The URL can be used to link to this page

INFORMATION 12-18-2017 Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: December 18, 2017 Subject: November 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 November, actual revenues (except for property taxes) and expenditures should run about 92% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being 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 63% of budget. The second-half property tax settlement will be received in December. ■ Licenses and permits collections exceed annual budget estimates by$271,664 as of the end of November. Building-related permit collections are at 146% of budget. ■ Intergovernmental revenue collections are at$105% of budget with the 4"'quarter crime prevention grant yet to be received for 2017. ■ Charges for services are 111% of budget estimates,with plan review fees and the Otsego fire contract making up the majority share. ■ Although fines and forfeits collections lag a month,reported collections through October are about 101% of budget estimates. p 0 W I H L 0 N' AfURE] Expenditures: ■ Total departmental expenditures are about 85% of budget and most departments are below budget estimates. The fourth quarter workers' compensation insurance premium is reflected in the November expenditures. 2017 Monthly Expenditures $16,000 $14,000 o $12,000 - Q $10,000 4A D _ $8,000 $6,000 $4,000 $2,000 Actual $831 $1,896 $3,021 $4,018 $5,103 $6,568 $7,621 $8,761 1 $9,642 1$10,8731$12 205 Budget $1,198 $2,396 $3,595 $4,793 $5,991 $7,189 $8,387 1 $9,586 $10,784$11,982$13,180$14,378 ICE ARENA As of the end of November, expenditures of$619,721 exceeded revenues of$599,461 by $20,260. Ice rental revenues of$384,627 are about 71% of budget estimates. PINEWOOD GOLF Through the end of November, expenditures of$130,577 exceeded revenues of$90,861 by $39,716. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds-Budget to Actual ■ Cash Report-All Funds ■ Pinewood Revenue&Expense-November 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 14,378,400.00 190,214.49 9,569,841.93 66.56 4,808,558.07 TOTAL REVENUES 14,378,400.00 190,214.49 9,569,841.93 66.56 4,808,558.07 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 148,800.00 24,154.61 124,678.06 83.79 24,121.94 Cable TV 111,300.00 7,783.53 85,162.17 76.52 26,137.83 Administrative Services 594,450.00 44,225.78 507,026.54 85.29 87,423.46 Human Resources 234,450.00 12,933.98 178,180.28 76.00 56,269.72 Elections 6,600.00 0.00 6,300.00 95.45 300.00 Finance 572,200.00 38,565.00 496,754.72 86.81 75,445.28 Information Technology 385,100.00 21,088.76 310,472.05 80.62 74,627.95 Legal 220,000.00 19,046.60 191,263.95 86.94 28,736.05 Community Development 223,400.00 17,395.20 193,982.55 86.83 29,417.45 Planning 297,450.00 23,008.84 257,831.19 86.68 39,618.81 City Hall Maintenance 638,850.00 52,131.01 541,108.24 84.70 97,741.76 TOTAL General Government 3,432,600.00 260,333.31 2,892,759.75 84.27 539,840.25 Public Safety Police Administration 762,900.00 65,921.28 619,530.30 81.21 143,369.70 Patrol 2,495,550.00 182,112.82 2,009,570.98 80.53 485,979.02 Investigations 1,029,350.00 67,815.71 796,790.17 77.41 232,559.83 Police Support Services 676,100.00 42,919.61 549,116.00 81.22 126,984.00 Police Reserves 21,450.00 1,733.56 10,229.84 47.69 11,220.16 Public safety building 156,900.00 11,947.19 131,564.23 83.85 25,335.77 Fire Administration 481,050.00 35,992.07 421,979.93 87.72 59,070.07 Fire Operations 400,200.00 34,737.07 368,453.20 92.07 31,746.80 Emergency Management 27,300.00 399.57 12,205.60 44.71 15,094.40 Building Safety 665,300.00 50,216.29 563,744.18 84.74 101,555.82 Code Enforcement 93,650.00 7,326.16 77,779.69 83.05 15,870.31 Environmental 47,000.00 2,016.73 24,804.94 52.78 22,195.06 TOTAL Public Safety 6,856,750.00 503,138.06 5,585,769.06 81.46 1,270,980.94 Public Works Street Maintenance 1,304,800.00 128,704.65 1,191,616.53 91.33 113,183.47 Snow Removal 305,950.00 4,283.57 128,558.89 42.02 177,391.11 Equipment Services 196,050.00 10,641.45 158,550.07 80.87 37,499.93 Engineering 218,500.00 16,461.44 194,822.66 89.16 23,677.34 TOTAL Public Works 2,025,300.00 160,091.11 1,673,548.15 82.63 351,751.85 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,047,950.00 80,945.24 901,093.58 85.99 146,856.42 Parks & Rec Admin 557,950.00 41,391.83 468,201.58 83.91 89,748.42 Recreation Programs 174,450.00 3,875.61 144,409.08 82.78 30,040.92 Sr Citizen Programs 249,600.00 19,605.00 219,516.53 87.95 30,083.47 TOTAL Culture & Recreation 2,029,950.00 145,817.68 1,733,220.77 85.38 296,729.23 Economic Development Economic Development 0.00 ( 31.70) 22,345.82 0.00 ( 22,345.82) Energy City 33,800.00 1,720.65 30,153.41 89.21 3,646.59 TOTAL Economic Development 33,800.00 1,688.95 52,499.23 155.32 ( 18,699.23) General Transfers Out 0.00 266,832.00 266,832.00 0.00 ( 266,832.00) TOTAL General 0.00 266,832.00 266,832.00 0.00 ( 266,832.00) TOTAL EXPENDITURES 14,378,400.00 1,337,901.11 12,204,628.96 84.88 2,173,771.04 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 1,147,686.62)( 2,634,787.03) 2,634,787.03 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,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 0.00 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 0.00 5,244,829.33 51.88 4,864,420.67 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 0.00 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 600.00 3,000.00 96.77 100.00 101-3-0000-3214 Rental License 45,000.00 2,176.00 64,510.00 143.36 ( 19,510.00) 101-3-0000-3216 Mining License 23,000.00 375.00 18,603.45 80.88 4,396.55 101-3-0000-3217 Garbage Hauler License 1,800.00 495.00 960.00 53.33 840.00 101-3-0000-3218 Other Business License/Permit 13,000.00 6,795.00 14,235.00 109.50 ( 1,235.00) 101-3-0000-3229 NPDES Permit 12,000.00 1,225.00 19,250.00 160.42 ( 7,250.00) 101-3-0000-3231 Building Permit 415,000.00 27,467.60 533,800.69 128.63 ( 118,800.69) 101-3-0000-3232 Plumbing/Heating Permit 118,000.00 6,857.09 242,588.85 205.58 ( 124,588.85) 101-3-0000-3233 Permit Surcharge 1,500.00 ( 309.70) 2,781.98 185.47 ( 1,281.98) 101-3-0000-3235 Animal License 6,000.00 570.00 3,170.00 52.83 2,830.00 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 960.00 14,110.00 176.38 ( 6,110.00) TOTAL Licenses & Permits 714,950.00 47,210.99 986,614.13 138.00 ( 271,664.13) Intergovernmental Rev 101-3-0000-3322 MV Credit 5,000.00 0.00 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 1,000.00 11,173.66 111.74 ( 1,173.66) 101-3-0000-3329 State Crime Prevention Grant 25,000.00 ( 13,188.70) 14,549.78 58.20 10,450.22 TOTAL Intergovernmental Rev 293,500.00 ( 12,188.70) 309,210.30 105.35 ( 15,710.30) Charges for Services 101-3-0000-3412 Planning & Zoning Fees 30,000.00 1,925.00 32,759.70 109.20 ( 2,759.70) 101-3-0000-3413 Plan Check Fee 145,000.00 14,920.89 260,079.76 179.37 ( 115,079.76) 101-3-0000-3415 Special Assessment Search 500.00 50.00 1,050.00 210.00 ( 550.00) 101-3-0000-3417 Copies 1,700.00 265.03 2,692.03 158.35 ( 992.03) 101-3-0000-3418 Other General Govt Services 5,000.00 13.00 3,091.00 61.82 1,909.00 101-3-0000-3430 Lockout Fees 7,000.00 570.00 5,385.00 76.93 1,615.00 101-3-0000-3431 Police Services 8,000.00 88.00 13,330.25 166.63 ( 5,330.25) 101-3-0000-3432 School Liaison 123,600.00 0.00 123,624.00 100.02 ( 24.00) 101-3-0000-3434 Animal Impound Fee 3,000.00 375.00 4,175.00 139.17 ( 1,175.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 24.10 281.45 14.07 1,718.55 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 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND 91.67% 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 785.00 11,620.90 46.48 13,379.10 101-3-0000-3452 Engineering Services Reimb 125,000.00 14,534.94 130,380.75 104.30 ( 5,380.75) 101-3-0000-3461 Recreation Fees 96,000.00 ( 1,854.50) 60,432.58 62.95 35,567.42 101-3-0000-3462 Sr Center Activities 30,000.00 2,919.00 38,781.63 129.27 ( 8,781.63) 101-3-0000-3472 Park Use Fee 24,400.00 ( 414.94) 25,351.34 103.90 ( 951.34) 101-3-0000-3475 Building Rent 2,400.00 200.00 2,200.00 91.67 200.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 1,700.00 11,115.00 123.50 ( 2,115.00) 101-3-0000-3484 Contractor License Check 1,000.00 65.00 1,005.00 100.50 ( 5.00) TOTAL Charges for Services 891,400.00 36,165.52 985,499.89 110.56 ( 94,099.89) Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 16,633.63 151,724.58 104.64 ( 6,724.58) 101-3-0000-3511 Parking Fines 10,000.00 160.00 5,080.00 50.80 4,920.00 101-3-0000-3512 Ordinance Violations 0.00 0.00 75.00 0.00 ( 75.00) TOTAL Fines & Forfeits 155,000.00 16,793.63 156,879.58 101.21 ( 1,879.58) Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 86,891.62 96.55 3,108.38 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 ( 127.66) 4,068.39 62.59 2,431.61 TOTAL Other Revenue 217,500.00 ( 127.66) 107,837.42 49.58 109,662.58 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 102,360.71 904,838.83 87.42 130,161.17 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 102,360.71 1,778,971.28 89.09 217,828.72 _____________________________________________________________________________ TOTAL General Fund 14,378,400.00 190,214.49 9,569,841.93 66.56 4,808,558.07 ___________________________________________________________________________________________________________________ TOTAL REVENUE 14,378,400.00 190,214.49 9,569,841.93 66.56 4,808,558.07 ============= ============= ============= ======= ============= 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,208.32 35,291.52 91.67 3,208.48 101-4-1110-4104 PERA 1,900.00 117.09 1,182.99 62.26 717.01 101-4-1110-4105 FICA 2,400.00 90.94 851.46 35.48 1,548.54 101-4-1110-4107 Medicare 550.00 55.24 537.95 97.81 12.05 101-4-1110-4109 Workers Comp 100.00 13.50 47.25 47.25 52.75 TOTAL Personal Services 43,450.00 3,485.09 37,911.17 87.25 5,538.83 Supplies 101-4-1110-4201 Office Supplies 800.00 244.83 611.67 76.46 188.33 TOTAL Supplies 800.00 244.83 611.67 76.46 188.33 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 1,374.17 5,100.01 49.04 5,299.99 101-4-1110-4322 Postage 50.00 0.45 34.30 68.60 15.70 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 10.12 1,236.22 47.55 1,363.78 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 18,840.00 18,870.00 96.52 680.00 101-4-1110-4440 Miscellaneous 27,450.00 199.95 22,046.29 80.31 5,403.71 TOTAL Other Services & Charges 104,550.00 20,424.69 86,155.22 82.41 18,394.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 148,800.00 24,154.61 124,678.06 83.79 24,121.94 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 65,000.00 4,996.80 56,214.01 86.48 8,785.99 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 788.86 7,630.51 41.47 10,769.49 101-4-1120-4104 PERA 6,800.00 433.92 4,795.37 70.52 2,004.63 101-4-1120-4105 FICA 5,200.00 328.17 3,739.92 71.92 1,460.08 101-4-1120-4107 Medicare 1,200.00 76.75 874.65 72.89 325.35 101-4-1120-4108 Insurance 11,350.00 914.50 8,915.50 78.55 2,434.50 101-4-1120-4109 Workers Comp 400.00 240.25 440.50 110.13 ( 40.50) TOTAL Personal Services 108,350.00 7,779.25 82,750.99 76.37 25,599.01 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1120-4201 Office Supplies 2,000.00 4.28 1,608.48 80.42 391.52 TOTAL Supplies 2,000.00 4.28 1,608.48 80.42 391.52 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,783.53 85,162.17 76.52 26,137.83 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 398,500.00 30,650.90 345,016.27 86.58 53,483.73 101-4-1210-4102 Overtime Pay 0.00 0.00 69.15 0.00 ( 69.15) 101-4-1210-4103 Part-time Pay 47,200.00 3,393.45 38,479.26 81.52 8,720.74 101-4-1210-4104 PERA 33,450.00 2,553.35 28,767.57 86.00 4,682.43 101-4-1210-4105 FICA 27,650.00 2,037.10 24,152.51 87.35 3,497.49 101-4-1210-4107 Medicare 6,450.00 503.78 5,675.92 88.00 774.08 101-4-1210-4108 Insurance 26,650.00 2,250.50 25,310.70 94.97 1,339.30 101-4-1210-4109 Workers Comp 2,100.00 499.50 1,920.75 91.46 179.25 TOTAL Personal Services 542,000.00 41,888.58 469,392.13 86.60 72,607.87 Supplies 101-4-1210-4201 Office Supplies 7,300.00 223.77 3,064.76 41.98 4,235.24 TOTAL Supplies 7,300.00 223.77 3,064.76 41.98 4,235.24 Other Services & Charges 101-4-1210-4319 Other Professional Services 13,000.00 0.00 8,537.94 65.68 4,462.06 101-4-1210-4321 Telephone 1,650.00 163.51 1,973.62 119.61 ( 323.62) 101-4-1210-4322 Postage 0.00 216.96 771.09 0.00 ( 771.09) 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,400.00 91.67 400.00 101-4-1210-4359 Publishing 0.00 80.00 80.00 0.00 ( 80.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 841.00 13,772.84 92.13 1,177.16 101-4-1210-4433 Dues & Subscriptions 2,900.00 411.96 2,609.66 89.99 290.34 TOTAL Other Services & Charges 45,150.00 2,113.43 34,569.65 76.57 10,580.35 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 594,450.00 44,225.78 507,026.54 85.29 87,423.46 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 127,050.00 9,248.86 90,967.30 71.60 36,082.70 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 7,070.74 74.04 2,479.26 101-4-1220-4105 FICA 7,900.00 560.97 5,826.46 73.75 2,073.54 101-4-1220-4107 Medicare 1,850.00 131.20 1,362.64 73.66 487.36 101-4-1220-4108 Insurance 15,850.00 1,337.00 12,319.00 77.72 3,531.00 101-4-1220-4109 Workers Comp 600.00 160.25 565.25 94.21 34.75 TOTAL Personal Services 162,800.00 12,131.94 123,594.32 75.92 39,205.68 Supplies 101-4-1220-4201 Office Supplies 1,200.00 54.97 968.98 80.75 231.02 TOTAL Supplies 1,200.00 54.97 968.98 80.75 231.02 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 0.00 1,728.30 138.26 ( 478.30) 101-4-1220-4322 Postage 600.00 28.74 248.34 41.39 351.66 101-4-1220-4331 Travel, Conferences & Schools 7,200.00 718.33 1,716.54 23.84 5,483.46 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 747.07 53,616.98 76.11 16,833.02 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 234,450.00 12,933.98 178,180.28 76.00 56,269.72 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 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Finance ======= Personal Services 101-4-1310-4101 Regular Pay 303,000.00 23,601.51 261,794.97 86.40 41,205.03 101-4-1310-4103 Part-time Pay 54,700.00 3,997.43 46,546.73 85.09 8,153.27 101-4-1310-4104 PERA 26,850.00 2,069.90 23,125.44 86.13 3,724.56 101-4-1310-4105 FICA 22,200.00 1,624.95 18,478.14 83.23 3,721.86 101-4-1310-4107 Medicare 5,200.00 380.04 4,321.51 83.11 878.49 101-4-1310-4108 Insurance 40,600.00 3,377.70 34,585.20 85.19 6,014.80 101-4-1310-4109 Workers Comp 1,700.00 466.00 1,606.75 94.51 93.25 TOTAL Personal Services 454,250.00 35,517.53 390,458.74 85.96 63,791.26 Supplies 101-4-1310-4201 Office Supplies 5,000.00 50.32 2,287.50 45.75 2,712.50 TOTAL Supplies 5,000.00 50.32 2,287.50 45.75 2,712.50 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 399.90 29.62 950.10 101-4-1310-4322 Postage 2,800.00 906.35 2,837.46 101.34 ( 37.46) 101-4-1310-4331 Travel, Conferences & Schools 3,900.00 880.95 1,658.21 42.52 2,241.79 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 109.00 16,424.26 86.22 2,625.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 932.76 7,231.65 124.68 ( 1,431.65) 101-4-1310-4440 Miscellaneous 1,500.00 128.10 1,080.00 72.00 420.00 TOTAL Other Services & Charges 112,950.00 2,997.15 104,008.48 92.08 8,941.52 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 572,200.00 38,565.00 496,754.72 86.81 75,445.28 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 196,400.00 10,630.62 145,683.84 74.18 50,716.16 101-4-1350-4104 PERA 14,750.00 797.30 10,434.95 70.75 4,315.05 101-4-1350-4105 FICA 12,200.00 577.71 8,125.55 66.60 4,074.45 101-4-1350-4107 Medicare 2,850.00 135.11 1,900.72 66.69 949.28 101-4-1350-4108 Insurance 34,400.00 1,623.00 24,190.50 70.32 10,209.50 101-4-1350-4109 Workers Comp 950.00 255.00 881.25 92.76 68.75 TOTAL Personal Services 261,550.00 14,018.74 191,216.81 73.11 70,333.19 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1350-4219 Operating Supplies 20,100.00 2,118.37 16,884.37 84.00 3,215.63 TOTAL Supplies 20,100.00 2,118.37 16,884.37 84.00 3,215.63 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 493.75 9,915.50 123.94 ( 1,915.50) 101-4-1350-4321 Telephone 2,800.00 108.51 1,719.96 61.43 1,080.04 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 7.00 11,587.41 90.88 1,162.59 101-4-1350-4404 Equip Repair/Maint Services 79,900.00 4,342.39 79,148.00 99.06 752.00 TOTAL Other Services & Charges 103,450.00 4,951.65 102,370.87 98.96 1,079.13 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 385,100.00 21,088.76 310,472.05 80.62 74,627.95 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 220,000.00 19,046.60 191,263.95 86.94 28,736.05 TOTAL Other Services & Charges 220,000.00 19,046.60 191,263.95 86.94 28,736.05 ___________________________________________________________________________________________________________________ TOTAL Legal 220,000.00 19,046.60 191,263.95 86.94 28,736.05 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 175,100.00 13,469.66 151,791.69 86.69 23,308.31 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,010.22 11,400.46 86.70 1,749.54 101-4-1500-4105 FICA 10,850.00 779.41 8,929.82 82.30 1,920.18 101-4-1500-4107 Medicare 2,550.00 182.28 2,088.42 81.90 461.58 101-4-1500-4108 Insurance 15,850.00 1,623.00 16,137.00 101.81 ( 287.00) 101-4-1500-4109 Workers Comp 850.00 148.75 706.75 83.15 143.25 TOTAL Personal Services 218,350.00 17,213.32 191,269.16 87.60 27,080.84 Supplies 101-4-1500-4201 Office Supplies 1,100.00 146.89 1,053.97 95.82 46.03 TOTAL Supplies 1,100.00 146.89 1,053.97 95.82 46.03 Other Services & Charges 101-4-1500-4321 Telephone 800.00 34.99 669.90 83.74 130.10 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 34.99 1,659.42 42.01 2,290.58 ___________________________________________________________________________________________________________________ TOTAL Community Development 223,400.00 17,395.20 193,982.55 86.83 29,417.45 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Planning ======== Personal Services 101-4-1510-4101 Regular Pay 217,700.00 17,001.81 187,133.54 85.96 30,566.46 101-4-1510-4104 PERA 16,350.00 1,275.12 14,034.92 85.84 2,315.08 101-4-1510-4105 FICA 13,500.00 967.19 10,667.79 79.02 2,832.21 101-4-1510-4107 Medicare 3,150.00 226.19 2,494.88 79.20 655.12 101-4-1510-4108 Insurance 26,600.00 2,240.50 24,645.50 92.65 1,954.50 101-4-1510-4109 Workers Comp 1,100.00 296.25 819.00 74.45 281.00 TOTAL Personal Services 278,400.00 22,007.06 239,795.63 86.13 38,604.37 Supplies 101-4-1510-4201 Office Supplies 1,500.00 97.34 1,697.81 113.19 ( 197.81) 101-4-1510-4212 Fuels & Lubes 300.00 4.09 34.71 11.57 265.29 101-4-1510-4219 Operating Supplies 1,900.00 48.08 2,072.56 109.08 ( 172.56) TOTAL Supplies 3,700.00 149.51 3,805.08 102.84 ( 105.08) 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 550.27 1,443.26 120.27 ( 243.26) 101-4-1510-4331 Travel, Conferences & Schools 2,950.00 174.00 2,547.27 86.35 402.73 101-4-1510-4359 Publishing 8,000.00 128.00 7,984.00 99.80 16.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 0.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 852.27 14,230.48 92.71 1,119.52 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,450.00 23,008.84 257,831.19 86.68 39,618.81 City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 354,300.00 27,451.34 307,968.25 86.92 46,331.75 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 368.82 4,466.82 125.83 ( 916.82) 101-4-1600-4104 PERA 26,850.00 2,058.85 23,138.80 86.18 3,711.20 101-4-1600-4105 FICA 22,400.00 1,725.42 19,442.00 86.79 2,958.00 101-4-1600-4107 Medicare 5,250.00 403.53 4,546.92 86.61 703.08 101-4-1600-4108 Insurance 50,300.00 4,157.50 45,732.50 90.92 4,567.50 101-4-1600-4109 Workers Comp 12,450.00 3,346.25 11,603.75 93.20 846.25 TOTAL Personal Services 478,600.00 39,511.71 417,188.94 87.17 61,411.06 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 260.72 1,817.86 60.60 1,182.14 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 1,195.37 18,103.58 54.04 15,396.42 TOTAL Supplies 38,900.00 1,456.09 20,684.05 53.17 18,215.95 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 1,165.76 11,921.46 101.89 ( 221.46) 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.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,165.93 59,534.28 91.24 5,715.72 101-4-1600-4401 Bldg Repair/Maint Services 30,800.00 3,585.69 20,854.45 67.71 9,945.55 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,704.13 91.67 245.87 TOTAL Other Services & Charges 121,350.00 11,163.21 103,235.25 85.07 18,114.75 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 638,850.00 52,131.01 541,108.24 84.70 97,741.76 Contingency =========== Personal Services _____________ _____________ _____________ _______ _____________ Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,432,600.00 260,333.31 2,892,759.75 84.27 539,840.25 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 372,800.00 27,640.50 289,859.95 77.75 82,940.05 101-4-2110-4102 Overtime Pay 2,500.00 0.00 1,189.62 47.58 1,310.38 101-4-2110-4104 PERA 55,100.00 4,158.56 45,402.55 82.40 9,697.45 101-4-2110-4105 FICA 3,800.00 246.06 1,344.06 35.37 2,455.94 101-4-2110-4107 Medicare 5,400.00 395.35 4,096.14 75.85 1,303.86 101-4-2110-4108 Insurance 34,250.00 2,192.00 22,285.00 65.07 11,965.00 101-4-2110-4109 Workers Comp 66,500.00 24,952.50 80,927.25 121.70 ( 14,427.25) TOTAL Personal Services 540,350.00 59,584.97 445,104.57 82.37 95,245.43 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2110-4201 Office Supplies 11,000.00 59.05 7,463.06 67.85 3,536.94 101-4-2110-4217 Uniform Allowance 3,000.00 74.99 2,576.10 85.87 423.90 101-4-2110-4219 Operating Supplies 23,500.00 196.50 10,299.27 43.83 13,200.73 TOTAL Supplies 37,500.00 330.54 20,338.43 54.24 17,161.57 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 1,682.66 8,394.05 106.25 ( 494.05) 101-4-2110-4321 Telephone 34,700.00 2,536.97 24,463.59 70.50 10,236.41 101-4-2110-4322 Postage 2,400.00 597.45 1,666.32 69.43 733.68 101-4-2110-4331 Travel, Conferences & Schools 14,800.00 1,188.69 9,070.67 61.29 5,729.33 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 0.00 58,006.67 84.13 10,943.33 101-4-2110-4433 Dues & Subscriptions 13,600.00 0.00 11,843.00 87.08 1,757.00 101-4-2110-4437 Taxes & Licenses 200.00 0.00 132.00 66.00 68.00 TOTAL Other Services & Charges 185,050.00 6,005.77 154,087.30 83.27 30,962.70 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 762,900.00 65,921.28 619,530.30 81.21 143,369.70 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,612,400.00 124,670.54 1,343,175.64 83.30 269,224.36 101-4-2120-4102 Overtime Pay 100,000.00 4,561.89 57,874.37 57.87 42,125.63 101-4-2120-4104 PERA 277,400.00 20,935.62 226,961.90 81.82 50,438.10 101-4-2120-4107 Medicare 24,850.00 1,819.23 19,727.50 79.39 5,122.50 101-4-2120-4108 Insurance 174,100.00 13,313.50 141,100.50 81.05 32,999.50 TOTAL Personal Services 2,188,750.00 165,300.78 1,788,839.91 81.73 399,910.09 Supplies 101-4-2120-4212 Fuels & Lubes 78,000.00 6,462.96 66,285.44 84.98 11,714.56 101-4-2120-4217 Uniform Allowance 35,600.00 972.20 12,558.02 35.28 23,041.98 101-4-2120-4219 Operating Supplies 73,900.00 2,539.41 40,187.03 54.38 33,712.97 101-4-2120-4221 Equipment Parts 23,300.00 ( 69.86) 16,411.62 70.44 6,888.38 TOTAL Supplies 210,800.00 9,904.71 135,442.11 64.25 75,357.89 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 27,050.00 2,385.00 22,778.81 84.21 4,271.19 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 564.00 18,708.52 89.94 2,091.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 43,541.63 91.67 3,958.37 TOTAL Other Services & Charges 96,000.00 6,907.33 85,288.96 88.84 10,711.04 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,495,550.00 182,112.82 2,009,570.98 80.53 485,979.02 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 696,700.00 49,851.20 565,318.01 81.14 131,381.99 101-4-2130-4102 Overtime Pay 55,000.00 1,063.38 26,170.35 47.58 28,829.65 101-4-2130-4104 PERA 121,800.00 8,248.19 95,821.03 78.67 25,978.97 101-4-2130-4107 Medicare 9,550.00 696.18 8,138.03 85.21 1,411.97 101-4-2130-4108 Insurance 93,950.00 6,273.88 69,012.68 73.46 24,937.32 TOTAL Personal Services 977,000.00 66,132.83 764,460.10 78.25 212,539.90 Supplies 101-4-2130-4217 Uniform Allowance 6,950.00 0.00 4,168.51 59.98 2,781.49 101-4-2130-4219 Operating Supplies 10,600.00 4.99 7,047.67 66.49 3,552.33 TOTAL Supplies 17,550.00 4.99 11,216.18 63.91 6,333.82 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 145.00 1,366.00 18.21 6,134.00 101-4-2130-4331 Travel, Conferences & Schools 11,200.00 0.00 5,314.78 47.45 5,885.22 101-4-2130-4433 Dues & Subscriptions 2,100.00 366.22 1,599.74 76.18 500.26 101-4-2130-4460 Equip Replacement Charge 14,000.00 1,166.67 12,833.37 91.67 1,166.63 TOTAL Other Services & Charges 34,800.00 1,677.89 21,113.89 60.67 13,686.11 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,029,350.00 67,815.71 796,790.17 77.41 232,559.83 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 437,350.00 25,002.55 356,493.15 81.51 80,856.85 101-4-2150-4102 Overtime Pay 7,500.00 1,378.61 11,947.82 159.30 ( 4,447.82) 101-4-2150-4103 Part-time Pay 40,500.00 3,121.48 34,300.66 84.69 6,199.34 101-4-2150-4104 PERA 44,700.00 2,212.69 30,926.22 69.19 13,773.78 101-4-2150-4105 FICA 24,200.00 1,779.06 20,246.73 83.66 3,953.27 101-4-2150-4107 Medicare 5,650.00 416.10 4,735.12 83.81 914.88 101-4-2150-4108 Insurance 72,200.00 4,488.75 61,433.00 85.09 10,767.00 TOTAL Personal Services 632,100.00 38,399.24 520,082.70 82.28 112,017.30 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2150-4201 Office Supplies 1,000.00 85.24 221.51 22.15 778.49 101-4-2150-4217 Uniform Allowance 5,350.00 874.25 3,414.37 63.82 1,935.63 101-4-2150-4219 Operating Supplies 14,600.00 1,618.88 9,848.65 67.46 4,751.35 TOTAL Supplies 20,950.00 2,578.37 13,484.53 64.37 7,465.47 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,900.00 165.00 2,409.05 34.91 4,490.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 1,252.00 5,776.50 82.52 1,223.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,775.00 91.67 525.00 TOTAL Other Services & Charges 23,050.00 1,942.00 15,548.77 67.46 7,501.23 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 676,100.00 42,919.61 549,116.00 81.22 126,984.00 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 90.60 1,562.87 28.42 3,937.13 101-4-2160-4105 FICA 350.00 5.62 96.89 27.68 253.11 101-4-2160-4107 Medicare 100.00 1.31 22.67 22.67 77.33 TOTAL Personal Services 5,950.00 97.53 1,682.43 28.28 4,267.57 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 441.03 4,648.69 84.52 851.31 101-4-2160-4219 Operating Supplies 4,700.00 1,195.00 1,323.72 28.16 3,376.28 TOTAL Supplies 10,200.00 1,636.03 5,972.41 58.55 4,227.59 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 0.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 0.00 2,575.00 48.58 2,725.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 21,450.00 1,733.56 10,229.84 47.69 11,220.16 Public safety building ====================== 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% 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 726.12 22,608.08 124.91 ( 4,508.08) TOTAL Supplies 18,100.00 726.12 22,608.08 124.91 ( 4,508.08) 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 7,476.68 75,826.22 79.40 19,673.78 101-4-2190-4401 Bldg Repair/Maint Services 38,100.00 3,744.39 28,277.93 74.22 9,822.07 TOTAL Other Services & Charges 138,800.00 11,221.07 108,956.15 78.50 29,843.85 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,900.00 11,947.19 131,564.23 83.85 25,335.77 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 246,050.00 17,372.71 210,763.03 85.66 35,286.97 101-4-2310-4104 PERA 36,150.00 2,517.89 30,940.38 85.59 5,209.62 101-4-2310-4105 FICA 2,650.00 229.89 2,482.78 93.69 167.22 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 30,000.00 100.00 0.00 101-4-2310-4107 Medicare 3,550.00 239.93 2,927.34 82.46 622.66 101-4-2310-4108 Insurance 30,950.00 2,357.80 26,533.82 85.73 4,416.18 101-4-2310-4109 Workers Comp 9,650.00 3,250.25 11,126.75 115.30 ( 1,476.75) 101-4-2310-4110 Re-employment Compensation 0.00 233.48 466.96 0.00 ( 466.96) TOTAL Personal Services 359,000.00 26,201.95 315,241.06 87.81 43,758.94 Supplies 101-4-2310-4201 Office Supplies 2,950.00 22.49 1,037.36 35.16 1,912.64 101-4-2310-4212 Fuels & Lubes 3,900.00 303.01 3,335.51 85.53 564.49 101-4-2310-4217 Uniform Allowance 3,500.00 324.49 1,388.41 39.67 2,111.59 101-4-2310-4219 Operating Supplies 1,200.00 26.99 1,529.58 127.47 ( 329.58) 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 12,050.00 676.98 7,290.86 60.51 4,759.14 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 254.42 2,515.20 91.46 234.80 101-4-2310-4322 Postage 650.00 231.69 732.27 112.66 ( 82.27) 101-4-2310-4331 Travel, Conferences & Schools 4,250.00 704.56 5,648.58 132.91 ( 1,398.58) 101-4-2310-4359 Publishing 750.00 398.80 398.80 53.17 351.20 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,104.28 15,794.92 88.99 1,955.08 101-4-2310-4401 Bldg Repair/Maint Services 7,500.00 721.85 9,535.90 127.15 ( 2,035.90) 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 989.21 2,294.21 77.77 655.79 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% 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 0.00 2,064.00 98.29 36.00 101-4-2310-4460 Equip Replacement Charge 56,500.00 4,708.33 51,791.63 91.67 4,708.37 TOTAL Other Services & Charges 110,000.00 9,113.14 99,448.01 90.41 10,551.99 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 481,050.00 35,992.07 421,979.93 87.72 59,070.07 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 14,969.26 157,603.97 83.52 31,096.03 101-4-2320-4105 FICA 11,700.00 890.23 9,425.66 80.56 2,274.34 101-4-2320-4107 Medicare 2,750.00 214.88 2,257.60 82.09 492.40 101-4-2320-4109 Workers Comp 29,000.00 10,853.25 37,813.50 130.39 ( 8,813.50) TOTAL Personal Services 232,150.00 26,927.62 207,100.73 89.21 25,049.27 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 775.42 5,347.85 74.28 1,852.15 101-4-2320-4217 Uniform Allowance 8,600.00 663.97 6,160.57 71.63 2,439.43 101-4-2320-4219 Operating Supplies 76,950.00 2,059.79 78,170.93 101.59 ( 1,220.93) 101-4-2320-4221 Equipment Parts 9,400.00 57.98 10,327.65 109.87 ( 927.65) TOTAL Supplies 102,450.00 3,557.16 100,082.30 97.69 2,367.70 Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 442.59 3,674.92 83.52 725.08 101-4-2320-4331 Travel, Conferences & Schools 19,700.00 1,418.19 12,932.31 65.65 6,767.69 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 2,391.51 36,231.26 102.93 ( 1,031.26) 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 4,252.29 61,270.17 93.40 4,329.83 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 400,200.00 34,737.07 368,453.20 92.07 31,746.80 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4201 Office Supplies 0.00 0.00 35.25 0.00 ( 35.25) 101-4-2330-4219 Operating Supplies 7,200.00 0.00 4,816.21 66.89 2,383.79 TOTAL Supplies 7,200.00 0.00 4,851.46 67.38 2,348.54 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-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 399.57 4,172.24 92.72 327.76 101-4-2330-4404 Equip Repair/Maint Services 4,950.00 0.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 399.57 7,354.14 36.59 12,745.86 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,300.00 399.57 12,205.60 44.71 15,094.40 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 465,650.00 35,478.60 395,336.81 84.90 70,313.19 101-4-2410-4102 Overtime Pay 0.00 0.00 86.97 0.00 ( 86.97) 101-4-2410-4103 Part-time Pay 0.00 607.23 5,853.69 0.00 ( 5,853.69) 101-4-2410-4104 PERA 41,600.00 3,229.87 35,621.89 85.63 5,978.11 101-4-2410-4105 FICA 24,100.00 1,683.72 18,768.21 77.88 5,331.79 101-4-2410-4107 Medicare 6,750.00 466.27 5,229.74 77.48 1,520.26 101-4-2410-4108 Insurance 83,500.00 6,735.50 75,655.50 90.61 7,844.50 101-4-2410-4109 Workers Comp 2,250.00 485.50 1,678.00 74.58 572.00 TOTAL Personal Services 623,850.00 48,686.69 538,230.81 86.28 85,619.19 Supplies 101-4-2410-4201 Office Supplies 3,000.00 91.53 1,261.20 42.04 1,738.80 101-4-2410-4212 Fuels & Lubes 6,000.00 261.55 4,938.25 82.30 1,061.75 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 154.17 4,524.78 46.89 5,125.22 TOTAL Supplies 20,400.00 507.25 10,738.58 52.64 9,661.42 Other Services & Charges 101-4-2410-4321 Telephone 5,350.00 452.19 3,869.65 72.33 1,480.35 101-4-2410-4322 Postage 700.00 50.34 239.56 34.22 460.44 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 0.00 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 236.49 3,783.65 75.67 1,216.35 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 3,116.63 91.67 283.37 TOTAL Other Services & Charges 21,050.00 1,022.35 14,774.79 70.19 6,275.21 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 665,300.00 50,216.29 563,744.18 84.74 101,555.82 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 72,050.00 5,542.40 62,352.00 86.54 9,698.00 101-4-2420-4104 PERA 5,400.00 415.68 4,676.40 86.60 723.60 101-4-2420-4105 FICA 4,500.00 355.87 3,997.44 88.83 502.56 101-4-2420-4107 Medicare 1,050.00 83.23 934.88 89.04 115.12 101-4-2420-4108 Insurance 3,600.00 304.50 3,349.50 93.04 250.50 101-4-2420-4109 Workers Comp 350.00 70.75 244.00 69.71 106.00 TOTAL Personal Services 86,950.00 6,772.43 75,554.22 86.89 11,395.78 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 92.58 980.24 49.01 1,019.76 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 92.58 980.24 29.70 2,319.76 Other Services & Charges 101-4-2420-4321 Telephone 850.00 24.36 260.07 30.60 589.93 101-4-2420-4322 Postage 1,750.00 436.79 902.66 51.58 847.34 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 461.15 1,245.23 36.62 2,154.77 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 93,650.00 7,326.16 77,779.69 83.05 15,870.31 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 19,150.00 1,330.30 14,372.54 75.05 4,777.46 101-4-2440-4104 PERA 1,450.00 99.77 955.43 65.89 494.57 101-4-2440-4105 FICA 1,200.00 82.65 898.27 74.86 301.73 101-4-2440-4107 Medicare 300.00 19.33 209.96 69.99 90.04 101-4-2440-4108 Insurance 2,400.00 188.55 1,708.93 71.21 691.07 101-4-2440-4109 Workers Comp 300.00 57.75 216.75 72.25 83.25 TOTAL Personal Services 24,800.00 1,778.35 18,361.88 74.04 6,438.12 Supplies 101-4-2440-4201 Office Supplies 1,500.00 4.28 1,671.17 111.41 ( 171.17) 101-4-2440-4212 Fuels & Lubes 300.00 7.96 94.37 31.46 205.63 101-4-2440-4219 Operating Supplies 5,000.00 0.00 738.27 14.77 4,261.73 TOTAL Supplies 6,800.00 12.24 2,503.81 36.82 4,296.19 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2440-4321 Telephone 850.00 0.00 90.00 10.59 760.00 101-4-2440-4322 Postage 1,000.00 9.61 24.72 2.47 975.28 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 216.53 1,331.53 95.11 68.47 101-4-2440-4359 Publishing 1,000.00 0.00 56.00 5.60 944.00 101-4-2440-4409 Contractual Services 11,000.00 0.00 2,437.00 22.15 8,563.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 15,400.00 226.14 3,939.25 25.58 11,460.75 ___________________________________________________________________________________________________________________ TOTAL Environmental 47,000.00 2,016.73 24,804.94 52.78 22,195.06 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,856,750.00 503,138.06 5,585,769.06 81.46 1,270,980.94 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 502,550.00 45,320.74 477,132.99 94.94 25,417.01 101-4-3120-4102 Overtime Pay 4,000.00 0.00 1,392.83 34.82 2,607.17 101-4-3120-4103 Part-time Pay 81,400.00 4,562.70 72,046.98 88.51 9,353.02 101-4-3120-4104 PERA 42,450.00 3,740.51 39,729.12 93.59 2,720.88 101-4-3120-4105 FICA 36,450.00 2,967.08 33,032.13 90.62 3,417.87 101-4-3120-4107 Medicare 8,550.00 693.94 7,725.28 90.35 824.72 101-4-3120-4108 Insurance 79,650.00 6,741.26 69,454.86 87.20 10,195.14 101-4-3120-4109 Workers Comp 30,900.00 8,791.25 31,272.50 101.21 ( 372.50) 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 72,817.48 733,258.37 93.30 52,691.63 Supplies 101-4-3120-4201 Office Supplies 1,500.00 135.27 1,486.76 99.12 13.24 101-4-3120-4212 Fuels & Lubes 45,000.00 16,557.92 40,863.02 90.81 4,136.98 101-4-3120-4219 Operating Supplies 56,500.00 5,939.78 46,765.05 82.77 9,734.95 101-4-3120-4221 Equipment Parts 52,000.00 4,946.86 42,171.77 81.10 9,828.23 101-4-3120-4226 Street Signs 31,500.00 555.64 26,587.80 84.41 4,912.20 TOTAL Supplies 186,500.00 28,135.47 157,874.40 84.65 28,625.60 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 603.43 5,818.86 79.71 1,481.14 101-4-3120-4322 Postage 100.00 24.53 71.46 71.46 28.54 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 2,357.00 46.22 2,743.00 101-4-3120-4359 Publishing 200.00 0.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 4,384.93 68,746.63 74.08 24,053.37 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 1,114.91 20,361.78 101.81 ( 361.78) 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 842.90 10,243.43 113.82 ( 1,243.43) 101-4-3120-4409 Contractual Services 63,500.00 11,308.79 71,868.46 113.18 ( 8,368.46) 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Works 91.67% 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 638.88 3,188.57 54.98 2,611.43 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 97,166.63 91.67 8,833.37 TOTAL Other Services & Charges 332,350.00 27,751.70 300,483.76 90.41 31,866.24 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,304,800.00 128,704.65 1,191,616.53 91.33 113,183.47 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 140,000.00 301.04 29,272.66 20.91 110,727.34 101-4-3130-4102 Overtime Pay 20,000.00 1,201.24 10,507.03 52.54 9,492.97 101-4-3130-4104 PERA 11,550.00 113.43 2,647.14 22.92 8,902.86 101-4-3130-4105 FICA 9,950.00 88.83 2,213.09 22.24 7,736.91 101-4-3130-4107 Medicare 2,300.00 20.78 523.74 22.77 1,776.26 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 2,485.50 8,749.50 99.43 50.50 TOTAL Personal Services 213,650.00 4,210.82 59,184.16 27.70 154,465.84 Supplies 101-4-3130-4219 Operating Supplies 92,300.00 72.75 69,374.73 75.16 22,925.27 TOTAL Supplies 92,300.00 72.75 69,374.73 75.16 22,925.27 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 305,950.00 4,283.57 128,558.89 42.02 177,391.11 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 117,150.00 9,124.80 101,381.45 86.54 15,768.55 101-4-3150-4102 Overtime Pay 3,000.00 0.00 1,411.92 47.06 1,588.08 101-4-3150-4104 PERA 9,000.00 684.36 7,709.51 85.66 1,290.49 101-4-3150-4105 FICA 7,450.00 549.57 6,201.71 83.24 1,248.29 101-4-3150-4107 Medicare 1,750.00 128.53 1,450.40 82.88 299.60 101-4-3150-4108 Insurance 15,900.00 1,337.00 14,707.00 92.50 1,193.00 101-4-3150-4109 Workers Comp 3,400.00 808.50 2,839.50 83.51 560.50 TOTAL Personal Services 157,650.00 12,632.76 135,701.49 86.08 21,948.51 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 355.82) 5,026.29 98.55 73.71 101-4-3150-4219 Operating Supplies 11,150.00 275.33 12,094.61 108.47 ( 944.61) 101-4-3150-4221 Equipment Parts 4,500.00 ( 1,942.78)( 638.63) 14.19- 5,138.63 TOTAL Supplies 20,750.00 ( 2,023.27) 16,482.27 79.43 4,267.73 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 0.00 3,899.91 31.20 8,600.09 101-4-3150-4417 Uniform Rental 2,150.00 31.96 1,309.25 60.90 840.75 TOTAL Other Services & Charges 17,650.00 31.96 6,366.31 36.07 11,283.69 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 196,050.00 10,641.45 158,550.07 80.87 37,499.93 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 170,400.00 13,105.73 147,439.42 86.53 22,960.58 101-4-3300-4102 Overtime Pay 0.00 70.27 70.27 0.00 ( 70.27) 101-4-3300-4104 PERA 12,800.00 988.20 11,063.20 86.43 1,736.80 101-4-3300-4105 FICA 10,550.00 848.53 9,016.77 85.47 1,533.23 101-4-3300-4107 Medicare 2,450.00 198.45 2,108.76 86.07 341.24 101-4-3300-4108 Insurance 7,200.00 609.00 15,929.00 221.24 ( 8,729.00) 101-4-3300-4109 Workers Comp 800.00 167.00 576.50 72.06 223.50 TOTAL Personal Services 204,200.00 15,987.18 186,203.92 91.19 17,996.08 Supplies 101-4-3300-4201 Office Supplies 150.00 8.57 216.39 144.26 ( 66.39) 101-4-3300-4212 Fuels & Lubes 1,000.00 35.51 713.23 71.32 286.77 101-4-3300-4219 Operating Supplies 2,500.00 128.65 3,364.22 134.57 ( 864.22) TOTAL Supplies 3,650.00 172.73 4,293.84 117.64 ( 643.84) 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 124.36 954.04 68.15 445.96 101-4-3300-4322 Postage 350.00 52.17 236.26 67.50 113.74 101-4-3300-4331 Travel, Conferences & Schools 1,500.00 0.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,375.00 91.67 125.00 TOTAL Other Services & Charges 10,650.00 301.53 4,324.90 40.61 6,325.10 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 218,500.00 16,461.44 194,822.66 89.16 23,677.34 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,025,300.00 160,091.11 1,673,548.15 82.63 351,751.85 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 405,150.00 32,367.03 352,979.48 87.12 52,170.52 101-4-5110-4102 Overtime Pay 6,600.00 464.64 4,208.13 63.76 2,391.87 101-4-5110-4103 Part-time Pay 68,250.00 1,824.00 51,858.96 75.98 16,391.04 101-4-5110-4104 PERA 30,900.00 2,462.06 26,683.53 86.35 4,216.47 101-4-5110-4105 FICA 29,250.00 2,006.81 23,846.04 81.52 5,403.96 101-4-5110-4107 Medicare 6,900.00 469.33 5,570.72 80.74 1,329.28 101-4-5110-4108 Insurance 79,300.00 5,799.50 67,482.50 85.10 11,817.50 101-4-5110-4109 Workers Comp 12,250.00 4,572.25 16,057.75 131.08 ( 3,807.75) 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 49,965.62 550,912.11 86.27 87,687.89 Supplies 101-4-5110-4212 Fuels & Lubes 25,000.00 1,192.97 17,851.45 71.41 7,148.55 101-4-5110-4217 Uniform Allowance 3,800.00 120.00 2,808.05 73.90 991.95 101-4-5110-4219 Operating Supplies 97,000.00 9,828.94 85,751.41 88.40 11,248.59 101-4-5110-4221 Equipment Parts 27,000.00 92.28 17,547.49 64.99 9,452.51 TOTAL Supplies 152,800.00 11,234.19 123,958.40 81.12 28,841.60 Other Services & Charges 101-4-5110-4321 Telephone 5,050.00 422.87 3,491.07 69.13 1,558.93 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 476.12 2,951.70 61.49 1,848.30 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 7,610.07 73,869.01 97.20 2,130.99 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 2,372.85 9,330.57 56.55 7,169.43 101-4-5110-4409 Contractual Services 45,100.00 3,163.52 29,558.07 65.54 15,541.93 101-4-5110-4415 Equipment Rental 22,200.00 1,425.00 24,055.09 108.36 ( 1,855.09) 101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 47,025.00 91.67 4,275.00 TOTAL Other Services & Charges 256,550.00 19,745.43 226,223.07 88.18 30,326.93 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,047,950.00 80,945.24 901,093.58 85.99 146,856.42 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 304,750.00 23,553.88 263,663.52 86.52 41,086.48 101-4-5210-4102 Overtime Pay 0.00 0.00 1,624.41 0.00 ( 1,624.41) 101-4-5210-4103 Part-time Pay 51,150.00 3,981.21 42,921.68 83.91 8,228.32 101-4-5210-4104 PERA 26,700.00 2,065.15 23,127.75 86.62 3,572.25 101-4-5210-4105 FICA 22,050.00 1,626.28 18,249.28 82.76 3,800.72 101-4-5210-4107 Medicare 5,150.00 380.34 4,267.97 82.87 882.03 101-4-5210-4108 Insurance 41,700.00 3,508.00 38,588.00 92.54 3,112.00 101-4-5210-4109 Workers Comp 3,900.00 904.75 3,937.75 100.97 ( 37.75) TOTAL Personal Services 455,400.00 36,019.61 396,380.36 87.04 59,019.64 Supplies 101-4-5210-4219 Operating Supplies 8,600.00 ( 66.73) 10,019.02 116.50 ( 1,419.02) TOTAL Supplies 8,600.00 ( 66.73) 10,019.02 116.50 ( 1,419.02) Other Services & Charges 101-4-5210-4321 Telephone 6,750.00 340.36 2,767.96 41.01 3,982.04 101-4-5210-4322 Postage 5,300.00 203.91 727.23 13.72 4,572.77 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 1,174.03 7,890.60 89.16 959.40 101-4-5210-4349 Advertising/Marketing 33,200.00 546.92 19,151.26 57.68 14,048.74 101-4-5210-4361 Insurance 450.00 0.00 415.50 92.33 34.50 101-4-5210-4389 Utilities 11,300.00 692.27 8,432.26 74.62 2,867.74 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 1,175.00 12,102.69 70.36 5,097.31 101-4-5210-4404 Equip Repair/Maint Services 8,600.00 1,306.46 7,799.70 90.69 800.30 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 5,438.95 61,802.20 65.78 32,147.80 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 557,950.00 41,391.83 468,201.58 83.91 89,748.42 Recreation Programs =================== Personal Services 101-4-5220-4102 Overtime Pay 0.00 0.00 39.21 0.00 ( 39.21) 101-4-5220-4103 Part-time Pay 82,000.00 1,725.37 68,856.91 83.97 13,143.09 101-4-5220-4104 PERA 1,900.00 90.30 1,800.41 94.76 99.59 101-4-5220-4105 FICA 5,100.00 106.97 4,302.22 84.36 797.78 101-4-5220-4107 Medicare 1,200.00 25.02 1,006.19 83.85 193.81 TOTAL Personal Services 90,200.00 1,947.66 76,004.94 84.26 14,195.06 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5220-4219 Operating Supplies 25,000.00 960.94 13,022.23 52.09 11,977.77 TOTAL Supplies 25,000.00 960.94 13,022.23 52.09 11,977.77 Other Services & Charges 101-4-5220-4409 Contractual Services 54,000.00 884.00 51,768.50 95.87 2,231.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 83.01 3,026.91 84.08 573.09 TOTAL Other Services & Charges 59,250.00 967.01 55,381.91 93.47 3,868.09 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 174,450.00 3,875.61 144,409.08 82.78 30,040.92 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 124,600.00 9,584.00 107,819.98 86.53 16,780.02 101-4-5510-4103 Part-time Pay 9,750.00 537.50 7,862.25 80.64 1,887.75 101-4-5510-4104 PERA 10,100.00 718.80 8,086.50 80.06 2,013.50 101-4-5510-4105 FICA 8,350.00 622.34 7,116.52 85.23 1,233.48 101-4-5510-4107 Medicare 1,950.00 145.55 1,664.34 85.35 285.66 101-4-5510-4108 Insurance 23,000.00 1,583.00 17,413.00 75.71 5,587.00 101-4-5510-4109 Workers Comp 650.00 173.50 601.75 92.58 48.25 TOTAL Personal Services 178,400.00 13,364.69 150,564.34 84.40 27,835.66 Supplies 101-4-5510-4219 Operating Supplies 10,750.00 776.62 7,293.19 67.84 3,456.81 TOTAL Supplies 10,750.00 776.62 7,293.19 67.84 3,456.81 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 111.25 1,096.88 45.70 1,303.12 101-4-5510-4322 Postage 3,000.00 12.69 1,863.09 62.10 1,136.91 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.65 16,839.69 79.06 4,460.31 101-4-5510-4401 Bldg Repair/Maint Services 16,500.00 1,747.32 15,807.59 95.80 692.41 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 1,658.09 23,501.08 197.49 ( 11,601.08) 101-4-5510-4433 Dues & Subscriptions 800.00 105.69 600.86 75.11 199.14 TOTAL Other Services & Charges 60,450.00 5,463.69 61,659.00 102.00 ( 1,209.00) 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Culture & Recreation 91.67% 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 19,605.00 219,516.53 87.95 30,083.47 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,029,950.00 145,817.68 1,733,220.77 85.38 296,729.23 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 0.00 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 ( 15.00) 1,231.92 0.00 ( 1,231.92) 101-4-6210-4105 FICA 0.00 ( 18.59) 1,020.78 0.00 ( 1,020.78) 101-4-6210-4107 Medicare 0.00 ( 8.68) 238.72 0.00 ( 238.72) 101-4-6210-4108 Insurance 0.00 0.00 2,272.20 0.00 ( 2,272.20) TOTAL Personal Services 0.00 ( 42.27) 22,239.18 0.00 ( 22,239.18) Other Services & Charges 101-4-6210-4322 Postage 0.00 95.56 95.56 0.00 ( 95.56) 101-4-6210-4361 Insurance 0.00 0.00 ( 73.00) 0.00 73.00 101-4-6210-4440 Miscellaneous 0.00 ( 84.99) 84.08 0.00 ( 84.08) TOTAL Other Services & Charges 0.00 10.57 106.64 0.00 ( 106.64) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 31.70) 22,345.82 0.00 ( 22,345.82) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 19,150.00 1,330.31 14,372.66 75.05 4,777.34 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.78 959.76 66.19 490.24 101-4-6220-4105 FICA 1,200.00 82.66 907.88 75.66 292.12 101-4-6220-4107 Medicare 300.00 19.34 216.70 72.23 83.30 101-4-6220-4108 Insurance 2,400.00 188.56 1,708.94 71.21 691.06 TOTAL Personal Services 24,500.00 1,720.65 24,665.94 100.68 ( 165.94) 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 12-13-2017 08:27 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 101-GENERAL FUND Economic Development 91.67% 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 0.00 4,666.21 84.84 833.79 101-4-6220-4359 Publishing 1,000.00 0.00 652.40 65.24 347.60 TOTAL Other Services & Charges 9,000.00 0.00 5,428.61 60.32 3,571.39 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,800.00 1,720.65 30,153.41 89.21 3,646.59 ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,800.00 1,688.95 52,499.23 155.32 ( 18,699.23) Transfers Out ============= Transfers Out 101-4-7000-4720 Transfers 0.00 119,382.35 119,382.35 0.00 ( 119,382.35) 101-4-7000-4725 Transfer-Capital Outlay Reserv 0.00 147,449.65 147,449.65 0.00 ( 147,449.65) TOTAL Transfers Out 0.00 266,832.00 266,832.00 0.00 ( 266,832.00) ___________________________________________________________________________________________________________________ TOTAL Transfers Out 0.00 266,832.00 266,832.00 0.00 ( 266,832.00) ___________________________________________________________________________________________________________________ TOTAL General 0.00 266,832.00 266,832.00 0.00 ( 266,832.00) ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 14,378,400.00 1,337,901.11 12,204,628.96 84.88 2,173,771.04 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 1,147,686.62)( 2,634,787.03) 2,634,787.03 Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Sales and cost of sales: Sales 7,004,150$ 6,206,892$ 797,258$ 88.62% Cost of sales (5,008,100) (4,103,444) (904,656) 81.94% Gross profit 1,996,050 2,103,448 (107,398) 105.38% Operating revenues: User charges - - - 0.00%1,915,000$ 1,683,979$ 231,021$ 87.94%1,366,000$ 1,126,079$ 239,921$ 82.44%445,000$ 381,234$ 63,766$ 85.67% Delinquency collections - - - 0.00%2,000 612 1,388 30.60%10,500 3,584 6,916 34.13%- 1,273 (1,273) 0.00% Other 1,700 4,220 (2,520) 248.24%2,000 51,799 (49,799) 2589.95%2,500 919 1,581 36.76%- - - 0.00% Total operating revenues 1,700 4,220 (2,520) 248.24%1,919,000 1,736,390 182,610 90.48%1,379,000 1,130,582 248,418 81.99%445,000 382,507 62,493 85.96% Operating expenses: Personal services 663,300 597,748 65,552 90.12%550,800 493,183 57,617 89.54%24,450 18,123 6,327 74.12%86,000 68,134 17,866 79.23% Supplies 20,700 11,243 9,457 54.31%206,800 146,399 60,401 70.79%21,400 16,048 5,352 74.99%2,000 188 1,812 9.40% Other service charges 241,500 221,769 19,731 91.83%552,000 495,405 56,595 89.75%1,457,200 1,233,571 223,629 84.65%458,200 236,338 221,862 51.58% Depreciation *125,000 - 125,000 0.00%1,425,000 - 1,425,000 0.00%- - - 0.00%448,000 - 448,000 0.00% Total operating expenses 1,050,500 830,760 219,740 79.08%2,734,600 1,134,987 1,599,613 41.50%1,503,050 1,267,742 235,308 84.34%994,200 304,660 689,540 30.64% Operating income (loss)947,250 1,276,908 (329,658) 134.80%(815,600) 601,403 (1,417,003) -73.74%(124,050) (137,160) 13,110 110.57%(549,200) 77,847 (627,047) -14.17% Nonoperating revenues (expenses): Interest income 35,000 51,774 (16,774) 147.93%80,000 51,523 28,477 64.40%8,000 4,451 3,549 55.64%4,000 6,513 (2,513) 162.83% Grant revenue - - - 0.00%- 163,561 (163,561) 0.00%- - - 0.00%- - - 0.00% Interest expense - - - 0.00%(264,350) (152,970) (111,380) 57.87%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)35,000 51,774 (16,774) 147.93%(184,350) 62,114 (246,464) -33.69%8,000 4,451 3,549 55.64%4,000 6,513 (2,513) 162.83% Income (loss) before contributions and transfers 982,250 1,328,682 (346,432) 135.27%(999,950) 663,517 (1,663,467) -66.36%(116,050) (132,709) 16,659 114.36%(545,200) 84,360 (629,560) -15.47% Contributions - connection fees - - - 0.00%500,000 993,273 (493,273) 198.65%- - - 0.00%53,000 51,344 1,656 96.88% Transfers in - - - 0.00%- - - 0.00%44,600 - 44,600 0.00%- - - 0.00% Transfers out (762,850) (710,866) (51,984) 93.19%(130,000) (130,000) - 100.00%(46,150) (46,150) - 100.00%(15,000) (15,000) - 100.00% NET INCOME (LOSS)219,400 617,816 (398,416) 281.59%(629,950) 1,526,790 (2,156,740) -242.37%(117,600) (178,859) 61,259 152.09%(507,200) 120,704 (627,904) -23.80% Items reclassified to balance sheet at year end: Capital Outlay (100,500) (563,409) 462,909 560.61%(150,000) - (150,000) 0.00% Bond Payment (405,000) (405,000) - 100.00% Revenues over/(under) expenditures 219,400 617,816 (398,416) (1,135,450) 558,381 (1,693,831) (117,600) (178,859) 61,259 (657,200) 120,704 (777,904) -18.37% * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED NOVEMBER 30, 2017 Liquor Sewer Garbage 12-13-2017 08:32 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2017 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 16,277.78 ( 646.68) 15,631.10 101-1010 Cash - General Fund 5,148,268.31 ( 1,154,296.65) 3,993,971.66 211-1010 Cash - Library 420,766.33 ( 5,051.55) 415,714.78 221-1010 Cash - Ice Arena 386,445.95 56,454.53 442,900.48 222-1010 Cash - Pinewood Golf Course ( 27,992.47) ( 598.89) ( 28,591.36) 225-1010 Cash - Park Dedication 71,832.03 27,092.67 98,924.70 228-1010 Cash - Landfill 371,891.37 ( 9,975.45) 361,915.92 231-1010 Cash - Landfill Const Debris 749,432.86 0.00 749,432.86 240-1010 Cash - Micro Loan Fund 666,192.62 6,030.82 672,223.44 242-1010 Cash - State DEED 206,781.40 1,816.49 208,597.89 245-1010 Cash - Development Fund 589,826.50 ( 2,329.13) 587,497.37 290-1010 Cash - Capital Outlay Reserve 787,077.92 146,401.76 933,479.68 291-1010 Cash - Insurance Reserve 161,614.99 ( 4,903.93) 156,711.06 292-1010 Cash - Govt Bldgs Reserve 2,041,296.75 93,924.60 2,135,221.35 294-1010 Cash - Drug Forfeiture 21,223.11 2,396.30 23,619.41 295-1010 Cash - Severance Pay Reserve 73,219.76 0.00 73,219.76 296-1010 Cash - GRE Reserve 1,930,514.41 0.00 1,930,514.41 313-1010 Cash - 2007C/2012B GO Bonds 161,111.15 0.00 161,111.15 333-1010 Cash - 2010A GO Cap Imp Bonds 681,518.55 0.00 681,518.55 401-1010 Cash - Pavement Mgmt 3,198,047.65 ( 563,378.41) 2,634,669.24 403-1010 Cash - Street Improvement 1,008,240.81 ( 149,694.64) 858,546.17 406-1010 Cash - City Wide Trunk Util 3,803,232.66 0.00 3,803,232.66 410-1010 Cash - Equipment Replacement 863,101.22 24,120.82 887,222.04 440-1010 Cash - Park Improvement 298,624.39 47,777.05 346,401.44 463-1010 Cash - TIF #23 Pref Powder 1,768.65 0.00 1,768.65 602-1010 Cash - Wastewater Treatment 3,673,886.95 104,636.96 3,778,523.91 603-1010 Cash - Liquor 3,525,187.97 105,678.48 3,630,866.45 605-1010 Cash - Garbage 240,521.69 ( 11,790.61) 228,731.08 607-1010 Cash - Storm Water 541,558.11 32,855.13 574,413.24 801-1010 Cash - Interest 0.00 92,504.05 92,504.05 821-1010 Cash - Developer Escrow 392,393.54 725,834.45 1,118,227.99_ TOTAL CLAIM ON CASH 32,003,862.96 ( 435,141.83) 31,568,721.13 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 90,007,509.89 497,699.53 90,505,209.42 999-1001 PY BANK ACCOUNT (86,385,836.49) ( 932,841.36) (87,318,677.85) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 32,003,862.96 ( 435,141.83) 31,568,721.13 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 32,003,862.96 ( 435,141.83) 31,568,721.13 =============== ============== ============== 222-PINEWOOD GOLF COURSE MONTH OF YTD YTD YTD REVENUES:NOVEMBER ACTUAL ERGC CITY Charges for Services 222-3-0000-3467 Concessions - 5,199.87 5,199.87 - 222-3-0000-3469 Other Sales - 2,169.44 2,169.44 - 222-3-0000-3476 Green Fees - 65,018.69 65,018.69 - 222-3-0000-3477 Membership Fees - 5,300.00 5,300.00 - 222-3-0000-3478 Golf Cart Rental - 13,172.49 13,172.49 - 222-3-0000-3792 Cash Over - 0.60 0.60 - TOTAL Charges for Services - 90,861.09 90,861.09 - TOTAL REVENUE - 90,861.09 90,861.09 - EXPENDITURES: Supplies 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 (375.13) 4,580.75 4,580.75 - TOTAL Supplies (375.13) 14,475.29 13,987.01 488.28 Other Services & Charges 222-4-5300-4319 Management Fee - 24,000.00 - 24,000.00 222-4-5300-4349 Advertising/Marketing - 1,436.00 1,436.00 - 222-4-5300-4389 Utilities 692.82 5,136.66 1,849.58 3,287.08 222-4-5300-4401 Building Maintenance - 1,764.09 1,178.09 586.00 222-4-5300-4404 Grounds Maintenance 2,028.62 12,898.32 12,668.32 230.00 222-4-5300-4409 Contractual Svcs - Wages/Taxes 1,303.42 68,211.12 68,211.12 - 222-4-5300-4415 Equipment Rental - 374.06 374.06 - 222-4-5300-4437 Taxes & Licenses - 525.00 525.00 - 222-4-5300-4438 Bank/Credit Card Fees 90.33 1,756.76 1,756.76 - TOTAL Other Services & Charges 4,115.19 116,102.01 87,998.93 28,103.08 TOTAL EXPENDITURES 3,740.06 130,577.30 101,985.94 28,591.36 REVENUES OVER/(UNDER) EXPENDITURES (3,740.06) (39,716.21) (11,124.85) (28,591.36) CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30, 2017