Loading...
INFORMATION #1 06-17-2013 INFORMATION �i City of Elk River MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: June 17, 2013 SUBJECT: May 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 May, actual revenues (except for property taxes and state aids) and expenditures should run about 41.7% 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 exceeded. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. GENERAL FUND Revenues: • Excluding transfers, revenue collections are about 6.5% of budget estimates. The first installment of the first half property taxes, our largest revenue source,will be received in June. • Licenses and permit collections are 42% of budget estimates. The majority of the annual liquor license renewals were collected in May. • Charges for services are 40% of budget with May collections consisting primarily of the fire contract billing for Big Lake Township, engineering services reimbursement, and recreation fees for summer programs. • The transfer in is the Utilities' 3% contribution based on April electric sales. All other transfers will be recorded mid-year. 1`4A U Expenditures: • Excluding transfers, total departmental expenditures are 35% 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. 2013 Monthly Expenditures $14,000 $12,000 o $10,000 z a $8,000 O $6,000 $4,000 $2,000 $0 Jan Oa r Apr May Jun Jul Aug Sep Oct Nov Dec �Actual $617 $1,541 $2,798 $3,7111$4,5361 Budget $1,070 $2,139 $3,209 $4,2791$5,3491$6,4181$7,4881$8,5581$9,6281$10,691$11,761$12,83 ICE ARENA For May, revenues exceed expenditures by$96,509. Excluding transfers,revenues are 44% of budget. Revenues consist mainly of ice rental billings while expenditures are well within budget estimates at 24%. PINEWOOD GOLF For May, expenditures exceed revenues by$19,512. Excluding transfers,revenues are about 25% of budget estimates and membership fees are at 98.5% of estimates. Expenditures are at 28% of budget. ATTACHMENTS ■ General Fund Revenue& Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,636,950.00 244,380.91 977,529.90 7.74 11,659,420.10 TOTAL REVENUES 12,636,950.00 244,380.91 977,529.90 7.74 11,659,420.10 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- EXPENDITURE SUMMARY General Government Mayor & Council 151,500.00 31466.01 55,966.40 36.94 95,533.60 Cable TV 87,550.00 6,159.62 32,549.02 37.18 55,000.98 Administrative Services 588,250.00 40,130.11 209,149.59 35.55 379,100.41 Human Resources 96,350.00 7,107.98 38,818.19 40.29 57,531.81 Finance 540,450.00 35,690.18 255,423.40 47.26 285,026.60 Information Technology 296,700.00 24,269.06 105,330.45 35.50 191,369.55 Legal 228,000.00 19,328.15 77,313.70 33.91 150,686.30 Community Development 213,800.00 22,009.81 93,630.48 43.79 120,169.52 Planning 236,700.00 7,835.19 63,169.10 26.69 173,530.90 City Hall Maintenance 517,350.00 35,300.94 194,599.77 37.61 322,750.23 Contingency 81400.00 0.00 0.00 0.00 8,400.00 TOTAL General Government 21965,050.00 201,297.05 11125,950.10 37.97 11839,099.90 Public Safety Police Administration 637,350.00 32,229.05 236,974.12 37.18 400,375.88 Patrol 2,362,450.00 163,256.98 848,868.61 35.93 1,513,581.39 Investigations 772,250.00 48,917.26 269,498.54 34.90 502,751.46 Police Support Services 500,650.00 33,386.60 173,852.48 34.73 326,797.52 Police Reserves 21,600.00 21629.50 41403.17 20.39 17,196.83 Public safety building 76,000.00 2,885.52 24,999.88 32.89 51,000.12 Fire Administration 295,200.00 17,160.46 100,101.11 33.91 195,098.89 Fire Operations 344,250.00 17,406.75 90,602.04 26.32 253,647.96 Emergency Management 28,800.00 278.57 4,498.43 15.62 24,301.57 Building Safety 663,600.00 41,856.50 244,289.39 36.81 419,310.61 Code Enforcement 85,050.00 61044.11 32,250.07 37.92 52,799.93 Environmental 52,350.00 21730.18 10,223.18 19.53 42,126.82 TOTAL Public Safety 5,839,550.00 368,781.48 2,040,561.02 34.94 3,798,988.98 Public Works Street Maintenance 11530,200.00 90,832.65 423,222.35 27.66 11106,977.65 Snow Removal 285,700.00 21390.28 186,689.74 65.34 99,010.26 Equipment Services 252,750.00 16,838.05 85,064.46 33.66 167,685.54 Engineering 173,350.00 13,590.39 71,679.16 41.35 101,670.84 TOTAL Public Works 2,242,000.00 123,651.37 766,655.71 34.20 1,475,344.29 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 807,450.00 64,737.21 278,830.57 34.53 528,619.43 Parks & Rec Admin 522,100.00 31,843.52 188,503.16 36.10 333,596.84 Recreation Programs 196,500.00 71944.31 33,664.97 17.13 162,835.03 Sr Citizen Programs 188,050.00 14,305.77 71,568.64 38.06 116,481.36 TOTAL Culture & Recreation 11714,100.00 118,830.81 572,567.34 33.40 11141,532.66 Economic Development Economic Development 0.00 13,415.14 25,967.69 0.00 ( 25,967.69) Energy City 31,450.00 11334.81 61454.85 20.52 24,995.15 TOTAL Economic Development 31,450.00 14,749.95 32,422.54 103.09 ( 972.54) General 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 827,310.66 41538,156.71 35.35 81298,793.29 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES ( 200,000.00) ( 582,929.75) ( 3,560,626.81) 31 360,626.81 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,203,100.00 0.00 11600.96 0.02 9,201,499.04 101-3-0000-3121 Gravel Tax 84,000.00 0.00 11,352.07 13.51 72,647.93 TOTAL Taxes 91287,100.00 0.00 12,953.03 0.14 91274,146.97 Licenses & Permits 101-3-0000-3211 Liquor License 61,500.00 47,885.00 59,825.00 97.28 11675.00 101-3-0000-3212 Amusement License 11000.00 0.00 0.00 0.00 11000.00 101-3-0000-3213 Cigarette License 31000.00 62.50 62.50 2.08 21937.50 101-3-0000-3214 Apartment License 25,000.00 21115.58 26,390.58 105.56 ( 11390.58) 101-3-0000-3216 Mining License 21,000.00 11571.70 41385.35 20.88 16,614.65 101-3-0000-3217 Garbage Hauler License 11900.00 0.00 210.00 11.05 11690.00 101-3-0000-3218 Other Business License/Permit 17,000.00 790.00 31450.00 20.29 13,550.00 101-3-0000-3229 NPDES Permit 21500.00 11575.00 51250.00 210.00 ( 21750.00) 101-3-0000-3231 Building Permit 220,000.00 19,501.35 90,268.80 41.03 129,731.20 101-3-0000-3232 Plumbing/Heating Permit 190,000.00 14,911.82 36,096.28 19.00 153,903.72 101-3-0000-3233 Permit Surcharge 500.00 ( 576.12) 11773.77 354.75 ( 11273.77) 101-3-0000-3235 Animal License 41500.00 11280.00 21630.00 58.44 11870.00 101-3-0000-3236 Parking Permit 21000.00 ( 2.57) 168.43 8.42 11831.57 101-3-0000-3237 Other Non-Business Lic/Permit 81500.00 21525.00 41835.00 56.88 31665.00 TOTAL Licenses & Permits 558,400.00 91,639.26 235,345.71 42.15 323,054.29 Intergovernmental Rev 101-3-0000-3311 Federal Grant 21300.00 0.00 0.00 0.00 21300.00 101-3-0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2% 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 0.00 145,385.02 50.55 142,214.98 101-3-0000-3329 State Crime Prevention Grant 20,000.00 0.00 0.01 0.00 19,999.99 101-3-0000-3330 Other State Grants 600.00 0.00 0.00 0.00 600.00 TOTAL Intergovernmental Rev 545,600.00 0.00 145,385.03 26.65 400,214.97 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 11700.00 61290.00 41.93 81710.00 101-3-0000-3413 Plan Check Fee 85,000.00 81632.48 34,417.29 40.49 50,582.71 101-3-0000-3415 Special Assessment Search 11000.00 20.00 620.00 62.00 380.00 101-3-0000-3417 Copies 21600.00 87.86 11189.42 45.75 11410.58 101-3-0000-3418 Other General Govt Services 41000.00 408.00 11114.75 27.87 21885.25 101-3-0000-3430 Lockout Fees 71500.00 660.00 21900.00 38.67 4,600.00 101-3-0000-3431 Police Services 21000.00 110.00 320.00 16.00 1,680.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 31500.00 350.00 11275.00 36.43 21225.00 101-3-0000-3436 Fire Contracts 201,000.00 18,594.00 109,104.72 54.28 91,895.28 101-3-0000-3437 Fire Services 31000.00 101.40 187.10 6.24 21812.90 101-3-0000-3451 Street Services 30,000.00 51086.50 61184.00 20.61 23,816.00 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3452 Engineering Services Reimb 104,900.00 28,041.67 28,041.67 26.73 76,858.33 101-3-0000-3461 Recreation Fees 126,000.00 13,956.50 60,566.63 48.07 65,433.37 101-3-0000-3462 Sr Center Activities 0.00 21550.00 13,430.00 0.00 ( 13,430.00) 101-3-0000-3472 Park Use Fee 15,000.00 232.88 61897.60 45.98 81102.40 101-3-0000-3474 Facility Use Fee 51700.00 0.00 0.00 0.00 51700.00 101-3-0000-3475 Building Rent 21400.00 200.00 11000.00 41.67 11400.00 101-3-0000-3483 Sewer Inspection Fee 31000.00 715.00 21505.00 83.50 495.00 101-3-0000-3484 Contractor License Check 400.00 85.00 250.00 62.50 150.00 TOTAL Charges for Services 687,000.00 81,531.29 276,293.18 40.22 410,706.82 Fines & Forfeits 101-3-0000-3510 Court Fines 115,000.00 11,150.13 38,437.67 33.42 76,562.33 101-3-0000-3511 Parking Fines 12,000.00 40.00 71730.00 64.42 41270.00 101-3-0000-3512 Ordinance Violations 200.00 0.00 0.00 0.00 200.00 TOTAL Fines & Forfeits 127,200.00 11,190.13 46,167.67 36.30 81,032.33 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 91813.93 9.81 90,186.07 101-3-0000-3625 Refunds & Reimbursements 66,500.00 ( 360.91) ( 117.38) 0.18- 66,617.38 101-3-0000-3626 Contributions 25,000.00 750.00 14,750.00 59.00 10,250.00 101-3-0000-3629 Miscellaneous Revenue 6,000.00 31845.14 6,313.03 105.22 ( 313.03) TOTAL Other Revenue 197,500.00 41234.23 30,759.58 15.57 166,740.42 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 0.00 0.00 0.00 35,000.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 100,000.00 0.00 0.00 0.00 100,000.00 101-3-0000-3943 Transfer-Liquor 330,000.00 0.00 0.00 0.00 330,000.00 101-3-0000-3944 Transfer-Garbage 25,000.00 0.00 0.00 0.00 25,000.00 101-3-0000-3945 Transfer-Utilities 500,000.00 55,786.00 230,625.70 46.13 269,374.30 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 0.00 18,150.00 TOTAL Transfers In 11234,150.00 55,786.00 230,625.70 18.69 11003,524.30 TOTAL General Fund 12,636,950.00 244,380.91 977,529.90 7.74 11,659,420.10 TOTAL REVENUE 12,636,950.00 244,380.91 977,529.90 7.74 11,659,420.10 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council --------------- --------------- Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 31208.32 15,166.28 39.39 23,333.72 101-4-1110-4104 PERA 11900.00 0.00 283.34 14.91 11616.66 101-4-1110-4105 FICA 21400.00 0.00 534.76 22.28 11865.24 101-4-1110-4107 Medicare 550.00 0.00 173.38 31.52 376.62 101-4-1110-4109 Workers Comp 100.00 0.00 37.00 37.00 63.00 TOTAL Personal Services 43,450.00 31208.32 16,194.76 37.27 27,255.24 Supplies 101-4-1110-4201 Office Supplies 3,000.00 23.79 915.98 30.53 21084.02 TOTAL Supplies 31000.00 23.79 915.98 30.53 21084.02 Other Services & Charges 101-4-1110-4319 Other Professional Services 16,500.00 0.00 21214.98 13.42 14,285.02 101-4-1110-4322 Postage 400.00 0.00 581.36 145.34 ( 181.36) 101-4-1110-4331 Travel, Conferences & Schools 41100.00 0.00 0.00 0.00 41100.00 101-4-1110-4359 Publishing 31700.00 82.50 744.00 20.11 2,956.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 151.40 61068.32 56.19 41731.68 TOTAL Other Services & Charges 105,050.00 233.90 38,855.66 36.99 66,194.34 Capital Outlay TOTAL Mayor & Council 151,500.00 31466.01 55,966.40 36.94 95,533.60 Cable TV Personal Services 101-4-1120-4101 Regular Pay 59,700.00 41593.60 22,738.33 38.09 36,961.67 101-4-1120-4103 Part-time Pay 61750.00 289.25 11443.00 21.38 5,307.00 101-4-1120-4104 PERA 41350.00 166.52 11661.62 38.20 2,688.38 101-4-1120-4105 FICA 41100.00 124.98 11313.11 32.03 2,786.89 101-4-1120-4107 Medicare 950.00 29.23 307.11 32.33 642.89 101-4-1120-4108 Insurance 91150.00 951.00 41755.00 51.97 41395.00 101-4-1120-4109 Workers Comp 300.00 0.00 132.00 44.00 168.00 TOTAL Personal Services 85,300.00 61154.58 32,350.17 37.93 52,949.83 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1120-4201 Office Supplies 800.00 5.04 198.85 24.86 601.15 TOTAL Supplies 800.00 5.04 198.85 24.86 601.15 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 11250.00 0.00 0.00 0.00 11250.00 101-4-1120-4404 Equip Repair/Maint Services 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 11450.00 0.00 0.00 0.00 11450.00 Capital Outlay TOTAL Cable TV 87,550.00 61159.62 32,549.02 37.18 55,000.98 Administrative Services ----------------------- ----------------------- Personal Services 101-4-1210-4101 Regular Pay 361,450.00 27,802.54 137,622.60 38.08 223,827.40 101-4-1210-4103 Part-time Pay 43,350.00 31024.80 15,125.33 34.89 28,224.67 101-4-1210-4104 PERA 29,350.00 11117.49 11,026.50 37.57 18,323.50 101-4-1210-4105 FICA 25,100.00 940.58 91336.11 37.20 15,763.89 101-4-1210-4107 Medicare 51850.00 219.98 21183.47 37.32 31666.53 101-4-1210-4108 Insurance 31,550.00 21542.04 12,557.39 39.80 18,992.61 101-4-1210-4109 Workers Comp 21350.00 0.00 1,324.00 56.34 11026.00 TOTAL Personal Services 499,000.00 35,647.43 189,175.40 37.91 309,824.60 Supplies 101-4-1210-4201 Office Supplies 11,500.00 11620.79 31179.24 27.65 81320.76 TOTAL Supplies 11,500.00 11620.79 31179.24 27.65 8,320.76 Other Services & Charges 101-4-1210-4319 Other Professional Services 61100.00 0.00 327.00 5.36 51773.00 101-4-1210-4321 Telephone 350.00 95.59 433.11 123.75 ( 83.11) 101-4-1210-4322 Postage 11000.00 0.00 353.38 35.34 646.62 101-4-1210-4331 Travel, Conferences & Schools 71600.00 438.72 11211.70 15.94 6,388.30 101-4-1210-4334 Car Allowance 41800.00 400.00 21000.00 41.67 21800.00 101-4-1210-4359 Publishing 14,000.00 0.00 61022.00 43.01 71978.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 11919.62 61014.92 25.06 17,985.08 101-4-1210-4433 Dues & Subscriptions 700.00 7.96 301.84 43.12 398.16 TOTAL Other Services & Charges 58,750.00 21861.89 16,794.95 28.59 41,955.05 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-1210-4560 Equipment 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Capital Outlay 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Administrative Services 588,250.00 40,130.11 209,149.59 35.55 379,100.41 Human Resources --------------- --------------- Personal Services 101-4-1220-4101 Regular Pay 70,600.00 51430.08 26,878.92 38.07 43,721.08 101-4-1220-4103 Part-time Pay 0.00 459.36 11607.76 0.00 ( 11607.76) 101-4-1220-4104 PERA 51100.00 196.84 21200.47 43.15 21899.53 101-4-1220-4105 FICA 41400.00 162.48 11831.00 41.61 21569.00 101-4-1220-4107 Medicare 11000.00 38.00 428.22 42.82 571.78 101-4-1220-4108 Insurance 61250.00 525.01 31067.37 49.08 31182.63 101-4-1220-4109 Workers Comp 400.00 0.00 222.00 55.50 178.00 TOTAL Personal Services 87,750.00 61811.77 36,235.74 41.29 51,514.26 Supplies 101-4-1220-4201 Office Supplies 1,900.00 176.36 1,338.51 70.45 561.49 TOTAL Supplies 11900.00 176.36 11338.51 70.45 561.49 Other Services & Charges 101-4-1220-4319 Other Professional Services 21000.00 119.85 11119.85 55.99 880.15 101-4-1220-4322 Postage 900.00 0.00 104.09 11.57 795.91 101-4-1220-4331 Travel, Conferences & Schools 31000.00 0.00 20.00 0.67 21980.00 101-4-1220-4433 Dues & Subscriptions 800.00 0.00 0.00 0.00 800.00 TOTAL Other Services & Charges 61700.00 119.85 11243.94 18.57 51456.06 Capital Outlay TOTAL Human Resources 96,350.00 71107.98 38,818.19 40.29 57,531.81 Elections Personal Services Supplies Other Services & Charges 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % 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 114,171.61 38.13 185,278.39 101-4-1310-4103 Part-time Pay 50,300.00 41134.25 20,211.86 40.18 30,088.14 101-4-1310-4104 PERA 25,350.00 11001.49 91680.37 38.19 15,669.63 101-4-1310-4105 FICA 21,700.00 828.02 81033.13 37.02 13,666.87 101-4-1310-4107 Medicare 51100.00 193.65 11878.72 36.84 31221.28 101-4-1310-4108 Insurance 30,500.00 21462.11 12,091.87 39.65 18,408.13 101-4-1310-4109 Workers Comp 21050.00 0.00 11054.00 51.41 996.00 TOTAL Personal Services 434,450.00 31,652.98 167,121.56 38.47 267,328.44 Supplies 101-4-1310-4201 Office Supplies 61900.00 21079.19 21597.18 37.64 41302.82 TOTAL Supplies 61900.00 21079.19 21597.18 37.64 41302.82 Other Services & Charges 101-4-1310-4301 Audit Fees 18,300.00 0.00 13,740.00 75.08 4,560.00 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 33.18 150.67 43.05 199.33 101-4-1310-4322 Postage 21300.00 0.00 792.42 34.45 11507.58 101-4-1310-4331 Travel, Conferences & Schools 21450.00 19.52 383.02 15.63 2,066.98 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 11581.16 15,559.57 103.04 ( 459.57) 101-4-1310-4433 Dues & Subscriptions 11500.00 0.00 735.00 49.00 765.00 101-4-1310-4438 Credit Card Fees 41000.00 245.80 698.78 17.47 31301.22 101-4-1310-4440 Miscellaneous 1,000.00 78.35 441.20 44.12 558.80 TOTAL Other Services & Charges 99,100.00 11958.01 85,704.66 86.48 13,395.34 Capital Outlay TOTAL Finance 540,450.00 35,690.18 255,423.40 47.26 285,026.60 Information Technology ---------------------- ---------------------- Personal Services 101-4-1350-4101 Regular Pay 138,450.00 10,651.68 53,338.72 38.53 85,111.28 101-4-1350-4103 Part-time Pay 13,500.00 11252.00 11752.80 12.98 11,747.20 101-4-1350-4104 PERA 11,000.00 431.52 31979.07 36.17 71020.93 101-4-1350-4105 FICA 91400.00 353.75 31189.14 33.93 6,210.86 101-4-1350-4107 Medicare 21200.00 82.73 745.84 33.90 11454.16 101-4-1350-4108 Insurance 21,450.00 11741.02 81684.60 40.49 12,765.40 101-4-1350-4109 Workers Comp 800.00 0.00 442.50 55.31 357.50 TOTAL Personal Services 196,800.00 14,512.70 72,132.67 36.65 124,667.33 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1350-4219 Operating Supplies 20,800.00 21284.31 71848.81 37.73 12,951.19 TOTAL Supplies 20,800.00 21284.31 71848.81 37.73 12,951.19 Other Services & Charges 101-4-1350-4319 Other Professional Services 51000.00 650.00 909.00 18.18 41091.00 101-4-1350-4321 Telephone 11800.00 138.38 550.56 30.59 11249.44 101-4-1350-4331 Travel, Conferences & Schools 61200.00 120.31 41445.60 71.70 11754.40 101-4-1350-4404 Equip Repair/Maint Services 40,200.00 51229.93 71210.38 17.94 32,989.62 TOTAL Other Services & Charges 53,200.00 61138.62 13,115.54 24.65 40,084.46 Capital Outlay 101-4-1350-4560 Equipment 25,900.00 1,333.43 12,233.43 47.23 13,666.57 TOTAL Capital Outlay 25,900.00 11333.43 12,233.43 47.23 13,666.57 TOTAL Information Technology 296,700.00 24,269.06 105,330.45 35.50 191,369.55 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 228,000.00 19,328.15 77,313.70 33.91 150,686.30 TOTAL Other Services & Charges 228,000.00 19,328.15 77,313.70 33.91 150,686.30 TOTAL Legal 228,000.00 19,328.15 77,313.70 33.91 150,686.30 Community Development --------------------- --------------------- Personal Services 101-4-1500-4101 Regular Pay 164,200.00 18,666.84 76,507.86 46.59 87,692.14 101-4-1500-4104 PERA 11,900.00 676.68 51035.06 42.31 6,864.94 101-4-1500-4105 FICA 10,200.00 562.05 41218.44 41.36 5,981.56 101-4-1500-4107 Medicare 21400.00 131.45 986.58 41.11 11413.42 101-4-1500-4108 Insurance 23,500.00 11574.03 51323.11 22.65 18,176.89 101-4-1500-4109 Workers Comp 11200.00 0.00 637.50 53.13 562.50 TOTAL Personal Services 213,400.00 21,611.05 92,708.55 43.44 120,691.45 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1500-4201 Office Supplies 0.00 156.78 293.47 0.00 ( 293.47) TOTAL Supplies 0.00 156.78 293.47 0.00 ( 293.47) Other Services & Charges 101-4-1500-4321 Telephone 0.00 35.27 163.25 0.00 ( 163.25) 101-4-1500-4331 Travel, Conferences & Schools 400.00 206.71 465.21 116.30 ( 65.21) TOTAL Other Services & Charges 400.00 241.98 628.46 157.12 ( 228.46) TOTAL Community Development 213,800.00 22,009.81 93,630.48 43.79 120,169.52 Planning Personal Services 101-4-1510-4101 Regular Pay 154,250.00 51430.08 41,355.63 26.81 112,894.37 101-4-1510-4103 Part-time Pay 14,550.00 0.00 0.00 0.00 14,550.00 101-4-1510-4104 PERA 12,250.00 196.84 31446.33 28.13 8,803.67 101-4-1510-4105 FICA 10,450.00 145.91 21709.08 25.92 71740.92 101-4-1510-4107 Medicare 21450.00 34.13 633.60 25.86 1,816.40 101-4-1510-4108 Insurance 21,450.00 992.01 71384.16 34.42 14,065.84 101-4-1510-4109 Workers Comp 950.00 0.00 396.50 41.74 553.50 TOTAL Personal Services 216,350.00 61798.97 55,925.30 25.85 160,424.70 Supplies 101-4-1510-4201 Office Supplies 41450.00 300.52 853.12 19.17 31596.88 TOTAL Supplies 41450.00 300.52 853.12 19.17 3,596.88 Other Services & Charges 101-4-1510-4321 Telephone 400.00 85.72 331.09 82.77 68.91 101-4-1510-4322 Postage 21200.00 0.00 152.09 6.91 21047.91 101-4-1510-4331 Travel, Conferences & Schools 11650.00 60.00 371.24 22.50 11278.76 101-4-1510-4359 Publishing 81000.00 165.00 11675.00 20.94 6,325.00 101-4-1510-4361 Insurance 0.00 0.00 131.00 0.00 ( 131.00) 101-4-1510-4404 Equip Repair/Maint Services 21400.00 424.98 31144.26 131.01 ( 744.26) 101-4-1510-4433 Dues & Subscriptions 11000.00 0.00 540.00 54.00 460.00 101-4-1510-4440 Miscellaneous 250.00 0.00 46.00 18.40 204.00 TOTAL Other Services & Charges 15,900.00 735.70 61390.68 40.19 9,509.32 Capital Outlay TOTAL Planning 236,700.00 71835.19 63,169.10 26.69 173,530.90 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE City Hall Maintenance --------------------- --------------------- Personal Services 101-4-1600-4101 Regular Pay 281,150.00 21,511.64 104,634.11 37.22 176,515.89 101-4-1600-4102 Overtime Pay 31500.00 352.28 11760.28 50.29 11739.72 101-4-1600-4103 Part-time Pay 26,550.00 21221.04 91190.73 34.62 17,359.27 101-4-1600-4104 PERA 22,550.00 844.58 81388.99 37.20 14,161.01 101-4-1600-4105 FICA 19,300.00 759.12 71275.66 37.70 12,024.34 101-4-1600-4107 Medicare 41500.00 177.53 11701.52 37.81 21798.48 101-4-1600-4108 Insurance 32,500.00 21386.48 12,826.60 39.47 19,673.40 101-4-1600-4109 Workers Comp 10,300.00 0.00 51111.50 49.63 51188.50 TOTAL Personal Services 400,350.00 28,252.67 150,889.39 37.69 249,460.61 Supplies 101-4-1600-4212 Fuels & Lubs 41000.00 262.40 11641.26 41.03 21358.74 101-4-1600-4217 Uniform Allowance 11700.00 0.00 543.05 31.94 11156.95 101-4-1600-4219 Operating Supplies 27,000.00 21342.38 12,008.82 44.48 14,991.18 TOTAL Supplies 32,700.00 21604.78 14,193.13 43.40 18,506.87 Other Services & Charges 101-4-1600-4321 Telephone 11,000.00 11016.75 41665.86 42.42 6,334.14 101-4-1600-4331 Travel, Conferences & Schools 11500.00 88.53 368.53 24.57 11131.47 101-4-1600-4361 Insurance 41400.00 0.00 21451.00 55.70 11949.00 101-4-1600-4389 Utilities 34,200.00 21980.23 13,907.44 40.67 20,292.56 101-4-1600-4401 Bldg Repair/Maint Services 23,950.00 230.94 71334.82 30.63 16,615.18 101-4-1600-4404 Equip Repair/Maint Services 81200.00 39.54 352.10 4.29 71847.90 101-4-1600-4460 Equip Replacement Charge 1,050.00 87.50 437.50 41.67 612.50 TOTAL Other Services & Charges 84,300.00 41443.49 29,517.25 35.01 54,782.75 Capital Outlay TOTAL City Hall Maintenance 517,350.00 35,300.94 194,599.77 37.61 322,750.23 Contingency Personal Services 101-4-1900-4101 Regular Pay ( 41,600.00) 0.00 0.00 0.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 0.00 50,000.00 TOTAL Other Services & Charges 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL Contingency 81400.00 0.00 0.00 0.00 81400.00 TOTAL General Government 21965,050.00 201,297.05 11125,950.10 37.97 11839,099.90 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration --------------------- --------------------- Personal Services 101-4-2110-4101 Regular Pay 331,700.00 22,038.16 109,088.88 32.89 222,611.12 101-4-2110-4104 PERA 44,550.00 11586.75 15,833.29 35.54 28,716.71 101-4-2110-4105 FICA 21800.00 0.00 0.00 0.00 21800.00 101-4-2110-4107 Medicare 31300.00 101.99 11016.31 30.80 21283.69 101-4-2110-4108 Insurance 37,150.00 11776.02 81880.10 23.90 28,269.90 101-4-2110-4109 Workers Comp 61,500.00 0.00 32,477.00 52.81 29,023.00 TOTAL Personal Services 481,000.00 25,502.92 167,295.58 34.78 313,704.42 Supplies 101-4-2110-4201 Office Supplies 14,000.00 787.87 31088.81 22.06 10,911.19 101-4-2110-4217 Uniform Allowance 21700.00 121.63 11093.08 40.48 1,606.92 101-4-2110-4219 Operating Supplies 5,600.00 0.76 21992.66 53.44 2,607.34 TOTAL Supplies 22,300.00 910.26 71174.55 32.17 15,125.45 Other Services & Charges 101-4-2110-4319 Other Professional Services 41900.00 11303.84 11893.37 38.64 3,006.63 101-4-2110-4321 Telephone 32,750.00 11542.54 61453.17 19.70 26,296.83 101-4-2110-4322 Postage 21800.00 0.00 859.63 30.70 11940.37 101-4-2110-4331 Travel, Conferences & Schools 51050.00 689.00 11919.00 38.00 31131.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 91000.00 0.00 41650.00 51.67 41350.00 101-4-2110-4404 Equip Repair/Maint Services 74,250.00 700.49 43,678.82 58.83 30,571.18 101-4-2110-4433 Dues & Subscriptions 41500.00 11580.00 21894.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 51815.87 62,503.99 46.63 71,546.01 Capital Outlay TOTAL Police Administration 637,350.00 32,229.05 236,974.12 37.18 400,375.88 Patrol Personal Services 101-4-2120-4101 Regular Pay 11515,850.00 110,145.53 576,901.57 38.06 938,948.43 101-4-2120-4102 Overtime Pay 90,000.00 11980.67 91294.26 10.33 80,705.74 101-4-2120-4104 PERA 231,250.00 81000.28 82,118.38 35.51 149,131.62 101-4-2120-4107 Medicare 20,900.00 705.58 71081.79 33.88 13,818.21 101-4-2120-4108 Insurance 171,850.00 13,310.14 63,646.70 37.04 108,203.30 TOTAL Personal Services 21029,850.00 134,142.20 739,042.70 36.41 11290,807.30 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 131,650.00 91966.48 48,953.87 37.18 82,696.13 101-4-2120-4217 Uniform Allowance 17,700.00 21269.98 41055.04 22.91 13,644.96 101-4-2120-4219 Operating Supplies 66,450.00 71465.83 22,642.58 34.07 43,807.42 101-4-2120-4221 Equipment Parts 25,000.00 11376.60 21065.91 8.26 22,934.09 TOTAL Supplies 240,800.00 21,078.89 77,717.40 32.27 163,082.60 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 20,350.00 995.00 71188.91 35.33 13,161.09 101-4-2120-4404 Equip Repair/Maint Services 25,700.00 31274.22 51886.25 22.90 19,813.75 101-4-2120-4433 Dues & Subscriptions 550.00 0.00 200.00 36.36 350.00 101-4-2120-4460 Equip Replacement Charge 45,200.00 31766.67 18,833.35 41.67 26,366.65 TOTAL Other Services & Charges 91,800.00 81035.89 32,108.51 34.98 59,691.49 Capital Outlay TOTAL Patrol 21362,450.00 163,256.98 848,868.61 35.93 11513,581.39 Investigations -------------- -------------- Personal Services 101-4-2130-4101 Regular Pay 524,200.00 38,580.84 191,061.13 36.45 333,138.87 101-4-2130-4102 Overtime Pay 45,000.00 985.44 81092.59 17.98 36,907.41 101-4-2130-4104 PERA 81,950.00 21799.65 28,922.28 35.29 53,027.72 101-4-2130-4107 Medicare 71050.00 204.14 21199.40 31.20 41850.60 101-4-2130-4108 Insurance 73,150.00 5,821.46 29,107.30 39.79 44,042.70 TOTAL Personal Services 731,350.00 48,391.53 259,382.70 35.47 471,967.30 Supplies 101-4-2130-4217 Uniform Allowance 51500.00 0.00 522.38 9.50 4,977.62 101-4-2130-4219 Operating Supplies 81500.00 128.23 1,304.67 15.35 71195.33 TOTAL Supplies 14,000.00 128.23 11827.05 13.05 12,172.95 Other Services & Charges 101-4-2130-4319 Other Professional Services 61250.00 0.00 475.00 7.60 51775.00 101-4-2130-4331 Travel, Conferences & Schools 81200.00 ( 590.00) 21726.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 41937.50 41.67 61912.50 TOTAL Other Services & Charges 26,900.00 397.50 81288.79 30.81 18,611.21 Capital Outlay TOTAL Investigations 772,250.00 48,917.26 269,498.54 34.90 502,751.46 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services ----------------------- ----------------------- Personal Services 101-4-2150-4101 Regular Pay 313,950.00 23,940.80 118,742.10 37.82 195,207.90 101-4-2150-4102 Overtime Pay 10,000.00 210.31 918.83 9.19 91081.17 101-4-2150-4103 Part-time Pay 35,400.00 11741.00 71857.74 22.20 27,542.26 101-4-2150-4104 PERA 26,050.00 937.70 91313.26 35.75 16,736.74 101-4-2150-4105 FICA 22,300.00 770.34 71676.90 34.43 14,623.10 101-4-2150-4107 Medicare 51200.00 180.13 11795.30 34.53 3,404.70 101-4-2150-4108 Insurance 39,250.00 31650.05 18,250.25 46.50 20,999.75 TOTAL Personal Services 452,150.00 31,430.33 164,554.38 36.39 287,595.62 Supplies 101-4-2150-4201 Office Supplies 11000.00 0.00 0.00 0.00 11000.00 101-4-2150-4217 Uniform Allowance 31400.00 301.53 378.51 11.13 3,021.49 101-4-2150-4219 Operating Supplies 13,000.00 244.35 21636.29 20.28 10,363.71 TOTAL Supplies 17,400.00 545.88 31014.80 17.33 14,385.20 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 31450.00 0.00 843.70 24.46 2,606.30 101-4-2150-4404 Equip Repair/Maint Services 21100.00 101.53 101.53 4.83 11998.47 101-4-2150-4409 Contractual Services 17,500.00 679.69 11957.22 11.18 15,542.78 101-4-2150-4433 Dues & Subscriptions 500.00 0.00 235.00 47.00 265.00 101-4-2150-4460 Equip Replacement Charge 71550.00 629.17 3,145.85 41.67 41404.15 TOTAL Other Services & Charges 31,100.00 11410.39 61283.30 20.20 24,816.70 Capital Outlay TOTAL Police Support Services 500,650.00 33,386.60 173,852.48 34.73 326,797.52 Police Reserves --------------- --------------- Personal Services 101-4-2160-4103 Part-time Pay 51500.00 0.00 0.00 0.00 5,500.00 101-4-2160-4105 FICA 350.00 0.00 0.00 0.00 350.00 101-4-2160-4107 Medicare 100.00 0.00 0.00 0.00 100.00 TOTAL Personal Services 51950.00 0.00 0.00 0.00 5,950.00 Supplies 101-4-2160-4217 Uniform Allowance 51000.00 247.95 247.95 4.96 41752.05 101-4-2160-4219 Operating Supplies 6,100.00 1,756.55 21122.72 34.80 31977.28 TOTAL Supplies 11,100.00 21004.50 21370.67 21.36 81729.33 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2160-4319 Other Professional Services 11600.00 0.00 475.00 29.69 11125.00 101-4-2160-4321 Telephone 100.00 0.00 0.00 0.00 100.00 101-4-2160-4331 Travel, Conferences & Schools 11700.00 275.00 11207.50 71.03 492.50 101-4-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 101-4-2160-4433 Dues & Subscriptions 11000.00 350.00 350.00 35.00 650.00 TOTAL Other Services & Charges 41550.00 625.00 21032.50 44.67 21517.50 Capital Outlay TOTAL Police Reserves 21,600.00 21629.50 41403.17 20.39 17,196.83 Public safety building ---------------------- ---------------------- Personal Services Supplies 101-4-2190-4219 Operating Supplies 18,200.00 962.11 6,103.54 33.54 12,096.46 TOTAL Supplies 18,200.00 962.11 61103.54 33.54 12,096.46 Other Services & Charges 101-4-2190-4361 Insurance 51000.00 0.00 21436.00 48.72 21564.00 101-4-2190-4389 Utilities 19,450.00 11818.88 91616.82 49.44 91833.18 101-4-2190-4401 Bldg Repair/Maint Services 33,350.00 104.53 6,843.52 20.52 26,506.48 TOTAL Other Services & Charges 57,800.00 11923.41 18,896.34 32.69 38,903.66 Capital Outlay TOTAL Public safety building 76,000.00 21885.52 24,999.88 32.89 51,000.12 Fire Administration ------------------- ------------------- Personal Services 101-4-2310-4101 Regular Pay 99,900.00 71537.70 37,297.19 37.33 62,602.81 101-4-2310-4103 Part-time Pay 27,000.00 21017.98 10,423.55 38.61 16,576.45 101-4-2310-4104 PERA 16,350.00 615.21 61161.68 37.69 10,188.32 101-4-2310-4105 FICA 11650.00 61.99 819.39 49.66 830.61 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101-4-2310-4107 Medicare 11850.00 68.46 730.51 39.49 11119.49 101-4-2310-4108 Insurance 61250.00 621.01 31125.55 50.01 3,124.45 101-4-2310-4109 Workers Comp 41150.00 0.00 2,602.50 62.71 11547.50 TOTAL Personal Services 187,150.00 10,922.35 61,160.37 32.68 125,989.63 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2310-4201 Office Supplies 31800.00 212.12 11989.57 52.36 11810.43 101-4-2310-4212 Fuels & Lubs 31000.00 178.42 891.89 29.73 21108.11 101-4-2310-4217 Uniform Allowance 950.00 0.00 21.96 2.31 928.04 101-4-2310-4219 Operating Supplies 20,900.00 26.93 823.00 3.94 20,077.00 TOTAL Supplies 28,650.00 417.47 31726.42 13.01 24,923.58 Other Services & Charges 101-4-2310-4319 Other Professional Services 0.00 495.78 495.78 0.00 ( 495.78) 101-4-2310-4321 Telephone 21200.00 314.09 11225.95 55.73 974.05 101-4-2310-4322 Postage 11000.00 0.00 20.79 2.08 979.21 101-4-2310-4331 Travel, Conferences & Schools 11800.00 0.00 233.10 12.95 11566.90 101-4-2310-4359 Publishing 0.00 397.50 397.50 0.00 ( 397.50) 101-4-2310-4361 Insurance 15,500.00 0.00 61942.00 44.79 81558.00 101-4-2310-4389 Utilities 12,000.00 11218.02 51417.76 45.15 6,582.24 101-4-2310-4401 Bldg Repair/Maint Services 51500.00 69.47 21189.30 39.81 3,310.70 101-4-2310-4404 Equip Repair/Maint Services 61500.00 400.78 31505.14 53.93 21994.86 101-4-2310-4433 Dues & Subscriptions 11600.00 150.00 912.00 57.00 688.00 101-4-2310-4460 Equip Replacement Charge 33,300.00 21775.00 13,875.00 41.67 19,425.00 TOTAL Other Services & Charges 79,400.00 51820.64 35,214.32 44.35 44,185.68 Capital Outlay TOTAL Fire Administration 295,200.00 17,160.46 100,101.11 33.91 195,098.89 Fire Operations --------------- --------------- Personal Services 101-4-2320-4103 Part-time Pay 157,700.00 12,408.32 52,885.42 33.54 104,814.58 101-4-2320-4105 FICA 91800.00 20.32 21363.10 24.11 7,436.90 101-4-2320-4107 Medicare 21300.00 4.75 589.15 25.62 11710.85 101-4-2320-4109 Workers Comp 21,950.00 0.00 10,991.50 50.08 10,958.50 TOTAL Personal Services 191,750.00 12,433.39 66,829.17 34.85 124,920.83 Supplies 101-4-2320-4212 Fuels & Lubs 61000.00 713.96 31359.26 55.99 2,640.74 101-4-2320-4217 Uniform Allowance 61500.00 0.00 238.67 3.67 6,261.33 101-4-2320-4219 Operating Supplies 52,800.00 11441.11 10,864.22 20.58 41,935.78 101-4-2320-4221 Equipment Parts 61800.00 179.27 11427.43 20.99 51372.57 TOTAL Supplies 72,100.00 21334.34 15,889.58 22.04 56,210.42 Other Services & Charges 101-4-2320-4321 Telephone 21100.00 226.51 598.36 28.49 1,501.64 101-4-2320-4331 Travel, Conferences & Schools 20,450.00 11870.59 51838.61 28.55 14,611.39 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 541.92 11446.32 4.10 33,853.68 101-4-2320-4409 Contractual Services 6,450.00 0.00 0.00 0.00 61450.00 TOTAL Other Services & Charges 64,400.00 21639.02 71883.29 12.24 56,516.71 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-2320-4560 Equipment 16,000.00 0.00 0.00 0.00 16,000.00 TOTAL Capital Outlay 16,000.00 0.00 0.00 0.00 16,000.00 TOTAL Fire Operations 344,250.00 17,406.75 90,602.04 26.32 253,647.96 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 71100.00 118.67 21970.71 41.84 41129.29 TOTAL Supplies 71400.00 118.67 21970.71 40.14 4,429.29 Other Services & Charges 101-4-2330-4321 Telephone 650.00 26.00 104.00 16.00 546.00 101-4-2330-4331 Travel, Conferences & Schools 31650.00 0.00 0.00 0.00 3,650.00 101-4-2330-4389 Utilities 11200.00 37.71 150.51 12.54 11049.49 101-4-2330-4404 Equip Repair/Maint Services 31800.00 96.19 643.83 16.94 3,156.17 101-4-2330-4433 Dues & Subscriptions 100.00 0.00 100.00 100.00 0.00 TOTAL Other Services & Charges 91400.00 159.90 998.34 10.62 81401.66 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 278.57 41498.43 15.62 24,301.57 Building Safety --------------- --------------- Personal Services 101-4-2410-4101 Regular Pay 417,750.00 26,273.46 148,333.55 35.51 269,416.45 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 51970.38 29,407.38 43.92 37,542.62 101-4-2410-4104 PERA 40,200.00 11372.79 14,491.72 36.05 25,708.28 101-4-2410-4105 FICA 25,700.00 817.73 91105.00 35.43 16,595.00 101-4-2410-4107 Medicare 71050.00 228.50 21462.81 34.93 41587.19 101-4-2410-4108 Insurance 55,650.00 31963.05 20,865.27 37.49 34,784.73 101-4-2410-4109 Workers Comp 6,700.00 0.00 3,587.50 53.54 31112.50 TOTAL Personal Services 620,000.00 38,625.91 228,529.68 36.86 391,470.32 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2410-4201 Office Supplies 41600.00 339.77 693.39 15.07 3,906.61 101-4-2410-4212 Fuels & Lubs 81000.00 790.45 31530.89 44.14 4,469.11 101-4-2410-4217 Uniform Allowance 11900.00 0.00 0.00 0.00 11900.00 101-4-2410-4219 Operating Supplies 61900.00 223.02 11274.03 18.46 51625.97 TOTAL Supplies 21,400.00 11353.24 51498.31 25.69 15,901.69 Other Services & Charges 101-4-2410-4319 Other Professional Services 0.00 70.83 70.83 0.00 ( 70.83) 101-4-2410-4321 Telephone 41200.00 538.44 11102.41 26.25 3,097.59 101-4-2410-4322 Postage 0.00 0.00 232.91 0.00 ( 232.91) 101-4-2410-4331 Travel, Conferences & Schools 31200.00 330.00 21503.06 78.22 696.94 101-4-2410-4361 Insurance 650.00 0.00 631.50 97.15 18.50 101-4-2410-4404 Equip Repair/Maint Services 81300.00 613.08 21777.69 33.47 5,522.31 101-4-2410-4433 Dues & Subscriptions 11950.00 0.00 11318.00 67.59 632.00 101-4-2410-4460 Equip Replacement Charge 3,900.00 325.00 1,625.00 41.67 21275.00 TOTAL Other Services & Charges 22,200.00 11877.35 10,261.40 46.22 11,938.60 Capital Outlay TOTAL Building Safety 663,600.00 41,856.50 244,289.39 36.81 419,310.61 Code Enforcement ---------------- ---------------- Personal Services 101-4-2420-4101 Regular Pay 66,250.00 51096.00 25,225.22 38.08 41,024.78 101-4-2420-4102 Overtime Pay 0.00 0.00 179.15 0.00 ( 179.15) 101-4-2420-4104 PERA 41800.00 184.73 11675.19 34.90 31124.81 101-4-2420-4105 FICA 41100.00 168.53 11484.53 36.21 2,615.47 101-4-2420-4107 Medicare 950.00 39.41 347.17 36.54 602.83 101-4-2420-4108 Insurance 31600.00 241.38 11029.82 28.61 21570.18 101-4-2420-4109 Workers Comp 0.00 0.00 146.00 0.00 ( 146.00) TOTAL Personal Services 79,700.00 51730.05 30,087.08 37.75 49,612.92 Supplies 101-4-2420-4212 Fuels & Lubs 21250.00 224.52 11124.56 49.98 11125.44 101-4-2420-4219 Operating Supplies 250.00 0.00 0.00 0.00 250.00 TOTAL Supplies 21500.00 224.52 11124.56 44.98 11375.44 Other Services & Charges 101-4-2420-4321 Telephone 750.00 26.55 100.45 13.39 649.55 101-4-2420-4322 Postage 11000.00 0.00 126.77 12.68 873.23 101-4-2420-4331 Travel, Conferences & Schools 0.00 0.49 434.21 0.00 ( 434.21) 101-4-2420-4361 Insurance 350.00 0.00 64.50 18.43 285.50 101-4-2420-4460 Equip Replacement Charge 750.00 62.50 312.50 41.67 437.50 TOTAL Other Services & Charges 21850.00 89.54 11038.43 36.44 11811.57 TOTAL Code Enforcement 85,050.00 61044.11 32,250.07 37.92 52,799.93 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2440-4101 Regular Pay 36,450.00 11286.80 61117.39 16.78 30,332.61 101-4-2440-4104 PERA 21650.00 46.65 558.29 21.07 21091.71 101-4-2440-4105 FICA 21250.00 38.42 463.21 20.59 1,786.79 101-4-2440-4107 Medicare 500.00 8.98 108.31 21.66 391.69 101-4-2440-4108 Insurance 51300.00 60.01 300.05 5.66 41999.95 101-4-2440-4109 Workers Comp 550.00 0.00 256.50 46.64 293.50 101-4-2440-4110 Re-employment Compensation 0.00 329.60 329.60 0.00 ( 329.60) TOTAL Personal Services 47,700.00 11770.46 81133.35 17.05 39,566.65 Supplies 101-4-2440-4201 Office Supplies 500.00 56.94 246.77 49.35 253.23 101-4-2440-4212 Fuels & Lubs 150.00 0.00 38.84 25.89 111.16 101-4-2440-4219 Operating Supplies 11800.00 809.26 11558.53 86.59 241.47 TOTAL Supplies 21450.00 866.20 11844.14 75.27 605.86 Other Services & Charges 101-4-2440-4321 Telephone 350.00 41.02 158.59 45.31 191.41 101-4-2440-4322 Postage 500.00 0.00 34.60 6.92 465.40 101-4-2440-4331 Travel, Conferences & Schools 11200.00 0.00 0.00 0.00 11200.00 101-4-2440-4359 Publishing 100.00 52.50 52.50 52.50 47.50 101-4-2440-4433 Dues & Subscriptions 50.00 0.00 0.00 0.00 50.00 TOTAL Other Services & Charges 21200.00 93.52 245.69 11.17 11954.31 TOTAL Environmental 52,350.00 21730.18 10,223.18 19.53 42,126.82 TOTAL Public Safety 51839,550.00 368,781.48 21040,561.02 34.94 31798,988.98 Street Maintenance ------------------ ------------------ Personal Services 101-4-3120-4101 Regular Pay 404,300.00 35,728.52 141,066.94 34.89 263,233.06 101-4-3120-4102 Overtime Pay 41000.00 237.24 591.70 14.79 3,408.30 101-4-3120-4103 Part-time Pay 82,050.00 41704.89 20,750.20 25.29 61,299.80 101-4-3120-4104 PERA 33,850.00 11404.67 11,589.86 34.24 22,260.14 101-4-3120-4105 FICA 30,400.00 11134.22 11,372.53 37.41 19,027.47 101-4-3120-4107 Medicare 71100.00 265.27 21659.74 37.46 4,440.26 101-4-3120-4108 Insurance 62,500.00 51041.43 24,098.46 38.56 38,401.54 101-4-3120-4109 Workers Comp 24,300.00 0.00 12,493.00 51.41 11,807.00 TOTAL Personal Services 648,500.00 48,516.24 224,622.43 34.64 423,877.57 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Works 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 51900.00 130.92 587.40 9.96 5,312.60 101-4-3120-4212 Fuels & Lubs 80,250.00 51551.31 61,253.97 76.33 18,996.03 101-4-3120-4219 Operating Supplies 127,750.00 10,007.25 30,908.16 24.19 96,841.84 101-4-3120-4226 Street Signs 35,850.00 695.96 11875.71 5.23 33,974.29 TOTAL Supplies 249,750.00 16,385.44 94,625.24 37.89 155,124.76 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 212.48 212.48 38.63 337.52 101-4-3120-4321 Telephone 61100.00 583.82 21114.06 34.66 3,985.94 101-4-3120-4322 Postage 50.00 0.00 0.94 1.88 49.06 101-4-3120-4331 Travel, Conferences & Schools 31500.00 308.00 11527.53 43.64 11972.47 101-4-3120-4359 Publishing 200.00 0.00 14.67 7.34 185.33 101-4-3120-4361 Insurance 16,000.00 0.00 81809.50 55.06 71190.50 101-4-3120-4389 Utilities 52,000.00 51366.58 25,983.64 49.97 26,016.36 101-4-3120-4401 Bldg Repair/Maint Services 11500.00 0.00 580.71 38.71 919.29 101-4-3120-4404 Equip Repair/Maint Services 51000.00 2.84 123.66 2.47 41876.34 101-4-3120-4409 Contractual Services 447,650.00 11,501.45 25,102.07 5.61 422,547.93 101-4-3120-4415 Equipment Rental 41500.00 96.19 384.76 8.55 41115.24 101-4-3120-4417 Uniform Rental 41700.00 384.61 11484.41 31.58 31215.59 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 261.25 74.64 88.75 101-4-3120-4437 Taxes & Licenses 150.00 0.00 0.00 0.00 150.00 101-4-3120-4460 Equip Replacement Charge 89,700.00 71475.00 37,375.00 41.67 52,325.00 TOTAL Other Services & Charges 631,950.00 25,930.97 103,974.68 16.45 527,975.32 Capital Outlay TOTAL Street Maintenance 11530,200.00 90,832.65 423,222.35 27.66 11106,977.65 Snow Removal Personal Services 101-4-3130-4101 Regular Pay 106,550.00 11386.52 62,315.31 58.48 44,234.69 101-4-3130-4102 Overtime Pay 20,000.00 79.08 22,138.92 110.69 ( 21138.92) 101-4-3130-4103 Part-time Pay 200.00 0.00 525.76 262.88 ( 325.76) 101-4-3130-4104 PERA 81750.00 105.70 61606.92 75.51 21143.08 101-4-3130-4105 FICA 71850.00 86.07 51496.04 70.01 21353.96 101-4-3130-4107 Medicare 11850.00 20.13 11285.35 69.48 564.65 101-4-3130-4108 Insurance 16,550.00 402.10 71602.17 45.93 81947.83 101-4-3130-4109 Workers Comp 71950.00 0.00 31432.00 43.17 41518.00 TOTAL Personal Services 169,700.00 21079.60 109,402.47 64.47 60,297.53 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Works 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies 96,000.00 310.68 77,287.27 80.51 18,712.73 TOTAL Supplies 96,000.00 310.68 77,287.27 80.51 18,712.73 Other Services & Charges Capital Outlay 101-4-3130-4560 Equipment 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Capital Outlay 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Snow Removal 285,700.00 21390.28 186,689.74 65.34 99,010.26 Equipment Services ------------------ ------------------ Personal Services 101-4-3150-4101 Regular Pay 169,400.00 13,028.80 58,820.33 34.72 110,579.67 101-4-3150-4102 Overtime Pay 0.00 86.13 502.87 0.00 ( 502.87) 101-4-3150-4104 PERA 12,300.00 478.54 41356.17 35.42 71943.83 101-4-3150-4105 FICA 10,500.00 377.50 31508.17 33.41 61991.83 101-4-3150-4107 Medicare 21450.00 88.29 820.48 33.49 11629.52 101-4-3150-4108 Insurance 21,700.00 11691.99 71966.53 36.71 13,733.47 101-4-3150-4109 Workers Comp 41400.00 0.00 21182.00 49.59 21218.00 TOTAL Personal Services 220,750.00 15,751.25 78,156.55 35.41 142,593.45 Supplies 101-4-3150-4219 Operating Supplies 22,500.00 815.70 51871.60 26.10 16,628.40 101-4-3150-4221 Equipment Parts 61000.00 0.00 0.00 0.00 61000.00 TOTAL Supplies 28,500.00 815.70 51871.60 20.60 22,628.40 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 271.10 1,036.31 34.54 11963.69 TOTAL Other Services & Charges 31500.00 271.10 11036.31 29.61 21463.69 Capital Outlay TOTAL Equipment Services 252,750.00 16,838.05 85,064.46 33.66 167,685.54 Engineering 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Public Works 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 113,800.00 11,531.64 56,937.61 50.03 56,862.39 101-4-3300-4104 PERA 81250.00 418.02 41160.74 50.43 41089.26 101-4-3300-4105 FICA 71050.00 369.96 31670.48 52.06 31379.52 101-4-3300-4107 Medicare 11650.00 86.52 858.41 52.02 791.59 101-4-3300-4108 Insurance 14,150.00 600.01 31000.05 21.20 11,149.95 101-4-3300-4109 Workers Comp 600.00 0.00 139.50 23.25 460.50 TOTAL Personal Services 145,500.00 13,006.15 68,766.79 47.26 76,733.21 Supplies 101-4-3300-4201 Office Supplies 200.00 21.15 38.60 19.30 161.40 101-4-3300-4212 Fuels & Lubs 11000.00 63.64 69.19 6.92 930.81 101-4-3300-4219 Operating Supplies 1,000.00 0.00 81.17 8.12 918.83 TOTAL Supplies 21200.00 84.79 188.96 8.59 21011.04 Other Services & Charges 101-4-3300-4319 Other Professional Services 15,000.00 125.41 357.91 2.39 14,642.09 101-4-3300-4321 Telephone 11100.00 53.97 209.24 19.02 890.76 101-4-3300-4322 Postage 300.00 0.00 388.13 129.38 ( 88.13) 101-4-3300-4331 Travel, Conferences & Schools 21700.00 60.00 379.09 14.04 21320.91 101-4-3300-4361 Insurance 200.00 0.00 101.00 50.50 99.00 101-4-3300-4404 Equip Repair/Maint Services 51600.00 197.57 975.54 17.42 4,624.46 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 312.50 41.67 437.50 TOTAL Other Services & Charges 25,650.00 499.45 21723.41 10.62 22,926.59 Capital Outlay TOTAL Engineering 173,350.00 13,590.39 71,679.16 41.35 101,670.84 TOTAL Public Works 21242,000.00 123,651.37 766,655.71 34.20 11475,344.29 Parks Department ---------------- ---------------- Personal Services 101-4-5110-4101 Regular Pay 335,000.00 25,864.76 127,103.96 37.94 207,896.04 101-4-5110-4102 Overtime Pay 61600.00 0.00 11557.09 23.59 51042.91 101-4-5110-4103 Part-time Pay 58,250.00 41568.40 51162.40 8.86 53,087.60 101-4-5110-4104 PERA 26,200.00 11009.21 91526.19 36.36 16,673.81 101-4-5110-4105 FICA 24,900.00 857.84 71809.96 31.37 17,090.04 101-4-5110-4107 Medicare 51850.00 200.63 11826.58 31.22 41023.42 101-4-5110-4108 Insurance 45,600.00 31706.62 18,886.71 41.42 26,713.29 101-4-5110-4109 Workers Comp 10,500.00 0.00 51523.50 52.60 41976.50 TOTAL Personal Services 512,900.00 36,207.46 177,396.39 34.59 335,503.61 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Culture & Recreation 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5110-4212 Fuels & Lubs 40,200.00 31779.70 13,853.64 34.46 26,346.36 101-4-5110-4217 Uniform Allowance 31350.00 268.61 438.50 13.09 21911.50 101-4-5110-4219 Operating Supplies 84,050.00 14,221.44 30,438.42 36.21 53,611.58 101-4-5110-4221 Equipment Parts 13,000.00 21186.26 12,354.83 95.04 645.17 TOTAL Supplies 140,600.00 20,456.01 57,085.39 40.60 83,514.61 Other Services & Charges 101-4-5110-4319 Other Professional Services 0.00 70.83 70.83 0.00 ( 70.83) 101-4-5110-4321 Telephone 31750.00 437.35 11234.30 32.91 21515.70 101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-5110-4331 Travel, Conferences & Schools 31950.00 24.00 448.88 11.36 31501.12 101-4-5110-4361 Insurance 25,000.00 0.00 12,787.50 51.15 12,212.50 101-4-5110-4389 Utilities 24,700.00 11221.27 31166.30 12.82 21,533.70 101-4-5110-4401 Bldg Repair/Maint Services 41000.00 0.00 0.00 0.00 41000.00 101-4-5110-4404 Equip Repair/Maint Services 12,900.00 11314.22 21657.73 20.60 10,242.27 101-4-5110-4409 Contractual Services 61650.00 0.00 0.00 0.00 61650.00 101-4-5110-4415 Equipment Rental 17,000.00 343.57 670.75 3.95 16,329.25 101-4-5110-4460 Equip Replacement Charge 55,950.00 4,662.50 23,312.50 41.67 32,637.50 TOTAL Other Services & Charges 153,950.00 81073.74 44,348.79 28.81 109,601.21 Capital Outlay TOTAL Parks Department 807,450.00 64,737.21 278,830.57 34.53 528,619.43 Parks & Rec Admin ----------------- ----------------- Personal Services 101-4-5210-4101 Regular Pay 281,500.00 17,437.20 95,319.92 33.86 186,180.08 101-4-5210-4103 Part-time Pay 51,550.00 31337.72 17,175.00 33.32 34,375.00 101-4-5210-4104 PERA 23,800.00 752.34 81372.05 35.18 15,427.95 101-4-5210-4105 FICA 20,650.00 616.33 61933.79 33.58 13,716.21 101-4-5210-4107 Medicare 4,850.00 144.14 11621.57 33.43 31228.43 101-4-5210-4108 Insurance 40,000.00 21342.65 13,837.28 34.59 26,162.72 101-4-5210-4109 Workers Comp 21000.00 0.00 11993.00 99.65 7.00 TOTAL Personal Services 424,350.00 24,630.38 145,252.61 34.23 279,097.39 Supplies 101-4-5210-4219 Operating Supplies 13,200.00 11389.27 71379.63 55.91 51820.37 TOTAL Supplies 13,200.00 11389.27 71379.63 55.91 51820.37 Other Services & Charges 101-4-5210-4321 Telephone 51350.00 818.63 21398.05 44.82 21951.95 101-4-5210-4322 Postage 41500.00 0.00 11740.53 38.68 21759.47 101-4-5210-4331 Travel, Conferences & Schools 91850.00 76.80 809.43 8.22 91040.57 101-4-5210-4349 Advertising/Marketing 32,400.00 11328.41 91614.06 29.67 22,785.94 101-4-5210-4361 Insurance 650.00 0.00 368.00 56.62 282.00 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Culture & Recreation 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5210-4389 Utilities 41700.00 639.07 21713.58 57.74 11986.42 101-4-5210-4401 Bldg Repair/Maint Services 14,100.00 11944.17 61261.29 44.41 71838.71 101-4-5210-4404 Equip Repair/Maint Services 11,250.00 11016.79 10,275.98 91.34 974.02 101-4-5210-4433 Dues & Subscriptions 11750.00 0.00 11690.00 96.57 60.00 TOTAL Other Services & Charges 84,550.00 51823.87 35,870.92 42.43 48,679.08 Capital Outlay TOTAL Parks & Rec Admin 522,100.00 31,843.52 188,503.16 36.10 333,596.84 Recreation Programs ------------------- ------------------- Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 41067.19 18,800.26 22.93 63,199.74 101-4-5220-4104 PERA 21400.00 49.26 322.91 13.45 21077.09 101-4-5220-4105 FICA 41350.00 118.46 11134.51 26.08 31215.49 101-4-5220-4107 Medicare 11200.00 27.71 265.29 22.11 934.71 TOTAL Personal Services 89,950.00 41262.62 20,522.97 22.82 69,427.03 Supplies 101-4-5220-4219 Operating Supplies 38,000.00 11469.00 41117.68 10.84 33,882.32 TOTAL Supplies 38,000.00 11469.00 41117.68 10.84 33,882.32 Other Services & Charges 101-4-5220-4409 Contractual Services 62,350.00 11680.00 61899.34 11.07 55,450.66 101-4-5220-4412 Building Rent 11600.00 0.00 828.75 51.80 771.25 101-4-5220-4438 Credit Card Fees 41600.00 532.69 11296.23 28.18 31303.77 TOTAL Other Services & Charges 68,550.00 21212.69 91024.32 13.16 59,525.68 TOTAL Recreation Programs 196,500.00 71944.31 33,664.97 17.13 162,835.03 Concessions Personal Services Supplies Other Services & Charges Sr Citizen Programs ------------------- ------------------- 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Culture & Recreation 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5510-4101 Regular Pay 97,100.00 71276.80 36,020.16 37.10 61,079.84 101-4-5510-4104 PERA 71050.00 263.78 21632.14 37.34 41417.86 101-4-5510-4105 FICA 61000.00 220.76 21207.57 36.79 31792.43 101-4-5510-4107 Medicare 11400.00 51.63 516.29 36.88 883.71 101-4-5510-4108 Insurance 18,600.00 11233.02 61165.10 33.15 12,434.90 101-4-5510-4109 Workers Comp 600.00 0.00 285.50 47.58 314.50 TOTAL Personal Services 130,750.00 91045.99 47,826.76 36.58 82,923.24 Supplies 101-4-5510-4219 Operating Supplies 14,900.00 11758.94 51874.73 39.43 91025.27 TOTAL Supplies 14,900.00 11758.94 51874.73 39.43 91025.27 Other Services & Charges 101-4-5510-4321 Telephone 21600.00 160.22 802.05 30.85 11797.95 101-4-5510-4322 Postage 21550.00 600.00 11338.48 52.49 11211.52 101-4-5510-4331 Travel, Conferences & Schools 11800.00 57.06 126.27 7.02 11673.73 101-4-5510-4361 Insurance 11500.00 0.00 11026.50 68.43 473.50 101-4-5510-4389 Utilities 10,050.00 995.14 41073.72 40.53 5,976.28 101-4-5510-4401 Bldg Repair/Maint Services 12,950.00 570.60 61265.91 48.39 6,684.09 101-4-5510-4404 Equip Repair/Maint Services 21300.00 241.97 11071.75 46.60 11228.25 101-4-5510-4409 Contractual Services 71700.00 796.55 21853.87 37.06 4,846.13 101-4-5510-4433 Dues & Subscriptions 950.00 79.30 308.60 32.48 641.40 TOTAL Other Services & Charges 42,400.00 31500.84 17,867.15 42.14 24,532.85 Capital Outlay TOTAL Sr Citizen Programs 188,050.00 14,305.77 71,568.64 38.06 116,481.36 TOTAL Culture & Recreation 11714,100.00 118,830.81 572,567.34 33.40 11141,532.66 Economic Development -------------------- -------------------- Personal Services 101-4-6210-4101 Regular Pay 0.00 91991.16 17,868.20 0.00 ( 17,868.20) 101-4-6210-4103 Part-time Pay 0.00 11050.00 31225.00 0.00 ( 3,225.00) 101-4-6210-4104 PERA 0.00 362.18 948.27 0.00 ( 948.27) 101-4-6210-4105 FICA 0.00 273.11 851.53 0.00 ( 851.53) 101-4-6210-4107 Medicare 0.00 63.88 199.18 0.00 ( 199.18) 101-4-6210-4108 Insurance 0.00 11700.02 2,692.03 0.00 ( 2,692.03) TOTAL Personal Services 0.00 13,440.35 25,784.21 0.00 ( 25,784.21) 6-11-2013 04:14 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 101-GENERAL FUND Economic Development 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 25.21) 183.48 0.00 ( 183.48) TOTAL Other Services & Charges 0.00 ( 25.21) 183.48 0.00 ( 183.48) TOTAL Economic Development 0.00 13,415.14 25,967.69 0.00 ( 25,967.69) Energy City Personal Services 101-4-6220-4101 Regular Pay 16,700.00 965.12 41824.65 28.89 11,875.35 101-4-6220-4104 PERA 11200.00 34.99 349.14 29.10 850.86 101-4-6220-4105 FICA 11050.00 28.81 287.86 27.42 762.14 101-4-6220-4107 Medicare 250.00 6.74 67.34 26.94 182.66 101-4-6220-4108 Insurance 21750.00 45.01 225.05 8.18 21524.95 TOTAL Personal Services 21,950.00 11080.67 51754.04 26.21 16,195.96 Supplies 101-4-6220-4219 Operating Supplies 51000.00 4.14 430.83 8.62 41569.17 TOTAL Supplies 51000.00 4.14 430.83 8.62 41569.17 Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 31000.00 250.00 269.98 9.00 21730.02 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 11500.00 TOTAL Other Services & Charges 41500.00 250.00 269.98 6.00 41230.02 TOTAL Energy City 31,450.00 11334.81 61454.85 20.52 24,995.15 TOTAL Economic Development 31,450.00 14,749.95 32,422.54 103.09 ( 972.54) Transfers Out Transfers Out 101-4-7000-4724 Transfer - Pinewood 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 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 827,310.66 4,538,156.71 35.35 81298,793.29 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES ( 200,000.00) ( 582,929.75) ( 3,560,626.81) 3,360,626.81 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 722,550.00 21,881.34 233,759.84 32.35 488,790.16 Hockey 36,000.00 0.00 53,006.00 147.24 ( 17,006.00) Skating 64,500.00 51102.00 14,877.00 23.07 49,623.00 Concessions 78,000.00 31829.97 35,524.87 45.54 42,475.13 TOTAL REVENUES 901,050.00 30,813.31 337,167.71 37.42 563,882.29 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- EXPENDITURE SUMMARY Culture & Recreation Ice Arena 888,150.00 44,562.71 200,505.60 22.58 687,644.40 Hockey 19,300.00 9.15 10,370.83 53.73 81929.17 Skating 32,550.00 31300.97 10,392.93 31.93 22,157.07 Arena Concessions 50,000.00 21830.37 20,741.40 41.48 29,258.60 TOTAL Culture & Recreation 990,000.00 50,703.20 242,010.76 24.45 747,989.24 TOTAL EXPENDITURES 990,000.00 50,703.20 242,010.76 24.45 747,989.24 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES ( 88,950.00) ( 19,889.89) 95,156.95 ( 184,106.95) 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 493,000.00 19,208.94 198,291.24 40.22 294,708.76 221-3-0000-3465 Admissions 25,500.00 0.00 91582.00 37.58 15,918.00 221-3-0000-3466 Dry Floor Events 19,500.00 11741.99 11,560.47 59.28 71939.53 221-3-0000-3468 Skate Sharpening 41300.00 44.00 21200.00 51.16 21100.00 221-3-0000-3475 Building Rent 21600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 18,000.00 206.67 21293.35 12.74 15,706.65 TOTAL Charges for Services 562,900.00 21,201.60 223,927.06 39.78 338,972.94 Other Revenue 221-3-0000-3621 Interest Income 0.00 0.00 551.38 0.00 ( 551.38) 221-3-0000-3622 Vending Machines 11,800.00 343.89 41642.73 39.35 71157.27 221-3-0000-3626 Contributions 71300.00 0.00 31219.00 44.10 41081.00 221-3-0000-3629 Miscellaneous Revenue 21800.00 321.85 11262.17 45.08 11537.83 TOTAL Other Revenue 21,900.00 665.74 91675.28 44.18 12,224.72 Sales 221-3-0000-3791 ATM Revenue 250.00 14.00 157.50 63.00 92.50 TOTAL Sales 250.00 14.00 157.50 63.00 92.50 Transfers In 221-3-0000-3921 Transfers 137,500.00 0.00 0.00 0.00 137,500.00 TOTAL Transfers In 137,500.00 0.00 0.00 0.00 137,500.00 TOTAL Ice Arena 722,550.00 21,881.34 233,759.84 32.35 488,790.16 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 36,000.00 0.00 53,006.00 147.24 ( 17,006.00) TOTAL Charges for Services 36,000.00 0.00 53,006.00 147.24 ( 17,006.00) Other Revenue TOTAL Hockey 36,000.00 0.00 53,006.00 147.24 ( 17,006.00) Skating 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Charges for Services 221-3-5420-3461 Recreation Fees 60,700.00 384.00 81119.00 13.38 52,581.00 221-3-5420-3465 Admissions 31800.00 41043.00 41043.00 106.39 ( 243.00) TOTAL Charges for Services 64,500.00 41427.00 12,162.00 18.86 52,338.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 675.00 21715.00 0.00 ( 21715.00) TOTAL Other Revenue 0.00 675.00 21715.00 0.00 ( 21715.00) TOTAL Skating 64,500.00 51102.00 14,877.00 23.07 49,623.00 Concessions Charges for Services 221-3-5430-3467 Concessions 78,000.00 31829.97 35,524.87 45.54 42,475.13 TOTAL Charges for Services 78,000.00 31829.97 35,524.87 45.54 42,475.13 TOTAL Concessions 78,000.00 31829.97 35,524.87 45.54 42,475.13 TOTAL REVENUE 901,050.00 30,813.31 337,167.71 37.42 563,882.29 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 162,700.00 12,420.76 61,636.39 37.88 101,063.61 221-4-5400-4103 Part-time Pay 60,550.00 41664.25 26,979.71 44.56 33,570.29 221-4-5400-4104 PERA 15,450.00 566.66 51555.47 35.96 91894.53 221-4-5400-4105 FICA 13,900.00 511.55 51384.36 38.74 81515.64 221-4-5400-4107 Medicare 31300.00 119.62 11259.22 38.16 21040.78 221-4-5400-4108 Insurance 24,550.00 11941.03 91705.15 39.53 14,844.85 221-4-5400-4109 Workers Comp 71050.00 0.00 ( 454.00) 6.44- 71504.00 221-4-5400-4110 Re-employment Compensation 0.00 988.41 11309.20 0.00 ( 11309.20) TOTAL Personal Services 287,500.00 21,212.28 111,375.50 38.74 176,124.50 Supplies 221-4-5400-4212 Fuels & Lubs 11100.00 45.09 93.26 8.48 11006.74 221-4-5400-4217 Uniform Allowance 900.00 0.00 22.25 2.47 877.75 221-4-5400-4219 Operating Supplies 39,050.00 21033.38 71281.87 18.65 31,768.13 221-4-5400-4255 Soft Drinks/Misc 71000.00 172.56 11806.37 25.81 5,193.63 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00 TOTAL Supplies 48,950.00 21251.03 91203.75 18.80 39,746.25 Other Services & Charges 221-4-5400-4319 Other Professional Services 0.00 35.41 35.41 0.00 ( 35.41) 221-4-5400-4321 Telephone 31250.00 210.39 656.18 20.19 21593.82 221-4-5400-4322 Postage 400.00 0.00 15.73 3.93 384.27 221-4-5400-4331 Travel, Conferences & Schools 11500.00 60.00 222.16 14.81 11277.84 221-4-5400-4359 Publishing 31200.00 11447.82 21269.02 70.91 930.98 221-4-5400-4361 Insurance 71100.00 0.00 41059.00 57.17 31041.00 221-4-5400-4389 Utilities 149,050.00 11,152.02 50,150.50 33.65 98,899.50 221-4-5400-4401 Bldg Repair/Maint Services 24,900.00 81047.66 21,531.01 86.47 3,368.99 221-4-5400-4409 Contractual Services 11800.00 0.00 31.32 1.74 1,768.68 221-4-5400-4415 Equipment Rental 21700.00 146.10 726.02 26.89 11973.98 221-4-5400-4433 Dues & Subscriptions 500.00 0.00 230.00 46.00 270.00 TOTAL Other Services & Charges 194,400.00 21,099.40 79,926.35 41.11 114,473.65 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 0.00 0.00 244,000.00 TOTAL Capital Outlay 357,300.00 0.00 0.00 0.00 357,300.00 Transfers Out TOTAL Ice Arena 888,150.00 44,562.71 200,505.60 22.58 687,644.40 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA Culture & Recreation 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % 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.00 50.00 TOTAL Personal Services 900.00 0.00 0.00 0.00 900.00 Supplies 221-4-5410-4219 Operating Supplies 91100.00 0.00 81960.40 98.47 139.60 TOTAL Supplies 91100.00 0.00 81960.40 98.47 139.60 Other Services & Charges 221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00 221-4-5410-4409 Contractual Services 61000.00 0.00 25.00 0.42 51975.00 221-4-5410-4438 Credit Card Fees 21800.00 9.15 11385.43 49.48 11414.57 TOTAL Other Services & Charges 91300.00 9.15 11410.43 15.17 71889.57 TOTAL Hockey 19,300.00 9.15 10,370.83 53.73 81929.17 Skating Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 21627.98 71889.46 44.32 91910.54 221-4-5420-4104 PERA 11000.00 4.10 61.57 6.16 938.43 221-4-5420-4105 FICA 1,100.00 19.55 385.67 35.06 714.33 221-4-5420-4107 Medicare 250.00 4.57 90.13 36.05 159.87 TOTAL Personal Services 20,150.00 21656.20 81426.83 41.82 11,723.17 Supplies 221-4-5420-4219 Operating Supplies 51300.00 476.00 476.00 8.98 41824.00 TOTAL Supplies 51300.00 476.00 476.00 8.98 41824.00 Other Services & Charges 221-4-5420-4359 Publishing 11000.00 0.00 0.00 0.00 11000.00 221-4-5420-4409 Contractual Services 31300.00 165.00 11219.85 36.97 21080.15 221-4-5420-4438 Credit Card Fees 21800.00 3.77 270.25 9.65 21529.75 TOTAL Other Services & Charges 71100.00 168.77 11490.10 20.99 51609.90 TOTAL Skating 32,550.00 31300.97 10,392.93 31.93 22,157.07 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 221-ICE ARENA Culture & Recreation 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions ----------------- ----------------- Personal Services 221-4-5430-4103 Part-time Pay 21,300.00 11005.66 71105.71 33.36 14,194.29 221-4-5430-4104 PERA 200.00 11.88 153.22 76.61 46.78 221-4-5430-4105 FICA 11300.00 37.62 503.49 38.73 796.51 221-4-5430-4107 Medicare 300.00 8.79 117.75 39.25 182.25 TOTAL Personal Services 23,100.00 11063.95 71880.17 34.11 15,219.83 Supplies 221-4-5430-4219 Operating Supplies 21150.00 96.73 316.32 14.71 11833.68 221-4-5430-4259 Other Merchandise For Resale 24,750.00 11669.69 12,544.91 50.69 12,205.09 TOTAL Supplies 26,900.00 11766.42 12,861.23 47.81 14,038.77 TOTAL Arena Concessions 50,000.00 21830.37 20,741.40 41.48 29,258.60 TOTAL Culture & Recreation 990,000.00 50,703.20 242,010.76 24.45 747,989.24 TOTAL EXPENDITURES 990,000.00 50,703.20 242,010.76 24.45 747,989.24 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES ( 88,950.00) ( 19,889.89) 95,156.95 ( 184,106.95) 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 233,300.00 26,108.53 46,446.55 19.91 186,853.45 TOTAL REVENUES 233,300.00 26,108.53 46,446.55 19.91 186,853.45 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- EXPENDITURE SUMMARY Culture & Recreation Golf Course 233,300.00 22,699.41 65,977.67 28.28 167,322.33 TOTAL Culture & Recreation 233,300.00 22,699.41 65,977.67 28.28 167,322.33 TOTAL EXPENDITURES 233,300.00 22,699.41 65,977.67 28.28 167,322.33 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES 0.00 31409.12 ( 19,531.12) 19,531.12 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 222-PINEWOOD GOLF COURSE 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course -------------------- -------------------- Charges for Services 222-3-0000-3461 Recreation Fees 17,000.00 41371.56 11,054.41 65.03 51945.59 222-3-0000-3467 Concessions 16,000.00 11600.33 11952.31 12.20 14,047.69 222-3-0000-3469 Other Sales 31500.00 728.51 857.81 24.51 2,642.19 222-3-0000-3476 Green Fees 110,000.00 10,622.60 12,978.98 11.80 97,021.02 222-3-0000-3477 Membership Fees 17,000.00 61483.30 16,739.96 98.47 260.04 222-3-0000-3478 Golf Cart Rental 20,000.00 21147.50 21708.35 13.54 17,291.65 222-3-0000-3479 Tournaments 51000.00 149.72 149.72 2.99 41850.28 TOTAL Charges for Services 188,500.00 26,103.52 46,441.54 24.64 142,058.46 Other Revenue 222-3-0000-3629 Miscellaneous Revenue 0.00 4.50 4.50 0.00 ( 4.50) TOTAL Other Revenue 0.00 4.50 4.50 0.00 ( 4.50) Sales 222-3-0000-3792 Cash Over 0.00 0.51 0.51 0.00 ( 0.51) TOTAL Sales 0.00 0.51 0.51 0.00 ( 0.51) Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund 44,800.00 0.00 0.00 0.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 26,108.53 46,446.55 19.91 186,853.45 TOTAL REVENUE 233,300.00 26,108.53 46,446.55 19.91 186,853.45 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- 6-11-2013 04:15 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2013 222-PINEWOOD GOLF COURSE 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 90,100.00 51095.38 25,212.78 27.98 64,887.22 222-4-5300-4103 Part-time Pay 29,900.00 41809.99 71915.89 26.47 21,984.11 222-4-5300-4104 PERA 81700.00 293.70 21176.61 25.02 6,523.39 222-4-5300-4105 FICA 71450.00 260.73 11849.50 24.83 5,600.50 222-4-5300-4107 Medicare 11750.00 60.97 432.51 24.71 11317.49 222-4-5300-4108 Insurance 61250.00 484.01 21420.05 38.72 31829.95 222-4-5300-4109 Workers Comp 11700.00 0.00 828.50 48.74 871.50 222-4-5300-4110 Re-employment Compensation 0.00 1,682.00 3,515.60 0.00 ( 31515.60) TOTAL Personal Services 145,850.00 12,686.78 44,351.44 30.41 101,498.56 Supplies 222-4-5300-4212 Fuels & Lubs 51000.00 11780.46 11790.18 35.80 31209.82 222-4-5300-4217 Uniform Allowance 600.00 0.00 198.34 33.06 401.66 222-4-5300-4219 Operating Supplies 28,150.00 41018.94 41855.88 17.25 23,294.12 222-4-5300-4259 Other Merchandise For Resale 9,500.00 2,368.63 4,601.55 48.44 41898.45 TOTAL Supplies 43,250.00 81168.03 11,445.95 26.46 31,804.05 Other Services & Charges 222-4-5300-4321 Telephone 21400.00 270.76 645.36 26.89 11754.64 222-4-5300-4331 Travel, Conferences & Schools 250.00 17.71 147.81 59.12 102.19 222-4-5300-4349 Advertising/Marketing 51000.00 324.00 487.20 9.74 41512.80 222-4-5300-4361 Insurance 10,700.00 0.00 51431.50 50.76 5,268.50 222-4-5300-4389 Utilities 61600.00 357.99 925.45 14.02 5,674.55 222-4-5300-4401 Bldg Repair/Maint Services 81000.00 87.54 147.66 1.85 71852.34 222-4-5300-4404 Equip Repair/Maint Services 41000.00 0.00 794.20 19.86 31205.80 222-4-5300-4415 Equipment Rental 11350.00 14.55 14.55 1.08 11335.45 222-4-5300-4437 Taxes & Licenses 900.00 318.00 11048.18 116.46 ( 148.18) 222-4-5300-4438 Credit Card Fees 5,000.00 454.05 538.37 10.77 41461.63 TOTAL Other Services & Charges 44,200.00 11844.60 10,180.28 23.03 34,019.72 Capital Outlay Debt Service TOTAL Golf Course 233,300.00 22,699.41 65,977.67 28.28 167,322.33 TOTAL Culture & Recreation 233,300.00 22,699.41 65,977.67 28.28 167,322.33 TOTAL EXPENDITURES 233,300.00 22,699.41 65,977.67 28.28 167,322.33 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REVENUES OVER/(UNDER) EXPENDITURES 0.00 31409.12 ( 19,531.12) 19,531.12 CITY OF ELK RIVER ENTERPRISE FUNDS- BUDGET TO ACTUAL MONTH ENDED MAY,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 $ 2,487,827 $ 4,012,173 38.27% Cost of sales (4,695,750) (1,412,183) (3,283,567) 30.07% Gross profit 1,804,250 1,075,644 728,606 59.62% Operating revenues: User charges - - - 0.00% $ 1,602,200 $ 519,529 $ 1,082,671 32.43% $ 1,324,000 $ 409,540 $ 914,460 30.93% Delinquency collections - - - 0.00% 2,500 (9,401) 11,901 -376.04% 7,000 (13,978) 20,978 -199.69% Other 400 1,379 2,621 34.48% 287,750 2,067 285,683 0.72% 2,000 1,134 866 56.70% Total operating revenues 4,000 1,379 2,621 34.48% 1,892,450 512,195 1,380,255 27.07% 1,333,000 396,696 936,304 29.76% Operating expenses: Personal services 611,850 233,314 378,536 38.13% 499,150 187,739 311,411 37.61% 49,250 9,590 39,660 19.47% Supplies 29,600 3,393 26,207 11.46% 262,300 32,681 229,619 12.46% 10,200 1,104 9,096 10.82% Other service charges 222,900 63,924 158,976 28.68% 687,250 149,363 537,887 21.73% 1,297,400 390,241 907,159 30.08% Depreciation* 123,150 - 123,150 0.00% 993,600 - 993,600 0.00% - - - 0.00% Total operating expenses 987,500 300,631 686,869 30.44% 2,442,300 369,783 2,072,517 15.14% 1,356,850 400,935 955,915 29.55% Operating income(loss) 8209750 7769392 44,358 94.60% (549,850) 142,412 (692,262) -25.90% (23,850) (41239) (19,611) 17.77% Nonoperating revenues(expenses): Interest income 23,000 4,267 18,733 18.55% 72,250 12,551 59,699 17.37% 5,400 1,543 3,857 28.57% 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 4,267 18,733 18.55% 47,350 (1,365) 48,715 -2.88% 5,400 1,543 3,857 28.57% Income(loss)before contributions and transfers 843,750 780,659 63,091 92.52% (502,500) 141,047 (643,547) -28.07% (18,450) (2,696) (15,754) 14.61% Contributions-connection fees - - - 0.00% 231,700 90,915 140,785 39.24% - - - 0.00% Transfers in - - - 0.00% - - - 0.00% 25,000 - 25,000 0.00% Transfers out (717,500) - (717,500) 0.00% (115,000) (15,000) (100,000) 13.04% (25,000) - (25,000) 0.00% NET INCOME(LOSS) 1269250 780,659 (654,409) 618.34% (385,800) 216,962 (6029762) -56.24% (18,450) (2,696) (15,754) 14.61% Items reclassified to balance sheet at year end: Capital Outlay (15,000) (469) (14,531) 3.13% (611,500) - (611,500) 0.00% Bond Payment - - - 0.00% (175,000) (175,000) - 100.00% Revenues over/(under)expenditures 111,250 7809190 (668,940) (11172,300) 41,962 (11214,262) (18,450) (21696) (15,754) *Recorded at year end 6-11-2013 04:17 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: MAY 31ST, 2013 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 28,361.48 2,152.41 30,513.89 101-1010 Cash - General Fund 3,079,644.17 512,690.49) 2,566,953.68 211-1010 Cash - Library 440,182.13 3,456.31) 436,725.82 221-1010 Cash - Ice Arena 176,988.04 68,211.44 245,199.48 222-1010 Cash - Pinewood Golf Course 18,858.37) 3,633.74 15,224.63) 223-1010 Cash - Sr Citizen Account 8,366.25 1,570.66) 6,795.59 225-1010 Cash - Park Dedication 20,355.12 0.00 20,355.12 228-1010 Cash - Landfill 760,919.14 22,487.82) 738,431.32 231-1010 Cash - Landfill Const Debris 705,075.02 0.00 705,075.02 240-1010 Cash - Micro Loan Fund 848,223.16 59,893.68 908,116.84 241-1010 Cash - Federal DEED 708,349.00 0.00 708,349.00 242-1010 Cash - State DEED 403,048.33 0.00 403,048.33 245-1010 Cash - Development Fund 935,537.63 1,686.00) 933,851.63 290-1010 Cash - Capital Outlay Reserve 1,645,532.60 987.57) 1,644,545.03 291-1010 Cash - Insurance Reserve 374,095.38 10,876.77) 363,218.61 292-1010 Cash - Govt Bldgs Reserve 4,507,913.80 14,044.97) 4,493,868.83 294-1010 Cash - Drug Forfeiture 29,293.48 237.86 29,531.34 295-1010 Cash - Severance Pay Reserve 115,966.05 0.00 115,966.05 296-1010 Cash - GRE Reserve 1,614,247.78 1,214.00) 1,613,033.78 311-1010 Cash - 2003A GO Bonds 40,129.95) 0.00 40,129.95) 312-1010 Cash - 2005A GO Bonds 111,865.65 0.00 111,865.65 313-1010 Cash - 2007C GO Bonds 40,961.14 2,600.00 43,561.14 333-1010 Cash - 2010A GO Cap Imp Bonds 177,075.82 425.00) 176,650.82 344-1010 Cash - 2006C Cap Imp Bonds Lby 431.25) 0.00 431.25) 345-1010 Cash - 2012A CIP Bonds-PW 820.83 0.00 820.83 401-1010 Cash - Pavement Mgmt 3,002,173.19 50,464.97) 2,951,708.22 403-1010 Cash - Street Improvement 1,623,954.76 11,202.56) 1,612,752.2C 404-1010 Cash - Surface Water Managemnt 188,255.59 1,398.43) 186,857.16 406-1010 Cash - City Wide Trunk Util 4,531,197.25 1,646.10 4,532,843.35 410-1010 Cash - Equipment Replacement 962,213.78 8,882.04) 953,331.74 426-1010 Cash - YMCA 872,847.57 0.00 872,847.57 440-1010 Cash - Park Improvement 94,262.43 6,920.13) 87,342.3C 459-1010 Cash - TIF 419 Highway 169 367,967.33 0.00 367,967.33 602-1010 Cash - Wastewater Treatment 5,235,569.74 101,326.70 5,336,896.44 603-1010 Cash - Liquor 1,882,123.27 153,411.61 2,035,534.88 605-1010 Cash - Garbage 632,898.87 16,924.73) 615,974.14 801-1010 Cash - Interest 0.00 25,442.86 25,442.86 821-1010 Cash - Developer Escrow 60,367.4C 1,066.00 61,433.40 TOTAL CLAIM ON CASH 36,127,233.61 245,610.05) 35,881,623.56 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 41,959,908.63 412,133.47 42,372,042.1C 999-1001 PY BANK ACCOUNT (34,214,864.58) ( 657,743.52) (34,872,608.10) 999-1002 POOLED INVESTMENTS 28,382,189.56 O.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 36,127,233.61 245,610.05) 35,881,623.56