Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 05-16-2011
INFORMATION MEMORANDUM ..~--4 Elk River TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: May I6, 201 1 SUBJECT: Hail Damage Insurance Claim A number of City buildings have recently been visited by the League's claium adjuster, Mike Coulter. He indicated that a number of the park shelters and buildings have hail damage including River's Edge, Orono, YAC, Lions Park, and the roof at Pinewood Golf Course. In addition, a number of park signs had significant hail damage. Rodney Schreifels, Parks Maintenance Supervisor, will be putting together specifications and the advertisement for bid for the project over the next month. The results of the bid will come back to Council for approval sometime this summer. The $10,000 deductible will be funded out of the insurance reserve fund. C:\Users\jmiller\AppData\Local\Microsoft\Windows\Temporary Internet Files\Low\Content.IES\AQUMI4RP\insuranceclaimupdate[1].docx INFORMATION MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: May 16, 2011 SUBJECT: April 2011 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, Pinewood Golf Course and Ice Arena special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of March, actual revenues (except for property taxes and state aids) and expenditures should run slightly over 33% of the annual budget. It is natural fox some of the items to vary from month to month, such as exceeding budget fox 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 fox the variance. General Fund Kevenue,r • Excluding transfers, revenue collections are about 5% of budget; however, property taxes, our largest revenue source, will be received in July and December. • Licenses and permits are 56% of budget estimate due mainly to a few larger building- relatedpermits that have been issued. • Charges for services are slightly above budget estimates due to the collection of recreation fees and the semi-annual police and fire contracts. • Fines and forfeits are 33.5% of budget and right in line with the budget benchmark. • The negative interest income is related to the reversal of the prior year's interest receivable. • The transfers in will be recorded mid-year. E.xpenditure.r: • Excluding transfers, the total departmental expenditures are about 28% and almost all departments are well within or below budget. • The transfers out to the Ice Arena and Pinewood Golf are made at the end of the year. Ice Arena As of the end of April, revenues exceed expenditures by $138,639. Excluding transfers, revenues are slightly under 46% of budget estimates and expenditures are about 28% of budget. Ice rental, concessions and hockey program registrations make up 38% of the revenue collections Pinewood Golf The month of April marked the opening of the golf course operations. Year to date expenditures exceed revenues by $25,778. Excluding transfers, total revenue collections are 13% of budget and membership fees are at 78% of estimates. Expenditures are about 21 of budget, which includes the first of six monthly lease payments on the golf carts and liability insurance paid through June 30. 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND FINANCIAL SUMMF,RY 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BAL.~INCE REVENUE SUMP4ARY General Fund 12,163,450.00 171,137.28 730,952.60 6.01 11,932,497.40 TOTAL REVENUES 12,163,450.00 171,137.28 730;952.60 6.01 11,432,497.40 EXPENDITURE SUNLMARY General Government Mayor & Council 177,800.00 9,278.45 58,376.39 32.83 119,423.61 Cable TV 77,800.00 8,090.90 23,059.42 29.64 54,740.58 Administrative Services 473,650.00 49,386.50 143,454.01 30.29 330,195.99 Human Resources 150,750.00 16,478.95 48,940.54 32.46 101,809.46 Finance 454,700.00 51,073.03 139,019.58 30.57 315,680.42 Information Technology 266,600.00 31,911.78 86,023.37 32.27 180,576.63 Legal 290,000.00 15,360.50 59,363.95 24.73 180,636.05 Community Development 67,100.00 7,458.99 21,216.53 31.62 45,883.47 Planning 303,550.00 31,737.19 91,588.39 30.17 211,961.61 City Hall Maintenance 300,850.00 24,118.78 81,964.37 27.24 218,885.63 Contingency 75,000.00 0.00 0.00 0.00 75,000.00 TOTAL General Government 2,587,800.00 239,895.07 753,006.55 29.10 1,834,793.95 Public Safety Police Administration 563,800.00 46,190.95 201,079.66 35.67 362,720.39 Patrol 2,252,800.00 221,651.63 624,150.43 27.71 1,628,649.57 Investigations 752,450.00 71,045.38 200,822.79 26.69 551,627.21 Police Support Services 491,700.00 50,448.55 145,564.21 29.60 346,135.79 Police Reserves 22,900.00 2,832.33 7,750.18 33.84 15,149.82 Public safety building 205,000.00 19,141.25 59,186.12 28.87 145,813.88 Fire Administration 559,600.00 43,129.19 169,845.10 27.96 424,754.90 Fire Inspections 184,850.00 20,982.53 55,961.16 30.00 129,388.84 Emergency Management 107,400.00 15,295.02 18,177.05 16.92 89,222.95 Building Safety 465,200.00 50,544.57 145,641.00 31.31 319,559.00 Environmental 56,950.00 5,699.08 16,962.05 29.78 39,987.95 TOTAL Public Safety 5,692,650.00 546,955.48 1,639,639.75 28.80 4,053,010.25 Public Works Street Maintenance 1,524,450.00 105,743.99 273,535.20 17.94 1,250,914.80 Snow Removal 262,850.00 12,695.15 192,259.48 73.14 70,590.52 Equipment Services 245,950.00 23,656.70 63,555.75 25.84 182,394.25 Engineering 177,800.00 9,649.13 35,435.30 19.93 142,364.70 TOTAL Public Works 2,211,050.00 151,749.97 564,785.73 25.54 1,646,264.27 5-11-2011 09:14 AM ' 101-GENERAL FUND FINANCIAL SUMM.z1RY CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 790,350.00 71,627.39 214,757.73 27.17 575,592.27 550,300.00 55,851.32 148,115.33 26.92 402,184.61 192,500.00 4,925.70 25,435.82 13.21 167,064.18 14,100.00 81.74 115.06 0.82 13,984.94 204,450.00 19,528.02 59,961.46 29.33 144,488.54 1,751,700.00 152,014.17 498,385.40 25.60 1,303,319.60 0.00 7,565.92 33,980.01 0.00 ( 33,980.01) 51,650.00 5,836.60 9,456.57 18.31 .42,193.93 51,650.00 13,402.52 43,436.58 84.10 8,213.92 205,200.00 0.00 0.00 0.00 205,200.00 205,200.00 0.00 0.00 0.00 205,200.00 12,500,050.00 ------------- ------------- 1,104,012.21 ------------- ------------- 3,449,254.01 ------------- ------------- 27.59 ------- ------- 9,050,795.99 ------------- ------------- ( 336,600.00)( 932,879.93)( 2,718,301.41) 2,381,701.41 5-11-2011 09:14 AM CITY OF ELK RIVER - PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 3CTH, 2011 i01-GENERAL FUND REVENUES CURRENT CURRENT BUDGET PERIOD 33.33°s OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3119 MV Reduction 101-3-0000-3121 Gravel Tax TOTAL Taxes Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 Amusement License 101-3-0000-3213 Cigarette License 101-3-0000-3214 Apartment License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3236 Parking Permit 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Licenses & Permits Intergovernmental Rev 101-3-0000-3311 Federal Grant 101-3-0000-3324 PERA Aid 101-3-0000-3325 Police 2~ Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3327 State-Aid Street Maint 101-3-0000-3329 State Crime Prevention Grant 101-3-0000-3330 Other State Grants 101-3-0000-3341 County Reimb/Grant TOTAL Intergovernmental Rev 9,758,SOC.00 O.OC 0.00 ( 221,100.00) C.00 0.00 75,000.00 4,867.14 4,867.14 9,612,400.00 4,867.14 9,867.14 53,000.00 0.00 115.00 1,000.00 0.00 195.00 3,000.00 0.00 112.50 16,000.00 5,940.00 11,070.00 20,000.00 1,526.70 4,298.50 4,000.00 0.00 555.00 14,000.00 680.00 5,920.00 2,500.00 0.00 525.00 100,000.00 6,869.90 23,966.30 25,000.00 1,222.00 90,026.95 200.00 136.09 1,716.15 3,000.00 410.00 1,398.00 3,000.00 320.00 440.00 8,000.00 1,655.00 2,395.00 252,700.00 18,759.69 142,733.90 4,000.00 0.00 0.00 14,000.00 0.00 0.00 205,000.00 0.00 0.00 12,000.00 0.00 0.00 259,050.00 0.00 137,742.55 35,000.00 0.00 0.00 4,000.00 0.00 0.00 0.00 0.00 5,125.00 528,050.00 0.00 142,867.55 0.00 0.00 0.05 0.22 19.50 3.75 69.19 21.49 13.88 42.29 21.00 23.97 360.11 858.08 46.60 14.67 56.48 9,758,500.00 221,100.00) 70,132.86 9,607,532.86 52,885.00 805.00 2,887.50 4,930.00 15,701.50 3,445.00 8,080.00 1,975.00 76,033.70 65,026.95) 1,516.15) 1,602.00 2,560.00 5,605.00 109,966.60 0.00 4,000.00 0.00 14,000.00 o.oo zos,ooo.oo 0.00 12,000.00 54.22 116,307.45 0.00 35,000.00 0.00 4,000.00 0.00 ( 5,125.00) 27.06 385,182.45 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 1,910.00 4,190.00 27.93 10,810.00 101-3-0000-3413 Plan Check Fee 30,000.00 881.18 5,149.05 17.16 24,850.95 101-3-0000-3415 Special Assessment Search 600.00 40.00 360.00 60.00 240.00 101-3-0000-3417 Copies 1,500.00 106.03 1,016.17 67.74 483.83 101-3-0000-3418 Other General Govt Services 4,000.00 301.25 1,109.13 27.73 2,890.87 101-3-0000-3430 Lockout Fees 7,500.00 620.00 2,865.00 38.20 4,635.00 101-3-0000-3431 Police Services 2,000.00 80.25 316.00 15.80 1,684.00 101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101-3-0000-3439 Animal Impound Fee 3,000.00 225.00 575.00 19.17 2,425.00 101-3-0000-3936 Fire Contracts 194,000.00 0.00 84,902.72 43.76 109,097.28 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND REVENUES 33.330 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE a OF BUDGET ACTUAL BUDGET BALANCE 101-3-000C-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3452 Engineering Services Reimb 101-3-0000-3461 Recreation Fees 101-3-0000-3467 Concessions 101-3-0000-3472 Park Use Fee 101-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3489 .Contractor License Check TOTP.L Charges for Services Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines & Forfeits ial Assessments 4,000.00 0.00 0.00 0.00 4,000.00 30,000.00 5,906.71 7,806.71 26.02 22,193.29 99,100.00 2,776.76 6,592.08 6.65 92,507.92 123,000.00 15,365.63 71,804.03 58.38 51,195.97 14,100.00 103.50 103.50 0.73 13,996.50 18,000.00 1,206.14 2,526.96 14.04 15,473.04 6,200.00 2,131.08 3,751.67 60.51 2,498.33 13,200.00 650.00 1,700.00 12.88 11,500.00 2,500.00 65.00 260.00 10.90 2,240.00 400.00 15.00 85.00 21.25 315.00 643,100.00 32,383.53 232,613.02 36.17 410,486.98 120,000.00 12,358.56 30,889.16 25.74 89,110.84 10,000.00 1,240.00 12,665.50 126.66 ( 2,665.50) 130,000.00 13,598.56 93,554.66 33.50 86,445.34 Cther Revenue 101-3-0000-3621 Interest Income 120,000.00 0.00 ( 2,530.74) 2.11- 122,530.74 101-3-0000-3625 Refunds ~ Reimbursements 65,000.00 204.16 455.65 0.70 64,544.35 101-3-0000-3626 Contributions 23,700.00 160.00 3,098.00 12.86 20,652.00 101-3-0000-3629 Miscellaneous Revenue 9,000.00 ( 12.75) 2,711.97 67.80 1,288.03 TOTAL Other Revenue 212,700.00 351.41 3,684.88 1.73 209,015.12 Transfers In 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-3942 Transfer-WWTS 75,000.00 0.00 0.00 0.00 75,000.00 101-3-0000-3943 Transfer-Liquor 270,000.00 0.00 0.00 0.00 270,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 300,000.00 101,176.95 160,631.95 53.59 139,368.05 101-3-0000-3948 Transfer-EDA 25,000.00 0.00 0.00 0.00 25,000.00 101-3-0000-3949 Transfer-HRA 15,000.00 0.00 0.00 0.00 15,000.00 TOTAL Transfers In 784,500.00 101,176.95 160,631.95 20.48 623,868.05 TOTAL General Fund 12,163,450.00 171,137.28 730,952.60 6.01 11,432,497.40 TOTAL REVENUE 12,163,450.00 171,137.28 730,952.60 6.01 11,432,497.40 5-11-2011 09:14 AM ~ '_Ol-GENERAL FUND ~ DEPARTMENTAL EXPENDITURES Mayor & Council CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 33.33% OF YEAR COMP. CURRENT CURRENT YEP~I2 TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services i01-4-1110-4103 Part-time Pay 101-9-1110-4104 PERA 101-4-1110-4105 FICA 101-4-1110-4107 Medicare 101-4-1110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1110-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,366.48 13,465.92 34.98 25,034.08 1,900.00 100.41 401.64 21.14 1,498.36 2,400.00 120.89 483.56 20.15 1,916.44 550.00 98.81 195.24 35.50 359.76 50.00 0.00 93.25 186.50 ( 43.25) 43,400.00 3,636.59 14,639.61 33.73 28,760.39 3,400.00 382.06 392.73 11.55 3,007.27 3,400.00 382.06 392.73 11.55 3,007.27 11,050.00 200.00 3,595.39 32.54 7,454.61 900.00 0.00 144.31 36.08 255.69 2,600.00 53.80 357.84 13.76 2,242.16 17,700.00 0.00 3,028.55 17.11 14,671.45 74,800.00 0.00 32,271.50 43.14 42,528.50 16,000.00 0.00 0.00 0.00 16,000.00 8,450.00 6.00 3,946.46 96.70 4,503.54 131,000.00 259.80 43,344.05 33.09 87,655.95 TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay i01-4-1120-4103 Part-time Pay 101-4-1120-4104,PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 177,800.00 4,278.45 58,376.39 32.83 119,423.61 54,150.00 6,129.80 16,332.80 30.16 37,817.20 6,500.00 384.38 1,146.89 17.64 5,353.11 3,950.00 444.06 1,332.18 33.73 2,617.82 3,750.00 379.03 1,117.60 29.80 2,632.40 900.00 88.63 261.34 29.04 638.66 5,800.00 670.00 2,680.00 46.21 3,120.00 200.00 0.00 37.25 18.63 162.75 75,250.00 8,090.90 22,908.06 30.44 52,341.94 700.00 0.00 129.94 18.56 570.06 700.00 0.00 129.94 18.56 570.06 5-11-2011 09:19 AM 101-GENERAL FUND General Government DE~riRTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 PAGE: 6 33.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Cther Services & Charges 1C1-4-1120-4322 Postage 50.00 101-9-1120-4331 Travel, Conferences & Schocls 1,650.00 101-4-1120-4404 Equip Repair/Maint Services 150.00 TOTAL Other Services & Charges 1,850.00 Capital Outlay TOTAL Cable TV 77,800.00 8,090.90 23,059.42 29.69 54,740.58 Administrative Services Personal Servic es 101-4-1210-9101 Regular Pay 296,450.00 34,209.43 91,225.14 30.77 205,224.86 101-4-1210-4103 Part-time Pay 44,900.00 5,298.59 11,193.32 24.93 33,706.68 101-4-1210-4104 PERA 24,750.00 2,864.32 8,332.68 33.67 16,417.32 101-4-1210-4105 FICA 21,150.00 2,402.80 7,052.77 33.35 14,097.23 101-4-1210-9106 Other Retirement Contributions 4,800.00 400.00 1,600.00 33.33 3,200.00 101-4-1210-4107 Medicare 4,950.00 561.94 1,649.40 33.32 3,300.60 101-4-1210-4108 Insurance 28,500.00 2,100.02 8,400.08 29.97 20,099.92 101-4-1210-4109 Workers Comp 1,800.00 0.00 961.50 53.42 838.50 TOTAL Person al Services 427,300.00 47,837.10 130,414.89 30.52 296,885.11 Supplies 101-4-1210-4201 Office Supplies 9,500.00 171.10 1,115.91 11.75 8,384.09 TOTAL Suppli es 9,500.00 171.10 1,115.91 11.75 8,389.09 Other Services & Charges 101-4-1210-4319 Other Professional Services 5,500.00 0.00 5,328.00 96.87 172.00 101-4-1210-4321 Telephone 800.00 60.77 192.50 24.06 607.50 101-4-1210-4322 Postage 1,000.00 0.00 166.57 16.66 833.43 101-4-1210-4331 Travel, Conferences & Schools 5,300.00 149.66 549.66 10.37 4,750.34 101-4-1210-4361 Insurance 100.00 0.00 197.50. 147.50 ( 47.50) 101-4-1210-4404 Equip Repair/Maint Services 23,050.00 1,167.87 5,138.98 22.29 17,911.02 101-4-1210-4433 Dues & Subscriptions 1,100.00 0.00 400.00 36.36 7.00.00 TOTAL Other Services & Charges 36,850.00 1,378.30 11,923.21 32.36 24,926.79 Capital Outlay 0.00 C.00 0.00 50.00 n nl~ 71 ~'i 1 'Z /~ 1 G7Q CO 0.00 21.42 1.16 1,828.58 ' TOTAL Administrative Services 473,650.00 49,386.50 143,454.01 30.29 330,195.99 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 33.33a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Human Resources Personal Services 101-4-1220-4101 Regular Pay 101-9-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance i01-4-1220-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-9-1220-9319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-9-1220-4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay ' TOTAL Human Resources Elections Personal Services Supplies Other Services & Charges Capital Outlay 67,850.00 7,828.86 20,921.10 30.83 46,928.90 48,350.00 5,297.28 15,2?9.37 31.60 33,070.63 8,450.00 951.66 2,973.78 35.19 5,476.22 7,200.00 768.60 2,431.96 33.78 4,?68.04 1,700.00 179.74 568.72 33.45 1,131.28 5,800.00 1,234.01 3,440.02 59.31 2,359.98 600.00 0.00 319.00 53.17 281.00 139,950.00 16,260.15 45,933.95 32.82 94,016.05 3,200.00 0.00 1,973.68 61.68 1,226.32 3,200.00 0.00 1,973.68 61.68 1,226.32 3,000.00 159.80 264.80 8.83 2,735.20 350.00 0.00 286.30 81.80 63.70 2,350.00 0.00 211.06 8.98 2,138.94 900.00 0.00 0.00 0.00 900.00 1,000.00 59.00 270.75 27.08 729.25 7,600.00 218.80 1,032.91 13.59 6,567.09 150,750.00 16,478.95 48,940.54 32.46 101,809.46 ' Finance 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERP.L FUND General Government ' DEPARTMENTAL EXPENDITURES 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1310-4101 Regular Pay 101-4-131G-4104 PERA 101-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-4-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-9-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 287,800.00 33,209.05 88,557.97 30.77 199,242.53 20,850.00 2,907.65 7,222.95 34.64 13,627.05 17,850.00 1,977.11 5,848.21 32.76 12,001.79 4,200.00 462.37 1,367.67 32.56 2,832.33 25,850.00 2,100.01 8,400.04 32.50 17,449.96 1,500.00 0.00 797.50 53.17 702.50 358,050.00 40,156.19 112,193.84 31.33 245,856.16 3,850.00 0.00 324.91 8.44 3,525.09 3,850.00 0.00 324.91 8.44 3,525.09 18,300.00 10,020.00 13,500.00 73.77 4,800.00 53,500.00 0.00 0.00 0.00 53,500.00 800.00 57.99 183.52 22.94 616.48 3,600.00 0.00 504.93 14.03 3,095.07 2,500.00 66.78 461.10 18.44 2,038.90 1,300.00 0.00 0.00 0.00 1,300.00 11,300.00 772.07 11,116.28 98.37 183.72 1,500.00 0.00 735.00 49.00 765.00 92,800.00 10,916.84 26,500.83 28.56 66,299.17 TOTAL Finance Information Technology Personal Services 101-4-1350-9101 Regular Pay 101-4-1350-4103 Part-time Pay 101-4-1350-4104 PERA 101-9-1350-4105 FICA 101-4-1350-4107 Medicare 101-9-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1350-4219 Operating Supplies TOTAL Supplies 459,700.00 51,073.03 139,019.58 30.57 315,680.42 128,400.00 14,813.16 39,501.81 30.76 88,898.19 5,000.00 0.00 0.00 0.00 5,000.00 9,300.00 1,073.97 3,221.91 39.64 6,078.09 8,250.00 883.86 2,583.80 31.32 5,666.20 1,950.00 206.71 604.29 30.99 1,395.71 19,850.00 1,626.01 6,504.04 32.77 13,345.96 650.00 0.00 380.00 58.46 270.00 173,400.00 18,603.71 52,795.85 30.45 120,604.15 25,100.00 2,800.92 3,696.43 14.73 21,403.57 25,100.00 2,800.42 3,696.43 14.73 21,403.57 5-11-2011 09:14 AM 101-GENERAL FUND General Government DEPARTMEATTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 PAGE: 9 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALFNCE Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 60.00 0.75 7,940.00 101-4-1350-4321 Telephone 1,950.00 134.94 243.01 16.76 1,206.99 101-4-1350-4331 Travel, Conferences & Schools 8,000.00 28.56 ll5.89 1.45 7,884.11 10i-4-1350-4404 Equip Repair/Mairt Services 19,750.00 110.25 7,978.29 40.40 11,771.71 TOTAL Other Services & Charges 37,200.00 273.75 8,397.19 22.57 28,802.81 Capital Outlay 101-4-1350-4560 Equipment 30,900.00 10,233.90 21,133.90 68.39 9,766.10 TOTAL Capita l Outlay 30,900.00 10,233.90 21,133.90 68.39 9,766.10 TOTAL Information Technology Legal Personal Services Supplies Other Services & Charges i01-4-1400-4304 Legal Fees TOTAL Other Services & Charges 266,600.00 31,911.78 86,023.37 32.27 180,576.63 240,000.00 15,360.50 59,363.95 24.73 180,636.05 240,000.00 15,360.50 59,363.95 24.73 180,636.05 TOTAL Legal Community Development Personal Services 101-9-1500-4101 Regular Pay 101-4-1500-4104 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1500-4201 Office Supplies TOTAL Supplies 240,000.00 15,360.50 59,363.95 24.73 180,636.05 52,700.00 6,079.22 16,211.24 30.76 36,488.76 3,800.00 440.73 1,322.19 34.79 2,477.81 3,250.00 367.18 1,091.80 33.59 2,158.20 750.00 85.86 255.30 39.04 494.70 5,800.00 486.00 1,944.00 33.52 3,856.00 250.00 0.00 392.00 156.80 ( 142.00) 66,550.00 7,458.99 21,216.53 31.88 45,333.47 150.00 0.00 0.00 0.00 150.00 150.00 0.00 0.00 0.00 150.00 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: P.PRIL 30TH, 2011 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 33.33° OF YEAR COMP. .CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 10i-9-1500-4331 Travel, Conferences & Schools TOTAL Other Services & Charges 400.00 0.00 0.00 0.00 400.00 400.00 0.00 0.00 0.00 400.00 TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4109 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-9-1510-4108 Insurance 101-9-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs 101-4-1510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1510-4321 Telephone 101-4-1510-9322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance i01-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4440 Miscellaneous 101-4-1510-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Planning City Hall Maintenance 67,100.00 7,458.99 21,216.53 31.62 45,883.47 211,900.00 24,452.53 65,206.73 30.77 146,693.27 15,350.00 1,772.82 5,318.96 34.65 10,031.54 13,150.00 1,428.26 4,196.96 31.92 8,953.04 3,100.00 334.03 981.55 31.66 2,118.95 28,300.00 2,324.03 9,296.12 32.85 19,003.88 700.00 0.00 573.00 81.86 127.00 272,500.00 30,311.67 85,572.82 31.4C 186,927.18 4,750.00 7.60 1,165.76 24.54 3,584.24 1,850.00 166.97 459.72 24.58 1,395.28 0.00 0.00 175.00 0.00 ( 175.00) 6,600.00 174.57 1,795.48 27.20 4,804.52 1,150.00 51.58 177.50 15.43 972.50 3,200.00 0.00 469.60 14.68 2,730.40 3,000.00 20.00 891.00 28.03 2,159.00 8,000.00 697.50 960.00 12.00 7,040.00 400.00 0.00 207.00 51.75 193.00 6,900.00 415.21 1,080.35 15.66 5,819.65 1,000.00 0.00 80.00 8.00 920.00 0.00 0.00 138.00 0.00 ( 138.00) 800.00 66.66 266.64 33.33 533.36 24,450.00 1,250.95 4,220.09 17.26 20,229.91 303,550.00 31,737.19 91,588.39 30.17 211,961.61 5-11-2011 09:19 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENER~.L FUND General Government DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1600-9101 Regular Pay 101-4-1600-4102 Overtime Fay 101-4-1600-4103 Part-time Pay 101-4-1600-4104 PERA TO1-4-1600-9105 FICA 101-4-1600-4107 Medicare 101-4-1600-9108 Insurance 101-4-1600-4109 Wor'rers Comp TOTAL Personal Services Supplies 101-4-1600-9212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone i0i-4-1600-4331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4401 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services 101-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 104,350.00 11,697.83 31,164.67 29.87 73,185.33 z,soo.oo o.oo o.oo o.oo z,soo.oo 19,050.00 1,758.00 4,702.65 24.69 14,347.35 9,150.00 975.58 3,021.35 33.02 6,128.65 7,800.00 831.69 2,588.29 33.18 5,211.71 1,800.00 194.52 605.37 33.63 1,194.63 17,200.00 1,203.80 5,282.52 30.71 11,917.48 5,850.00 0.00 2,458.00 42.02 3,392.00 167,700.00 16,661.42 49,822.85 29.71 117,877.15 3,450.00 271.15 811.43 23.52 2,638.57 1,700.00 0.00 631.69 37.16 1,068.31 28,900.00 1,811.21 6,431.01 22.25 22,468.99 34,050.00 2,082.36 7,879.13 23.13 26,175.87 12,250.00 1,198.97 4,474.46 36.53 7,775.54 1,500.00 0.00 200.00 13.33 1,300.00 4,850.00 0.00 2,372.50 98.92 2,477.50 43,800.00 3,642.68 12,390.57 28.29 31,409.43 30,600.00 491.68 4,463.18 19.59 26,136.82 5,000.00 0.00 0.00 0.00 5,000.00 1,100.00 91.67 366.68 33.33 733.32 99,100.00 5,375.00 24,267.39 24.99 74,832.61 300,850.00 24,118.78 81,964.37 27.24 218,885.63 75,000.00 0.00 0.00 0.00 75,000.00 75,000.00 0.00 0.00 0.00 75,000.00 TOTAL Contingency 75,000.00 0.00 0.00 0.00 75,000.00 TOTAL General Government 2,587,800.00 239,895.07 753,006.55 29.10 1,834,793.45 5-11-2011 09:14 AM - CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND Public Safety ^ DEPARTMENTAL EXPENDITURES ^ Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PE RA 101-4-2110-4107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-4319 Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-4322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-4361 Insurance 101-4-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues ~ Subscriptions 101-4-2110-4937 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay CURRENT CURRENT BUDGET PERIOD 33.33a OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE 275,400.00 31,332.21 81,552.53 29.61 193,847.47 39,650.00 4,511.85 12,767.54 32.20 26,882.46 2,750.00 287.76 784.42 28.52 1,965.58 25,650.00 1,844.02 6,918.08 26.97 18,731.92 59,350.00 0.00 29,294.50 49.36 30,055.50 402,800.00 37,975.84 131,317.07 32.60 271,482.93 19,000.00 707.28 2,419.37 12.73 16,580.63 2,250.00 113.59 1,104.34 49.08 1,145.66 4,600.00 342.00 483.80 10.52 4,116.20 25,850.00 1,162.87 4,007.51 15.50 21,842.49 4,950.00 36.73 359.12 7.25 4,590.88 29,300.00 1,598.03 5,672.92 19.36 23,627.08 2,200.00 0.00 952.24 20.56 1,797.76 3,350.00 790.00 2,041.25 60.93 1,308.75 500.00 0.00 0.00 0.00 500.00 9,600.00 0.00 3,500.50 36.46 6,099.50 75,250.00 3,633.48 48,025.05 63.82 27,224.95 9,200.00 994.00 5,520.25 60.00 3,679.75 800.00 0.00 183.75 22.97 616.25 135,150.00 7,052.24 65,755.08 48.65 69,394.92 ' TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PERA 101-4-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services 563,800.00 96,190.95 201,079.66 35.67 362,720.34 1,444,350.00 151,680.35 410,491.77 28.42 1,033,858.23 90,000.00 5,608.06 11,183.69 12.43 78,816.31 220,950.00 22,649.39 68,202.61 30.87 152,797.39 19,950.00 1,882.73 5,606.09 28.10 14,343.91 171,450.00 13,952.28 54,747.90 31.93 116,702.60 1,946,700.00 195,772.81 550,231.56 28.26 1,396,468.44 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 1G1-GENERAL FUND Public Safety 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 108,500.00 9,774.77 27,025.63 24.91 81,474.37 101-4-2120-4217 Uniform Allowance 23,900.00 771.81 2,530.47 10.59 21,369.53 101-4-2120-9219 Operating Supplies 58,650.00 5,136.92 15,590.30 26.58 43,059.70 101-4-2120-4221 Equipment Parts 28,000.00 941.99 2,489.38 8.89 25,510.62 TOTAL Suppli es 219,050.00 16,625.49 47,635.78 21.75 171,414.22 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 15,650.00 3,253.00 5,438.98 34.75 10,211.02 101-4-2120-4409 Equip Repair/Maint Services 26,700.00 2,321.16 5,787.43 21.68 20,912.57 101-4-2120-4433 Dues & Subscriptions 550.00 0.00 340.00 61.82 210.00 101-4-2120-4460 Equip Replacement Charge 44,150.00 3,679.17 14,716.68 33.33 29,433.32 TOTAL Other Services & Charges 87,050.00 9,253.33 26,283.09 30.19 60,766.91 Capital Outlay TOTAL Patrol Investigations Personal Services 101-9-2130-4101 Regular Pay 101-9-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies 2,252,800.00 221,651.63 624,150.93 27.71 1,628,649.57 505,600.00 51,839.20 138,659.21 27.42 366,940.79 45,000.00 1,911.80 9,127.75 9.17 40,872.25 79,300.00 7,740.10 23,240.81 29.31 56,059.19 5,850.00 579.93 1,708.81 29.21 4,141.19 70,100.00 5,041.63 22,414.98 31.98 47,685.02 705,850.00 67,112.66 190,151.56 26.94 515,698.44 5,150.00 784.97 1,378.09 26.76 3,771.91 8,700.00 513.96 1,331.46 15.30 7,368.59 13,850.00 1,298.93 2,709.55 19.56 11,140.45 Other Services & Charges 101-4-2130-4319 Other Professional Services 11,900.00 256.29 986.68 8.29 10,913.32 101-4-2130-4331 Travel, Conferences & Schools 5,550.00 1,190.00 2,075.00 37.39 3,475.00 101-4-2130-4433 Dues & Subscriptions 1,050.00 0.00 150.00 14.29 900.00 101-4-2130-4460 Equip Replacement Charge 14,250.00 1,187.50 4,750.00 33.33 9,500.00 TOTAL Other Services & Charges 32,750.00 2,633.79 7,961.68 24.31 29,788.32 Capital Outlay TOTAL Investigations 752,450.00 71,045.38 200,822.79 26.69 551,627.21 5-11-2011 09:19 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Police SupportServices Personal Services 101-4-2150-4101 Regular Pay i01-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA i01-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-9217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-9331 Travel, Conferences & Schools 101-4-2150-9404 Equip Repair/Maint Services 101-4-2150-4409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Police Support Services Police Reserves -------------- Personal Services 101-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA 101-4-2160-4107 Medicare 101-4-2160-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2160-9217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies 33.33s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 347,050.00 39,727.22 106,042.89 30.56 241,007.11 3,500.00 0.00 0.00 0.00 3,500.00 25,900.00 2,880.24 8,841.72 34.81 16,558.28 21,750.00 2,935.80 7,280.08 33.47 14,469.92 5,100.00 569.65 1,721.27 33.75 3,378.73 46,350.00 3,720.03 15,147.04 32.68 31,202.96 949,150.00 49,332.99 139,033.00 30.95 310,117.00 1,000.00 193.06 453.77 45.38 546.23 3,000.00 0.00 16.03 0.53 2,983.97 10,100.00 0.00 1,479.51 14.65 8,620.49 14,100.00 193.06 1,949.31 13.82 12,150.69 3,550.00 0.00 125.00 3.52 3,425.00 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 376.72 2,040.25 12.75 13,959.75 500.00 0.00 233.33 46.67 266.67 6,550.00 545.83 2,183.32 33.33 4,366.68 28,450.00 922.55 4,581.90 16.11 23,868.10 991,700.00 50,498.55 195,564.21 29.60 346,135.79 5,500.00 2,623.28 5,376.72 97.76 123.28 350.00 162.65 386.33 110.38 ( 36.33) 100.00 38.09 90.36 90.36 9.64 0.00 0.00 1,026.00 0.00 ( 1,026.00) 5,950.00 2,823.97 6,879.41 115.62 ( 929.91) 5,000.00 0.00 0.00 0.00 5,000.00 6,000.00 8.36 185.77 3.10 5,814.23 11,000.00 8.36 185.77 1.69 10,814.23 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERP.L FUND Public Safety ' DEPARTMENTAL EXPENDITURES 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges i01-4-2160-4319 Other Professional Services 101-4-2160-4321 Telephone 101-4-2160-4331 Travel, Conferences & Schools 101-4-2160-4359 Publishing 101-4-2160-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 1,SOG.00 0.00 x,600.00 0.00 1,700.00 0.00 150.00 0.00 1,000.00 0.00 5,950.00 0.00 0.00 C.00 1,500.00 0.00 0.00 1,600.00 100.00 5.88 1,600.00 0.00 0.00 150.00 585.00 58.SC 415.00 685.00 11.51 5,265.00 TOTAL Police Reserves Public safety building Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-4107 Medicare 101-4-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2190-4361 Insurance 101-9-2190-4389 Utilities 101-4-2190-9401 Bldg Repair/Maint Services TOTAL Other Services & Charges Capital Outlay TOTAL Public safety building Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-9105 FICA 101-4-2310-4106 Other Retirement Contributions 22,900.00 2,832.33 7,750.18 33.84 15,149.82 101,850.00 11,119.26 29,400.24 28.87 72,449.76 7,400.00 806.12 2,373.81 32.08 5,026.19 6,300.00 670.22 1,979.97 31.35 4,325.03 1,500.00 156.74 461.89 30.79 1,038.11 13,300.00 1,082.61 4,201.89 31.59 9,098.11 3,400.00 0.00 1,837.50 54.04 1,562.50 133,750.00 13,834.95 40,250.30 30.09 93,999.70 15,000.00 1,697.45 4,510.01 30.07 10,489.99 15,000.00 1,697.45 4,510.01 30.07 10,489.99 6,750.00 0.00 2,570.00 38.07 4,180.00 18,200.00 2,743.03 9,303.70 51.12 8,896.30 31,300.00 865.82 2,552.11 8.15 28,747.89 56,250.00 3,608.85 14,425.81 25.65 41,829.19 205,000.00 19,141.25 59,186.12 28.87 145,813.88 86,200.00 10,169.05 27,329.32 31.70 58,870.68 186,250.00 16,937.87 53,374.75 28.66 132,875.25 13,500.00 1,591.22 9,745.22 35.15 8,754.78 12,500.00 1,076.43 3,592.12 28.74 8,907.88 38,500.00 0.00 0.00 0.00 38,500.00 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND Public Safety 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2310-4107 Medicare 3,950.00 367.97 1,188.81 30.10 2,761.19 101-4-2310-4108 Insurance 7,200.00 1,114.79 4,039.45 56.10 3,160.55 101-4-2310-4109 Workers Comp 20,200.00 0.00 10,039.00 49.70 10,161.00 TOTAL Personal Services 368,300.00 31,257.33 104,308.67 28.32 263,991.33 Supplies 101-4-2310-9201 Office Supplies 5,150.00 95.58 328.80 6.38 4,821.20 101-4-2310-4212 Fuels & Lubs 7,350.00 853.70 1,745.94 23.75 5,609.06 101-4-2310-4217 Uniform Allowance 4,400.00 352.13 378.12 8.59 4,021.88 101-4-2310-9219 Operating Supplies 26,150.00 2,626.26 5,661.83 21.65 20,488.17 101-4-2310-4221 Equipment Parts 7,400.00 758.65 1,717.33 23.21 5,682.67 TOTAL Supplies 50,450.00 4,686.32 9,832.02 19.49 40,617.98 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,100.00 450.00 2,320.00 45.49 2,780.00 101-4-2310-4321 Telephone 4,950.00 152.84 593.65 11.99 4,356.35 .101-4-2310-4322 Postage 500.00 0.00 83.64 16.73 416.36 101-4-2310-9331 Travel, Conferences & Schools 27,450.00 ( 28.70) 1,436.33 5.23 26,013.67 101-4-2310-9359 Publishing 300.00 0.00 0.00 0.00 300.00 101-4-2310-4361 Insurance 17,500.00 0.00 7,967.50 42.67 10,032.50 101-4-2310-4389 Utilities 15,150.00 1,826.87 6,005.85 39.64 9,149.15 101-4-2310-4401 Bldg Repair/Maint Services 5,650.00 0.00 160.32 2.84 5,489.68 101-4-2310-4404 Equip Repair/Maint Services 31,550.00 1,857.70 10,683.85 33.86 20,866.15 101-4-2310-4933 Dues & Subscriptions 1,950.00 456.00 1,351.00 69.28 599.00 101-9-2310-4460 Equip Replacement Charge 29,650.00 2,470.83 9,883.32 33.33 19,766.68 TOTAL Other Services & Charges 139,750.00 7,185.54 39,985.46 28.61 99,764.54 Capital Outlay 101-4-2310-4560 Equipment TOTAL Capital Outlay 31,100.00 0.00 10,718.95 34.47 20,381.05 31,100.00 0.00 10,718.95 34.47 20,381.05 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-9104 PERA 101-4-2320-9105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services 589,600.00 43,129.19 164,845.10 27.96 424,754.90 .129,900.00 15,274.62 40,124.82 31.01 89,275.18 19,850.00 1,738.83 5,163.63 39.77 9,686.37 3,250.00 411.07 1,258.29 38.72 1,991.71 1,900.00 220.52 663.75 34.93 1,236.25 14,850.00 1,195.86 4,783.44 32.21 10,066.56 164,250.00 18,840.90 51,993.93 31.66 112,256.07 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4331 Travel, Conferences & Schools i01-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 2,750.00 919.18 419.18 15.24 2,330.82 3,200.00 608.86 1,369.77 42.65 1,835.23 1,400.00 0.00 0.00 .0.00 1,400.00 4,450.00 0.00 0.00 0.00 4,450.00 11,800.00 1,028.04 1,783.95 15.12 10,016.05 2,950.00 131.09 940.78 14.94 2,509.22 2,500.00 0.00 260.00 10.40 2,240.00 2,000.00 0.00 0.00 0.00 2,000.00 1,350.00 982.50 982.50 72.78 367.50 8,800.00 1,113.59 1,683.28 19.13 7,116.72 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-9101 Regular Pay 101-4-2330-4104 PERA 101-9-2330-9107 Medicare 101-9-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-9331 Travel, Conferences & Schools 101-4-2330-9389 Utilities 101-4-2330-4404 Equip Repair/Maint Services 101-4-2330-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay TOTAL Emergency Management 184,850.00 20,982.53 55,461.16 30.00 129,388.84 8,900.00 1,002.06 2,672.16 30.02 6,227.84 1,300.00 144.30 432.90 33.30 867.10 150.00 14.55 43.65 29.10 106.35 600.00 39.84 159.36 26.56 940.64 10,950.00 1,200.75 3,308.07 30.21 7,641.93 500.00 57.94 57.94 11.59 442.06 9,150.00 738.52 738.52 8.07 8,411.48 9,650.00 796.46 796.96 8.25 8,853.54 1,650.00 26.00 101.43 6.15 1,548.57 9,000.00 0.00 40.80 1.02 3,959.20 1,500.00 100.19 311.29 20.75 1,188.71 7,800.00 ( 74.81) 272.57 3.49 7,527.43 100.00 0.00 100.00 100.00 0.00 15,050.00 51.38 826.09 5.49 14,223.91 71,750.00 13,246.43 13,296.43 18.46 58,503.57 71,750.00 13,246.43 13,246.43 18.46 58,503.57 107,400.00 15,295.02 18,177.05 16.92 89,222.95 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4103 Part-time Pay 101-4-2410-4104 PERA 101-4-2410-4105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2410-4201 Office Supplies 1G1-4-2910-4212 Fuels & Lubs 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2410-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools i01-4-2910-4361 Insurance 101-4-2910-9404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 319,900.00 36,852.21 98,300.65 30.78 221,099.35 25,950.00 2,957.38 7,921.77 30.53 18,028.23 25,050.00 2,886.23 8,665.39 34.59 16,384.61 21,400.00 2,356.11 6,961.90 32.53 14,438.10 5,000.00 551.02 1,628.18 32.56 3,371.82 90,150.00 3,286.02 13,144.08 32.74 27,005.92 1,200.00 0.00 741.50 61.79 458.50 438,150.00 98,888.97 137,363.47 31.35 300,786.53 2,500.00 0.00 302.13 12.09 2,197.87 4,700.00 335.56 937.74 19.95 3,762.26 2,250.00 54.85 135.01 6.00 2,114.99 9,950.00 390.41 1,379.88 14.55 8,075.12 1,600.00 162.02 497.98 31.12 1,102.02 400.00 0.00 53.66 13.42 346.39 4,650.00 0.00 1,495.00 32.15 3,155.00 900.00 0.00 299.50 33.28 600.50 7,200.00 850.67 3,816.51 53.01 3,383.49 1,200.00 115.00 190.00 15.83 1,010.00 1,650.00 137.50 550.00 33.33 1,100.00 17,600.00 1,265.19 6,902.65 39.22 10,697.35 TOTAL Building Safety Environmental Personal Services 101-4-2490-4101 Regular Pay 101-4-2490-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2490-4109 Workers Comp TOTAL Personal Services 465,200.00 50,544.57 195,641.00 31.31 319,559.00 39,050.00 4,504.20 12,011.18 30.76 27,038.82 2,850.00 326.55 970.69 34.06 1,879.31 2,400.00 254.05 729.26 30.39 1,670.74 550.00 59.41 170.54 31.01 379.46 4,850.00 479.59 1,918.37 39.55 2,931.63 400.00 0.00 233.50 58.38 166.50 50,100.00 5,623.80 16,033.54 32.00 34,066.46 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 I iCl-GENER~,L FUND Public Safety ' DEPARTMENTAL EXPENDITURES 33.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-2440-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101-4-2440-4321 Telephone 101-4-2440-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools 101-4-2940-4359 Publishing 101-4-2940-4361 Insurance 101-4-2440-4409 Contractual Services 101-4-2440-4433 Dues & Subscriptions TOTAL Other Services & Charges CURRENT BUDGET CURRENT PERIOD 650.00 0.00 150.00 i6. 96 800.00 16.96 700.00 500.00 500.00 100.00 200.00 3,000.00 1,050.00 6,050.00 67.55 10.39 582.45 33.74 22.49 116.26 101.29 12.66 698.71 2.66 106.53 15.22 593.47 0.00 397.53 79.51 102.47 50.66 215.66 43.13 284.34 0.00 67.50 67.50 32.50 0.00 0.00 0.00 200.00 0.00 0.00 0.00 3,000.00 0.00 90.00 3:81 1,010.00 53.32 827.22 13.67 5,222.78 TOTAL Environmental 56,950.00 5,694.08 16,962.05 29.78 39,987.95 ' TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-9101 Regular Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3120-4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-4-3120-4219 Operating Supplies 101-9-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101-9-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Insurance 101-4-3120-4389 Utilities 5,692,650.00 546,955.98 1,639,639.75 28.80 4,053,010.25 926,650.00 50,007.75 96,520.73 22.62 330,129.27 78,400.00 5,470.95 14,712.96 18.77 63,687.04 34,950.00 3,839.84 8,511.83 24.35 26,438.17 31,300.00 3,289.36 7,078.70 22.62 24,221.30 7,350.00 769.28 1,655.49 _22.52 5,694.51 57,050.00 3,828.18 11,280.26 19.77 45,769.74 25,050.00 0.00 13,188.00 52.65 11,862.00 660,750.00 67,205.36 152,947.97 23.15 507,802.03 3,600.00 0.00 42.56 1.18 3,557.44 64,250.00 13,198.78 29,114.01 45.31 35,135.99 146,750.00 2,872.91 12,645.02 8.62 134,104.98 42,000.00 38.97 2,056.44 4.90 39,943.56 256,600.00 16,110.16 43,858.03 17.09 212,741.97 250.00 0.00 0.00 0.00 250.00 8,950.00 948.31 1,981.38 16.55 7,468.62 200.00 0.00 16.15 8.08 183.85 3,000.00 20.00 296.66 9.89 2,703.34 500.00 0.00 0.00 0.00 500.00 17,250.00 0.00 8,716.50 50.53 8,533.50 36,000.00 9,056.11 12,424.99 39.51 23,575.01 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENER~IL FUND Public Works 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-9-3120-4401 Blda Repair/Mairt Services i01-4-3120-9404 Equip Repair/Maint Services 101-4-3120-9409 Contractual Services 101-4-3120-4415 Equipment Rental 101-4-3120-4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-3120-4437 Taxes & Licenses 101-4-3120-9460 Equip Replacement Charge TCTAL Other Services & Charges Capital Outlay 9,500.00 0.00 923.87 2G.53 3,576.13 5,000.00 0.00 2,528.03 50.56 2,471.97 422,750.00 9,875.24 18,174.83 4.30 404,575.17 10,000.00 96.19 288.57 2.89 9,711.43 4,700.00 100.12 993.72 10.50 4,206.28 350.00 70.00 251.25 71.79 98.75 500.00 0.00 83.25 16.65 416.75 93,150.00 7,762.50 31,050.00 33.33 62,100.00 607,100.00 22,428.47 76,729.20 12.64 530,370.80 TOTAL Street Maintenance Snow Removal Personal Services 101-9-3130-4101 Regular Pay i01-9-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 1,524,450.00 105,743.99 273,535.20 17.94 1,250,914.80 115,500.00 6,716.38 69,593.29 60.25 45,906.71 15,000.00 2,206.76 17,367.13 115.78 ( 2,367.13) 9,050.00 646.93 7,728.45 85.40 1,321.55 8,100.00 507.81 6,190.07 76.92 1,909.93 1,900.00 118.75 1,447.62 76.19 952.38 15,950.00 2,207.55 19,176.21 88.88 1,773.79 7,350.00 0.00 1,736.00 23.62 5,614.00 172,850.00 12,404.18 118,238.77 68.91 59,611.23 90,000.00 290.97 74,020.71 82.25 15,979.29 90,000.00 290.97 74,020.71 82.25 15,979.29 TOTAL Snow Removal Equipment Services ------------------ ------------------ Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services 262,850.00 12,695.15 192,259.98 73.14 70,590.52 162,750.00 18,116.02 45,239.45 27.80 117,510.55 0.00 0.00 41.39 0.00 ( 41.39) 11,800.00 1,313.39 3,590.82 30.43 8,209.18 10,100.00 1,068.42 2,880.96 28.52 7,219.04 2,350.00 249.87 673.78 28.67 1,676.22 22,700.00 1,560.93 5,539.02 24.40 17,160.98 7,050.00 0.00 1,836.00 26.04 5,214.00 216,750.00 22,308.63 59,801.42 27.59 156,948.58 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND Public Works ' DEPARTMENTAL EXPENDITURES 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-9105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services Supplies 101-9-3300-4201 Office Supplies 101-4-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3300-4319 Other Professional Services 101-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-9-3300-9331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services-& Charges Capital Outlay 14,500.00 1,195.99 2,883.86 19.89 11,616.14 11,200.00 0.00 0.00 0.00 11,200.00 25,700.00 1,145.99 2,883.86 11.22 22,816.14 500.00 G.00 182.16 36.43 317.84 3,000.00 202.08 688.31 22.94 2,311.69 3,500.00 202.08 870.47 24.87 2,629.53 245,950.00 23,656.70 63,555.75 25.89 182,394.25 116,750.00 9,941.88 26,511.68 22.71 90,238.32 8,950.00 720.78 2,162.34 25.59 6,287.66 7,250.00 566.05 1,647.79 22.73 5,602.21 1,700.00 132.37 385.33 22.67 1,314.67 13,000.00 928.01 3,712.04 28.55 9,287.96 950.00 0.00 ( 143.00) 31.78- 593.00 147,600.00 12,289.09 34,276.18 23.22 113,323.82 1,000.00 0.00 0.00 0.00 1,000.00 700.00 25.00 127.25 18.18 572.75 9,800.00 23.51 23.51 0.24 9,776.49 11,500.00 98.51 150.76 1.31 11,349.24 10,000.00 ( 2,963.50)( 287.50) 2.88- 10,287.50 1,150.00 1.33 5.17 0.45 1,144.83 200.00 0.00 8.89 4.45 191.11 5,850.00 20.00 175.00 2.99 5,675.00 200.00 0.00 92.00 46.00 108.00 500.00 187.03 748.12 149.62 ( 248.12) 800.00 66.67 266.68 33.34 533.32 18,700.00 ( 2,688.47) 1,008.36 5.3.9 17,691.64 TOTAL Engineering 177,800.00 9,649.13 35,435.30 19.93 142,364.70 TOTAL Public Works 2,211,050.00 151,744.97 564,785.73 25.54 1,646,264.27 5-11-2011 09:19 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURREA'T BUDGET PERIOD YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Parks Department Personal Services 101-4-5110-4101 Regular Pay 101-9-5110-4102 Overtime Pay 101-4-5110-4103 Part-time Pay 101-4-5110-4104 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 WorY,ers Comp 101-4-5110-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies 101-4-5110-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-5110-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4401 Bldq Repair/Maint Services 101-4-5110-9404 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4960 Equip Replacement Charge TOTAL Other Services & Charges 350,250.00 38,750.54 103,789.09 29.63 246,460.91 0.00 0.00 19.00 0.00 ( 19.00) 40,000.00 332.50 332.50 0.83 39,667.50 25,400.00 2,833.52 8,452.73 33.28 16,947.27 29,200.00 2,298.57 6,706.75 27.71 17,993.25 5,650.00 537.57 1,568.59 27.76 4,081.41 46,900.00 3,744.90 15,917.30 33.94 30,982.70 9,000.00 0.00 5,163.00 57.37 3,837.00 0.00 2,483.00 2,983.00 0.00 ( 2,483.00) 501,900.00 50,980.10 149,431.96 28.81 356,968.04 33,200.00 2,400.99 7,274.00 21.91 25,926.00 3,250.00 115.46 397.03 12.22 2,852.97 72,900.00 7,592.00 15,289.79 20.97 57,610.21 11,000.00 2,011.71 8,370.86 76.10 2,629.14 120,350.00 12,070.16 31,331.68 26.03 89,018.32 4,400.00 248.29 752.20 17.10 3,647.80 100.00 0.00 0.00 0.00 100.00 3,150.00 55.00 706.07 22.41 2,443.93 26,700.00 0.00 12,814.50 47.99 13,885.50 27,800.00 114.31 380.82 1.37 27,419.18 4,000.00 0.00 0.00 0.00 9,000.00 12,000.00 2,867.71 2,942.71 24.52 9,057.29 7,550.00 0.00 0.00 0.00 7,550.00 25,000.00 466.82 2,097.79 8.39 22,902.21 57,900.00 9,825.00 19,300.00 33.33 38,600.00 168,600.00 8,577.13 38,994.09 23.13 129,605.91 Capital Outlay TOTAL Parks Department 790,350.00 71,627.39 214,757.73 27.17 575,592.27 Parks & Rec Admin ----------------- ----------------- Personal Services 101-4-5210-4101 Regular Pay 338,950.00 28,571.26 76,174.73 22.47 262,775.27 101-4-5210-4103 Part-time Pay 20,850.00 4,131.88 11,221.52 53..82 9,628.48 101-4-5210-4109 PERA 26,100.00 2,371.02 7,106.68 27.23 18,993.32 101-4-5210-4105 FICA 22,300.00 1,912.81 5,627.06 25.23 16,672.94 101-4-5210-4107 Medicare 5,200.00 447.36 1,316.05 25.31 3,883.95 5-11-2011 09:14 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GEA~ERAL FL`ND Culture & Recreation CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES ~ BUDGET PERIOD ACTUAL PAGE: 23 33.33% OF YE~ARCOMP. °s OF BUDGET BUDGET BALANCE 10'_-4-5210-9108 Insurance 45,600.00 2,926.75 11,714.18 25.69 33,885.82 101-4-521C-4109 Workers Comp 3,750.00 0.00 1,781.00 47.49 1,969.00 TOTAL Person al Services 462,750.00 40,361.08 114,941.22 24.84 347,808.78 Supplies 101-4-5210-4219 Operating Supplies 11,700.00 1,530.56 6,369.63 54.44 5,330.37 TOTAL Suppli es 11,700.00 1,530.56 6,369.63 54.44 5,330.37 Other Services & Charges 101-4-5210-4321 Telephone 4,800.00 244.69 860.34 17.92 3,939.66 101-4-5210-4322 Postage 9,OOO.OC 1,507.22 1,796.89 44.92 2,203.11 101-4-5210-4331 Travel, Conferences & Schools 6,950.00 24.99 278.03 4.00 6,671.97 101-4-5210-4349 Advertising/Marketing 26,400.00 9,878.10 11,584.97 43.88 14,815.03 101-4-5210-4361 Insurance 1,450.00 0.00 307.50 21.21 1,142.50 101-4-5210-4389 Utilities 8,500.00 616.04 2,018.91 23.75 6,981.09 101-4-5210-4401 Bldg Repair/Maint Services 12,850.00 930.99 5,301.77 41.26 7,548.23 101-4-5210-4904 Equip Repair/Maint Services 9,350.00 757.65 3,598.07 38.48 5,751.93 101-4-5210-4433 Dues & Subscriptions 1,550.00. 0.00 1,058.00 68.26 492.00 TOTAL Other Services & Charges 75,850.00 13,959.68 26,804.48 35.34 49,045.52 Capital Outlay TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 101-4-5220-4109 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare TOTAL Personal Services Supplies 101-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5220-4409 Equip Repair/Maint Services 101-4-5220-4909 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 550,300.00 55,851.32 148,115.33 26.92 402,184.67 82,000.00 2,935.44 10,666.29 13.01 71,333.71 2,400.00 109.63 319.47 13.31 2,080.53 4,350.00 182.01 725.27 16.67 3,624.73 1,200.00 42.59 169.62 19.14 1,030.38 89,950.00 3,269.67 11,880.65 13.21 78,069.35 31,000.00 1,336.68 6,089.78 19.64 29,910.22 31,000.00 1,336.68 6,089.78 19.64 24,910.22 500.00 0.00 0.00 0..00 500.00 64,050.00 ( 750.00) 5,730.75 8.95 58,319.25 3,000.00 0.00 0.00 0.00 3,000.00 4,000.00 1,069.35 1,734.69 43.37 2,265.36 71,550.00 319.35 7,465.39 10.93 64,084.61 TOTAL Recreation Programs 192,500.00 4,925.70 25,435.82 13.21 167,064.18 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 101-GENERAL~FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 33.330. OF YEAR COMP. °s OF BUDGET BUDGET BALANCE Concessions Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 101-4-5230-4109 PERA 150.00 101-4-5230-4105 FICA 250.00 '_01-4-5230-4107 Medicare 50.00 TOTAL Personal Services 9,100.00 Supplies 101-4-5230-9219 Operating Supplies 2,900.00 101-4-5230-4259 Other Merchandise For Resale 7,000.00 TOTAL Supplies 9,900.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 TOTAL Other Services & Charges 100.00 TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4104 PERA 101-4-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-4-5510-4331 Travel, Conferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4901 Bldg Repair/Maint Services 101-4-5510-4404 Equip Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 191.25 220.25 6.03 3,429.75 13.86 15.96 10.64 134.04 11.86 13.66 5.46 236.34 2.77 3.19 6.38 96.81 219.74 253.06 6.17 3,846.94 0.00 0.00 0.00 2,900.00 138.00)( 138.00) 1.97- 7,138.00 138.00)( 138.00) 1.39- 10,038.00 o.oo o.oo o.o0 100.00 0.00 0.00 0.00 100.00 19,100.00 81.74 115.06 0.82 ,13,984.94 57,400.00 6,621.63 17,657.66 30.76 39,742.34 62,000.00 6,902.18 18,556.19 29.93 43,443.81 8,650.00 980.96 2,956.02 39.17 5,693.98 7,400.00 802.39 2,383.63 32.21 5,016.37 1,750.00 187.66 557.48 31.86 1,192.52 13,700.00 1,110.20 4,440.80 32.41 9,259.20 500.00 0.00 258.00 51.60 242.00 151,400.00 16,604.52 46,809.78 30.92 104,590.22 12,400.00 164.08 1,707.83 13.77 10,692.17 12,400.00 164.08 1,707.83 13.77 10,692.17 2,600.00 181.67 736.29 28.32 1,863.71 2,500.00 511.88 1,072.23 42.89 1,427.77 2,400.00 200.00 259.00 10.79 2,141.00 1,600.00 0.00 742.50 96.41 857.50 9,700.00 1,224.83 4,109.59 42.37 5,590.41 12,400.00 624.04 4,023.08 32.4.4 8,376.92 1,500.00 0.00 0.00 0.00 1,500.00 6,950.00 17.00 ( 74.00) 1.06- 7,024.00 1,000.00 0.00 575.16 57.52 429.84 40,650.00 2,759.42 11,443.85 28.15 29,206.15 5-11-2011 09:14 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °sOF BUDGES BUDGET PERIOD ACTUAL BUDGET BALANCE ' Capital Outlay TOTAL Sr Citizen Programs 204,450.00 19,528.02 59,961.46 29.33 144,488.54 TOTAL Culture & Recreation Economic Development ------------------- Personal Services 101-4-6210-9101 Regular Pay 101-4-6210-9103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare 101-4-6210-4108 Insurance 101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210--4322 Postage 101-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 1,751,700.00 152,014.17 448,385.40 25.60 1,303,314.60 0.00 7,371.55 26,326.95 0.00 ( 26,326.95) 0.00 891.84 1,783.68 0.00 ( 1,783.68) 0.00 549.04 1,937.90 0.00 ( 1,937.90) 0.00 997.55 1,630.29 0.00 ( 1,630.29) 0.00 116.94 385.63 0..00 ( 385.63) 0.00 178.61 1,904.52 0.00 ( 1,904.52) 0.00 ( 161.00) 0.00 0.00 0.00 0.00 9,494.53 33,968.97 0.00 ( 33,968.97) 0..00 ( 421.04) 0.00 0.00 0.00 0.00 ( 1,433.00) 0.00 0.00 0.00 0.00 ( 24.57) 11.04 0.00 ( 11.04) 0.00 ( 1,878.61) 11.09 0.00 ( 11.04) TOTAL Economic Development 0.00 7,565.92 33,980.01 0.00 ( 33,980.01) Energy City Personal Services 101-4-6220-4101 Regular Pay 28,700.00 3,312.98 8,833.28 30.78 19,866.72 101-4-6220-4104 PERA 2,100.00 240.18 709.33 33.78 1,390.67 101-4-6220-4105 FICA 1,800.00 191.60 551.93 30.64 1,298.57 101-4-6220-4107 Medicare 400.00 44.81 128.97 32.29 271.03 101-4-6220-4108 Insurance 3,150.00 249.51 998.04 31.68 2,151.96 TOTAL Personal Services 36,150.00 4,038.58 11,221.05 31.04 24,928.95 Supplies Other Services & Charges 101-9-6220-4319 Other Professional Services 5,000.00 0.00 38.67 0.77 4,961.33 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 1,704.07 ( 2,424.11) 32.32- 9,929.11 101-4-6220-4359 Publishing 3,000.00 93.95 620.96 20.70 2,379.04 TOTAL Other Services & Charges 15,500.00 1,798.02 ( 1,769.48) 11.38- 17,264.48 TOTAL Energy City 51,650.00 5,836.60 9,456.57 18.31 42,193.43 5-11-2011 09:14 AM CITY OE ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 101-GENERAL FUND Economic Development ' DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Economic Development Transfers Out Transfers Out 10i-9-7000-4723 Transfer-Ice Arena 101-4-7000-4724 Transfer - Pinewood TOTAL Transfers Out TOTAL Transfers Out 51,650.00 13,402.52 43,436.58 84.10 8,213.42 156,250.00 0.00 48,950.00 0.00 205,200.00 0.00 205,200.00 0.00 0.00 0.00 156,250.00 0.00 0.00 48,950.00 0.00 0.00 205,200.00 0.00 0.00 205,200.00 TOTAL General 205,200.00 0.00 0.00 0.00 205,200.00 ~ TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 12,500,050.00 1,104,012.21 3,949,254.01 27.59 9,050,795.99 ( 336,600.00)( 932,874.93)( 2,718,301.41) 2,381,701.41 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 221-ICE P.RENA FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' REVENUE SUMMARY Ice Arena 678,900.00 50,530.59 225,487.45 33.21 453,412.55 Hockey 49,500.00 2,985.00 44,047.00 88.98 5,453.00 Skating 73,350.00 859.00 17,954.00 24.48 55,396.00 Concessions 63,100.00 BOC.46 37,314.78 59.14 25,785.22 TOTAL REVENUES 864,850.00 55,175.05 324,803.23 37.56 540,046.77 . EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 756,500.00 90,559.76 152,301.16 20.13 604,198.84 27,050.00 2,338.88 3,307.01 12.23 23,742.99 34,050.00 2,305.71 7,384.12 21.69 26,665.88 47,250.00 3,688.01 23,172.27 49.04 24,077.73 869,850.00 48,892.36 186,164.56 21.53 678,685.44 864,850.00 48,892.36 186,164.56 21.53 678,685.44 0.00 6,282.69 138,638.67 ( 138,638.67) 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TY., 2011 ~ 221-ICE ARENA ' REVENUES 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3982 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-000G-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221-3-0000-3791 ATM Revenue TOTAL Sales Transfers In 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating 443,000.00 43,577.87 188,945.90 42.65 254,054.60 22,900.00 0.00 17,666.25 77.15 5,233.75 14,600.00 7,399.95 9,467.40 64.85 5,132.60 4,100.00 132.00 2,212.00 53.95 1,888.00 2,600.00 0.00 0.00 0.00 2,600.00 17,000.00 ( 800.00) 1,574.00 9.26 15,426.00 504,200.00 50,309.E2 219,865.05 43.61 284,334.95 16,650.00 125.56 4,696.64 28.21 11,953.36 1,800.00 57.76 768.26 92.68 1,031.74 18,450.00 183.32 5,464.90 29.62 12,985.10 0.00 37.45 1.57.50 0.00 ( 157.50) 0.00 37.45 157.50 0.00 ( 157.50) 156,250.00 0.00 0.00 0.00 156,250.00 156,250.00 0.00 0.00 0.00 156,250.00 678,900.00 50,530.59 225,487.45 33.21 453,412.55 49,500.00 2,985.00 44,047.00 88.98 5,453.00 49,500.00 2,985.00 94,047.00 88.98 5,453.00 99,500.00 2,985.00 44,047.00 88.98 5,953.00 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 22i-ICE ARENA REVENUES Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services Other Revenue 221-3-5420-3629 Miscellaneous Revenue TOTAL Other Revenue TOTAL Skating Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services TOTAL Concessions 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 68,000.00 859.00 17,954.00 26.90 50,046.00 3,800.00 0.00 0.00 0.00 3,800.00 71,800.00 859.00 17,954.00 25.01 53,896.00 1,550.00 0.00 0.00 0.00 1,550.00 1,550.00 0.00 0.00 0.00 1,550.00 73,350.00 859.00 17,954.00 29.48 55,396.00 63,100.00 800.46 37,314.78 59.19 25,785.22 63,100.00 800.46 37,314.78 59.14 25,785.22 63,100.00 800.46 37,314.78 59.14 25,785.22 I TCTAL REVENUE 864,850.00 55,175.05 324,803.23 37.56 540,046.77 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ^ 221-ICE ARENA ' DEPARTMENTAL EXPENDITURES CURRENT BUDGET CURRENT PERIOD 33.33$ OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE ~ Ice Arena Personal Services 221-4-5400-4101 Regular Pay 148,700.00 14,390.58 221-4-5400-4103 Part-time Pay 73,200.00 7,503.15 221-4-5400-4104 PERA 12,250.00 1,350.79 221-4-5400-4105 FICA 13,750.00 1,341.78 221-4-5900-4107 Medicare 3,200.00 313.79 221-4-5400-9108 Insurance 17,150.00 1,160.52 221-4-5400-9109 Workers Comp 5,550.00 0.00 221-4-5400-4110 Re-employment Compensation 0.00 370.07 TOTAL Personal Services 273,800.00 26,430.63 Supplies 221-4-5400-4212 Fuels & Lubs 400.00 0.00 221-4-5400-4217 Uniform Allowance 1,500.00 0.00 221-4-5400-4219 Operating Supplies 34,500.00 ( 469.92) 221-4-5400-4255 Soft Drinks/Misc 9,000.00 0.00 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 TOTAL Supplies 46,300.00 ( 469.92) Other Services & Charges 39,193.93 26.36 109,506.07 29,830.98 40.75 43,369.02 9,444.46 36.28 7,805.54 4,822.20 35.07 8,927.80 1,127.78 35.24 2,072.22 5,026.98 29.31 12,123.02 3,426.00 61.73 2,124.00 370.07 0.00 ( 370.07) 88,242.40 32.23 185,557.60 6.82 1.71 393.18 0.00 0.00 1,500.00 4,928.85 14.29 29,571.15 1,437.12 15.97 7,562.88 0.00 0.00 900.00 6,372.79 13.76 221-4-5400-4321 Telephone 3,450.00 234.64 846.48 24.54 2,603.52 221-4-5400-4322 Postage 500.00 0.00 196.32 39.26 303.68 221-4-5400-4331 Travel, Conferences & Schools 1,000.00 0.00 0.00 0.00 1,000.00 221-4-5400-4359 Publishing 2,200.00 290.00 570.50 25.93 1,629.50 221-4-5400-4361 Insurance 8,350.00 0.00 3,614.50 43.29 4,735.50 221-4-5400-4389 Utilities 148,950.00 14,044.81 42,977.78 28.85 105,972.22 221-4-5400-4401 Bldg Repair/Maint Services 22,300.00 0.00 2,189.44 9.82 20,110.56 221-4-5400-4409 Contractual Services 1,200.00 29.60 85.94 7.16 1,114.06 221-4-5400-4915 Equipment Rental 2,800.00 0.00 341.98 12.21 2,458.02 221-4-5400-4933 Dues & Subscriptions 450.00 0.00 183.34 40.74 266.66 TOTAL Other Services & Charges 191,200.00 14,599.05 51,006.28 26.68 140,193.72 Capital Outlay 221-4-5400-4560 Equipment 44,400.00 0.00 6,679.69 15.04 37,720.31 TOTAL Capital Outlay 44,400.00 0.00 6,679.69 15.04 37,720.31 I 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out 200,800.00 0.00 200,800.00 0.00 0.00 0.00 200,800.00 0.00 0.00 200,800.00 TOTAL Ice Arena 756,500.00 40,559.76 152,301.16 20.13 604,198.84 5-11-2011 09:15 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 PAGE: 5 33.330 OF YEAR COMP. CURRENT CURRENT- YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-9-5410-4103 Part-time Pay 221-4-5410-4105 FICA 221-4-5410-4107 Medicare TOTAL Personal Services Supplies 221-4-5410-9219 Operating Supplies TOTAL Supplies Cther Services & Charges 221-4-5410-4359 Publishing 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees .TOTAL Other Services & Charges TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-4-5920-9105 FICA 221-4-5920-9107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4359 Publishing 221-4-5420-4909 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Skating 3,600.00 0.00 0.00 0.00 3,600.00 250.00 0.00 0.00 0.00 250.00 50.00 0.00 0.00 0.00 50.00 3,900.00 0.00 0.00 0.00 3,900.00 14,050.00 1,385.35 1,385.35 9.86 12,664.65 14,050.00 1,385.35 1,385.35 9.86 12,664.65 500.00 0.00 0.00 0.00 500.00 6,400.00 179.20 341.60 5.34 6,058.90 2,200.00 774.33 1,580.06 71.82 619.94 9,100.00 953.53 1,921.66 21.12 7,178.34 27-,050.00 2,338.88 3,307.01 12.23 23,742.99 20,000.00 1,355.31 4,338.23 21.69 15,661.77 1,000.00 16.10 95.95 9.60 904.05 1,250.00 84.03 282.16 22.57 967.84 300.00 19.67 66.01 22.00 233.99 22,550.00 1,475.11 9,782.35 21.21 17,767.65 5,500.00 756.44 1,739.72 31.54 3,765.28 5,500.00 756.94 1,739.72 31.54 3,765.28 650.00 0.00 0.00 0.00 650.00 2,550.00 40.00 235.20 9.22 2,314.80 2,800.00 39.16 631.85 22.57 2,168.15 6,000.00 74.16 867.05 14.45 5,132.95 34,050.00 .2,305.71 7,384.12 21.69 26,665.88 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 221-ICE ARENA Culture & Recreation ' DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 1,987.88 8,168.22 39.08 12,731.78 221-4-5430-4109 PERA 200.00 36.82 152.41 76.21 47.59 221-4-5430-4105 FICA 1,300.00 123.26 563.94 43.38 736.06 221-4-5430-4107 Medicare 300.00 28.83 131.88 43.96 168.12 TOTAL Personal Services 22,700.00 2,176.79 9,016.95 39.72 13,683.55 Supplies 221-4-5430-4219 Operating Supplies 3,550.00 1.77 929.14 26.17 2,620.86 221-4-5930-4259 Other Merchandise' For Resale 21,000.00 1,509.45 13,226.68 62.98 7,773.32 TOTAL Supplies 24,550.00 1,511.22 14,155.82 57.66 10,394.18 TOTAL Arena Concessions 47,250.00 3,688.01 23,172.27 49.04 24,077.73 TOTAL Culture & Recreation ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 864,850.00 48,892.36 186,164.56 21.53 678,685.49 864,850.00 48,892.36 186,164.56 21.53 678,685.44 0.00 6,282.69 138,638.67 ( 138,638.67) 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ' 222-PINEWOOD GdLF COURSE FINANCIAL SUMMARY 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' REVENUE SUMM.~IRY' I Pinewood Golf Course TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 249,550.00 22,147.34 26,090.34 10.45 223,459.66 249,550.00 22,147.34 26,090.34 10.45 223,459.66 249,550.00 27,333.06 51,868.10 20.78 197,681.90 249,550.00 27,333.06 51,868.10 20.78 197,681.90 249,550.00 27,333.06 51,868.10 20.78 197,681.90 0.00 ( 5,185.72)( 25,777.76) 25,777.76 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ^ 222-PINEWOOD GOLF COURSE ' REVENUES 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3475 Building Rent 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments TOTAL Charges for Services Other Revenue Sales 222-3-0000-3792 Cash Over TOTAL Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In 17,000.00 19,000.00 5,000.00 100.00 120,000.00 14,000.00 18,500.00 7,000.00 200,600.00 0.00 0.00 3,945.00 7,888.00 46.40 9,112.00 497.39 497.34 2.62 18,502.66 132.10 132.10 2.64 4,867.90 0.00 0.00 0.00 100.00 5,715.00 5,715.00 4.76 114,285.00 10,965.02 10,965.02 78.32 3,039.98 890.50 890.50 4.81 17,609.50 0.00 0.00 0.00 7,000.00 22,144.96 26,087.96 13.00 174,512.04 TOTAL Pinewood Golf Course 2.38 2.38 48,950.00 0.00 48,950.00 0.00 2.38 0.00 ( 2.38) 2.38 0.00 ( 2.38) 0.00 0.00 48,950.00 0.00 0.00 48,950.00 249,550.00 22,147.34 26,090.34 10.45 223,459.66 ^ TOTAL REVENUE 249,550.00 22,147.34 26,090.34 10.45 223,459.66 5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2011 ~ 222-PINEWOOD GOLF COURSE I DEPARTMENTAL EXPENDITURES 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Golf Course Personal Services 222-4-5300-4101 Regular Pay 93,650.00 13,335.20 25,332.91 27.05 68,317.09 222-4-5300-4103 Part-time Pay 29,900.00 716.01 716.01 2.39 29,183.99 222-4-5300-4104 PERA 8,950.00 728.37 1,762.42 19.69 7,187.58 222-4-5300-4105 FICA 7,650.00 865.37 1,732.22 22.64 5,917.78 222-4-5300-4107 Medicare 1,800.00 202.38 405.08 22.50 1,394.92 222-4-5300-4108 Insurance 10,150.00 458.01 1,832.04 18.05 8,317.96 222-9-5300-4109 Workers Comp 1,400.00 0.00 836.00 59.71 564.00 222-9-5300-4110 Re-employment Compensation 0.00 9,842.25 4,842.25 0.00 ( 4,842.25) TOTAL Persona l Services 153,500.00 21,147.59 37,458.93 24.40 116,041.07 Supplies 222-4-5300-9212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4217 Uniform Allowance 500.00 360.00 360.00 72.00 140.00 222-4-5300-4219 Operating Supplies 30,400.00 4,429.60 4,896.64 16.11 25,503.36 222-4-5300-4259 Other Merchandise For Resale 14,500.00 251.28 516.07 3.56 13,983.93 TOTAL Supplies 50,400.00 5,090.88 5,772.71 11.45 94,627.29 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 122.16 429.06 17.16 2,070.94 222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00 222-4-5300-4349 Advertising/Marketing 1,300.00 195.00 195.00 15.00 1,105.00 222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 99.51 6,603.50 222-4-5300-4389 Utilities 7,150.00 244.53 392.23 5.49 6,757.77 222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 190.54 230.62 10.03 2,069.38 222-4-5300-4404 Equip Repair/Maint Services 3,000.00 61.60 1,277.40 42.58 1,722.60 222-4-5300-4415 Equipment Rental 2,000.00 21.16 21.16 1.06 1,978.84 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,238.66)( 834.48) 83.45- 1,834.48 222-4-5300-9438 Credit Card Fees 5,500.00 132.26 212.97 3.87 5,287.03 TOTAL Other Services & Charges 37,150.00 ( 271.91) 7,220.46 19.94 29,929.54 Capital Outlay Debt Service 222-4-5300-4601 Principal 8,500.00 1,416.00 1,416.00 16.66 7,084.00 TOTAL Debt Service 8,500.00 1,916.00 1,416.00 16.66 7,084.00 TOTAL Golf Course 249,550.00 27,333.06 51,868.10 20.78 197,681.90 TOTAL Culture & Recreation 249,550.00 27,333.06 51,868.10 20.78 197,681.90 ~ TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 249,550.00 27,333.06 51,868.10 20.78 197,681.90 0.00 ( 5,185.72)( 25,777.76) 25,777.76 5-11-2011 09:19 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2011 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALF,NCE ACTIVITY CURRENT BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 221-1010 Cash - Ice Arena 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 290-1010 Cash - Micro Loan Fund 241-1010 Cash - DTED Loan 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - GRE Reserve 308-1010 Cash - 1999A GO Bonds 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Cash - 2002A Pub Safety Bonds 340-1010 Cash - Equipment Certificates 375-1010 Cash - TIF #19 East Elk River 403-1010 Cash - Street Improvement 404-1010 Cash - Surface Water Managemnt 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash - Park Improvement 456-1010 Cash - TIF #16 King/Main 459-1010 Cash - TIF #19 Highway 169 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 24,391.39 77.42 24,418.81 4,078,081.90 ( 943,280.42) 3,134,801.48 413,506.67 ( 3,254.35) 410,252.32 87,215.32 45,391.97 132,607.29 ( 17,972.91) ( 5,476.86) ( 23,449.77) 10,015.53 ( 599.29) 9,416.24 11,216.82 ( 42,492.50) ( 31,275.68) 1,003,388.01 ( 25,715.31) 977,672.70 686,253.96 0.00 686,253.96 1,043,095.93 4,286.23 1,047,382.16 282,893.04 4,828.04 287,721.08 365,249.99 ( 763.28) 364,986.71 1,306,134.50 560.00 1,306,699.50 362,314.81 40,652.99 402,967.80 3,393,670.22 81,773.00 3,475,443.22 4,636.94 7,013.84 11,650.78 142,816.42 0.00 142,816.42 1,494,017.04 ( 277,102.66) 1,166,914.38 25,000.00 0.00 25,000.00 46,218.96 0.00 96,218.96 115,222.29 0.00 115,222.24 152,058.57 0.00 152,058.57 167,191.88 0.00 167,191.88 3,117.29 0.00 3,117.29 7,437.50 0.00 7,437.50 5,198,271.78 13,477.53 5,211,749.31 280,517.03 ( 976.62) 279,590.41 4,153,623.04 954.60 4,154,577.64 894,766.24 20,689.58 915,455.82 1,343,517.54 0.00 1,343,517.54 ( 37,108.51) ( 532.92) ( 37,641.43) 79,442.43 1,208.63 80,651.06 44,053.26 0.00 44,053.26 457,063.13 0.00 457,063.13 9,515,089.00 45,700.00 4,560,789.00 4,081,157.58 125,974.39 4,207,131.97 482,814.04 15,839.15 498,653.19 0.00 53,169.48 53,169.48 89,268.38 1,092.00 90,360.38 36,739,596.96 ( 837,505.36) 35,902,091.60 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH 20,645,639.50 239,373.35 20,885,012.85 (12,288,232.10) ( 1,076,878.71) (13,365,110.81) 28,382,189.56 0.00 28,382,189.56 36,739,596.96 ( 837,505.36) 35,902,091.60