Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 07-21-2014
Information City of Memorandum River TO: Mayor and City Council From: Tim Simon, Finance Director Date: July 21, 2014 Subject: June 2014 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Arena and Pinewood Golf Special Revenue Funds. These funds provide an important picture of the city's financial health. For the month of June,actual revenues (except for property taxes and state aids) and expenditures should run about 50% 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: • The first installment of the first half property taxes, our largest revenue source,was received in June with the remaining first half to be received early July. • Licenses and permits collections are over 51% of budget estimates,with the majority of the June collections coming from building permits. • Charges for services are over 72% of budget with June revenues consisting of the second half school liaison and Otsego fire contract billings. ■ Fines and forfeits collections,which lag a month,are over 50% of budget estimates. ■ The transfers in reflect the Utilities' 3% contribution based on electric sales through May. Most other transfers will be recorded in July. Expenditures: ■ Excluding transfers,total departmental expenditures are about 44% of budget and most departments are within or below budget. p0WIeEa 0 AVRE 2014 Monthly Expenditures $14,000 $12,000 o $10,000 z $8,000 _ $6,000 $4,000 $2,000 $0 Jan Feb *Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $962 $1,891 $2,882 $3,850 $4,699 $5,688 Budget $1,073 1 $2,1461$3,219 $4,292 $5,365 $6,438 $7,511 $8,584 $9,657 $10,730$11,803$12,876 Ice Arena For June,revenues exceed expenditures by$33,490. Revenues of$333,592 are about 43% of budget and expenditures of$300,102 are about 30% of budget estimates. Pinewood Golf For June, expenditures total$53,472, consisting mainly of personal services and ongoing expenditures such as insurance and utilities. Personal services will be reallocated at year end to those departments where staff time was utilized during the year. Attachments ■ General Fund Revenue &Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 INFORMATION 101-GENERAL FUND FINANCIAL SUMMARY 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,870,500.00 3,385,710.80 4,260,614.53 33.1C 8,609,885.47 TOTAL REVENUES 12,870,500.00 3,385,710.80 4,260,614.53 33.10 8,609,885.47 EXPENDITURE SUMMARY General Government Mayor & Council 150,550.00 4,819.57 52,081.39 34.59 98,468.61 Cable TV 93,000.00 7,062.87 39,776.01 42.77 53,223.99 Administrative Services 594,000.00 41,914.94 263,620.57 44.38 330,379.43 Human Resources 96,000.00 7,055.11 42,392.71 44.16 53,607.29 Elections 38,750.00 0.00 247.78 0.64 38,502.22 Finance 560,850.00 39,792.18 313,804.07 55.95 247,045.93 Information Technology 297,600.00 20,843.68 127,503.71 42.84 170,096.29 Legal 218,000.00 13,116.99 83,609.50 38.35 134,390.5C Community Development 325,500.00 24,559.06 147,307.81 45.26 178,192.19 Planning 192,500.00 14,109.15 84,939.66 44.12 107,560.34 City Hall Maintenance 544,950.00 46,883.33 264,547.96 48.55 280,402.04 Contingency 47,500.00) 0.00 0.00 O.00 ( 47,500.00) TOTAL General Government 3,064,200.00 220,156.88 1,419,831.17 46.34 1,644,368.83 Public Safety Police Administration 629,650.00 49,573.72 330,081.91 52.42 299,568.09 Patrol 2,428,450.00 192,026.87 1,014,837.30 41.79 1,413,612.7C Investigations 807,050.00 56,466.64 341,102.60 42.27 465,947.4C Police Support Services 526,300.00 38,407.06 224,123.02 42.58 302,176.98 Police Reserves 20,700.00 14.34 3,846.90 18.58 16,853.1C Public safety building 63,050.00 4,290.51 33,350.64 52.90 29,699.36 Fire Administration 372,450.00 19,899.98 124,076.45 33.31 248,373.55 Fire Operations 391,450.00 26,757.90 142,258.56 36.34 249,191.44 Emergency Management 24,150.00 1,847.22 3,578.03 14.82 20,571.97 Building Safety 617,950.00 46,992.76 272,133.13 44.04 345,816.87 Code Enforcement 88,600.00 6,873.94 40,860.46 46.12 47,739.54 Environmental 31,800.00 3,136.43 11,226.50 35.3C 20,573.5C TOTAL Public Safety 6,001,600.00 446,287.37 2,541,475.50 42.35 3,460,124.5C Public Works Street Maintenance 1,239,750.00 120,519.26 528,842.33 42.66 710,907.67 Snow Removal 277,750.00 5,407.83 243,468.19 87.66 34,281.81 Equipment Services 184,150.00 16,322.60 89,650.50 48.68 94,499.5C Engineering 166,850.00 15,533.36 92,689.77 55.55 74,160.23 TOTAL Public Works 1,868,500.00 157,783.05 954,650.79 51.09 913,849.21 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND FINANCIAL SUMMARY 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 938,450.00 88,270.22 374,678.53 39.93 563,771.47 Parks & Rec Admin 531,800.00 38,101.38 244,289.85 45.94 287,510.1E Recreation Programs 200,200.00 23,338.39 46,670.77 23.31 153,529.23 Sr Citizen Programs 193,550.00 15,281.69 91,143.65 47.09 102,406.35 TOTAL Culture & Recreation 1,864,000.00 164,991.68 756,782.80 40.60 1,107,217.20 Economic Development Economic Development 0.00 ( 606.49) 13,463.23 0.00 ( 13,463.23) Energy City 12,100.00 367.82 1,807.97 14.94 10,292.03 TOTAL Economic Development 12,100.00 ( 238.67) 15,271.20 126.21 ( 3,171.20) General Transfers Out 60,100.00 0.00 0.00 O.00 60,100.00 TOTAL General 60,100.00 0.00 0.00 O.00 60,100.00 TOTAL EXPENDITURES 12,870,500.00 988,980.31 5,688,011.46 44.19 7,182,488.54 REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,396,730.49 ( 1,427,396.93) 1,427,396.93 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,181,300.00 3,028,694.54 3,030,295.50 33.01 6,151,004.5C 101-3-0000-3121 Gravel Tax 125,000.00 0.00 8,059.11 6.45 116,940.89 TOTAL Taxes 9,306,300.00 3,028,694.54 3,038,354.61 32.65 6,267,945.39 Licenses & Permits 101-3-0000-3211 Liquor License 62,000.00 5,390.00 60,885.00 98.20 1,115.00 101-3-0000-3212 Amusement License 1,400.00 0.00 0.00 0.00 1,400.00 101-3-0000-3213 Cigarette License 3,000.00 75.00 75.00 2.50 2,925.00 101-3-0000-3214 Apartment License 27,000.00 2,668.00 7,088.00 26.25 19,912.00 101-3-0000-3216 Mining License 21,000.00 900.00 23,260.15 110.76 ( 2,260.15) 101-3-0000-3217 Garbage Hauler License 2,000.00 0.00 165.00 8.25 1,835.00 101-3-0000-3218 Other Business License/Permit 16,500.00 250.00 3,630.00 22.00 12,870.00 101-3-0000-3229 NPDES Permit 5,000.00 2,450.00 5,075.00 101.50 ( 75.00) 101-3-0000-3231 Building Permit 230,000.00 57,438.85 142,278.85 61.86 87,721.1E 101-3-0000-3232 Plumbing/Heating Permit 190,000.00 6,307.11 39,659.66 20.87 150,340.34 101-3-0000-3233 Permit Surcharge 2,000.00 2,018.76 4,622.80 231.14 ( 2,622.80) 101-3-0000-3235 Animal License 6,000.00 260.00 3,654.00 60.90 2,346.00 101-3-0000-3236 Parking Permit 1,500.00 0.00 430.40 28.69 1,069.6C 101-3-0000-3237 Other Non-Business Lic/Permit 8,500.00 785.00 4,145.00 48.76 4,355.00 TOTAL Licenses & Permits 575,900.00 78,542.72 294,968.86 51.22 280,931.14 Intergovernmental Rev 101-3-0000-3324 PERA Aid 14,100.00 0.00 0.00 0.00 14,100.00 101-3-0000-3325 Police 20 Aid 220,000.00 0.00 0.00 0.00 220,000.00 101-3-0000-3326 Police Training Reimb 11,400.00 0.00 0.00 0.00 11,400.00 101-3-0000-3329 State Crime Prevention Grant 30,000.00 ( 7,444.48) 8,644.60 28.82 21,355.4C 101-3-0000-3330 Other State Grants 2,400.00 0.00 0.00 O.00 2,400.00 TOTAL Intergovernmental Rev 277,900.00 ( 7,444.48) 8,644.60 3.11 269,255.4C Charges for Services 101-3-0000-3412 Planning & Zoning Fees 12,000.00 325.00 6,287.50 52.40 5,712.5C 101-3-0000-3413 Plan Check Fee 90,000.00 26,889.92 58,345.66 64.83 31,654.34 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 280.00 28.00 720.00 101-3-0000-3417 Copies 2,600.00 96.89 963.29 37.05 1,636.71 101-3-0000-3418 Other General Govt Services 4,000.00 13.00 1,668.13 41.70 2,331.87 101-3-0000-3430 Lockout Fees 7,500.00 590.00 3,720.00 49.60 3,780.00 101-3-0000-3431 Police Services 4,000.00 ( 40.00) 600.00 15.00 3,400.00 101-3-0000-3432 School Liaison 99,300.00 61,812.00 99,312.00 100.01 ( 12.00) 101-3-0000-3434 Animal Impound Fee 3,500.00 200.00 1,500.00 42.86 2,000.00 101-3-0000-3436 Fire Contracts 201,000.00 94,254.50 206,950.00 102.96 ( 5,950.00) 101-3-0000-3437 Fire Services 4,000.00 66.85 2,689.90 67.25 1,310.1C 101-3-0000-3438 Fire Inspections 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3451 Street Services 29,000.00 690.00 9,343.23 32.22 19,656.77 101-3-0000-3452 Engineering Services Reimb 87,350.00 0.00 39,131.07 44.80 48,218.93 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3461 Recreation Fees 125,000.00 7,109.00 64,485.95 51.59 60,514.OH 101-3-0000-3462 Sr Center Activities 20,050.00 1,429.00 15,507.46 77.34 4,542.54 101-3-0000-3472 Park Use Fee 20,800.00 7,796.37 16,794.65 80.74 4,005.3H 101-3-0000-3475 Building Rent 2,400.00 400.00 1,400.00 58.33 1,000.00 101-3-0000-3483 Sewer Inspection Fee 4,900.00 1,190.00 3,075.00 62.76 1,825.00 101-3-0000-3484 Contractor License Check 400.00 105.00 315.00 78.75 85.00 TOTAL Charges for Services 732,800.00 202,987.53 532,368.84 72.65 200,431.16 Fines & Forfeits 101-3-0000-3510 Court Fines 110,000.00 10,716.77 56,792.79 51.63 53,207.21 101-3-0000-3511 Parking Fines 12,000.00 240.00 5,290.00 44.08 6,710.00 101-3-0000-3512 Ordinance Violations 200.00 0.00 0.00 O.00 200.00 TOTAL Fines & Forfeits 122,200.00 10,956.77 62,082.79 50.80 60,117.21 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 ( 13,934.14) 16.39- 98,934.14 101-3-0000-3625 Refunds & Reimbursements 101,000.00 0.00 5,844.37 5.79 95,155.63 101-3-0000-3626 Contributions 15,000.00 9,090.00 23,090.00 153.93 ( 8,090.00) 101-3-0000-3629 Miscellaneous Revenue 6,000.00 492.69 5,695.58 94.93 304.42 TOTAL Other Revenue 207,000.00 9,582.69 20,695.81 10.00 186,304.19 Transfers In 101-3-0000-3921 Transfers 222,850.00 0.00 0.00 0.00 222,850.00 101-3-0000-3925 Transfer-Landfill 53,150.00 0.00 0.00 0.00 53,150.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 0.00 0.00 39,500.00 101-3-0000-3930 Transfer-Development 48,600.00 0.00 0.00 0.00 48,600.00 101-3-0000-3942 Transfer-WWTS 98,650.00 0.00 0.00 0.00 98,650.00 101-3-0000-3943 Transfer-Liquor 361,850.00 0.00 0.00 0.00 361,850.00 101-3-0000-3944 Transfer-Garbage 43,150.00 0.00 0.00 0.00 43,150.00 101-3-0000-3945 Transfer-Utilities 725,900.00 62,391.03 303,499.02 41.81 422,400.98 101-3-0000-3948 Transfer-EDA 31,900.00 0.00 0.00 0.00 31,900.00 101-3-0000-3949 Transfer-HRA 22,850.00 0.00 0.00 O.00 22,850.00 TOTAL Transfers In 1,648,400.00 62,391.03 303,499.02 18.41 1,344,900.98 TOTAL General Fund 12,870,500.00 3,385,710.80 4,260,614.53 33.10 8,609,885.47 TOTAL REVENUE 12,870,500.00 3,385,710.80 4,260,614.53 33.10 8,609,885.47 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o 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 19,249.59 50.00 19,250.41 101-4-1110-4104 PERA 1,900.00 70.84 425.04 22.37 1,474.96 101-4-1110-4105 FICA 2,400.00 147.26 883.54 36.81 1,516.46 101-4-1110-4107 Medicare 550.00 46.52 279.11 50.75 270.89 101-4-1110-4109 Workers Comp 100.00 19.00 57.00 57.00 43.00 TOTAL Personal Services 43,450.00 3,491.94 20,894.28 48.09 22,555.72 Supplies 101-4-1110-4201 Office Supplies 1,800.00 3.86 369.73 20.54 1,430.27 TOTAL Supplies 1,800.00 3.86 369.73 20.54 1,430.27 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 1,172.37 4,312.46 41.47 6,087.54 101-4-1110-4322 Postage 400.00 0.00 0.00 0.00 400.00 101-4-1110-4331 Travel, Conferences & Schools 3,100.00 0.00 43.68 1.41 3,056.32 101-4-1110-4359 Publishing 3,700.00 0.00 468.45 12.66 3,231.5E 101-4-1110-4361 Insurance 57,500.00 0.00 20,096.50 34.95 37,403.5C 101-4-1110-4433 Dues & Subscriptions 17,550.00 0.00 500.00 2.85 17,050.00 101-4-1110-4440 Miscellaneous 12,650.00 151.40 5,396.29 42.66 7,253.71 TOTAL Other Services & Charges 105,300.00 1,323.77 30,817.38 29.27 74,482.62 Capital Outlay TOTAL Mayor & Council 150,550.00 4,819.57 52,081.39 34.59 98,468.61 Cable TV Personal Services 101-4-1120-4101 Regular Pay 60,900.00 4,684.80 27,640.32 45.39 33,259.68 101-4-1120-4103 Part-time Pay 6,900.00 245.31 692.84 10.04 6,207.16 101-4-1120-4104 PERA 4,400.00 339.64 2,204.36 50.10 2,195.64 101-4-1120-4105 FICA 4,200.00 254.65 1,625.85 38.71 2,574.1E 101-4-1120-4107 Medicare 1,000.00 59.56 380.25 38.03 619.7E 101-4-1120-4108 Insurance 13,200.00 1,102.01 6,612.06 50.09 6,587.94 101-4-1120-4109 Workers Comp 300.00 72.00 216.00 72.00 84.00 TOTAL Personal Services 90,900.00 6,757.97 39,371.68 43.31 51,528.32 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1120-4201 Office Supplies 750.00 3.86 99.39 13.25 650.61 TOTAL Supplies 750.00 3.86 99.39 13.25 650.61 Other Services & Charges 101-4-1120-4322 Postage 50.00 0.00 3.90 7.80 46.1C 101-4-1120-4331 Travel, Conferences & Schools 1,150.00 301.04 301.04 26.18 848.96 101-4-1120-4404 Equip Repair/Maint Services 150.00 0.00 0.00 O.00 150.00 TOTAL Other Services & Charges 1,350.00 301.04 304.94 22.59 1,045.06 Capital Outlay TOTAL Cable TV 93,000.00 7,062.87 39,776.01 42.77 53,223.99 Administrative Services Personal Services 101-4-1210-4101 Regular Pay 372,250.00 28,525.58 168,300.92 45.21 203,949.08 101-4-1210-4103 Part-time Pay 45,600.00 3,342.96 19,120.78 41.93 26,479.22 101-4-1210-4104 PERA 30,300.00 2,310.45 14,945.33 49.32 15,354.67 101-4-1210-4105 FICA 25,900.00 1,885.06 12,296.78 47.48 13,603.22 101-4-1210-4107 Medicare 6,050.00 440.86 2,875.81 47.53 3,174.19 101-4-1210-4108 Insurance 33,650.00 3,064.05 18,939.50 56.28 14,710.5C 101-4-1210-4109 Workers Comp 1,750.00 432.25 1,296.75 74.1C 453.25 TOTAL Personal Services 515,500.00 40,001.21 237,775.87 46.13 277,724.13 Supplies 101-4-1210-4201 Office Supplies 10,250.00 145.28 1,631.31 15.92 8,618.69 TOTAL Supplies 10,250.00 145.28 1,631.31 15.92 8,618.69 Other Services & Charges 101-4-1210-4319 Other Professional Services 11,100.00 0.00 512.00 4.61 10,588.00 101-4-1210-4321 Telephone 1,100.00 86.32 436.17 39.65 663.83 101-4-1210-4322 Postage 1,000.00 0.00 5,368.18 536.82 ( 4,368.18) 101-4-1210-4331 Travel, Conferences & Schools 8,900.00 67.71 1,551.91 17.44 7,348.09 101-4-1210-4334 Car Allowance 4,800.00 400.00 2,400.00 50.00 2,400.00 101-4-1210-4359 Publishing 12,000.00 0.00 6,277.00 52.31 5,723.00 101-4-1210-4361 Insurance 200.00 0.00 60.50 30.25 139.5C 101-4-1210-4404 Equip Repair/Maint Services 27,400.00 1,035.16 5,969.91 21.79 21,430.09 101-4-1210-4433 Dues & Subscriptions 1,750.00 179.26 1,637.72 93.58 112.28 TOTAL Other Services & Charges 68,250.00 1,768.45 24,213.39 35.48 44,036.61 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Administrative Services 594,000.00 41,914.94 263,620.57 44.38 330,379.43 Human Resources Personal Services 101-4-1220-4101 Regular Pay 72,000.00 5,538.70 32,678.33 45.39 39,321.67 101-4-1220-4104 PERA 5,200.00 401.56 2,639.50 50.76 2,560.5C 101-4-1220-4105 FICA 4,450.00 330.94 2,181.57 49.02 2,268.43 101-4-1220-4107 Medicare 1,050.00 77.40 510.22 48.59 539.78 101-4-1220-4108 Insurance 6,750.00 562.00 3,461.92 51.29 3,288.08 101-4-1220-4109 Workers Comp 300.00 74.50 223.50 74.5C 76.5C TOTAL Personal Services 89,750.00 6,985.10 41,695.04 46.46 48,054.96 Supplies 101-4-1220-4201 Office Supplies 850.00 27.06 294.36 34.63 555.64 TOTAL Supplies 850.00 27.06 294.36 34.63 555.64 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,000.00 42.95 202.75 20.28 797.2E 101-4-1220-4322 Postage 500.00 0.00 68.37 13.67 431.63 101-4-1220-4331 Travel, Conferences & Schools 3,000.00 0.00 132.19 4.41 2,867.81 101-4-1220-4433 Dues & Subscriptions 900.00 0.00 0.00 O.00 900.00 TOTAL Other Services & Charges 5,400.00 42.95 403.31 7.47 4,996.69 Capital Outlay TOTAL Human Resources 96,000.00 7,055.11 42,392.71 44.16 53,607.29 Elections Personal Services 101-4-1230-4103 Part-time Pay 30,000.00 0.00 0.00 O.00 30,000.00 TOTAL Personal Services 30,000.00 0.00 0.00 0.00 30,000.00 Supplies 101-4-1230-4219 Operating Supplies 4,800.00 0.00 165.28 3.44 4,634.72 TOTAL Supplies 4,800.00 0.00 165.28 3.44 4,634.72 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1230-4322 Postage 600.00 0.00 0.00 0.00 600.00 101-4-1230-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00 101-4-1230-4359 Publishing 1,400.00 0.00 82.50 5.89 1,317.5C 101-4-1230-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 101-4-1230-4415 Equipment Rental 1,350.00 0.00 0.00 O.00 1,350.00 TOTAL Other Services & Charges 3,950.00 0.00 82.50 2.09 3,867.5C Capital Outlay TOTAL Elections 38,750.00 0.00 247.78 0.64 38,502.22 Finance Personal Services 101-4-1310-4101 Regular Pay 305,450.00 23,494.10 138,615.19 45.38 166,834.81 101-4-1310-4103 Part-time Pay 51,300.00 3,747.84 23,892.48 46.57 27,407.52 101-4-1310-4104 PERA 25,850.00 1,975.04 12,954.27 50.11 12,895.73 101-4-1310-4105 FICA 22,100.00 1,621.38 10,687.70 48.36 11,412.3C 101-4-1310-4107 Medicare 5,200.00 379.19 2,499.50 48.07 2,700.5C 101-4-1310-4108 Insurance 32,250.00 2,689.62 16,013.72 49.65 16,236.28 101-4-1310-4109 Workers Comp 1,500.00 369.00 1,107.00 73.8C 393.00 TOTAL Personal Services 443,650.00 34,276.17 205,769.86 46.38 237,880.14 Supplies 101-4-1310-4201 Office Supplies 10,400.00 177.59 6,790.22 65.29 3,609.78 TOTAL Supplies 10,400.00 177.59 6,790.22 65.29 3,609.78 Other Services & Charges 101-4-1310-4301 Audit Fees 18,450.00 4,440.00 17,940.00 97.24 510.00 101-4-1310-4319 Other Professional Services 56,000.00 0.00 53,332.00 95.24 2,668.00 101-4-1310-4321 Telephone 400.00 31.86 224.72 56.18 175.28 101-4-1310-4322 Postage 2,300.00 33.89 921.19 40.05 1,378.81 101-4-1310-4331 Travel, Conferences & Schools 2,800.00 297.64 1,638.04 58.50 1,161.96 101-4-1310-4359 Publishing 600.00 0.00 0.00 0.00 600.00 101-4-1310-4404 Equip Repair/Maint Services 20,900.00 0.00 20,809.00 99.56 91.00 101-4-1310-4433 Dues & Subscriptions 1,500.00 0.00 735.00 49.00 765.00 101-4-1310-4438 Credit Card Fees 2,500.00 535.03 5,218.94 208.76 ( 2,718.94) 101-4-1310-4440 Miscellaneous 1,350.00 0.00 425.10 31.49 924.9C TOTAL Other Services & Charges 106,800.00 5,338.42 101,243.99 94.80 5,556.01 Capital Outlay TOTAL Finance 560,850.00 39,792.18 313,804.07 55.95 247,045.93 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Information Technology Personal Services 101-4-1350-4101 Regular Pay 178,500.00 13,417.16 70,351.32 39.41 108,148.68 101-4-1350-4104 PERA 12,950.00 972.74 5,576.78 43.06 7,373.22 101-4-1350-4105 FICA 11,050.00 776.39 4,434.35 40.13 6,615.6E 101-4-1350-4107 Medicare 2,600.00 181.58 1,037.06 39.89 1,562.94 101-4-1350-4108 Insurance 32,900.00 2,484.01 12,708.32 38.63 20,191.68 101-4-1350-4109 Workers Comp 650.00 165.25 495.75 76.27 154.25 TOTAL Personal Services 238,650.00 17,997.13 94,603.58 39.64 144,046.42 Supplies 101-4-1350-4219 Operating Supplies 22,750.00 1,026.66 3,431.10 15.08 19,318.9C TOTAL Supplies 22,750.00 1,026.66 3,431.10 15.08 19,318.9C Other Services & Charges 101-4-1350-4319 Other Professional Services 6,000.00 0.00 0.00 0.00 6,000.00 101-4-1350-4321 Telephone 2,100.00 145.48 499.71 23.80 1,600.29 101-4-1350-4331 Travel, Conferences & Schools 6,900.00 72.41 4,482.21 64.96 2,417.79 101-4-1350-4404 Equip Repair/Maint Services 21,200.00 1,602.00 13,587.11 64.09 7,612.89 TOTAL Other Services & Charges 36,200.00 1,819.89 18,569.03 51.30 17,630.97 Capital Outlay 101-4-1350-4560 Equipment 0.00 0.00 10,900.00 O.00 ( 10,900.00) TOTAL Capital Outlay 0.00 0.00 10,900.00 0.00 ( 10,900.00) TOTAL Information Technology 297,600.00 20,843.68 127,503.71 42.84 170,096.29 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 218,000.00 13,116.99 83,609.50 38.35 134,390.5C TOTAL Other Services & Charges 218,000.00 13,116.99 83,609.50 38.35 134,390.5C TOTAL Legal 218,000.00 13,116.99 83,609.50 38.35 134,390.5C 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: It REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Community Development Personal Services 101-4-1500-4101 Regular Pay 259,150.00 19,636.56 115,855.70 44.71 143,294.3C 101-4-1500-4104 PERA 18,800.00 1,423.66 9,239.87 49.15 9,560.13 101-4-1500-4105 FICA 16,050.00 1,179.02 7,670.95 47.79 8,379.0E 101-4-1500-4107 Medicare 3,750.00 275.72 1,793.90 47.84 1,956.1C 101-4-1500-4108 Insurance 20,150.00 1,682.01 10,092.06 50.08 10,057.94 101-4-1500-4109 Workers Comp 1,100.00 268.00 804.00 73.09 296.00 TOTAL Personal Services 319,000.00 24,464.97 145,456.48 45.60 173,543.52 Supplies 101-4-1500-4201 Office Supplies 1,850.00 27.06 254.50 13.76 1,595.5C TOTAL Supplies 1,850.00 27.06 254.50 13.76 1,595.5C Other Services & Charges 101-4-1500-4321 Telephone 1,050.00 67.03 563.16 53.63 486.84 101-4-1500-4331 Travel, Conferences & Schools 2,950.00 0.00 483.67 16.40 2,466.33 101-4-1500-4433 Dues & Subscriptions 650.00 0.00 550.00 84.62 100.00 TOTAL Other Services & Charges 4,650.00 67.03 1,596.83 34.34 3,053.17 TOTAL Community Development 325,500.00 24,559.06 147,307.81 45.26 178,192.19 Planning Personal Services 101-4-1510-4101 Regular Pay 124,950.00 9,521.16 56,174.84 44.96 68,775.16 101-4-1510-4104 PERA 9,050.00 690.28 4,477.07 49.47 4,572.93 101-4-1510-4105 FICA 7,750.00 462.32 3,153.01 40.68 4,596.99 101-4-1510-4107 Medicare 1,800.00 108.12 737.37 40.97 1,062.63 101-4-1510-4108 Insurance 23,050.00 2,204.00 12,660.00 54.92 10,390.00 101-4-1510-4109 Workers Comp 800.00 106.00 318.00 39.75 482.00 TOTAL Personal Services 167,400.00 13,091.88 77,520.29 46.31 89,879.71 Supplies 101-4-1510-4201 Office Supplies 1,400.00 46.38 693.23 49.52 706.77 TOTAL Supplies 1,400.00 46.38 693.23 49.52 706.77 Other Services & Charges 101-4-1510-4321 Telephone 50.00 26.54 136.79 273.58 ( 86.79) 101-4-1510-4322 Postage 2,500.00 0.00 186.21 7.45 2,313.79 101-4-1510-4331 Travel, Conferences & Schools 1,150.00 18.13 112.66 9.80 1,037.34 101-4-1510-4359 Publishing 15,500.00 450.00 2,287.50 14.76 13,212.5C 101-4-1510-4361 Insurance 200.00 0.00 60.50 30.25 139.5C 101-4-1510-4404 Equip Repair/Maint Services 3,650.00 476.22 2,830.48 77.55 819.52 101-4-1510-4433 Dues & Subscriptions 400.00 0.00 308.00 77.00 92.00 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1510-4440 Miscellaneous 250.00 0.00 804.00 321.6C ( 554.00) TOTAL Other Services & Charges 23,700.00 970.89 6,726.14 28.38 16,973.86 Capital Outlay TOTAL Planning 192,500.00 14,109.15 84,939.66 44.12 107,560.34 City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 326,000.00 25,076.31 147,859.51 45.36 178,140.49 101-4-1600-4102 Overtime Pay 3,500.00 20.59 393.91 11.25 3,106.09 101-4-1600-4103 Part-time Pay 3,350.00 570.05 698.15 20.84 2,651.85 101-4-1600-4104 PERA 24,100.00 1,820.65 11,783.57 48.89 12,316.43 101-4-1600-4105 FICA 20,650.00 1,627.11 10,319.98 49.98 10,330.02 101-4-1600-4107 Medicare 4,800.00 380.52 2,413.43 50.28 2,386.57 101-4-1600-4108 Insurance 40,850.00 2,886.04 17,016.20 41.66 23,833.8C 101-4-1600-4109 Workers Comp 10,150.00 2,538.25 7,614.75 75.02 2,535.25 TOTAL Personal Services 433,400.00 34,919.52 198,099.50 45.71 235,300.5C Supplies 101-4-1600-4212 Fuels & Lubes 3,500.00 473.75 1,962.12 56.06 1,537.88 101-4-1600-4217 Uniform Allowance 1,700.00 155.00 716.45 42.14 983.5E 101-4-1600-4219 Operating Supplies 29,000.00 4,621.40 17,302.48 59.66 11,697.52 TOTAL Supplies 34,200.00 5,250.15 19,981.05 58.42 14,218.9E Other Services & Charges 101-4-1600-4321 Telephone 11,500.00 802.51 4,657.13 40.50 6,842.87 101-4-1600-4331 Travel, Conferences & Schools 1,200.00 671.25 1,031.25 85.94 168.7E 101-4-1600-4361 Insurance 4,900.00 0.00 2,384.00 48.65 2,516.00 101-4-1600-4389 Utilities 30,050.00 2,585.46 22,633.50 75.32 7,416.5C 101-4-1600-4401 Bldg Repair/Maint Services 24,650.00 2,566.94 15,120.33 61.34 9,529.67 101-4-1600-4404 Equip Repair/Maint Services 4,000.00 0.00 116.20 2.91 3,883.8C 101-4-1600-4460 Equip Replacement Charge 1,050.00 87.50 525.00 50.00 525.00 TOTAL Other Services & Charges 77,350.00 6,713.66 46,467.41 60.07 30,882.59 Capital Outlay TOTAL City Hall Maintenance 544,950.00 46,883.33 264,547.96 48.55 280,402.04 Contingency 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General Government 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1900-4101 Regular Pay 95,000.00) 0.00 0.00 O.00 ( 95,000.00) TOTAL Personal Services 95,000.00) 0.00 0.00 0.00 ( 95,000.00) Other Services & Charges 101-4-1900-4440 Miscellaneous 47,500.00 0.00 0.00 O.00 47,500.00 TOTAL Other Services & Charges 47,500.00 0.00 0.00 0.00 47,500.00 TOTAL Contingency 47,500.00) 0.00 0.00 0.00 ( 47,500.00) TOTAL General Government 3,064,200.00 220,156.88 1,419,831.17 46.34 1,644,368.83 Police Administration Personal Services 101-4-2110-4101 Regular Pay 341,150.00 25,920.58 152,931.44 44.83 188,218.56 101-4-2110-4104 PERA 48,250.00 3,688.82 23,941.10 49.62 24,308.9C 101-4-2110-4105 FICA 3,050.00 173.38 1,144.83 37.54 1,905.17 101-4-2110-4107 Medicare 3,400.00 245.98 1,612.58 47.43 1,787.42 101-4-2110-4108 Insurance 33,350.00 3,066.03 18,396.18 55.16 14,953.82 101-4-2110-4109 Workers Comp 51,800.00 12,953.50 38,860.50 75.02 12,939.5C TOTAL Personal Services 481,000.00 46,048.29 236,886.63 49.25 244,113.37 Supplies 101-4-2110-4201 Office Supplies 10,250.00 537.35 2,615.20 25.51 7,634.8C 101-4-2110-4217 Uniform Allowance 2,800.00 53.10 1,963.78 70.14 836.22 101-4-2110-4219 Operating Supplies 5,250.00 214.97 6,568.99 125.12 ( 1,318.99) TOTAL Supplies 18,300.00 805.42 11,147.97 60.92 7,152.03 Other Services & Charges 101-4-2110-4319 Other Professional Services 5,400.00 38.37 449.73 8.33 4,950.27 101-4-2110-4321 Telephone 22,950.00 2,026.98 9,256.47 40.33 13,693.53 101-4-2110-4322 Postage 3,000.00 ( 10.07) 539.65 17.99 2,460.3E 101-4-2110-4331 Travel, Conferences & Schools 5,800.00 0.00 3,147.51 54.27 2,652.49 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 9,300.00 0.00 21,626.00 232.54 ( 12,326.00) 101-4-2110-4404 Equip Repair/Maint Services 78,500.00 321.73 44,574.45 56.78 33,925.55 101-4-2110-4433 Dues & Subscriptions 4,600.00 215.00 2,145.00 46.63 2,455.00 101-4-2110-4437 Taxes & Licenses 300.00 128.00 308.50 102.83 ( 8.5C) TOTAL Other Services & Charges 130,350.00 2,720.01 82,047.31 62.94 48,302.69 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Police Administration 629,650.00 49,573.72 330,081.91 52.42 299,568.09 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,571,300.00 111,798.06 648,666.38 41.28 922,633.62 101-4-2120-4102 Overtime Pay 90,000.00 11,283.42 26,469.50 29.41 63,530.5C 101-4-2120-4104 PERA 254,200.00 18,831.46 114,226.68 44.94 139,973.32 101-4-2120-4107 Medicare 22,850.00 1,581.70 9,545.98 41.78 13,304.02 101-4-2120-4108 Insurance 174,200.00 15,046.14 90,476.97 51.94 83,723.03 TOTAL Personal Services 2,112,550.00 158,540.78 889,385.51 42.10 1,223,164.49 Supplies 101-4-2120-4212 Fuels & Lubes 125,000.00 18,617.51 56,733.29 45.39 68,266.71 101-4-2120-4217 Uniform Allowance 19,350.00 2,077.94 8,245.59 42.61 11,104.41 101-4-2120-4219 Operating Supplies 63,550.00 3,417.59 23,061.54 36.29 40,488.46 101-4-2120-4221 Equipment Parts 23,300.00 1,697.21 6,536.39 28.05 16,763.61 TOTAL Supplies 231,200.00 25,810.25 94,576.81 40.91 136,623.19 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 22,750.00 4,156.27 9,431.43 41.46 13,318.57 101-4-2120-4404 Equip Repair/Maint Services 25,700.00 497.90 3,388.53 13.18 22,311.47 101-4-2120-4433 Dues & Subscriptions 650.00 55.00 255.00 39.23 395.00 101-4-2120-4460 Equip Replacement Charge 35,600.00 2,966.67 17,800.02 50.00 17,799.98 TOTAL Other Services & Charges 84,700.00 7,675.84 30,874.98 36.45 53,825.02 Capital Outlay TOTAL Patrol 2,428,450.00 192,026.87 1,014,837.30 41.79 1,413,612.70 Investigations Personal Services 101-4-2130-4101 Regular Pay 546,300.00 39,358.41 232,152.47 42.50 314,147.53 101-4-2130-4102 Overtime Pay 45,000.00 2,336.19 9,537.70 21.19 35,462.3C 101-4-2130-4104 PERA 90,450.00 6,379.27 40,683.62 44.98 49,766.38 101-4-2130-4107 Medicare 7,300.00 446.50 2,879.80 39.45 4,420.2C 101-4-2130-4108 Insurance 78,400.00 6,566.22 39,197.19 50.00 39,202.81 TOTAL Personal Services 767,450.00 55,086.59 324,450.78 42.28 442,999.22 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2130-4217 Uniform Allowance 5,650.00 0.00 2,144.07 37.95 3,505.93 101-4-2130-4219 Operating Supplies 9,200.00 49.22 3,554.75 38.64 5,645.25 TOTAL Supplies 14,850.00 49.22 5,698.82 38.38 9,151.18 Other Services & Charges 101-4-2130-4319 Other Professional Services 5,500.00 0.00 343.63 6.25 5,156.37 101-4-2130-4331 Travel, Conferences & Schools 6,250.00 410.00 3,764.39 60.23 2,485.61 101-4-2130-4433 Dues & Subscriptions 1,950.00 0.00 1,320.00 67.69 630.00 101-4-2130-4460 Equip Replacement Charge 11,050.00 920.83 5,524.98 50.00 5,525.02 TOTAL Other Services & Charges 24,750.00 1,330.83 10,953.00 44.25 13,797.00 Capital Outlay TOTAL Investigations 807,050.00 56,466.64 341,102.60 42.27 465,947.4C Police Support Services Personal Services 101-4-2150-4101 Regular Pay 328,500.00 27,491.21 162,262.54 49.39 166,237.46 101-4-2150-4102 Overtime Pay 10,000.00 55.86 1,441.02 14.41 8,558.98 101-4-2150-4103 Part-time Pay 37,950.00 0.00 0.00 0.00 37,950.00 101-4-2150-4104 PERA 27,300.00 1,997.15 12,994.50 47.60 14,305.5C 101-4-2150-4105 FICA 23,350.00 1,616.15 10,569.34 45.26 12,780.66 101-4-2150-4107 Medicare 5,450.00 377.99 2,471.93 45.36 2,978.07 101-4-2150-4108 Insurance 48,100.00 4,770.02 28,620.12 59.5C 19,479.88 TOTAL Personal Services 480,650.00 36,308.38 218,359.45 45.43 262,290.5H Supplies 101-4-2150-4201 Office Supplies 950.00 0.00 0.00 0.00 950.00 101-4-2150-4217 Uniform Allowance 3,400.00 594.25 914.35 26.89 2,485.65 101-4-2150-4219 Operating Supplies 11,500.00 292.76 ( 429.80) 3.74- 11,929.8C TOTAL Supplies 15,850.00 887.01 484.55 3.06 15,365.45 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,700.00 0.00 370.00 10.00 3,330.00 101-4-2150-4404 Equip Repair/Maint Services 2,200.00 0.00 0.00 0.00 2,200.00 101-4-2150-4409 Contractual Services 16,900.00 670.00 1,424.00 8.43 15,476.00 101-4-2150-4433 Dues & Subscriptions 500.00 0.00 235.00 47.00 265.00 101-4-2150-4460 Equip Replacement Charge 6,500.00 541.67 3,250.02 50.00 3,249.98 TOTAL Other Services & Charges 29,800.00 1,211.67 5,279.02 17.71 24,520.98 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: lE REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Police Support Services 526,300.00 38,407.06 224,123.02 42.58 302,176.98 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 899.16 16.35 4,600.84 101-4-2160-4105 FICA 350.00 0.00 55.75 15.93 294.2E 101-4-2160-4107 Medicare 100.00 0.00 13.06 13.06 86.94 TOTAL Personal Services 5,950.00 0.00 967.97 16.27 4,982.03 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 0.00 1,179.74 23.59 3,820.26 101-4-2160-4219 Operating Supplies 3,700.00 14.34 1,224.19 33.09 2,475.81 TOTAL Supplies 8,700.00 14.34 2,403.93 27.63 6,296.07 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 0.00 475.00 22.62 1,625.00 101-4-2160-4321 Telephone 50.00 0.00 0.00 0.00 50.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00 101-4-2160-4433 Dues & Subscriptions 700.00 0.00 0.00 O.00 700.00 TOTAL Other Services & Charges 6,050.00 0.00 475.00 7.85 5,575.00 Capital Outlay TOTAL Police Reserves 20,700.00 14.34 3,846.90 18.58 16,853.1C Public safety building Personal Services Supplies 101-4-2190-4219 Operating Supplies 17,200.00 2,134.68 10,191.35 59.25 7,008.65 TOTAL Supplies 17,200.00 2,134.68 10,191.35 59.25 7,008.6E Other Services & Charges 101-4-2190-4361 Insurance 4,850.00 0.00 2,258.00 46.56 2,592.00 101-4-2190-4389 Utilities 12,200.00 1,126.88 13,530.47 110.91 ( 1,330.47) 101-4-2190-4401 Bldg Repair/Maint Services 28,800.00 1,028.95 7,370.82 25.59 21,429.18 TOTAL Other Services & Charges 45,850.00 2,155.83 23,159.29 50.51 22,690.71 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Public safety building 63,050.00 4,290.51 33,350.64 52.90 29,699.36 Fire Administration Personal Services 101-4-2310-4101 Regular Pay 144,300.00 7,988.00 47,129.20 32.66 97,170.8C 101-4-2310-4103 Part-time Pay 29,600.00 1,883.20 11,239.28 37.97 18,360.72 101-4-2310-4104 PERA 22,900.00 1,358.70 8,839.76 38.60 14,060.24 101-4-2310-4105 FICA 1,850.00 116.76 776.22 41.96 1,073.78 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101-4-2310-4107 Medicare 2,500.00 141.78 925.16 37.01 1,574.84 101-4-2310-4108 Insurance 16,550.00 680.41 3,973.66 24.01 12,576.34 101-4-2310-4109 Workers Comp 5,450.00 1,362.25 4,086.75 74.99 1,363.25 TOTAL Personal Services 253,150.00 13,531.10 76,970.03 30.40 176,179.97 Supplies 101-4-2310-4201 Office Supplies 4,700.00 0.00 438.34 9.33 4,261.66 101-4-2310-4212 Fuels & Lubes 4,800.00 97.38 751.04 15.65 4,048.96 101-4-2310-4217 Uniform Allowance 1,500.00 0.00 91.90 6.13 1,408.1C 101-4-2310-4219 Operating Supplies 700.00 8.42 8.42 1.20 691.58 101-4-2310-4221 Equipment Parts 450.00 553.94 553.94 123.1C ( 103.94) TOTAL Supplies 12,150.00 659.74 1,843.64 15.17 10,306.36 Other Services & Charges 101-4-2310-4319 Other Professional Services 15,000.00 0.00 1,176.00 7.84 13,824.00 101-4-2310-4321 Telephone 3,750.00 227.47 1,274.83 34.00 2,475.17 101-4-2310-4322 Postage 1,000.00 0.00 114.28 11.43 885.72 101-4-2310-4331 Travel, Conferences & Schools 4,500.00 75.00 446.10 9.91 4,053.90 101-4-2310-4359 Publishing 500.00 0.00 45.40 9.08 454.6C 101-4-2310-4361 Insurance 13,900.00 0.00 5,522.00 39.73 8,378.00 101-4-2310-4389 Utilities 11,200.00 868.54 8,905.04 79.51 2,294.96 101-4-2310-4401 Bldg Repair/Maint Services 5,000.00 788.00 1,512.16 30.24 3,487.84 101-4-2310-4404 Equip Repair/Maint Services 7,900.00 216.80 4,300.99 54.44 3,599.01 101-4-2310-4433 Dues & Subscriptions 2,000.00 0.00 766.00 38.30 1,234.00 101-4-2310-4460 Equip Replacement Charge 42,400.00 3,533.33 21,199.98 50.00 21,200.02 TOTAL Other Services & Charges 107,150.00 5,709.14 45,262.78 42.24 61,887.22 Capital Outlay TOTAL Fire Administration 372,450.00 19,899.98 124,076.45 33.31 248,373.55 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Fire Operations Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 14,009.06 63,409.57 37.37 106,290.43 101-4-2320-4105 FICA 10,500.00 794.54 3,668.60 34.94 6,831.4C 101-4-2320-4107 Medicare 2,450.00 185.83 857.95 35.02 1,592.0E 101-4-2320-4109 Workers Comp 24,150.00 6,042.00 18,126.00 75.06 6,024.00 TOTAL Personal Services 206,800.00 21,031.43 86,062.12 41.62 120,737.88 Supplies 101-4-2320-4201 Office Supplies 4,100.00 0.00 0.00 0.00 4,100.00 101-4-2320-4212 Fuels & Lubes 7,000.00 1,478.50 3,818.90 54.56 3,181.1C 101-4-2320-4217 Uniform Allowance 8,000.00 351.96 2,834.71 35.43 5,165.29 101-4-2320-4219 Operating Supplies 78,350.00 2,312.10 18,169.43 23.19 60,180.57 101-4-2320-4221 Equipment Parts 7,250.00 98.27 1,652.06 22.79 5,597.94 TOTAL Supplies 104,700.00 4,240.83 26,475.10 25.29 78,224.9C Other Services & Charges 101-4-2320-4321 Telephone 4,900.00 205.01 1,060.47 21.64 3,839.53 101-4-2320-4331 Travel, Conferences & Schools 32,500.00 695.00 19,193.74 59.06 13,306.26 101-4-2320-4404 Equip Repair/Maint Services 35,550.00 395.63 2,842.63 8.00 32,707.37 101-4-2320-4409 Contractual Services 7,000.00 190.00 6,624.50 94.64 375.5C TOTAL Other Services & Charges 79,950.00 1,485.64 29,721.34 37.17 50,228.66 Capital Outlay TOTAL Fire Operations 391,450.00 26,757.90 142,258.56 36.34 249,191.44 Emergency Management Personal Services Supplies 101-4-2330-4201 Office Supplies 300.00 0.00 0.00 0.00 300.00 101-4-2330-4219 Operating Supplies 11,900.00 1,698.22 2,611.97 21.95 9,288.03 TOTAL Supplies 12,200.00 1,698.22 2,611.97 21.41 9,588.03 Other Services & Charges 101-4-2330-4321 Telephone 250.00 26.00 130.00 52.00 120.00 101-4-2330-4331 Travel, Conferences & Schools 7,000.00 0.00 463.19 6.62 6,536.81 101-4-2330-4389 Utilities 500.00 123.00 372.87 74.57 127.13 101-4-2330-4404 Equip Repair/Maint Services 3,900.00 0.00 0.00 0.00 3,900.00 101-4-2330-4433 Dues & Subscriptions 300.00 0.00 0.00 O.00 300.00 TOTAL Other Services & Charges 11,950.00 149.00 966.06 8.08 10,983.94 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Emergency Management 24,150.00 1,847.22 3,578.03 14.82 20,571.97 Building Safety Personal Services 101-4-2410-4101 Regular Pay 399,300.00 30,129.69 177,765.13 44.52 221,534.87 101-4-2410-4103 Part-time Pay 43,400.00 2,042.88 12,598.60 29.03 30,801.4C 101-4-2410-4104 PERA 37,250.00 2,778.36 18,071.57 48.51 19,178.43 101-4-2410-4105 FICA 23,000.00 1,592.27 10,314.33 44.84 12,685.67 101-4-2410-4107 Medicare 6,400.00 447.76 2,903.87 45.37 3,496.13 101-4-2410-4108 Insurance 59,250.00 4,424.03 26,544.18 44.80 32,705.82 101-4-2410-4109 Workers Comp 1,900.00 468.50 1,405.50 73.97 494.5C TOTAL Personal Services 570,500.00 41,883.49 249,603.18 43.75 320,896.82 Supplies 101-4-2410-4201 Office Supplies 6,350.00 600.36 2,012.90 31.70 4,337.1C 101-4-2410-4212 Fuels & Lubes 8,000.00 1,580.70 5,112.04 63.90 2,887.96 101-4-2410-4217 Uniform Allowance 2,000.00 0.00 345.55 17.28 1,654.4E 101-4-2410-4219 Operating Supplies 6,600.00 1,754.91 3,402.65 51.56 3,197.35 TOTAL Supplies 22,950.00 3,935.97 10,873.14 47.38 12,076.86 Other Services & Charges 101-4-2410-4321 Telephone 4,750.00 369.66 1,413.84 29.77 3,336.16 101-4-2410-4322 Postage 600.00 0.00 189.08 31.51 410.92 101-4-2410-4331 Travel, Conferences & Schools 3,600.00 0.00 2,751.76 76.44 848.24 101-4-2410-4361 Insurance 1,250.00 0.00 285.00 22.80 965.00 101-4-2410-4404 Equip Repair/Maint Services 7,400.00 407.81 3,576.65 48.33 3,823.3E 101-4-2410-4433 Dues & Subscriptions 3,650.00 125.00 1,815.50 49.74 1,834.5C 101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 1,624.98 50.00 1,625.02 TOTAL Other Services & Charges 24,500.00 1,173.30 11,656.81 47.58 12,843.19 Capital Outlay TOTAL Building Safety 617,950.00 46,992.76 272,133.13 44.04 345,816.87 Code Enforcement Personal Services 101-4-2420-4101 Regular Pay 67,550.00 5,196.80 30,661.12 45.39 36,888.88 101-4-2420-4104 PERA 4,900.00 376.76 2,460.51 50.21 2,439.49 101-4-2420-4105 FICA 4,200.00 334.40 2,177.38 51.84 2,022.62 101-4-2420-4107 Medicare 1,000.00 78.20 509.19 50.92 490.81 101-4-2420-4108 Insurance 3,600.00 300.01 1,800.06 50.00 1,799.94 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Safety 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2420-4109 Workers Comp 300.00 72.00 216.00 72.00 84.00 TOTAL Personal Services 81,550.00 6,358.17 37,824.26 46.38 43,725.74 Supplies 101-4-2420-4212 Fuels & Lubes 2,500.00 360.30 796.21 31.85 1,703.79 101-4-2420-4219 Operating Supplies 700.00 0.00 555.00 79.29 145.00 TOTAL Supplies 3,200.00 360.30 1,351.21 42.23 1,848.79 Other Services & Charges 101-4-2420-4321 Telephone 900.00 88.65 297.41 33.05 602.59 101-4-2420-4322 Postage 750.00 0.00 395.90 52.79 354.1C 101-4-2420-4331 Travel, Conferences & Schools 500.00 0.15 522.16 104.43 ( 22.16) 101-4-2420-4361 Insurance 150.00 0.00 69.50 46.33 80.5C 101-4-2420-4404 Equip Repair/Maint Services 750.00 0.00 0.00 0.00 750.00 101-4-2420-4460 Equip Replacement Charge 800.00 66.67 400.02 50.00 399.98 TOTAL Other Services & Charges 3,850.00 155.47 1,684.99 43.77 2,165.01 TOTAL Code Enforcement 88,600.00 6,873.94 40,860.46 46.12 47,739.54 Environmental Personal Services 101-4-2440-4101 Regular Pay 20,100.00 1,513.34 6,462.90 32.15 13,637.1C 101-4-2440-4104 PERA 1,450.00 120.62 492.82 33.99 957.18 101-4-2440-4105 FICA 1,250.00 109.82 448.67 35.89 801.33 101-4-2440-4107 Medicare 300.00 25.68 104.92 34.97 195.08 101-4-2440-4108 Insurance 3,900.00 275.66 844.45 21.65 3,055.5E 101-4-2440-4109 Workers Comp 600.00 149.50 448.50 74.75 151.5C TOTAL Personal Services 27,600.00 2,194.62 8,802.26 31.89 18,797.74 Supplies 101-4-2440-4201 Office Supplies 450.00 3.86 118.95 26.43 331.0E 101-4-2440-4212 Fuels & Lubes 150.00 0.00 0.00 O.00 150.00 TOTAL Supplies 600.00 3.86 118.95 19.83 481.0E Other Services & Charges 101-4-2440-4321 Telephone 800.00 0.48 1.17 0.15 798.83 101-4-2440-4322 Postage 500.00 0.00 16.65 3.33 483.3E 101-4-2440-4331 Travel, Conferences & Schools 2,150.00 568.47 1,918.47 89.23 231.53 101-4-2440-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2440-4409 Contractual Services 0.00 369.00 369.00 0.00 ( 369.00) 101-4-2440-4433 Dues & Subscriptions 50.00 0.00 0.00 O.00 50.00 TOTAL Other Services & Charges 3,600.00 937.95 2,305.29 64.04 1,294.71 TOTAL Environmental 31,800.00 3,136.43 11,226.50 35.30 20,573.5C TOTAL Public Safety 6,001,600.00 446,287.37 2,541,475.50 42.35 3,460,124.5C 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Works 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 464,300.00 44,464.64 190,052.99 40.93 274,247.01 101-4-3120-4102 Overtime Pay 4,000.00 512.33 3,039.93 76.00 960.07 101-4-3120-4103 Part-time Pay 69,500.00 6,186.75 23,088.20 33.22 46,411.8C 101-4-3120-4104 PERA 37,400.00 3,484.67 16,285.92 43.55 21,114.08 101-4-3120-4105 FICA 33,350.00 3,022.68 13,664.43 40.97 19,685.57 101-4-3120-4107 Medicare 7,800.00 706.93 3,195.71 40.97 4,604.29 101-4-3120-4108 Insurance 74,150.00 6,672.06 25,449.13 34.32 48,700.87 101-4-3120-4109 Workers Comp 26,500.00 6,630.00 19,890.00 75.06 6,610.00 TOTAL Personal Services 717,000.00 71,680.06 294,666.31 41.10 422,333.69 Supplies 101-4-3120-4201 Office Supplies 2,800.00 170.71 814.95 29.11 1,985.05 101-4-3120-4212 Fuels & Lubes 81,700.00 6,749.72 54,393.52 66.58 27,306.48 101-4-3120-4219 Operating Supplies 106,350.00 8,111.38 32,016.62 30.10 74,333.38 101-4-3120-4221 Equipment Parts 0.00 5,601.89 15,064.91 0.00 ( 15,064.91) 101-4-3120-4226 Street Signs 32,600.00 11,237.53 20,028.71 61.44 12,571.29 TOTAL Supplies 223,450.00 31,871.23 122,318.71 54.74 101,131.29 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 0.00 0.00 550.00 101-4-3120-4321 Telephone 6,100.00 574.56 2,917.80 47.83 3,182.2C 101-4-3120-4322 Postage 100.00 0.00 15.16 15.16 84.84 101-4-3120-4331 Travel, Conferences & Schools 3,500.00 0.00 824.65 23.56 2,675.3E 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 18,450.00 0.00 9,016.50 48.87 9,433.5C 101-4-3120-4389 Utilities 53,400.00 5,513.26 39,454.72 73.89 13,945.28 101-4-3120-4401 Bldg Repair/Maint Services 10,450.00 1,226.36 4,956.52 47.43 5,493.48 101-4-3120-4404 Equip Repair/Maint Services 6,000.00 0.00 1,793.37 29.89 4,206.63 101-4-3120-4409 Contractual Services 100,000.00 1,480.00 5,327.85 5.33 94,672.1E 101-4-3120-4415 Equipment Rental 4,800.00 501.99 696.13 14.50 4,103.87 101-4-3120-4417 Uniform Rental 5,800.00 217.63 1,446.09 24.93 4,353.91 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 267.50 76.43 82.5C 101-4-3120-4437 Taxes & Licenses 150.00 0.00 416.00 277.33 ( 266.00) 101-4-3120-4460 Equip Replacement Charge 89,450.00 7,454.17 44,725.02 50.00 44,724.98 TOTAL Other Services & Charges 299,300.00 16,967.97 111,857.31 37.37 187,442.69 Capital Outlay TOTAL Street Maintenance 1,239,750.00 120,519.26 528,842.33 42.66 710,907.67 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Works 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Snow Removal Personal Services 101-4-3130-4101 Regular Pay 121,650.00 0.00 79,163.28 65.07 42,486.72 101-4-3130-4102 Overtime Pay 20,000.00 0.00 37,220.10 186.10 ( 17,220.10) 101-4-3130-4104 PERA 9,850.00 0.00 10,253.37 104.10 ( 403.37) 101-4-3130-4105 FICA 8,800.00 0.00 8,519.34 96.81 280.66 101-4-3130-4107 Medicare 2,050.00 0.00 1,992.39 97.19 57.61 101-4-3130-4108 Insurance 19,500.00 0.00 15,144.68 77.67 4,355.32 101-4-3130-4109 Workers Comp 6,500.00 1,626.00 4,878.00 75.05 1,622.00 TOTAL Personal Services 188,350.00 1,626.00 157,171.16 83.45 31,178.84 Supplies 101-4-3130-4219 Operating Supplies 89,400.00 3,781.83 86,297.03 96.53 3,102.97 TOTAL Supplies 89,400.00 3,781.83 86,297.03 96.53 3,102.97 Other Services & Charges Capital Outlay TOTAL Snow Removal 277,750.00 5,407.83 243,468.19 87.66 34,281.81 Equipment Services Personal Services 101-4-3150-4101 Regular Pay 116,800.00 8,985.60 51,049.44 43.71 65,750.56 101-4-3150-4102 Overtime Pay 1,000.00 0.00 727.42 72.74 272.58 101-4-3150-4104 PERA 8,450.00 651.44 4,194.95 49.64 4,255.05 101-4-3150-4105 FICA 7,250.00 524.06 3,401.09 46.91 3,848.91 101-4-3150-4107 Medicare 1,700.00 122.58 795.46 46.79 904.54 101-4-3150-4108 Insurance 13,450.00 1,124.01 6,372.53 47.38 7,077.47 101-4-3150-4109 Workers Comp 3,000.00 745.25 2,235.75 74.53 764.25 TOTAL Personal Services 151,650.00 12,152.94 68,776.64 45.35 82,873.36 Supplies 101-4-3150-4212 Fuels & Lubes 0.00 117.04 117.04 0.00 ( 117.04) 101-4-3150-4219 Operating Supplies 17,850.00 1,558.27 8,873.06 49.71 8,976.94 101-4-3150-4221 Equipment Parts 10,000.00 2,132.21 10,199.72 102.00 ( 199.72) TOTAL Supplies 27,850.00 3,807.52 19,189.82 68.90 8,660.18 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00 101-4-3150-4404 Equip Repair/Maint Services 1,000.00 181.95 856.90 85.69 143.1C 101-4-3150-4417 Uniform Rental 2,150.00 180.19 827.14 38.47 1,322.86 TOTAL Other Services & Charges 4,650.00 362.14 1,684.04 36.22 2,965.96 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Public Works 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Equipment Services 184,150.00 16,322.60 89,650.50 48.68 94,499.5C Engineering Personal Services 101-4-3300-4101 Regular Pay 118,500.00 11,938.32 70,436.10 59.44 48,063.9C 101-4-3300-4104 PERA 8,600.00 865.52 5,617.41 65.32 2,982.59 101-4-3300-4105 FICA 7,350.00 742.32 4,906.37 66.75 2,443.63 101-4-3300-4107 Medicare 1,700.00 173.60 1,147.46 67.50 552.54 101-4-3300-4108 Insurance 6,300.00 1,120.01 5,160.09 81.91 1,139.91 101-4-3300-4109 Workers Comp 650.00 166.50 499.50 76.85 150.5C TOTAL Personal Services 143,100.00 15,006.27 87,766.93 61.33 55,333.07 Supplies 101-4-3300-4201 Office Supplies 200.00 7.73 333.46 166.73 ( 133.46) 101-4-3300-4212 Fuels & Lubes 1,000.00 239.64 359.30 35.93 640.7C 101-4-3300-4219 Operating Supplies 950.00 0.00 1,288.37 135.62 ( 338.37) TOTAL Supplies 2,150.00 247.37 1,981.13 92.15 168.87 Other Services & Charges 101-4-3300-4319 Other Professional Services 10,000.00 0.00 440.00 4.40 9,560.00 101-4-3300-4321 Telephone 1,450.00 54.05 273.71 18.88 1,176.29 101-4-3300-4322 Postage 150.00 0.00 344.13 229.42 ( 194.13) 101-4-3300-4331 Travel, Conferences & Schools 2,750.00 0.00 439.36 15.98 2,310.64 101-4-3300-4361 Insurance 200.00 0.00 57.00 28.50 143.00 101-4-3300-4404 Equip Repair/Maint Services 6,300.00 163.17 1,012.51 16.07 5,287.49 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 375.00 50.00 375.00 TOTAL Other Services & Charges 21,600.00 279.72 2,941.71 13.62 18,658.29 Capital Outlay TOTAL Engineering 166,850.00 15,533.36 92,689.77 55.55 74,160.23 TOTAL Public Works 1,868,500.00 157,783.05 954,650.79 51.09 913,849.21 Parks Department 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Culture & Recreation 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5110-4101 Regular Pay 390,100.00 30,223.50 161,171.73 41.32 228,928.27 101-4-5110-4102 Overtime Pay 6,600.00 80.64 3,221.93 48.82 3,378.07 101-4-5110-4103 Part-time Pay 68,250.00 11,220.68 16,973.04 24.87 51,276.96 101-4-5110-4104 PERA 30,200.00 2,197.03 13,282.25 43.98 16,917.7E 101-4-5110-4105 FICA 28,300.00 2,422.68 11,721.02 41.42 16,578.98 101-4-5110-4107 Medicare 6,650.00 566.60 2,741.16 41.22 3,908.84 101-4-5110-4108 Insurance 68,400.00 4,466.04 24,976.58 36.52 43,423.42 101-4-5110-4109 Workers Comp 10,900.00 2,728.75 8,186.25 75.10 2,713.7E 101-4-5110-4110 Re-employment Compensation 0.00 0.00 1,125.14 O.00 ( 1,125.14) TOTAL Personal Services 609,400.00 53,905.92 243,399.10 39.94 366,000.9C Supplies 101-4-5110-4212 Fuels & Lubes 40,000.00 7,177.10 18,823.77 47.06 21,176.23 101-4-5110-4217 Uniform Allowance 4,250.00 122.65 1,524.36 35.87 2,725.64 101-4-5110-4219 Operating Supplies 92,550.00 14,636.49 49,441.33 53.42 43,108.67 101-4-5110-4221 Equipment Parts 13,050.00 3,255.36 11,218.78 85.97 1,831.22 TOTAL Supplies 149,850.00 25,191.60 81,008.24 54.06 68,841.76 Other Services & Charges 101-4-5110-4321 Telephone 4,900.00 385.22 1,941.77 39.63 2,958.23 101-4-5110-4322 Postage 50.00 31.93 93.00 186.00 ( 43.00) 101-4-5110-4331 Travel, Conferences & Schools 4,500.00 85.00 506.00 11.24 3,994.00 101-4-5110-4359 Publishing 0.00 0.00 403.00 0.00 ( 403.00) 101-4-5110-4361 Insurance 25,600.00 0.00 11,407.50 44.56 14,192.5C 101-4-5110-4389 Utilities 33,000.00 2,064.63 5,915.94 17.93 27,084.06 101-4-5110-4401 Bldg Repair/Maint Services 3,000.00 260.00 260.00 8.67 2,740.00 101-4-5110-4404 Equip Repair/Maint Services 13,300.00 510.98 850.76 6.40 12,449.24 101-4-5110-4409 Contractual Services 27,800.00 200.00 245.25 0.88 27,554.7E 101-4-5110-4415 Equipment Rental 15,950.00 1,376.61 3,097.99 19.42 12,852.01 101-4-5110-4460 Equip Replacement Charge 51,100.00 4,258.33 25,549.98 50.00 25,550.02 TOTAL Other Services & Charges 179,200.00 9,172.70 50,271.19 28.05 128,928.81 Capital Outlay TOTAL Parks Department 938,450.00 88,270.22 374,678.53 39.93 563,771.47 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 277,350.00 21,226.32 125,256.80 45.16 152,093.2C 101-4-5210-4103 Part-time Pay 53,900.00 3,532.48 21,506.62 39.90 32,393.38 101-4-5210-4104 PERA 23,700.00 1,795.00 11,725.35 49.47 11,974.6E 101-4-5210-4105 FICA 20,550.00 1,457.90 9,564.33 46.54 10,985.67 101-4-5210-4107 Medicare 4,800.00 340.97 2,236.91 46.60 2,563.09 101-4-5210-4108 Insurance 46,400.00 3,324.00 19,944.00 42.98 26,456.00 101-4-5210-4109 Workers Comp 3,300.00 817.50 2,452.50 74.32 847.5C TOTAL Personal Services 430,000.00 32,494.17 192,686.51 44.81 237,313.49 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Culture & Recreation 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5210-4219 Operating Supplies 15,500.00 889.61 10,583.03 68.28 4,916.97 TOTAL Supplies 15,500.00 889.61 10,583.03 68.28 4,916.97 Other Services & Charges 101-4-5210-4321 Telephone 6,050.00 529.68 2,731.62 45.15 3,318.38 101-4-5210-4322 Postage 5,100.00 0.00 521.88 10.23 4,578.12 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 445.42 2,079.70 21.11 7,770.3C 101-4-5210-4349 Advertising/Marketing 31,150.00 463.48 11,415.04 36.65 19,734.96 101-4-5210-4361 Insurance 900.00 0.00 167.00 18.56 733.00 101-4-5210-4389 Utilities 4,500.00 458.93 3,901.23 86.69 598.77 101-4-5210-4401 Bldg Repair/Maint Services 14,000.00 2,007.20 7,227.10 51.62 6,772.9C 101-4-5210-4404 Equip Repair/Maint Services 12,900.00 812.89 10,781.79 83.58 2,118.21 101-4-5210-4433 Dues & Subscriptions 1,850.00 0.00 2,194.95 118.65 ( 344.95) TOTAL Other Services & Charges 86,300.00 4,717.60 41,020.31 47.53 45,279.69 Capital Outlay TOTAL Parks & Rec Admin 531,800.00 38,101.38 244,289.85 45.94 287,510.1E Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 11,254.58 26,448.46 32.25 55,551.54 101-4-5220-4104 PERA 2,400.00 219.00 801.65 33.40 1,598.3E 101-4-5220-4105 FICA 4,350.00 697.78 1,741.09 40.03 2,608.91 101-4-5220-4107 Medicare 1,200.00 163.19 407.13 33.93 792.87 TOTAL Personal Services 89,950.00 12,334.55 29,398.33 32.68 60,551.67 Supplies 101-4-5220-4219 Operating Supplies 32,600.00 794.46 2,186.00 6.71 30,414.00 TOTAL Supplies 32,600.00 794.46 2,186.00 6.71 30,414.00 Other Services & Charges 101-4-5220-4409 Contractual Services 71,400.00 8,900.00 12,573.75 17.61 58,826.2E 101-4-5220-4412 Building Rent 1,650.00 765.00 765.00 46.36 885.00 101-4-5220-4438 Credit Card Fees 4,600.00 544.38 1,747.69 37.99 2,852.31 TOTAL Other Services & Charges 77,650.00 10,209.38 15,086.44 19.43 62,563.56 TOTAL Recreation Programs 200,200.00 23,338.39 46,670.77 23.31 153,529.23 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Culture & Recreation 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Concessions Personal Services Supplies Other Services & Charges Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 104,150.00 7,814.42 46,103.75 44.27 58,046.2E 101-4-5510-4104 PERA 7,550.00 566.54 3,676.82 48.70 3,873.18 101-4-5510-4105 FICA 6,450.00 455.16 2,968.35 46.02 3,481.6E 101-4-5510-4107 Medicare 1,500.00 106.44 694.17 46.28 805.83 101-4-5510-4108 Insurance 16,550.00 1,664.01 9,984.06 60.33 6,565.94 101-4-5510-4109 Workers Comp 450.00 107.75 323.25 71.83 126.75 TOTAL Personal Services 136,650.00 10,714.32 63,750.40 46.65 72,899.6C Supplies 101-4-5510-4219 Operating Supplies 11,250.00 977.99 5,683.82 50.52 5,566.18 TOTAL Supplies 11,250.00 977.99 5,683.82 50.52 5,566.18 Other Services & Charges 101-4-5510-4321 Telephone 2,600.00 160.79 964.41 37.09 1,635.59 101-4-5510-4322 Postage 2,550.00 220.00 2,018.92 79.17 531.08 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 0.00 635.32 20.83 2,414.68 101-4-5510-4361 Insurance 2,050.00 0.00 593.50 28.95 1,456.5C 101-4-5510-4389 Utilities 9,100.00 929.81 6,963.49 76.52 2,136.51 101-4-5510-4401 Bldg Repair/Maint Services 12,950.00 883.50 6,050.76 46.72 6,899.24 101-4-5510-4404 Equip Repair/Maint Services 2,800.00 164.16 908.80 32.46 1,891.2C 101-4-5510-4409 Contractual Services 9,700.00 1,231.12 3,351.33 34.55 6,348.67 101-4-5510-4433 Dues & Subscriptions 850.00 0.00 222.90 26.22 627.1C TOTAL Other Services & Charges 45,650.00 3,589.38 21,709.43 47.56 23,940.57 Capital Outlay TOTAL Sr Citizen Programs 193,550.00 15,281.69 91,143.65 47.09 102,406.3E TOTAL Culture & Recreation 1,864,000.00 164,991.68 756,782.80 40.60 1,107,217.2C 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND Economic Development 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Economic Development Personal Services 101-4-6210-4101 Regular Pay 0.00 0.00 9,560.84 0.00 ( 9,560.84) 101-4-6210-4103 Part-time Pay 0.00 0.00 1,050.00 0.00 ( 1,050.00) 101-4-6210-4104 PERA 0.00 0.00 700.66 0.00 ( 700.66) 101-4-6210-4105 FICA 0.00 1.92 621.74 0.00 ( 621.74) 101-4-6210-4107 Medicare 0.00 0.47 145.43 0.00 ( 145.43) 101-4-6210-4108 Insurance 0.00 ( 562.01) 1,382.02 O.00 ( 1,382.02) TOTAL Personal Services 0.00 ( 559.62) 13,460.69 0.00 ( 13,460.69) Other Services & Charges 101-4-6210-4331 Travel, Conferences & Schools 0.00 ( 48.00) 0.00 0.00 O.00 101-4-6210-4440 Miscellaneous 0.00 1.13 2.54 O.00 ( 2.54) TOTAL Other Services & Charges 0.00 ( 46.87) 2.54 0.00 ( 2.54) TOTAL Economic Development 0.00 ( 606.49) 13,463.23 0.00 ( 13,463.23) Energy City Personal Services 101-4-6220-4101 Regular Pay 4,250.00 318.60 1,306.26 30.74 2,943.74 101-4-6220-4104 PERA 300.00 21.70 89.18 29.73 210.82 101-4-6220-4105 FICA 250.00 19.76 81.02 32.41 168.98 101-4-6220-4107 Medicare 50.00 4.62 18.94 37.88 31.06 101-4-6220-4108 Insurance 800.00 3.14 12.57 1.57 787.43 TOTAL Personal Services 5,650.00 367.82 1,507.97 26.69 4,142.03 Supplies 101-4-6220-4219 Operating Supplies 950.00 0.00 0.00 O.00 950.00 TOTAL Supplies 950.00 0.00 0.00 0.00 950.00 Other Services & Charges 101-4-6220-4319 Other Professional Services 1,000.00 0.00 0.00 0.00 1,000.00 101-4-6220-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00 101-4-6220-4359 Publishing 1,500.00 0.00 300.00 20.00 1,200.00 TOTAL Other Services & Charges 5,500.00 0.00 300.00 5.45 5,200.00 TOTAL Energy City 12,100.00 367.82 1,807.97 14.94 10,292.03 TOTAL Economic Development 12,100.00 ( 238.67) 15,271.20 126.21 ( 3,171.20) 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 27 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 101-GENERAL FUND General 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Transfers Out Transfers Out 101-4-7000-4724 Transfer - Pinewood 60,100.00 0.00 0.00 O.00 60,100.00 TOTAL Transfers Out 60,100.00 0.00 0.00 0.00 60,100.00 TOTAL Transfers Out 60,100.00 0.00 0.00 0.00 60,100.00 TOTAL General 60,100.00 0.00 0.00 0.00 60,100.00 TOTAL EXPENDITURES 12,870,500.00 988,980.31 5,688,011.46 44.19 7,182,488.54 REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,396,730.49 ( 1,427,396.93) 1,427,396.93 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA FINANCIAL SUMMARY 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 625,250.00 6,764.26 235,181.27 37.61 390,068.73 Hockey 34,000.00 ( 11,571.26) 44,698.24 131.47 ( 10,698.24) Skating 42,000.00 203.98 18,469.98 43.98 23,530.02 Concessions 80,000.00 ( 229.16) 35,242.31 44.05 44,757.69 TOTAL REVENUES 781,250.00 ( 4,832.18) 333,591.80 42.70 447,658.2C EXPENDITURE SUMMARY Culture & Recreation Ice Arena 903,150.00 47,779.77 255,533.04 28.29 647,616.96 Hockey 19,050.00 2,896.00 12,898.02 67.71 6,151.98 Skating 30,250.00 459.50 8,802.62 29.10 21,447.38 Arena Concessions 52,100.00 1,459.62 22,867.91 43.89 29,232.09 TOTAL Culture & Recreation 1,004,550.00 52,594.89 300,101.59 29.87 704,448.41 TOTAL EXPENDITURES 1,004,550.00 52,594.89 300,101.59 29.87 704,448.41 REVENUES OVER/(UNDER) EXPENDITURES 223,300.00) ( 57,427.07) 33,490.21 256,790.21) 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 520,000.00 5,106.39 195,502.75 37.60 324,497.25 221-3-0000-3465 Admissions 28,500.00 0.00 9,728.50 34.14 18,771.5C 221-3-0000-3466 Dry Floor Events 19,500.00 1,371.25 9,504.61 48.74 9,995.39 221-3-0000-3468 Skate Sharpening 4,300.00 36.00 1,954.00 45.44 2,346.00 221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 24,500.00 0.00 ( 2,080.00) 8.49- 26,580.00 TOTAL Charges for Services 599,400.00 6,513.64 214,609.86 35.80 384,790.14 Other Revenue 221-3-0000-3621 Interest Income 0.00 0.00 150.11 0.00 ( 150.11) 221-3-0000-3622 Vending Machines 14,000.00 235.51 6,435.60 45.97 7,564.4C 221-3-0000-3625 Refunds & Reimbursements 0.00 0.00 6,155.63 0.00 ( 6,155.63) 221-3-0000-3626 Contributions 7,800.00 0.00 3,038.00 38.95 4,762.00 221-3-0000-3629 Miscellaneous Revenue 3,800.00 ( 1.29) 4,584.57 120.65 ( 784.57) TOTAL Other Revenue 25,600.00 234.22 20,363.91 79.55 5,236.09 Sales 221-3-0000-3791 ATM Revenue 250.00 16.40 207.50 83.00 42.5C TOTAL Sales 250.00 16.40 207.50 83.00 42.5C Transfers In TOTAL Ice Arena 625,250.00 6,764.26 235,181.27 37.61 390,068.73 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 34,000.00 ( 11,571.26) 44,698.24 131.47 ( 10,698.24) TOTAL Charges for Services 34,000.00 ( 11,571.26) 44,698.24 131.47 ( 10,698.24) Other Revenue TOTAL Hockey 34,000.00 ( 11,571.26) 44,698.24 131.47 ( 10,698.24) Skating 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Charges for Services 221-3-5420-3461 Recreation Fees 38,000.00 176.00 13,050.00 34.34 24,950.00 221-3-5420-3465 Admissions 4,000.00 ( 214.02) 3,112.98 77.82 887.02 TOTAL Charges for Services 42,000.00 ( 38.02) 16,162.98 38.48 25,837.02 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 242.00 2,307.00 O.00 ( 2,307.00) TOTAL Other Revenue 0.00 242.00 2,307.00 0.00 ( 2,307.00) TOTAL Skating 42,000.00 203.98 18,469.98 43.98 23,530.02 Concessions Charges for Services 221-3-5430-3467 Concessions 80,000.00 ( 229.16) 35,242.31 44.05 44,757.69 TOTAL Charges for Services 80,000.00 ( 229.16) 35,242.31 44.05 44,757.69 TOTAL Concessions 80,000.00 ( 229.16) 35,242.31 44.05 44,757.69 TOTAL REVENUE 781,250.00 ( 4,832.18) 333,591.80 42.70 447,658.2C 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 171,300.00 13,080.01 77,172.01 45.05 94,127.99 221-4-5400-4102 Overtime Pay 0.00 0.00 1,919.89 0.00 ( 1,919.89) 221-4-5400-4103 Part-time Pay 60,150.00 2,966.06 29,595.16 49.20 30,554.84 221-4-5400-4104 PERA 16,000.00 1,148.27 7,986.75 49.92 8,013.2E 221-4-5400-4105 FICA 14,400.00 936.54 7,117.77 49.43 7,282.23 221-4-5400-4107 Medicare 3,400.00 219.04 1,664.72 48.96 1,735.28 221-4-5400-4108 Insurance 25,800.00 2,202.02 13,212.12 51.21 12,587.88 221-4-5400-4109 Workers Comp 7,800.00 1,764.50 5,293.50 67.87 2,506.5C TOTAL Personal Services 298,850.00 22,316.44 143,961.92 48.17 154,888.08 Supplies 221-4-5400-4212 Fuels & Lubes 400.00 27.44 121.36 30.34 278.64 221-4-5400-4217 Uniform Allowance 800.00 0.00 0.00 0.00 800.00 221-4-5400-4219 Operating Supplies 48,500.00 11,051.80 29,245.84 60.30 19,254.16 221-4-5400-4255 Soft Drinks/Misc 8,100.00 654.80 2,248.36 27.76 5,851.64 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 O.00 900.00 TOTAL Supplies 58,700.00 11,734.04 31,615.56 53.86 27,084.44 Other Services & Charges 221-4-5400-4321 Telephone 3,300.00 75.95 828.14 25.10 2,471.86 221-4-5400-4322 Postage 300.00 0.00 16.87 5.62 283.13 221-4-5400-4331 Travel, Conferences & Schools 1,500.00 0.00 220.00 14.67 1,280.00 221-4-5400-4359 Publishing 5,700.00 0.00 2,201.09 38.62 3,498.91 221-4-5400-4361 Insurance 8,100.00 0.00 2,171.00 26.80 5,929.00 221-4-5400-4389 Utilities 153,500.00 13,052.99 71,044.86 46.28 82,455.14 221-4-5400-4401 Bldg Repair/Maint Services 23,800.00 294.03 2,498.14 10.50 21,301.86 221-4-5400-4409 Contractual Services 2,250.00 5.17 9.81 0.44 2,240.19 221-4-5400-4415 Equipment Rental 2,700.00 301.15 720.65 26.69 1,979.3E 221-4-5400-4433 Dues & Subscriptions 500.00 0.00 245.00 49.00 255.00 TOTAL Other Services & Charges 201,650.00 13,729.29 79,955.56 39.65 121,694.44 Capital Outlay 221-4-5400-4520 Buildings & Structures 145,550.00 0.00 0.00 0.00 145,550.00 221-4-5400-4530 Improvement Project Contract 198,400.00 0.00 0.00 O.00 198,400.00 TOTAL Capital Outlay 343,950.00 0.00 0.00 0.00 343,950.00 Transfers Out TOTAL Ice Arena 903,150.00 47,779.77 255,533.04 28.29 647,616.96 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA Culture & Recreation 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 850.00 0.00 0.00 0.00 850.00 221-4-5410-4105 FICA 50.00 0.00 0.00 0.0C 50.00 TOTAL Personal Services 900.00 0.00 0.00 0.00 900.00 Supplies 221-4-5410-4219 Operating Supplies 9,500.00 0.00 8,525.16 89.74 974.84 TOTAL Supplies 9,500.00 0.00 8,525.16 89.74 974.84 Other Services & Charges 221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00 221-4-5410-4409 Contractual Services 5,350.00 2,896.00 2,896.00 54.13 2,454.00 221-4-5410-4438 Credit Card Fees 2,800.00 0.00 1,476.86 52.75 1,323.14 TOTAL Other Services & Charges 8,650.00 2,896.00 4,372.86 50.55 4,277.14 TOTAL Hockey 19,050.00 2,896.00 12,898.02 67.71 6,151.98 Skating Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 0.00 5,451.07 30.62 12,348.93 221-4-5420-4104 PERA 1,000.00 0.00 116.20 11.62 883.8C 221-4-5420-4105 FICA 1,100.00 0.00 365.21 33.20 734.79 221-4-5420-4107 Medicare 250.00 0.00 85.38 34.15 164.62 TOTAL Personal Services 20,150.00 0.00 6,017.86 29.87 14,132.14 Supplies 221-4-5420-4219 Operating Supplies 4,850.00 449.34 1,883.64 38.84 2,966.36 TOTAL Supplies 4,850.00 449.34 1,883.64 38.84 2,966.36 Other Services & Charges 221-4-5420-4359 Publishing 1,050.00 0.00 0.00 0.00 1,050.00 221-4-5420-4409 Contractual Services 2,200.00 0.00 602.49 27.39 1,597.51 221-4-5420-4438 Credit Card Fees 2,000.00 10.16 298.63 14.93 1,701.37 TOTAL Other Services & Charges 5,250.00 10.16 901.12 17.16 4,348.88 TOTAL Skating 30,250.00 459.50 8,802.62 29.10 21,447.38 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 221-ICE ARENA Culture & Recreation 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 21,300.00 23.01 7,710.51 36.20 13,589.49 221-4-5430-4104 PERA 200.00 0.00 0.00 0.00 200.00 221-4-5430-4105 FICA 1,300.00 1.43 577.06 44.39 722.94 221-4-5430-4107 Medicare 300.00 0.33 134.94 44.98 165.06 TOTAL Personal Services 23,100.00 24.77 8,422.51 36.46 14,677.49 Supplies 221-4-5430-4219 Operating Supplies 2,200.00 20.06 80.41 3.66 2,119.59 221-4-5430-4259 Other Merchandise For Resale 26,800.00 1,414.79 14,364.99 53.6C 12,435.01 TOTAL Supplies 29,000.00 1,434.85 14,445.40 49.81 14,554.6C TOTAL Arena Concessions 52,100.00 1,459.62 22,867.91 43.89 29,232.09 TOTAL Culture & Recreation 1,004,550.00 52,594.89 300,101.59 29.87 704,448.41 TOTAL EXPENDITURES 1,004,550.00 52,594.89 300,101.59 29.87 704,448.41 REVENUES OVER/(UNDER) EXPENDITURES 223,300.00) ( 57,427.07) 33,490.21 256,790.21) 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 249,900.00 ( 142.00) ( 878.00) 0.35- 250,778.00 TOTAL REVENUES 249,900.00 ( 142.00) ( 878.00) 0.35- 250,778.00 EXPENDITURE SUMMARY Culture & Recreation Golf Course 249,900.00 9,901.78 53,471.56 21.4C 196,428.44 TOTAL Culture & Recreation 249,900.00 9,901.78 53,471.56 21.4C 196,428.44 TOTAL EXPENDITURES 249,900.00 9,901.78 53,471.56 21.40 196,428.44 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 10,043.78) ( 54,349.56) 54,349.56 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 222-PINEWOOD GOLF COURSE 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 17,000.00 0.00 ( 360.00) 2.12- 17,360.00 222-3-0000-3467 Concessions 16,800.00 0.00 0.00 0.00 16,800.00 222-3-0000-3469 Other Sales 4,500.00 0.00 0.00 0.00 4,500.00 222-3-0000-3476 Green Fees 110,000.00 ( 142.00) ( 518.00) 0.47- 110,518.00 222-3-0000-3477 Membership Fees 17,000.00 0.00 0.00 0.00 17,000.00 222-3-0000-3478 Golf Cart Rental 20,000.00 0.00 0.00 0.00 20,000.00 222-3-0000-3479 Tournaments 4,500.00 0.00 0.00 O.00 4,500.00 TOTAL Charges for Services 189,800.00 ( 142.00) ( 878.00) 0.46- 190,678.00 Other Revenue Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund 60,100.00 0.00 0.00 O.00 60,100.00 TOTAL Transfers In 60,100.00 0.00 0.00 0.00 60,100.00 TOTAL Pinewood Golf Course 249,900.00 ( 142.00) ( 878.00) 0.35- 250,778.00 TOTAL REVENUE 249,900.00 ( 142.00) ( 878.00) 0.35- 250,778.00 7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2014 222-PINEWOOD GOLF COURSE 50.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 67,550.00 5,197.30 30,664.07 45.39 36,885.93 222-4-5300-4103 Part-time Pay 54,250.00 0.00 1,224.00 2.26 53,026.00 222-4-5300-4104 PERA 8,850.00 376.80 2,534.25 28.64 6,315.7E 222-4-5300-4105 FICA 7,550.00 315.02 2,123.97 28.13 5,426.03 222-4-5300-4107 Medicare 1,750.00 73.68 496.77 28.39 1,253.23 222-4-5300-4108 Insurance 6,750.00 562.00 3,372.00 49.96 3,378.00 222-4-5300-4109 Workers Comp 1,750.00 440.00 1,320.00 75.43 430.00 TOTAL Personal Services 148,450.00 6,964.80 41,735.06 28.11 106,714.94 Supplies 222-4-5300-4212 Fuels & Lubs 5,500.00 526.35 526.35 9.57 4,973.6E 222-4-5300-4217 Uniform Allowance 700.00 0.00 0.00 0.00 700.00 222-4-5300-4219 Operating Supplies 29,050.00 1,326.59 1,883.49 6.48 27,166.51 222-4-5300-4259 Other Merchandise For Resale 9,500.00 0.00 ( 106.82) 1.12- 9,606.82 TOTAL Supplies 44,750.00 1,852.94 2,303.02 5.15 42,446.98 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 170.43 574.58 22.98 1,925.42 222-4-5300-4331 Travel, Conferences & Schools 250.00 0.00 18.11 7.24 231.89 222-4-5300-4349 Advertising/Marketing 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4361 Insurance 11,550.00 0.00 1,837.00 15.90 9,713.00 222-4-5300-4389 Utilities 6,700.00 222.74 1,556.57 23.23 5,143.43 222-4-5300-4401 Bldg Repair/Maint Services 10,700.00 20.04 100.20 0.94 10,599.8C 222-4-5300-4404 Equip Repair/Maint Services 4,650.00 0.00 617.38 13.28 4,032.62 222-4-5300-4415 Equipment Rental 1,400.00 0.00 0.00 0.00 1,400.00 222-4-5300-4437 Taxes & Licenses 900.00 0.00 697.72 77.52 202.28 222-4-5300-4438 Credit Card Fees 5,000.00 0.00 6.93 0.14 4,993.07 222-4-5300-4460 Equip Replacement Charge 8,050.00 670.83 4,024.99 50.00 4,025.01 TOTAL Other Services & Charges 56,700.00 1,084.04 9,433.48 16.64 47,266.52 Capital Outlay Debt Service TOTAL Golf Course 249,900.00 9,901.78 53,471.56 21.40 196,428.44 TOTAL Culture & Recreation 249,900.00 9,901.78 53,471.56 21.40 196,428.44 TOTAL EXPENDITURES 249,900.00 9,901.78 53,471.56 21.40 196,428.44 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 10,043.78) ( 54,349.56) 54,349.56 CITY OF ELK RIVER ENTERPRISE FUNDS- BUDGET TO ACTUAL MONTH ENDED JUNE,2014 Liquor Sewer Garbage 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 Sales and cost of sales: Sales $ 6,700,000 $ 3,169,583 $ 3,530,417 47.31% Cost of sales (4,761,250) (1,903,429) (2,857,821) 39.98% Gross profit 1,938,750 1,266,154 672,596 65.31% Operating revenues: User charges - - - 0.00% $ 1,668,900 $ 681,822 $ 987,078 40.85% $ 1,291,000 $ 543,484 $ 747,516 42.10% Delinquency collections - - - 0.00% 2,500 (7,085) 9,585 -283.40% 10,000 (13,003) 23,003 -130.03% Other 3,500 1,535 1,965 43.86% 2,000 40,685 (38,685) 2034.25% 2,300 1,617 683 70.30% Total operating revenues 3,500 1,535 1,965 43.86% 1,673,400 715,422 957,978 42.75% 1,303,300 532,098 771,202 40.83% Operating expenses: Personal services 623,350 302,353 320,997 48.50% 518,100 237,385 280,715 45.82% 27,500 7,351 20,149 26.73% Supplies 44,600 11,405 33,195 25.57% 254,100 72,898 181,202 28.69% 5,000 1,916 3,084 38.32% Other service charges 217,050 84,960 132,090 39.14% 526,650 414,454 112,196 78.70% 1,316,450 517,032 799,418 39.27% Depreciation* 124,400 - 124,400 0.00% 977,950 - 977,950 0.00% - - - 0.00% Total operating expenses 1,009,400 398,718 610,682 39.50% 2,276,800 724,737 1,552,063 31.83% 1,348,950 526,299 822,651 39.02% Operating income(loss) 932,850 868,971 63,879 93.15% (603,400) (91315) (594,085) 1.54% (45,650) 51799 (51,449) -12.70% Nonoperating revenues(expenses): Interest income 26,100 5,219 20,881 20.00% 81,550 12,542 69,008 15.38% 5,500 1,553 3,947 28.24% Grant revenue - - - 0.00% 3,000,000 - 3,000,000 0.00% - - - 0.00% Interest expense - - - 0.00% (10,850) (1,810) (9,040) 16.68% - - - 0.00% Total nonoperating revenues(expenses) 26,100 5,219 20,881 20.00% 3,070,700 10,732 3,059,968 0.35% 5,500 1,553 3,947 28.24% Income(loss)before contributions and transfers 958,950 874,190 84,760 91.16% 21467,300 11417 21465,883 0.06% (40,150) 7,352 (47,502) -18.31% Contributions-connection fees - - - 0.00% 454,750 17,799 436,951 3.91% - - - 0.00% Transfers in - - - 0.00% 1,000,000 - 1,000,000 0.00% 14,400 - 14,400 0.00% Transfers out (653,850) (282,519) (371,331) 43.21% (113,650) - (113,650) 0.00% (43,150) - (43,150) 0.00% NET INCOME(LOSS) 3059100 5919671 (286,571) 193.93% 3,808,400 19,216 317899184 0.50% (68,900) 7,352 (76,252) -10.67% Items reclassified to balance sheet at year end: Bond Proceeds 5,619,000 - 5,619,000 0.00% Capital Outlay (12,619,000) - (12,619,000) 0.00% Bond Payment (560,000) (560,000) - 100.00% Revenues over/(under)expenditures 305,100 591,671 (286,571) (31751,600) (540,784) (39210,816) (68,900) 71352 (76,252) *Recorded at year end GL Rev over/(under)Exp 696,767 (253,474) 38,658 Interest reversal (105,095) (287,311) (31,306) Reported Rev over/(under)Exp 591,672 (540,785) 7,352 7-15-2014 08:19 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JUNE 30TH, 2014 INFORMATION BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 26,045.48 1,305.35 27,350.83 101-1010 Cash - General Fund 2,092,232.43 2,242,330.38 4,334,562.81 211-1010 Cash - Library 426,075.67 16,255.57 442,331.24 221-1010 Cash - Ice Arena 325,416.96 59,396.25) 266,020.71 222-1010 Cash - Pinewood Golf Course 43,377.43) ( 10,103.78) ( 53,481.21) 225-1010 Cash - Park Dedication 19,299.49 0.00 19,299.49 228-1010 Cash - Landfill 685,238.79 12,004.65) 673,234.14 231-1010 Cash - Landfill Const Debris 712,134.89 0.00 712,134.89 240-1010 Cash - Micro Loan Fund 864,178.38 1,218.61 865,396.99 241-1010 Cash - Federal DEED 200,000.00 0.00 200,000.00 242-1010 Cash - State DEED 407,083.95 0.00 407,083.95 245-1010 Cash - Development Fund 506,368.67 40,920.07 547,288.74 290-1010 Cash - Capital Outlay Reserve 1,616,082.98 23,823.83 1,639,906.81 291-1010 Cash - Insurance Reserve 267,383.67 3,773.52) 263,610.15 292-1010 Cash - Govt Bldgs Reserve 3,726,004.77 57,650.81 3,783,655.58 294-1010 Cash - Drug Forfeiture 36,676.03 118.66 36,794.69 295-1010 Cash - Severance Pay Reserve 117,127.19 0.00 117,127.19 296-1010 Cash - GRE Reserve 2,187,610.72 382,000.00 2,569,610.72 313-1010 Cash - 2007C GO Bonds 69,411.86 3,900.00 73,311.86 333-1010 Cash - 2010A GO Cap Imp Bonds 201,663.48 120,799.64 322,463.12 401-1010 Cash - Pavement Mgmt 1,687,501.30 10,259.32) 1,677,241.98 403-1010 Cash - Street Improvement 1,874,982.27 45,812.86) 1,829,169.41 404-1010 Cash - Surface Water Managemnt 195,231.61 13,211.44 208,443.05 406-1010 Cash - City Wide Trunk Util 4,348,137.71 0.00 4,348,137.71 410-1010 Cash - Equipment Replacement 846,623.19 125,458.59) 721,164.6C 426-1010 Cash - YMCA 629,650.11 0.00 629,650.11 440-1010 Cash - Park Improvement 93,718.86 277,359.21 371,078.07 459-1010 Cash - TIF 419 Highway 169 367,853.03 0.00 367,853.03 462-1010 Cash - TIF 422 Downtown Redev 63,664.75) 0.00 63,664.75) 602-1010 Cash - Wastewater Treatment 5,368,210.43 39,654.85 5,407,865.28 603-1010 Cash - Liquor 2,550,665.54 273,250.71) 2,277,414.83 605-1010 Cash - Garbage 660,223.91 6,091.88) 654,132.03 801-1010 Cash - Interest 21,319.95 65,920.70 87,240.65 821-1010 Cash - Developer Escrow 58,161.19 1,000.00 59,161.19 TOTAL CLAIM ON CASH 33,081,272.33 2,741,317.56 35,822,589.89 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 50,573,445.38 3,604,406.51 54,177,851.89 999-1001 PY BANK ACCOUNT (45,874,362.61) ( 863,088.95) (46,737,451.56) 999-1002 POOLED INVESTMENTS 28,382,189.56 O.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 33,081,272.33 2,741,317.56 35,822,589.89