Loading...
INFORMATION #4 06-15-20091~3~ ®~~II~TIC3 ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: June 15, 2009 SUBJECT: May 2009 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and the Ice Arena and Pinewood Golf special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of May, actual revenues (except for property taxes and state aids) and expenditures should generally 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 overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Kevenue.r.• • Excluding transfers in, revenue collections axe at 5% of budget; however, property taxes, our largest revenue source, will be received in June/July and December. • The total licenses and permits category is currently exceeding the budget benchmark as of the end of May due to the annual renewal of business licenses. • Charges for services are exceeding budget estimates due mainly to the collection of recreation-related fees and the annual fire contract. • Court fine collections (which lag a month behind) at 25% of budget are lower than the budget benchmark of 33% for the same time period. • Transfers in will be recorded mid-year. E.xf~enditure.r: • Excluding transfers out, the total departmental expenditures are at about 36% and most departments are well within or below budget estimates. • The transfers out to the Ice Arena and Pinewood Golf Course are made at the end of the year based on actual results. Ice Arena For the month ended May, revenues exceed expenditures by $18,696. Excluding transfers, revenue collections of $297,032 are at 39% of budget estimates and slightly below last year's collections of $303,238 or 41% of budget estimates. Expenditures are at 29% of budget estimates and include $24,225 of debt service payments. Pinewood Golf For the month ended May, expenditures exceed revenues by $23,761. The following chart provides arevenue/expenditure comparison with last year's operations: %of %of 5 31 09 Budget 5 31 08 Budget Revenues (excluding transfers) $76,415 39.70% $62,129 29.14% Expenditures $100,176 39.32% $117,900 42.05% Revenues .over (under) ($23,761) ($55,771) expenditures ,. 6-11-2009 02:47 PM I 101-GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY General Fund ~ TOTAL REVENUES ' EXPENDITURE SUMMARY ' General Government Mayor & Council Cable TV Administrative Services Human Resources Finance Information Technology Legal Community Development Planning City Hall Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fire Administration Fire Inspections Emergency Management Building Safety Environmental TOTAL Public Safety ' Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works 12,636,100.00 96,521.77 767,150.66 6.07 11,868,949.34 12,636,100.00 96,521.77 767,150.66 6.07 11,868,949.34 168,100.00 9,268.07 62,913.68 37.43 105,186.32 81,800.00 7,385.21 25,971.07 31.75 55,828.93 971,650.00 47,503.95 177,008.03 37.53 294,691.97 147,950.00 15,488.89 56,321.23 38.07 91,628.77 447,300.00 39,275.22 164,084.31 36.68 283,215.69 278,050.00 19,732.02 79,272.43 28.51 198,777.57 234,000.00 17,610.75 68,186.00 29.14 165,814.00 126,950.00 7,199.82 57,864.03 45.58 69,085.97 321,200.00 30,257.35 115,220.61 35.87 205,979.39 286,350.00 23,997.65 105,862.62 36.97 180,987.38 70,050.00 0.00 0.00 0.00 70,050.00 2,633,400.00 212,718.93 912,704.01 39.66 1,720,695.99 597,700.00 42,832.13 281,673.77 47.13 316,026.23 2,182,800.00 200,027.30 742,228.68 34.00 1,440,571.32 714,150.00 69,319.38 244,272.37 39.20 469,877.63 492,050.00 49,353.86 182,170.60 37.02 309,879.40 22,750.00 512.33 2,366.14 10.40 20,383.86 202,700.00 18,746.53 69,330.20 34.20 133,369.80 472,200.00 55,239.61 182,293.24 38.61 289,906.76 188,850.00 21,562.80 70,339.33 37.25 118,510.67 49,150.00 3,675.50 10,953.61 22.29 38,196.39 588,600.00 47,790.39 267,036.84 45.37 321,563.16 75,350.00 7,522.58 27,601.78 36.63 47,748.22 5,586,300.00 516,582.36 2,080,266.56 37.24 3,506,033.44 1,300,650.00 110,785.91 386,997.67 29.75 913,652.33 308,750.00 256.45 146,570.85 97.47 162,179.15 250,450.00 24,103.94 66,867.20 34.68 163,582.80 191,150.00 5,987.31 36,041.06 18.85 155,108.94 2,051,000.00 141,133.11 656,476.78 32.01 1,394,523.22 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 "i01-GENERAL FUND FINANCIAL SUMMARY 41.67°s 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 Developement Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 733,150.00 79,098.79 241,657.15 32.96 491,492.85 541,450.00 52,018.47 211,661.28 39.09 329,788.72 164,300.00 13,836.68 53,197.26 32.38 111,102.74 19,500.00 9,687.04 5,349.Oi 27.43 19,150.99 193,350.00 19,006.26 71,101.72 36.77 122,248.28 1,651,750.00 163,647.19 582,966.42 35.29 1,068,783.58 0.00 7,213.20 37,525.93 0.00 ( 37,525.93) 55,800.00 6,420.68 9,963.55 17.86 45,836.45 55,800.00 13,633.88 4"7,489.48 85.11 8,310.52 229,300.00 0.00 66,600.00 29.04 162,700.00 229,300.00 0.00 66,600.00 29.04 162,700.00 12,207,550.00 1,047,715.47 4,346,503.25 35.61 7,861,046.75 428,550.00 ( 951,193.70)( 3,579,352.59) 4,007,902.59 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND REVENUES General Fund CURRENT CURRENT BUDGET PERIOD 41.67°s OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,547,550.00 0.00 0.00 0.00 9,547,550.00 101-3-0000-3121 Gravel Tax 150,000.00 0.00 3,997.52 2.67 146,002.48 101-3-0000-3132 Tax Forfeited Land Sale 0.00 0.00 25.55 0.00 ( 25.55) TOTAL Property Taxes 9,697,550.00 0.00 4,023.07 0.04 9,693,526.93 Licenses & Permits 101-3-0000-3211 Liquor License 51,000.00 11,150.00 43,790.00 85.86 7,210.00 101-3-0000-3212 Amusement License 1,000.00 0.00 0.00 0.00 1,000.00 101-3-0000-3213 Cigarette License 3,000.00 0.00 100.00 3.33 2,900.00 101-3-0000-3214 Apartment License 15,850.00 6,735.00 12,210.00 77.03 3,640.00 101-3-0000-3216 Mining License 9,000.00 0.00 20,562.45 228.47 ( 11,562.45) 101-3-0000-3217 Garbage Hauler License 3,000.00 0.00 3,095.00 103.17 ( 95.00) 101-3-0000-3218 Other Business License/Permit 13,000.00 1,395.00 14,570.00 112.08 ( 1,570.00) 101-3-0000-3229 NPDES Permit 5,000.00 0.00 525.00 10.50 4,475.00 101-3-0000-3231 Building Permit 188,300.00 19,248.05 55,721.92 29.59 132,578.08 101-3-0000-3232 Plumbing/Heating Permit 47,600.00 2,817.59 28,422.06 59.71 19,177.94 101-3-0000-3233 Permit Surcharge 200.00 957.08 1,335.20 667.60 ( 1,135.20) 101-3-0000-3234 Electric Permit 100.00 0.00 0.00 0.00 100.00 101-3-0000-3235 Animal License 3,000.00 1,580.00 2,660.00 88.67 340.00 101-3-0000-3236 Parking Permit 1,500.00 20.00 1,180.00 78.67 320.00 101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 830.00 5,230.00 43.58 6,770.00 TOTAL Licenses & Permits 353,550.00 44,732.72 189,901.63 53.57 164,148.37 Intergovernmental Rev 101-3-0000-3321 Local Government Aid 686,800.00 0.00 0.00 0.00 686,600.00 101-3-0000-3329 PERA Aid 15,000.00 0.00 0.00 0.00 15,000.00 101-3-0000-3325 Police 2~ Aid 215,000.00 0.00 0.00 0.00 215,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 0.00 0.00 10,000.00 i01-3-0000-3327 State-Aid Street Maint 36,800.00 0.00 19,487.34 52.95 17,312.66 101-3-0000-3329 State Crime Prevention Grant 12,500.00 1,440.00 2,666.40 21.33 9,833.60 101-3-0000-3341 County Reimb/Grant 7,500.00 0.00 0.00 0.00 7,500.00 TOTAL Intergovernmental Rev 983,600.00 1,440.00 22,153.74 2.25 961,446.26 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 350.00 7,500.00 30.00 17,500.00 101-3-0000-3413 Plan Check Fee 75,300.00 8,066.34 19,450.01 25.83 55,849.99 101-3-0000-3415 Special Assessment Search 500.00 20.00 260.00 52.00 240.00 101-3-0000-3417 Copies 1,500.00 164.10 866.57 57.77 633.43 101-3-0000-3418 Other General Govt Services 5,000.00 0.00 1,009.88 20.20 3,990.12 101-3-0000-3930 Lockout Fees 8,500.00 479.58 3,564.58 41.94 4,935.42 101-3-0000-3431 Police Services 2,000.00 290.25 820.75 41.04 1,179.25 101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 885.00 1,770.00 59.00 1,230.00 101-3-0000-3436 Fire Contracts 208,000.00 0.00 149,717.00 71.98 58,283.00 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 ~ 101-GENERAL FUND REVENUES 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3461 Recreation Fees 101-3-0000-3467 Concessions 'i01-3-0000-3472 Park Use Fee 101-3-0000-3974 Facility Use Fee 101-3-0000-3475 Building Rent i01-3-0000-3483 Sewer Inspection Fee 101-3-0000-3489 Contractor License Check TOTAL Charges for Services pines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines & Forfeits Cher Revenue 101-3-0000-3621 Interest Income 101-3-0000-3625 Refunds & Reimbursements 101-3-0000-3626 Contributions 101-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101-3-0000-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-WWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1,000.00 0.00 0.00 0.00 1,000.00 25,000.00 0.00 6,640.99 26.56 18,359.01 121,500.00 8,877.20 70,976.64 58.42 50,523.36 20,100.00 1,218.42 3,209.98 15.97 16,890.02 2,600.00 1,349.56 11,049.00 424.96 ( 8,449.00) 3,100.00 1,291.32 9,096.18 132.13 ( 996.18) 2,400.00 200.00 2,350.00 97.92 50.00 5,000.00 0.00 650.00 13.00 4,350.00 500.00 35.00 145.00 29.00 355.00 585,000.00 23,176.77 321,576.58 54.97 263,423.42 150,000.00 8,976.73 38,109.83 25.41 111,890.17 7,000.00 350.00 9,755.75 139.37 ( 2,755.75) 157,000.00 9,326.73 47,865.58 30.99 109,134.42 180,000.00 12,332.72 5,701.08 3.17 174,298.92 54,000.00 1,839.83 1,839.83 3.41 52,160.17 22,800.00 2,610.00 18,380.00 80.61 9,420.00 3,000.00 1,063.00 3,209.15 106.97 ( 209.15) 259,800.00 17,845.55 29,130.06 11.21 230,669.99 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 50,000.00 0.00 0.00 0.00 50,000.00 248,600.00 0.00 0.00 0.00 248,600.00 200,000.00 0.00 153,000.00 76.50 47,000.00 17,000.00 0.00 0.00 0.00 17,000.00 9,500.00 0.00 0.00 0.00 9,500.00 599,600.00 0.00 153,000.00 25.52 446,600.00 12,636,100.00 96,521.77 767,150.66 6.07 11,868,949.34 TOTAL REVENUE 12,636,100.00 96,521.77 767,150.66 6.07 11,868,949.34 6-11-2009 02:97 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Mayor & Council DEPARTMENTAL EXPENDITURES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-4104 PERA i01-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 1,950.00 2,900.00 550.00 50.00 43,450.00 3,208.00 16,040.00 41.66 22,960.00 102.07 510.35 26.17 1,439.65 198.90 994.50 41.44 1,405.50 46.52 232.60 42.29 317.40 0.00 19.50 39.00 30.50 3,555.49 17,796.95 40.96 25,653.05 3,200.00 0.00 3,200.00 0.00 772.22 24.13 2,927.78 772.22 24.13 2,927.78 6,750.00 0.00 3,812.16 56.48 2,937.84 800.00 69.95 69.95 8.74 730.05 6,500.00 0.00 212.29 3.27 6,287.76 18,200.00 75.00 6,216.28 34.16 11,983.72 64,800.00 0.00 31,312.00 48.32 33,488.00 15,000.00 500.00 500.00 3.33 19,500.00 9,400.00 67.63 2,221.88 23.64 7,178.12 121,450.00 712.58 44,344.51 36.51 77,105.49 I TOTAL Mayor & Council 168,100.00 4,268.07 62,913.68 37.43 105,186.32 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Cable TV DEPARTMENTAL EXPENDITURES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services i01-4-1120-4101 Regular Pay 50,600.00 101-4-1120-9103 Part-time Pay 11,800.00 101-4-1120-4104 PERA 3,550.00 101-4-1120-4105 FICA 4,000.00 101-4-1120-4107 Medicare 950.00 101-9-1120-4108 Insurance 5,250.00 101-4-1120-4109 Workers Comp 200.00 TOTAL Person al Services 76,350.00 Supplies i01-4-1120-4201 Office Supplies 3,350.00 TOTAL Supplies 3,350.00 Other Services & Charges 101-4-1120-4319 Other Professional Services 500.00 101-4-1120-4322 Postage 100.00 101-4-1120-4331 Travel, Conferences & Schools 1,400.00 ~01-4-1120-4404 Equip Repair/Maint Services 100.00 TOTAL Other Services & Charges 2,100.00 5,628.00 19,135.21 37.82 31,464.79 475.00 1,362.50 11.55 10,437.50 379.89 1,386.83 39.07 2,163.17 375.82 1,349.74 33.74 2,650.26 87.89 315.65 33.23 634.35 438.01 2,190.05 41.72 3,059.95 0.00 86.50 43.25 113.50 7,384.61 25,826.48 33.83 50,523.52 0.00 114.20 3.41 3,235.80 0.00 114.20 3.41 3,235.80 o.oo o.oo o.oo Soo.oo 0.60 0.60 0.60 99.40 0.00 29.79 2.13 1,370.21 0.00 0.00 0.00 100.00 0.60 30.39 1.45 2,069.61 TOTAL Cable TV 81,800.00 7,385.21 25,971.07 31.75 55,828.93 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 i0i-GENERAL FUND General Government Administrative Services DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 91.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1210-4101 Regular Pay i01-4-1210-4102 Overtime Pay 101-4-1210-4103 Part-time Pay 101-4-1210-4104 PERA 101-4-1210-4105 FICA "_O1-4-1210-4106 Other Retirement Contributions 101-4-1210-9107 Medicare i01-4-1210-4108 Insurance 101-4-1210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1210-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1210-4319 Other Professional Services 101-4-1210-4321 Telephone 101-4-1210-9322 Postage 101-4-1210-9331 Travel, Conferences & Schools 101-4-1210-4361 Insurance 101-9-1210-4404 Equip Repair/Maint Services 101-4-1210-4433 Dues & Subscriptions 101-4-1210-9460 Equip Replacement Charge TOTAL Other Services & Charges 296,750.00 33,586.02 114,192.42 38.48 182,557.58 2,000.00 0.00 0.00 0.00 2,000.00 45,600.00 9,852.10 16,912.20 37.09 28,687.80 23,250.00 2,594.58 9,500.24 40.86 13,749.76 21,350.00 2,340.86 8,543.79 40.02 12,806.21 4,800.00 400.00 2,000.00 41.67 2,800.00 5,000.00 547.47 1,998.17 39.96 3,001.83 23,450.00 1,954.03 9,770.15 91.66 13,679.85 1,300.00 0.00 701.00 53.92 599.00 423,500.00 46,275.06 163,617.97 38.63 259,882.03 9,900.00 50.48 1,825.95 18.94 8,074.05 9,900.00 50.48 1,825.95 18.44 8,074.05 4,500.00 0.00 9,860.00 108.00 ( 360.00) 600.00 65.84 270.46 45.08 329.54 1,500.00 70.95 70.95 4.73 1,429.05 5,600.00 166.58 849.98 15.18 4,750.02 200.00 0.00 112.00 56.00 88.00 22,600.00 842.71 5,089.07 22.52 17,510.93 2,600.00 0.00 150.00 5.77 2,450.00 650.00 32.33 161.65 24.87 488.35 38,250.00 1,178.41 11,564.11 30.23 26,685.89 TOTAL Administrative Services 471,650.00 47,503.95 177,008.03 37.53 294,641.97 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Duman Resources DEPARTMENTAL EXPENDITURES 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 101-4-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 101-4-1220-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage ''.O1-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions '_01-9-1220-4940 Miscellaneous TOTAL Other Services & Charges 68,850.00 7,828.86 26,618.12 38.66 42,231.88 45,200.00 5,028.48 17,914.00 39.63 27,286.00 7,700.00 867.87 3,243.80 42.13 4,456.20 7,100.00 791.60 2,962.41 41.72 4,137.59 1,650.00 185.12 692.78 41.99 957.22 5,250.00 438.00 2,190.00 41.71 3,060.00 950.00 0.00 232.50 51.67 217.50 136,200.00 15,139.93 53,853.61 39.59 82,346.39 3,000.00 0.00 1,830.06 61.00 1,169.94 3,000.00 0.00 1,830.06 61.00 1,169.94 3,000.00 0.00 0.00 0.00 3,000.00 350.00 102.71 102.71 29.35 247.29 3,750.00 184.50 202.45 5.40 3,547.55 650.00 0.00 0.00 0.00 650.00 1,000.00 61.75 332.40 33.24 667.60 8,750.00 398.96 637.56 7.29 8,112.44 TOTAL Human Resources 147,950.00 15,488.89 56,321.23 38.07 91,625.77 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Finance DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1310-4101 Regular Pay 101-4-1310-4103 Part-time Pay 101-4-1310-4104 PERA "i01-9-1310-4105 FICA 101-9-1310-4107 Medicare "_01-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-9301 Audit Fees 101-4-1310-9319 Other Professional Services 101-4-1310-4321 Telephone 101-4-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 101-4-1310-4440 Miscellaneous TOTAL Other Services & Charges 284,350.00 31,987.74 108,758.33 38.25 175,591.67 5,150.00 265.00 1,060.00 20.58 4,090.00 19,550.00 2,159.16 7,882.12 40.32 11,667.88 17,950.00 1,902.27 6,842.82 38.12 11,107.18 9,200.00 444.88 1,600.29 38.10 2,599.71 23,450.00 1,954.03 9,770.15 41.66 13,679.85 1,100.00 0.00 590.50 53.68 509.50 355,750.00 38,713.08 136,504.21 38.37 219,245.79 3,850.00 49.85 925.91 24.05 2,929.09 3,850.00 44.85 925.91 24.05 2,924.09 17,300.00 0.00 12,960.00 74.91 4,340.00 48,150.00 0.00 0.00 0.00 48,150.00 850.00 61.40 254.24 29.91 595.76 3,600.00 415.47 415.47 11.54 3,184.53 4,150.00 40.42 2,168.28 52.25 1,981.72 z,ooo.oo o.oo o.oo o.oo z,ooo.oo 10,100.00 0.00 10,094.20 99.94 5.80 1,550.00 0.00 670.00 43.23 880.00 0.00 0.00 92.00 0.00 ( 92.00) 87,700.00 517.29 26,654.19 30.39 61,045.81 TOTAL Finance 447,300.00 39,275.22 169,084.31 36.68 283,215.69 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUATD General Government information Technology DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67$ OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1350-9101 Regular Pay 101-4-1350-4103 Part-time Pay 1C1-4-1350-4104 PERA 101-9-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services Supplies 101-9-1350-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1350-4319 Other Professional Services '~O1-4-1350-4321 Telephone 101-4-1350-4331 Travel, Conferences & Schools 101-4-1350-4404 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 101-4-1350-4560 Equipment TOTAL Capital Outlay TOTAL Information Technology 129,300.00 14,587.56 49,553.94 38.32 79,746.56 12,850.00 0.00 0.00 0.00 12,850.00 9,600.00 984.66 3,591.53 37.41 6,008.47 8,800.00 902.52 3,207.34 36.45 5,592.66 2,050.00 211.06 750.10 36.59 1,299.90 15,350.00 845.46 5,996.08 39.06 9,353.92 550.00 0.00 290.00 52.73 260.00 178,500.00 17,531.26 63,388.49 35.51 115,111.51 23,300.00 1,641.11 3,984.73 14.96 19,815.27 23,300.00 1,641.11 3,984.73 14.96 19,815.27 8,000.00 0.00 330.00 4.13 7,670.00 800.00 51.70 226.50 28.31 573.50 4,500.00 59.95 170.06 3.78 4,329.94 19,950.00 448.00 7,063.20 35.40 12,886.80 33,250.00 559.65 7,789.76 23.43 25,460.24 43,000.00 0.00 4,609.45 10.72 38,390.55 93,000.00 0.00 4,609.45 10.72 38,390.55 278,050.00 19,732.02 79,272.43 28.51 198,777.57 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Legal DEPARTMENTAL EXPENDITURES 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 234,000.00 17,610.75 68,186.00 29.14 165,814.00 234,000.00 17,610.75 68,186.00 29.19 165,814.00 I TOTAL Legal 234,000.00 17,610.75 68,186.00 29.14 165,814.00 I 6-11-2009 02:47 PM 101-GENERAL FUND General Government Community Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services i01-4-1500-4101 Regular Pay 84,550.00 5,952.56 46,135.33 54.57 38,414.67 '~01-4-1500-4104 PERA 5,700.00 401.79 2,385.92 41.86 3,314.08 101-9-1500-4105 FICA 5,300.00 350.87 2,968.45 56.01 2,331.55 101-4-1500-9107 Medicare 1,250.00 82.06 694.25 55.54 555.75 i01-4-1500-4108 Insurance 8,7C0.00 412.54 4,715.58 59.20 3,984.42 101-4-1500-4109 Workers Comp 550.00 0.00 285.00 51.82 265.00 101-4-1500-4110 Re-employment Compensation 18,100.00 0.00 0.00 0.00 18,100.00 TOTAL Personal Services 124,150.00 7,199.82 57,184.53 96.06 66,965.97 Supplies i01-4-1500-4201 Office Supplies 250.00 0.00 32.71 13.08 217.29 TOTAL Supplies 250.00 0.00 32.71 13.08 217.29 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 0.00 646.79 25.36 1,903.21 TOTAL Other Services & Charges 2,550.00 0.00 646.79 25.36 1,903.21 TOTAL Community Development 126,950.00 7,199.82 57,864.03 45.58 69,085.97 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND General Government Planning DEPARTMENTAL EXPENDITURES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services `.O1-4-1510-9101 Regular Pay 101-4-1510-4104 PERA `~O1-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101'-9-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs TOTAL Supplies Other Services & Charges '_O1-4-1510-4319 Other Professional Services 101-4-1510-4321 Telephone 101-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services i01-4-1510-4433 Dues & Subscriptions 101-4-1510-4490 Miscellaneous TOTAL Other Services & Charges 210,300.00 23,742.39 80,235.08 38.15 130,064.92 14,200.00 1,602.60 5,693.33 40.09 8,506.67 13,050.00 1,374.60 4,769.32 36.55 8,280.68 3,050.00 321.49 1,115.48 36.57 1,934.52 28,300.00 2,190.02 10,060.09 35.55 18,239.91 500.00 0.00 311.00 62.20 189.00 269,400.00 29,181.05 102,184.30 37.93 167,215.70 4,850.00 94.33 1,719.99 35.46 3,130.01 850.00 0.00 400.23 47.09 449.77 5,700.00 94.33 2,120.22 37.20 3,579.78 20,000.00 0.00 6,919.34 34.57 13,085.66 800.00 41.85 140.10 17.51 659.90 2,000.00 312.76 312.76 15.64 1,687.24 6,350.00 95.96 497.62 7.84 5,852.38 10,000.00 393.25 1,963.45 19.63 8,036.55 700.00 0.00 0.00 0.00 700.00 5,000.00 117.15 575.82 11.52 4,424.18 1,000.00 0.00 445.00 44.50 555.00 250.00 21.00 67.00 26.80 183.00 46,100.00 981.97 10,916.09 23.68 35,183.91 TOTAL Planning 321,200.00 30,257.35 115,220.61 35.87 205,979.39 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NAY 31ST, 2009 101-GENERAL FUND General Government City Hall Maintenance DEPARTMENTAL EXPENDITURES 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 10i-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay '_O1-4-1600-4103 Part-time Pay 101-4-1600-4104 PERA 101-4-1600-4105 FICA 101-4-1600-4107 Medicare 101-4-1600-4108 Insurance 101-4-1600-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone i01-4-1600-4331 Travel, Conferences & Schools "_01-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 TOTAL Other Services & Charges 83,750.00 10,537.50 37,368.25 44.62 46,381.75 9,100.00 0.00 0.00 0.00 9,100.00 18,450.00 2,780.91 6,509.81 35.28 11,940.19 7,800.00 865.16 3,138.80 40.24 4,661.20 7,150.00 821.99 2,886.54 40.37 9,263.46 1,700.00 192.24 675.09 39.71 1,024.91 1i, 900.00 1,146.29 6,049.08 50.83 5,850.92 2,550.00 0.00 2,137.50 83.82 412.50 142,400.00 16,344.09 58,765.07 41.27 83,634.93 3,750.00 0.00 679.16 18.11 3,070.89 1,700.00 123.30 510.26 30.02 1,189.74 30,000.00 1,448.19 11,600.83 38.67 18,399.17 35,450.00 1,571.49 12,790.25 36.08 22,659.75 15,450.00 875.13 4,582.66 29.66 10,867.34 2,000.00 0.00 1,240.00 62.00 760.00 5,700.00 0.00 2,320.00 40.70 3,380.00 51,800.00 3,245.80 17,879.34 34.52 33,920.66 32,300.00 1,961.14 8,234.64 25.49 24,065.36 1,250.00 0.00 50.66 4.05 1,199.34 108,500.00 6,082.07 34,307.30 31.62 74,192.70 TOTAL City Hall Maintenance 286,350.00 23,997.65 105,862.62 36.97 180,487.38 6-11-2009 02:47 PM 101-GENERAL FUND General Government Contingency DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1900-9440 Miscellaneous TOTAL Other Services & Charges 70,050.00 0.00 0.00 0.00 70,050.00 70,050.00 0.00 0.00 0.00 70,050.00 TOTAL Contingency 70,050.00 0.00 0.00 0.00 70,050.00 I TOTAL General Government 2,633,900.00 212,718.93 912,704.01 34.66 1,720,695.99 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Police Administration DEPARTMENTAL EXPENDITURES 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2110-4101 Regular Pay 279,400.00 31,773.66 108,030.45 38.67 171,369.55 101-4-2110-4104 PERA 39,400.00 9,480.11 16,388.63 41.60 23,011.37 101-4-2110-4105 FICA 0.00 0.00 1,116.38 0.00 ( 1,116.38) 101-4-2110-4107 Medicare 2,550.00 306.93 1,373.59 53.87 1,176.41 101-4-2110-4108 Insurance 23,250.00 1,938.01 9,690.05 41.68 13,559.95 101-9-2110-4109 Workers Comp 48,500.00 0.00 25,940.50 53.49 22,559.50 TOTAL Personal Services 393,100.00 38,498.71 162,539.60 41.35 230,560.40 Supplies 101-4-2110-4201 Office Supplies 16,000.00 635.35 3,123.92 19.52 12,876.08 101-4-2110-4217 Uniform Allowance 2,500.00 163.84 1,343.81 53.75 1,156.19 '_O1-4-2110-4219 Operating Supplies 3,150.00 70.27 269.30 8.55 2,880.70 TOTAL Supplies 21,650.00 869.46 4,737.03 21.88 16,912.97 tither Services & Charges 101-4-2110-4319 Other Professional Services 5,500.00 31.83 690.36 11.64 4,859.64 101-4-2110-4321 Telephone 25,000.00 1,219.SC 7,506.81 30.03 17,493.19 101-4-2110-4322 Postage 2,100.00 375.67 417.73 19.89 1,682.27 101-4-2110-4331 Travel, Conferences & Schools 9,200.00 0.00 723.69 17.23 3,476.31 101-4-2110-4359 Publishing 500.00 112.20 112.20 22.49 387.80 "101-4-2110-4361 Insurance 12,450.00 0.00 4,576.50 36.76 7,873.50 101-4-2110-4409 Equip Repair/Maint Services 69,250.00 805.96 39,569.35 57.14 29,680.65 101-4-2110-4433 Dues & Subscriptions 5,850.00 810.00 3,098.00 52.96 2,752.00 "~O1-4-2110-4937 Taxes & Licenses 500.00 108.50 153.50 30.70 346.50 TOTAL Other Services & Charges 125,350.00 3,463.96 56,798.19 45.31 68,551.86 Capital Outlay 101-9-2110-4560 Equipment 57,600.00 0.00 57,599.00 100.00 1.00 TOTAL Capital Outlay 57,600.00 0.00 57,599.00 100.00 1.00 TOTAL Police Administration 597,700.00 42,832.13 281,673.77 47.13 316,026.23 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Patrol DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 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-9-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Fuels & Lubs i01-9-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-4404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges 1,435,250.00 147,969.42 513,786.40 35.80 921,463.60 90,000.00 7,923.28 15,777.35 17.53 74,222.65 215,050.00 21,980.82 80,071.83 37.23 134,978.17 19,800.00 1,880.35 6,772.58 34.20 13,027.42 150,400.00 12,978.07 64,890.35 43.15 85,509.65 1,910,500.00 192,731.94 681,298.51 35.66 1,229,201.49 95,000.00 186.15 29,929.40 26.24 70,070.60 17,200.00 2.61 737.54 4.29 16,462.46 49,000.00 2,889.60 9,982.78 20.37 39,017.22 25,000.00 843.55 5,578.73 22.31 19,421.27 186,200.00 3,921.91 41,228.45 22.14 144,971.55 14,650.00 260.00 2,374.89 16.21 12,275.11 27,200.00 884.04 5,949.78 21.87 21,250.22 550.00 0.00 230.00 41.82 320.00 43,700.00 2,229.41 11,147.05 25.51 32,552.95 86,100.00 3,373.45 19,701.72 22.88 66,398.28 TOTAL Patrol 2,182,800.00 200,027.30 742,228.68 34.00 1,440,571.32 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Investigations DEPARTMENTAL EXPENDITURES 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay i01-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 Other Services & Charges 101-4-2130-4319 Other Professional Services i01-4-2130-4331 Travel, Conferences & Schools 101-4-2130-4933 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges 995,800.00 53,586.46 179,595.98 36.22 316,204.02 40,000.00 840.53 9,696.76 11.74 35,303.24 75,550.00 7,674.24 27,805.78 36.80 47,744.22 5,600.00 499.89 1,765.47 31.53 3,834.53 58,600.OG 4,919.94 24,574.70 41.94 34,025.30 675,S5C.00 67,516.06 238,438.69 35.30 437,111.31 4,850.00 0.00 219.84 4.43 4,635.16 8,400.00 511.29 760.25 9.05 7,639.75 13,250.00 511.29 975.09 7.36 12,274.91 10,750.00 270.32 965.04 8.98 9,784.96 9,000.00 500.00 1,235.00 30.88 2,765.00 200.00 0.00 50.00 25.00 150.00 10,400.00 521.71 2,608.55 25.08 7,791.45 25,350.00 1,292.03 4,858.59 19.17 20,491.41 TOTAL Investigations 714,150.00 69,319.38 244,272.37 34.20 469,877.63 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NAY 31ST, 2009 101-GENERAL FUND Public Safety Police Support Services DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67$ OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE I Personal Services 101-4-2150-9101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-9331 Travel, Conferences & Schools 101-4-2150-4404 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 346,900.00 39,116.69 133,157.47 38.38 213,742.53 6,500.00 0.00 0.00 0.00 6,500.00 23,850.00 2,640.38 9,647.14 40.45 14,202.86 21,900.00 2,383.06 8,679.88 39.63 13,220.12 5,100.00 557.31 2,029.92 39.80 3,070.08 42,050.00 3,504.02 17,520.10 41.66 24,529.90 446,300.00 48,201.46 171,039.51 38.32 275,265.49 1,000.00 119.25 284.29 28.43 715.71 3,250.00 0.00 53.56 1.65 3,196.49 8,050.00 10.40 2,468.33 30.66 5,581.67 12,300.00 129.65 2,806.18 22.81 9,993.82 3,550.00 10.00 10.00 0.28 3,540.00 5,500.00 0.00 3,675.00 66.82 1,825.00 16,000.00 615.95 2,438.41 15.29 13,561.59 500.00 0.00 222.50 44.50 277.50 7,900.00 396.80 1,984.00 25.11 5,916.00 33,450.00 1,022.75 8,329.91 24.90 25,120.09 TOTAL Police Support Services 492,050.00 49,353.86 182,170.60 37.02 309,879.40 6-11-2009 02:47 PM 1G1-GENERAL FUND Public Safety Police Reserves DEPARTMENTAL EXPENDITURES PAGE: 20 41.67a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services '_O1-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA X01-4-2160-4107 Medicare 101-4-2160-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies Other Services & Charges 10i-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 5,500.00 0.00 0.00 0.00 5,500.00 350.00 0.00 0.00 0.00 350.00 100.00 0.00 0.00 0.00 100.00 0.00 29.07 29.07 0.00 ( 29.07) 5,950.00 29.07 29.07 0.49 5,920.93 5,000.00 24.00 279.00 5.58 4,721.00 6,000.00 320.69 871.88 14.53 5,128.12 11,000.00 344.69 1,150.88 10.96 9,899.12 1,500.00 0.00 0.00 0.00 1,500.00 1,600.00 138.57 592.99 37.06 1,007.01 1,700.00 0.00 O.OC 0.00 1,700.00 0.00 0.00 112.20 0.00 ( 112.20) 1,000.00 0.00 481.00 48.10 519.00 5,800.00 138.57 1,186.19 20.95 4,613.81 TOTAL Police Reserves CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 22,750.00 512.33 2,366.14 10.40 20,383.86 6-11-2009 02:97 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Public safety building DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67$ OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-9107 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-4-2190-4389 Utilities 101-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges 98,200.00 10,873.00 35,184.71 35.83 63,015.29 450.00 0.00 0.00 0.00 450.00 6,650.00 733.93 2,529.92 38.04 4,120.08 6,100.00 659.31 2,274.22 37.28 3,825.78 1,450.00 154.20 531.93 36.68 918.07 14,250.00 1,059.97 9,951.31 34.75 9,298.69 2,200.00 0.00 1,895.50 86.16 304.50 129,300.00 13,480.41 97,367.59 36.63 81,932.41 17,000.00 3,138.06 10,046.96 59.10 6,953.04 17,000.00 3,138.06 10,046.96 59.10 6,953.04 6,900.00 0.00 3,006.50 43.57 3,893.50 18,200.00 1,895.99 5,441.15 29.90 12,758.85 31,300.00 232.12 3,468.00 11.08 27,832.00 56,400.00 2,128.06 11,915.65 21.13 44,984.35 TOTAL Public safety building 202,700.00 18,746.53 69,330.20 39.20 133,369.80 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety 41.67% OF YEAR COMP. Fire Administration CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2310-4101 Regular Pay 90,850.00 28,509.92 55,704.00 61.31 35,146.00 101-4-2310-4103 Part-time Pay 150,350.00 17,276.75 56,459.76 37.55 93,890.24 101-4-2310-9104 PERA 13,250.00 719.09 4,979.82 37.58 8,270.18 101-4-2310-4105 FICA 10,050.00 1,103.03 3,920.91 39.01 6,129.09 i01-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101-4-2310-4107 Medicare 3,500.00 622.82 1,609.21 45.98 1,890.79 101-4-2310-4108 Insurance 9,150.00 373.98 3,786.07 41.38 5,363.93 101-4-2310-4109 Workers Comp 15,350.00 0.00 7,858.00 51.19 7,492.00 i01-4-2310-4110 Re-employment Compensation 0.00 632.04 632.04 0.00 ( 632.09) TOTAL Personal Services 322,500.00 49,237.63 134,949.81 41.84 187,550.19 Supplies 101-4-2310-4201 Office Supplies 1,200.00 51.94 362.98 30.25 837.02 101-4-2310-4212 Fuels & Lubs 7,950.00 42.07 1,160.91 14.60 6,789.09 101-4-2310-4217 Uniform Allowance 1,100.00 0.00 0.00 0.00 1,100.00 101-4-2310-4219 Operating Supplies 32,400.00 373.23 10,737.02 33.14 21,662.98 TOTAL Supplies 42,650.00 967.29 12,260.91 28.75 30,389.09 Other Services & Charges 101-4-2310-9319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-9359 Publishing 101-9-2310-9361 Insurance i01-4-2310-4389 Utilities 101-4-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions 101-4-2310-4960 Equip Replacement Charge TOTAL Other Services & Charges 4,950.00 0.00 2,400.00 48.98 2,550.00 2,700.00 169.92 1,048.95 38.85 1,651.05 500.00 114.57 114.57 22.91 385.43 19,850.00 800.29 3,938.88 19.84 15,911.12 500.00 301.00 301.00 60.20 199.00 21,300.00 0.00 8,728.00 40.98 12,572.00 15,150.00 1,344.36 8,232.85 54.34 6,917.15 4,000.00 159.75 319.50 7.99 3,680.50 20,850.00 1,880.65 9,731.27 22.69 16,118.73 2,000.00 0.00 1,446.50 72.33 553.50 15,250.00 764.20 3,821.00 25.06 11,429.00 107,050.00 5,534.79 35,082.52 32.77 71,967.48 TOTAL Fire Administration 472,200.00 55,239.61 182,293.24 38.61 289,906.76 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Fire Inspections DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 91.67 OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4102 Overtime Pay ~O1-4-2320-4103 Part-time Pay 101-9-2320-9104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-9-2320-4212 Fuels & Lubs 101-4-2320-9217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies 0*_her Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 132,250.00 17,804.36 53,893.49 40.75 78,356.51 2,000.00 0.00 0.00 0.00 2,000.00 0.00 140.50 140.50 0.00 ( 140.50) 14,700.00 1,654.75 6,070.24 41.29 8,629.76 7,600.00 901.94 1,463.70 19.26 6,136.30 1,900.00 255.12 818.54 43.08 1,081.46 13,700.00 1,078.00 5,646.00 41.21 8,054.00 172,150.00 21,334.67 68,032.97 39.52 104,117.53 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 0.00 797.61 26.59 2,202.39 800.00 83.06 83.06 10.38 716.94 4,150.00 27.71 712.02 17.16 3,437.98 9,900.00 110.77 1,592.69 16.09 8,307.31 1,350.00 117.36 500.82 37.10 849.18 150.00 0.00 0.00 0.00 150.00 z,7so.oo o.oo o.oo o.o0 2,7so.oo zoo.oo o.oo o.oo o.o0 200.00 1,850.00 0.00 143.35 7.75 1,706.65 500.00 0.00 70.00 14.00 930.00 6,800.00 117.36 714.17 10.50 6,085.83 TOTAL Fire Inspections 188,850.00 21,562.80 70,339.33 37.25 118,510.67 6-11-2009 02:47 PM 101-GENERAL FUND Public Safety Emergency Management DEPARTMENTAL EXPENDITURES PAGE: 29 41.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Fersonal Services 101-4-2330-4101 Regular Pay '_O1-4-2330-4104 PERA ",01-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Cther Services & Charges 101-9-2330-4321 Telephone 101-4-2330-4322 Postage "101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4359 Publishing 101-4-2330-4389 Utilities 101-4-2330-4404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 9,950.00 3,276.02 5,985.81 60.16 3,964.19 1,400.00 53.06 472.95 33.75 927.55 150.00 45.61 86.58 57.72 63.42 800.00 0.00 256.04 32.01 543.96 12,300.00 3,374.69 6,800.88 55.29 5,499.12 2,500.00 O.OG 0.00 0.00 2,500.00 8,500.00 0.00 399.57 4.70 8,100.43 11,000.00 O.GO 399.57 3.63 10,600.43 1,500.00 88.59 523.51 39.90 976.49 100.00 0.00 0.00 0.00 100.00 1,850.00 0.00 255.60 13.82 1,599.40 500.00 C.00 0.00 0.00 500.00 1,500.00 103.92 956.99 30.46 1,043.06 5,100.00 108.30 2,317.11 45.43 2,782.89 400.00 0.00 200.00 50.00 200.00 10,950.00 300.81 3,753.16 34.28 7,196.84 14,900.00 0.00 0.00 0.00 14,900.00 14,900.00 0.00 0.00 0.00 14,900.00 TOTAL Emergency Management CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 49,150.00 3,675.50 10,953.61 22.29 38,196.39 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Safety Building Safety DEPARTMENTAL EXPENDITURES Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4102 Overtime Pay 101-4-2410-9103 Part-time Pay 101-4-2410-4104 PERA 101-4-2410-4105 FICA i01-4-2410-4107 Medicare 101-4-2910-4108 Insurance 101-4-2910-4109 Workers Comp 101-4-2410-4110 Re-employment Compensation .TOTAL Personal Services Supplies 101-4-2410-4201 Office Supplies 101-4-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2410-4321 Telephone i01-4-2410-4322 Postage i01-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance i01-4-2410-4409 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4960 Equip Replacement Charge TOTAL Other Services & Charges CURRENT BUDGET 375,300.00 500.00 23,450.00 26,950.00 24,750.00 5,800.00 41,600.00 1,400.00 29,350.00 529,100.00 3,000.00 5,950.00 700.00 2,650.00 12,300.00 CURRENT YEAR TO DATE PERIOD ACTUAL 41.67 OF YEAR COMP. ~ OF BUDGET BUDGET BALANCE 35,849.12 184,812.21 49.24 190,487.79 0.00 0.00 0.00 500.00 2,844.00 9,606.40 90.97 13,843.60 2,611.78 11,005.48 40.84 15,944.52 2,255.92 12,095.40 48.87 12,654.60 527.60 2,828.71 48.77 2,971.29 2,939.47 20,896.02 50.23 20,703.98 0.00 658.50 47.04 741.50 0.00 0.00 0.00 29,350.00 47,027.89 241,902.72 45.72 287,197.28 33.65 491.74 16.39 2,508.26 0.00 973.72 16.37 4,976.28 0.00 0.00 0.00 700.00 63.66 1,048.64 39.57 1,601.36 97.31 2,514.10 20.44 9,785.90 6,900.00 169.16 1,500.00 67.74 9,400.00 75.76 16,500.00 0.00 9,400.00 226.00 1,200.00 0.00 2,300.00 126.48 47,200.00 665.14 1,140.45 16.53 5,759.55 67.74 4.52 1,432.26 2,255.08 23.99 7,144.92 14,513.50 87.96 1,986.50 3,635.85 38.68 5,764.15 375.00 31.25 825.00 632.40 27.50 1,667.60 22,620.02 47.92 24,579.98 TOTAL Building Safety 588,600.00 47,790.34 267,036.84 45.37 321,563.16 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MA_Y 31ST, 2009 101-GENERAL FUND Public Safety Environmental DEPARTMENTAL EXPENDITURES 41.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare '_01-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-4201 Office Supplies "~O1-4-2940-4212 Fuels & Lubs 101-9-2440-4217 Uniform Allowance 101-4-2440-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2440-4321 Telephone 101-4-2940-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools "_O1-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4404 Equip Repair/Maint Services 101-4-2440-4409 Contractual Services 101-4-2440-4433 Dues & Subscriptions 101-4-2440-4460 Equip Replacement Charge TOTAL Other Services & Charges 52,200.00 5,901.78 20,444.80 39.17 31,755.20 3,500.00 398.37 1,497.32 42.78 2,002.68 3,200.00 298.93 1,092.93 32.58 2,157.57 750.00 69.93 243.82 32.51 506.18 8,450.00 669.60 3,399.20 40.23 5,050.80 350.00 0.00 196.00 56.00 154.00 68,950.00 7,338.61 26,823.57 39.19 41,626.43 650.00 8.41 95.39 14.68 554.61 200.00 0.00 4.55 2.28 195.45 zoo.oo o.oo o.oo o.oo zoo.oo 0.00 0.00 9.07 0.00 ( 9.07) 1,050.00 8.41 109.01 10.38 940.99 700.00 53.60 203.28 29.04 496.72 500.00 85.22 85.22 17.09 414.78 500.00 0.00 85.00 17.00 415.00 500.00 0.00 0.00 0.00 500.00 300.00 0.00 112.00 37.33 188.00 50.00 0.00 0.00 0.00 50.00 1,500.00 0.00 0.00 0.00 1,500.00 1,050.00 0.00 0.00 0.00 1,050.00 750.00 36.74 183.70 24.49 566.30 5,850.00 175.56 669.20 11.44 5,180.80 TOTAL Environmental 75,350.00 7,522.58 27,601.78 36.63 47,748.22 TOTAL Public Safety 5,586,300.00 516,582.36 2,080,266.56 37.24 3,506,033.44 6-11-2009 C2:47 PM CITY OF ELK RIVER PAGE: 27 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Works Street Maintenance DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67°s OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE Personal Services i01-4-3120-4101 Regular Pay 101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-9107 Medicare 1G1-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-4-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-9-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Insurance 101-4-3120-4389 Utilities 101-4-3120-4401 Bldg Repair/Maint Services 101-4-3120-4409 Equip Repair/Maint Services 101-4-3120-4409 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 TOTAL Other Services & Charges Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay 391,850.00 60,168.72 169,840.02 42.07 227,009.98 10,400.00 0.00 0.00 0.00 10,400.00 78,950.00 6,830.37 19,495.07 29.69 59,454.93 31,050.00 4,406.33 12,839.82 91.35 18,210.18 28,750.00 3,926.35 11,175.41 38.87 17,574.59 6,700.00 918.19 2,613.47 39.01 4,086.53 50,900.00 5,700.27 23,031.30 45.70 27,368.70 20,000.00 0.00 9,845.50 49.23 10,159.50 618,100.00 81,950.23 243,840.59 39.45 374,259.41 4,800.00 186.66 371.96 7.75 4,428.04 82,950.00 1,191.69 12,618.57 15.21 70,331.43 160,000.00 6,972.83 41,489.66 25.93 118,510.34 17,500.00 8,270.94 13,533.34 77.33 3,966.66 265,250.00 16,622.12 68,013.53 25.69 197,236.47 950.00 39.00 152.00 9,450.00 428.55 1,770.11 200.00 18.29 18.29 3,000.00 1,094.69 1,754.49 500.00 0.00 0.00 18,250.00 0.00 7,963.50 33,000.00 3,351.81 15,118.64 6,500.00 0.00 673.69 0.00 264.03 1,658.27 199,000.00 0.00 9,000.38 3,500.00 95.85 383.40 4,850.00 453.11 1,158.38 700.00 0.00 241.25 500.00 0.00 0.00 130,200.00 6,517.73 32,588.65 910,600.00 12,213.06 72,481.05 6,700.00 0.00 2,662.50 6,700.00 0.00 2,662.50 16.00 18.73 9.15 58.48 0.00 43.64 45.81 10.36 0.00 4.52 10.95 23.88 39.46 0.00 17.65 798.00 7,679.89 181.71 1,245.51 500.00 10,286.50 17,881.36 5,826.31 1,658.27) 189,999.62 3,116.60 3,691.62 458.75 500.00 97,611.35 338,118.95 39.74 4,037.50 39.74 4,037.50 TOTAL Street Maintenance 1,300,650.00 110,785.41 386,997.67 29.75 913,652.33 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 28 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Works Snow Removal DEPARTMENTAL EXPENDITURES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-9102 Overtime Pay _O1-9-3130-9104 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 Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 159,150.00 0.00 51,121.00 32.12 108,029.00 12,450.00 0.00 401.74 3.23 12,098.26 11,800.00 0.00 4,843.68 41.05 6,956.32 10,950.00 0.00 4,203.11 38.38 6,796.89 2,550.00 0.00 982.97 38.55 1,567.03 21,300.00 0.00 8,908.07 41.82 12,391.93 6,550.00 0.00 3,497.00 52.63 3,103.00 224,750.00 0.00 73,907.57 32.88 150,842.93 79,000.00 256.95 72,663.28 91.98 6,336.72 79,000.00 256.45 72,663.28 91.98 6,336.72 5,000.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Snow Removal 308,750.00 256.45 146,570.85 47.47 162,179.15 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 29 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Public Works Equipment Services DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 41.67°s OF YEAR COMP. °s OF BUDGET BUDGET BALANCE Personal Services 101-4-3150-4101 Regular Pay i01-4-3150-4102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA i01-9-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3150-4219 Operating Supplies 101-9-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services i01-4-3150-4917 Uniform Rental TOTAL Other Services & Charges TOTAL Equipment Services 165,200.00 18,571.03 61,042.69 36.95 104,157.31 2,500.00 0.00 0.00 0.00 2,500.00 11,300.00 1,253.55 4,348.89 38.49 6,951.16 10,400.00 1,056.69 3,565.34 34.28 6,834.66 2,950.00 247.13 833.85 34.03 1,616.15 23,000.00 1,854.03 8,601.73 37.40 14,398.27 5,250.00 0.00 2,844.00 54.17 2,406.00 220,100.00 22,982.43 81,236.45 36.91 138,863.55 16,350.00 754.83 4,238.33 25.92 12,111.67 9,200.00 139.52 431.42 4.69 8,768.58 25,550.00 894.35 4,669.75 18.28 20,880.25 2,000.00 0.00 0.00 0.00 2,000.00 2,800.00 227.16 961.00 34.32 1,839.00 4,800.00 227.16 961.00 20.02 3,839.00 250,450.00 24,103.94 86,867.20 34.68 163,582.80 6-11-2009 02:97 PM 101-GENERAL FUND Public Works Engineering DEPARTMENTAL EXPENDITURES PAGE: 30 41. 67o OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare i01-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services Supplies i01-4-3300-4201 Office Supplies 101-4-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges i01-4-3300-9303 Engineering Fees i01-4-3300-9319 Other Professional Services 101-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-4-3300-4331 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 49,500.00 0.00 0.00 0.00 49,500.00 3,350.00 0.00 0.00 0.00 3,350.00 3,050.00 O.OC 0.00 0.00 3,050.00 700.00 0.00 0.00 0.00 700.00 7,700.00 O.oo o.oo 0.00 7,700.00 100.00 0.00 84.50 84.50 15.50 64,400.00 0.00 84.50 0.13 64,315.50 850.00 8.41 118.18 13.90 731.82 350.00 0.00 76.08 21.74 273.92 9,850.00 0.00 1,750.00 17.77 8,100.00 11,050.00 8.41 1,944.26 17.60 9,105.74 88,000.00 4,550.94 27,009.52 30.69 60,990.98 20,000.00 1,382.50 6,230.00 31.15 13,770.00 750.00 0.48 3.64 0.49 746.36 200.00 8.24 8.24 4.12 191.76 5,200.00 0.00 60.00 1.15 5,140.00 300.00 O.OC 112.00 37.33 188.00 115,700.00 5,978.90 39,012.30 29.40 81,687.70 TOTAL Engineering 191,150.00 5,987.31 36,041.06 18.85 155,108.94 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 TOTAL Public Works 2,051,000.00 141,133.11 656,476.78 32.01 1,394,523.22 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 31 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Culture & Recreation Parks Department DEPARTMENTAL EXPENDITURES 41.67°s OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-9-5110-4101 Regular Pay 338,150.00 41,943.32 128,601.94 38.03 209,548.56 101-4-5110-4102 Overtime Pay 1,000.00 0.00 0.00 0.00 1,000.00 101-9-5110-4103 Part-time Pay 43,350.00 6,935.89 6,935.89 16.00 36,419.11 101-4-5110-4104 PERA 23,850.00 2,971.87 9,463.99 39.68 14,386.06 101-4-5110-4105 FICA 24,150.00 2,861.90 8,170.15 33.83 15,979.85 101-4-5110-4107 Medicare 5,650.00 669.30 1,910.75 33.82 3,739.25 101-4-5110-4108 Insurance 51,200.00 3,845.48 17,137.27 33.47 34,062.73 101-4-5110-4109 Workers Comp 6,500.00 0.00 3,852.00 59.26 2,698.00 101-4-5110-4110 Re-employment Compensation 0.00 599.56. 599.56 0.00 ( 599.56) TOTAL Personal Services 493,850.00 59,827.32 176,671.00 35.77 317,179.00 Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5110-4319 Other Professional Services 101-4-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-5110-9331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-9389 Utilities 101-4-5110-4401 Bldg Repair/Maint Services 101-4-5110-4404 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Parks Department 31,350.00 41.13 9,315.22 13.76 27,034.78 3,200.00 155.80 1,429.91 44.68 1,770.09 68,550.00 8,814.81 25,661.82 37.44 42,888.18 103,100.00 9,011.74 31,406.95 30.46 71,693.05 0.00 39.00 39.00 0.00 ( 39.00) 3,900.00 401.89 1,520.47 38.99 2,379.53 0.00 6.45 6.45 0.00 ( 6.45) 2,550.00 800.00 1,948.00 76.39 602.00 27,000.00 0.00 11,810.00 43.74 15,190.00 15,050.00 607.72 3,904.96 25.95 11,145.04 5,500.00 0.00 108.75 1.98 5,391.25 13,500.00 0.00 1,737.44 12.87 11,762.56 6,100.00 280.40 280.40 4.60 5,819.60 24,500.00 1,286.36 3,039.43 12.39 21,465.57 38,100.00 1,837.86 9,189.30 24.12 28,910.70 136,200.00 5,259.68 33,579.20 24.65 102,620.80 733,150.00 74,098.74 241,657.15 32.96 491,492.85 6-11-2009 02:47 PM REVENUE 101-GENERAL FUND Culture & Recreation Parks & Rec Admin DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 URRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 1.67a $ OF BUDGET PAGE: 32 F YEAR COMP. BUDGET BALANCE Personal Services 101-4-5210-4101 Regular Pay 335,550.00 37,168.12 126,374.95 37.66 209,175.55 101-4-5210-4102 Overtime Pay 700.00 0.00 0.00 0.00 700.00 10i-4-5210-4103 Part-time Pay 21,150.00 2,987.56 10,500.66 49.65 10,649.34 101-9-5210-4104 PERA 24,150.00 2,671.25 9,889.81 40.95 19,260.19 i01-4-5210-4105 FICA 22,200.00 2,375.77 8,620.45 38.83 13,579.55 101-4-5210-4107 Medicare 5,200.00 555.61 2,016.00 38.77 3,184.00 101-4-5210-4108 Insurance 39,850.00 2,799.97 15,700.39 39.40 24,149.61 101-4-5210-4109 Workers Comp 4,950.00 0.00 1,585.50 32.03 3,364.50 TOTAL Personal Services 453,750.00 48,058.28 174,687.26 38.50 279,062.74 Supplies 101-9-5210-4219 Operating Supplies 12,900.00 773.98 5,679.19 44.02 7,220.81 TOTAL Supplies 12,900.00 773.98 5,679.19 44.02 7,220.81 Cher Services & Charges i01-9-5210-4321 Telephone 4,100.00 319.17 1,450.43 35.38 2,649.57 "i01-4-5210-4322 Postage 6,000.00 158.79 1,766.73 29.45 4,233.27 101-4-5210-4331 Travel, Conferences & Schools 5,650.00 86.99 1,394.20 24.68 4,255.80 101-4-5210-4349 Advertising/Marketing 26,400.00 159.99 10,774.73 40.81 15,625.27 101-4-5210-4361 Insurance 1,500.00 0.00 714.00 47.60 786.00 101-4-5210-4389 Utilities 7,800.00 927.29 6,288.37 80.62 1,511.63 '_01-9-5210-9401 Bldg Repair/Maint Services 14,950.00 877.67 4,955.31 33.15 9,994.69 "101-4-5210-4404 Equip Repair/Maint Services 6,750.00 606.31 2,641.06 39.13 4,108.94 101-4-5210-4933 Dues & Subscriptions 1,650.00 50.00 1,310.00 79.39 340.00 TOTAL Other Services & Charges 74,800.00 3,186.21 31,294.83 41.84 43,505.17 TOTAL Parks & Rec Admin 541,450.00 52,018.47 211,661.28 39.09 329,788.72 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 33 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Culture & Recreation Recreation Programs DEPARTMENTAL EXPENDITURES Personal Services 101-4-5220-9101 Regular Pay 101-9-5220-4103 Part-time Pay 101-4-5220-4104 PERA i01-4-5220-4105 FICA 101-4-5220-4107 Medicare i01-4-5220-4108 Insurance TOTAL Personal Services Supplies i01-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5220-4404 Equip Repair/Maint Services i01-4-5220-4409 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 0.00 1,195.07 0.00 ( 1,195.07) 80,000.00 6,862.10 28,975.66 36.22 51,024.34 1,600.00 341.11 934.03 58.38 665.97 4,500.00 425.99 2,005.10 44.56 2,494.90 1,300.00 99.99 468.98 36.08 831.02 0.00 0.00 290.00 0.00 ( 290.00) 87,400.00 7,728.19 33,868.84 38.75 53,531.16 24,000.00 4,005.88 8,086.74 33.69 15,913.26 29,000.00 4,005.88 8,086.74 33.69 15,913.26 400.00 0.00 0.00 0.00 900.00 47,000.00 9.30 7,659.89 16.30 39,340.11 2,500.00 1,427.00 1,427.00 57.08 1,073.00 3,000.00 666.31 2,159.79 71.83 845.21 52,900.00 2,102.61 11,241.68 21.25 41,658.32 TOTAL Recreation Programs 164,300.00 13,836.68 53,197.26 32.38 111,102.74 6-11-2009 02:97 PM 101-GENERAL FUND Culture & Recreation Concessions DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 34 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MP.Y 3iST, 2009 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 1,028.75 1,219.54 25.67 3,530.46 101-4-5230-4109 PERA 250.00 12.91 25.79 10.32 224.21 101-4-5230-4105 FICA 300.00 63.78 75.61 25.20 224.39 101-4-5230-4107 Medicare 100.00 19.92 17.69 17.69 82.31 TOTAL Personal Services 5,400.00 1,120.36 1,338.63 24.79 4,061.37 Supplies 101-4-5230-4219 Operating Supplies 600.00 35.04 35.04 5.84 564.96 101-4-5230-4259 Other Merchandise For Resale 13,400.00 3,531.64 3,975.34 29.67 9,424.66 TOTAL Supplies 14,000.00 3,566.68 4,010.38 28.65 9,989.62 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 100.00 C.00 0.00 0.00 100.00 TOTAL Concessions 19,500.00 4,687.09 5,349.01 27.43 14,150.99 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 35 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Culture & Recreation Sr Citizen Programs DEPARTMENTAL EXPENDITURES 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services i01-9-5510-4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4104 PERA 101-4-5510-4105 FICA i01-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-9-5510-4389 Utilities 101-9-5510-9401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Sr Citizen Programs 54,950.00 6,124.80 20,824.33 37.90 34,125.67 500.00 0.00 0.00 0.00 500.00 58,700.00 6,611.72 22,556.70 38.43 36,143.30 7,70C.00 859.71 3,142.91 40.82 4,557.09 7,100.00 751.15 2,703.74 38.08 4,396.26 1,650.00 175.69 632.38 38.33 1,017.62 12,400.00 1,034.22 5,171.10 41.70 7,228.90 700.00 0.00 186.00 26.57 514.00 143,700.00 15,557.29 55,217.16 38.43 88,482.84 10,950.00 238.90 3,750.98 34.26 7,199.02 10,950.00 238.90 3,750.98 34.26 7,199.02 2,400.00 205.89 1,029.14 42.88 1,370.86 4,000.00 513.07 1,133.71 28.34 2,866.29 2,400.00 76.17 465.29 19.39 1,934.71 900.00 0.00 775.50 86.17 124.50 8,150.00 840.86 4,200.54 51.54 3,949.46 11,800.00 1,585.08 4,819.64 40.84 6,980.36 8,100.00 ( 11.00)( 352.71) 4.35- 8,452.71 950.00 0.00 62.47 6.58 887.53 38,700.00 3,210.07 12,133.58 31.35 26,566.42 193,350.00 19,006.26 71,101.72 36.77 122,248.28 TOTAL Culture & Recreation 1,651,750.00 163,647.19 582,966.42 35.29 1,068,783.58 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 36 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERAL FUND Economic Development Economic Developement DEPARTMENTAL EXPENDITURES 41.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6210-9101 Regular Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare 101-4-6210-4108 Insurance TOTAL Personal Services Other Services & Charges 101-9-6210-4322 Postage 101-9-6210-4440 Miscellaneous TOTAL Other Services & Charges 0.00 6,111.51 28,279.88 0.00 ( 28,279.88) 0.00 l,G5C.32 2,100.64 0.00 ( 2,100.64) 0.00 437.12 1,956.01 0.00 ( 1,956.01) 0.00 399.87 1,766.89 0.00 ( 1,766.89) 0.00 93.53 913.25 0.00 ( 413.25) 0.00 ( 681.60) 2,174.00 C. 00 ( 2,174.00) 0.00 7,410.75 36,690.67 0.00 ( 36,690.67) 0.00 110.75 0.00 ( 308.30) 0.00 ( 197.55) 110.75 0.00 ( 110.75) 729.51 0.00 ( 724.51) 835.26 0.00 ( 835.26) TOTAL Economic Developement 0.00 7,213.20 37,525.93 0.00 ( 37,525.93) 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 37 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 101-GENERP.L FUND Economic Development Energy City DEPARTMENTAL EXPENDITURES 4i.67o OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6220-4101 Regular Pay 101-4-6220-4104 PERA 101-9-6220-4105 FICA 101-9-6220-9107 Medicare 101-4-6220-4108 Insurance TOTAL Personal Services 0*_her Services & Charges 101-4-6220-4319 Other Professional Services i01-4-6220-4331 Travel, Conferences & Schools 101-4-6220-4359 Publishing TOTAL Other Services & Charges TOTAL Energy City 27,250.00 3,080.37 10,747.68 39.44 16,502.32 1,550.00 207.93 773.79 49.92 776.21 1,500.00 159.52 556.97 37.13 943.03 400.00 37.31 130.25 32.56 269.75 3,600.00 300.01 1,474.94 90.96 2,125.56 34,300.00 3,785.14 13,683.13 39.89 20,616.87 2,000.00 0.00 0.00 0.00 2,000.00 17,000.00 2,607.84 ( 5,701.92) 33.54- 22,701.42 2,500.00 27.70 1,981.84 79.27 518.16 21,500.00 2,635.54 ( 3,719.58) 17.30- 25,219.58 55,800.00 6,420.68 9,963.55 17.86 45,836.45 TOTAL Economic Development 55,800.00 13,633.88 47,489.48 85.11 8,310.52 6-11-2009 02:47 PM 101-GENERAL FUND General Transfers Out DEPARTMENTAL EXPENDITURES Transfers Out 1G1-9-7000-4723 Transfer-Ice Arena 101-4-7000-4724 Transfer - Pinewood 101-4-7000-4730 Transfer-Debt Service TOTAL Transfers Out CITY OF ELK RIVER PAGE: 38 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 100,400.00 0.00 0.00 0.00 100,400.00 62,300.00 0.00 0.00 0.00 62,300.00 66,600.00 0.00 66,600.00 100.00 0.00 229,300.00 0.00 66,600.00 29.09 162,700.00 TOTAL Transfers Out 229,300.00 0.00 66,600.00 29.04 162,700.00 TOTAL General 229,300.00 0.00 66,600.00 29.04 162,700.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,207,550.00 1,047,715.47 4,346,503.25 35.61 7,861,046.75 428,550.00 ( 951,193.70)( 3,579,352.59) 4,007,902.59 6-11-2009 02:47 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 I 221-ICE ARENA FINANCIAL SUMMARY PAGE: 1 41.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET ;. BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena Hockey Skating Concessions TOTAL REVENUES I EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 735,000.00 3,400.85 203,809.04 27.73 531,190.96 70,000.00 ( 15,932.00) 29,276.00 41.82 40,724.00 84,700.00 4,957.00 32,293.40 38.13 52,406.60 73,000.00 1,671.52 31,653.81 93.36 41,346.19 962,700.00 ( 5,902.63) 297,032.25 30.85 665,667.75 847,900.00 73,199.56 229,992.91 27.13 617,907.09 30,150.00 5,304.34 12,883.80 42.73 17,266.20 39,450.00 6,738.59 15,241.88 44.24 19,208.12 50,200.00 1,701.53 20,217.43 40.27 29,982.57 962,700.00 86,894.02 278,336.02 28.91 684,363.98 962,700.00 86,894.02 278,336.02 28.91 684,363.98 0.00 ( 92,796.65) 18,696.23 ( 18,696.23) 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 221-ICE ARENA I REVENUES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a 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-3968 Skate Sharpening 221-3-0000-3475 Building Rert 221-3-0000-3482 Advertising fee TOTAL Charges for Services Ocher Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 221-3-0000-3921 Transfers 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 TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3965 Admissions TOTAL Charges for Services 432,000.00 1,446.04 170,186.22 39.39 261,813.78 33,000.00 0.00 12,394.00 37.56 20,606.00 15,000.00 833.32 7,063.32 47.09 7,936.68 9,500.00 92.00 2,512.00 55.82 1,988.00 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 75.00 865.00 4.68 17,635.00 505,600.00 2,946.36 193,020.54 38.18 312,579.46 22,000.00 905.38 6,476.95 29.44 15,523.05 0.00 0.00 3,493.00 0.00 ( 3,493.00) 2,000.00 49.11 868.55 43.43 1,131.45 24,000.00 954.99 10,788.50 44.95 13,211.50 100,000.00 0.00 0.00 0.00 100,000.00 105,400.00 0.00 0.00 0.00 105,400.00 205,400.00 0.00 0.00 0.00 205,400.00 735,000.00 3,400.85 203,809.04 27.73 531,190.96 70,000.00 ( 15,932.00) 29,276.00 91.82 40,724.00 70,000.00 ( 15,932.00) 29,276.00 41.82 40,729.00 70,000.00 ( 15,932.OC) 29,276.00 91.82 40,724.00 89,700.00 ( 89.40) 27,247.00 32.17 57,453.00 0.00 3,586.00 3,586.00 0.00 ( 3,586.00) 84,700.00 3,996.60 30,833.00 36.40 53,867.00 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 221-ICE ARENA I REVENUES 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 1,460.40 1,460.40 0.00 ( 1,460.40) TOTAL Other Revenue 0.00 1,960.40 1,460.40 0.00 ( 1,460.40) TOTAL Skating 84,700.00 4,957.00 32,293.40 38.13 52,406.60 Concessions Charges for Services 221-3-5430-3467 Concessions 73,000.00 1,671.52 31,653.81 43.36 41,396.19 TOTAL Charges for Services 73,000.00 1,671.52 31,653.81 43.36 41,346.19 TOTAL Concessions 73,000.00 1,671.52 31,653.81 43.36 41,346.19 TOTAL REVENUE 962,700.00 ( 5,902.63) 297,032.25 30.85 665,667.75 ~ 6-11-2009 02:47 PM 221-ICE ARENA Culture & Recreation Ice Arena DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 41.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5400-4101 Regular Pay 150,300.00 14,608.98 63,390.47 42.18 86,909.53 221-4-5400-4102 Overtime Pay 0.00 6.38 6.38 0.00 ( 6.38) 221-4-5400-4103 Part-time Pay 72,850.00 6,123.16 27,769.78 38.12 45,080.22 221-4-5400-9104 PERA 11,350.00 1,378.21 6,179.51 54.45 5,170.49 221-4-5400-4105 FICA 14,150.00 1,276.23 6,049.31 42.72 8,105.69 221-9-5400-4107 Medicare 3,300.00 298.97 1,413.58 42.84 1,886.42 221-4-5400-4108 Insurance 16,600.00 1,124.56 7,478.26 45.05 9,121.74 221-4-5400-4109 Workers Comp 4,350.00 0.00 2,233.00 51.33 2,117.00 TOTAL Personal Services 272,90C.00 24,815.99 119,515.29 4i. 96 158,384.71 Supplies 221-4-5400-4212 Fuels & Lubs 300.00 221-9-5900-4217 Uniform Allowance 1,500.00 221-4-5400-4219 Operating Supplies 41,100.00 221-4-5400-4255 Soft Drinks/Misc 13,500.00 221-4-5400-4259 Other Merchandise For Resale 1,200.00 TOTAL Supplies 57,600.00 Other Services & Charges 221-9-5900-4321 Telephone 2,900.00 221-4-5400-4322 Postage SOC.00 221-4-5400-4331 Travel, Conferences & Schools 1,050.00 221-4-5400-4359 Publishing 2,000.00 221-4-5400-4361 Insurance 9,000.00 221-4-5400-4389 Utilities 175,850.00 221-4-5400-4901 Bldg Repair/Maint Services 19,750.00 221-4-5400-4409 Contractual Services 2,000.00 221-4-5400-4415 Equipment Rental 5,400.00 221-4-5400-4433 Dues & Subscriptions 450.00 TOTAL Other Services & Charges 218,900.00 Capital Outlay 221-4-5400-9520 Buildings & Structures 100,000.00 TOTAL Capital Outlay 100,000.00 Transfers Out 0.00 ( 202.93) 67.64- 502.93 0.00 87.50 5.83 1,412.50 3,925.05 8,266.42 20.11 32,833.58 2,563.60 4,411.93 32.68 9,088.07 0.00 221.85 18.49 978.15 5,988.65 12,784.77 22.20 44,815.23 223.04 948.89 32.72 1,951.11 51.84 60.78 12.16 439.22 0.00 149.00 14.19 901.00 1,053.42 2,046.06 102.30 ( 96.06) 0.00 4,097.50 44.97 4,952.50 19,405.85 63,062.66 35.86 112,787.34 1,473.70 6,675.01 33.80 13,079.99 65.41 103.01 5.15 1,896.99 846.66 1,187.44 21.99 4,212.56 0.00 187,50 41.67 262.50 18,119.92 78,467.85 35.85 140,432.15 o.oc 0.00 o.oo o.o0 100,000.00 0.00 0.00 100,000.00 221-4-5400-4730 Transfer-Debt Service 198,500.00 24,225.00 24,225.00 12.20 174,275.00 TOTAL Transfers Out 198,500.00 24,225.00 24,225.00 12.20 174,275.00 TOTAL Ice Arena 847,900.00 73,149.56 229,992.91 27.13 617,907.09 6-11-2009 02:97 PM 221-ICE ARENA Culture & Recreation Hockey DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 PAGE: 5 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5410-4103 Part-time Pay 221-9-5410-4105 FICA 221-4-5410-4107 Medicare TOTAL Personal Services Supplies 221-4-5410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5410-4322 Postage 221-9-5410-4359 Publishing 221-9-5410-4409 Contractual Services 221-9-5410-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Hockey 3,600.00 0.00 154.00 4.28 3,446.00 200.00 0.00 9.55 4.78 190.45 50.00 0.00 2.23 4.46 47.77 3,850.00 0.00 165.78 4.31 3,684.22 14,850.00 1,980.20 7,200.60 48.49 7,649.40 19,850.00 1,480.20 7,200.60 48.99 7,649.40 500.00 0.00 0.00 0.00 500.00 1,700.00 0.00 0.00 0.00 1,700.00 7,050.00 3,813.20 9,128.40 58.56 2,921.60 2,200.00 10.94 1,389.02 63.14 810.98 11,450.00 3,829.14 5,517.42 48.19 5,932.58 30,150.00 5,304.34 12,883.80 42.73 17,266.20 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 221-ICE ARENA Calture & Recreation Skating DEPARTMENTAL EXPENDITURES 41.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-9-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5920-4322 Postage 221-4-5420-9359 Publishing 221-4-5420-4409 Contractual Services 221-9-5420-4438 Credit Card Fees TOTAL Other Services ~ Chases 20,000.00 3,760.34 9,013.36 45.07 10,986.64 500.00 185.89 428.60 85.72 71.40 1,250.00 233.14 575.90 46.07 674.10 300.00 59.50 139.67 44.89 165.33 22,050.00 4,233.87 10,152.53 46.04 11,897.47 6,000.00 2,384.45 2,939.94 49.00. 3,060.06 6,000.00 2,389.45 2,939.94 99.00 3,060.06 200.00 0.00 0.00 0.00 zoo.oo 1,300.00 0.00 0.00 0.00 1,300.00 2,450.00 96.85 1,409.78 57.54 1,040.22 2,950.00 23.42 739.63 30.19 1,710.37 6,400.00 120.27 2,149.41 33.58 4,250.59 TOTAL Skating 34,450.00 6,738.59 15,241.88 94.24 19,208.12 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 221-ICE ARENA Culture & Recreation Arena Concessions DEPARTMENTAL EXPENDITURES 41.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 484.49 6,780.08 32.44 14,119.92 221-4-5430-4104 PERA 0.00 26.83 177.00 0.00 ( 177.00) 221-4-5430-4105 FICA 1,300.00 30.04 440.72 33.90 859.28 221-4-5430-4107 Medicare 300.00 7.03 103.07 34.36 196.93 TOTAL Personal Services 22,500.00 548.39 7,500.87 33.34 14,999.13 Supplies 221-4-5430-4219 Operating Supplies 6,700.00 8.i0 711.28 10.62 5,988.72 221-4-5430-4259 Other Merchandise For Resale 21,000.00 1,145.04 12,005.28 57.17 8,994.72 TOTAL Supplies 27,700.00 1,153.14 12,716.56 45.91 14,983.44 ' TOTAL Arena Concessions 50,200.00 1,701.53 20,217.43 40.27 29,982.57 I TOTAL Culture & Recreation 962,700.00 86,894.02 278,336.02 28.91 684,363.98 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 962,700.00 86,894.02 278,336.02 28.91 684,363.98 0.00 ( 92,796.65) 18,696.23 ( 18,696.23) E-11-2009 02:97 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 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 254,800.00 38,175.42 76,415.00 29.99 178,385.00 TOTAL REVENUES 254,800.00 ------------ --- ------------ --- 38,175.92 -------- -------- 76,415.00 ------------- ------------- 29.99 ------- ------- 178,385.00 ---------- ----------- EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 254,800.00 54,205.61 100,175.96 39.32 154,624.04 254,800.00 54,205.61 100,175.96 39.32 154,624.04 254,800.00 54,205.61 100,175.96 39.32 159,624.04 0.00 ( 16,030.19)( 23,760.96) 23,760.96 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 ^ 222-PINEWOOD GOLF COURSE ~ REVENUES ~ 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-3976 Green Fees 222-3-0000-3977 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments 222-3-0000-3482 Advertising fee TOTAL Charges for Services Sales 222-3-0000-3792 Cash Over TOTAL Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course 41.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 20,000.00 5,924.98 15,976.98 79.88 4,023.02 19,000.00 2,880.13 4,146.62 21.82 14,853.38 4,000.00 1,183.95 1,839.35 45.98 2,160.65 112,000.00 21,729.77 39,375.82 30.69 77,624.18 18,000.00 2,165.00 14,230.00 79.06 3,770.00 19,000.00 3,079.00 4,634.00 24.39 14,366.00 0.00 1,168.51 1,168.51 0.00 ( 1,168.51) 500.00 50.00 50.00 10.00 450.00 192,500.00 38,181.34 76,421.28 39.70 116,078.72 0.00 ( 5.92)( 6.28) 0.00 6.28 0.00 ( 5.92)( 6.28) 0.00 6.28 62,300.00 0.00 0.00 0.00 62,300.00 62,300.00 0.00 0.00 0.00 62,300.00 254,800.00 38,175.42 76,415.00 29.99 178,385.00 ^ TOTAL REVENUE 254,800.00 38,175.42 76,415.00 29.99 178,385.00 6-11-2009 02:47 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2009 222-PINEWOOD GOLF COURSE Culture & Recreation Golf Course DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 41.67a OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Personal Services 222-4-5300-4101 Regular Pay 89,300.00 10,820.03 36,070;98 40.39 53,229.02 222-4-5300-4102 Overtime Pay 100.00 0.00 169.38 169.38 ( 69.38) 222-9-5300-4103 Part-time Pay 28,650.00 3,792.56 3,995.06 13.94 24,654.99 222-9-5300-4104 PERA 8,100.00 834.54 2,734.66 33.76 5,365.34 222-4-5300-4105 FICA 7,450.00 890.33 2,636.79 35.39 4,813.21 222-4-5300-4107 Medicare 1,750.00 208.24 616.71 35.24 1,133.29 222-4-5300-4108 Insurance 9,200.00 876.00 4,090.00 49.46 5,110.00 222-4-5300-4109 Workers Comp 1,050.00 0.00 588.00 56.00 462.00 TOTAL Person al Services 195,600.00 17,921.70 50,901.58 34.96 94,698.42 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 607.72 607.72 12.15 9,392.28 222-4-5300-4217 Uniform Allowance 500.00 0.00 328.93 65.79 171.07 222-4-5300-4219 Operating Supplies 25,100.00 2,509.08 5,072.20 20.21 20,027.80 222-4-5300-4259 Other Merchandise For Resale 10,800.00 2,896.94 4,238.26 39.24 6,561.74 TOTAL Supplies 41,400.00 6,013.74 10,247.11 24.75 3i, 152.89 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 221.63 659.73 26.39 1,840.27 ^<22-9-5300-4331 Travel, Conferences & Schools 90C.00 0.00 326.33 81.58 73.67 222-4-5300-4349 Advertising/Marketing 1,500.00 9.75 159.75 10.65 1,390.25 222-4-5300-4361 Insurance 11,550.00 0.00 5,146.50 44.56 6,403.50 222-4-5300-4389 Utilities 6,800.00 311.03 1,225.89 18.03 5,579.11 222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 19.97 79.88 3.99 1,920.12 222-4-5300-9404 Equip Repair/Maint Services 2,500.00 8.80 836.85 33.47 1,663.15 222-4-5300-4415 Equipment Rental 36,050.00 598.08 598.08 1.66 35,451.92 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 119.48)( 1,318.31> 131.83- 2,318.31 222-4-5300-4938 Credit Card Fees 3,500.00 750.91 927.09 26.49 2,572.91 TOTAL Other Services & Charges 67,800.00 1,800.69 8,641.79 12.75 59,158.21 Debt Service 222-4-5300-9601 Principal 0.00 28,969.48 30,385.48 0.00 ( 30,385.98) TOTAL Debt Service 0.00 28,969.48 30,385.48 0.00 ( 30,385.48) TOTAL Golf Course 254,800.00 59,205.61 100,175.96 39.32 154,624.04 I TOTAL Culture & Recreation 254,800.00 54,205.61 100,175.96 39.32 159,624.04 TOTAL EXPENDITURES 254,800.00 54,205.61 100,175.96 39.32 154,624.04 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 16,030.19)( 23,760.96) 23,760.96 6-11-2009 02:48 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: MAY 31ST, 2009 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT CURRENT BALANCE ACTIVITY BALANCE 002-1010 Cash - Section 125 101-1010 Cash - General Fund 21i-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 240-1010 Cash - Micro Loan Fund 241-1010 Cash - DTED Loan 295-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 - NSP/RDF 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 330-1010 Cash - 1997 City Hall Bonds 331-1010 Cash - 1994C Storm Sewer Bonds 333-1010 Cash - 2002A Pub Safety Bonds 340-1010 Cash - Equipment Certificates 343-1010 Cash - 1996C Ice Arena Bonds 375-1010 Cash - TIF #19 East Elk River 401-1010 Cash - Capital Projects 403-1010 Cash - Street Improvement Resr 404-1010 Cash - Surface Water Managemnt 405-1010 Cash - NE Area Trunk Utilities 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 490-1010 Cash - Park Improvement 459-1010 Cash - TIF #19 Highway 169 462-1010 Cash - TIF #22 Downtown Redev 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 31,591.11 ( 823.38) 30,767.73 2,524,540.26 ( 920,464.83) 1,604,075.43 388,681.60 ( 2,844.95) 385,836.65 140,333.04 ( 91,918.31) 48,414.73 ( 5,765.26) ( 16,217.36) ( 21,982.62) 10,441.62 ( 350.65) 10,090.97 ( 101,428.75) 42,296.70 ( 59,132.05) 1,393,020.25 ( 4,240.12) 1,338,780.13 665,409.34 2,604.72 668,014.C6 790,639.19 14,941.96 805,581.15 150,773.88 590.20 151,369.08 77,655.05 303.94 77,958.99 1,395,092.00 4,797.93 1,399,889.93 554,866.96 ( 7,018.87) 547,848.09 2,062,098.76 8,072.07 2,070,170.83 11,493.92 489.50 11,978.42 138,478.51 542.04 139,020.55 713,243.49 ( 39,673.57) 673,569.92 20,000.00 0.00 20,000.00 133,935.60 524.24 134,459.84 111,834.10 437.76 112,271.86 170,145.85 5,886.41 176,032.26 333.69 0.00 333.69 76,981.22 301.33 77,282.55 184,309.72 721.53 185,031.25 10,699.62 41.88 10,741.50 0.00 3,420.00 3,420.00 ( 77,731.25) 0.00 ( 77,731.25) 2,001,816.71 8,647.25 2,010,463.96 2,816,870.72 2,668.29 2,819,538.96 185,747.95 660.09 186,907.54 266,995.20 1,045.16 268,040.36 3,908,433.30 13,342.25 3,421,775.55 1,029,984.22 ( 36,573.52) 993,410.70 1,796,191.39 7,031.18 1,803,222.57 ( 143,547.59) 35,730.34 ( 107,817.25) ( 3,639.46) 1,869.16 ( 1,770.30) 732,990.06 0.00 732,990.06 ( 997.50) 0.00 ( 997.50) 3,668,332.54 ( 67,776.00) 3,600,556.54 3,505,911.83 115,015.44 3,620,927.27 330,247.43 ( 8,389.75) 321,857.68 122,231.43 ( 5,676.05) 116,555.38 31,239,291.25 ( 929,991.04) 30,309,250.21