The URL can be used to link to this page

INFORMATION #1 08-19-2013 INFORMATION �i City of Elk River MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: August 19, 2013 SUBJECT: July 2013 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 July, actual revenues (except for property taxes and state aids) and expenditures should run about 58% 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,revenue collections are about 50.6% of budget estimates. The remaining first half property taxes were received in July along with the second quarter gravel tax collections. • Licenses and permit collections are 59% of budget estimates and building permit collections are about 66% of budget. • Intergovernmental revenue collections for July include the state aid street maintenance and PERA aid payments. • Charges for services are 63% of budget estimates and about 60% of budgeted recreation fees have been collected. • Many of the budgeted transfers were recorded in July. Expenditures: • Excluding transfers,total departmental expenditures are about 51% of budget and almost all departments are within or below budget. • The Transfers Out to Pinewood Golf will be made at the end of the year. P 0 W II R 1 0 9 Y �-4AUR 2013 Monthly Expenditures $14,000 $12,000 o $10,000 z Q $8,000 O $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $617 $1,541 $2,798 $3,711 $4,536 $5,525 $6,501 -Budget $1,070 $2,139 $3,209 $4,279 $5,349 $6,418 $7,488 1$8,558 1 $9,628 $10,697$11,767 $12,837 ICE ARENA For July, expenditures exceed revenues by$12,802. Excluding transfers, revenues of $369,400 are 48% of budget and expenditures of$382,202 are 39% of budget estimates. Ice rental revenues of$231,932 are about 47% of budget. PINEWOOD GOLF For July, expenditures exceed revenues by$10,880. Excluding transfers, revenues of $108,223 are about 57% of budget estimates. Green fee collections are $50,434 as of the end of July, or 46% of the $110,000 budget. Expenditures of$119,103 are 51% of budget. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds-Budget to Actual ■ Cash Report-All Funds 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND FINANCIAL SUMMARY 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,636,950.00 2,109,956.94 6,590,693.05 52.15 6,046,256.95 TOTAL REVENUES 12,636,950.00 2,109,956.94 6,590,693.05 52.15 6,046,256.9E EXPENDITURE SUMMARY General Government Mayor & Council 151,500.00 6,419.48 66,312.98 43.77 85,187.02 Cable TV 87,550.00 6,504.58 45,975.50 52.51 41,574.5C Administrative Services 588,250.00 44,575.31 298,095.94 50.68 290,154.06 Human Resources 96,350.00 7,901.84 55,870.81 57.99 40,479.19 Finance 540,450.00 38,262.03 330,472.35 61.15 209,977.6E Information Technology 296,700.00 35,846.76 163,186.85 55.00 133,513.1E Legal 228,000.00 3,732.15 101,440.20 44.49 126,559.8C Community Development 213,800.00 23,564.70 141,927.40 66.38 71,872.6C Planning 236,700.00 11,938.68 84,254.52 35.60 152,445.48 City Hall Maintenance 517,350.00 37,438.42 277,987.95 53.73 239,362.0E Contingency 8,400.00 0.00 0.00 O.00 8,400.00 TOTAL General Government 2,965,050.00 216,183.95 1,565,524.50 52.80 1,399,525.50 Public Safety Police Administration 637,350.00 34,101.18 330,142.68 51.80 307,207.32 Patrol 2,362,450.00 180,623.65 1,207,630.40 51.12 1,154,819.6C Investigations 772,250.00 62,122.55 396,479.73 51.34 375,770.27 Police Support Services 500,650.00 39,426.17 249,593.07 49.85 251,056.93 Police Reserves 21,600.00 1,642.31 9,165.21 42.43 12,434.79 Public safety building 76,000.00 2,810.96 32,220.51 42.40 43,779.49 Fire Administration 295,200.00 64,292.43 183,346.66 62.11 111,853.34 Fire Operations 344,250.00 24,204.26 141,740.06 41.17 202,509.94 Emergency Management 28,800.00 1,989.11 7,777.05 27.00 21,022.9E Building Safety 663,600.00 42,860.90 336,365.25 50.69 327,234.7E Code Enforcement 85,050.00 6,583.17 46,013.24 54.10 39,036.76 Environmental 52,350.00 1,758.70 14,763.64 28.2C 37,586.36 TOTAL Public Safety 5,839,550.00 462,415.39 2,955,237.50 50.61 2,884,312.5C Public Works Street Maintenance 1,530,200.00 99,693.18 622,855.87 40.70 907,344.13 Snow Removal 285,700.00 0.00 189,155.20 66.21 96,544.8C Equipment Services 252,750.00 17,883.04 124,440.67 49.23 128,309.33 Engineering 173,350.00 15,397.65 102,752.47 59.27 70,597.53 TOTAL Public Works 2,242,000.00 132,973.87 1,039,204.21 46.35 1,202,795.79 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND FINANCIAL SUMMARY 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 807,450.00 75,229.72 431,729.34 53.47 375,720.66 Parks & Rec Admin 522,100.00 35,243.42 260,933.76 49.98 261,166.24 Recreation Programs 196,500.00 34,811.47 97,214.82 49.47 99,285.18 Sr Citizen Programs 188,050.00 15,708.44 102,425.99 54.47 85,624.01 TOTAL Culture & Recreation 1,714,100.00 160,993.05 892,303.91 52.06 821,796.09 Economic Development Economic Development 0.00 ( 2,351.13) 38,818.72 0.00 ( 38,818.72) Energy City 31,450.00 1,153.77 9,418.80 29.95 22,031.2C TOTAL Economic Development 31,450.00 ( 1,197.36) 48,237.52 153.38 ( 16,787.52) General Transfers Out 44,800.00 0.00 0.00 O.00 44,800.00 TOTAL General 44,800.00 0.00 0.00 O.00 44,800.00 TOTAL EXPENDITURES 12,836,950.00 971,368.90 6,500,507.64 50.64 6,336,442.36 REVENUES OVER/(UNDER) EXPENDITURES 200,000.00) 1,138,588.04 90,185.41 290,185.41) 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND 58.33° 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,203,100.00 1,391,310.57 4,628,457.12 50.29 4,574,642.88 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 ( 74,940.89) ( 74,940.89) 0.00 74,940.89 101-3-0000-3121 Gravel Tax 84,000.00 22,396.93 33,749.00 40.18 50,251.00 101-3-0000-3131 Penalties/Interest 0.00 13,625.93 13,625.93 O.00 ( 13,625.93) TOTAL Taxes 9,287,100.00 1,352,392.54 4,600,891.16 49.54 4,686,208.84 Licenses & Permits 101-3-0000-3211 Liquor License 61,500.00 0.00 59,785.00 97.21 1,715.00 101-3-0000-3212 Amusement License 1,000.00 0.00 0.00 0.00 1,000.00 101-3-0000-3213 Cigarette License 3,000.00 100.00 225.00 7.50 2,775.00 101-3-0000-3214 Apartment License 25,000.00 650.00 29,816.58 119.27 ( 4,816.58) 101-3-0000-3216 Mining License 21,000.00 0.00 9,504.10 45.26 11,495.9C 101-3-0000-3217 Garbage Hauler License 1,900.00 0.00 210.00 11.05 1,690.00 101-3-0000-3218 Other Business License/Permit 17,000.00 110.00 3,810.00 22.41 13,190.00 101-3-0000-3229 NPDES Permit 2,500.00 700.00 7,350.00 294.00 ( 4,850.00) 101-3-0000-3231 Building Permit 220,000.00 20,614.70 144,954.05 65.89 75,045.9E 101-3-0000-3232 Plumbing/Heating Permit 190,000.00 8,323.82 61,859.78 32.56 128,140.22 101-3-0000-3233 Permit Surcharge 500.00 ( 1,350.50) 1,839.51 367.90 ( 1,339.51) 101-3-0000-3235 Animal License 4,500.00 392.00 3,332.00 74.04 1,168.00 101-3-0000-3236 Parking Permit 2,000.00 0.00 188.43 9.42 1,811.57 101-3-0000-3237 Other Non-Business Lic/Permit 8,500.00 700.00 7,305.96 85.95 1,194.04 TOTAL Licenses & Permits 558,400.00 30,240.02 330,180.41 59.13 228,219.59 Intergovernmental Rev 101-3-0000-3311 Federal Grant 2,300.00 0.00 0.00 0.00 2,300.00 101-3-0000-3324 PERA Aid 14,000.00 6,992.00 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 20 Aid 210,000.00 0.00 0.00 0.00 210,000.00 101-3-0000-3326 Police Training Reimb 11,100.00 0.00 0.00 0.00 11,100.00 101-3-0000-3327 State-Aid Street Maint 287,600.00 145,385.03 290,770.05 101.10 ( 3,170.05) 101-3-0000-3329 State Crime Prevention Grant 20,000.00 3,790.11 3,790.12 18.95 16,209.88 101-3-0000-3330 Other State Grants 600.00 0.00 0.00 O.00 600.00 TOTAL Intergovernmental Rev 545,600.00 156,167.14 301,552.17 55.27 244,047.83 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 2,055.00 9,145.00 60.97 5,855.00 101-3-0000-3413 Plan Check Fee 85,000.00 8,402.75 61,712.73 72.60 23,287.27 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 740.00 74.00 260.00 101-3-0000-3417 Copies 2,600.00 93.00 1,383.99 53.23 1,216.01 101-3-0000-3418 Other General Govt Services 4,000.00 395.00 1,720.25 43.01 2,279.75 101-3-0000-3430 Lockout Fees 7,500.00 580.00 4,060.00 54.13 3,440.00 101-3-0000-3431 Police Services 2,000.00 500.00 990.00 49.50 1,O10.00 101-3-0000-3432 School Liaison 75,000.00 0.00 0.00 0.00 75,000.00 101-3-0000-3434 Animal Impound Fee 3,500.00 400.00 1,925.00 55.00 1,575.00 101-3-0000-3436 Fire Contracts 201,000.00 0.00 199,615.44 99.31 1,384.56 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3437 Fire Services 3,000.00 15.70 102.10 3.40 2,897.9C 101-3-0000-3451 Street Services 30,000.00 8,678.74 15,862.74 52.88 14,137.26 101-3-0000-3452 Engineering Services Reimb 104,900.00 0.00 28,041.67 26.73 76,858.33 101-3-0000-3461 Recreation Fees 126,000.00 9,873.86 75,245.49 59.72 50,754.51 101-3-0000-3462 Sr Center Activities 0.00 933.52 15,607.52 0.00 ( 15,607.52) 101-3-0000-3472 Park Use Fee 15,000.00 2,642.50 10,885.01 72.57 4,114.99 101-3-0000-3474 Facility Use Fee 5,700.00 0.00 0.00 0.00 5,700.00 101-3-0000-3475 Building Rent 2,400.00 200.00 1,400.00 58.33 1,000.00 101-3-0000-3483 Sewer Inspection Fee 3,000.00 1,060.00 4,475.00 149.17 ( 1,475.00) 101-3-0000-3484 Contractor License Check 400.00 75.00 410.00 102.5C ( 10.00) TOTAL Charges for Services 687,000.00 35,965.07 433,321.94 63.07 253,678.06 Fines & Forfeits 101-3-0000-3510 Court Fines 115,000.00 5,777.27 53,271.77 46.32 61,728.23 101-3-0000-3511 Parking Fines 12,000.00 460.00 8,410.00 70.08 3,590.00 101-3-0000-3512 Ordinance Violations 200.00 0.00 0.00 O.00 200.00 TOTAL Fines & Forfeits 127,200.00 6,237.27 61,681.77 48.49 65,518.23 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 21,937.88 21.94 78,062.12 101-3-0000-3625 Refunds & Reimbursements 66,500.00 ( 192.18) 186.23 0.28 66,313.77 101-3-0000-3626 Contributions 25,000.00 ( 858.53) 14,666.67 58.67 10,333.33 101-3-0000-3629 Miscellaneous Revenue 6,000.00 505.61 7,197.21 119.95 ( 1,197.21) TOTAL Other Revenue 197,500.00 ( 545.10) 43,987.99 22.27 153,512.01 Transfers In 101-3-0000-3921 Transfers 112,900.00 0.00 0.00 0.00 112,900.00 101-3-0000-3925 Transfer-Landfill 35,000.00 35,000.00 35,000.00 100.00 0.0C 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 39,500.00 39,500.00 100.00 O.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 100,000.00 100,000.00 100,000.00 100.00 0.0C 101-3-0000-3943 Transfer-Liquor 330,000.00 330,000.00 330,000.00 100.00 0.0C 101-3-0000-3944 Transfer-Garbage 25,000.00 25,000.00 25,000.00 100.00 0.0C 101-3-0000-3945 Transfer-Utilities 500,000.00 0.00 289,577.61 57.92 210,422.39 101-3-0000-3948 Transfer-EDA 25,000.00 0.00 0.00 0.00 25,000.00 101-3-0000-3949 Transfer-HRA 18,150.00 0.00 0.00 O.00 18,150.00 TOTAL Transfers In 1,234,150.00 529,500.00 819,077.61 66.37 415,072.39 TOTAL General Fund 12,636,950.00 2,109,956.94 6,590,693.05 52.15 6,046,256.95 TOTAL REVENUE 12,636,950.00 2,109,956.94 6,590,693.05 52.15 6,046,256.9E 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND 58.33° 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 21,582.92 56.06 16,917.08 101-4-1110-4104 PERA 1,900.00 70.84 495.86 26.10 1,404.14 101-4-1110-4105 FICA 2,400.00 147.26 976.54 40.69 1,423.46 101-4-1110-4107 Medicare 550.00 46.52 312.94 56.90 237.06 101-4-1110-4109 Workers Comp 100.00 0.00 55.50 55.5C 44.5C TOTAL Personal Services 43,450.00 3,472.94 23,423.76 53.91 20,026.24 Supplies 101-4-1110-4201 Office Supplies 3,000.00 0.00 939.49 31.32 2,060.51 TOTAL Supplies 3,000.00 0.00 939.49 31.32 2,060.51 Other Services & Charges 101-4-1110-4319 Other Professional Services 16,500.00 2,492.46 4,707.44 28.53 11,792.56 101-4-1110-4322 Postage 400.00 0.00 647.89 161.97 ( 247.89) 101-4-1110-4331 Travel, Conferences & Schools 4,100.00 151.28 151.28 3.69 3,948.72 101-4-1110-4359 Publishing 3,700.00 0.00 819.00 22.14 2,881.00 101-4-1110-4361 Insurance 53,000.00 0.00 28,747.00 54.24 24,253.00 101-4-1110-4433 Dues & Subscriptions 16,550.00 0.00 500.00 3.02 16,050.00 101-4-1110-4440 Miscellaneous 10,800.00 302.80 6,377.12 59.05 4,422.88 TOTAL Other Services & Charges 105,050.00 2,946.54 41,949.73 39.93 63,100.27 Capital Outlay TOTAL Mayor & Council 151,500.00 6,419.48 66,312.98 43.77 85,187.02 Cable TV Personal Services 101-4-1120-4101 Regular Pay 59,700.00 4,593.60 31,925.53 53.48 27,774.47 101-4-1120-4103 Part-time Pay 6,750.00 243.75 1,998.75 29.61 4,751.25 101-4-1120-4104 PERA 4,350.00 333.04 2,494.22 57.34 1,855.78 101-4-1120-4105 FICA 4,100.00 258.64 1,971.08 48.08 2,128.92 101-4-1120-4107 Medicare 950.00 60.49 461.01 48.53 488.99 101-4-1120-4108 Insurance 9,150.00 951.00 6,657.00 72.75 2,493.00 101-4-1120-4109 Workers Comp 300.00 0.00 205.00 68.33 95.00 TOTAL Personal Services 85,300.00 6,440.52 45,712.59 53.59 39,587.41 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° 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 800.00 64.06 262.91 32.86 537.09 TOTAL Supplies 800.00 64.06 262.91 32.86 537.09 Other Services & Charges 101-4-1120-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-1120-4331 Travel, Conferences & Schools 1,250.00 0.00 0.00 0.00 1,250.00 101-4-1120-4404 Equip Repair/Maint Services 150.00 0.00 0.00 O.00 150.00 TOTAL Other Services & Charges 1,450.00 0.00 0.00 0.00 1,450.00 Capital Outlay TOTAL Cable TV 87,550.00 6,504.58 45,975.50 52.51 41,574.5C Administrative Services Personal Services 101-4-1210-4101 Regular Pay 361,450.00 27,968.54 193,551.38 53.55 167,898.62 101-4-1210-4103 Part-time Pay 43,350.00 3,077.20 21,557.87 49.73 21,792.13 101-4-1210-4104 PERA 29,350.00 2,250.81 16,665.18 56.78 12,684.82 101-4-1210-4105 FICA 25,100.00 1,894.70 14,082.83 56.11 11,017.17 101-4-1210-4107 Medicare 5,850.00 443.12 3,293.60 56.30 2,556.4C 101-4-1210-4108 Insurance 31,550.00 2,542.04 17,641.47 55.92 13,908.53 101-4-1210-4109 Workers Comp 2,350.00 0.00 1,938.50 82.49 411.5C TOTAL Personal Services 499,000.00 38,176.41 268,730.83 53.85 230,269.17 Supplies 101-4-1210-4201 Office Supplies 11,500.00 823.07 4,082.19 35.5C 7,417.81 TOTAL Supplies 11,500.00 823.07 4,082.19 35.50 7,417.81 Other Services & Charges 101-4-1210-4319 Other Professional Services 6,100.00 0.00 327.00 5.36 5,773.00 101-4-1210-4321 Telephone 350.00 116.76 619.92 177.12 ( 269.92) 101-4-1210-4322 Postage 1,000.00 0.00 503.01 50.30 496.99 101-4-1210-4331 Travel, Conferences & Schools 7,600.00 314.85 1,541.55 20.28 6,058.45 101-4-1210-4334 Car Allowance 4,800.00 400.00 2,800.00 58.33 2,000.00 101-4-1210-4359 Publishing 14,000.00 3,061.00 9,083.00 64.88 4,917.00 101-4-1210-4361 Insurance 200.00 0.00 131.00 65.50 69.00 101-4-1210-4404 Equip Repair/Maint Services 24,000.00 1,605.26 8,714.42 36.31 15,285.58 101-4-1210-4433 Dues & Subscriptions 700.00 77.96 1,563.02 223.29 ( 863.02) TOTAL Other Services & Charges 58,750.00 5,575.83 25,282.92 43.03 33,467.08 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-1210-4560 Equipment 19,000.00 0.00 0.00 0.0C 19,000.00 TOTAL Capital Outlay 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Administrative Services 588,250.00 44,575.31 298,095.94 50.68 290,154.06 Human Resources Personal Services 101-4-1220-4101 Regular Pay 70,600.00 5,430.08 37,739.08 53.45 32,860.92 101-4-1220-4103 Part-time Pay 0.00 918.72 3,445.20 0.00 ( 3,445.20) 101-4-1220-4104 PERA 5,100.00 460.28 3,351.17 65.71 1,748.83 101-4-1220-4105 FICA 4,400.00 380.44 2,782.10 63.23 1,617.9C 101-4-1220-4107 Medicare 1,000.00 88.98 650.67 65.07 349.33 101-4-1220-4108 Insurance 6,250.00 602.45 4,272.27 68.36 1,977.73 101-4-1220-4109 Workers Comp 400.00 0.00 329.00 82.25 71.00 TOTAL Personal Services 87,750.00 7,880.95 52,569.49 59.91 35,180.51 Supplies 101-4-1220-4201 Office Supplies 1,900.00 20.89 1,395.71 73.46 504.29 TOTAL Supplies 1,900.00 20.89 1,395.71 73.46 504.29 Other Services & Charges 101-4-1220-4319 Other Professional Services 2,000.00 0.00 1,304.75 65.24 695.2E 101-4-1220-4322 Postage 900.00 0.00 192.36 21.37 707.64 101-4-1220-4331 Travel, Conferences & Schools 3,000.00 0.00 408.50 13.62 2,591.5C 101-4-1220-4433 Dues & Subscriptions 800.00 0.00 0.00 O.00 800.00 TOTAL Other Services & Charges 6,700.00 0.00 1,905.61 28.44 4,794.39 Capital Outlay TOTAL Human Resources 96,350.00 7,901.84 55,870.81 57.99 40,479.19 Elections Personal Services Supplies Other Services & Charges 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay Finance Personal Services 101-4-1310-4101 Regular Pay 299,450.00 23,033.46 160,281.60 53.53 139,168.4C 101-4-1310-4103 Part-time Pay 50,300.00 3,674.89 27,518.58 54.71 22,781.42 101-4-1310-4104 PERA 25,350.00 1,936.38 14,521.32 57.28 10,828.68 101-4-1310-4105 FICA 21,700.00 1,597.39 12,025.55 55.42 9,674.4E 101-4-1310-4107 Medicare 5,100.00 373.59 2,812.45 55.15 2,287.5E 101-4-1310-4108 Insurance 30,500.00 2,440.58 16,973.03 55.65 13,526.97 101-4-1310-4109 Workers Comp 2,050.00 0.00 1,585.00 77.32 465.00 TOTAL Personal Services 434,450.00 33,056.29 235,717.53 54.26 198,732.47 Supplies 101-4-1310-4201 Office Supplies 6,900.00 221.82 2,899.50 42.02 4,000.5C TOTAL Supplies 6,900.00 221.82 2,899.50 42.02 4,000.5C Other Services & Charges 101-4-1310-4301 Audit Fees 18,300.00 4,181.40 17,921.40 97.93 378.6C 101-4-1310-4319 Other Professional Services 53,500.00 0.00 53,204.00 99.45 296.00 101-4-1310-4321 Telephone 350.00 69.01 226.76 64.79 123.24 101-4-1310-4322 Postage 2,300.00 0.00 1,378.63 59.94 921.37 101-4-1310-4331 Travel, Conferences & Schools 2,450.00 33.74 536.76 21.91 1,913.24 101-4-1310-4359 Publishing 600.00 0.00 0.00 0.00 600.00 101-4-1310-4404 Equip Repair/Maint Services 15,100.00 0.97 15,561.55 103.06 ( 461.55) 101-4-1310-4433 Dues & Subscriptions 1,500.00 225.00 960.00 64.00 540.00 101-4-1310-4438 Credit Card Fees 4,000.00 393.20 1,468.12 36.70 2,531.88 101-4-1310-4440 Miscellaneous 1,000.00 80.60 598.10 59.81 401.9C TOTAL Other Services & Charges 99,100.00 4,983.92 91,855.32 92.69 7,244.68 Capital Outlay TOTAL Finance 540,450.00 38,262.03 330,472.35 61.15 209,977.6E Information Technology Personal Services 101-4-1350-4101 Regular Pay 138,450.00 10,651.68 74,642.08 53.91 63,807.92 101-4-1350-4103 Part-time Pay 13,500.00 1,252.00 4,319.40 32.00 9,180.6C 101-4-1350-4104 PERA 11,000.00 863.04 6,141.20 55.83 4,858.8C 101-4-1350-4105 FICA 9,400.00 700.05 4,941.80 52.57 4,458.2C 101-4-1350-4107 Medicare 2,200.00 163.72 1,155.73 52.53 1,044.27 101-4-1350-4108 Insurance 21,450.00 1,741.02 12,166.64 56.72 9,283.36 101-4-1350-4109 Workers Comp 800.00 0.00 673.25 84.16 126.75 TOTAL Personal Services 196,800.00 15,371.51 104,040.10 52.87 92,759.9C 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1350-4219 Operating Supplies 20,800.00 70.77 9,004.60 43.29 11,795.4C TOTAL Supplies 20,800.00 70.77 9,004.60 43.29 11,795.4C Other Services & Charges 101-4-1350-4319 Other Professional Services 5,000.00 647.50 1,556.50 31.13 3,443.5C 101-4-1350-4321 Telephone 1,800.00 171.74 838.22 46.57 961.78 101-4-1350-4331 Travel, Conferences & Schools 6,200.00 663.82 5,109.42 82.41 1,090.58 101-4-1350-4404 Equip Repair/Maint Services 40,200.00 2,959.78 14,442.94 35.93 25,757.06 TOTAL Other Services & Charges 53,200.00 4,442.84 21,947.08 41.25 31,252.92 Capital Outlay 101-4-1350-4560 Equipment 25,900.00 15,961.64 28,195.07 108.86 ( 2,295.07) TOTAL Capital Outlay 25,900.00 15,961.64 28,195.07 108.86 ( 2,295.07) TOTAL Information Technology 296,700.00 35,846.76 163,186.85 55.00 133,513.1E Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 228,000.00 3,732.15 101,440.20 44.49 126,559.8C TOTAL Other Services & Charges 228,000.00 3,732.15 101,440.20 44.49 126,559.8C TOTAL Legal 228,000.00 3,732.15 101,440.20 44.49 126,559.8C Community Development Personal Services 101-4-1500-4101 Regular Pay 164,200.00 18,804.66 113,979.36 69.41 50,220.64 101-4-1500-4104 PERA 11,900.00 1,363.35 8,428.45 70.83 3,471.55 101-4-1500-4105 FICA 10,200.00 1,132.64 7,037.23 68.99 3,162.77 101-4-1500-4107 Medicare 2,400.00 264.90 1,645.83 68.58 754.17 101-4-1500-4108 Insurance 23,500.00 1,574.03 8,471.17 36.05 15,028.83 101-4-1500-4109 Workers Comp 1,200.00 0.00 957.75 79.81 242.25 TOTAL Personal Services 213,400.00 23,139.58 140,519.79 65.85 72,880.21 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: It REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1500-4201 Office Supplies 0.00 0.00 293.47 O.00 ( 293.47) TOTAL Supplies 0.00 0.00 293.47 0.00 ( 293.47) Other Services & Charges 101-4-1500-4321 Telephone 0.00 251.10 474.91 0.00 ( 474.91) 101-4-1500-4331 Travel, Conferences & Schools 400.00 174.02 639.23 159.81 ( 239.23) TOTAL Other Services & Charges 400.00 425.12 1,114.14 278.54 ( 714.14) TOTAL Community Development 213,800.00 23,564.70 141,927.40 66.38 71,872.6C Planning Personal Services 101-4-1510-4101 Regular Pay 154,250.00 5,430.08 52,215.79 33.85 102,034.21 101-4-1510-4103 Part-time Pay 14,550.00 2,114.00 2,667.00 18.33 11,883.00 101-4-1510-4104 PERA 12,250.00 546.94 4,623.88 37.75 7,626.12 101-4-1510-4105 FICA 10,450.00 422.89 3,603.99 34.49 6,846.01 101-4-1510-4107 Medicare 2,450.00 98.91 842.92 34.40 1,607.08 101-4-1510-4108 Insurance 21,450.00 992.01 9,368.18 43.67 12,081.82 101-4-1510-4109 Workers Comp 950.00 0.00 596.75 62.82 353.25 TOTAL Personal Services 216,350.00 9,604.83 73,918.51 34.17 142,431.49 Supplies 101-4-1510-4201 Office Supplies 4,450.00 1,149.83 2,085.43 46.86 2,364.57 101-4-1510-4212 Fuels & Lubes 0.00 12.65 12.65 O.00 ( 12.65) TOTAL Supplies 4,450.00 1,162.48 2,098.08 47.15 2,351.92 Other Services & Charges 101-4-1510-4321 Telephone 400.00 ( 100.63) 228.74 57.19 171.26 101-4-1510-4322 Postage 2,200.00 0.00 368.28 16.74 1,831.72 101-4-1510-4331 Travel, Conferences & Schools 1,650.00 0.00 447.24 27.11 1,202.76 101-4-1510-4359 Publishing 8,000.00 907.50 2,582.50 32.28 5,417.5C 101-4-1510-4361 Insurance 0.00 0.00 131.00 0.00 ( 131.00) 101-4-1510-4404 Equip Repair/Maint Services 2,400.00 364.50 3,894.17 162.26 ( 1,494.17) 101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 540.00 54.00 460.00 101-4-1510-4440 Miscellaneous 250.00 0.00 46.00 18.4C 204.00 TOTAL Other Services & Charges 15,900.00 1,171.37 8,237.93 51.81 7,662.07 Capital Outlay TOTAL Planning 236,700.00 11,938.68 84,254.52 35.60 152,445.48 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND General Government 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 281,150.00 21,626.88 147,801.47 52.57 133,348.53 101-4-1600-4102 Overtime Pay 3,500.00 0.00 1,933.28 55.24 1,566.72 101-4-1600-4103 Part-time Pay 26,550.00 2,924.40 14,763.21 55.61 11,786.79 101-4-1600-4104 PERA 22,550.00 1,697.99 12,662.65 56.15 9,887.35 101-4-1600-4105 FICA 19,300.00 1,550.27 11,157.05 57.81 8,142.9E 101-4-1600-4107 Medicare 4,500.00 362.54 2,609.22 57.98 1,890.78 101-4-1600-4108 Insurance 32,500.00 2,393.03 17,612.66 54.19 14,887.34 101-4-1600-4109 Workers Comp 10,300.00 0.00 7,777.75 75.51 2,522.25 TOTAL Personal Services 400,350.00 30,555.11 216,317.29 54.03 184,032.71 Supplies 101-4-1600-4212 Fuels & Lubes 4,000.00 253.91 2,130.79 53.27 1,869.21 101-4-1600-4217 Uniform Allowance 1,700.00 0.00 644.05 37.89 1,055.9E 101-4-1600-4219 Operating Supplies 27,000.00 2,905.54 16,756.95 62.06 10,243.05 TOTAL Supplies 32,700.00 3,159.45 19,531.79 59.73 13,168.21 Other Services & Charges 101-4-1600-4321 Telephone 11,000.00 838.79 6,492.59 59.02 4,507.41 101-4-1600-4331 Travel, Conferences & Schools 1,500.00 0.00 368.53 24.57 1,131.47 101-4-1600-4361 Insurance 4,400.00 0.00 2,451.00 55.70 1,949.00 101-4-1600-4389 Utilities 34,200.00 1,450.65 17,787.41 52.01 16,412.59 101-4-1600-4401 Bldg Repair/Maint Services 23,950.00 941.48 13,669.30 57.07 10,280.7C 101-4-1600-4404 Equip Repair/Maint Services 8,200.00 405.44 757.54 9.24 7,442.46 101-4-1600-4460 Equip Replacement Charge 1,050.00 87.50 612.50 58.33 437.5C TOTAL Other Services & Charges 84,300.00 3,723.86 42,138.87 49.99 42,161.13 Capital Outlay TOTAL City Hall Maintenance 517,350.00 37,438.42 277,987.95 53.73 239,362.0E Contingency Personal Services 101-4-1900-4101 Regular Pay 41,600.00) 0.00 0.00 O.00 ( 41,600.00) TOTAL Personal Services 41,600.00) 0.00 0.00 0.00 ( 41,600.00) Other Services & Charges 101-4-1900-4440 Miscellaneous 50,000.00 0.00 0.00 O.00 50,000.00 TOTAL Other Services & Charges 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL Contingency 8,400.00 0.00 0.00 0.00 8,400.00 TOTAL General Government 2,965,050.00 216,183.95 1,565,524.50 52.80 1,399,525.5C 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration Personal Services 101-4-2110-4101 Regular Pay 331,700.00 22,038.16 153,165.20 46.18 178,534.8C 101-4-2110-4104 PERA 44,550.00 3,173.50 23,767.04 53.35 20,782.96 101-4-2110-4105 FICA 2,800.00 0.00 0.00 0.00 2,800.00 101-4-2110-4107 Medicare 3,300.00 203.98 1,526.26 46.25 1,773.74 101-4-2110-4108 Insurance 37,150.00 1,776.02 12,432.14 33.46 24,717.86 101-4-2110-4109 Workers Comp 61,500.00 0.00 48,846.50 79.43 12,653.5C TOTAL Personal Services 481,000.00 27,191.66 239,737.14 49.84 241,262.86 Supplies 101-4-2110-4201 Office Supplies 14,000.00 632.74 4,920.37 35.15 9,079.63 101-4-2110-4217 Uniform Allowance 2,700.00 0.00 1,093.08 40.48 1,606.92 101-4-2110-4219 Operating Supplies 5,600.00 590.59 5,553.27 99.17 46.73 TOTAL Supplies 22,300.00 1,223.33 11,566.72 51.87 10,733.28 Other Services & Charges 101-4-2110-4319 Other Professional Services 4,900.00 82.94 2,014.33 41.11 2,885.67 101-4-2110-4321 Telephone 32,750.00 2,012.62 9,860.51 30.11 22,889.49 101-4-2110-4322 Postage 2,800.00 0.00 1,625.71 58.06 1,174.29 101-4-2110-4331 Travel, Conferences & Schools 5,050.00 0.00 3,279.20 64.93 1,770.8C 101-4-2110-4359 Publishing 500.00 42.00 42.00 8.40 458.00 101-4-2110-4361 Insurance 9,000.00 0.00 4,650.00 51.67 4,350.00 101-4-2110-4404 Equip Repair/Maint Services 74,250.00 3,548.63 54,317.07 73.15 19,932.93 101-4-2110-4433 Dues & Subscriptions 4,500.00 0.00 2,894.00 64.31 1,606.00 101-4-2110-4437 Taxes & Licenses 300.00 0.00 156.00 52.00 144.00 TOTAL Other Services & Charges 134,050.00 5,686.19 78,838.82 58.81 55,211.18 Capital Outlay TOTAL Police Administration 637,350.00 34,101.18 330,142.68 51.80 307,207.32 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,515,850.00 118,511.95 806,506.11 53.20 709,343.89 101-4-2120-4102 Overtime Pay 90,000.00 4,971.97 24,127.65 26.81 65,872.35 101-4-2120-4104 PERA 231,250.00 17,781.70 125,463.25 54.25 105,786.75 101-4-2120-4107 Medicare 20,900.00 1,608.23 10,993.74 52.60 9,906.26 101-4-2120-4108 Insurance 171,850.00 13,223.63 90,180.47 52.48 81,669.53 TOTAL Personal Services 2,029,850.00 156,097.48 1,057,271.22 52.09 972,578.78 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubes 131,650.00 10,080.14 63,866.77 48.51 67,783.23 101-4-2120-4217 Uniform Allowance 17,700.00 2,812.87 7,640.88 43.17 10,059.12 101-4-2120-4219 Operating Supplies 66,450.00 1,247.84 26,423.13 39.76 40,026.87 101-4-2120-4221 Equipment Parts 25,000.00 2,948.21 7,039.32 28.16 17,960.68 TOTAL Supplies 240,800.00 17,089.06 104,970.10 43.59 135,829.9C Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 20,350.00 150.00 8,374.64 41.15 11,975.36 101-4-2120-4404 Equip Repair/Maint Services 25,700.00 3,520.44 10,392.75 40.44 15,307.25 101-4-2120-4433 Dues & Subscriptions 550.00 0.00 255.00 46.36 295.00 101-4-2120-4460 Equip Replacement Charge 45,200.00 3,766.67 26,366.69 58.33 18,833.31 TOTAL Other Services & Charges 91,800.00 7,437.11 45,389.08 49.44 46,410.92 Capital Outlay TOTAL Patrol 2,362,450.00 180,623.65 1,207,630.40 51.12 1,154,819.6C Investigations Personal Services 101-4-2130-4101 Regular Pay 524,200.00 42,436.65 272,078.60 51.90 252,121.4C 101-4-2130-4102 Overtime Pay 45,000.00 3,988.21 19,377.19 43.06 25,622.81 101-4-2130-4104 PERA 81,950.00 6,685.18 45,111.66 55.05 36,838.34 101-4-2130-4107 Medicare 7,050.00 521.02 3,452.06 48.97 3,597.94 101-4-2130-4108 Insurance 73,150.00 5,907.97 40,836.73 55.83 32,313.27 TOTAL Personal Services 731,350.00 59,539.03 380,856.24 52.08 350,493.76 Supplies 101-4-2130-4217 Uniform Allowance 5,500.00 392.50 2,639.54 47.99 2,860.46 101-4-2130-4219 Operating Supplies 8,500.00 1,203.52 2,720.16 32.00 5,779.84 TOTAL Supplies 14,000.00 1,596.02 5,359.70 38.28 8,640.3C Other Services & Charges 101-4-2130-4319 Other Professional Services 6,250.00 0.00 475.00 7.60 5,775.00 101-4-2130-4331 Travel, Conferences & Schools 8,200.00 0.00 2,726.29 33.25 5,473.71 101-4-2130-4433 Dues & Subscriptions 600.00 0.00 150.00 25.00 450.00 101-4-2130-4460 Equip Replacement Charge 11,850.00 987.50 6,912.50 58.33 4,937.5C TOTAL Other Services & Charges 26,900.00 987.50 10,263.79 38.16 16,636.21 Capital Outlay TOTAL Investigations 772,250.00 62,122.55 396,479.73 51.34 375,770.27 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services Personal Services 101-4-2150-4101 Regular Pay 313,950.00 24,254.40 166,937.31 53.17 147,012.69 101-4-2150-4102 Overtime Pay 10,000.00 531.69 1,881.17 18.81 8,118.83 101-4-2150-4103 Part-time Pay 35,400.00 1,851.51 11,465.74 32.39 23,934.26 101-4-2150-4104 PERA 26,050.00 1,931.23 14,078.23 54.04 11,971.77 101-4-2150-4105 FICA 22,300.00 1,579.87 11,568.34 51.88 10,731.66 101-4-2150-4107 Medicare 5,200.00 369.45 2,705.33 52.03 2,494.67 101-4-2150-4108 Insurance 39,250.00 3,650.05 25,550.35 65.1C 13,699.65 TOTAL Personal Services 452,150.00 34,168.20 234,186.47 51.79 217,963.53 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 3,400.00 1,148.55 1,577.13 46.39 1,822.87 101-4-2150-4219 Operating Supplies 13,000.00 2,408.29 4,688.84 36.07 8,311.16 TOTAL Supplies 17,400.00 3,556.84 6,265.97 36.01 11,134.03 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,450.00 0.00 843.70 24.46 2,606.3C 101-4-2150-4404 Equip Repair/Maint Services 2,100.00 0.00 101.53 4.83 1,998.47 101-4-2150-4409 Contractual Services 17,500.00 1,071.96 3,556.21 20.32 13,943.79 101-4-2150-4433 Dues & Subscriptions 500.00 0.00 235.00 47.00 265.00 101-4-2150-4460 Equip Replacement Charge 7,550.00 629.17 4,404.19 58.33 3,145.81 TOTAL Other Services & Charges 31,100.00 1,701.13 9,140.63 29.39 21,959.37 Capital Outlay TOTAL Police Support Services 500,650.00 39,426.17 249,593.07 49.85 251,056.93 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 638.48 680.12 12.37 4,819.88 101-4-2160-4105 FICA 350.00 39.57 42.15 12.04 307.85 101-4-2160-4107 Medicare 100.00 9.26 9.86 9.86 90.14 TOTAL Personal Services 5,950.00 687.31 732.13 12.30 5,217.87 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 955.00 4,277.86 85.56 722.14 101-4-2160-4219 Operating Supplies 6,100.00 0.00 2,122.72 34.8C 3,977.28 TOTAL Supplies 11,100.00 955.00 6,400.58 57.66 4,699.42 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 1F REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2160-4319 Other Professional Services 1,600.00 0.00 475.00 29.69 1,125.00 101-4-2160-4321 Telephone 100.00 0.00 0.00 0.00 100.00 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 1,207.50 71.03 492.5C 101-4-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 350.00 35.00 650.00 TOTAL Other Services & Charges 4,550.00 0.00 2,032.50 44.67 2,517.5C Capital Outlay TOTAL Police Reserves 21,600.00 1,642.31 9,165.21 42.43 12,434.79 Public safety building Personal Services Supplies 101-4-2190-4219 Operating Supplies 18,200.00 811.51 7,367.54 40.48 10,832.46 TOTAL Supplies 18,200.00 811.51 7,367.54 40.48 10,832.46 Other Services & Charges 101-4-2190-4361 Insurance 5,000.00 0.00 2,436.00 48.72 2,564.00 101-4-2190-4389 Utilities 19,450.00 448.33 11,727.65 60.30 7,722.35 101-4-2190-4401 Bldg Repair/Maint Services 33,350.00 1,551.12 10,689.32 32.05 22,660.68 TOTAL Other Services & Charges 57,800.00 1,999.45 24,852.97 43.00 32,947.03 Capital Outlay TOTAL Public safety building 76,000.00 2,810.96 32,220.51 42.40 43,779.49 Fire Administration Personal Services 101-4-2310-4101 Regular Pay 99,900.00 7,684.50 52,519.39 52.57 47,380.61 101-4-2310-4103 Part-time Pay 27,000.00 1,656.54 13,930.81 51.60 13,069.19 101-4-2310-4104 PERA 16,350.00 1,226.66 9,224.47 56.42 7,125.53 101-4-2310-4105 FICA 1,650.00 102.71 1,099.96 66.66 550.04 101-4-2310-4106 Other Retirement Contributions 30,000.00 30,000.00 30,000.00 100.00 O.00 101-4-2310-4107 Medicare 1,850.00 134.07 1,068.06 57.73 781.94 101-4-2310-4108 Insurance 6,250.00 621.01 4,367.57 69.88 1,882.43 101-4-2310-4109 Workers Comp 4,150.00 0.00 3,988.25 96.1C 161.75 TOTAL Personal Services 187,150.00 41,425.49 116,198.51 62.09 70,951.49 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2310-4201 Office Supplies 3,800.00 0.00 1,989.57 52.36 1,810.43 101-4-2310-4212 Fuels & Lubes 3,000.00 276.31 1,225.37 40.85 1,774.63 101-4-2310-4217 Uniform Allowance 950.00 0.00 461.96 48.63 488.04 101-4-2310-4219 Operating Supplies 20,900.00 18,534.00 18,960.71 90.72 1,939.29 TOTAL Supplies 28,650.00 18,810.31 22,637.61 79.01 6,012.39 Other Services & Charges 101-4-2310-4321 Telephone 2,200.00 276.92 1,619.61 73.62 580.39 101-4-2310-4322 Postage 1,000.00 0.00 247.93 24.79 752.07 101-4-2310-4331 Travel, Conferences & Schools 1,800.00 0.00 993.21 55.18 806.79 101-4-2310-4359 Publishing 0.00 0.00 397.50 0.00 ( 397.50) 101-4-2310-4361 Insurance 15,500.00 0.00 6,942.00 44.79 8,558.00 101-4-2310-4389 Utilities 12,000.00 233.58 6,524.91 54.37 5,475.09 101-4-2310-4401 Bldg Repair/Maint Services 5,500.00 123.98 2,901.10 52.75 2,598.9C 101-4-2310-4404 Equip Repair/Maint Services 6,500.00 438.15 4,338.28 66.74 2,161.72 101-4-2310-4433 Dues & Subscriptions 1,600.00 209.00 1,121.00 70.06 479.00 101-4-2310-4460 Equip Replacement Charge 33,300.00 2,775.00 19,425.00 58.33 13,875.00 TOTAL Other Services & Charges 79,400.00 4,056.63 44,510.54 56.06 34,889.46 Capital Outlay TOTAL Fire Administration 295,200.00 64,292.43 183,346.66 62.11 111,853.34 Fire Operations Personal Services 101-4-2320-4103 Part-time Pay 157,700.00 11,413.86 72,880.89 46.21 84,819.11 101-4-2320-4105 FICA 9,800.00 645.71 4,060.00 41.43 5,740.00 101-4-2320-4107 Medicare 2,300.00 151.04 986.00 42.87 1,314.00 101-4-2320-4109 Workers Comp 21,950.00 0.00 16,705.25 76.11 5,244.75 TOTAL Personal Services 191,750.00 12,210.61 94,632.14 49.35 97,117.86 Supplies 101-4-2320-4212 Fuels & Lubes 6,000.00 833.82 4,512.85 75.21 1,487.15 101-4-2320-4217 Uniform Allowance 6,500.00 0.00 579.65 8.92 5,920.35 101-4-2320-4219 Operating Supplies 52,800.00 2,367.00 14,127.15 26.76 38,672.85 101-4-2320-4221 Equipment Parts 6,800.00 917.06 2,390.43 35.15 4,409.57 TOTAL Supplies 72,100.00 4,117.88 21,610.08 29.97 50,489.92 Other Services & Charges 101-4-2320-4321 Telephone 2,100.00 192.33 964.85 45.95 1,135.15 101-4-2320-4331 Travel, Conferences & Schools 20,450.00 600.00 6,827.11 33.38 13,622.89 101-4-2320-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2320-4404 Equip Repair/Maint Services 35,300.00 7,083.44 17,210.10 48.75 18,089.90 101-4-2320-4409 Contractual Services 6,450.00 0.00 495.78 7.69 5,954.22 TOTAL Other Services & Charges 64,400.00 7,875.77 25,497.84 39.59 38,902.16 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-2320-4560 Equipment 16,000.00 0.00 0.00 0.0C 16,000.00 TOTAL Capital Outlay 16,000.00 0.00 0.00 0.00 16,000.00 TOTAL Fire Operations 344,250.00 24,204.26 141,740.06 41.17 202,509.94 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 7,100.00 1,476.60 5,576.20 78.54 1,523.8C TOTAL Supplies 7,400.00 1,476.60 5,576.20 75.35 1,823.8C Other Services & Charges 101-4-2330-4321 Telephone 650.00 26.00 156.00 24.00 494.00 101-4-2330-4331 Travel, Conferences & Schools 3,650.00 0.00 0.00 0.00 3,650.00 101-4-2330-4389 Utilities 1,200.00 36.51 225.45 18.79 974.5E 101-4-2330-4404 Equip Repair/Maint Services 3,800.00 450.00 1,190.02 31.32 2,609.98 101-4-2330-4433 Dues & Subscriptions 100.00 0.00 100.00 100.00 O.00 TOTAL Other Services & Charges 9,400.00 512.51 1,671.47 17.78 7,728.53 Capital Outlay 101-4-2330-4560 Equipment 12,000.00 0.00 529.38 4.41 11,470.62 TOTAL Capital Outlay 12,000.00 0.00 529.38 4.41 11,470.62 TOTAL Emergency Management 28,800.00 1,989.11 7,777.05 27.00 21,022.9E Building Safety Personal Services 101-4-2410-4101 Regular Pay 417,750.00 26,273.47 200,880.48 48.09 216,869.52 101-4-2410-4102 Overtime Pay 0.00 0.00 276.45 0.00 ( 276.45) 101-4-2410-4103 Part-time Pay 66,950.00 4,611.57 41,280.43 61.66 25,669.57 101-4-2410-4104 PERA 40,200.00 2,617.49 21,185.77 52.70 19,014.23 101-4-2410-4105 FICA 25,700.00 1,486.63 13,056.02 50.80 12,643.98 101-4-2410-4107 Medicare 7,050.00 422.19 3,573.11 50.68 3,476.89 101-4-2410-4108 Insurance 55,650.00 3,723.05 28,551.37 51.31 27,098.63 101-4-2410-4109 Workers Comp 6,700.00 0.00 5,383.75 80.35 1,316.25 TOTAL Personal Services 620,000.00 39,134.40 314,187.38 50.68 305,812.62 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2410-4201 Office Supplies 4,600.00 31.33 779.18 16.94 3,820.82 101-4-2410-4212 Fuels & Lubes 8,000.00 726.48 4,728.95 59.11 3,271.0E 101-4-2410-4217 Uniform Allowance 1,900.00 0.00 710.70 37.41 1,189.3C 101-4-2410-4219 Operating Supplies 6,900.00 287.19 1,794.86 26.01 5,105.14 TOTAL Supplies 21,400.00 1,045.00 8,013.69 37.45 13,386.31 Other Services & Charges 101-4-2410-4321 Telephone 4,200.00 92.85 1,349.43 32.13 2,850.57 101-4-2410-4322 Postage 0.00 0.00 488.81 0.00 ( 488.81) 101-4-2410-4331 Travel, Conferences & Schools 3,200.00 750.00 3,420.25 106.88 ( 220.25) 101-4-2410-4361 Insurance 650.00 0.00 631.50 97.15 18.5C 101-4-2410-4404 Equip Repair/Maint Services 8,300.00 1,513.65 4,521.19 54.47 3,778.81 101-4-2410-4433 Dues & Subscriptions 1,950.00 0.00 1,478.00 75.79 472.00 101-4-2410-4460 Equip Replacement Charge 3,900.00 325.00 2,275.00 58.33 1,625.00 TOTAL Other Services & Charges 22,200.00 2,681.50 14,164.18 63.80 8,035.82 Capital Outlay TOTAL Building Safety 663,600.00 42,860.90 336,365.25 50.69 327,234.7E Code Enforcement Personal Services 101-4-2420-4101 Regular Pay 66,250.00 5,096.01 35,417.24 53.46 30,832.76 101-4-2420-4102 Overtime Pay 0.00 0.00 179.15 0.00 ( 179.15) 101-4-2420-4104 PERA 4,800.00 369.46 2,598.84 54.14 2,201.16 101-4-2420-4105 FICA 4,100.00 328.43 2,301.29 56.13 1,798.71 101-4-2420-4107 Medicare 950.00 76.81 538.19 56.65 411.81 101-4-2420-4108 Insurance 3,600.00 241.38 1,512.58 42.02 2,087.42 101-4-2420-4109 Workers Comp 0.00 0.00 219.00 O.00 ( 219.00) TOTAL Personal Services 79,700.00 6,112.09 42,766.29 53.66 36,933.71 Supplies 101-4-2420-4212 Fuels & Lubes 2,250.00 224.49 1,423.82 63.28 826.18 101-4-2420-4219 Operating Supplies 250.00 0.00 286.71 114.68 ( 36.71) TOTAL Supplies 2,500.00 224.49 1,710.53 68.42 789.47 Other Services & Charges 101-4-2420-4321 Telephone 750.00 184.09 315.00 42.00 435.00 101-4-2420-4322 Postage 1,000.00 0.00 285.21 28.52 714.79 101-4-2420-4331 Travel, Conferences & Schools 0.00 0.00 434.21 0.00 ( 434.21) 101-4-2420-4361 Insurance 350.00 0.00 64.50 18.43 285.5C 101-4-2420-4460 Equip Replacement Charge 750.00 62.50 437.50 58.33 312.5C TOTAL Other Services & Charges 2,850.00 246.59 1,536.42 53.91 1,313.58 TOTAL Code Enforcement 85,050.00 6,583.17 46,013.24 54.10 39,036.76 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Safety 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2440-4101 Regular Pay 36,450.00 1,286.80 8,690.99 23.84 27,759.01 101-4-2440-4104 PERA 2,650.00 93.30 791.54 29.87 1,858.46 101-4-2440-4105 FICA 2,250.00 76.60 654.59 29.09 1,595.41 101-4-2440-4107 Medicare 500.00 17.91 153.06 30.61 346.94 101-4-2440-4108 Insurance 5,300.00 60.01 420.07 7.93 4,879.93 101-4-2440-4109 Workers Comp 550.00 0.00 405.75 73.77 144.25 101-4-2440-4110 Re-employment Compensation 0.00 0.00 329.60 O.00 ( 329.6C) TOTAL Personal Services 47,700.00 1,534.62 11,445.60 23.99 36,254.4C Supplies 101-4-2440-4201 Office Supplies 500.00 6.27 263.93 52.79 236.07 101-4-2440-4212 Fuels & Lubes 150.00 33.74 72.58 48.39 77.42 101-4-2440-4219 Operating Supplies 1,800.00 0.84 1,560.25 86.68 239.75 TOTAL Supplies 2,450.00 40.85 1,896.76 77.42 553.24 Other Services & Charges 101-4-2440-4321 Telephone 350.00 70.73 239.34 68.38 110.66 101-4-2440-4322 Postage 500.00 0.00 464.23 92.85 35.77 101-4-2440-4331 Travel, Conferences & Schools 1,200.00 0.00 177.71 14.81 1,022.29 101-4-2440-4359 Publishing 100.00 112.50 540.00 540.00 ( 440.00) 101-4-2440-4433 Dues & Subscriptions 50.00 0.00 0.00 O.00 50.00 TOTAL Other Services & Charges 2,200.00 183.23 1,421.28 64.60 778.72 TOTAL Environmental 52,350.00 1,758.70 14,763.64 28.20 37,586.36 TOTAL Public Safety 5,839,550.00 462,415.39 2,955,237.50 50.61 2,884,312.50 Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 404,300.00 37,364.53 215,680.00 53.35 188,620.00 101-4-3120-4102 Overtime Pay 4,000.00 514.88 1,572.26 39.31 2,427.74 101-4-3120-4103 Part-time Pay 82,050.00 8,268.41 36,428.67 44.40 45,621.33 101-4-3120-4104 PERA 33,850.00 3,043.79 19,165.78 56.62 14,684.22 101-4-3120-4105 FICA 30,400.00 2,736.64 18,019.36 59.27 12,380.64 101-4-3120-4107 Medicare 7,100.00 640.04 4,214.30 59.36 2,885.7C 101-4-3120-4108 Insurance 62,500.00 5,545.73 35,119.25 56.19 27,380.75 101-4-3120-4109 Workers Comp 24,300.00 0.00 19,100.00 78.6C 5,200.00 TOTAL Personal Services 648,500.00 58,114.02 349,299.62 53.86 299,200.38 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 2C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Works 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 5,900.00 2,545.58 3,262.26 55.29 2,637.74 101-4-3120-4212 Fuels & Lubes 80,250.00 ( 3,974.69) 61,740.31 76.93 18,509.69 101-4-3120-4219 Operating Supplies 127,750.00 20,675.57 67,465.28 52.81 60,284.72 101-4-3120-4226 Street Signs 35,850.00 3,741.87 6,469.22 18.05 29,380.78 TOTAL Supplies 249,750.00 22,988.33 138,937.07 55.63 110,812.93 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 212.48 38.63 337.52 101-4-3120-4321 Telephone 6,100.00 418.15 3,101.52 50.84 2,998.48 101-4-3120-4322 Postage 50.00 0.00 10.66 21.32 39.34 101-4-3120-4331 Travel, Conferences & Schools 3,500.00 132.78 1,647.68 47.08 1,852.32 101-4-3120-4359 Publishing 200.00 0.00 68.07 34.04 131.93 101-4-3120-4361 Insurance 16,000.00 0.00 8,809.50 55.06 7,190.5C 101-4-3120-4389 Utilities 52,000.00 2,585.96 31,837.71 61.23 20,162.29 101-4-3120-4401 Bldg Repair/Maint Services 1,500.00 0.00 580.71 38.71 919.29 101-4-3120-4404 Equip Repair/Maint Services 5,000.00 1,876.89 2,190.05 43.80 2,809.9E 101-4-3120-4409 Contractual Services 447,650.00 2,828.51 28,230.17 6.31 419,419.83 101-4-3120-4415 Equipment Rental 4,500.00 2,915.56 3,396.51 75.48 1,103.49 101-4-3120-4417 Uniform Rental 4,700.00 267.98 1,857.87 39.53 2,842.13 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 261.25 74.64 88.7E 101-4-3120-4437 Taxes & Licenses 150.00 90.00 90.00 60.00 60.00 101-4-3120-4460 Equip Replacement Charge 89,700.00 7,475.00 52,325.00 58.33 37,375.00 TOTAL Other Services & Charges 631,950.00 18,590.83 134,619.18 21.30 497,330.82 Capital Outlay TOTAL Street Maintenance 1,530,200.00 99,693.18 622,855.87 40.70 907,344.13 Snow Removal Personal Services 101-4-3130-4101 Regular Pay 106,550.00 0.00 62,315.31 58.48 44,234.69 101-4-3130-4102 Overtime Pay 20,000.00 0.00 22,138.92 110.69 ( 2,138.92) 101-4-3130-4103 Part-time Pay 200.00 0.00 525.76 262.88 ( 325.76) 101-4-3130-4104 PERA 8,750.00 0.00 6,606.92 75.51 2,143.08 101-4-3130-4105 FICA 7,850.00 0.00 5,496.04 70.01 2,353.96 101-4-3130-4107 Medicare 1,850.00 0.00 1,285.35 69.48 564.6E 101-4-3130-4108 Insurance 16,550.00 0.00 7,602.17 45.93 8,947.83 101-4-3130-4109 Workers Comp 7,950.00 0.00 5,148.00 64.75 2,802.00 TOTAL Personal Services 169,700.00 0.00 111,118.47 65.48 58,581.53 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Works 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies 96,000.00 0.00 78,036.73 81.29 17,963.27 TOTAL Supplies 96,000.00 0.00 78,036.73 81.29 17,963.27 Other Services & Charges Capital Outlay 101-4-3130-4560 Equipment 20,000.00 0.00 0.00 0.0C 20,000.00 TOTAL Capital Outlay 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Snow Removal 285,700.00 0.00 189,155.20 66.21 96,544.8C Equipment Services Personal Services 101-4-3150-4101 Regular Pay 169,400.00 13,028.81 84,877.94 50.11 84,522.06 101-4-3150-4102 Overtime Pay 0.00 0.00 502.87 0.00 ( 502.87) 101-4-3150-4104 PERA 12,300.00 944.59 6,717.66 54.62 5,582.34 101-4-3150-4105 FICA 10,500.00 741.18 5,358.84 51.04 5,141.16 101-4-3150-4107 Medicare 2,450.00 173.34 1,253.29 51.15 1,196.71 101-4-3150-4108 Insurance 21,700.00 1,728.36 11,493.92 52.97 10,206.08 101-4-3150-4109 Workers Comp 4,400.00 0.00 3,336.00 75.82 1,064.00 TOTAL Personal Services 220,750.00 16,616.28 113,540.52 51.43 107,209.48 Supplies 101-4-3150-4219 Operating Supplies 22,500.00 1,052.44 9,430.93 41.92 13,069.07 101-4-3150-4221 Equipment Parts 6,000.00 0.00 0.00 O.00 6,000.00 TOTAL Supplies 28,500.00 1,052.44 9,430.93 33.09 19,069.07 Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 500.00 0.00 0.00 0.00 500.00 101-4-3150-4417 Uniform Rental 3,000.00 214.32 1,469.22 48.97 1,530.78 TOTAL Other Services & Charges 3,500.00 214.32 1,469.22 41.98 2,030.78 Capital Outlay TOTAL Equipment Services 252,750.00 17,883.04 124,440.67 49.23 128,309.33 Engineering 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Public Works 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 113,800.00 11,538.04 80,007.29 70.31 33,792.71 101-4-3300-4104 PERA 8,250.00 836.51 6,251.31 75.77 1,998.69 101-4-3300-4105 FICA 7,050.00 740.31 5,520.67 78.31 1,529.33 101-4-3300-4107 Medicare 1,650.00 173.13 1,291.10 78.25 358.9C 101-4-3300-4108 Insurance 14,150.00 600.01 4,200.07 29.68 9,949.93 101-4-3300-4109 Workers Comp 600.00 0.00 303.75 50.63 296.25 TOTAL Personal Services 145,500.00 13,888.00 97,574.19 67.06 47,925.81 Supplies 101-4-3300-4201 Office Supplies 200.00 4.18 50.04 25.02 149.96 101-4-3300-4212 Fuels & Lubes 1,000.00 117.83 242.72 24.27 757.28 101-4-3300-4219 Operating Supplies 1,000.00 0.00 129.23 12.92 870.77 TOTAL Supplies 2,200.00 122.01 421.99 19.18 1,778.01 Other Services & Charges 101-4-3300-4319 Other Professional Services 15,000.00 920.00 1,577.91 10.52 13,422.09 101-4-3300-4321 Telephone 1,100.00 83.82 318.52 28.96 781.48 101-4-3300-4322 Postage 300.00 0.00 451.05 150.35 ( 151.05) 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 127.25 506.34 18.75 2,193.66 101-4-3300-4361 Insurance 200.00 0.00 101.00 50.50 99.00 101-4-3300-4404 Equip Repair/Maint Services 5,600.00 194.07 1,363.97 24.36 4,236.03 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 437.50 58.33 312.5C TOTAL Other Services & Charges 25,650.00 1,387.64 4,756.29 18.54 20,893.71 Capital Outlay TOTAL Engineering 173,350.00 15,397.65 102,752.47 59.27 70,597.53 TOTAL Public Works 2,242,000.00 132,973.87 1,039,204.21 46.35 1,202,795.79 Parks Department Personal Services 101-4-5110-4101 Regular Pay 335,000.00 26,154.88 179,308.12 53.52 155,691.88 101-4-5110-4102 Overtime Pay 6,600.00 0.00 1,606.78 24.35 4,993.22 101-4-5110-4103 Part-time Pay 58,250.00 11,762.24 25,446.40 43.68 32,803.6C 101-4-5110-4104 PERA 26,200.00 2,161.73 14,807.27 56.52 11,392.73 101-4-5110-4105 FICA 24,900.00 2,273.87 13,101.86 52.62 11,798.14 101-4-5110-4107 Medicare 5,850.00 531.83 3,064.26 52.38 2,785.74 101-4-5110-4108 Insurance 45,600.00 3,840.05 26,566.81 58.26 19,033.19 101-4-5110-4109 Workers Comp 10,500.00 0.00 8,332.75 79.36 2,167.25 TOTAL Personal Services 512,900.00 46,724.60 272,234.25 53.08 240,665.7E 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Culture & Recreation 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5110-4212 Fuels & Lubes 40,200.00 4,621.35 21,106.95 52.50 19,093.05 101-4-5110-4217 Uniform Allowance 3,350.00 190.28 1,125.83 33.61 2,224.17 101-4-5110-4219 Operating Supplies 84,050.00 7,650.65 48,939.19 58.23 35,110.81 101-4-5110-4221 Equipment Parts 13,000.00 2,511.04 16,741.88 128.78 ( 3,741.88) TOTAL Supplies 140,600.00 14,973.32 87,913.85 62.53 52,686.15 Other Services & Charges 101-4-5110-4321 Telephone 3,750.00 371.68 2,051.32 54.70 1,698.68 101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-5110-4331 Travel, Conferences & Schools 3,950.00 0.00 448.88 11.36 3,501.12 101-4-5110-4361 Insurance 25,000.00 0.00 12,787.50 51.15 12,212.5C 101-4-5110-4389 Utilities 24,700.00 3,612.76 8,458.00 34.24 16,242.00 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 1,650.00 41.25 2,350.00 101-4-5110-4404 Equip Repair/Maint Services 12,900.00 2,922.20 7,749.43 60.07 5,150.57 101-4-5110-4409 Contractual Services 6,650.00 527.96 2,518.78 37.88 4,131.22 101-4-5110-4415 Equipment Rental 17,000.00 1,434.70 3,279.83 19.29 13,720.17 101-4-5110-4460 Equip Replacement Charge 55,950.00 4,662.50 32,637.50 58.33 23,312.5C TOTAL Other Services & Charges 153,950.00 13,531.80 71,581.24 46.50 82,368.76 Capital Outlay TOTAL Parks Department 807,450.00 75,229.72 431,729.34 53.47 375,720.66 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 281,500.00 20,651.90 133,640.90 47.47 147,859.1C 101-4-5210-4102 Overtime Pay 0.00 168.05 371.02 0.00 ( 371.02) 101-4-5210-4103 Part-time Pay 51,550.00 3,719.73 24,422.79 47.38 27,127.21 101-4-5210-4104 PERA 23,800.00 1,779.13 12,456.53 52.34 11,343.47 101-4-5210-4105 FICA 20,650.00 1,457.84 10,273.66 49.75 10,376.34 101-4-5210-4107 Medicare 4,850.00 340.93 2,402.63 49.54 2,447.37 101-4-5210-4108 Insurance 40,000.00 2,826.66 19,006.59 47.52 20,993.41 101-4-5210-4109 Workers Comp 2,000.00 0.00 3,061.50 153.08 ( 1,061.5C) TOTAL Personal Services 424,350.00 30,944.24 205,635.62 48.46 218,714.38 Supplies 101-4-5210-4219 Operating Supplies 13,200.00 321.07 7,999.49 60.6C 5,200.51 TOTAL Supplies 13,200.00 321.07 7,999.49 60.60 5,200.51 Other Services & Charges 101-4-5210-4321 Telephone 5,350.00 275.81 3,188.45 59.60 2,161.55 101-4-5210-4322 Postage 4,500.00 0.00 1,993.90 44.31 2,506.1C 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 205.38 1,403.31 14.25 8,446.69 101-4-5210-4349 Advertising/Marketing 32,400.00 1,480.71 14,874.99 45.91 17,525.01 101-4-5210-4361 Insurance 650.00 0.00 368.00 56.62 282.06 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Culture & Recreation 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5210-4389 Utilities 4,700.00 207.00 3,370.55 71.71 1,329.45 101-4-5210-4401 Bldg Repair/Maint Services 14,100.00 1,060.99 8,536.49 60.54 5,563.51 101-4-5210-4404 Equip Repair/Maint Services 11,250.00 748.22 11,872.96 105.54 ( 622.96) 101-4-5210-4433 Dues & Subscriptions 1,750.00 0.00 1,690.00 96.57 60.00 TOTAL Other Services & Charges 84,550.00 3,978.11 47,298.65 55.94 37,251.35 Capital Outlay TOTAL Parks & Rec Admin 522,100.00 35,243.42 260,933.76 49.98 261,166.24 Recreation Programs Personal Services 101-4-5220-4102 Overtime Pay 0.00 33.54 215.61 0.00 ( 215.61) 101-4-5220-4103 Part-time Pay 82,000.00 14,208.49 42,671.32 52.04 39,328.68 101-4-5220-4104 PERA 2,400.00 179.39 786.33 32.76 1,613.67 101-4-5220-4105 FICA 4,350.00 897.52 2,776.14 63.82 1,573.86 101-4-5220-4107 Medicare 1,200.00 209.91 649.22 54.1C 550.78 TOTAL Personal Services 89,950.00 15,528.85 47,098.62 52.36 42,851.38 Supplies 101-4-5220-4219 Operating Supplies 38,000.00 6,782.22 13,628.83 35.87 24,371.17 TOTAL Supplies 38,000.00 6,782.22 13,628.83 35.87 24,371.17 Other Services & Charges 101-4-5220-4409 Contractual Services 62,350.00 12,268.89 32,813.01 52.63 29,536.99 101-4-5220-4412 Building Rent 1,600.00 0.00 1,627.75 101.73 ( 27.75) 101-4-5220-4438 Credit Card Fees 4,600.00 231.51 2,046.61 44.49 2,553.39 TOTAL Other Services & Charges 68,550.00 12,500.40 36,487.37 53.23 32,062.63 TOTAL Recreation Programs 196,500.00 34,811.47 97,214.82 49.47 99,285.18 Concessions Personal Services Supplies Other Services & Charges 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 2E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Culture & Recreation 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 97,100.00 7,468.80 50,765.76 52.28 46,334.24 101-4-5510-4104 PERA 7,050.00 541.48 3,964.96 56.24 3,085.04 101-4-5510-4105 FICA 6,000.00 453.43 3,323.28 55.39 2,676.72 101-4-5510-4107 Medicare 1,400.00 106.05 777.23 55.52 622.77 101-4-5510-4108 Insurance 18,600.00 1,233.02 8,631.14 46.40 9,968.86 101-4-5510-4109 Workers Comp 600.00 0.00 439.75 73.29 160.25 TOTAL Personal Services 130,750.00 9,802.78 67,902.12 51.93 62,847.88 Supplies 101-4-5510-4219 Operating Supplies 14,900.00 2,231.08 8,896.76 59.71 6,003.24 TOTAL Supplies 14,900.00 2,231.08 8,896.76 59.71 6,003.24 Other Services & Charges 101-4-5510-4321 Telephone 2,600.00 161.05 1,123.64 43.22 1,476.36 101-4-5510-4322 Postage 2,550.00 18.40 1,627.38 63.82 922.62 101-4-5510-4331 Travel, Conferences & Schools 1,800.00 58.25 184.52 10.25 1,615.48 101-4-5510-4361 Insurance 1,500.00 0.00 1,026.50 68.43 473.5C 101-4-5510-4389 Utilities 10,050.00 449.15 5,276.31 52.50 4,773.69 101-4-5510-4401 Bldg Repair/Maint Services 12,950.00 895.45 8,018.39 61.92 4,931.61 101-4-5510-4404 Equip Repair/Maint Services 2,300.00 223.14 1,533.64 66.68 766.36 101-4-5510-4409 Contractual Services 7,700.00 1,724.14 6,383.13 82.90 1,316.87 101-4-5510-4433 Dues & Subscriptions 950.00 145.00 453.60 47.75 496.4C TOTAL Other Services & Charges 42,400.00 3,674.58 25,627.11 60.44 16,772.89 Capital Outlay TOTAL Sr Citizen Programs 188,050.00 15,708.44 102,425.99 54.47 85,624.01 TOTAL Culture & Recreation 1,714,100.00 160,993.05 892,303.91 52.06 821,796.09 Economic Development Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 634.22) 27,225.14 0.00 ( 27,225.14) 101-4-6210-4103 Part-time Pay 0.00 ( 2,175.00) 2,100.00 0.00 ( 2,100.00) 101-4-6210-4104 PERA 0.00 308.69 2,358.50 0.00 ( 2,358.50) 101-4-6210-4105 FICA 0.00 54.24 1,855.30 0.00 ( 1,855.30) 101-4-6210-4107 Medicare 0.00 12.68 433.95 0.00 ( 433.95) 101-4-6210-4108 Insurance 0.00 84.80 4,476.85 0.00 ( 4,476.85) 101-4-6210-4109 Workers Comp 0.00 0.00 102.75 0.0C ( 102.75) TOTAL Personal Services 0.00 ( 2,348.81) 38,552.49 0.00 ( 38,552.49) 8-12-2013 01:19 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 101-GENERAL FUND Economic Development 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-6210-4322 Postage 0.00 0.00 113.03 0.00 ( 113.03) 101-4-6210-4349 Advertising/Marketing 0.00 0.00 ( 371.93) 0.00 371.93 101-4-6210-4440 Miscellaneous 0.00 ( 2.32) 525.13 O.00 ( 525.13) TOTAL Other Services & Charges 0.00 ( 2.32) 266.23 0.00 ( 266.23) TOTAL Economic Development 0.00 ( 2,351.13) 38,818.72 0.00 ( 38,818.72) Energy City Personal Services 101-4-6220-4101 Regular Pay 16,700.00 965.12 6,754.89 40.45 9,945.11 101-4-6220-4104 PERA 1,200.00 69.98 524.09 43.67 675.91 101-4-6220-4105 FICA 1,050.00 57.44 431.37 41.08 618.63 101-4-6220-4107 Medicare 250.00 13.44 100.92 40.37 149.08 101-4-6220-4108 Insurance 2,750.00 45.01 315.07 11.46 2,434.93 TOTAL Personal Services 21,950.00 1,150.99 8,126.34 37.02 13,823.66 Supplies 101-4-6220-4219 Operating Supplies 5,000.00 2.78 436.50 8.73 4,563.5C TOTAL Supplies 5,000.00 2.78 436.50 8.73 4,563.5C Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 3,000.00 0.00 460.96 15.37 2,539.04 101-4-6220-4359 Publishing 1,500.00 0.00 395.00 26.33 1,105.00 TOTAL Other Services & Charges 4,500.00 0.00 855.96 19.02 3,644.04 TOTAL Energy City 31,450.00 1,153.77 9,418.80 29.95 22,031.2C TOTAL Economic Development 31,450.00 ( 1,197.36) 48,237.52 153.38 ( 16,787.52) Transfers Out Transfers Out 101-4-7000-4724 Transfer - Pinewood 44,800.00 0.00 0.00 O.00 44,800.00 TOTAL Transfers Out 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Transfers Out 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL General 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL EXPENDITURES 12,836,950.00 971,368.90 6,500,507.64 50.64 6,336,442.36 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA FINANCIAL SUMMARY 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 722,550.00 34,048.04 272,518.30 37.72 450,031.7C Hockey 36,000.00 21,120.00 44,399.88 123.33 ( 8,399.88) Skating 64,500.00 1,017.00 16,161.92 25.06 48,338.08 Concessions 78,000.00 1,048.75 36,319.75 46.56 41,680.25 TOTAL REVENUES 901,050.00 57,233.79 369,399.85 41.00 531,650.1E EXPENDITURE SUMMARY Culture & Recreation Ice Arena 888,150.00 34,015.48 334,830.14 37.70 553,319.86 Hockey 19,300.00 0.00 12,793.68 66.29 6,506.32 Skating 32,550.00 22.85 12,542.84 38.53 20,007.16 Arena Concessions 50,000.00 49.42 22,035.58 44.07 27,964.42 TOTAL Culture & Recreation 990,000.00 34,087.75 382,202.24 38.61 607,797.76 TOTAL EXPENDITURES 990,000.00 34,087.75 382,202.24 38.61 607,797.76 REVENUES OVER/(UNDER) EXPENDITURES 88,950.00) 23,146.04 ( 12,802.39) 76,147.61) 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA 58.33° 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 493,000.00 31,511.00 231,932.18 47.05 261,067.82 221-3-0000-3465 Admissions 25,500.00 0.00 9,582.00 37.58 15,918.00 221-3-0000-3466 Dry Floor Events 19,500.00 1,195.00 14,414.80 73.92 5,085.2C 221-3-0000-3468 Skate Sharpening 4,300.00 128.00 2,380.00 55.35 1,920.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 18,000.00 206.67 2,706.69 15.04 15,293.31 TOTAL Charges for Services 562,900.00 33,040.67 261,015.67 46.37 301,884.33 Other Revenue 221-3-0000-3621 Interest Income 0.00 0.00 899.67 0.00 ( 899.67) 221-3-0000-3622 Vending Machines 11,800.00 892.72 5,800.94 49.16 5,999.06 221-3-0000-3626 Contributions 7,300.00 0.00 3,219.00 44.10 4,081.00 221-3-0000-3629 Miscellaneous Revenue 2,800.00 111.50 1,408.02 50.29 1,391.98 TOTAL Other Revenue 21,900.00 1,004.22 11,327.63 51.72 10,572.37 Sales 221-3-0000-3791 ATM Revenue 250.00 3.15 175.00 70.00 75.00 TOTAL Sales 250.00 3.15 175.00 70.00 75.00 Transfers In 221-3-0000-3921 Transfers 137,500.00 0.00 0.00 0.0C 137,500.00 TOTAL Transfers In 137,500.00 0.00 0.00 0.00 137,500.00 TOTAL Ice Arena 722,550.00 34,048.04 272,518.30 37.72 450,031.7C Hockey Charges for Services 221-3-5410-3461 Recreation Fees 36,000.00 21,120.00 44,399.88 123.33 ( 8,399.88) TOTAL Charges for Services 36,000.00 21,120.00 44,399.88 123.33 ( 8,399.88) Other Revenue TOTAL Hockey 36,000.00 21,120.00 44,399.88 123.33 ( 8,399.88) Skating 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA 58.33° 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 60,700.00 927.00 9,498.00 15.65 51,202.00 221-3-5420-3465 Admissions 3,800.00 0.00 3,858.92 101.55 ( 58.92) TOTAL Charges for Services 64,500.00 927.00 13,356.92 20.71 51,143.08 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 90.00 2,805.00 O.00 ( 2,805.00) TOTAL Other Revenue 0.00 90.00 2,805.00 0.00 ( 2,805.00) TOTAL Skating 64,500.00 1,017.00 16,161.92 25.06 48,338.08 Concessions Charges for Services 221-3-5430-3467 Concessions 78,000.00 1,048.75 36,319.75 46.56 41,680.25 TOTAL Charges for Services 78,000.00 1,048.75 36,319.75 46.56 41,680.2E TOTAL Concessions 78,000.00 1,048.75 36,319.75 46.56 41,680.2E TOTAL REVENUE 901,050.00 57,233.79 369,399.85 41.00 531,650.1E 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA 58.33° 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 162,700.00 12,622.36 86,679.51 53.28 76,020.49 221-4-5400-4103 Part-time Pay 60,550.00 2,910.35 33,440.32 55.23 27,109.68 221-4-5400-4104 PERA 15,450.00 1,092.30 8,282.82 53.61 7,167.18 221-4-5400-4105 FICA 13,900.00 916.37 7,744.19 55.71 6,155.81 221-4-5400-4107 Medicare 3,300.00 214.33 1,811.12 54.88 1,488.88 221-4-5400-4108 Insurance 24,550.00 1,941.03 13,587.21 55.35 10,962.79 221-4-5400-4109 Workers Comp 7,050.00 0.00 1,474.50 20.91 5,575.5C 221-4-5400-4110 Re-employment Compensation 0.00 0.00 1,309.20 O.00 ( 1,309.2C) TOTAL Personal Services 287,500.00 19,696.74 154,328.87 53.68 133,171.13 Supplies 221-4-5400-4212 Fuels & Lubs 1,100.00 15.22 108.48 9.86 991.52 221-4-5400-4217 Uniform Allowance 900.00 0.00 22.25 2.47 877.7E 221-4-5400-4219 Operating Supplies 39,050.00 672.62 17,709.58 45.35 21,340.42 221-4-5400-4255 Soft Drinks/Misc 7,000.00 0.00 1,921.41 27.45 5,078.59 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 O.00 900.00 TOTAL Supplies 48,950.00 687.84 19,761.72 40.37 29,188.28 Other Services & Charges 221-4-5400-4319 Other Professional Services 0.00 0.00 35.41 0.00 ( 35.41) 221-4-5400-4321 Telephone 3,250.00 ( 3.01) 786.94 24.21 2,463.06 221-4-5400-4322 Postage 400.00 0.00 68.00 17.00 332.00 221-4-5400-4331 Travel, Conferences & Schools 1,500.00 440.00 662.16 44.14 837.84 221-4-5400-4359 Publishing 3,200.00 25.00 2,744.02 85.75 455.98 221-4-5400-4361 Insurance 7,100.00 0.00 4,059.00 57.17 3,041.00 221-4-5400-4389 Utilities 149,050.00 11,618.65 73,186.97 49.10 75,863.03 221-4-5400-4401 Bldg Repair/Maint Services 24,900.00 1,399.96 23,436.70 94.12 1,463.3C 221-4-5400-4409 Contractual Services 1,800.00 3.13 45.36 2.52 1,754.64 221-4-5400-4415 Equipment Rental 2,700.00 147.17 1,019.29 37.75 1,680.71 221-4-5400-4433 Dues & Subscriptions 500.00 0.00 230.00 46.00 270.00 TOTAL Other Services & Charges 194,400.00 13,630.90 106,273.85 54.67 88,126.15 Capital Outlay 221-4-5400-4520 Buildings & Structures 113,300.00 0.00 0.00 0.00 113,300.00 221-4-5400-4560 Equipment 244,000.00 0.00 54,465.70 22.32 189,534.3C TOTAL Capital Outlay 357,300.00 0.00 54,465.70 15.24 302,834.3C Transfers Out TOTAL Ice Arena 888,150.00 34,015.48 334,830.14 37.70 553,319.86 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA Culture & Recreation 58.33° 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,100.00 0.00 8,960.40 98.47 139.6C TOTAL Supplies 9,100.00 0.00 8,960.40 98.47 139.6C Other Services & Charges 221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00 221-4-5410-4409 Contractual Services 6,000.00 0.00 2,457.00 40.95 3,543.00 221-4-5410-4438 Credit Card Fees 2,800.00 0.00 1,376.28 49.15 1,423.72 TOTAL Other Services & Charges 9,300.00 0.00 3,833.28 41.22 5,466.72 TOTAL Hockey 19,300.00 0.00 12,793.68 66.29 6,506.32 Skating Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 0.00 7,988.91 44.88 9,811.09 221-4-5420-4104 PERA 1,000.00 0.00 231.55 23.16 768.45 221-4-5420-4105 FICA 1,100.00 0.00 535.22 48.66 564.78 221-4-5420-4107 Medicare 250.00 0.00 125.10 50.04 124.9C TOTAL Personal Services 20,150.00 0.00 8,880.78 44.07 11,269.22 Supplies 221-4-5420-4219 Operating Supplies 5,300.00 0.00 1,576.21 29.74 3,723.79 TOTAL Supplies 5,300.00 0.00 1,576.21 29.74 3,723.79 Other Services & Charges 221-4-5420-4359 Publishing 1,000.00 0.00 415.74 41.57 584.26 221-4-5420-4409 Contractual Services 3,300.00 0.00 1,369.85 41.51 1,930.1E 221-4-5420-4438 Credit Card Fees 2,800.00 22.85 300.26 10.72 2,499.74 TOTAL Other Services & Charges 7,100.00 22.85 2,085.85 29.38 5,014.1E TOTAL Skating 32,550.00 22.85 12,542.84 38.53 20,007.16 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 221-ICE ARENA Culture & Recreation 58.33° 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 45.90 7,151.61 33.58 14,148.39 221-4-5430-4104 PERA 200.00 0.00 158.27 79.14 41.73 221-4-5430-4105 FICA 1,300.00 2.85 531.08 40.85 768.92 221-4-5430-4107 Medicare 300.00 0.67 124.20 41.4C 175.8C TOTAL Personal Services 23,100.00 49.42 7,965.16 34.48 15,134.84 Supplies 221-4-5430-4219 Operating Supplies 2,150.00 0.00 316.32 14.71 1,833.68 221-4-5430-4259 Other Merchandise For Resale 24,750.00 0.00 13,754.10 55.57 10,995.9C TOTAL Supplies 26,900.00 0.00 14,070.42 52.31 12,829.58 TOTAL Arena Concessions 50,000.00 49.42 22,035.58 44.07 27,964.42 TOTAL Culture & Recreation 990,000.00 34,087.75 382,202.24 38.61 607,797.76 TOTAL EXPENDITURES 990,000.00 34,087.75 382,202.24 38.61 607,797.76 REVENUES OVER/(UNDER) EXPENDITURES 88,950.00) 23,146.04 ( 12,802.39) 76,147.61) 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 58.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 233,300.00 29,500.34 108,222.70 46.39 125,077.3C TOTAL REVENUES 233,300.00 29,500.34 108,222.70 46.39 125,077.3C EXPENDITURE SUMMARY Culture & Recreation Golf Course 233,300.00 26,725.82 119,103.12 51.05 114,196.88 TOTAL Culture & Recreation 233,300.00 26,725.82 119,103.12 51.05 114,196.88 TOTAL EXPENDITURES 233,300.00 26,725.82 119,103.12 51.05 114,196.88 REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,774.52 ( 10,880.42) 10,880.42 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 222-PINEWOOD GOLF COURSE 58.33° 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 13,277.03 78.10 3,722.97 222-3-0000-3467 Concessions 16,000.00 3,310.72 9,079.54 56.75 6,920.46 222-3-0000-3469 Other Sales 3,500.00 717.15 2,903.34 82.95 596.66 222-3-0000-3476 Green Fees 110,000.00 18,898.32 50,433.60 45.85 59,566.4C 222-3-0000-3477 Membership Fees 17,000.00 1,707.67 19,210.22 113.00 ( 2,210.22) 222-3-0000-3478 Golf Cart Rental 20,000.00 4,492.23 11,731.40 58.66 8,268.6C 222-3-0000-3479 Tournaments 5,000.00 374.25 1,581.56 31.63 3,418.44 TOTAL Charges for Services 188,500.00 29,500.34 108,216.69 57.41 80,283.31 Other Revenue 222-3-0000-3629 Miscellaneous Revenue 0.00 0.00 4.50 O.00 ( 4.5C) TOTAL Other Revenue 0.00 0.00 4.50 0.00 ( 4.50) Sales 222-3-0000-3792 Cash Over 0.00 0.00 1.51 O.00 ( 1.51) TOTAL Sales 0.00 0.00 1.51 0.00 ( 1.51) Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund 44,800.00 0.00 0.00 O.00 44,800.00 TOTAL Transfers In 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Pinewood Golf Course 233,300.00 29,500.34 108,222.70 46.39 125,077.3C TOTAL REVENUE 233,300.00 29,500.34 108,222.70 46.39 125,077.3C 8-12-2013 01:20 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2013 222-PINEWOOD GOLF COURSE 58.33° 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 66,250.00 5,095.38 35,403.54 53.44 30,846.46 222-4-5300-4103 Part-time Pay 53,750.00 9,394.52 25,202.54 46.89 28,547.46 222-4-5300-4104 PERA 8,700.00 622.20 3,789.73 43.56 4,910.27 222-4-5300-4105 FICA 7,450.00 895.71 3,893.13 52.26 3,556.87 222-4-5300-4107 Medicare 1,750.00 209.50 910.49 52.03 839.51 222-4-5300-4108 Insurance 6,250.00 484.01 3,388.07 54.21 2,861.93 222-4-5300-4109 Workers Comp 1,700.00 0.00 1,274.75 74.99 425.25 222-4-5300-4110 Re-employment Compensation 0.00 0.00 3,515.60 O.00 ( 3,515.6C) TOTAL Personal Services 145,850.00 16,701.32 77,377.85 53.05 68,472.15 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 66.90 1,974.01 39.48 3,025.99 222-4-5300-4217 Uniform Allowance 600.00 0.00 240.97 40.16 359.03 222-4-5300-4219 Operating Supplies 28,150.00 4,618.40 16,282.03 57.84 11,867.97 222-4-5300-4259 Other Merchandise For Resale 9,500.00 1,361.37 7,226.79 76.07 2,273.21 TOTAL Supplies 43,250.00 6,046.67 25,723.80 59.48 17,526.2C Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 ( 3.25) 754.00 31.42 1,646.00 222-4-5300-4331 Travel, Conferences & Schools 250.00 0.00 167.81 67.12 82.19 222-4-5300-4349 Advertising/Marketing 5,000.00 1,303.00 2,428.20 48.56 2,571.8C 222-4-5300-4361 Insurance 10,700.00 0.00 5,431.50 50.76 5,268.5C 222-4-5300-4389 Utilities 6,600.00 678.03 1,946.67 29.50 4,653.33 222-4-5300-4401 Bldg Repair/Maint Services 8,000.00 20.04 187.74 2.35 7,812.26 222-4-5300-4404 Equip Repair/Maint Services 4,000.00 1,040.60 1,834.80 45.87 2,165.2C 222-4-5300-4415 Equipment Rental 1,350.00 160.62 175.17 12.98 1,174.83 222-4-5300-4437 Taxes & Licenses 900.00 0.00 1,048.18 116.46 ( 148.18) 222-4-5300-4438 Credit Card Fees 5,000.00 778.79 2,027.40 40.55 2,972.6C TOTAL Other Services & Charges 44,200.00 3,977.83 16,001.47 36.20 28,198.53 Capital Outlay Debt Service TOTAL Golf Course 233,300.00 26,725.82 119,103.12 51.05 114,196.88 TOTAL Culture & Recreation 233,300.00 26,725.82 119,103.12 51.05 114,196.88 TOTAL EXPENDITURES 233,300.00 26,725.82 119,103.12 51.05 114,196.88 REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,774.52 ( 10,880.42) 10,880.42 CITY OF ELK RIVER ENTERPRISE FUNDS- BUDGET TO ACTUAL MONTH ENDED JULY,2013 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,500,000 $ 3,732,824 $ 2,767,176 57.43% Cost of sales (4,695,750) (2,332,133) (2,363,617) 49.66% Gross profit 1,804,250 1,400,691 403,559 77.63% Operating revenues: User charges - - - 0.00% $ 1,602,200 $ 656,331 $ 945,869 40.96% $ 1,324,000 $ 628,394 $ 695,606 47.46% Delinquency collections - - - 0.00% 2,500 (2,392) 4,892 -95.68% 7,000 (8,846) 15,846 -126.37% Other 400 1,566 2,434 39.15% 287,750 2,067 285,683 0.72% 2,000 1,897 103 94.85% Total operating revenues 4,000 1,566 2,434 39.15% 1,892,450 656,006 1,236,444 34.66% 1,333,000 621,445 711,555 46.62% Operating expenses: Personal services 611,850 332,949 278,901 54.42% 499,150 270,011 229,139 54.09% 49,250 13,544 35,706 27.50% Supplies 29,600 7,143 22,457 24.13% 262,300 47,572 214,728 18.14% 10,200 6,677 3,523 65.46% Other service charges 222,900 99,062 123,838 44.44% 687,250 213,821 473,429 31.11% 1,297,400 596,828 700,572 46.00% Depreciation* 123,150 - 123,150 0.00% 993,600 - 993,600 0.00% - - - 0.00% Total operating expenses 987,500 439,154 548,346 44.47% 2,442,300 531,404 1,910,896 21.76% 1,356,850 617,049 739,801 45.48% Operating income(loss) 8209750 9639103 (142,353) 117.34% (549,850) 124,602 (674,452) -22.66% (23,850) 41396 (28,246) -18.43% Nonoperating revenues(expenses): Interest income 23,000 8,536 14,464 37.11% 72,250 24,729 47,521 34.23% 5,400 2,920 2,480 54.07% Miscellaneous revenue - - - 0.00% - 518 (518) 0.00% - - - 0.00% Interest expense - - - 0.00% (24,900) (14,434) (10,466) 57.97% - - - 0.00% Total nonoperating revenues(expenses) 23,000 8,536 14,464 37.11% 47,350 10,813 36,537 22.84% 5,400 2,920 2,480 54.07% Income(loss)before contributions and transfers 843,750 971,639 (127,889) 115.16% (502,500) 135,415 (637,915) -26.95% (18,450) 7,316 (25,766) -39.65% Contributions-connection fees - - - 0.00% 231,700 209,342 22,358 90.35% - - - 0.00% Transfers in - - - 0.00% - - - 0.00% 25,000 - 25,000 0.00% Transfers out (717,500) (580,289) (137,211) 80.88% (115,000) (115,000) - 100.00% (25,000) (25,000) - 100.00% NET INCOME(LOSS) 1269250 3919350 (265,100) 309.98% (385,800) 229,757 (6159557) -59.55% (18,450) (17,684) (766) 95.85% Items reclassified to balance sheet at year end: Capital Outlay (15,000) (1,380) (13,620) 9.20% (611,500) - (611,500) 0.00% Bond Payment - - - 0.00% (175,000) (175,000) - 100.00% Revenues over/(under)expenditures 111,250 3899970 (278,720) (11172,300) 54,757 (11227,057) (18,450) (17,684) (766) *Recorded at year end 8-12-2013 01:32 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JULY 31ST, 2013 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 32,152.32 2,878.12 35,030.44 101-1010 Cash - General Fund 4,994,224.97 1,143,679.32 6,137,904.29 211-1010 Cash - Library 456,097.05 4,548.75 460,645.8C 221-1010 Cash - Ice Arena 131,753.04 23,384.17 155,137.21 222-1010 Cash - Pinewood Golf Course 7,989.75) 4,694.44 3,295.31) 223-1010 Cash - Sr Citizen Account 1,292.23 0.00 1,292.23 225-1010 Cash - Park Dedication 20,400.85 3,712.00 24,112.85 228-1010 Cash - Landfill 737,641.80 38,744.94) 698,896.86 231-1010 Cash - Landfill Const Debris 706,659.37 0.00 706,659.37 240-1010 Cash - Micro Loan Fund 908,463.81 60,635.89 969,099.7C 241-1010 Cash - Federal DEED 509,585.80 0.00 509,585.8C 242-1010 Cash - State DEED 403,953.95 0.00 403,953.95 245-1010 Cash - Development Fund 1,017,088.98 135,506.47) 881,582.51 290-1010 Cash - Capital Outlay Reserve 1,611,104.41 831.65) 1,610,272.76 291-1010 Cash - Insurance Reserve 338,201.21 1,015.59 339,216.8C 292-1010 Cash - Govt Bldgs Reserve 4,491,169.46 606,466.35) 3,884,703.11 294-1010 Cash - Drug Forfeiture 42,677.49 18,891.97 61,569.46 295-1010 Cash - Severance Pay Reserve 116,226.60 0.00 116,226.6C 296-1010 Cash - GRE Reserve 1,616,658.28 335,500.00 1,952,158.28 311-1010 Cash - 2003A GO Bonds 40,129.95) 4,148.18 35,981.77) 312-1010 Cash - 2005A GO Bonds 142,314.25 142,314.25) O.00 313-1010 Cash - 2007C GO Bonds 109,046.81 114,904.60 223,951.41 333-1010 Cash - 2010A GO Cap Imp Bonds 305,396.96 300,060.80 605,457.76 344-1010 Cash - 2006C Cap Imp Bonds Lby 431.25) 0.00 431.25) 345-1010 Cash - 2012A CIP Bonds-PW 822.68 0.00 822.68 350-1010 Cash - State-Aid Road Bonds 0.00 502,270.95 502,270.95 401-1010 Cash - Pavement Mgmt 2,955,231.00 761,034.63) 2,194,196.37 403-1010 Cash - Street Improvement 1,618,532.68 88,333.10) 1,530,199.58 404-1010 Cash - Surface Water Managemnt 201,537.03 8,745.18) 192,791.85 406-1010 Cash - City Wide Trunk Util 4,544,639.72 89,923.90 4,634,563.62 410-1010 Cash - Equipment Replacement 963,401.28 9,876.39) 953,524.89 426-1010 Cash - YMCA 874,808.85 250,000.00) 624,808.85 440-1010 Cash - Park Improvement 215,911.26 53,993.94) 161,917.32 459-1010 Cash - TIF 419 Highway 169 368,794.16 0.00 368,794.16 462-1010 Cash - TIF 422 Downtown Redev 0.00 0.01) ( 0.01) 602-1010 Cash - Wastewater Treatment 5,454,288.04 104,576.95) 5,349,711.09 603-1010 Cash - Liquor 1,862,346.68 212,949.35) 1,649,397.33 605-1010 Cash - Garbage 613,590.21 12,601.13) 600,989.08 801-1010 Cash - Interest 0.00 57,009.84 57,009.84 821-1010 Cash - Developer Escrow 62,112.4C 6,549.00 68,661.40 TOTAL CLAIM ON CASH 38,379,574.68 247,833.18 38,627,407.86 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 45,841,887.72 1,096,925.63 46,938,813.35 999-1001 PY BANK ACCOUNT (35,844,502.60) ( 849,092.45) (36,693,595.05) 999-1002 POOLED INVESTMENTS 28,382,189.56 O.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 38,379,574.68 247,833.18 38,627,407.86