Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 11-20-2017
Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: November 20, 2017 Subject: October 2017 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, the Ice Arena and Pinewood Golf Course Special Revenue Funds, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of October, actual revenues (except for property taxes and state aids) and expenditures should run about 83% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being below budget for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues: ■ Excluding transfers in,revenue collections are 62% of budget. The second-half property tax settlement will be received in early December. The third quarter gravel tax was received from the county in October. ■ Licenses and permits collections are 131% of annual budget estimates,with building- related permit collections at 139% and rental licenses at 139% as of the end of October. ■ Intergovernmental revenue collections consist of the third quarter state crime prevention grant. ■ Charges for services are 106% of budget estimates,with plan review fees and the Otsego fire contract making up the majority share. The second half payment of the school liaison contract is reflected in October collections. ■ Although fines and forfeits collections lag a month,reported collections through September are about 90% of budget estimates. p0WIeI1 0 NAWREJ Expenditures: ■ Total departmental expenditures are about 76% of budget and most departments are at or below budget estimates. 2017 Monthly Expenditures $16,000 $14,000 Ole o $12,000 Q $10,000 4A D _ $8,000 'h $6,000 $4,000 $2,000 0000 Actual $831 $1,896 $3,021 1 $4,018 1 $5,103 $6,568 1 $7,621 1 $8,761 1 $9,642 $10,867 Budget $1,198 $2,396 $3,595 1 $4,793 1 $5,991 1 $7,189 1 $8,387 1 $9,586 1$10,7841$11,9821$13,180$14,378 ICE ARENA As of the end of October, expenditures of$495,606 exceed revenues of$566,951 by$71,345. Ice rental revenues of$305,967 are about 57% of budget estimates. Overall,revenues and expenditures through October are in line with year-to-date budget estimates and prior year results. PINEWOOD GOLF Through the end of October, expenditures of$126,837 exceeded revenues of$90,836 by $36,001. The golf season ended on Sunday, October 8; however,there may be some additional costs associated with winterizing the ground and facilities. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds-Budget to Actual ■ Cash Report-All Funds ■ Pinewood Revenue&Expense-September& October 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND FINANCIAL SUMMARY 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 14,378,400.00 500,346.79 9,374,335.19 65.20 5,004,064.81 TOTAL REVENUES 14,378,400.00 500,346.79 9,374,335.19 65.20 5,004,064.81 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 148,800.00 5,868.10 100,523.45 67.56 48,276.55 Cable TV 111,300.00 7,640.22 77,378.64 69.52 33,921.36 Administrative Services 594,450.00 42,778.70 462,604.71 77.82 131,845.29 Human Resources 234,450.00 12,182.35 165,246.30 70.48 69,203.70 Elections 6,600.00 0.00 6,300.00 95.45 300.00 Finance 572,200.00 37,176.03 458,003.92 80.04 114,196.08 Information Technology 385,100.00 24,616.45 289,383.29 75.14 95,716.71 Legal 220,000.00 17,865.34 172,217.35 78.28 47,782.65 Community Development 223,400.00 17,914.56 176,587.35 79.05 46,812.65 Planning 297,450.00 25,216.21 234,822.35 78.95 62,627.65 City Hall Maintenance 638,850.00 47,968.03 488,977.23 76.54 149,872.77 TOTAL General Government 3,432,600.00 239,225.99 2,632,044.59 76.68 800,555.41 Public Safety Police Administration 762,900.00 44,741.06 553,609.02 72.57 209,290.98 Patrol 2,495,550.00 189,955.36 1,827,458.16 73.23 668,091.84 Investigations 1,029,350.00 71,311.79 728,974.46 70.82 300,375.54 Police Support Services 676,100.00 44,098.15 506,196.39 74.87 169,903.61 Police Reserves 21,450.00 835.07 8,496.28 39.61 12,953.72 Public safety building 156,900.00 15,583.79 119,617.04 76.24 37,282.96 Fire Administration 481,050.00 212,840.13 385,987.86 80.24 95,062.14 Fire Operations 400,200.00 32,433.19 333,716.13 83.39 66,483.87 Emergency Management 27,300.00 1,670.13 11,806.03 43.25 15,493.97 Building Safety 665,300.00 48,954.39 513,527.89 77.19 151,772.11 Code Enforcement 93,650.00 6,823.28 70,453.53 75.23 23,196.47 Environmental 47,000.00 2,640.77 23,588.21 50.19 23,411.79 TOTAL Public Safety 6,856,750.00 671,887.11 5,083,431.00 74.14 1,773,319.00 Public Works Street Maintenance 1,304,800.00 119,589.58 1,063,110.39 81.48 241,689.61 Snow Removal 305,950.00 75.93 124,275.32 40.62 181,674.68 Equipment Services 196,050.00 19,710.80 147,908.62 75.44 48,141.38 Engineering 218,500.00 17,026.21 178,361.22 81.63 40,138.78 TOTAL Public Works 2,025,300.00 156,402.52 1,513,655.55 74.74 511,644.45 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND FINANCIAL SUMMARY 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,047,950.00 88,426.04 820,148.34 78.26 227,801.66 Parks & Rec Admin 557,950.00 39,604.71 426,809.75 76.50 131,140.25 Recreation Programs 174,450.00 10,681.71 140,850.47 80.74 33,599.53 Sr Citizen Programs 249,600.00 17,437.38 199,911.53 80.09 49,688.47 TOTAL Culture & Recreation 2,029,950.00 156,149.84 1,587,720.09 78.21 442,229.91 Economic Development Economic Development 0.00 ( 271.10) 22,375.06 0.00 ( 22,375.06) Energy City 33,800.00 2,105.56 27,632.76 81.75 6,167.24 TOTAL Economic Development 33,800.00 1,834.46 50,007.82 147.95 ( 16,207.82) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 14,378,400.00 1,225,499.92 10,866,859.05 75.58 3,511,540.95 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 725,153.13)( 1,492,523.86) 1,492,523.86 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND 83.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,969,250.00 0.00 5,143,925.58 51.60 4,825,324.42 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 ( 14,682.23) 0.00 14,682.23 101-3-0000-3121 Gravel Tax 140,000.00 59,144.79 110,215.06 78.73 29,784.94 101-3-0000-3131 Penalties/Interest 0.00 0.00 5,370.92 0.00 ( 5,370.92) TOTAL Taxes 10,109,250.00 59,144.79 5,244,829.33 51.88 4,864,420.67 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 3,612.46 70,069.16 103.81 ( 2,569.16) 101-3-0000-3212 Amusement License 1,050.00 0.00 ( 465.00) 44.29- 1,515.00 101-3-0000-3213 Cigarette License 3,100.00 2,100.00 2,400.00 77.42 700.00 101-3-0000-3214 Rental License 45,000.00 2,915.00 62,334.00 138.52 ( 17,334.00) 101-3-0000-3216 Mining License 23,000.00 0.00 18,228.45 79.25 4,771.55 101-3-0000-3217 Garbage Hauler License 1,800.00 0.00 465.00 25.83 1,335.00 101-3-0000-3218 Other Business License/Permit 13,000.00 1,630.00 7,440.00 57.23 5,560.00 101-3-0000-3229 NPDES Permit 12,000.00 2,625.00 18,025.00 150.21 ( 6,025.00) 101-3-0000-3231 Building Permit 415,000.00 34,690.20 506,333.09 122.01 ( 91,333.09) 101-3-0000-3232 Plumbing/Heating Permit 118,000.00 13,477.08 235,731.76 199.77 ( 117,731.76) 101-3-0000-3233 Permit Surcharge 1,500.00 365.31 3,091.68 206.11 ( 1,591.68) 101-3-0000-3235 Animal License 6,000.00 140.00 2,600.00 43.33 3,400.00 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 10.00 13,150.00 164.38 ( 5,150.00) TOTAL Licenses & Permits 714,950.00 61,565.05 939,403.14 131.39 ( 224,453.14) Intergovernmental Rev 101-3-0000-3322 MV Credit 5,000.00 2,882.94 2,882.94 57.66 2,117.06 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 239,500.00 0.00 273,611.92 114.24 ( 34,111.92) 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 10,173.66 101.74 ( 173.66) 101-3-0000-3329 State Crime Prevention Grant 25,000.00 17,067.94 27,738.48 110.95 ( 2,738.48) TOTAL Intergovernmental Rev 293,500.00 19,950.88 321,399.00 109.51 ( 27,899.00) Charges for Services 101-3-0000-3412 Planning & Zoning Fees 30,000.00 5,987.50 30,834.70 102.78 ( 834.70) 101-3-0000-3413 Plan Check Fee 145,000.00 13,842.27 245,158.87 169.08 ( 100,158.87) 101-3-0000-3415 Special Assessment Search 500.00 100.00 1,000.00 200.00 ( 500.00) 101-3-0000-3417 Copies 1,700.00 223.70 2,427.00 142.76 ( 727.00) 101-3-0000-3418 Other General Govt Services 5,000.00 0.00 3,078.00 61.56 1,922.00 101-3-0000-3430 Lockout Fees 7,000.00 380.00 4,815.00 68.79 2,185.00 101-3-0000-3431 Police Services 8,000.00 4,801.25 13,242.25 165.53 ( 5,242.25) 101-3-0000-3432 School Liaison 123,600.00 61,812.00 123,624.00 100.02 ( 24.00) 101-3-0000-3434 Animal Impound Fee 3,000.00 375.00 3,800.00 126.67 ( 800.00) 101-3-0000-3436 Fire Contracts 234,000.00 0.00 252,362.00 107.85 ( 18,362.00) 101-3-0000-3437 Fire Services 2,000.00 10.70 257.35 12.87 1,742.65 101-3-0000-3438 Fire Inspections 5,000.00 0.00 0.00 0.00 5,000.00 101-3-0000-3450 Maintenance Facility Rent 13,800.00 0.00 5,782.50 41.90 8,017.50 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3451 Street Services 25,000.00 295.00 10,835.90 43.34 14,164.10 101-3-0000-3452 Engineering Services Reimb 125,000.00 33,538.57 115,845.81 92.68 9,154.19 101-3-0000-3461 Recreation Fees 96,000.00 2,474.50 62,287.08 64.88 33,712.92 101-3-0000-3462 Sr Center Activities 30,000.00 1,354.00 35,805.63 119.35 ( 5,805.63) 101-3-0000-3472 Park Use Fee 24,400.00 ( 1,389.94) 25,766.28 105.60 ( 1,366.28) 101-3-0000-3475 Building Rent 2,400.00 200.00 2,000.00 83.33 400.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 1,775.00 9,415.00 104.61 ( 415.00) 101-3-0000-3484 Contractor License Check 1,000.00 105.00 940.00 94.00 60.00 TOTAL Charges for Services 891,400.00 125,884.55 949,277.37 106.49 ( 57,877.37) Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 12,985.07 135,090.95 93.17 9,909.05 101-3-0000-3511 Parking Fines 10,000.00 400.00 4,920.00 49.20 5,080.00 101-3-0000-3512 Ordinance Violations 0.00 0.00 75.00 0.00 ( 75.00) TOTAL Fines & Forfeits 155,000.00 13,385.07 140,085.95 90.38 14,914.05 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 81,656.37 90.73 8,343.63 101-3-0000-3625 Refunds & Reimbursements 101,000.00 0.00 877.41 0.87 100,122.59 101-3-0000-3626 Contributions 20,000.00 0.00 16,000.00 80.00 4,000.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 190.93 4,196.05 64.55 2,303.95 TOTAL Other Revenue 217,500.00 190.93 102,729.83 47.23 114,770.17 Transfers In 101-3-0000-3921 Transfers 0.00 0.00 12,332.45 0.00 ( 12,332.45) 101-3-0000-3925 Transfer-Landfill 56,000.00 0.00 56,000.00 100.00 0.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 113,250.00 0.00 13,250.00 11.70 100,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 14,000.00 0.00 14,000.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 130,000.00 0.00 130,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 482,850.00 0.00 482,850.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 46,150.00 0.00 46,150.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 1,035,000.00 220,225.52 802,478.12 77.53 232,521.88 101-3-0000-3946 Transfer-Stormwater 15,000.00 0.00 15,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,996,800.00 220,225.52 1,676,610.57 83.96 320,189.43 _____________________________________________________________________________ TOTAL General Fund 14,378,400.00 500,346.79 9,374,335.19 65.20 5,004,064.81 ___________________________________________________________________________________________________________________ TOTAL REVENUE 14,378,400.00 500,346.79 9,374,335.19 65.20 5,004,064.81 ============= ============= ============= ======= ============= 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,208.32 32,083.20 83.33 6,416.80 101-4-1110-4104 PERA 1,900.00 102.09 1,065.90 56.10 834.10 101-4-1110-4105 FICA 2,400.00 72.32 760.52 31.69 1,639.48 101-4-1110-4107 Medicare 550.00 46.53 482.71 87.77 67.29 101-4-1110-4109 Workers Comp 100.00 0.00 33.75 33.75 66.25 TOTAL Personal Services 43,450.00 3,429.26 34,426.08 79.23 9,023.92 Supplies 101-4-1110-4201 Office Supplies 800.00 3.44 366.84 45.86 433.16 TOTAL Supplies 800.00 3.44 366.84 45.86 433.16 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 0.00 3,725.84 35.83 6,674.16 101-4-1110-4322 Postage 50.00 0.00 33.85 67.70 16.15 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 628.61 1,226.10 47.16 1,373.90 101-4-1110-4359 Publishing 3,700.00 0.00 653.40 17.66 3,046.60 101-4-1110-4361 Insurance 40,800.00 0.00 38,215.00 93.66 2,585.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 30.00 30.00 0.15 19,520.00 101-4-1110-4440 Miscellaneous 27,450.00 1,776.79 21,846.34 79.59 5,603.66 TOTAL Other Services & Charges 104,550.00 2,435.40 65,730.53 62.87 38,819.47 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 148,800.00 5,868.10 100,523.45 67.56 48,276.55 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 65,000.00 4,996.80 51,217.21 78.80 13,782.79 101-4-1120-4102 Overtime Pay 0.00 0.00 140.53 0.00 ( 140.53) 101-4-1120-4103 Part-time Pay 18,400.00 873.76 6,841.65 37.18 11,558.35 101-4-1120-4104 PERA 6,800.00 440.29 4,361.45 64.14 2,438.55 101-4-1120-4105 FICA 5,200.00 333.45 3,411.75 65.61 1,788.25 101-4-1120-4107 Medicare 1,200.00 77.98 797.90 66.49 402.10 101-4-1120-4108 Insurance 11,350.00 914.50 8,001.00 70.49 3,349.00 101-4-1120-4109 Workers Comp 400.00 0.00 200.25 50.06 199.75 TOTAL Personal Services 108,350.00 7,636.78 74,971.74 69.19 33,378.26 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.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 2,000.00 3.44 1,604.20 80.21 395.80 TOTAL Supplies 2,000.00 3.44 1,604.20 80.21 395.80 Other Services & Charges 101-4-1120-4331 Travel, Conferences & Schools 950.00 0.00 802.70 84.49 147.30 TOTAL Other Services & Charges 950.00 0.00 802.70 84.49 147.30 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 111,300.00 7,640.22 77,378.64 69.52 33,921.36 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 398,500.00 30,650.92 314,365.37 78.89 84,134.63 101-4-1210-4102 Overtime Pay 0.00 ( 170.25)( 101.10) 0.00 101.10 101-4-1210-4103 Part-time Pay 47,200.00 3,404.79 35,085.81 74.33 12,114.19 101-4-1210-4104 PERA 33,450.00 2,541.42 26,201.45 78.33 7,248.55 101-4-1210-4105 FICA 27,650.00 2,144.20 22,104.85 79.95 5,545.15 101-4-1210-4107 Medicare 6,450.00 501.47 5,169.67 80.15 1,280.33 101-4-1210-4108 Insurance 26,650.00 2,250.50 23,060.20 86.53 3,589.80 101-4-1210-4109 Workers Comp 2,100.00 0.00 1,421.25 67.68 678.75 TOTAL Personal Services 542,000.00 41,323.05 427,307.50 78.84 114,692.50 Supplies 101-4-1210-4201 Office Supplies 7,300.00 168.86 2,840.99 38.92 4,459.01 TOTAL Supplies 7,300.00 168.86 2,840.99 38.92 4,459.01 Other Services & Charges 101-4-1210-4319 Other Professional Services 13,000.00 251.88 8,537.94 65.68 4,462.06 101-4-1210-4321 Telephone 1,650.00 163.32 1,810.11 109.70 ( 160.11) 101-4-1210-4322 Postage 0.00 0.00 554.13 0.00 ( 554.13) 101-4-1210-4331 Travel, Conferences & Schools 7,750.00 0.00 2,366.50 30.54 5,383.50 101-4-1210-4334 Car Allowance 4,800.00 400.00 4,000.00 83.33 800.00 101-4-1210-4361 Insurance 100.00 0.00 58.00 58.00 42.00 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 459.63 12,931.84 86.50 2,018.16 101-4-1210-4433 Dues & Subscriptions 2,900.00 11.96 2,197.70 75.78 702.30 TOTAL Other Services & Charges 45,150.00 1,286.79 32,456.22 71.89 12,693.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 594,450.00 42,778.70 462,604.71 77.82 131,845.29 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.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 127,050.00 9,248.86 81,718.44 64.32 45,331.56 101-4-1220-4102 Overtime Pay 0.00 0.00 474.58 0.00 ( 474.58) 101-4-1220-4103 Part-time Pay 0.00 0.00 5,008.35 0.00 ( 5,008.35) 101-4-1220-4104 PERA 9,550.00 693.66 6,377.08 66.78 3,172.92 101-4-1220-4105 FICA 7,900.00 560.96 5,265.49 66.65 2,634.51 101-4-1220-4107 Medicare 1,850.00 131.19 1,231.44 66.56 618.56 101-4-1220-4108 Insurance 15,850.00 1,337.00 10,982.00 69.29 4,868.00 101-4-1220-4109 Workers Comp 600.00 0.00 405.00 67.50 195.00 TOTAL Personal Services 162,800.00 11,971.67 111,462.38 68.47 51,337.62 Supplies 101-4-1220-4201 Office Supplies 1,200.00 101.29 914.01 76.17 285.99 TOTAL Supplies 1,200.00 101.29 914.01 76.17 285.99 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 360.00 1,728.30 138.26 ( 478.30) 101-4-1220-4322 Postage 600.00 0.00 219.60 36.60 380.40 101-4-1220-4331 Travel, Conferences & Schools 7,200.00 ( 250.61) 998.21 13.86 6,201.79 101-4-1220-4404 Equip Repair/Maint 60,600.00 0.00 49,097.00 81.02 11,503.00 101-4-1220-4433 Dues & Subscriptions 800.00 0.00 826.80 103.35 ( 26.80) TOTAL Other Services & Charges 70,450.00 109.39 52,869.91 75.05 17,580.09 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 234,450.00 12,182.35 165,246.30 70.48 69,203.70 Elections ========= Personal Services _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1230-4404 Equip Repair/Maint Services 6,600.00 0.00 6,300.00 95.45 300.00 TOTAL Other Services & Charges 6,600.00 0.00 6,300.00 95.45 300.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 6,600.00 0.00 6,300.00 95.45 300.00 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Finance ======= Personal Services 101-4-1310-4101 Regular Pay 303,000.00 23,601.52 238,193.46 78.61 64,806.54 101-4-1310-4103 Part-time Pay 54,700.00 3,997.44 42,549.30 77.79 12,150.70 101-4-1310-4104 PERA 26,850.00 2,069.90 21,055.54 78.42 5,794.46 101-4-1310-4105 FICA 22,200.00 1,624.97 16,853.19 75.92 5,346.81 101-4-1310-4107 Medicare 5,200.00 380.03 3,941.47 75.80 1,258.53 101-4-1310-4108 Insurance 40,600.00 3,377.70 31,207.50 76.87 9,392.50 101-4-1310-4109 Workers Comp 1,700.00 0.00 1,140.75 67.10 559.25 TOTAL Personal Services 454,250.00 35,051.56 354,941.21 78.14 99,308.79 Supplies 101-4-1310-4201 Office Supplies 5,000.00 1,517.18 2,237.18 44.74 2,762.82 TOTAL Supplies 5,000.00 1,517.18 2,237.18 44.74 2,762.82 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 0.00 17,275.00 86.38 2,725.00 101-4-1310-4319 Other Professional Services 56,500.00 0.00 55,456.00 98.15 1,044.00 101-4-1310-4321 Telephone 1,350.00 39.99 359.91 26.66 990.09 101-4-1310-4322 Postage 2,800.00 0.00 1,931.11 68.97 868.89 101-4-1310-4331 Travel, Conferences & Schools 3,900.00 75.00 777.26 19.93 3,122.74 101-4-1310-4359 Publishing 450.00 0.00 152.00 33.78 298.00 101-4-1310-4404 Equip Repair/Maint Services 19,050.00 0.00 16,315.26 85.64 2,734.74 101-4-1310-4433 Dues & Subscriptions 1,600.00 0.00 1,494.00 93.38 106.00 101-4-1310-4438 Credit Card Fees 5,800.00 585.20 6,298.89 108.60 ( 498.89) 101-4-1310-4440 Miscellaneous 1,500.00 ( 92.90) 766.10 51.07 733.90 TOTAL Other Services & Charges 112,950.00 607.29 100,825.53 89.27 12,124.47 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 572,200.00 37,176.03 458,003.92 80.04 114,196.08 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 196,400.00 10,630.62 135,053.22 68.76 61,346.78 101-4-1350-4104 PERA 14,750.00 797.30 9,637.65 65.34 5,112.35 101-4-1350-4105 FICA 12,200.00 578.14 7,547.84 61.87 4,652.16 101-4-1350-4107 Medicare 2,850.00 135.22 1,765.61 61.95 1,084.39 101-4-1350-4108 Insurance 34,400.00 1,623.00 22,567.50 65.60 11,832.50 101-4-1350-4109 Workers Comp 950.00 0.00 626.25 65.92 323.75 TOTAL Personal Services 261,550.00 13,764.28 177,198.07 67.75 84,351.93 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1350-4219 Operating Supplies 20,100.00 366.35 14,766.00 73.46 5,334.00 TOTAL Supplies 20,100.00 366.35 14,766.00 73.46 5,334.00 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 5,848.25 9,421.75 117.77 ( 1,421.75) 101-4-1350-4321 Telephone 2,800.00 115.18 1,611.45 57.55 1,188.55 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 165.00 11,580.41 90.83 1,169.59 101-4-1350-4404 Equip Repair/Maint Services 79,900.00 4,357.39 74,805.61 93.62 5,094.39 TOTAL Other Services & Charges 103,450.00 10,485.82 97,419.22 94.17 6,030.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 385,100.00 24,616.45 289,383.29 75.14 95,716.71 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 220,000.00 17,865.34 172,217.35 78.28 47,782.65 TOTAL Other Services & Charges 220,000.00 17,865.34 172,217.35 78.28 47,782.65 ___________________________________________________________________________________________________________________ TOTAL Legal 220,000.00 17,865.34 172,217.35 78.28 47,782.65 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 175,100.00 13,512.66 138,322.03 79.00 36,777.97 101-4-1500-4102 Overtime Pay 0.00 0.00 215.02 0.00 ( 215.02) 101-4-1500-4104 PERA 13,150.00 1,013.45 10,390.24 79.01 2,759.76 101-4-1500-4105 FICA 10,850.00 782.81 8,150.41 75.12 2,699.59 101-4-1500-4107 Medicare 2,550.00 183.07 1,906.14 74.75 643.86 101-4-1500-4108 Insurance 15,850.00 1,623.00 14,514.00 91.57 1,336.00 101-4-1500-4109 Workers Comp 850.00 0.00 558.00 65.65 292.00 TOTAL Personal Services 218,350.00 17,114.99 174,055.84 79.71 44,294.16 Supplies 101-4-1500-4201 Office Supplies 1,100.00 674.58 907.08 82.46 192.92 TOTAL Supplies 1,100.00 674.58 907.08 82.46 192.92 Other Services & Charges 101-4-1500-4321 Telephone 800.00 124.99 634.91 79.36 165.09 101-4-1500-4331 Travel, Conferences & Schools 2,600.00 0.00 124.02 4.77 2,475.98 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 865.50 157.36 ( 315.50) TOTAL Other Services & Charges 3,950.00 124.99 1,624.43 41.12 2,325.57 ___________________________________________________________________________________________________________________ TOTAL Community Development 223,400.00 17,914.56 176,587.35 79.05 46,812.65 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Planning ======== Personal Services 101-4-1510-4101 Regular Pay 217,700.00 17,001.85 170,131.73 78.15 47,568.27 101-4-1510-4104 PERA 16,350.00 1,275.12 12,759.80 78.04 3,590.20 101-4-1510-4105 FICA 13,500.00 967.19 9,700.60 71.86 3,799.40 101-4-1510-4107 Medicare 3,150.00 226.20 2,268.69 72.02 881.31 101-4-1510-4108 Insurance 26,600.00 2,240.50 22,405.00 84.23 4,195.00 101-4-1510-4109 Workers Comp 1,100.00 0.00 522.75 47.52 577.25 TOTAL Personal Services 278,400.00 21,710.86 217,788.57 78.23 60,611.43 Supplies 101-4-1510-4201 Office Supplies 1,500.00 343.56 1,600.47 106.70 ( 100.47) 101-4-1510-4212 Fuels & Lubes 300.00 4.04 30.62 10.21 269.38 101-4-1510-4219 Operating Supplies 1,900.00 650.48 2,024.48 106.55 ( 124.48) TOTAL Supplies 3,700.00 998.08 3,655.57 98.80 44.43 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-1510-4322 Postage 1,200.00 0.00 892.99 74.42 307.01 101-4-1510-4331 Travel, Conferences & Schools 2,950.00 1,367.27 2,373.27 80.45 576.73 101-4-1510-4359 Publishing 8,000.00 1,120.00 7,856.00 98.20 144.00 101-4-1510-4361 Insurance 100.00 0.00 58.00 58.00 42.00 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 1,000.00 20.00 878.00 87.80 122.00 101-4-1510-4440 Miscellaneous 250.00 0.00 239.95 95.98 10.05 TOTAL Other Services & Charges 15,350.00 2,507.27 13,378.21 87.15 1,971.79 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,450.00 25,216.21 234,822.35 78.95 62,627.65 City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 354,300.00 27,555.00 280,516.91 79.17 73,783.09 101-4-1600-4102 Overtime Pay 3,500.00 0.00 289.90 8.28 3,210.10 101-4-1600-4103 Part-time Pay 3,550.00 655.68 4,098.00 115.44 ( 548.00) 101-4-1600-4104 PERA 26,850.00 2,066.62 21,079.95 78.51 5,770.05 101-4-1600-4105 FICA 22,400.00 1,744.76 17,716.58 79.09 4,683.42 101-4-1600-4107 Medicare 5,250.00 408.05 4,143.39 78.92 1,106.61 101-4-1600-4108 Insurance 50,300.00 4,157.50 41,575.00 82.65 8,725.00 101-4-1600-4109 Workers Comp 12,450.00 0.00 8,257.50 66.33 4,192.50 TOTAL Personal Services 478,600.00 36,587.61 377,677.23 78.91 100,922.77 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND General Government 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 235.15 1,557.14 51.90 1,442.86 101-4-1600-4217 Uniform Allowance 2,400.00 0.00 762.61 31.78 1,637.39 101-4-1600-4219 Operating Supplies 33,500.00 2,822.68 16,908.21 50.47 16,591.79 TOTAL Supplies 38,900.00 3,057.83 19,227.96 49.43 19,672.04 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 239.66 10,755.70 91.93 944.30 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 399.00 847.03 42.35 1,152.97 101-4-1600-4361 Insurance 5,150.00 0.00 4,992.50 96.94 157.50 101-4-1600-4389 Utilities 65,250.00 6,473.02 53,368.35 81.79 11,881.65 101-4-1600-4401 Bldg Repair/Maint Services 30,800.00 965.08 17,268.76 56.07 13,531.24 101-4-1600-4404 Equip Repair/Maint Services 3,500.00 0.00 2,381.40 68.04 1,118.60 101-4-1600-4460 Equip Replacement Charge 2,950.00 245.83 2,458.30 83.33 491.70 TOTAL Other Services & Charges 121,350.00 8,322.59 92,072.04 75.87 29,277.96 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 638,850.00 47,968.03 488,977.23 76.54 149,872.77 Contingency =========== Personal Services _____________ _____________ _____________ _______ _____________ Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,432,600.00 239,225.99 2,632,044.59 76.68 800,555.41 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 372,800.00 27,640.50 262,219.45 70.34 110,580.55 101-4-2110-4102 Overtime Pay 2,500.00 1,189.62 1,189.62 47.58 1,310.38 101-4-2110-4104 PERA 55,100.00 4,351.28 41,243.99 74.85 13,856.01 101-4-2110-4105 FICA 3,800.00 246.07 1,098.00 28.89 2,702.00 101-4-2110-4107 Medicare 5,400.00 412.63 3,700.79 68.53 1,699.21 101-4-2110-4108 Insurance 34,250.00 2,192.00 20,093.00 58.67 14,157.00 101-4-2110-4109 Workers Comp 66,500.00 0.00 55,974.75 84.17 10,525.25 TOTAL Personal Services 540,350.00 36,032.10 385,519.60 71.35 154,830.40 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2110-4201 Office Supplies 11,000.00 826.18 7,404.01 67.31 3,595.99 101-4-2110-4217 Uniform Allowance 3,000.00 863.40 2,501.11 83.37 498.89 101-4-2110-4219 Operating Supplies 23,500.00 197.65 10,102.77 42.99 13,397.23 TOTAL Supplies 37,500.00 1,887.23 20,007.89 53.35 17,492.11 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 171.59 6,711.39 84.95 1,188.61 101-4-2110-4321 Telephone 34,700.00 2,012.16 21,926.62 63.19 12,773.38 101-4-2110-4322 Postage 2,400.00 0.00 1,068.87 44.54 1,331.13 101-4-2110-4331 Travel, Conferences & Schools 14,800.00 568.98 7,881.98 53.26 6,918.02 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 42,000.00 0.00 40,511.00 96.45 1,489.00 101-4-2110-4404 Equip Repair/Maint Services 68,950.00 3,650.00 58,006.67 84.13 10,943.33 101-4-2110-4433 Dues & Subscriptions 13,600.00 408.00 11,843.00 87.08 1,757.00 101-4-2110-4437 Taxes & Licenses 200.00 11.00 132.00 66.00 68.00 TOTAL Other Services & Charges 185,050.00 6,821.73 148,081.53 80.02 36,968.47 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 762,900.00 44,741.06 553,609.02 72.57 209,290.98 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,612,400.00 122,539.31 1,218,505.10 75.57 393,894.90 101-4-2120-4102 Overtime Pay 100,000.00 5,303.92 53,312.48 53.31 46,687.52 101-4-2120-4104 PERA 277,400.00 20,710.59 206,026.28 74.27 71,373.72 101-4-2120-4107 Medicare 24,850.00 1,798.18 17,908.27 72.07 6,941.73 101-4-2120-4108 Insurance 174,100.00 13,353.50 127,787.00 73.40 46,313.00 TOTAL Personal Services 2,188,750.00 163,705.50 1,623,539.13 74.18 565,210.87 Supplies 101-4-2120-4212 Fuels & Lubes 78,000.00 6,420.28 59,822.48 76.70 18,177.52 101-4-2120-4217 Uniform Allowance 35,600.00 4,246.81 11,585.82 32.54 24,014.18 101-4-2120-4219 Operating Supplies 73,900.00 7,931.46 37,647.62 50.94 36,252.38 101-4-2120-4221 Equipment Parts 23,300.00 1,701.71 16,481.48 70.74 6,818.52 TOTAL Supplies 210,800.00 20,300.26 125,537.40 59.55 85,262.60 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 27,050.00 1,991.27 20,393.81 75.39 6,656.19 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 0.00 18,144.52 87.23 2,655.48 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 260.00 40.00 390.00 101-4-2120-4460 Equip Replacement Charge 47,500.00 3,958.33 39,583.30 83.33 7,916.70 TOTAL Other Services & Charges 96,000.00 5,949.60 78,381.63 81.65 17,618.37 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,495,550.00 189,955.36 1,827,458.16 73.23 668,091.84 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 696,700.00 49,851.20 515,466.81 73.99 181,233.19 101-4-2130-4102 Overtime Pay 55,000.00 2,369.93 25,106.97 45.65 29,893.03 101-4-2130-4104 PERA 121,800.00 8,459.85 87,572.84 71.90 34,227.16 101-4-2130-4107 Medicare 9,550.00 715.12 7,441.85 77.93 2,108.15 101-4-2130-4108 Insurance 93,950.00 6,273.88 62,738.80 66.78 31,211.20 TOTAL Personal Services 977,000.00 67,669.98 698,327.27 71.48 278,672.73 Supplies 101-4-2130-4217 Uniform Allowance 6,950.00 1,059.12 4,168.51 59.98 2,781.49 101-4-2130-4219 Operating Supplies 10,600.00 652.00 7,042.68 66.44 3,557.32 TOTAL Supplies 17,550.00 1,711.12 11,211.19 63.88 6,338.81 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 19.00 1,221.00 16.28 6,279.00 101-4-2130-4331 Travel, Conferences & Schools 11,200.00 545.00 5,314.78 47.45 5,885.22 101-4-2130-4433 Dues & Subscriptions 2,100.00 200.02 1,233.52 58.74 866.48 101-4-2130-4460 Equip Replacement Charge 14,000.00 1,166.67 11,666.70 83.33 2,333.30 TOTAL Other Services & Charges 34,800.00 1,930.69 19,436.00 55.85 15,364.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,029,350.00 71,311.79 728,974.46 70.82 300,375.54 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 437,350.00 27,067.59 331,490.60 75.80 105,859.40 101-4-2150-4102 Overtime Pay 7,500.00 27.38 10,569.21 140.92 ( 3,069.21) 101-4-2150-4103 Part-time Pay 40,500.00 3,034.16 31,179.18 76.99 9,320.82 101-4-2150-4104 PERA 44,700.00 2,259.69 28,713.53 64.24 15,986.47 101-4-2150-4105 FICA 24,200.00 1,785.78 18,467.67 76.31 5,732.33 101-4-2150-4107 Medicare 5,650.00 417.63 4,319.02 76.44 1,330.98 101-4-2150-4108 Insurance 72,200.00 5,756.25 56,944.25 78.87 15,255.75 TOTAL Personal Services 632,100.00 40,348.48 481,683.46 76.20 150,416.54 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 136.27 13.63 863.73 101-4-2150-4217 Uniform Allowance 5,350.00 487.20 2,540.12 47.48 2,809.88 101-4-2150-4219 Operating Supplies 14,600.00 1,763.22 8,229.77 56.37 6,370.23 TOTAL Supplies 20,950.00 2,250.42 10,906.16 52.06 10,043.84 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,900.00 0.00 2,244.05 32.52 4,655.95 101-4-2150-4404 Equip Repair/Maint Services 2,300.00 0.00 1,353.22 58.84 946.78 101-4-2150-4409 Contractual Services 7,000.00 974.25 4,524.50 64.64 2,475.50 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 235.00 42.73 315.00 101-4-2150-4460 Equip Replacement Charge 6,300.00 525.00 5,250.00 83.33 1,050.00 TOTAL Other Services & Charges 23,050.00 1,499.25 13,606.77 59.03 9,443.23 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 676,100.00 44,098.15 506,196.39 74.87 169,903.61 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 241.60 1,472.27 26.77 4,027.73 101-4-2160-4105 FICA 350.00 14.97 91.27 26.08 258.73 101-4-2160-4107 Medicare 100.00 3.50 21.36 21.36 78.64 TOTAL Personal Services 5,950.00 260.07 1,584.90 26.64 4,365.10 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 0.00 4,207.66 76.50 1,292.34 101-4-2160-4219 Operating Supplies 4,700.00 0.00 128.72 2.74 4,571.28 TOTAL Supplies 10,200.00 0.00 4,336.38 42.51 5,863.62 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 575.00 1,725.00 82.14 375.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 575.00 2,575.00 48.58 2,725.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 21,450.00 835.07 8,496.28 39.61 12,953.72 Public safety building ====================== 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 18,100.00 5,434.83 21,881.96 120.89 ( 3,781.96) TOTAL Supplies 18,100.00 5,434.83 21,881.96 120.89 ( 3,781.96) Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 0.00 4,852.00 93.31 348.00 101-4-2190-4389 Utilities 95,500.00 8,445.74 68,349.54 71.57 27,150.46 101-4-2190-4401 Bldg Repair/Maint Services 38,100.00 1,703.22 24,533.54 64.39 13,566.46 TOTAL Other Services & Charges 138,800.00 10,148.96 97,735.08 70.41 41,064.92 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,900.00 15,583.79 119,617.04 76.24 37,282.96 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 246,050.00 19,188.15 193,390.32 78.60 52,659.68 101-4-2310-4104 PERA 36,150.00 2,812.00 28,422.49 78.62 7,727.51 101-4-2310-4105 FICA 2,650.00 229.90 2,252.89 85.01 397.11 101-4-2310-4106 Other Retirement Contributions 30,000.00 181,297.16 30,000.00 100.00 0.00 101-4-2310-4107 Medicare 3,550.00 266.25 2,687.41 75.70 862.59 101-4-2310-4108 Insurance 30,950.00 2,360.99 24,176.02 78.11 6,773.98 101-4-2310-4109 Workers Comp 9,650.00 0.00 7,876.50 81.62 1,773.50 101-4-2310-4110 Re-employment Compensation 0.00 0.00 233.48 0.00 ( 233.48) TOTAL Personal Services 359,000.00 206,154.45 289,039.11 80.51 69,960.89 Supplies 101-4-2310-4201 Office Supplies 2,950.00 28.22 1,014.87 34.40 1,935.13 101-4-2310-4212 Fuels & Lubes 3,900.00 276.57 3,032.50 77.76 867.50 101-4-2310-4217 Uniform Allowance 3,500.00 0.00 1,063.92 30.40 2,436.08 101-4-2310-4219 Operating Supplies 1,200.00 99.41 1,502.59 125.22 ( 302.59) 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 12,050.00 404.20 6,613.88 54.89 5,436.12 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,000.00 0.00 90.00 1.80 4,910.00 101-4-2310-4321 Telephone 2,750.00 135.87 2,260.78 82.21 489.22 101-4-2310-4322 Postage 650.00 0.00 500.58 77.01 149.42 101-4-2310-4331 Travel, Conferences & Schools 4,250.00 0.00 4,944.02 116.33 ( 694.02) 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 9,800.00 0.00 8,582.50 87.58 1,217.50 101-4-2310-4389 Utilities 17,750.00 1,243.43 14,690.64 82.76 3,059.36 101-4-2310-4401 Bldg Repair/Maint Services 7,500.00 136.85 8,814.05 117.52 ( 1,314.05) 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 0.00 1,305.00 44.24 1,645.00 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-2310-4433 Dues & Subscriptions 2,100.00 57.00 2,064.00 98.29 36.00 101-4-2310-4460 Equip Replacement Charge 56,500.00 4,708.33 47,083.30 83.33 9,416.70 TOTAL Other Services & Charges 110,000.00 6,281.48 90,334.87 82.12 19,665.13 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 481,050.00 212,840.13 385,987.86 80.24 95,062.14 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 15,509.91 142,634.71 75.59 46,065.29 101-4-2320-4105 FICA 11,700.00 910.06 8,535.43 72.95 3,164.57 101-4-2320-4107 Medicare 2,750.00 219.41 2,042.72 74.28 707.28 101-4-2320-4109 Workers Comp 29,000.00 0.00 26,960.25 92.97 2,039.75 TOTAL Personal Services 232,150.00 16,639.38 180,173.11 77.61 51,976.89 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 75.30 25.10 224.70 101-4-2320-4212 Fuels & Lubes 7,200.00 704.00 4,572.43 63.51 2,627.57 101-4-2320-4217 Uniform Allowance 8,600.00 2,060.35 5,496.60 63.91 3,103.40 101-4-2320-4219 Operating Supplies 76,950.00 11,169.07 76,111.14 98.91 838.86 101-4-2320-4221 Equipment Parts 9,400.00 224.42 10,269.67 109.25 ( 869.67) TOTAL Supplies 102,450.00 14,157.84 96,525.14 94.22 5,924.86 Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 339.91 3,232.33 73.46 1,167.67 101-4-2320-4331 Travel, Conferences & Schools 19,700.00 ( 20.00) 11,514.12 58.45 8,185.88 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 1,316.06 33,839.75 96.14 1,360.25 101-4-2320-4409 Contractual Services 6,300.00 0.00 8,431.68 133.84 ( 2,131.68) TOTAL Other Services & Charges 65,600.00 1,635.97 57,017.88 86.92 8,582.12 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 400,200.00 32,433.19 333,716.13 83.39 66,483.87 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4201 Office Supplies 0.00 35.25 35.25 0.00 ( 35.25) 101-4-2330-4219 Operating Supplies 7,200.00 652.43 4,816.21 66.89 2,383.79 TOTAL Supplies 7,200.00 687.68 4,851.46 67.38 2,348.54 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2330-4331 Travel, Conferences & Schools 10,400.00 0.00 602.00 5.79 9,798.00 101-4-2330-4389 Utilities 4,500.00 432.45 3,772.67 83.84 727.33 101-4-2330-4404 Equip Repair/Maint Services 4,950.00 550.00 2,319.90 46.87 2,630.10 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 260.00 104.00 ( 10.00) TOTAL Other Services & Charges 20,100.00 982.45 6,954.57 34.60 13,145.43 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,300.00 1,670.13 11,806.03 43.25 15,493.97 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 465,650.00 35,289.05 359,858.21 77.28 105,791.79 101-4-2410-4102 Overtime Pay 0.00 12.76 86.97 0.00 ( 86.97) 101-4-2410-4103 Part-time Pay 0.00 0.00 5,246.46 0.00 ( 5,246.46) 101-4-2410-4104 PERA 41,600.00 3,151.93 32,392.02 77.87 9,207.98 101-4-2410-4105 FICA 24,100.00 1,633.48 17,084.49 70.89 7,015.51 101-4-2410-4107 Medicare 6,750.00 454.56 4,763.47 70.57 1,986.53 101-4-2410-4108 Insurance 83,500.00 6,735.50 68,920.00 82.54 14,580.00 101-4-2410-4109 Workers Comp 2,250.00 0.00 1,192.50 53.00 1,057.50 TOTAL Personal Services 623,850.00 47,277.28 489,544.12 78.47 134,305.88 Supplies 101-4-2410-4201 Office Supplies 3,000.00 205.07 1,169.67 38.99 1,830.33 101-4-2410-4212 Fuels & Lubes 6,000.00 549.33 4,676.70 77.95 1,323.30 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 14.35 0.82 1,735.65 101-4-2410-4219 Operating Supplies 9,650.00 192.99 4,370.61 45.29 5,279.39 TOTAL Supplies 20,400.00 947.39 10,231.33 50.15 10,168.67 Other Services & Charges 101-4-2410-4321 Telephone 5,350.00 439.69 3,417.46 63.88 1,932.54 101-4-2410-4322 Postage 700.00 0.00 189.22 27.03 510.78 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 6.70 1,568.80 37.80 2,581.20 101-4-2410-4361 Insurance 450.00 0.00 496.00 110.22 ( 46.00) 101-4-2410-4404 Equip Repair/Maint Services 5,000.00 0.00 3,547.16 70.94 1,452.84 101-4-2410-4433 Dues & Subscriptions 2,000.00 0.00 1,700.50 85.03 299.50 101-4-2410-4460 Equip Replacement Charge 3,400.00 283.33 2,833.30 83.33 566.70 TOTAL Other Services & Charges 21,050.00 729.72 13,752.44 65.33 7,297.56 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 665,300.00 48,954.39 513,527.89 77.19 151,772.11 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 72,050.00 5,542.40 56,809.60 78.85 15,240.40 101-4-2420-4104 PERA 5,400.00 415.68 4,260.72 78.90 1,139.28 101-4-2420-4105 FICA 4,500.00 355.87 3,641.57 80.92 858.43 101-4-2420-4107 Medicare 1,050.00 83.22 851.65 81.11 198.35 101-4-2420-4108 Insurance 3,600.00 304.50 3,045.00 84.58 555.00 101-4-2420-4109 Workers Comp 350.00 0.00 173.25 49.50 176.75 TOTAL Personal Services 86,950.00 6,701.67 68,781.79 79.10 18,168.21 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 100.90 887.66 44.38 1,112.34 101-4-2420-4217 Uniform Allowance 350.00 0.00 0.00 0.00 350.00 101-4-2420-4219 Operating Supplies 950.00 0.00 0.00 0.00 950.00 TOTAL Supplies 3,300.00 100.90 887.66 26.90 2,412.34 Other Services & Charges 101-4-2420-4321 Telephone 850.00 20.71 235.71 27.73 614.29 101-4-2420-4322 Postage 1,750.00 0.00 465.87 26.62 1,284.13 101-4-2420-4331 Travel, Conferences & Schools 700.00 0.00 0.00 0.00 700.00 101-4-2420-4361 Insurance 100.00 0.00 82.50 82.50 17.50 TOTAL Other Services & Charges 3,400.00 20.71 784.08 23.06 2,615.92 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 93,650.00 6,823.28 70,453.53 75.23 23,196.47 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 19,150.00 1,330.28 13,042.24 68.11 6,107.76 101-4-2440-4104 PERA 1,450.00 99.77 855.66 59.01 594.34 101-4-2440-4105 FICA 1,200.00 82.66 815.62 67.97 384.38 101-4-2440-4107 Medicare 300.00 19.32 190.63 63.54 109.37 101-4-2440-4108 Insurance 2,400.00 188.54 1,520.38 63.35 879.62 101-4-2440-4109 Workers Comp 300.00 0.00 159.00 53.00 141.00 TOTAL Personal Services 24,800.00 1,720.57 16,583.53 66.87 8,216.47 Supplies 101-4-2440-4201 Office Supplies 1,500.00 3.44 1,666.89 111.13 ( 166.89) 101-4-2440-4212 Fuels & Lubes 300.00 3.76 86.41 28.80 213.59 101-4-2440-4219 Operating Supplies 5,000.00 0.00 738.27 14.77 4,261.73 TOTAL Supplies 6,800.00 7.20 2,491.57 36.64 4,308.43 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2440-4321 Telephone 850.00 0.00 90.00 10.59 760.00 101-4-2440-4322 Postage 1,000.00 0.00 15.11 1.51 984.89 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 80.00 1,115.00 79.64 285.00 101-4-2440-4359 Publishing 1,000.00 56.00 56.00 5.60 944.00 101-4-2440-4409 Contractual Services 11,000.00 777.00 3,237.00 29.43 7,763.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 15,400.00 913.00 4,513.11 29.31 10,886.89 ___________________________________________________________________________________________________________________ TOTAL Environmental 47,000.00 2,640.77 23,588.21 50.19 23,411.79 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,856,750.00 671,887.11 5,083,431.00 74.14 1,773,319.00 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 502,550.00 44,393.30 431,812.25 85.92 70,737.75 101-4-3120-4102 Overtime Pay 4,000.00 294.96 1,563.08 39.08 2,436.92 101-4-3120-4103 Part-time Pay 81,400.00 5,084.80 67,484.28 82.90 13,915.72 101-4-3120-4104 PERA 42,450.00 3,732.97 36,001.38 84.81 6,448.62 101-4-3120-4105 FICA 36,450.00 2,960.25 30,075.61 82.51 6,374.39 101-4-3120-4107 Medicare 8,550.00 692.30 7,033.81 82.27 1,516.19 101-4-3120-4108 Insurance 79,650.00 6,741.26 62,713.60 78.74 16,936.40 101-4-3120-4109 Workers Comp 30,900.00 0.00 22,481.25 72.75 8,418.75 101-4-3120-4110 Re-employment Compensation 0.00 0.00 1,471.68 0.00 ( 1,471.68) TOTAL Personal Services 785,950.00 63,899.84 660,636.94 84.06 125,313.06 Supplies 101-4-3120-4201 Office Supplies 1,500.00 3.44 1,351.49 90.10 148.51 101-4-3120-4212 Fuels & Lubes 45,000.00 ( 15,734.35) 24,305.10 54.01 20,694.90 101-4-3120-4219 Operating Supplies 56,500.00 3,552.13 40,825.27 72.26 15,674.73 101-4-3120-4221 Equipment Parts 52,000.00 6,024.45 37,224.91 71.59 14,775.09 101-4-3120-4226 Street Signs 31,500.00 537.37 26,034.62 82.65 5,465.38 TOTAL Supplies 186,500.00 ( 5,616.96) 129,741.39 69.57 56,758.61 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 203.19 36.94 346.81 101-4-3120-4321 Telephone 7,300.00 449.32 5,215.43 71.44 2,084.57 101-4-3120-4322 Postage 100.00 0.00 46.93 46.93 53.07 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 275.00 2,357.00 46.22 2,743.00 101-4-3120-4359 Publishing 200.00 200.00 246.00 123.00 ( 46.00) 101-4-3120-4361 Insurance 18,500.00 0.00 16,070.00 86.86 2,430.00 101-4-3120-4389 Utilities 92,800.00 9,624.58 64,361.70 69.36 28,438.30 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 22.95 19,246.87 96.23 753.13 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 4,795.00 9,400.53 104.45 ( 400.53) 101-4-3120-4409 Contractual Services 63,500.00 36,609.66 60,559.67 95.37 2,940.33 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Works 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-3120-4415 Equipment Rental 3,000.00 0.00 3,516.75 117.23 ( 516.75) 101-4-3120-4417 Uniform Rental 5,800.00 496.86 2,549.69 43.96 3,250.31 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 530.00 151.43 ( 180.00) 101-4-3120-4437 Taxes & Licenses 150.00 0.00 95.00 63.33 55.00 101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 88,333.30 83.33 17,666.70 TOTAL Other Services & Charges 332,350.00 61,306.70 272,732.06 82.06 59,617.94 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,304,800.00 119,589.58 1,063,110.39 81.48 241,689.61 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 140,000.00 0.00 28,971.62 20.69 111,028.38 101-4-3130-4102 Overtime Pay 20,000.00 0.00 9,305.79 46.53 10,694.21 101-4-3130-4104 PERA 11,550.00 0.00 2,533.71 21.94 9,016.29 101-4-3130-4105 FICA 9,950.00 0.00 2,124.26 21.35 7,825.74 101-4-3130-4107 Medicare 2,300.00 0.00 502.96 21.87 1,797.04 101-4-3130-4108 Insurance 21,050.00 0.00 5,271.00 25.04 15,779.00 101-4-3130-4109 Workers Comp 8,800.00 0.00 6,264.00 71.18 2,536.00 TOTAL Personal Services 213,650.00 0.00 54,973.34 25.73 158,676.66 Supplies 101-4-3130-4219 Operating Supplies 92,300.00 75.93 69,301.98 75.08 22,998.02 TOTAL Supplies 92,300.00 75.93 69,301.98 75.08 22,998.02 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 305,950.00 75.93 124,275.32 40.62 181,674.68 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 117,150.00 9,124.80 92,256.65 78.75 24,893.35 101-4-3150-4102 Overtime Pay 3,000.00 234.22 1,411.92 47.06 1,588.08 101-4-3150-4104 PERA 9,000.00 701.93 7,025.15 78.06 1,974.85 101-4-3150-4105 FICA 7,450.00 564.10 5,652.14 75.87 1,797.86 101-4-3150-4107 Medicare 1,750.00 131.92 1,321.87 75.54 428.13 101-4-3150-4108 Insurance 15,900.00 1,337.00 13,370.00 84.09 2,530.00 101-4-3150-4109 Workers Comp 3,400.00 0.00 2,031.00 59.74 1,369.00 TOTAL Personal Services 157,650.00 12,093.97 123,068.73 78.06 34,581.27 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Works 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 300.27) 5,382.11 105.53 ( 282.11) 101-4-3150-4219 Operating Supplies 11,150.00 4,201.96 11,819.28 106.00 ( 669.28) 101-4-3150-4221 Equipment Parts 4,500.00 1,710.06 1,304.15 28.98 3,195.85 TOTAL Supplies 20,750.00 5,611.75 18,505.54 89.18 2,244.46 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 1,157.15 38.57 1,842.85 101-4-3150-4404 Equip Repair/Maint Services 12,500.00 1,637.73 3,899.91 31.20 8,600.09 101-4-3150-4417 Uniform Rental 2,150.00 367.35 1,277.29 59.41 872.71 TOTAL Other Services & Charges 17,650.00 2,005.08 6,334.35 35.89 11,315.65 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 196,050.00 19,710.80 147,908.62 75.44 48,141.38 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 170,400.00 13,105.73 134,333.69 78.83 36,066.31 101-4-3300-4104 PERA 12,800.00 982.93 10,075.00 78.71 2,725.00 101-4-3300-4105 FICA 10,550.00 796.10 8,168.24 77.42 2,381.76 101-4-3300-4107 Medicare 2,450.00 186.19 1,910.31 77.97 539.69 101-4-3300-4108 Insurance 7,200.00 1,532.00 15,320.00 212.78 ( 8,120.00) 101-4-3300-4109 Workers Comp 800.00 0.00 409.50 51.19 390.50 TOTAL Personal Services 204,200.00 16,602.95 170,216.74 83.36 33,983.26 Supplies 101-4-3300-4201 Office Supplies 150.00 6.88 207.82 138.55 ( 57.82) 101-4-3300-4212 Fuels & Lubes 1,000.00 75.67 677.72 67.77 322.28 101-4-3300-4219 Operating Supplies 2,500.00 0.00 3,235.57 129.42 ( 735.57) TOTAL Supplies 3,650.00 82.55 4,121.11 112.91 ( 471.11) Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 0.00 730.00 18.25 3,270.00 101-4-3300-4321 Telephone 1,400.00 90.71 829.68 59.26 570.32 101-4-3300-4322 Postage 350.00 0.00 184.09 52.60 165.91 101-4-3300-4331 Travel, Conferences & Schools 1,500.00 125.00 734.00 48.93 766.00 101-4-3300-4361 Insurance 100.00 0.00 82.50 82.50 17.50 101-4-3300-4404 Equip Repair/Maint Services 1,800.00 0.00 213.10 11.84 1,586.90 101-4-3300-4460 Equip Replacement Charge 1,500.00 125.00 1,250.00 83.33 250.00 TOTAL Other Services & Charges 10,650.00 340.71 4,023.37 37.78 6,626.63 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Public Works 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 218,500.00 17,026.21 178,361.22 81.63 40,138.78 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,025,300.00 156,402.52 1,513,655.55 74.74 511,644.45 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 405,150.00 32,304.66 320,612.45 79.13 84,537.55 101-4-5110-4102 Overtime Pay 6,600.00 568.80 3,743.49 56.72 2,856.51 101-4-5110-4103 Part-time Pay 68,250.00 1,920.00 50,034.96 73.31 18,215.04 101-4-5110-4104 PERA 30,900.00 2,458.08 24,221.47 78.39 6,678.53 101-4-5110-4105 FICA 29,250.00 2,010.88 21,839.23 74.66 7,410.77 101-4-5110-4107 Medicare 6,900.00 470.28 5,101.39 73.93 1,798.61 101-4-5110-4108 Insurance 79,300.00 5,799.50 61,683.00 77.78 17,617.00 101-4-5110-4109 Workers Comp 12,250.00 0.00 11,485.50 93.76 764.50 101-4-5110-4110 Re-employment Compensation 0.00 0.00 2,225.00 0.00 ( 2,225.00) TOTAL Personal Services 638,600.00 45,532.20 500,946.49 78.44 137,653.51 Supplies 101-4-5110-4212 Fuels & Lubes 25,000.00 1,588.51 16,658.48 66.63 8,341.52 101-4-5110-4217 Uniform Allowance 3,800.00 630.99 2,688.05 70.74 1,111.95 101-4-5110-4219 Operating Supplies 97,000.00 8,186.10 75,922.47 78.27 21,077.53 101-4-5110-4221 Equipment Parts 27,000.00 3,669.22 17,455.21 64.65 9,544.79 TOTAL Supplies 152,800.00 14,074.82 112,724.21 73.77 40,075.79 Other Services & Charges 101-4-5110-4321 Telephone 5,050.00 348.63 3,068.20 60.76 1,981.80 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 4,800.00 0.00 2,475.58 51.57 2,324.42 101-4-5110-4361 Insurance 33,500.00 0.00 32,492.50 96.99 1,007.50 101-4-5110-4389 Utilities 76,000.00 16,065.35 66,258.94 87.18 9,741.06 101-4-5110-4401 Bldg Repair/Maint Services 2,000.00 0.00 3,450.06 172.50 ( 1,450.06) 101-4-5110-4404 Equip Repair/Maint Services 16,500.00 1,500.37 6,957.72 42.17 9,542.28 101-4-5110-4409 Contractual Services 45,100.00 3,329.67 26,394.55 58.52 18,705.45 101-4-5110-4415 Equipment Rental 22,200.00 3,300.00 22,630.09 101.94 ( 430.09) 101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 42,750.00 83.33 8,550.00 TOTAL Other Services & Charges 256,550.00 28,819.02 206,477.64 80.48 50,072.36 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,047,950.00 88,426.04 820,148.34 78.26 227,801.66 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Culture & Recreation 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 304,750.00 23,553.85 240,109.64 78.79 64,640.36 101-4-5210-4102 Overtime Pay 0.00 183.67 1,624.41 0.00 ( 1,624.41) 101-4-5210-4103 Part-time Pay 51,150.00 4,224.78 38,940.47 76.13 12,209.53 101-4-5210-4104 PERA 26,700.00 2,097.18 21,062.60 78.89 5,637.40 101-4-5210-4105 FICA 22,050.00 1,652.77 16,623.00 75.39 5,427.00 101-4-5210-4107 Medicare 5,150.00 386.54 3,887.63 75.49 1,262.37 101-4-5210-4108 Insurance 41,700.00 3,508.00 35,080.00 84.12 6,620.00 101-4-5210-4109 Workers Comp 3,900.00 0.00 3,033.00 77.77 867.00 TOTAL Personal Services 455,400.00 35,606.79 360,360.75 79.13 95,039.25 Supplies 101-4-5210-4219 Operating Supplies 8,600.00 444.91 10,085.75 117.28 ( 1,485.75) TOTAL Supplies 8,600.00 444.91 10,085.75 117.28 ( 1,485.75) Other Services & Charges 101-4-5210-4321 Telephone 6,750.00 249.78 2,427.60 35.96 4,322.40 101-4-5210-4322 Postage 5,300.00 0.00 523.32 9.87 4,776.68 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 421.03 6,716.57 75.89 2,133.43 101-4-5210-4349 Advertising/Marketing 33,200.00 1,126.30 18,604.34 56.04 14,595.66 101-4-5210-4361 Insurance 450.00 0.00 415.50 92.33 34.50 101-4-5210-4389 Utilities 11,300.00 805.90 7,739.99 68.50 3,560.01 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 950.00 10,927.69 63.53 6,272.31 101-4-5210-4404 Equip Repair/Maint Services 8,600.00 0.00 6,493.24 75.50 2,106.76 101-4-5210-4433 Dues & Subscriptions 2,300.00 0.00 2,515.00 109.35 ( 215.00) TOTAL Other Services & Charges 93,950.00 3,553.01 56,363.25 59.99 37,586.75 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 557,950.00 39,604.71 426,809.75 76.50 131,140.25 Recreation Programs =================== Personal Services 101-4-5220-4102 Overtime Pay 0.00 37.89 39.21 0.00 ( 39.21) 101-4-5220-4103 Part-time Pay 82,000.00 3,310.39 67,131.54 81.87 14,868.46 101-4-5220-4104 PERA 1,900.00 159.45 1,710.11 90.01 189.89 101-4-5220-4105 FICA 5,100.00 207.59 4,195.25 82.26 904.75 101-4-5220-4107 Medicare 1,200.00 48.56 981.17 81.76 218.83 TOTAL Personal Services 90,200.00 3,763.88 74,057.28 82.10 16,142.72 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Culture & Recreation 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5220-4219 Operating Supplies 25,000.00 3,779.39 12,378.29 49.51 12,621.71 TOTAL Supplies 25,000.00 3,779.39 12,378.29 49.51 12,621.71 Other Services & Charges 101-4-5220-4409 Contractual Services 54,000.00 2,780.00 50,884.50 94.23 3,115.50 101-4-5220-4412 Building Rent 1,650.00 0.00 586.50 35.55 1,063.50 101-4-5220-4438 Credit Card Fees 3,600.00 358.44 2,943.90 81.78 656.10 TOTAL Other Services & Charges 59,250.00 3,138.44 54,414.90 91.84 4,835.10 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 174,450.00 10,681.71 140,850.47 80.74 33,599.53 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 124,600.00 9,584.00 98,235.98 78.84 26,364.02 101-4-5510-4103 Part-time Pay 9,750.00 712.50 7,324.75 75.13 2,425.25 101-4-5510-4104 PERA 10,100.00 718.80 7,367.70 72.95 2,732.30 101-4-5510-4105 FICA 8,350.00 633.19 6,494.18 77.77 1,855.82 101-4-5510-4107 Medicare 1,950.00 148.08 1,518.79 77.89 431.21 101-4-5510-4108 Insurance 23,000.00 1,583.00 15,830.00 68.83 7,170.00 101-4-5510-4109 Workers Comp 650.00 0.00 428.25 65.88 221.75 TOTAL Personal Services 178,400.00 13,379.57 137,199.65 76.91 41,200.35 Supplies 101-4-5510-4219 Operating Supplies 10,750.00 398.03 6,516.57 60.62 4,233.43 TOTAL Supplies 10,750.00 398.03 6,516.57 60.62 4,233.43 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 20.71 985.63 41.07 1,414.37 101-4-5510-4322 Postage 3,000.00 0.00 1,850.40 61.68 1,149.60 101-4-5510-4331 Travel, Conferences & Schools 3,100.00 0.00 659.06 21.26 2,440.94 101-4-5510-4361 Insurance 1,350.00 0.00 1,274.00 94.37 76.00 101-4-5510-4389 Utilities 21,300.00 1,828.47 15,011.04 70.47 6,288.96 101-4-5510-4401 Bldg Repair/Maint Services 16,500.00 1,017.04 14,060.27 85.21 2,439.73 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,900.00 793.56 21,842.99 183.55 ( 9,942.99) 101-4-5510-4433 Dues & Subscriptions 800.00 0.00 495.17 61.90 304.83 TOTAL Other Services & Charges 60,450.00 3,659.78 56,195.31 92.96 4,254.69 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Culture & Recreation 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 249,600.00 17,437.38 199,911.53 80.09 49,688.47 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,029,950.00 156,149.84 1,587,720.09 78.21 442,229.91 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 0.01) 16,425.56 0.00 ( 16,425.56) 101-4-6210-4103 Part-time Pay 0.00 0.00 1,050.00 0.00 ( 1,050.00) 101-4-6210-4104 PERA 0.00 0.00 1,246.92 0.00 ( 1,246.92) 101-4-6210-4105 FICA 0.00 0.00 1,039.37 0.00 ( 1,039.37) 101-4-6210-4107 Medicare 0.00 ( 0.02) 247.40 0.00 ( 247.40) 101-4-6210-4108 Insurance 0.00 0.00 2,272.20 0.00 ( 2,272.20) TOTAL Personal Services 0.00 ( 0.03) 22,281.45 0.00 ( 22,281.45) Other Services & Charges 101-4-6210-4349 Advertising/Marketing 0.00 ( 2.46)( 2.46) 0.00 2.46 101-4-6210-4361 Insurance 0.00 ( 106.00)( 73.00) 0.00 73.00 101-4-6210-4440 Miscellaneous 0.00 ( 162.61) 169.07 0.00 ( 169.07) TOTAL Other Services & Charges 0.00 ( 271.07) 93.61 0.00 ( 93.61) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 271.10) 22,375.06 0.00 ( 22,375.06) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 19,150.00 1,330.28 13,042.35 68.11 6,107.65 101-4-6220-4103 Part-time Pay 0.00 0.00 6,500.00 0.00 ( 6,500.00) 101-4-6220-4104 PERA 1,450.00 99.77 859.98 59.31 590.02 101-4-6220-4105 FICA 1,200.00 82.63 825.22 68.77 374.78 101-4-6220-4107 Medicare 300.00 19.34 197.36 65.79 102.64 101-4-6220-4108 Insurance 2,400.00 188.54 1,520.38 63.35 879.62 TOTAL Personal Services 24,500.00 1,720.56 22,945.29 93.65 1,554.71 Supplies 101-4-6220-4219 Operating Supplies 300.00 0.00 58.86 19.62 241.14 TOTAL Supplies 300.00 0.00 58.86 19.62 241.14 11-15-2017 08:04 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 101-GENERAL FUND Economic Development 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-6220-4319 Other Professional Services 2,500.00 0.00 110.00 4.40 2,390.00 101-4-6220-4331 Travel, Conferences & Schools 5,500.00 385.00 3,866.21 70.29 1,633.79 101-4-6220-4359 Publishing 1,000.00 0.00 652.40 65.24 347.60 TOTAL Other Services & Charges 9,000.00 385.00 4,628.61 51.43 4,371.39 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,800.00 2,105.56 27,632.76 81.75 6,167.24 ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,800.00 1,834.46 50,007.82 147.95 ( 16,207.82) Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 14,378,400.00 1,225,499.92 10,866,859.05 75.58 3,511,540.95 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 725,153.13)( 1,492,523.86) 1,492,523.86 o000 0 0 0 �00� �O_O� MOOS OOOM �NMO� � X00 � O N �00� M O� 0000 NOO M - M � m v v M M D V r M M 0 �- La Q Y � y nu v — J U c c c a+ o 0 0 0 0 0 0 V M M SR z3 9 _ N Q c c c 0 0 0 u O W h O h U G �9J' r — GO iV GO iV � � N O N � M O z c zo Fez ' o— _ - - - .. .. CC� F L b° c c c 0 0 0 pp r O r r V O M O M O O 0 0— �9J' W O GO r G0 O 121 N co .� vain NN Nn,M N M ,- Y � O b N M a\ G O � T 6 S F G y 6 u n 0. O '� W O � '✓� � L ,� u w v y J A ° U 11-15-2017 08:08 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: OCTOBER 31ST, 2017 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 15,326.84 950.94 16,277.78 101-1010 Cash - General Fund 5,855,400.63 ( 712,555.77) 5,142,844.86 211-1010 Cash - Library 434,712.91 ( 14,316.17) 420,396.74 221-1010 Cash - Ice Arena 470,770.25 ( 84,903.53) 385,866.72 222-1010 Cash - Pinewood Golf Course ( 23,375.32) ( 4,617.15) ( 27,992.47) 225-1010 Cash - Park Dedication 90,405.49 ( 18,636.57) 71,768.92 228-1010 Cash - Landfill 360,447.77 11,116.95 371,564.72 231-1010 Cash - Landfill Const Debris 748,774.56 0.00 748,774.56 240-1010 Cash - Micro Loan Fund 661,213.26 4,394.20 665,607.46 242-1010 Cash - State DEED 204,713.28 1,886.49 206,599.77 245-1010 Cash - Development Fund 580,076.57 9,231.85 589,308.42 290-1010 Cash - Capital Outlay Reserve 755,736.41 30,650.16 786,386.57 291-1010 Cash - Insurance Reserve 162,100.24 ( 627.21) 161,473.03 292-1010 Cash - Govt Bldgs Reserve 1,931,661.85 107,841.85 2,039,503.70 294-1010 Cash - Drug Forfeiture 20,934.72 269.75 21,204.47 295-1010 Cash - Severance Pay Reserve 73,155.46 0.00 73,155.46 296-1010 Cash - GRE Reserve 1,928,818.69 0.00 1,928,818.69 313-1010 Cash - 2007C/2012B GO Bonds 160,969.63 0.00 160,969.63 333-1010 Cash - 2010A GO Cap Imp Bonds 680,919.91 0.00 680,919.91 401-1010 Cash - Pavement Mgmt 1,797,194.45 1,398,044.10 3,195,238.55 403-1010 Cash - Street Improvement 903,752.00 103,603.19 1,007,355.19 406-1010 Cash - City Wide Trunk Util 3,799,891.97 0.00 3,799,891.97 410-1010 Cash - Equipment Replacement 838,222.27 24,120.82 862,343.09 440-1010 Cash - Park Improvement 354,256.19 ( 55,894.12) 298,362.07 463-1010 Cash - TIF #23 Pref Powder 1,768.65 0.00 1,768.65 602-1010 Cash - Wastewater Treatment 3,364,196.83 306,463.04 3,670,659.87 603-1010 Cash - Liquor 3,504,042.79 18,151.99 3,522,194.78 605-1010 Cash - Garbage 142,289.87 98,020.55 240,310.42 607-1010 Cash - Storm Water 478,990.48 62,091.93 541,082.41 801-1010 Cash - Interest 0.00 28,488.54 28,488.54 821-1010 Cash - Developer Escrow 412,280.54 ( 19,887.00) 392,393.54_ TOTAL CLAIM ON CASH 30,709,649.19 1,293,888.83 32,003,538.02 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 87,776,578.37 2,230,606.58 90,007,184.95 999-1001 PY BANK ACCOUNT (85,449,118.74) ( 936,717.75) (86,385,836.49) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 30,709,649.19 1,293,888.83 32,003,538.02 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 30,709,649.19 1,293,888.83 32,003,538.02 =============== ============== ============== CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2017 222 -PINEWOOD GOLF COURSE REVENUES: 222-4-5300-4319 Chames for Services 222-4-5300-4349 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3792 Cash Over TOTAL Charges for Services TOTAL REVENUE EXPENDITURES: Supplies 222-4-5300-4212 Fuels & Lubes 222-4-5300-4219 Operating Supplies 222-4-5300-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charees 222-4-5300-4319 Management Fee 222-4-5300-4349 Advertising/Marketing 222-4-5300-4389 Utilities 222-4-5300-4401 Building Maintenance 222-4-5300-4404 Grounds Maintenance 222-4-5300-4409 Contractual Svcs- Wages/Taxes 222-4-5300-4415 Equipment Rental 222-4-5300-4437 Taxes & Licenses 222-4-5300-4438 Bank/Credit Card Fees TOTAL Other Services & Charges TOTAL EXPENDITURES MONTH OF YTD SEPTEMBER ACTUAL ERGC CITY 1,363.69 5,127.35 5,127.35 527.32 2,103.44 2,103.44 10,996.07 63,881.45 63,881.45 - 5,300.00 5,300.00 2,219.98 12, 99 2.80 12, 992.80 - 0.60 0.60 15,107.06 89,405.64 89,405.64 15,107.06 89,405.64 89,405.64 438.80 6,952.71 6,896.21 56.50 - 2,941.83 2,510.05 431.78 1,075.56 4,936.68 4,936.68 1,514.36 14,831.22 14,342.94 488.28 4,000.00 20,000.00 - 20,000.00 318.00 1,436.00 1,436.00 - 1,169.80 3,540.20 1,469.16 2,071.04 - 1,764.09 1,178.09 586.00 950.15 10,869.70 10,639.70 230.00 7,258.34 60,723.79 60,723.79 - - 374.06 374.06 - - 525.00 525.00 - 344.37 1,420.43 1,420.43 - 14,040.66 100,653.27 77,766.23 22,887.04 15,555.02 115,484.49 92,109.17 23,375.32 REVENUES OVER/(UNDER) EXPENDITURES (447.96) (26,078.85) (2,703.53) (23,375.32) CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31, 2017 222 -PINEWOOD GOLF COURSE TOTAL Charges for Services TOTALREVENUE Supplies 1,430.45 90,836.09 90,836.09 1,430.45 90,836.09 90,836.09 222-4-5300-4212 Fuels & Lubes 6,952.71 6,896.21 56.50 222-4-5300-4219 Operating Supplies - 2,941.83 2,510.05 431.78 222-4-5300-4259 Other Merchandise For Resale 19.20 4,955.88 4,955.88 TOTAL Supplies 19.20 14,850.42 14,362.14 488.28 Other Services & Charges 222-4-5300-4319 MONTH OF YTD Advertising/Marketing REVENUES: Utilities OCTOBER ACTUAL ERGC CITY Charges for Services 222-4-5300-4409 Contractual Svcs- Wages/Taxes 222-4-5300-4415 Equipment Rental 222-3-0000-3467 Concessions 72.52 5,199.87 5,199.87 222-3-0000-3469 Other Sales 66.00 2,169.44 2,169.44 222-3-0000-3476 Green Fees 1,112.24 64,993.69 64,993.69 222-3-0000-3477 Membership Fees - 5,300.00 5,300.00 222-3-0000-3478 Golf Cart Rental 179.69 13,172.49 13,172.49 222-3-0000-3792 Cash Over - 0.60 0.60 TOTAL Charges for Services TOTALREVENUE Supplies 1,430.45 90,836.09 90,836.09 1,430.45 90,836.09 90,836.09 222-4-5300-4212 Fuels & Lubes 6,952.71 6,896.21 56.50 222-4-5300-4219 Operating Supplies - 2,941.83 2,510.05 431.78 222-4-5300-4259 Other Merchandise For Resale 19.20 4,955.88 4,955.88 TOTAL Supplies 19.20 14,850.42 14,362.14 488.28 Other Services & Charges 222-4-5300-4319 Management Fee 222-4-5300-4349 Advertising/Marketing 222-4-5300-4389 Utilities 222-4-5300-4401 Building Maintenance 222-4-5300-4404 Grounds Maintenance 222-4-5300-4409 Contractual Svcs- Wages/Taxes 222-4-5300-4415 Equipment Rental 222-4-5300-4437 Taxes & Licenses 222-4-5300-4438 Bank/Credit Card Fees TOTAL Other Services & Charges TOTAL EXPENDITURES 4,000.00 24,000.00 - 24,000.00 - 1,436.00 1,436.00 - 903.64 4,443.84 1,755.65 2,688.19 - 1,764.09 1,178.09 586.00 10,869.70 10,639.70 230.00 6,183.91 66,907.70 66,907.70 - - 374.06 374.06 - - 525.00 525.00 - 246.00 1,666.43 1,666.43 - 11,333.55 111,986.82 84,482.63 27,504.19 11,352.75 126,837.24 98,844.77 27,992.47 REVENUES OVER/(UNDER) EXPENDITURES (9,922.30) (36,001.15) (8,008.68) (27,992.47)