Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 09-18-2017
Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: September 18, 2017 Subject: August 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 Enterprise Fund and Pinewood Golf Course Special Revenue Fund. These funds provide an important picture of the city's financial health. For the month of August, actual revenues (except for property taxes and state aids) and expenditures should run about 67% 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 57% of budget. The second-half property tax settlement will be received in early December. ■ Licenses and permits collections are 116% of annual budget estimates,with building- related permit collections at 122% and rental licenses at 127% as of the end of August. ■ Charges for services are 88% of budget estimates,with collections of plan review fees and the annual Otsego fire contract making up the majority share. ■ Although fines and forfeits collections lag a month,reported collections through July are about 72% of budget estimates. p 0 W I H L 0 N' AfURE] Expenditures: ■ Total departmental expenditures are 61% of budget and most departments are at or below budget estimates. The 3rd quarter premium for property/liability insurance is reflected in August expenditures. 2017 Monthly Expenditures $16,000 $14,000 ode o $12,000 $10,000 CA O $8,000 ~ $6,000 $4,000 $2,000 =Actual $831 1$1,8961$)3,0211$4,0181$5,1031$6,5681$7,6211$8,7611 Budget $1,198 $2,3961 3,595 $4,793 $5,991 $7,189 $8,387 $9,586 $10,78 $11,98 $13,218 ICE ARENA As of the end of August, revenues of$449,684 exceed expenditures of$432,701 by$16,983. Ice rental revenues of$259,514 are about 48% of budget estimates. Overall,revenues and expenditures are in line with budget estimates year to date. PINEWOOD GOLF Through the end of July, expenditures of$74,600 exceed revenues of$56,524 by$18,076. August financials are not yet available. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds ■ Pinewood Revenue&Expense -July 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND FINANCIAL SUMMARY 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 14,378,400.00 279,381.77 8,463,203.66 58.86 5,915,196.34 TOTAL REVENUES 14,378,400.00 279,381.77 8,463,203.66 58.86 5,915,196.34 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 148,800.00 27,343.24 78,839.88 52.98 69,960.12 Cable TV 111,300.00 7,474.92 62,278.42 55.96 49,021.58 Administrative Services 594,450.00 42,585.32 367,047.33 61.75 227,402.67 Human Resources 234,450.00 29,697.89 141,059.58 60.17 93,390.42 Elections 6,600.00 13.44 6,313.44 95.66 286.56 Finance 572,200.00 36,465.47 384,285.47 67.16 187,914.53 Information Technology 385,100.00 21,035.58 244,082.73 63.38 141,017.27 Legal 220,000.00 17,457.99 124,182.51 56.45 95,817.49 Community Development 223,400.00 17,161.43 141,159.46 63.19 82,240.54 Planning 297,450.00 22,770.20 186,164.29 62.59 111,285.71 City Hall Maintenance 638,850.00 49,407.85 392,508.71 61.44 246,341.29 TOTAL General Government 3,432,600.00 271,413.33 2,127,921.82 61.99 1,304,678.18 Public Safety Police Administration 762,900.00 57,310.93 454,462.32 59.57 308,437.68 Patrol 2,495,550.00 174,968.38 1,449,962.81 58.10 1,045,587.19 Investigations 1,029,350.00 70,468.83 588,158.71 57.14 441,191.29 Police Support Services 676,100.00 45,581.37 417,859.71 61.80 258,240.29 Police Reserves 21,450.00 2,181.69 7,364.54 34.33 14,085.46 Public safety building 156,900.00 11,245.41 87,505.43 55.77 69,394.57 Fire Administration 481,050.00 36,083.53 318,975.25 66.31 162,074.75 Fire Operations 400,200.00 46,857.48 270,174.37 67.51 130,025.63 Emergency Management 27,300.00 1,152.71 8,789.73 32.20 18,510.27 Building Safety 665,300.00 48,805.74 416,452.69 62.60 248,847.31 Code Enforcement 93,650.00 6,838.31 56,792.04 60.64 36,857.96 Environmental 47,000.00 2,259.66 19,131.14 40.70 27,868.86 TOTAL Public Safety 6,856,750.00 503,754.04 4,095,628.74 59.73 2,761,121.26 Public Works Street Maintenance 1,304,800.00 114,725.36 843,810.56 64.67 460,989.44 Snow Removal 305,950.00 74.40 124,124.55 40.57 181,825.45 Equipment Services 196,050.00 12,471.18 112,075.16 57.17 83,974.84 Engineering 218,500.00 17,270.89 143,320.18 65.59 75,179.82 TOTAL Public Works 2,025,300.00 144,541.83 1,223,330.45 60.40 801,969.55 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND FINANCIAL SUMMARY 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,047,950.00 114,672.16 639,146.09 60.99 408,803.91 Parks & Rec Admin 557,950.00 51,565.79 347,130.26 62.22 210,819.74 Recreation Programs 174,450.00 29,861.06 118,709.10 68.05 55,740.90 Sr Citizen Programs 249,600.00 23,902.05 163,804.43 65.63 85,795.57 TOTAL Culture & Recreation 2,029,950.00 220,001.06 1,268,789.88 62.50 761,160.12 Economic Development Economic Development 0.00 ( 2,334.69) 22,359.70 0.00 ( 22,359.70) Energy City 33,800.00 3,534.91 22,565.93 66.76 11,234.07 TOTAL Economic Development 33,800.00 1,200.22 44,925.63 132.92 ( 11,125.63) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 14,378,400.00 1,140,910.48 8,760,596.52 60.93 5,617,803.48 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 861,528.71)( 297,392.86) 297,392.86 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND 66.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 603.30 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 51,070.27 36.48 88,929.73 101-3-0000-3131 Penalties/Interest 0.00 0.00 5,370.92 0.00 ( 5,370.92) TOTAL Taxes 10,109,250.00 603.30 5,185,684.54 51.30 4,923,565.46 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 ( 4,686.67) 66,456.70 98.45 1,043.30 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 0.00 300.00 9.68 2,800.00 101-3-0000-3214 Rental License 45,000.00 4,240.00 57,224.00 127.16 ( 12,224.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 670.00 5,220.00 40.15 7,780.00 101-3-0000-3229 NPDES Permit 12,000.00 1,750.00 12,950.00 107.92 ( 950.00) 101-3-0000-3231 Building Permit 415,000.00 29,412.20 436,887.74 105.27 ( 21,887.74) 101-3-0000-3232 Plumbing/Heating Permit 118,000.00 21,085.22 213,237.53 180.71 ( 95,237.53) 101-3-0000-3233 Permit Surcharge 1,500.00 ( 873.32) 2,824.56 188.30 ( 1,324.56) 101-3-0000-3235 Animal License 6,000.00 260.00 2,350.00 39.17 3,650.00 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 1,800.00 11,110.00 138.88 ( 3,110.00) TOTAL Licenses & Permits 714,950.00 53,657.43 826,788.98 115.64 ( 111,838.98) Intergovernmental Rev 101-3-0000-3322 MV Credit 5,000.00 0.00 0.00 0.00 5,000.00 101-3-0000-3324 PERA Aid 14,000.00 ( 2,194.50) 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 239,500.00 0.00 0.00 0.00 239,500.00 101-3-0000-3326 Police Training Reimb 10,000.00 10,173.66 10,173.66 101.74 ( 173.66) 101-3-0000-3329 State Crime Prevention Grant 25,000.00 4,104.21 10,670.54 42.68 14,329.46 TOTAL Intergovernmental Rev 293,500.00 12,083.37 27,836.20 9.48 265,663.80 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 30,000.00 4,025.00 22,884.70 76.28 7,115.30 101-3-0000-3413 Plan Check Fee 145,000.00 10,827.71 217,998.84 150.34 ( 72,998.84) 101-3-0000-3415 Special Assessment Search 500.00 0.00 700.00 140.00 ( 200.00) 101-3-0000-3417 Copies 1,700.00 321.13 2,089.51 122.91 ( 389.51) 101-3-0000-3418 Other General Govt Services 5,000.00 255.25 2,865.25 57.31 2,134.75 101-3-0000-3430 Lockout Fees 7,000.00 495.00 3,935.00 56.21 3,065.00 101-3-0000-3431 Police Services 8,000.00 340.00 7,781.00 97.26 219.00 101-3-0000-3432 School Liaison 123,600.00 0.00 61,812.00 50.01 61,788.00 101-3-0000-3434 Animal Impound Fee 3,000.00 150.00 3,225.00 107.50 ( 225.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 ( 6.20) 258.15 12.91 1,741.85 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 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND 66.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 575.00 9,769.14 39.08 15,230.86 101-3-0000-3452 Engineering Services Reimb 125,000.00 0.00 82,307.24 65.85 42,692.76 101-3-0000-3461 Recreation Fees 96,000.00 8,231.17 55,766.48 58.09 40,233.52 101-3-0000-3462 Sr Center Activities 30,000.00 2,939.00 31,523.00 105.08 ( 1,523.00) 101-3-0000-3472 Park Use Fee 24,400.00 126.20 14,286.34 58.55 10,113.66 101-3-0000-3475 Building Rent 2,400.00 200.00 1,600.00 66.67 800.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 975.00 6,080.00 67.56 2,920.00 101-3-0000-3484 Contractor License Check 1,000.00 145.00 720.00 72.00 280.00 TOTAL Charges for Services 891,400.00 29,599.26 783,746.15 87.92 107,653.85 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 13,630.64 104,660.77 72.18 40,339.23 101-3-0000-3511 Parking Fines 10,000.00 320.00 4,000.00 40.00 6,000.00 101-3-0000-3512 Ordinance Violations 0.00 0.00 75.00 0.00 ( 75.00) TOTAL Fines & Forfeits 155,000.00 13,950.64 108,735.77 70.15 46,264.23 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 54,376.01 60.42 35,623.99 101-3-0000-3625 Refunds & Reimbursements 101,000.00 ( 122.50) 129.59 0.13 100,870.41 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 483.86 3,521.37 54.17 2,978.63 TOTAL Other Revenue 217,500.00 361.36 74,026.97 34.04 143,473.03 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 109,576.41 582,252.60 56.26 452,747.40 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 34,800.00 34,800.00 100.00 0.00 101-3-0000-3949 Transfer-HRA 24,750.00 24,750.00 24,750.00 100.00 0.00 TOTAL Transfers In 1,996,800.00 169,126.41 1,456,385.05 72.94 540,414.95 _____________________________________________________________________________ TOTAL General Fund 14,378,400.00 279,381.77 8,463,203.66 58.86 5,915,196.34 ___________________________________________________________________________________________________________________ TOTAL REVENUE 14,378,400.00 279,381.77 8,463,203.66 58.86 5,915,196.34 ============= ============= ============= ======= ============= 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND 66.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 25,666.56 66.67 12,833.44 101-4-1110-4104 PERA 1,900.00 102.09 861.72 45.35 1,038.28 101-4-1110-4105 FICA 2,400.00 72.32 615.86 25.66 1,784.14 101-4-1110-4107 Medicare 550.00 46.57 389.65 70.85 160.35 101-4-1110-4109 Workers Comp 100.00 0.00 33.75 33.75 66.25 TOTAL Personal Services 43,450.00 3,429.30 27,567.54 63.45 15,882.46 Supplies 101-4-1110-4201 Office Supplies 800.00 1.70 360.93 45.12 439.07 TOTAL Supplies 800.00 1.70 360.93 45.12 439.07 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 0.00 512.12 19.70 2,087.88 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 8,308.00 26,213.00 64.25 14,587.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 0.00 0.00 0.00 19,550.00 101-4-1110-4440 Miscellaneous 27,450.00 15,604.24 19,773.20 72.03 7,676.80 TOTAL Other Services & Charges 104,550.00 23,912.24 50,911.41 48.70 53,638.59 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 148,800.00 27,343.24 78,839.88 52.98 69,960.12 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 65,000.00 4,996.80 41,223.61 63.42 23,776.39 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 672.12 5,249.78 28.53 13,150.22 101-4-1120-4104 PERA 6,800.00 425.17 3,492.54 51.36 3,307.46 101-4-1120-4105 FICA 5,200.00 320.94 2,754.52 52.97 2,445.48 101-4-1120-4107 Medicare 1,200.00 75.05 644.20 53.68 555.80 101-4-1120-4108 Insurance 11,350.00 914.50 6,172.00 54.38 5,178.00 101-4-1120-4109 Workers Comp 400.00 0.00 200.25 50.06 199.75 TOTAL Personal Services 108,350.00 7,404.58 59,877.43 55.26 48,472.57 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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 70.34 1,598.29 79.91 401.71 TOTAL Supplies 2,000.00 70.34 1,598.29 79.91 401.71 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 Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 111,300.00 7,474.92 62,278.42 55.96 49,021.58 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 398,500.00 30,650.92 253,063.54 63.50 145,436.46 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,404.80 28,276.22 59.91 18,923.78 101-4-1210-4104 PERA 33,450.00 2,554.20 21,105.83 63.10 12,344.17 101-4-1210-4105 FICA 27,650.00 2,154.80 17,805.87 64.40 9,844.13 101-4-1210-4107 Medicare 6,450.00 503.93 4,164.26 64.56 2,285.74 101-4-1210-4108 Insurance 26,650.00 2,250.50 18,559.20 69.64 8,090.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,519.15 344,465.32 63.55 197,534.68 Supplies 101-4-1210-4201 Office Supplies 7,300.00 265.89 2,622.86 35.93 4,677.14 TOTAL Supplies 7,300.00 265.89 2,622.86 35.93 4,677.14 Other Services & Charges 101-4-1210-4319 Other Professional Services 13,000.00 0.00 7,944.06 61.11 5,055.94 101-4-1210-4321 Telephone 1,650.00 328.15 1,483.47 89.91 166.53 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 47.17 2,366.50 30.54 5,383.50 101-4-1210-4334 Car Allowance 4,800.00 400.00 3,200.00 66.67 1,600.00 101-4-1210-4361 Insurance 100.00 13.00 45.00 45.00 55.00 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 0.00 2,192.21 14.66 12,757.79 101-4-1210-4433 Dues & Subscriptions 2,900.00 11.96 2,173.78 74.96 726.22 TOTAL Other Services & Charges 45,150.00 800.28 19,959.15 44.21 25,190.85 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 594,450.00 42,585.32 367,047.33 61.75 227,402.67 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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 63,220.73 49.76 63,829.27 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 4,989.76 52.25 4,560.24 101-4-1220-4105 FICA 7,900.00 560.96 4,143.56 52.45 3,756.44 101-4-1220-4107 Medicare 1,850.00 131.18 969.05 52.38 880.95 101-4-1220-4108 Insurance 15,850.00 1,337.00 8,308.00 52.42 7,542.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.66 87,519.03 53.76 75,280.97 Supplies 101-4-1220-4201 Office Supplies 1,200.00 179.88 793.47 66.12 406.53 TOTAL Supplies 1,200.00 179.88 793.47 66.12 406.53 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 244.35 1,368.30 109.46 ( 118.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 0.00 1,235.38 17.16 5,964.62 101-4-1220-4404 Equip Repair/Maint 60,600.00 17,302.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 17,546.35 52,747.08 74.87 17,702.92 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 234,450.00 29,697.89 141,059.58 60.17 93,390.42 Elections ========= Personal Services _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1230-4331 Travel, Conferences & Schools 0.00 13.44 13.44 0.00 ( 13.44) 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 13.44 6,313.44 95.66 286.56 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 6,600.00 13.44 6,313.44 95.66 286.56 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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.53 190,990.42 63.03 112,009.58 101-4-1310-4103 Part-time Pay 54,700.00 3,997.44 34,554.42 63.17 20,145.58 101-4-1310-4104 PERA 26,850.00 2,069.90 16,928.62 63.05 9,921.38 101-4-1310-4105 FICA 22,200.00 1,657.76 13,570.46 61.13 8,629.54 101-4-1310-4107 Medicare 5,200.00 387.70 3,173.74 61.03 2,026.26 101-4-1310-4108 Insurance 40,600.00 3,091.70 24,738.10 60.93 15,861.90 101-4-1310-4109 Workers Comp 1,700.00 0.00 1,140.75 67.10 559.25 TOTAL Personal Services 454,250.00 34,806.03 285,096.51 62.76 169,153.49 Supplies 101-4-1310-4201 Office Supplies 5,000.00 16.97 695.35 13.91 4,304.65 TOTAL Supplies 5,000.00 16.97 695.35 13.91 4,304.65 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 279.93 20.74 1,070.07 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 27.26 252.26 6.47 3,647.74 101-4-1310-4359 Publishing 450.00 152.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 505.00 1,434.00 89.63 166.00 101-4-1310-4438 Credit Card Fees 5,800.00 825.22 4,632.75 79.88 1,167.25 101-4-1310-4440 Miscellaneous 1,500.00 93.00 765.30 51.02 734.70 TOTAL Other Services & Charges 112,950.00 1,642.47 98,493.61 87.20 14,456.39 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 572,200.00 36,465.47 384,285.47 67.16 187,914.53 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 196,400.00 10,630.62 113,791.98 57.94 82,608.02 101-4-1350-4104 PERA 14,750.00 797.30 8,056.22 54.62 6,693.78 101-4-1350-4105 FICA 12,200.00 600.22 6,380.74 52.30 5,819.26 101-4-1350-4107 Medicare 2,850.00 140.38 1,492.65 52.37 1,357.35 101-4-1350-4108 Insurance 34,400.00 1,623.00 19,321.50 56.17 15,078.50 101-4-1350-4109 Workers Comp 950.00 0.00 626.25 65.92 323.75 TOTAL Personal Services 261,550.00 13,791.52 149,669.34 57.22 111,880.66 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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 1,977.31 13,574.44 67.53 6,525.56 TOTAL Supplies 20,100.00 1,977.31 13,574.44 67.53 6,525.56 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 2,236.00 27.95 5,764.00 101-4-1350-4321 Telephone 2,800.00 160.81 1,215.46 43.41 1,584.54 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 1,750.00 11,346.66 88.99 1,403.34 101-4-1350-4404 Equip Repair/Maint Services 79,900.00 3,355.94 66,040.83 82.65 13,859.17 TOTAL Other Services & Charges 103,450.00 5,266.75 80,838.95 78.14 22,611.05 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 385,100.00 21,035.58 244,082.73 63.38 141,017.27 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 220,000.00 17,457.99 124,182.51 56.45 95,817.49 TOTAL Other Services & Charges 220,000.00 17,457.99 124,182.51 56.45 95,817.49 ___________________________________________________________________________________________________________________ TOTAL Legal 220,000.00 17,457.99 124,182.51 56.45 95,817.49 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 175,100.00 13,469.65 111,339.71 63.59 63,760.29 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 8,366.57 63.62 4,783.43 101-4-1500-4105 FICA 10,850.00 779.41 6,588.18 60.72 4,261.82 101-4-1500-4107 Medicare 2,550.00 182.28 1,540.79 60.42 1,009.21 101-4-1500-4108 Insurance 15,850.00 1,623.00 11,268.00 71.09 4,582.00 101-4-1500-4109 Workers Comp 850.00 0.00 558.00 65.65 292.00 TOTAL Personal Services 218,350.00 17,064.56 139,876.27 64.06 78,473.73 Supplies 101-4-1500-4201 Office Supplies 1,100.00 11.88 215.24 19.57 884.76 TOTAL Supplies 1,100.00 11.88 215.24 19.57 884.76 Other Services & Charges 101-4-1500-4321 Telephone 800.00 84.99 474.93 59.37 325.07 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 469.00 85.27 81.00 TOTAL Other Services & Charges 3,950.00 84.99 1,067.95 27.04 2,882.05 ___________________________________________________________________________________________________________________ TOTAL Community Development 223,400.00 17,161.43 141,159.46 63.19 82,240.54 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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.85 136,128.04 62.53 81,571.96 101-4-1510-4104 PERA 16,350.00 1,275.12 10,209.56 62.44 6,140.44 101-4-1510-4105 FICA 13,500.00 967.19 7,766.23 57.53 5,733.77 101-4-1510-4107 Medicare 3,150.00 226.20 1,816.30 57.66 1,333.70 101-4-1510-4108 Insurance 26,600.00 2,240.50 17,924.00 67.38 8,676.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 174,366.88 62.63 104,033.12 Supplies 101-4-1510-4201 Office Supplies 1,500.00 254.39 1,176.05 78.40 323.95 101-4-1510-4212 Fuels & Lubes 300.00 0.00 26.58 8.86 273.42 101-4-1510-4219 Operating Supplies 1,900.00 0.00 1,370.84 72.15 529.16 TOTAL Supplies 3,700.00 254.39 2,573.47 69.55 1,126.53 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 90.00 25.71 260.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 0.00 590.00 20.00 2,360.00 101-4-1510-4359 Publishing 8,000.00 552.00 5,608.00 70.10 2,392.00 101-4-1510-4361 Insurance 100.00 13.00 45.00 45.00 55.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 858.00 85.80 142.00 101-4-1510-4440 Miscellaneous 250.00 239.95 239.95 95.98 10.05 TOTAL Other Services & Charges 15,350.00 804.95 9,223.94 60.09 6,126.06 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,450.00 22,770.20 186,164.29 62.59 111,285.71 City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 354,300.00 27,432.06 225,426.41 63.63 128,873.59 101-4-1600-4102 Overtime Pay 3,500.00 0.00 275.27 7.86 3,224.73 101-4-1600-4103 Part-time Pay 3,550.00 723.98 2,813.96 79.27 736.04 101-4-1600-4104 PERA 26,850.00 2,057.40 16,958.59 63.16 9,891.41 101-4-1600-4105 FICA 22,400.00 1,742.30 14,228.15 63.52 8,171.85 101-4-1600-4107 Medicare 5,250.00 407.48 3,327.55 63.38 1,922.45 101-4-1600-4108 Insurance 50,300.00 4,157.50 33,260.00 66.12 17,040.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,520.72 304,547.43 63.63 174,052.57 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND General Government 66.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 291.88 1,250.26 41.68 1,749.74 101-4-1600-4217 Uniform Allowance 2,400.00 149.98 762.61 31.78 1,637.39 101-4-1600-4219 Operating Supplies 33,500.00 1,380.37 13,000.38 38.81 20,499.62 TOTAL Supplies 38,900.00 1,822.23 15,013.25 38.59 23,886.75 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 1,204.35 9,316.28 79.63 2,383.72 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 448.03 22.40 1,551.97 101-4-1600-4361 Insurance 5,150.00 1,228.00 3,764.50 73.10 1,385.50 101-4-1600-4389 Utilities 65,250.00 5,895.79 40,548.69 62.14 24,701.31 101-4-1600-4401 Bldg Repair/Maint Services 30,800.00 2,490.93 14,522.49 47.15 16,277.51 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 1,966.64 66.67 983.36 TOTAL Other Services & Charges 121,350.00 11,064.90 72,948.03 60.11 48,401.97 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 638,850.00 49,407.85 392,508.71 61.44 246,341.29 Contingency =========== Personal Services _____________ _____________ _____________ _______ _____________ Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,432,600.00 271,413.33 2,127,921.82 61.99 1,304,678.18 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 372,800.00 27,640.49 206,938.45 55.51 165,861.55 101-4-2110-4102 Overtime Pay 2,500.00 0.00 0.00 0.00 2,500.00 101-4-2110-4104 PERA 55,100.00 4,158.56 32,734.15 59.41 22,365.85 101-4-2110-4105 FICA 3,800.00 246.06 605.86 15.94 3,194.14 101-4-2110-4107 Medicare 5,400.00 389.56 2,892.79 53.57 2,507.21 101-4-2110-4108 Insurance 34,250.00 2,192.00 15,709.00 45.87 18,541.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 34,626.67 314,855.00 58.27 225,495.00 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 100.19 3,354.19 30.49 7,645.81 101-4-2110-4217 Uniform Allowance 3,000.00 299.96 1,637.71 54.59 1,362.29 101-4-2110-4219 Operating Supplies 23,500.00 135.00 6,496.23 27.64 17,003.77 TOTAL Supplies 37,500.00 535.15 11,488.13 30.64 26,011.87 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 4,512.65 6,539.80 82.78 1,360.20 101-4-2110-4321 Telephone 34,700.00 2,532.96 17,613.69 50.76 17,086.31 101-4-2110-4322 Postage 2,400.00 0.00 1,043.03 43.46 1,356.97 101-4-2110-4331 Travel, Conferences & Schools 14,800.00 4,100.00 7,313.00 49.41 7,487.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 42,000.00 9,939.00 30,572.00 72.79 11,428.00 101-4-2110-4404 Equip Repair/Maint Services 68,950.00 623.50 54,356.67 78.83 14,593.33 101-4-2110-4433 Dues & Subscriptions 13,600.00 408.00 10,560.00 77.65 3,040.00 101-4-2110-4437 Taxes & Licenses 200.00 33.00 121.00 60.50 79.00 TOTAL Other Services & Charges 185,050.00 22,149.11 128,119.19 69.23 56,930.81 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 762,900.00 57,310.93 454,462.32 59.57 308,437.68 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,612,400.00 117,184.06 972,078.25 60.29 640,321.75 101-4-2120-4102 Overtime Pay 100,000.00 3,117.77 40,893.97 40.89 59,106.03 101-4-2120-4104 PERA 277,400.00 19,488.87 164,093.32 59.15 113,306.68 101-4-2120-4107 Medicare 24,850.00 1,689.56 14,265.78 57.41 10,584.22 101-4-2120-4108 Insurance 174,100.00 12,645.00 101,160.00 58.10 72,940.00 TOTAL Personal Services 2,188,750.00 154,125.26 1,292,491.32 59.05 896,258.68 Supplies 101-4-2120-4212 Fuels & Lubes 78,000.00 6,597.13 47,089.40 60.37 30,910.60 101-4-2120-4217 Uniform Allowance 35,600.00 446.68 7,339.01 20.62 28,260.99 101-4-2120-4219 Operating Supplies 73,900.00 2,970.50 21,958.54 29.71 51,941.46 101-4-2120-4221 Equipment Parts 23,300.00 2,913.75 13,914.84 59.72 9,385.16 TOTAL Supplies 210,800.00 12,928.06 90,301.79 42.84 120,498.21 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 27,050.00 2,976.73 17,158.54 63.43 9,891.46 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 980.00 18,084.52 86.94 2,715.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 31,666.64 66.67 15,833.36 TOTAL Other Services & Charges 96,000.00 7,915.06 67,169.70 69.97 28,830.30 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,495,550.00 174,968.38 1,449,962.81 58.10 1,045,587.19 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 696,700.00 49,851.20 415,917.69 59.70 280,782.31 101-4-2130-4102 Overtime Pay 55,000.00 1,393.89 20,513.97 37.30 34,486.03 101-4-2130-4104 PERA 121,800.00 8,301.72 70,701.78 58.05 51,098.22 101-4-2130-4107 Medicare 9,550.00 700.96 6,015.96 62.99 3,534.04 101-4-2130-4108 Insurance 93,950.00 6,273.88 50,191.04 53.42 43,758.96 TOTAL Personal Services 977,000.00 66,521.65 563,340.44 57.66 413,659.56 Supplies 101-4-2130-4217 Uniform Allowance 6,950.00 28.85 3,109.39 44.74 3,840.61 101-4-2130-4219 Operating Supplies 10,600.00 1,938.66 6,330.74 59.72 4,269.26 TOTAL Supplies 17,550.00 1,967.51 9,440.13 53.79 8,109.87 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 418.00 1,062.00 14.16 6,438.00 101-4-2130-4331 Travel, Conferences & Schools 11,200.00 995.00 4,769.78 42.59 6,430.22 101-4-2130-4433 Dues & Subscriptions 2,100.00 ( 600.00) 213.00 10.14 1,887.00 101-4-2130-4460 Equip Replacement Charge 14,000.00 1,166.67 9,333.36 66.67 4,666.64 TOTAL Other Services & Charges 34,800.00 1,979.67 15,378.14 44.19 19,421.86 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,029,350.00 70,468.83 588,158.71 57.14 441,191.29 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 437,350.00 26,851.78 277,475.02 63.44 159,874.98 101-4-2150-4102 Overtime Pay 7,500.00 832.66 9,956.42 132.75 ( 2,456.42) 101-4-2150-4103 Part-time Pay 40,500.00 3,160.81 25,180.09 62.17 15,319.91 101-4-2150-4104 PERA 44,700.00 2,313.40 24,166.46 54.06 20,533.54 101-4-2150-4105 FICA 24,200.00 1,841.61 14,884.63 61.51 9,315.37 101-4-2150-4107 Medicare 5,650.00 430.70 3,481.08 61.61 2,168.92 101-4-2150-4108 Insurance 72,200.00 5,122.50 44,798.00 62.05 27,402.00 TOTAL Personal Services 632,100.00 40,553.46 399,941.70 63.27 232,158.30 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 81.35 136.27 13.63 863.73 101-4-2150-4217 Uniform Allowance 5,350.00 113.90 2,052.92 38.37 3,297.08 101-4-2150-4219 Operating Supplies 14,600.00 3,874.66 5,463.30 37.42 9,136.70 TOTAL Supplies 20,950.00 4,069.91 7,652.49 36.53 13,297.51 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,900.00 25.00 1,859.05 26.94 5,040.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 348.00 2,618.25 37.40 4,381.75 101-4-2150-4433 Dues & Subscriptions 550.00 60.00 235.00 42.73 315.00 101-4-2150-4460 Equip Replacement Charge 6,300.00 525.00 4,200.00 66.67 2,100.00 TOTAL Other Services & Charges 23,050.00 958.00 10,265.52 44.54 12,784.48 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 676,100.00 45,581.37 417,859.71 61.80 258,240.29 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 94.38 955.09 17.37 4,544.91 101-4-2160-4105 FICA 350.00 5.86 59.21 16.92 290.79 101-4-2160-4107 Medicare 100.00 1.37 13.86 13.86 86.14 TOTAL Personal Services 5,950.00 101.61 1,028.16 17.28 4,921.84 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 1,505.08 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 1,505.08 4,336.38 42.51 5,863.62 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 575.00 1,150.00 54.76 950.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,000.00 37.74 3,300.00 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 21,450.00 2,181.69 7,364.54 34.33 14,085.46 Public safety building ====================== 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 1,412.04 13,585.02 75.06 4,514.98 TOTAL Supplies 18,100.00 1,412.04 13,585.02 75.06 4,514.98 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 1,195.00 3,657.00 70.33 1,543.00 101-4-2190-4389 Utilities 95,500.00 7,159.19 51,671.27 54.11 43,828.73 101-4-2190-4401 Bldg Repair/Maint Services 38,100.00 1,479.18 18,592.14 48.80 19,507.86 TOTAL Other Services & Charges 138,800.00 9,833.37 73,920.41 53.26 64,879.59 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,900.00 11,245.41 87,505.43 55.77 69,394.57 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 246,050.00 19,188.15 155,014.03 63.00 91,035.97 101-4-2310-4104 PERA 36,150.00 2,812.00 22,798.50 63.07 13,351.50 101-4-2310-4105 FICA 2,650.00 229.90 1,793.10 67.66 856.90 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 266.25 2,154.90 60.70 1,395.10 101-4-2310-4108 Insurance 30,950.00 2,364.19 19,454.04 62.86 11,495.96 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 233.48 233.48 0.00 ( 233.48) TOTAL Personal Services 359,000.00 25,093.97 239,324.55 66.66 119,675.45 Supplies 101-4-2310-4201 Office Supplies 2,950.00 0.00 945.45 32.05 2,004.55 101-4-2310-4212 Fuels & Lubes 3,900.00 280.50 2,436.11 62.46 1,463.89 101-4-2310-4217 Uniform Allowance 3,500.00 0.00 944.42 26.98 2,555.58 101-4-2310-4219 Operating Supplies 1,200.00 0.00 1,319.38 109.95 ( 119.38) 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 12,050.00 280.50 5,645.36 46.85 6,404.64 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,000.00 90.00 90.00 1.80 4,910.00 101-4-2310-4321 Telephone 2,750.00 254.23 1,870.60 68.02 879.40 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 1,903.00 6,679.50 68.16 3,120.50 101-4-2310-4389 Utilities 17,750.00 1,236.15 12,050.25 67.89 5,699.75 101-4-2310-4401 Bldg Repair/Maint Services 7,500.00 2,517.35 7,821.75 104.29 ( 321.75) 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 0.00 375.00 12.71 2,575.00 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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,007.00 95.57 93.00 101-4-2310-4460 Equip Replacement Charge 56,500.00 4,708.33 37,666.64 66.67 18,833.36 TOTAL Other Services & Charges 110,000.00 10,709.06 74,005.34 67.28 35,994.66 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 481,050.00 36,083.53 318,975.25 66.31 162,074.75 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 12,568.87 115,347.65 61.13 73,352.35 101-4-2320-4105 FICA 11,700.00 755.16 6,912.02 59.08 4,787.98 101-4-2320-4107 Medicare 2,750.00 179.26 1,654.01 60.15 1,095.99 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 13,503.29 150,873.93 64.99 81,276.07 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 738.11 3,707.11 51.49 3,492.89 101-4-2320-4217 Uniform Allowance 8,600.00 747.20 2,949.70 34.30 5,650.30 101-4-2320-4219 Operating Supplies 76,950.00 19,895.60 57,517.86 74.75 19,432.14 101-4-2320-4221 Equipment Parts 9,400.00 3,300.03 8,212.15 87.36 1,187.85 TOTAL Supplies 102,450.00 24,680.94 72,462.12 70.73 29,987.88 Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 387.03 2,505.16 56.94 1,894.84 101-4-2320-4331 Travel, Conferences & Schools 19,700.00 680.07 8,327.54 42.27 11,372.46 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 7,606.15 28,651.94 81.40 6,548.06 101-4-2320-4409 Contractual Services 6,300.00 0.00 7,353.68 116.73 ( 1,053.68) TOTAL Other Services & Charges 65,600.00 8,673.25 46,838.32 71.40 18,761.68 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 400,200.00 46,857.48 270,174.37 67.51 130,025.63 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,200.00 222.95 3,804.25 52.84 3,395.75 TOTAL Supplies 7,200.00 222.95 3,804.25 52.84 3,395.75 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 0.00 0.00 10,400.00 101-4-2330-4389 Utilities 4,500.00 478.02 2,955.58 65.68 1,544.42 101-4-2330-4404 Equip Repair/Maint Services 4,950.00 451.74 1,769.90 35.76 3,180.10 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 260.00 104.00 ( 10.00) TOTAL Other Services & Charges 20,100.00 929.76 4,985.48 24.80 15,114.52 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,300.00 1,152.71 8,789.73 32.20 18,510.27 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 465,650.00 35,522.21 289,090.57 62.08 176,559.43 101-4-2410-4102 Overtime Pay 0.00 0.00 74.21 0.00 ( 74.21) 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,178.03 26,065.33 62.66 15,534.67 101-4-2410-4105 FICA 24,100.00 1,636.43 13,825.64 57.37 10,274.36 101-4-2410-4107 Medicare 6,750.00 459.19 3,852.11 57.07 2,897.89 101-4-2410-4108 Insurance 83,500.00 6,735.50 55,449.00 66.41 28,051.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,531.36 394,795.82 63.28 229,054.18 Supplies 101-4-2410-4201 Office Supplies 3,000.00 22.65 935.02 31.17 2,064.98 101-4-2410-4212 Fuels & Lubes 6,000.00 348.31 3,459.71 57.66 2,540.29 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 141.14 4,974.36 51.55 4,675.64 TOTAL Supplies 20,400.00 512.10 9,383.44 46.00 11,016.56 Other Services & Charges 101-4-2410-4321 Telephone 5,350.00 369.95 2,620.81 48.99 2,729.19 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 0.00 1,562.10 37.64 2,587.90 101-4-2410-4361 Insurance 450.00 109.00 387.00 86.00 63.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,266.64 66.67 1,133.36 TOTAL Other Services & Charges 21,050.00 762.28 12,273.43 58.31 8,776.57 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 665,300.00 48,805.74 416,452.69 62.60 248,847.31 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 45,724.80 63.46 26,325.20 101-4-2420-4104 PERA 5,400.00 415.68 3,429.36 63.51 1,970.64 101-4-2420-4105 FICA 4,500.00 355.87 2,929.82 65.11 1,570.18 101-4-2420-4107 Medicare 1,050.00 83.23 685.20 65.26 364.80 101-4-2420-4108 Insurance 3,600.00 304.50 2,436.00 67.67 1,164.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.68 55,378.43 63.69 31,571.57 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 95.01 692.59 34.63 1,307.41 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 95.01 692.59 20.99 2,607.41 Other Services & Charges 101-4-2420-4321 Telephone 850.00 21.62 192.65 22.66 657.35 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 20.00 62.50 62.50 37.50 TOTAL Other Services & Charges 3,400.00 41.62 721.02 21.21 2,678.98 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 93,650.00 6,838.31 56,792.04 60.64 36,857.96 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 19,150.00 1,274.07 10,429.45 54.46 8,720.55 101-4-2440-4104 PERA 1,450.00 99.56 654.80 45.16 795.20 101-4-2440-4105 FICA 1,200.00 82.48 649.20 54.10 550.80 101-4-2440-4107 Medicare 300.00 19.26 151.72 50.57 148.28 101-4-2440-4108 Insurance 2,400.00 188.59 1,143.23 47.63 1,256.77 101-4-2440-4109 Workers Comp 300.00 0.00 159.00 53.00 141.00 TOTAL Personal Services 24,800.00 1,663.96 13,187.40 53.18 11,612.60 Supplies 101-4-2440-4201 Office Supplies 1,500.00 1.70 1,660.98 110.73 ( 160.98) 101-4-2440-4212 Fuels & Lubes 300.00 0.00 82.65 27.55 217.35 101-4-2440-4219 Operating Supplies 5,000.00 0.00 735.00 14.70 4,265.00 TOTAL Supplies 6,800.00 1.70 2,478.63 36.45 4,321.37 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Safety 66.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 90.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 0.00 900.00 64.29 500.00 101-4-2440-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2440-4409 Contractual Services 11,000.00 504.00 2,460.00 22.36 8,540.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 15,400.00 594.00 3,465.11 22.50 11,934.89 ___________________________________________________________________________________________________________________ TOTAL Environmental 47,000.00 2,259.66 19,131.14 40.70 27,868.86 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,856,750.00 503,754.04 4,095,628.74 59.73 2,761,121.26 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 502,550.00 44,364.62 343,154.69 68.28 159,395.31 101-4-3120-4102 Overtime Pay 4,000.00 0.00 1,104.71 27.62 2,895.29 101-4-3120-4103 Part-time Pay 81,400.00 7,260.14 58,246.81 71.56 23,153.19 101-4-3120-4104 PERA 42,450.00 3,641.46 28,684.78 67.57 13,765.22 101-4-3120-4105 FICA 36,450.00 3,073.86 24,230.26 66.48 12,219.74 101-4-3120-4107 Medicare 8,550.00 718.89 5,666.77 66.28 2,883.23 101-4-3120-4108 Insurance 79,650.00 6,741.26 49,231.08 61.81 30,418.92 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 65,800.23 534,272.03 67.98 251,677.97 Supplies 101-4-3120-4201 Office Supplies 1,500.00 1.70 372.46 24.83 1,127.54 101-4-3120-4212 Fuels & Lubes 45,000.00 13,410.18 38,830.16 86.29 6,169.84 101-4-3120-4219 Operating Supplies 56,500.00 5,668.35 28,547.27 50.53 27,952.73 101-4-3120-4221 Equipment Parts 52,000.00 5,296.18 29,025.13 55.82 22,974.87 101-4-3120-4226 Street Signs 31,500.00 ( 407.80 ) 26,035.70 82.65 5,464.30 TOTAL Supplies 186,500.00 23,968.61 122,810.72 65.85 63,689.28 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 45.00 203.19 36.94 346.81 101-4-3120-4321 Telephone 7,300.00 570.15 4,187.10 57.36 3,112.90 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 0.00 2,082.00 40.82 3,018.00 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 18,500.00 3,623.00 12,447.00 67.28 6,053.00 101-4-3120-4389 Utilities 92,800.00 6,694.07 49,943.21 53.82 42,856.79 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 3,590.20 17,978.00 89.89 2,022.00 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 30.53 4,605.53 51.17 4,394.47 101-4-3120-4409 Contractual Services 63,500.00 987.00 18,799.19 29.61 44,700.81 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Works 66.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 440.74 1,652.27 28.49 4,147.73 101-4-3120-4433 Dues & Subscriptions 350.00 142.50 530.00 151.43 ( 180.00) 101-4-3120-4437 Taxes & Licenses 150.00 0.00 70.00 46.67 80.00 101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 70,666.64 66.67 35,333.36 TOTAL Other Services & Charges 332,350.00 24,956.52 186,727.81 56.18 145,622.19 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,304,800.00 114,725.36 843,810.56 64.67 460,989.44 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 74.40 69,151.21 74.92 23,148.79 TOTAL Supplies 92,300.00 74.40 69,151.21 74.92 23,148.79 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 305,950.00 74.40 124,124.55 40.57 181,825.45 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 117,150.00 9,124.80 73,913.36 63.09 43,236.64 101-4-3150-4102 Overtime Pay 3,000.00 0.00 931.76 31.06 2,068.24 101-4-3150-4104 PERA 9,000.00 684.36 5,613.38 62.37 3,386.62 101-4-3150-4105 FICA 7,450.00 549.57 4,517.41 60.64 2,932.59 101-4-3150-4107 Medicare 1,750.00 128.53 1,056.49 60.37 693.51 101-4-3150-4108 Insurance 15,900.00 1,337.00 10,696.00 67.27 5,204.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 11,824.26 98,759.40 62.64 58,890.60 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Works 66.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 ( 300.49) 2,201.56 43.17 2,898.44 101-4-3150-4219 Operating Supplies 11,150.00 747.40 7,044.17 63.18 4,105.83 101-4-3150-4221 Equipment Parts 4,500.00 ( 106.50 )( 259.24) 5.76- 4,759.24 TOTAL Supplies 20,750.00 340.41 8,986.49 43.31 11,763.51 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 2,262.18 18.10 10,237.82 101-4-3150-4417 Uniform Rental 2,150.00 306.51 909.94 42.32 1,240.06 TOTAL Other Services & Charges 17,650.00 306.51 4,329.27 24.53 13,320.73 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 196,050.00 12,471.18 112,075.16 57.17 83,974.84 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 170,400.00 13,105.72 108,122.23 63.45 62,277.77 101-4-3300-4104 PERA 12,800.00 982.92 8,109.14 63.35 4,690.86 101-4-3300-4105 FICA 10,550.00 796.10 6,576.04 62.33 3,973.96 101-4-3300-4107 Medicare 2,450.00 186.19 1,537.95 62.77 912.05 101-4-3300-4108 Insurance 7,200.00 1,532.00 12,256.00 170.22 ( 5,056.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.93 137,010.86 67.10 67,189.14 Supplies 101-4-3300-4201 Office Supplies 150.00 3.39 157.40 104.93 ( 7.40) 101-4-3300-4212 Fuels & Lubes 1,000.00 68.85 565.13 56.51 434.87 101-4-3300-4219 Operating Supplies 2,500.00 0.00 2,141.48 85.66 358.52 TOTAL Supplies 3,650.00 72.24 2,864.01 78.47 785.99 Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 146.00 730.00 18.25 3,270.00 101-4-3300-4321 Telephone 1,400.00 91.62 646.62 46.19 753.38 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 0.00 609.00 40.60 891.00 101-4-3300-4361 Insurance 100.00 20.00 62.50 62.50 37.50 101-4-3300-4404 Equip Repair/Maint Services 1,800.00 213.10 213.10 11.84 1,586.90 101-4-3300-4460 Equip Replacement Charge 1,500.00 125.00 1,000.00 66.67 500.00 TOTAL Other Services & Charges 10,650.00 595.72 3,445.31 32.35 7,204.69 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Public Works 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 218,500.00 17,270.89 143,320.18 65.59 75,179.82 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,025,300.00 144,541.83 1,223,330.45 60.40 801,969.55 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 405,150.00 32,389.27 255,826.08 63.14 149,323.92 101-4-5110-4102 Overtime Pay 6,600.00 204.26 2,972.17 45.03 3,627.83 101-4-5110-4103 Part-time Pay 68,250.00 9,984.96 43,722.96 64.06 24,527.04 101-4-5110-4104 PERA 30,900.00 2,444.51 19,358.59 62.65 11,541.41 101-4-5110-4105 FICA 29,250.00 2,500.82 17,674.77 60.43 11,575.23 101-4-5110-4107 Medicare 6,900.00 584.88 4,127.46 59.82 2,772.54 101-4-5110-4108 Insurance 79,300.00 5,799.50 50,084.00 63.16 29,216.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 53,908.20 407,476.53 63.81 231,123.47 Supplies 101-4-5110-4212 Fuels & Lubes 25,000.00 2,771.77 13,708.28 54.83 11,291.72 101-4-5110-4217 Uniform Allowance 3,800.00 516.07 1,987.07 52.29 1,812.93 101-4-5110-4219 Operating Supplies 97,000.00 11,368.66 55,426.91 57.14 41,573.09 101-4-5110-4221 Equipment Parts 27,000.00 2,603.13 12,778.90 47.33 14,221.10 TOTAL Supplies 152,800.00 17,259.63 83,901.16 54.91 68,898.84 Other Services & Charges 101-4-5110-4321 Telephone 5,050.00 392.42 2,319.10 45.92 2,730.90 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 730.00 2,124.46 44.26 2,675.54 101-4-5110-4361 Insurance 33,500.00 8,034.00 24,459.50 73.01 9,040.50 101-4-5110-4389 Utilities 76,000.00 13,490.72 38,955.68 51.26 37,044.32 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,202.46 4,878.72 29.57 11,621.28 101-4-5110-4409 Contractual Services 45,100.00 8,783.10 21,650.79 48.01 23,449.21 101-4-5110-4415 Equipment Rental 22,200.00 5,596.63 15,730.09 70.86 6,469.91 101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 34,200.00 66.67 17,100.00 TOTAL Other Services & Charges 256,550.00 43,504.33 147,768.40 57.60 108,781.60 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,047,950.00 114,672.16 639,146.09 60.99 408,803.91 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Culture & Recreation 66.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.86 193,001.92 63.33 111,748.08 101-4-5210-4102 Overtime Pay 0.00 67.03 1,440.74 0.00 ( 1,440.74) 101-4-5210-4103 Part-time Pay 51,150.00 3,857.37 30,923.56 60.46 20,226.44 101-4-5210-4104 PERA 26,700.00 2,060.87 16,914.46 63.35 9,785.54 101-4-5210-4105 FICA 22,050.00 1,622.77 13,355.67 60.57 8,694.33 101-4-5210-4107 Medicare 5,150.00 379.52 3,123.50 60.65 2,026.50 101-4-5210-4108 Insurance 41,700.00 3,508.00 28,064.00 67.30 13,636.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,049.42 289,856.85 63.65 165,543.15 Supplies 101-4-5210-4219 Operating Supplies 8,600.00 1,547.79 8,963.63 104.23 ( 363.63) TOTAL Supplies 8,600.00 1,547.79 8,963.63 104.23 ( 363.63) Other Services & Charges 101-4-5210-4321 Telephone 6,750.00 339.78 1,928.04 28.56 4,821.96 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 2,281.92 4,448.72 50.27 4,401.28 101-4-5210-4349 Advertising/Marketing 33,200.00 10,179.33 17,104.04 51.52 16,095.96 101-4-5210-4361 Insurance 450.00 101.00 314.50 69.89 135.50 101-4-5210-4389 Utilities 11,300.00 891.55 6,035.23 53.41 5,264.77 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 950.00 8,947.69 52.02 8,252.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 225.00 2,515.00 109.35 ( 215.00) TOTAL Other Services & Charges 93,950.00 14,968.58 48,309.78 51.42 45,640.22 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 557,950.00 51,565.79 347,130.26 62.22 210,819.74 Recreation Programs =================== Personal Services 101-4-5220-4102 Overtime Pay 0.00 0.00 1.32 0.00 ( 1.32) 101-4-5220-4103 Part-time Pay 82,000.00 13,642.84 60,129.44 73.33 21,870.56 101-4-5220-4104 PERA 1,900.00 178.08 1,397.21 73.54 502.79 101-4-5220-4105 FICA 5,100.00 845.83 3,758.77 73.70 1,341.23 101-4-5220-4107 Medicare 1,200.00 197.82 879.08 73.26 320.92 TOTAL Personal Services 90,200.00 14,864.57 66,165.82 73.35 24,034.18 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Culture & Recreation 66.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 2,708.48 5,912.01 23.65 19,087.99 TOTAL Supplies 25,000.00 2,708.48 5,912.01 23.65 19,087.99 Other Services & Charges 101-4-5220-4409 Contractual Services 54,000.00 12,121.50 43,808.50 81.13 10,191.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 166.51 2,236.27 62.12 1,363.73 TOTAL Other Services & Charges 59,250.00 12,288.01 46,631.27 78.70 12,618.73 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 174,450.00 29,861.06 118,709.10 68.05 55,740.90 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 124,600.00 9,584.00 79,067.98 63.46 45,532.02 101-4-5510-4103 Part-time Pay 9,750.00 700.00 5,799.75 59.48 3,950.25 101-4-5510-4104 PERA 10,100.00 718.80 5,930.10 58.71 4,169.90 101-4-5510-4105 FICA 8,350.00 632.42 5,221.59 62.53 3,128.41 101-4-5510-4107 Medicare 1,950.00 147.90 1,221.17 62.62 728.83 101-4-5510-4108 Insurance 23,000.00 1,583.00 12,664.00 55.06 10,336.00 101-4-5510-4109 Workers Comp 650.00 0.00 428.25 65.88 221.75 TOTAL Personal Services 178,400.00 13,366.12 110,332.84 61.85 68,067.16 Supplies 101-4-5510-4219 Operating Supplies 10,750.00 808.71 5,548.53 51.61 5,201.47 TOTAL Supplies 10,750.00 808.71 5,548.53 51.61 5,201.47 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 108.43 855.69 35.65 1,544.31 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 200.90 643.00 20.74 2,457.00 101-4-5510-4361 Insurance 1,350.00 314.00 960.00 71.11 390.00 101-4-5510-4389 Utilities 21,300.00 1,614.37 11,474.50 53.87 9,825.50 101-4-5510-4401 Bldg Repair/Maint Services 16,500.00 2,661.85 12,086.19 73.25 4,413.81 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 4,576.98 19,541.36 164.21 ( 7,641.36) 101-4-5510-4433 Dues & Subscriptions 800.00 250.69 495.17 61.90 304.83 TOTAL Other Services & Charges 60,450.00 9,727.22 47,923.06 79.28 12,526.94 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Culture & Recreation 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 249,600.00 23,902.05 163,804.43 65.63 85,795.57 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,029,950.00 220,001.06 1,268,789.88 62.50 761,160.12 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 2,076.60) 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 ( 140.74) 1,246.92 0.00 ( 1,246.92) 101-4-6210-4105 FICA 0.00 ( 110.14) 1,039.38 0.00 ( 1,039.38) 101-4-6210-4107 Medicare 0.00 ( 21.41) 247.42 0.00 ( 247.42) 101-4-6210-4108 Insurance 0.00 ( 3.47 ) 2,272.20 0.00 ( 2,272.20) TOTAL Personal Services 0.00 ( 2,352.36) 22,281.48 0.00 ( 22,281.48) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 17.67 78.22 0.00 ( 78.22) TOTAL Other Services & Charges 0.00 17.67 78.22 0.00 ( 78.22) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 2,334.69) 22,359.70 0.00 ( 22,359.70) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 19,150.00 1,274.07 10,429.56 54.46 8,720.44 101-4-6220-4103 Part-time Pay 0.00 1,300.00 5,200.00 0.00 ( 5,200.00) 101-4-6220-4104 PERA 1,450.00 93.84 666.13 45.94 783.87 101-4-6220-4105 FICA 1,200.00 77.74 664.64 55.39 535.36 101-4-6220-4107 Medicare 300.00 18.19 159.80 53.27 140.20 101-4-6220-4108 Insurance 2,400.00 188.53 1,143.33 47.64 1,256.67 TOTAL Personal Services 24,500.00 2,952.37 18,263.46 74.54 6,236.54 Supplies 101-4-6220-4219 Operating Supplies 300.00 56.70 58.86 19.62 241.14 TOTAL Supplies 300.00 56.70 58.86 19.62 241.14 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 57.44 3,481.21 63.29 2,018.79 101-4-6220-4359 Publishing 1,000.00 468.40 652.40 65.24 347.60 TOTAL Other Services & Charges 9,000.00 525.84 4,243.61 47.15 4,756.39 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,800.00 3,534.91 22,565.93 66.76 11,234.07 9-14-2017 12:19 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2017 101-GENERAL FUND Economic Development 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,800.00 1,200.22 44,925.63 132.92 ( 11,125.63) Transfers Out ============= Transfers Ou t _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 14,378,400.00 1,140,910.48 8,760,596.52 60.93 5,617,803.48 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 861,528.71)( 297,392.86) 297,392.86 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$ 4,564,002$ 2,440,148$ 65.16% Cost of sales (5,008,100) (2,963,048) (2,045,052) 59.17% Gross profit 1,996,050 1,600,954 395,096 80.21% Operating revenues: User charges - - - 0.00%1,915,000$ 1,165,630$ 749,370$ 60.87%1,366,000$ 786,506$ 579,494$ 57.58%445,000$ 266,481$ 178,519$ 59.88% 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 1,600 100 94.12%2,000 24,166 (22,166) 1208.30%2,500 638 1,862 25.52%- - - 0.00% Total operating revenues 1,700 1,600 100 94.12%1,919,000 1,190,408 728,592 62.03%1,379,000 790,728 588,272 57.34%445,000 267,754 177,246 60.17% Operating expenses: Personal services 663,300 435,403 227,897 65.64%550,800 364,224 186,576 66.13%24,450 13,021 11,429 53.26%86,000 49,559 36,441 57.63% Supplies 20,700 9,125 11,575 44.08%206,800 90,504 116,296 43.76%21,400 15,818 5,582 73.92%2,000 64 1,936 3.20% Other service charges 241,500 159,179 82,321 65.91%552,000 354,849 197,151 64.28%1,457,200 854,563 602,637 58.64%458,200 224,362 233,838 48.97% 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 603,707 446,793 57.47%2,734,600 809,577 1,925,023 29.60%1,503,050 883,402 619,648 58.77%994,200 273,985 720,215 27.56% Operating income (loss)947,250 998,847 (51,597) 105.45%(815,600) 380,831 (1,196,431) -46.69%(124,050) (92,674) (31,376) 74.71%(549,200) (6,231) (542,969) 1.13% Nonoperating revenues (expenses): Interest income 35,000 35,601 (601) 101.72%80,000 35,199 44,801 44.00%8,000 3,298 4,702 41.23%4,000 4,173 (173) 104.33% Grant revenue - - - 0.00%- 129,339 (129,339) 0.00%- - - 0.00%- - - 0.00% Interest expense - - - 0.00%(264,350) (152,520) (111,830) 57.70%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)35,000 35,601 (601) 101.72%(184,350) 12,018 (196,368) -6.52%8,000 3,298 4,702 41.23%4,000 4,173 (173) 104.33% Income (loss) before contributions and transfers 982,250 1,034,448 (52,198) 105.31%(999,950) 392,849 (1,392,799) -39.29%(116,050) (89,376) (26,674) 77.02%(545,200) (2,058) (543,142) 0.38% Contributions - connection fees - - - 0.00%500,000 842,148 (342,148) 168.43%- - - 0.00%53,000 44,753 8,247 84.44% 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 323,582 (104,182) 147.48%(629,950) 1,104,997 (1,734,947) -175.41%(117,600) (135,526) 17,926 115.24%(507,200) 27,695 (534,895) -5.46% Items reclassified to balance sheet at year end: Capital Outlay (100,500) (1,344,672) 1,244,172 1337.98%(150,000) - (150,000) 0.00% Bond Payment (405,000) (405,000) - 100.00% Revenues over/(under) expenditures 219,400 323,582 (104,182) (1,135,450) (644,675) (490,775) (117,600) (135,526) 17,926 (657,200) 27,695 (684,895) -4.21% * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED AUGUST 31, 2017 Liquor Sewer Garbage 9-14-2017 12:38 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: AUGUST 31ST, 2017 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 11,775.25 1,396.63 13,171.88 101-1010 Cash - General Fund 7,156,898.49 ( 818,992.15) 6,337,906.34 211-1010 Cash - Library 448,439.89 ( 7,882.41) 440,557.48 221-1010 Cash - Ice Arena 511,482.48 ( 21,657.76) 489,824.72 222-1010 Cash - Pinewood Golf Course ( 13,973.78) ( 4,680.48) ( 18,654.26) 225-1010 Cash - Park Dedication 89,110.79 ( 1,395.00) 87,715.79 228-1010 Cash - Landfill 363,350.61 ( 4,848.23) 358,502.38 231-1010 Cash - Landfill Const Debris 745,881.84 0.00 745,881.84 240-1010 Cash - Micro Loan Fund 646,843.37 6,523.66 653,367.03 242-1010 Cash - State DEED 134,353.06 1,886.49 136,239.55 245-1010 Cash - Development Fund 1,232,937.93 ( 51,135.50) 1,181,802.43 290-1010 Cash - Capital Outlay Reserve 771,786.95 2,933.06 774,720.01 291-1010 Cash - Insurance Reserve 182,826.39 ( 25,262.68) 157,563.71 292-1010 Cash - Govt Bldgs Reserve 2,144,820.19 ( 314,987.50) 1,829,832.69 294-1010 Cash - Drug Forfeiture 18,321.94 1,967.82 20,289.76 295-1010 Cash - Severance Pay Reserve 72,872.88 0.00 72,872.88 296-1010 Cash - GRE Reserve 1,922,617.10 ( 1,250.00) 1,921,367.10 313-1010 Cash - 2007C/2012B GO Bonds 166,397.78 ( 6,050.00) 160,347.78 333-1010 Cash - 2010A GO Cap Imp Bonds 490,089.32 188,200.00 678,289.32 345-1010 Cash - 2012A CIP Bonds-PW ( 450.00) 450.00 0.00 401-1010 Cash - Pavement Mgmt 3,106,834.38 ( 610,934.31) 2,495,900.07 403-1010 Cash - Street Improvement 949,568.95 ( 46,949.13) 902,619.82 406-1010 Cash - City Wide Trunk Util 3,785,211.90 0.00 3,785,211.90 410-1010 Cash - Equipment Replacement 793,197.41 13,298.69 806,496.10 440-1010 Cash - Park Improvement 560,454.63 ( 143,961.98) 416,492.65 463-1010 Cash - TIF #23 Pref Powder 1,768.65 0.00 1,768.65 602-1010 Cash - Wastewater Treatment 3,648,767.71 ( 267,218.34) 3,381,549.37 603-1010 Cash - Liquor 3,319,596.59 17,866.81 3,337,463.40 605-1010 Cash - Garbage 298,064.73 ( 26,000.37) 272,064.36 607-1010 Cash - Storm Water 453,185.53 28,219.51 481,405.04 801-1010 Cash - Interest 0.00 98,504.50 98,504.50 821-1010 Cash - Developer Escrow 401,677.04 4,046.00 405,723.04_ TOTAL CLAIM ON CASH 34,414,710.00 ( 1,987,912.67) 32,426,797.33 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 89,616,871.42 ( 1,051,390.31) 88,565,481.11 999-1001 PY BANK ACCOUNT (83,584,350.98) ( 936,522.36) (84,520,873.34) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 34,414,710.00 ( 1,987,912.67) 32,426,797.33 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 34,414,710.00 ( 1,987,912.67) 32,426,797.33 =============== ============== ============== 222-PINEWOOD GOLF COURSE MONTH OF YTD REVENUES: JULY ACTUAL ERGC CITY Charges for Services 222-3-0000-3467 Concessions 1,265.52 2,447.12 2,447.12 - 222-3-0000-3469 Other Sales 332.89 1,379.34 1,379.34 - 222-3-0000-3476 Green Fees 18,143.61 39,480.17 39,480.17 - 222-3-0000-3477 Membership Fees - 5,300.00 5,300.00 - 222-3-0000-3478 Golf Cart Rental 3,724.97 7,916.44 7,916.44 - 222-3-0000-3792 Cash Over - 0.67 0.67 - TOTAL Charges for Services 23,466.99 56,523.74 56,523.74 - TOTAL REVENUE 23,466.99 56,523.74 56,523.74 - EXPENDITURES: Supplies 222-4-5300-4212 Fuels & Lubes 707.14 2,712.25 2,655.75 56.50 222-4-5300-4219 Operating Supplies 425.12 2,941.83 2,510.05 431.78 222-4-5300-4259 Other Merchandise For Resale 465.93 1,435.87 1,435.87 - TOTAL Supplies 1,598.19 7,089.95 6,601.67 488.28 Other Services & Charges 222-4-5300-4319 Management Fee 4,000.00 12,000.00 - 12,000.00 222-4-5300-4349 Advertising/Marketing 318.00 968.00 968.00 - 222-4-5300-4389 Utilities 542.94 1,595.99 - 1,595.99 222-4-5300-4401 Building Maintenance 146.72 1,764.09 1,178.09 586.00 222-4-5300-4404 Grounds Maintenance 990.20 8,663.64 8,433.64 230.00 222-4-5300-4409 Contractual Svcs - Wages/Taxes 13,465.30 41,012.26 41,012.26 - 222-4-5300-4415 Equipment Rental - 374.06 374.06 - 222-4-5300-4437 Taxes & Licenses 225.00 525.00 525.00 - 222-4-5300-4438 Bank/Credit Card Fees 448.63 607.13 607.13 - TOTAL Other Services & Charges 20,136.79 67,510.17 53,098.18 14,411.99 TOTAL EXPENDITURES 21,734.98 74,600.12 59,699.85 14,900.27 REVENUES OVER/(UNDER) EXPENDITURES 1,732.01 (18,076.38) (3,176.11) (14,900.27) CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31, 2017