Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 09-19-2016
Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Lori Ziemer,Finance Director Date: September 19, 2016 Subject: August 2016 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, Ice Arena Special Revenue Fund, and Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of 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 significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues: ■ Excluding transfers in,revenue collections are about 54% of budget,with the second half property taxes to be collected in December. ■ Licenses and permits collections are 73% of budget estimates,with building-related permit collections in line with budget estimates at 65% as of the end of August. ■ Intergovernmental revenue collections consist of police training reimbursement and crime prevention grant from the State. ■ Charges for services are 73% of budget,with August collections consisting mainly of plan check fees and recreation fees. ■ Fines and forfeits collections,which lag a month,are 75% of budget estimates. Expenditures: ■ Total departmental expenditures are about 61% of budget and most departments are within or below budget. p0WIeI1 0 NAWREJ 01 2016 Monthly Expenditures $16,000 $14,000 N $12,000 0 Z $10,000 p $8,000 ~ $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $831 $1,859 $2,920 $3,933 $4,945 $5,993 $7,450 $8,533 Budget $1,157 $2,314 $3,471 $4,628 $5,785 $6,942 $8,099 1 $9,257 1$10,4141$11,5711$12,728$13,885 ICE ARENA For the month ending August,revenues of$444,710 exceed expenditures of$362,357 by $82,353. August revenues consist mainly of off season ice rental revenues which are at $261,250 or 49% of budget estimate. ATTACHMENTS ■ General Fund Revenue& Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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 13,884,800.00 283,026.38 7,796,803.42 56.15 6,087,996.58 TOTAL REVENUES 13,884,800.00 283,026.38 7,796,803.42 56.15 6,087,996.58 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 145,850.00 31,023.31 87,339.40 59.88 58,510.60 Cable TV 109,700.00 7,330.06 61,043.87 55.65 48,656.13 Administrative Services 605,500.00 41,870.80 372,236.66 61.48 233,263.34 Human Resources 178,400.00 12,191.70 102,644.04 57.54 75,755.96 Elections 20,500.00 15,581.12 22,540.17 109.95 ( 2,040.17) Finance 583,550.00 28,486.43 410,853.51 70.41 172,696.49 Information Technology 346,350.00 24,014.80 219,138.12 63.27 127,211.88 Legal 214,600.00 33,102.84 129,733.55 60.45 84,866.45 Community Development 213,750.00 17,823.94 139,091.83 65.07 74,658.17 Planning 297,400.00 22,588.21 168,475.59 56.65 128,924.41 City Hall Maintenance 623,650.00 51,228.54 389,148.33 62.40 234,501.67 Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,244,250.00 285,241.75 2,102,245.07 64.80 1,142,004.93 Public Safety Police Administration 713,700.00 49,802.75 458,338.76 64.22 255,361.24 Patrol 2,530,150.00 162,047.55 1,484,719.45 58.68 1,045,430.55 Investigations 994,000.00 67,708.32 604,793.39 60.84 389,206.61 Police Support Services 558,600.00 40,329.52 320,217.43 57.32 238,382.57 Police Reserves 23,250.00 197.20 8,604.43 37.01 14,645.57 Public safety building 156,000.00 18,655.53 88,767.41 56.90 67,232.59 Fire Administration 475,750.00 35,700.91 307,019.98 64.53 168,730.02 Fire Operations 381,300.00 33,926.52 242,071.73 63.49 139,228.27 Emergency Management 24,800.00 3,116.88 8,396.42 33.86 16,403.58 Building Safety 647,750.00 48,532.84 404,440.50 62.44 243,309.50 Code Enforcement 91,600.00 6,700.49 57,530.96 62.81 34,069.04 Environmental 39,100.00 3,088.72 26,135.28 66.84 12,964.72 TOTAL Public Safety 6,636,000.00 469,807.23 4,011,035.74 60.44 2,624,964.26 Public Works Street Maintenance 1,310,000.00 112,197.98 792,823.60 60.52 517,176.40 Snow Removal 281,550.00 2,655.43 150,837.27 53.57 130,712.73 Equipment Services 186,250.00 11,417.39 106,683.00 57.28 79,567.00 Engineering 217,950.00 16,514.93 133,091.01 61.06 84,858.99 TOTAL Public Works 1,995,750.00 142,785.73 1,183,434.88 59.30 812,315.12 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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,038,100.00 90,884.32 608,074.60 58.58 430,025.40 Parks & Rec Admin 545,700.00 39,924.06 324,198.49 59.41 221,501.51 Recreation Programs 165,750.00 22,365.52 113,235.24 68.32 52,514.76 Sr Citizen Programs 242,950.00 20,789.78 144,688.09 59.55 98,261.91 TOTAL Culture & Recreation 1,992,500.00 173,963.68 1,190,196.42 59.73 802,303.58 Economic Development Economic Development 0.00 9,904.43 36,874.99 0.00 ( 36,874.99) Energy City 16,300.00 1,533.38 9,233.55 56.65 7,066.45 TOTAL Economic Development 16,300.00 11,437.81 46,108.54 282.87 ( 29,808.54) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 13,884,800.00 1,083,236.20 8,533,020.65 61.46 5,351,779.35 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 800,209.82)( 736,217.23) 736,217.23 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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,596,850.00 18,347.03 4,993,540.13 52.03 4,603,309.87 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 25,697.32 0.00 ( 25,697.32) 101-3-0000-3121 Gravel Tax 127,000.00 0.00 54,344.44 42.79 72,655.56 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,276.37 0.00 ( 2,276.37) TOTAL Taxes 9,723,850.00 18,347.03 5,075,858.26 52.20 4,647,991.74 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 30.00 65,795.00 97.47 1,705.00 101-3-0000-3212 Amusement License 1,050.00 0.00 0.00 0.00 1,050.00 101-3-0000-3213 Cigarette License 3,100.00 0.00 100.00 3.23 3,000.00 101-3-0000-3214 Apartment License 35,000.00 1,664.00 43,681.00 124.80 ( 8,681.00) 101-3-0000-3216 Mining License 23,000.00 2,617.35 22,135.34 96.24 864.66 101-3-0000-3217 Garbage Hauler License 1,600.00 0.00 315.00 19.69 1,285.00 101-3-0000-3218 Other Business License/Permit 12,000.00 300.00 5,870.00 48.92 6,130.00 101-3-0000-3229 NPDES Permit 10,000.00 1,050.00 7,875.00 78.75 2,125.00 101-3-0000-3231 Building Permit 385,000.00 22,192.05 193,898.03 50.36 191,101.97 101-3-0000-3232 Plumbing/Heating Permit 92,000.00 35,550.38 118,428.18 128.73 ( 26,428.18) 101-3-0000-3233 Permit Surcharge 300.00 557.02 3,797.09 1,265.70 ( 3,497.09) 101-3-0000-3235 Animal License 6,500.00 100.00 2,475.00 38.08 4,025.00 101-3-0000-3236 Parking Permit 1,500.00 ( 1.29) 355.55 23.70 1,144.45 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 1,110.00 7,050.00 88.13 950.00 TOTAL Licenses & Permits 646,550.00 65,169.51 471,775.19 72.97 174,774.81 Intergovernmental Rev 101-3-0000-3311 Federal Grant 1,800.00 0.00 0.00 0.00 1,800.00 101-3-0000-3322 MV Credit 4,000.00 0.00 0.00 0.00 4,000.00 101-3-0000-3324 PERA Aid 14,000.00 ( 2,194.50) 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 230,000.00 0.00 0.00 0.00 230,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 8,754.52 8,754.52 87.55 1,245.48 101-3-0000-3329 State Crime Prevention Grant 25,250.00 5,121.58 6,930.38 27.45 18,319.62 101-3-0000-3330 Other State Grants 3,300.00 0.00 900.00 27.27 2,400.00 TOTAL Intergovernmental Rev 288,350.00 11,681.60 23,576.90 8.18 264,773.10 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 16,000.00 1,200.00 21,152.50 132.20 ( 5,152.50) 101-3-0000-3413 Plan Check Fee 135,000.00 9,558.41 77,919.04 57.72 57,080.96 101-3-0000-3415 Special Assessment Search 500.00 120.00 880.00 176.00 ( 380.00) 101-3-0000-3417 Copies 1,700.00 308.51 1,971.77 115.99 ( 271.77) 101-3-0000-3418 Other General Govt Services 4,500.00 125.00 3,154.25 70.09 1,345.75 101-3-0000-3430 Lockout Fees 7,500.00 560.00 4,490.00 59.87 3,010.00 101-3-0000-3431 Police Services 6,000.00 410.00 7,282.48 121.37 ( 1,282.48) 101-3-0000-3432 School Liaison 123,600.00 0.00 123,624.00 100.02 ( 24.00) 101-3-0000-3434 Animal Impound Fee 3,000.00 525.00 3,150.00 105.00 ( 150.00) 101-3-0000-3436 Fire Contracts 220,000.00 0.00 234,655.72 106.66 ( 14,655.72) 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3437 Fire Services 3,000.00 643.50 1,150.00 38.33 1,850.00 101-3-0000-3438 Fire Inspections 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3450 Maintenance Facility Rent 14,500.00 1,156.50 9,252.00 63.81 5,248.00 101-3-0000-3451 Street Services 35,000.00 508.37 14,012.28 40.04 20,987.72 101-3-0000-3452 Engineering Services Reimb 148,950.00 0.00 37,949.34 25.48 111,000.66 101-3-0000-3461 Recreation Fees 96,000.00 6,480.47 63,982.71 66.65 32,017.29 101-3-0000-3462 Sr Center Activities 29,000.00 3,766.00 22,569.73 77.83 6,430.27 101-3-0000-3472 Park Use Fee 24,400.00 280.59 17,238.92 70.65 7,161.08 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 1,365.00 5,255.00 58.39 3,745.00 101-3-0000-3484 Contractor License Check 1,000.00 85.00 515.00 51.50 485.00 TOTAL Charges for Services 891,050.00 27,292.35 651,804.74 73.15 239,245.26 Fines & Forfeits 101-3-0000-3510 Court Fines 117,000.00 11,608.74 91,978.47 78.61 25,021.53 101-3-0000-3511 Parking Fines 10,000.00 60.00 3,060.00 30.60 6,940.00 TOTAL Fines & Forfeits 127,000.00 11,668.74 95,038.47 74.83 31,961.53 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 45,807.72 53.89 39,192.28 101-3-0000-3625 Refunds & Reimbursements 101,000.00 ( 19,092.26) 6,985.83 6.92 94,014.17 101-3-0000-3626 Contributions 20,000.00 0.00 16,000.00 80.00 4,000.00 101-3-0000-3629 Miscellaneous Revenue 7,500.00 1,012.57 5,355.19 71.40 2,144.81 TOTAL Other Revenue 213,500.00 ( 18,079.69) 74,148.74 34.73 139,351.26 Transfers In 101-3-0000-3921 Transfers 217,950.00 0.00 0.00 0.00 217,950.00 101-3-0000-3925 Transfer-Landfill 55,000.00 0.00 55,000.00 100.00 0.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 0.00 0.00 12,950.00 0.00 ( 12,950.00) 101-3-0000-3929 Transfer-NSP/RDF Reserve 45,000.00 0.00 45,000.00 100.00 0.00 101-3-0000-3930 Transfer-Development 62,600.00 0.00 62,600.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 100,000.00 0.00 100,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 438,950.00 0.00 438,950.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 45,000.00 0.00 45,000.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 970,450.00 107,396.84 580,551.12 59.82 389,898.88 101-3-0000-3946 Transfer-Stormwater 0.00 0.00 5,000.00 0.00 ( 5,000.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,994,500.00 166,946.84 1,404,601.12 70.42 589,898.88 _____________________________________________________________________________ TOTAL General Fund 13,884,800.00 283,026.38 7,796,803.42 56.15 6,087,996.58 ___________________________________________________________________________________________________________________ TOTAL REVENUE 13,884,800.00 283,026.38 7,796,803.42 56.15 6,087,996.58 ============= ============= ============= ======= ============= 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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.34 25,665.29 66.66 12,834.71 101-4-1110-4104 PERA 1,900.00 117.09 839.22 44.17 1,060.78 101-4-1110-4105 FICA 2,400.00 53.73 541.38 22.56 1,858.62 101-4-1110-4107 Medicare 550.00 46.55 372.18 67.67 177.82 101-4-1110-4109 Workers Comp 100.00 0.00 62.25 62.25 37.75 TOTAL Personal Services 43,450.00 3,425.71 27,480.32 63.25 15,969.68 Supplies 101-4-1110-4201 Office Supplies 1,000.00 6.09 450.43 45.04 549.57 TOTAL Supplies 1,000.00 6.09 450.43 45.04 549.57 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 3,214.06 7,663.28 73.69 2,736.72 101-4-1110-4322 Postage 200.00 0.00 30.09 15.05 169.91 101-4-1110-4331 Travel, Conferences & Schools 2,100.00 0.00 1,002.88 47.76 1,097.12 101-4-1110-4359 Publishing 3,700.00 0.00 751.72 20.32 2,948.28 101-4-1110-4361 Insurance 39,600.00 8,952.50 28,182.50 71.17 11,417.50 101-4-1110-4433 Dues & Subscriptions 18,550.00 0.00 0.00 0.00 18,550.00 101-4-1110-4440 Miscellaneous 26,850.00 15,424.95 21,778.18 81.11 5,071.82 TOTAL Other Services & Charges 101,400.00 27,591.51 59,408.65 58.59 41,991.35 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 145,850.00 31,023.31 87,339.40 59.88 58,510.60 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 63,350.00 4,875.20 40,464.18 63.87 22,885.82 101-4-1120-4103 Part-time Pay 17,950.00 742.99 6,300.25 35.10 11,649.75 101-4-1120-4104 PERA 6,100.00 421.37 3,591.65 58.88 2,508.35 101-4-1120-4105 FICA 5,050.00 317.47 2,722.22 53.91 2,327.78 101-4-1120-4107 Medicare 1,200.00 74.24 636.64 53.05 563.36 101-4-1120-4108 Insurance 14,250.00 861.00 6,888.00 48.34 7,362.00 101-4-1120-4109 Workers Comp 350.00 0.00 284.25 81.21 65.75 TOTAL Personal Services 108,250.00 7,292.27 60,887.19 56.25 47,362.81 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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 500.00 37.79 156.68 31.34 343.32 TOTAL Supplies 500.00 37.79 156.68 31.34 343.32 Other Services & Charges 101-4-1120-4331 Travel, Conferences & Schools 950.00 0.00 0.00 0.00 950.00 TOTAL Other Services & Charges 950.00 0.00 0.00 0.00 950.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 109,700.00 7,330.06 61,043.87 55.65 48,656.13 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 388,750.00 29,903.16 248,196.22 63.84 140,553.78 101-4-1210-4103 Part-time Pay 46,000.00 3,477.47 26,666.89 57.97 19,333.11 101-4-1210-4104 PERA 32,600.00 2,503.53 21,111.63 64.76 11,488.37 101-4-1210-4105 FICA 26,950.00 2,116.29 17,643.80 65.47 9,306.20 101-4-1210-4107 Medicare 6,300.00 494.94 4,126.37 65.50 2,173.63 101-4-1210-4108 Insurance 36,600.00 2,160.00 19,450.88 53.14 17,149.12 101-4-1210-4109 Workers Comp 1,900.00 0.00 1,462.50 76.97 437.50 TOTAL Personal Services 539,100.00 40,655.39 338,658.29 62.82 200,441.71 Supplies 101-4-1210-4201 Office Supplies 7,300.00 193.62 1,100.75 15.08 6,199.25 TOTAL Supplies 7,300.00 193.62 1,100.75 15.08 6,199.25 Other Services & Charges 101-4-1210-4319 Other Professional Services 11,600.00 0.00 6,278.44 54.12 5,321.56 101-4-1210-4321 Telephone 1,500.00 510.74 699.62 46.64 800.38 101-4-1210-4322 Postage 800.00 0.00 645.17 80.65 154.83 101-4-1210-4331 Travel, Conferences & Schools 10,550.00 83.09 3,421.76 32.43 7,128.24 101-4-1210-4334 Car Allowance 4,800.00 400.00 3,200.00 66.67 1,600.00 101-4-1210-4359 Publishing 13,000.00 0.00 9,783.00 75.25 3,217.00 101-4-1210-4361 Insurance 50.00 16.00 39.50 79.00 10.50 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 0.00 6,495.41 43.45 8,454.59 101-4-1210-4433 Dues & Subscriptions 1,850.00 11.96 1,914.72 103.50 ( 64.72) TOTAL Other Services & Charges 59,100.00 1,021.79 32,477.62 54.95 26,622.38 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 605,500.00 41,870.80 372,236.66 61.48 233,263.34 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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 121,250.00 9,431.50 76,987.87 63.50 44,262.13 101-4-1220-4104 PERA 9,100.00 707.36 5,912.45 64.97 3,187.55 101-4-1220-4105 FICA 7,500.00 569.14 4,762.76 63.50 2,737.24 101-4-1220-4107 Medicare 1,750.00 133.11 1,113.87 63.65 636.13 101-4-1220-4108 Insurance 14,900.00 1,260.00 10,080.12 67.65 4,819.88 101-4-1220-4109 Workers Comp 550.00 0.00 408.00 74.18 142.00 TOTAL Personal Services 155,050.00 12,101.11 99,265.07 64.02 55,784.93 Supplies 101-4-1220-4201 Office Supplies 1,350.00 42.64 204.57 15.15 1,145.43 TOTAL Supplies 1,350.00 42.64 204.57 15.15 1,145.43 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 47.95 699.10 55.93 550.90 101-4-1220-4322 Postage 600.00 0.00 229.64 38.27 370.36 101-4-1220-4331 Travel, Conferences & Schools 18,200.00 0.00 358.66 1.97 17,841.34 101-4-1220-4404 Equip Repair/Maint 1,200.00 0.00 1,082.00 90.17 118.00 101-4-1220-4433 Dues & Subscriptions 750.00 0.00 805.00 107.33 ( 55.00) TOTAL Other Services & Charges 22,000.00 47.95 3,174.40 14.43 18,825.60 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 178,400.00 12,191.70 102,644.04 57.54 75,755.96 Elections ========= Personal Services 101-4-1230-4103 Part-time Pay 15,000.00 15,420.75 15,990.00 106.60 ( 990.00) TOTAL Personal Services 15,000.00 15,420.75 15,990.00 106.60 ( 990.00) Supplies 101-4-1230-4219 Operating Supplies 1,300.00 85.11 85.11 6.55 1,214.89 TOTAL Supplies 1,300.00 85.11 85.11 6.55 1,214.89 Other Services & Charges 101-4-1230-4322 Postage 50.00 0.00 49.80 99.60 0.20 101-4-1230-4331 Travel, Conferences & Schools 150.00 35.26 35.26 23.51 114.74 101-4-1230-4359 Publishing 350.00 40.00 80.00 22.86 270.00 101-4-1230-4404 Equip Repair/Maint Services 3,300.00 0.00 6,300.00 190.91 ( 3,000.00) 101-4-1230-4415 Equipment Rental 350.00 0.00 0.00 0.00 350.00 TOTAL Other Services & Charges 4,200.00 75.26 6,465.06 153.93 ( 2,265.06) 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND General Government 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 20,500.00 15,581.12 22,540.17 109.95 ( 2,040.17) Finance ======= Personal Services 101-4-1310-4101 Regular Pay 317,750.00 16,496.51 207,333.21 65.25 110,416.79 101-4-1310-4102 Overtime Pay 0.00 236.29 3,001.44 0.00 ( 3,001.44) 101-4-1310-4103 Part-time Pay 53,400.00 4,753.31 38,392.21 71.90 15,007.79 101-4-1310-4104 PERA 27,850.00 1,611.47 16,379.95 58.81 11,470.05 101-4-1310-4105 FICA 23,000.00 1,281.44 15,287.89 66.47 7,712.11 101-4-1310-4107 Medicare 5,400.00 299.70 3,575.38 66.21 1,824.62 101-4-1310-4108 Insurance 38,350.00 2,335.00 23,087.33 60.20 15,262.67 101-4-1310-4109 Workers Comp 1,650.00 0.00 1,248.75 75.68 401.25 TOTAL Personal Services 467,400.00 27,013.72 308,306.16 65.96 159,093.84 Supplies 101-4-1310-4201 Office Supplies 4,500.00 98.89 1,470.67 32.68 3,029.33 TOTAL Supplies 4,500.00 98.89 1,470.67 32.68 3,029.33 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 0.00 20,100.00 100.50 ( 100.00) 101-4-1310-4319 Other Professional Services 54,000.00 600.00 53,420.00 98.93 580.00 101-4-1310-4321 Telephone 350.00 39.99 267.83 76.52 82.17 101-4-1310-4322 Postage 2,600.00 25.00 1,965.02 75.58 634.98 101-4-1310-4331 Travel, Conferences & Schools 4,150.00 0.00 170.90 4.12 3,979.10 101-4-1310-4359 Publishing 200.00 0.00 290.00 145.00 ( 90.00) 101-4-1310-4404 Equip Repair/Maint Services 21,750.00 0.00 19,170.66 88.14 2,579.34 101-4-1310-4433 Dues & Subscriptions 1,600.00 0.00 1,495.00 93.44 105.00 101-4-1310-4438 Credit Card Fees 5,500.00 572.78 3,389.12 61.62 2,110.88 101-4-1310-4440 Miscellaneous 1,500.00 136.05 808.15 53.88 691.85 TOTAL Other Services & Charges 111,650.00 1,373.82 101,076.68 90.53 10,573.32 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 583,550.00 28,486.43 410,853.51 70.41 172,696.49 Information Technology ====================== 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND General Government 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-1350-4101 Regular Pay 188,650.00 14,960.72 120,742.93 64.00 67,907.07 101-4-1350-4102 Overtime Pay 0.00 77.85 140.13 0.00 ( 140.13) 101-4-1350-4104 PERA 14,150.00 1,127.90 9,282.31 65.60 4,867.69 101-4-1350-4105 FICA 11,700.00 856.71 7,073.33 60.46 4,626.67 101-4-1350-4107 Medicare 2,750.00 200.37 1,654.26 60.15 1,095.74 101-4-1350-4108 Insurance 32,350.00 2,728.00 21,792.26 67.36 10,557.74 101-4-1350-4109 Workers Comp 850.00 0.00 634.50 74.65 215.50 TOTAL Personal Services 250,450.00 19,951.55 161,319.72 64.41 89,130.28 Supplies 101-4-1350-4219 Operating Supplies 15,800.00 347.63 6,170.06 39.05 9,629.94 TOTAL Supplies 15,800.00 347.63 6,170.06 39.05 9,629.94 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 129.00 3,382.50 42.28 4,617.50 101-4-1350-4321 Telephone 2,550.00 160.96 ( 252.90) 9.92- 2,802.90 101-4-1350-4331 Travel, Conferences & Schools 8,950.00 69.72 2,202.60 24.61 6,747.40 101-4-1350-4404 Equip Repair/Maint Services 60,600.00 3,355.94 46,316.14 76.43 14,283.86 TOTAL Other Services & Charges 80,100.00 3,715.62 51,648.34 64.48 28,451.66 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 346,350.00 24,014.80 219,138.12 63.27 127,211.88 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 214,600.00 33,102.84 129,733.55 60.45 84,866.45 TOTAL Other Services & Charges 214,600.00 33,102.84 129,733.55 60.45 84,866.45 ___________________________________________________________________________________________________________________ TOTAL Legal 214,600.00 33,102.84 129,733.55 60.45 84,866.45 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 170,850.00 13,196.98 109,116.61 63.87 61,733.39 101-4-1500-4104 PERA 12,800.00 989.78 8,380.88 65.48 4,419.12 101-4-1500-4105 FICA 10,600.00 792.26 6,746.14 63.64 3,853.86 101-4-1500-4107 Medicare 2,500.00 185.29 1,577.73 63.11 922.27 101-4-1500-4108 Insurance 11,050.00 1,260.00 10,080.12 91.22 969.88 101-4-1500-4109 Workers Comp 750.00 0.00 574.50 76.60 175.50 TOTAL Personal Services 208,550.00 16,424.31 136,475.98 65.44 72,074.02 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-1500-4201 Office Supplies 1,100.00 42.64 720.55 65.50 379.45 TOTAL Supplies 1,100.00 42.64 720.55 65.50 379.45 Other Services & Charges 101-4-1500-4321 Telephone 700.00 34.99 386.73 55.25 313.27 101-4-1500-4331 Travel, Conferences & Schools 2,850.00 775.00 961.57 33.74 1,888.43 101-4-1500-4433 Dues & Subscriptions 550.00 547.00 547.00 99.45 3.00 TOTAL Other Services & Charges 4,100.00 1,356.99 1,895.30 46.23 2,204.70 ___________________________________________________________________________________________________________________ TOTAL Community Development 213,750.00 17,823.94 139,091.83 65.07 74,658.17 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 207,100.00 16,148.39 119,872.49 57.88 87,227.51 101-4-1510-4104 PERA 15,550.00 1,211.12 9,163.90 58.93 6,386.10 101-4-1510-4105 FICA 12,850.00 931.35 7,023.36 54.66 5,826.64 101-4-1510-4107 Medicare 3,000.00 217.81 1,642.55 54.75 1,357.45 101-4-1510-4108 Insurance 39,100.00 2,087.00 14,926.09 38.17 24,173.91 101-4-1510-4109 Workers Comp 950.00 0.00 769.50 81.00 180.50 TOTAL Personal Services 278,550.00 20,595.67 153,397.89 55.07 125,152.11 Supplies 101-4-1510-4201 Office Supplies 2,500.00 98.42 1,585.46 63.42 914.54 101-4-1510-4212 Fuels & Lubes 300.00 9.44 33.08 11.03 266.92 101-4-1510-4219 Operating Supplies 2,150.00 273.89 1,845.44 85.83 304.56 TOTAL Supplies 4,950.00 381.75 3,463.98 69.98 1,486.02 Other Services & Charges 101-4-1510-4319 Other Professional Services 0.00 108.50 108.50 0.00 ( 108.50) 101-4-1510-4321 Telephone 350.00 25.29 236.95 67.70 113.05 101-4-1510-4322 Postage 1,500.00 0.00 587.04 39.14 912.96 101-4-1510-4331 Travel, Conferences & Schools 1,500.00 125.00 708.00 47.20 792.00 101-4-1510-4359 Publishing 8,000.00 1,336.00 7,893.00 98.66 107.00 101-4-1510-4361 Insurance 50.00 16.00 39.50 79.00 10.50 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 1,425.98 95.07 74.02 101-4-1510-4433 Dues & Subscriptions 750.00 0.00 476.75 63.57 273.25 101-4-1510-4440 Miscellaneous 250.00 0.00 138.00 55.20 112.00 TOTAL Other Services & Charges 13,900.00 1,610.79 11,613.72 83.55 2,286.28 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,400.00 22,588.21 168,475.59 56.65 128,924.41 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND General Government 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 343,000.00 26,183.80 215,323.15 62.78 127,676.85 101-4-1600-4102 Overtime Pay 3,500.00 0.00 1,287.89 36.80 2,212.11 101-4-1600-4103 Part-time Pay 3,450.00 346.32 1,558.44 45.17 1,891.56 101-4-1600-4104 PERA 26,000.00 1,989.76 16,750.89 64.43 9,249.11 101-4-1600-4105 FICA 21,700.00 1,632.51 13,837.82 63.77 7,862.18 101-4-1600-4107 Medicare 5,100.00 381.81 3,236.26 63.46 1,863.74 101-4-1600-4108 Insurance 40,550.00 3,750.00 29,077.65 71.71 11,472.35 101-4-1600-4109 Workers Comp 11,500.00 0.00 8,701.50 75.67 2,798.50 TOTAL Personal Services 454,800.00 34,284.20 289,773.60 63.71 165,026.40 Supplies 101-4-1600-4212 Fuels & Lubes 2,000.00 231.35 1,403.02 70.15 596.98 101-4-1600-4217 Uniform Allowance 2,400.00 0.00 502.78 20.95 1,897.22 101-4-1600-4219 Operating Supplies 30,400.00 1,352.85 21,066.94 69.30 9,333.06 TOTAL Supplies 34,800.00 1,584.20 22,972.74 66.01 11,827.26 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 1,114.31 7,598.77 64.95 4,101.23 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 532.57 26.63 1,467.43 101-4-1600-4361 Insurance 5,350.00 1,268.25 3,870.25 72.34 1,479.75 101-4-1600-4389 Utilities 75,750.00 5,354.86 36,138.28 47.71 39,611.72 101-4-1600-4401 Bldg Repair/Maint Services 32,800.00 7,376.89 24,027.48 73.25 8,772.52 101-4-1600-4404 Equip Repair/Maint Services 3,500.00 0.00 2,268.00 64.80 1,232.00 101-4-1600-4460 Equip Replacement Charge 2,950.00 245.83 1,966.64 66.67 983.36 TOTAL Other Services & Charges 134,050.00 15,360.14 76,401.99 57.00 57,648.01 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 623,650.00 51,228.54 389,148.33 62.40 234,501.67 Contingency =========== Personal Services 101-4-1900-4101 Regular Pay ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL Personal Services ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) ___________________________________________________________________________________________________________________ TOTAL General Government 3,244,250.00 285,241.75 2,102,245.07 64.80 1,142,004.93 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND Public Safety 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 373,250.00 28,057.42 228,873.18 61.32 144,376.82 101-4-2110-4102 Overtime Pay 0.00 19.93 19.93 0.00 ( 19.93) 101-4-2110-4104 PERA 54,450.00 4,176.94 34,950.03 64.19 19,499.97 101-4-2110-4105 FICA 4,300.00 224.31 1,827.33 42.50 2,472.67 101-4-2110-4107 Medicare 5,400.00 383.33 3,216.13 59.56 2,183.87 101-4-2110-4108 Insurance 35,950.00 2,988.00 23,797.93 66.20 12,152.07 101-4-2110-4109 Workers Comp 61,500.00 0.00 45,773.25 74.43 15,726.75 TOTAL Personal Services 534,850.00 35,849.93 338,457.78 63.28 196,392.22 Supplies 101-4-2110-4201 Office Supplies 10,350.00 347.18 5,064.25 48.93 5,285.75 101-4-2110-4217 Uniform Allowance 2,950.00 537.29 1,917.04 64.98 1,032.96 101-4-2110-4219 Operating Supplies 1,300.00 0.00 2,241.32 172.41 ( 941.32) TOTAL Supplies 14,600.00 884.47 9,222.61 63.17 5,377.39 Other Services & Charges 101-4-2110-4319 Other Professional Services 6,900.00 0.00 2,377.53 34.46 4,522.47 101-4-2110-4321 Telephone 31,900.00 2,379.85 16,299.44 51.10 15,600.56 101-4-2110-4322 Postage 2,400.00 0.00 1,029.27 42.89 1,370.73 101-4-2110-4331 Travel, Conferences & Schools 10,200.00 0.00 4,586.96 44.97 5,613.04 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 41,450.00 10,316.50 30,436.00 73.43 11,014.00 101-4-2110-4404 Equip Repair/Maint Services 65,050.00 0.00 52,805.17 81.18 12,244.83 101-4-2110-4433 Dues & Subscriptions 5,500.00 360.00 3,004.00 54.62 2,496.00 101-4-2110-4437 Taxes & Licenses 350.00 12.00 120.00 34.29 230.00 TOTAL Other Services & Charges 164,250.00 13,068.35 110,658.37 67.37 53,591.63 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 713,700.00 49,802.75 458,338.76 64.22 255,361.24 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,642,400.00 117,827.55 992,428.45 60.43 649,971.55 101-4-2120-4102 Overtime Pay 90,000.00 1,605.20 35,938.15 39.93 54,061.85 101-4-2120-4104 PERA 280,650.00 19,348.14 170,687.30 60.82 109,962.70 101-4-2120-4107 Medicare 23,800.00 1,561.49 13,842.01 58.16 9,957.99 101-4-2120-4108 Insurance 176,550.00 14,750.00 120,675.64 68.35 55,874.36 TOTAL Personal Services 2,213,400.00 155,092.38 1,333,571.55 60.25 879,828.45 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-2120-4212 Fuels & Lubes 88,000.00 5,744.89 48,493.30 55.11 39,506.70 101-4-2120-4217 Uniform Allowance 35,100.00 495.59 8,768.73 24.98 26,331.27 101-4-2120-4219 Operating Supplies 75,550.00 ( 5,646.69) 36,576.83 48.41 38,973.17 101-4-2120-4221 Equipment Parts 23,300.00 2,202.88 6,623.30 28.43 16,676.70 TOTAL Supplies 221,950.00 2,796.67 100,462.16 45.26 121,487.84 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,300.00 396.00 16,026.51 56.63 12,273.49 101-4-2120-4404 Equip Repair/Maint Services 20,700.00 0.00 4,104.23 19.83 16,595.77 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 455.00 70.00 195.00 101-4-2120-4460 Equip Replacement Charge 45,150.00 3,762.50 30,100.00 66.67 15,050.00 TOTAL Other Services & Charges 94,800.00 4,158.50 50,685.74 53.47 44,114.26 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,530,150.00 162,047.55 1,484,719.45 58.68 1,045,430.55 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 676,050.00 48,283.20 423,875.14 62.70 252,174.86 101-4-2130-4102 Overtime Pay 50,000.00 1,464.75 22,633.83 45.27 27,366.17 101-4-2130-4104 PERA 117,600.00 8,059.16 69,979.67 59.51 47,620.33 101-4-2130-4107 Medicare 9,200.00 653.53 5,394.36 58.63 3,805.64 101-4-2130-4108 Insurance 95,250.00 7,341.07 55,758.07 58.54 39,491.93 TOTAL Personal Services 948,100.00 65,801.71 577,641.07 60.93 370,458.93 Supplies 101-4-2130-4217 Uniform Allowance 6,800.00 317.60 3,990.42 58.68 2,809.58 101-4-2130-4219 Operating Supplies 7,600.00 94.83 5,793.96 76.24 1,806.04 TOTAL Supplies 14,400.00 412.43 9,784.38 67.95 4,615.62 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,500.00 229.00 761.00 11.71 5,739.00 101-4-2130-4331 Travel, Conferences & Schools 9,700.00 55.18 7,061.08 72.79 2,638.92 101-4-2130-4433 Dues & Subscriptions 2,100.00 110.00 745.86 35.52 1,354.14 101-4-2130-4460 Equip Replacement Charge 13,200.00 1,100.00 8,800.00 66.67 4,400.00 TOTAL Other Services & Charges 31,500.00 1,494.18 17,367.94 55.14 14,132.06 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 994,000.00 67,708.32 604,793.39 60.84 389,206.61 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND Public Safety 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 342,950.00 25,387.89 204,404.51 59.60 138,545.49 101-4-2150-4102 Overtime Pay 10,000.00 107.79 2,470.52 24.71 7,529.48 101-4-2150-4103 Part-time Pay 37,600.00 2,876.00 21,488.54 57.15 16,111.46 101-4-2150-4104 PERA 29,300.00 2,127.87 17,566.65 59.95 11,733.35 101-4-2150-4105 FICA 24,200.00 1,703.40 14,913.31 61.63 9,286.69 101-4-2150-4107 Medicare 5,650.00 398.39 3,494.45 61.85 2,155.55 101-4-2150-4108 Insurance 60,900.00 4,779.00 38,232.18 62.78 22,667.82 TOTAL Personal Services 510,600.00 37,380.34 302,570.16 59.26 208,029.84 Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2150-4217 Uniform Allowance 4,500.00 353.05 1,914.47 42.54 2,585.53 101-4-2150-4219 Operating Supplies 18,900.00 1,102.88 5,612.50 29.70 13,287.50 TOTAL Supplies 24,400.00 1,455.93 7,526.97 30.85 16,873.03 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 4,800.00 75.00 982.13 20.46 3,817.87 101-4-2150-4404 Equip Repair/Maint Services 2,250.00 0.00 1,749.92 77.77 500.08 101-4-2150-4409 Contractual Services 10,000.00 918.25 3,088.25 30.88 6,911.75 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 300.00 54.55 250.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 4,000.00 66.67 2,000.00 TOTAL Other Services & Charges 23,600.00 1,493.25 10,120.30 42.88 13,479.70 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 558,600.00 40,329.52 320,217.43 57.32 238,382.57 Police Reserves =============== Personal Services 101-4-2160-4101 Regular Pay 0.00 81.01 287.23 0.00 ( 287.23) 101-4-2160-4103 Part-time Pay 5,500.00 0.00 719.60 13.08 4,780.40 101-4-2160-4104 PERA 0.00 0.00 8.84 0.00 ( 8.84) 101-4-2160-4105 FICA 350.00 5.02 63.85 18.24 286.15 101-4-2160-4107 Medicare 100.00 1.17 14.93 14.93 85.07 TOTAL Personal Services 5,950.00 87.20 1,094.45 18.39 4,855.55 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 110.00 1,093.10 19.87 4,406.90 101-4-2160-4219 Operating Supplies 6,500.00 0.00 5,021.88 77.26 1,478.12 TOTAL Supplies 12,000.00 110.00 6,114.98 50.96 5,885.02 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-2160-4319 Other Professional Services 2,100.00 0.00 545.00 25.95 1,555.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 1,395.00 26.32 3,905.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 23,250.00 197.20 8,604.43 37.01 14,645.57 Public safety building ====================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 16,600.00 1,597.39 10,264.06 61.83 6,335.94 TOTAL Supplies 16,600.00 1,597.39 10,264.06 61.83 6,335.94 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 1,231.00 3,753.00 72.17 1,447.00 101-4-2190-4389 Utilities 97,500.00 7,734.77 53,944.81 55.33 43,555.19 101-4-2190-4401 Bldg Repair/Maint Services 36,700.00 8,092.37 20,805.54 56.69 15,894.46 TOTAL Other Services & Charges 139,400.00 17,058.14 78,503.35 56.32 60,896.65 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,000.00 18,655.53 88,767.41 56.90 67,232.59 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 233,350.00 18,207.30 147,879.48 63.37 85,470.52 101-4-2310-4104 PERA 34,450.00 2,680.94 21,156.42 61.41 13,293.58 101-4-2310-4105 FICA 2,400.00 193.41 1,540.30 64.18 859.70 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 30,000.00 100.00 0.00 101-4-2310-4107 Medicare 3,400.00 250.81 2,088.44 61.42 1,311.56 101-4-2310-4108 Insurance 29,100.00 2,549.38 20,136.39 69.20 8,963.61 101-4-2310-4109 Workers Comp 8,800.00 0.00 6,664.50 75.73 2,135.50 TOTAL Personal Services 341,500.00 23,881.84 229,465.53 67.19 112,034.47 Supplies 101-4-2310-4201 Office Supplies 3,150.00 0.00 2,910.49 92.40 239.51 101-4-2310-4212 Fuels & Lubes 2,500.00 220.92 2,412.34 96.49 87.66 101-4-2310-4217 Uniform Allowance 6,500.00 18.85 1,136.50 17.48 5,363.50 101-4-2310-4219 Operating Supplies 1,000.00 324.71 1,649.78 164.98 ( 649.78) 101-4-2310-4221 Equipment Parts 700.00 0.00 0.00 0.00 700.00 TOTAL Supplies 13,850.00 564.48 8,109.11 58.55 5,740.89 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-2310-4319 Other Professional Services 10,000.00 0.00 1,697.50 16.98 8,302.50 101-4-2310-4321 Telephone 3,100.00 259.95 1,955.55 63.08 1,144.45 101-4-2310-4322 Postage 500.00 0.00 440.99 88.20 59.01 101-4-2310-4331 Travel, Conferences & Schools 7,500.00 0.00 1,393.45 18.58 6,106.55 101-4-2310-4359 Publishing 750.00 0.00 120.00 16.00 630.00 101-4-2310-4361 Insurance 12,000.00 2,388.25 8,199.25 68.33 3,800.75 101-4-2310-4389 Utilities 22,250.00 1,265.51 10,270.61 46.16 11,979.39 101-4-2310-4401 Bldg Repair/Maint Services 5,500.00 2,847.55 7,657.35 139.22 ( 2,157.35) 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 10.00 10.00 0.34 2,940.00 101-4-2310-4433 Dues & Subscriptions 2,050.00 0.00 1,834.00 89.46 216.00 101-4-2310-4460 Equip Replacement Charge 53,800.00 4,483.33 35,866.64 66.67 17,933.36 TOTAL Other Services & Charges 120,400.00 11,254.59 69,445.34 57.68 50,954.66 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 475,750.00 35,700.91 307,019.98 64.53 168,730.02 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 19,218.29 106,777.73 62.92 62,922.27 101-4-2320-4105 FICA 10,500.00 1,130.77 6,258.45 59.60 4,241.55 101-4-2320-4107 Medicare 2,450.00 264.51 1,463.69 59.74 986.31 101-4-2320-4108 Insurance 0.00 126.89 240.98 0.00 ( 240.98) 101-4-2320-4109 Workers Comp 27,400.00 0.00 21,746.25 79.37 5,653.75 TOTAL Personal Services 210,050.00 20,740.46 136,487.10 64.98 73,562.90 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 37.22 12.41 262.78 101-4-2320-4212 Fuels & Lubes 8,700.00 502.10 4,664.29 53.61 4,035.71 101-4-2320-4217 Uniform Allowance 9,300.00 172.30 3,133.20 33.69 6,166.80 101-4-2320-4219 Operating Supplies 72,900.00 4,545.79 42,519.58 58.33 30,380.42 101-4-2320-4221 Equipment Parts 7,450.00 686.45 10,646.10 142.90 ( 3,196.10) TOTAL Supplies 98,650.00 5,906.64 61,000.39 61.84 37,649.61 Other Services & Charges 101-4-2320-4321 Telephone 4,650.00 398.14 2,218.60 47.71 2,431.40 101-4-2320-4331 Travel, Conferences & Schools 26,000.00 1,372.05 13,339.99 51.31 12,660.01 101-4-2320-4404 Equip Repair/Maint Services 36,300.00 5,509.23 24,578.40 67.71 11,721.60 101-4-2320-4409 Contractual Services 5,650.00 0.00 4,447.25 78.71 1,202.75 TOTAL Other Services & Charges 72,600.00 7,279.42 44,584.24 61.41 28,015.76 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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 Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 381,300.00 33,926.52 242,071.73 63.49 139,228.27 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,100.00 769.11 2,086.35 29.39 5,013.65 TOTAL Supplies 7,100.00 769.11 2,086.35 29.39 5,013.65 Other Services & Charges 101-4-2330-4321 Telephone 0.00 0.00 149.62 0.00 ( 149.62) 101-4-2330-4331 Travel, Conferences & Schools 10,400.00 0.00 0.00 0.00 10,400.00 101-4-2330-4389 Utilities 3,650.00 332.24 2,381.16 65.24 1,268.84 101-4-2330-4404 Equip Repair/Maint Services 3,450.00 2,015.53 3,519.29 102.01 ( 69.29) 101-4-2330-4433 Dues & Subscriptions 200.00 0.00 260.00 130.00 ( 60.00) TOTAL Other Services & Charges 17,700.00 2,347.77 6,310.07 35.65 11,389.93 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 24,800.00 3,116.88 8,396.42 33.86 16,403.58 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 450,050.00 35,056.04 288,293.80 64.06 161,756.20 101-4-2410-4104 PERA 40,300.00 3,130.54 25,936.13 64.36 14,363.87 101-4-2410-4105 FICA 23,250.00 1,644.95 13,962.40 60.05 9,287.60 101-4-2410-4107 Medicare 6,550.00 462.57 3,930.19 60.00 2,619.81 101-4-2410-4108 Insurance 78,600.00 6,588.00 52,704.30 67.05 25,895.70 101-4-2410-4109 Workers Comp 2,050.00 0.00 1,562.25 76.21 487.75 TOTAL Personal Services 600,800.00 46,882.10 386,389.07 64.31 214,410.93 Supplies 101-4-2410-4201 Office Supplies 7,700.00 107.27 2,455.90 31.89 5,244.10 101-4-2410-4212 Fuels & Lubes 5,000.00 537.04 3,897.41 77.95 1,102.59 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 0.00 0.00 1,750.00 101-4-2410-4219 Operating Supplies 9,550.00 251.66 1,760.28 18.43 7,789.72 TOTAL Supplies 24,000.00 895.97 8,113.59 33.81 15,886.41 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-2410-4321 Telephone 5,650.00 344.94 1,223.81 21.66 4,426.19 101-4-2410-4322 Postage 700.00 0.00 177.18 25.31 522.82 101-4-2410-4331 Travel, Conferences & Schools 3,800.00 0.00 1,883.71 49.57 1,916.29 101-4-2410-4361 Insurance 450.00 139.00 361.50 80.33 88.50 101-4-2410-4404 Equip Repair/Maint Services 5,600.00 0.00 2,465.00 44.02 3,135.00 101-4-2410-4433 Dues & Subscriptions 3,500.00 0.00 1,660.00 47.43 1,840.00 101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 2,166.64 66.67 1,083.36 TOTAL Other Services & Charges 22,950.00 754.77 9,937.84 43.30 13,012.16 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 647,750.00 48,532.84 404,440.50 62.44 243,309.50 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 70,300.00 5,408.00 44,886.40 63.85 25,413.60 101-4-2420-4104 PERA 5,250.00 405.60 3,447.60 65.67 1,802.40 101-4-2420-4105 FICA 4,350.00 347.50 2,961.04 68.07 1,388.96 101-4-2420-4107 Medicare 1,000.00 81.27 692.50 69.25 307.50 101-4-2420-4108 Insurance 3,600.00 300.00 2,400.06 66.67 1,199.94 101-4-2420-4109 Workers Comp 300.00 0.00 245.25 81.75 54.75 TOTAL Personal Services 84,800.00 6,542.37 54,632.85 64.43 30,167.15 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 85.58 787.50 39.38 1,212.50 101-4-2420-4217 Uniform Allowance 350.00 0.00 216.65 61.90 133.35 101-4-2420-4219 Operating Supplies 1,100.00 0.00 16.00 1.45 1,084.00 TOTAL Supplies 3,450.00 85.58 1,020.15 29.57 2,429.85 Other Services & Charges 101-4-2420-4321 Telephone 800.00 51.29 443.63 55.45 356.37 101-4-2420-4322 Postage 1,750.00 0.00 588.08 33.60 1,161.92 101-4-2420-4331 Travel, Conferences & Schools 700.00 0.00 770.00 110.00 ( 70.00) 101-4-2420-4361 Insurance 100.00 21.25 76.25 76.25 23.75 TOTAL Other Services & Charges 3,350.00 72.54 1,877.96 56.06 1,472.04 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 91,600.00 6,700.49 57,530.96 62.81 34,069.04 Environmental ============= 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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 101-4-2440-4101 Regular Pay 26,900.00 2,111.30 16,991.80 63.17 9,908.20 101-4-2440-4104 PERA 2,000.00 158.34 1,304.83 65.24 695.17 101-4-2440-4105 FICA 1,650.00 130.89 1,078.63 65.37 571.37 101-4-2440-4107 Medicare 400.00 30.61 252.25 63.06 147.75 101-4-2440-4108 Insurance 3,350.00 283.50 2,778.90 82.95 571.10 101-4-2440-4109 Workers Comp 300.00 0.00 208.50 69.50 91.50 TOTAL Personal Services 34,600.00 2,714.64 22,614.91 65.36 11,985.09 Supplies 101-4-2440-4201 Office Supplies 450.00 6.09 29.22 6.49 420.78 101-4-2440-4212 Fuels & Lubes 200.00 3.15 86.41 43.21 113.59 101-4-2440-4219 Operating Supplies 0.00 76.24 895.84 0.00 ( 895.84) TOTAL Supplies 650.00 85.48 1,011.47 155.61 ( 361.47) Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-2440-4322 Postage 700.00 0.00 61.90 8.84 638.10 101-4-2440-4331 Travel, Conferences & Schools 1,150.00 0.00 1,725.88 150.08 ( 575.88) 101-4-2440-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2440-4409 Contractual Services 1,000.00 288.60 541.12 54.11 458.88 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 3,850.00 288.60 2,508.90 65.17 1,341.10 ___________________________________________________________________________________________________________________ TOTAL Environmental 39,100.00 3,088.72 26,135.28 66.84 12,964.72 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,636,000.00 469,807.23 4,011,035.74 60.44 2,624,964.26 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 493,750.00 46,168.81 335,781.30 68.01 157,968.70 101-4-3120-4102 Overtime Pay 4,000.00 0.00 1,049.92 26.25 2,950.08 101-4-3120-4103 Part-time Pay 77,000.00 5,512.98 45,225.57 58.73 31,774.43 101-4-3120-4104 PERA 41,450.00 3,761.53 28,016.45 67.59 13,433.55 101-4-3120-4105 FICA 35,650.00 3,038.05 23,052.80 64.66 12,597.20 101-4-3120-4107 Medicare 8,350.00 710.53 5,391.39 64.57 2,958.61 101-4-3120-4108 Insurance 75,050.00 7,442.00 49,910.68 66.50 25,139.32 101-4-3120-4109 Workers Comp 28,600.00 0.00 21,716.25 75.93 6,883.75 TOTAL Personal Services 763,850.00 66,633.90 510,144.36 66.79 253,705.64 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-3120-4201 Office Supplies 2,850.00 95.16 1,606.58 56.37 1,243.42 101-4-3120-4212 Fuels & Lubes 66,200.00 11,116.23 10,721.52 16.20 55,478.48 101-4-3120-4219 Operating Supplies 60,000.00 5,710.82 35,271.87 58.79 24,728.13 101-4-3120-4221 Equipment Parts 50,000.00 5,478.39 35,096.48 70.19 14,903.52 101-4-3120-4226 Street Signs 30,500.00 1,156.05 28,644.13 93.92 1,855.87 TOTAL Supplies 209,550.00 23,556.65 111,340.58 53.13 98,209.42 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 140.54 25.55 409.46 101-4-3120-4321 Telephone 6,100.00 554.56 2,843.40 46.61 3,256.60 101-4-3120-4322 Postage 100.00 0.00 27.63 27.63 72.37 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 1,541.55 30.23 3,558.45 101-4-3120-4359 Publishing 200.00 0.00 48.00 24.00 152.00 101-4-3120-4361 Insurance 19,000.00 4,412.00 13,438.75 70.73 5,561.25 101-4-3120-4389 Utilities 102,800.00 6,410.66 50,283.83 48.91 52,516.17 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 1,874.25 6,451.69 32.26 13,548.31 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 3,590.45 39.89 5,409.55 101-4-3120-4409 Contractual Services 63,500.00 0.00 21,426.91 33.74 42,073.09 101-4-3120-4415 Equipment Rental 3,000.00 0.00 609.81 20.33 2,390.19 101-4-3120-4417 Uniform Rental 5,800.00 343.46 2,892.10 49.86 2,907.90 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 280.00 80.00 70.00 101-4-3120-4437 Taxes & Licenses 150.00 0.00 464.00 309.33 ( 314.00) 101-4-3120-4460 Equip Replacement Charge 100,950.00 8,412.50 67,300.00 66.67 33,650.00 TOTAL Other Services & Charges 336,600.00 22,007.43 171,338.66 50.90 165,261.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,310,000.00 112,197.98 792,823.60 60.52 517,176.40 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 137,650.00 0.00 52,468.97 38.12 85,181.03 101-4-3130-4102 Overtime Pay 20,000.00 0.00 4,226.28 21.13 15,773.72 101-4-3130-4104 PERA 11,400.00 0.00 4,560.68 40.01 6,839.32 101-4-3130-4105 FICA 9,750.00 0.00 3,608.48 37.01 6,141.52 101-4-3130-4107 Medicare 2,300.00 0.00 843.93 36.69 1,456.07 101-4-3130-4108 Insurance 19,850.00 0.00 9,884.63 49.80 9,965.37 101-4-3130-4109 Workers Comp 8,150.00 0.00 5,948.25 72.98 2,201.75 TOTAL Personal Services 209,100.00 0.00 81,541.22 39.00 127,558.78 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-3130-4219 Operating Supplies 72,450.00 2,655.43 69,296.05 95.65 3,153.95 TOTAL Supplies 72,450.00 2,655.43 69,296.05 95.65 3,153.95 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 281,550.00 2,655.43 150,837.27 53.57 130,712.73 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 113,250.00 8,508.80 69,182.37 61.09 44,067.63 101-4-3150-4102 Overtime Pay 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4104 PERA 8,700.00 638.16 5,313.02 61.07 3,386.98 101-4-3150-4105 FICA 7,200.00 509.93 4,252.60 59.06 2,947.40 101-4-3150-4107 Medicare 1,700.00 119.26 994.56 58.50 705.44 101-4-3150-4108 Insurance 14,850.00 1,178.00 9,362.70 63.05 5,487.30 101-4-3150-4109 Workers Comp 3,150.00 0.00 2,391.75 75.93 758.25 TOTAL Personal Services 151,850.00 10,954.15 91,497.00 60.25 60,353.00 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 178.66) 3,439.30 67.44 1,660.70 101-4-3150-4219 Operating Supplies 11,150.00 300.94 5,272.88 47.29 5,877.12 101-4-3150-4221 Equipment Parts 3,000.00 126.41 3,005.05 100.17 ( 5.05) TOTAL Supplies 19,250.00 248.69 11,717.23 60.87 7,532.77 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 695.12 23.17 2,304.88 101-4-3150-4404 Equip Repair/Maint Services 10,000.00 0.00 1,407.40 14.07 8,592.60 101-4-3150-4417 Uniform Rental 2,150.00 214.55 1,366.25 63.55 783.75 TOTAL Other Services & Charges 15,150.00 214.55 3,468.77 22.90 11,681.23 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 186,250.00 11,417.39 106,683.00 57.28 79,567.00 Engineering =========== 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND Public Works 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-3300-4101 Regular Pay 166,250.00 12,786.36 106,126.82 63.84 60,123.18 101-4-3300-4104 PERA 12,450.00 958.98 8,151.33 65.47 4,298.67 101-4-3300-4105 FICA 10,300.00 772.08 6,865.74 66.66 3,434.26 101-4-3300-4107 Medicare 2,400.00 180.57 1,605.70 66.90 794.30 101-4-3300-4108 Insurance 7,200.00 1,457.00 5,657.00 78.57 1,543.00 101-4-3300-4109 Workers Comp 750.00 0.00 581.25 77.50 168.75 TOTAL Personal Services 199,350.00 16,154.99 128,987.84 64.70 70,362.16 Supplies 101-4-3300-4201 Office Supplies 300.00 12.19 58.46 19.49 241.54 101-4-3300-4212 Fuels & Lubes 950.00 89.41 456.93 48.10 493.07 101-4-3300-4219 Operating Supplies 3,000.00 21.80 795.46 26.52 2,204.54 TOTAL Supplies 4,250.00 123.40 1,310.85 30.84 2,939.15 Other Services & Charges 101-4-3300-4319 Other Professional Services 7,000.00 0.00 690.13 9.86 6,309.87 101-4-3300-4321 Telephone 1,400.00 90.29 580.23 41.45 819.77 101-4-3300-4322 Postage 300.00 0.00 95.97 31.99 204.03 101-4-3300-4331 Travel, Conferences & Schools 1,850.00 0.00 360.24 19.47 1,489.76 101-4-3300-4361 Insurance 100.00 21.25 65.75 65.75 34.25 101-4-3300-4404 Equip Repair/Maint Services 2,200.00 0.00 0.00 0.00 2,200.00 101-4-3300-4460 Equip Replacement Charge 1,500.00 125.00 1,000.00 66.67 500.00 TOTAL Other Services & Charges 14,350.00 236.54 2,792.32 19.46 11,557.68 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 217,950.00 16,514.93 133,091.01 61.06 84,858.99 ___________________________________________________________________________________________________________________ TOTAL Public Works 1,995,750.00 142,785.73 1,183,434.88 59.30 812,315.12 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 409,900.00 27,240.35 274,106.81 66.87 135,793.19 101-4-5110-4102 Overtime Pay 6,600.00 225.87 3,486.14 52.82 3,113.86 101-4-5110-4103 Part-time Pay 68,250.00 7,395.00 26,725.00 39.16 41,525.00 101-4-5110-4104 PERA 31,250.00 2,059.68 19,277.53 61.69 11,972.47 101-4-5110-4105 FICA 30,050.00 1,979.90 17,549.04 58.40 12,500.96 101-4-5110-4107 Medicare 7,050.00 463.03 4,104.20 58.22 2,945.80 101-4-5110-4108 Insurance 73,500.00 5,480.00 48,921.45 66.56 24,578.55 101-4-5110-4109 Workers Comp 12,000.00 0.00 9,296.25 77.47 2,703.75 101-4-5110-4110 Re-employment Compensation 0.00 0.00 2,108.00 0.00 ( 2,108.00) TOTAL Personal Services 638,600.00 44,843.83 405,574.42 63.51 233,025.58 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-5110-4212 Fuels & Lubes 29,750.00 2,380.54 14,667.76 49.30 15,082.24 101-4-5110-4217 Uniform Allowance 3,800.00 0.00 2,306.89 60.71 1,493.11 101-4-5110-4219 Operating Supplies 94,900.00 10,104.47 51,647.64 54.42 43,252.36 101-4-5110-4221 Equipment Parts 26,000.00 1,556.18 14,399.42 55.38 11,600.58 TOTAL Supplies 154,450.00 14,041.19 83,021.71 53.75 71,428.29 Other Services & Charges 101-4-5110-4321 Telephone 4,900.00 377.93 709.46 14.48 4,190.54 101-4-5110-4322 Postage 100.00 0.00 86.66 86.66 13.34 101-4-5110-4331 Travel, Conferences & Schools 4,600.00 0.00 1,939.92 42.17 2,660.08 101-4-5110-4361 Insurance 30,250.00 8,212.75 22,904.75 75.72 7,345.25 101-4-5110-4389 Utilities 75,250.00 9,240.24 32,382.87 43.03 42,867.13 101-4-5110-4401 Bldg Repair/Maint Services 4,150.00 0.00 42.50 1.02 4,107.50 101-4-5110-4404 Equip Repair/Maint Services 17,650.00 2,563.20 4,233.07 23.98 13,416.93 101-4-5110-4409 Contractual Services 45,150.00 4,566.85 13,465.60 29.82 31,684.40 101-4-5110-4415 Equipment Rental 14,150.00 2,967.50 11,147.00 78.78 3,003.00 101-4-5110-4460 Equip Replacement Charge 48,850.00 4,070.83 32,566.64 66.67 16,283.36 TOTAL Other Services & Charges 245,050.00 31,999.30 119,478.47 48.76 125,571.53 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,038,100.00 90,884.32 608,074.60 58.58 430,025.40 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 294,400.00 22,755.17 187,456.81 63.67 106,943.19 101-4-5210-4103 Part-time Pay 48,450.00 3,660.14 30,510.81 62.97 17,939.19 101-4-5210-4104 PERA 25,700.00 1,983.46 16,746.39 65.16 8,953.61 101-4-5210-4105 FICA 21,250.00 1,563.83 13,261.52 62.41 7,988.48 101-4-5210-4107 Medicare 4,950.00 365.74 3,101.49 62.66 1,848.51 101-4-5210-4108 Insurance 42,700.00 3,284.00 26,188.84 61.33 16,511.16 101-4-5210-4109 Workers Comp 3,650.00 0.00 2,705.25 74.12 944.75 TOTAL Personal Services 441,100.00 33,612.34 279,971.11 63.47 161,128.89 Supplies 101-4-5210-4219 Operating Supplies 10,200.00 770.32 4,466.47 43.79 5,733.53 TOTAL Supplies 10,200.00 770.32 4,466.47 43.79 5,733.53 Other Services & Charges 101-4-5210-4321 Telephone 6,400.00 250.08 ( 778.48) 12.16- 7,178.48 101-4-5210-4322 Postage 5,300.00 0.00 1,749.46 33.01 3,550.54 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 340.09 2,555.10 25.94 7,294.90 101-4-5210-4349 Advertising/Marketing 33,200.00 2,918.37 12,106.10 36.46 21,093.90 101-4-5210-4361 Insurance 400.00 106.75 294.75 73.69 105.25 101-4-5210-4389 Utilities 11,300.00 881.36 4,896.45 43.33 6,403.55 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND Culture & Recreation 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 1,044.75 8,191.96 47.63 9,008.04 101-4-5210-4404 Equip Repair/Maint Services 8,400.00 0.00 8,310.57 98.94 89.43 101-4-5210-4433 Dues & Subscriptions 2,350.00 0.00 2,435.00 103.62 ( 85.00) TOTAL Other Services & Charges 94,400.00 5,541.40 39,760.91 42.12 54,639.09 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 545,700.00 39,924.06 324,198.49 59.41 221,501.51 Recreation Programs =================== Personal Services 101-4-5220-4102 Overtime Pay 0.00 19.69 169.00 0.00 ( 169.00) 101-4-5220-4103 Part-time Pay 82,000.00 14,028.48 55,278.24 67.41 26,721.76 101-4-5220-4105 FICA 4,300.00 870.99 3,503.91 81.49 796.09 101-4-5220-4107 Medicare 1,200.00 203.72 819.46 68.29 380.54 TOTAL Personal Services 87,500.00 15,122.88 59,770.61 68.31 27,729.39 Supplies 101-4-5220-4219 Operating Supplies 28,000.00 262.13 14,072.81 50.26 13,927.19 TOTAL Supplies 28,000.00 262.13 14,072.81 50.26 13,927.19 Other Services & Charges 101-4-5220-4409 Contractual Services 45,000.00 6,798.50 35,804.50 79.57 9,195.50 101-4-5220-4412 Building Rent 1,650.00 0.00 1,164.50 70.58 485.50 101-4-5220-4438 Credit Card Fees 3,600.00 182.01 2,422.82 67.30 1,177.18 TOTAL Other Services & Charges 50,250.00 6,980.51 39,391.82 78.39 10,858.18 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 165,750.00 22,365.52 113,235.24 68.32 52,514.76 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 118,900.00 9,350.40 75,037.96 63.11 43,862.04 101-4-5510-4103 Part-time Pay 3,150.00 276.00 2,198.40 69.79 951.60 101-4-5510-4104 PERA 8,900.00 701.28 5,761.98 64.74 3,138.02 101-4-5510-4105 FICA 7,550.00 568.85 4,681.38 62.01 2,868.62 101-4-5510-4107 Medicare 1,750.00 133.04 1,094.84 62.56 655.16 101-4-5510-4108 Insurance 21,650.00 1,787.00 14,296.06 66.03 7,353.94 101-4-5510-4109 Workers Comp 550.00 0.00 411.00 74.73 139.00 TOTAL Personal Services 162,450.00 12,816.57 103,481.62 63.70 58,968.38 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 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-5510-4219 Operating Supplies 16,500.00 482.45 10,104.55 61.24 6,395.45 TOTAL Supplies 16,500.00 482.45 10,104.55 61.24 6,395.45 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 112.45 809.51 33.73 1,590.49 101-4-5510-4322 Postage 3,000.00 600.00 1,820.46 60.68 1,179.54 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 52.59 806.10 26.43 2,243.90 101-4-5510-4361 Insurance 1,400.00 323.00 992.00 70.86 408.00 101-4-5510-4389 Utilities 25,550.00 1,689.70 11,635.71 45.54 13,914.29 101-4-5510-4401 Bldg Repair/Maint Services 16,050.00 1,440.25 6,701.75 41.76 9,348.25 101-4-5510-4404 Equip Repair/Maint Services 100.00 0.00 16.75 16.75 83.25 101-4-5510-4409 Contractual Services 11,600.00 3,030.53 7,672.92 66.15 3,927.08 101-4-5510-4433 Dues & Subscriptions 850.00 242.24 646.72 76.08 203.28 TOTAL Other Services & Charges 64,000.00 7,490.76 31,101.92 48.60 32,898.08 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 242,950.00 20,789.78 144,688.09 59.55 98,261.91 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 1,992,500.00 173,963.68 1,190,196.42 59.73 802,303.58 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 6,780.06 27,299.42 0.00 ( 27,299.42) 101-4-6210-4103 Part-time Pay 0.00 1,050.00 2,100.00 0.00 ( 2,100.00) 101-4-6210-4104 PERA 0.00 508.50 2,054.94 0.00 ( 2,054.94) 101-4-6210-4105 FICA 0.00 452.89 1,757.60 0.00 ( 1,757.60) 101-4-6210-4107 Medicare 0.00 105.92 410.92 0.00 ( 410.92) 101-4-6210-4108 Insurance 0.00 894.60 2,982.00 0.00 ( 2,982.00) TOTAL Personal Services 0.00 9,791.97 36,604.88 0.00 ( 36,604.88) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 112.46 270.11 0.00 ( 270.11) TOTAL Other Services & Charges 0.00 112.46 270.11 0.00 ( 270.11) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 9,904.43 36,874.99 0.00 ( 36,874.99) Energy City =========== 9-13-2016 04:55 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2016 101-GENERAL FUND Economic Development 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-6220-4101 Regular Pay 9,000.00 703.76 5,663.96 62.93 3,336.04 101-4-6220-4104 PERA 700.00 52.78 434.90 62.13 265.10 101-4-6220-4105 FICA 550.00 43.64 359.60 65.38 190.40 101-4-6220-4107 Medicare 150.00 10.20 84.04 56.03 65.96 101-4-6220-4108 Insurance 1,100.00 94.50 616.74 56.07 483.26 TOTAL Personal Services 11,500.00 904.88 7,159.24 62.25 4,340.76 Supplies 101-4-6220-4219 Operating Supplies 1,800.00 0.00 47.60 2.64 1,752.40 TOTAL Supplies 1,800.00 0.00 47.60 2.64 1,752.40 Other Services & Charges 101-4-6220-4319 Other Professional Services 500.00 628.50 1,978.50 395.70 ( 1,478.50) 101-4-6220-4331 Travel, Conferences & Schools 1,000.00 0.00 48.21 4.82 951.79 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Other Services & Charges 3,000.00 628.50 2,026.71 67.56 973.29 ___________________________________________________________________________________________________________________ TOTAL Energy City 16,300.00 1,533.38 9,233.55 56.65 7,066.45 ___________________________________________________________________________________________________________________ TOTAL Economic Development 16,300.00 11,437.81 46,108.54 282.87 ( 29,808.54) Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 13,884,800.00 1,083,236.20 8,533,020.65 61.46 5,351,779.35 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 800,209.82)( 736,217.23) 736,217.23 CITY OF ELK RIVER ENTERPRISE FUNDS-BUDGET TO ACTUAL MONTH ENDED AUGUST,2016 Liquor', Sewer Garbage, Stormwater, Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Sales and cost of sales: Sales $ 6,934,000 $ 4,483,399 $ 2,450,601 64.66% Cost of sales (4,957,300) (2,883,697) (2,073,603) 58.17% Gross profit 1,976,700 1,599,702 376,998 80.93% Operating revenues: User charges $ - $ - $ - 0.00% $ 1,860,000 $ 1,103,415 $ 756,585 59.32% $ 1,310,000 $ 780,570 $ 529,430 59.59% $ 420,000 $ 262,640 $ 157,360 62.53% Delinquency collections - - - 0.00% 1,300 1,479 (179) 113.77% 13,000 4,584 8,416 35.26% - 544 (544) 0.00% Other 1,700 1,647 53 96.88% 2,000 - 2,000 0.00% 3,500 1,331 2,169 38.03% - 11 (11) 0.00% Total operating revenues 1,700 1,647 53 96.88% 1,863,300 1,104,894 758,406 59.30% 1,326,500 786,485 540,015 59.29% 420,000 263,195 156,805 62.67% Operating expenses: Personal services 659,850 422,423 237,427 64.02% 532,650 338,066 194,584 63.47% 22,900 14,318 8,582 62.52% 80,650 51,009 29,641 63.25% Supplies 53,700 12,659 41,041 23.57% 217,800 47,118 170,682 21.63% 6,300 2,046 4,254 32.48% 7,000 90 6,910 1.29% Other service charges 231,950 151,293 80,657 65.23% 517,200 322,051 195,149 62.27% 1,340,700 836,875 503,825 62.42% 403,150 87,653 315,497 21.74% Depreciation* 123,000 - 123,000 0.00% 1,424,350 - 1,424,350 0.00% - - - 0.00% 433,750 - 433,750 0.00% Total operating expenses 1,068,500 586,375 482,125 54.88% 2,692,000 707,235 1,984,765 26.27% 1,369,900 853,239 516,661 62.28% 924,550 138,752 785,798 15.01% Operating income(loss) 909,900 1,014,974 (105,074) 111.55% (828,700) 397,659 (1,226,359) -47.99% (43,400) (66,754) 23,354 153.81% (504,550) 124,443 (628,993) -24.66% Nonoperating revenues(expenses): Interest income 25,000 27,770 (2,770) 111.08% 80,000 51,205 28,795 64.01% 6,250 4,644 1,606 74.30% 1,500 2,053 (553) 136.87% Grant revenue - - - 0.00% 800,000 339,728 460,272 42.47% - - - 0.00% - - - 0.00% Interest expense - - - 0.00% (272,400) (157,236) (115,164) 57.72% - - - 0.00% - - - 0.00% Total nonoperating revenues(expenses) 25,000 27,770 (2,770) 111.08% 607,600 233,697 373,903 38.46% 6,250 4,644 1,606 74.30% 1,500 2,053 (553) 136.87% Income(loss)before contributions and transfers 934,900 1,042,744 (107,844) 111.54% (221,100) 631,356 (852,456) -285.55% (37,150) (62,110) 24,960 167.19% (503,050) 126,496 (629,546) -25.15% Contributions-connection fees - - - 0.00% 492,700 299,053 193,647 60.70% - - - 0.00% 51,500 10,704 40,796 20.78% Sale of assets - - - 0.00% - 36,500 (36,500) 0.00% - - - 0.00% - - - 0.00% Transfers in - - - 0.00% - - - 0.00% 36,600 - 36,600 0.00% - - - 0.00% Transfers out (718,950) (704,567) (14,383) 98.00% (100,000) (100,000) - 100.00% (45,000) (45,000) - 100.00% (5,000) (5,000) - 100.00% NET INCOME(LOSS) 215,950 338,177 122,227 156.60% 171,600 866,909 (695,309) 505.19% 45,550 107,110 61,560 235.15% 4569550 132,200 588,750 -28.96% Items reclassified to balance sheet at year end: Capital Outlay (5,012,000) (2,509,757) (2,502,243) 50.07% Bond Payment (400,000) (400,000) - 100.00% Revenues over/(under)expenditures 215,950 338,177 (122,227) (5,240,400) (2,042,848) (3,197,552) (45,550) (107,110) 61,560 (456,550) 132,200 (588,750) *Recorded at yearend 9-13-2016 05:19 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: AUGUST 31ST, 2016 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 25,290.65 2,955.06 28,245.71 101-1010 Cash - General Fund 6,464,742.48 ( 795,961.32) 5,668,781.16 211-1010 Cash - Library 439,710.27 ( 10,859.81) 428,850.46 221-1010 Cash - Ice Arena 364,043.84 ( 18,934.83) 345,109.01 225-1010 Cash - Park Dedication 52,699.42 ( 2,406.75) 50,292.67 228-1010 Cash - Landfill 449,004.11 4,866.67 453,870.78 231-1010 Cash - Landfill Const Debris 733,677.62 0.00 733,677.62 240-1010 Cash - Micro Loan Fund 593,961.33 3,082.54 597,043.87 241-1010 Cash - Federal DEED 200,000.00 0.00 200,000.00 242-1010 Cash - State DEED 109,695.26 1,886.49 111,581.75 245-1010 Cash - Development Fund 884,660.19 ( 8,935.49) 875,724.70 290-1010 Cash - Capital Outlay Reserve 816,320.48 ( 28,468.28) 787,852.20 291-1010 Cash - Insurance Reserve 178,289.32 ( 40,289.72) 137,999.60 292-1010 Cash - Govt Bldgs Reserve 1,764,555.54 ( 344,674.50) 1,419,881.04 294-1010 Cash - Drug Forfeiture 11,211.56 151.29 11,362.85 295-1010 Cash - Severance Pay Reserve 71,680.59 0.00 71,680.59 296-1010 Cash - GRE Reserve 1,815,714.78 0.00 1,815,714.78 313-1010 Cash - 2007C/2012B GO Bonds 184,018.99 ( 5,950.00) 178,068.99 333-1010 Cash - 2010A GO Cap Imp Bonds 472,670.42 166,925.00 639,595.42 344-1010 Cash - 2006C Cap Imp Bonds Lby ( 450.00) 450.00 0.00 345-1010 Cash - 2012A CIP Bonds-PW ( 450.00) 450.00 0.00 401-1010 Cash - Pavement Mgmt 3,452,258.30 ( 16,276.69) 3,435,981.61 403-1010 Cash - Street Improvement 1,370,387.45 ( 10,463.93) 1,359,923.52 406-1010 Cash - City Wide Trunk Util 3,818,659.56 20,158.00 3,838,817.56 410-1010 Cash - Equipment Replacement 780,003.39 20,642.23 800,645.62 440-1010 Cash - Park Improvement 552,724.81 ( 57,256.01) 495,468.80 456-1010 Cash - TIF #16 King/Main 52,154.26 ( 52,154.26) 0.00 462-1010 Cash - TIF #22 Downtown Redev 0.00 ( 600.00) ( 600.00) 463-1010 Cash - TIF #23 Pref Powder 1,207.51 ( 600.00) 607.51 602-1010 Cash - Wastewater Treatment 5,346,980.32 ( 374,781.15) 4,972,199.17 603-1010 Cash - Liquor 2,965,134.45 ( 4,451.14) 2,960,683.31 605-1010 Cash - Garbage 458,610.28 ( 14,567.53) 444,042.75 607-1010 Cash - Storm Water 325,380.35 29,384.22 354,764.57 801-1010 Cash - Interest 23,213.79 65,279.15 88,492.94 821-1010 Cash - Developer Escrow 187,338.34 6,308.00 193,646.34_ TOTAL CLAIM ON CASH 34,965,099.66 ( 1,465,092.76) 33,500,006.90 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 77,889,937.06 ( 472,299.01) 77,417,638.05 999-1001 PY BANK ACCOUNT (71,307,026.96) ( 992,793.75) (72,299,820.71) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 34,965,099.66 ( 1,465,092.76) 33,500,006.90