Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 05-17-2010
t~.ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: May 17, 2010 SUBJECT: April 2010 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Pinewood Golf and Ice Arena special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of April, actual revenues (except for property taxes and state aids) and expenditures should run slightly over 33% 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 Kevenues: • Excluding transfers in, revenue collections axe about 4.4% of budget. Property taxes, our largest revenue source, will be received in July and December. • Licenses and permits are slightly below budget estimates at 29.8%. • Charges for services include the annual fire contracts which are lower than budget estimates due to a decrease in the percentage of fire calls for Otsego in 2009. • 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.>cpenditures: • Excluding transfers out, the total departmental expenditures are at about 28% and most departments axe 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 $119,710. Excluding transfers, revenues are about 45% of budget due mainly to ice rental, hockey program registrations and concessions while expenditures are about 32% of budget. Pinewood Golf For the month ended April, expenditures exceed revenues by $6,029. Excluding transfers, golf revenues collected through April account for 21% of budget estimates while expenditures axe about 20% of budget, which includes the first of six monthly lease payments on the golf carts and liability insurance paid through June 30. 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) ,~ ~ or<t~~" ' AS OF: APRIL 30TH, 2010 ~~ ~ ~ .~M.ie~'' a e ~~~ ~tt .. ~" ' 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 11,720,800.00 214,120.36 594,563.40 5.07 11,126,236.60 TOTAL REVENUES 11,720,800.00 214,120.36 599,563.40 5.07 11,126,236.60 EXPENDITURE SUMMARY General Government Mayor & Council 167,650.00 4,571.77 57,814.18 34.49 109,835.82 Cable TV 81,650.00 7,626.34 21,654.40 26.52 59,995.60 Administrative Services 470,500.00 51,359.97 148,305.15 31.52 322,194.85 Human Resources 150,450.00 15,436.66 47,563.03 31.61 102,886.97 Elections 38,100.00 192.26 192.26 0.37 37,957.74 Finance 947,400.00 52,578.75 192,284.25 31.80 305,115.75 Information Technology 303,150.00 21,542.90 67,705.14 22.33 235,494.86 Legal 234,000.00 5,853.30 31,670.30 13.53 202,329.70 Community Development 67,150.00 7,428.96 21,041.68 31.34 46,108.32 Planning 299,950.00 33,093.47 90,784.57 30.27 209,165.43 City Hall Maintenance 297,000.00 26,354.26 89,212.11 30.04 207,787.89 Contingency 113,100.00 0.00 435.90 0.39 112,664.10 TOTAL General Government 2,670,100.00 225,938.64 718,612.97 26.91 1,951,487.03 Public Safety Police Administration 543,800.00 47,773.62 193,894.26 35.66 349,905.74 Patrol 2,245,150.00 226,733.63 635,184.70 28.29 1,609,965.30 Investigations 731,350.00 74,359.80 211,760.63 28.95 519,589.37 Police Support Services 501,900.00 46,639.73 191,368.18 28.17 360,531.82 Police Reserves 22,900.00 139.67 1,438.85 6.28 21,461.15 Public safety building 206,250.00 19,680.29 64,664.36 31.35 141,585.64 Fire Administration 465,550.00 45,656.45 134,223.65 28.83 331,326.35 Fire Inspections 184,600.00 18,854.17 53,616.63 29.04 130,983.37 Emergency Management 30,800.00 1,377.53 4,552.37 14.78 26,297.63 Building Safety 465,550.00 49,231.98 192,875.36 30.69 322,674.64 Environmental 52,200.00 5,306.91 15,493.59 29.68 36,706.41 TOTAL Public Safety 5,450,050.00 535,753.78 1,599,072.58 29.34 3,850,977.42 Public Works Street Maintenance 1,336,950.00 111,788.31 307,733.75 23.02 1,029,216.25 Snow Removal 296,550.00 5,728.86 162,465.10 65.90 84,084.90 Equipment Services 246,300.00 25,003.75 70,436.77 28.60 175,863.23 Engineering 178,350.00 2,466.44 9,457.51 5.30 168,892.49 TOTAL Public Works 2,008,150.00 144,987.36 550,093.13 27.39 1,458,056.87 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % 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 767,150.00 59,746.43 198,285.15 25.85 568,864.85 543,300.00 58,703.06 163,782.89 30.15 379,517.16 174,550.00 8,095.88 22,079.31 12.65 152,470.69 13,850.00 95.96 1,530.65 11.05 12,319.35 203,250.00 17,134.05 52,570.41 25.86 150,679.59 1,702,100.00 143,775.38 438,248.36 25.75 1,263,851.64 0.00 ( 8,689.89) 19,766.18 0.00 ( 19,766.18) 51,350.00 5,594.01 5,123.18 9.98 46,226.82 51,350.00 ( 3,095.88) 24,889.36 48.47 26,460.64 164,050.00 0.00 0.00 0.00 164,050.00 169,050.00 0.00 0.00 0.00 164,050.00 12,045,800.00 ------------- - 1,097,359.28 ----------- 3,330,916.40 ------------- 27.65 ------- 8,714,883.60 ------------ ( 325,000.00)( 833,238.92)( 2,736,353.00) 2,911,353.00 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND REVENUES 33.33°s OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3123 Franchise 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 9,688,950.00 0.00 36.79 0.00 9,688,913.21 135,000.00 3,382.74 3,382.74 2.51 131,617.26 0.00 0.00 42,659.70 0.00 ( 92,659.70) 9,823,950.00 3,382.74 46,079.23 0.47 9,777,870.77 51,000.00 5,950.00 5,990.00 11.75 45,010.00 1,000.00 0.00 0.00 0.00 1,000.00 3,000.00 87.50 87.50 2.92 2,912.50 15,850.00 3,090.00 6,705.00 42.30 9,145.00 20,000.00 0.00 20,932.65 104.66 ( 932.65) 3,000.00 60.00 825.00 27.50 2,175.00 13,000.00 705.00 10,775.00 82.88 2,225.00 2,000.00 175.00 1,225.00 61.25 775.00 135,000.00 6,683.50 26,670.00 19.76 108,330.00 40,000.00 2,700.03 9,203.61 23.01 30,796.39 200.00 ( 397.30) 313.13 156.57 ( 113.13) 3,000.00 212.00 812.00 27.07 2,188.00 2,000.00 120.00 680.00 34.00 1,320.00 10,000.00 2,000.00 4,840.00 48.40 5,160.00 299,050.00 21,385.73 89,058.89 29.78 209,991.11 Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3322 MV Credit ( 221,100.00) 0.00 0.00 0.00 ( 221,100.00) 101-3-0000-3324 PERA Aid 19,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2% Aid 200,000.00 0.00 0.00 0.00 200,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3327 State-Aid Street Maint 39,000.00 0.00 28,905.39 79.12 10,094.61 101-3-0000-3329 State Crime Prevention Grant 13,000.00 4,324.83 4,324.84 33.27 8,675.16 101-3-0000-3330 Other State Grants 4,900.00 0.00 0.00 0.00 4,900.00 101-3-0000-3341 County Reimb/Grant 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Intergovernmental Rev 67,800.00 4,324.83 33,230.23 49.01 34,569.77 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 2,095.00 7,596.00 50.64 7,904.00 101-3-0000-3413 Plan Check Fee 50,000.00 889.82 10,157.21 20.31 39,842.79 101-3-0000-3415 Special Assessment Search 500.00 40.00 920.00 84.00 80.00 101-3-0000-3417 Copies 1,500.00 254.09 758.35 50.56 741.65 101-3-0000-3918 Other General Govt Services 4,000.00 301.25 810.00 20.25 3,190.00 101-3-0000-3430 Lockout Fees 8,000.00 700.00 2,750.00 34.38 5,250.00 101-3-0000-3431 Police Services 2,000.00 100.00 737.25 36.86 1,262.75 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 50.00 600.00 20.00 2,400.00 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND REVENUES 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 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-3975 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3984 Contractor License Check TOTAL Charges for Services Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinanace Violations TOTAL Fines & Forfeits 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-3999 Transfer-HRA TOTAL Transfers In TOTAL General Fund 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 185,000.00 124,359.00 124,359.00 67.22 60,641.00 1,000.00 0.00 0.00 0.00 1,000.00 25,000.00 4,833.46 6,215.46 24.86 18,784.54 114,200.00 20,779.87 66,292.08 58.01 47,957.92 14,100.00 609.09 1,593.81 11.30 12,506.19 18,000.00 8,572.54 8,698.33 48.32 9,301.67 4,300.00 ( 82.72) 2,630.30 61.17 1,669.70 7,800.00 200.00 2,150.00 27.56 5,650.00 2,500.00 260.00 1,040.00 41.60 1,460.00 300.00 45.00 120.00 40.00 180.00 531,200.00 169,006.90 274,377.79 51.65 256,822.21 125,000.00 16,125.79 36,503.69 29.20 88,496.31 10,000.00 170.00 5,305.00 53.05 4,695.00 0.00 50.00 50.00 0.00 ( 50.00) 135,000.00 16,345.79 41,858.69 31.01 93,141.31 160,000.00 0.00 ( 10,201.91) 6.38- 170,201.91 72,000.00 85.16 2,893.11 4.02 69,106.89 23,200.00 3,668.00 9,298.00 90.08 13,902.00 3,000.00 921.71 3,969.37 132.31 ( 969.37) 258,200.00 4,674.87 5,958.57 2.31 252,241.93 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 D.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 206,000.00 0.00 104,000.00 50.49 102,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 605,600.00 0.00 104,000.00 17.17 501,600.00 11,720,800.00 214,120.36 594,563.40 5.07 11,126,236.60 TOTAL REVENUE 11,720,800.00 214,120.36 594,563.40 5.07 11,126,236.60 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND DEPARTMENTAL EXPENDITURES 33.338 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 101-4-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-9201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-9322 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,208.00 12,832.00 33.33 25,668.00 1,950.00 100.41 401.64 20.60 1,548.36 2,400.00 162.73 632.32 26.35 1,767.68 550.00 46.52 186.08 33.83 363.92 50.00 0.00 22.00 94.00 28.00 43,950.00 3,517.66 14,074.04 32.39 29,375.96 2,800.00 0.00 169.13 6.04 2,630.87 2,800.00 0.00 169.13 6.04 2,630.87 10,750.00 0.00 3,177.94 29.56 7,572.06 500.00 39.74 39.74 7.95 460.26 3,100.00 66.40 203.26 6.56 2,896.74 18,200.00 0.00 2,882.08 15.84 15,317.92 68,050.00 0.00 34,533.50 50.75 33,516.50 15,500.00 500.00 500.00 3.23 15,000.00 5,300.00 447.97 2,234.49 42.16 3,065.51 121,400.00 1,054.11 43,571.01 35.89 77,828.99 TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4109 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 167,650.00 9,571.77 57,814.18 34.49 109,835.82 52,000.00 5,877.60 15,869.53 30.52 36,130.47 11,750.00 409.38 1,218.77 10.37 10,531.23 3,650.00 411.42 1,229.37 33.68 2,420.63 3,950.00 387.82 1,164.38 29.48 2,785.62 900.00 90.71 272.35 30.26 627.65 5,500.00 449.00 1,796.00 32.65 3,704.00 200.00 0.00 88.50 44.25 111.50 77,950.00 7,625.93 21,638.90 27.76 56,311.10 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 5-12-2010 09:42 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES PAGE: 6 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1120-4319 Other Professional Services 101-4-1120-4322 Postage 101-4-1120-4331 Travel, Conferences & Schools 101-4-1120-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 500.00 0.00 0.00 0.00 500.00 50.00 0.41 0.91 0.82 49.59 1,700.00 0.00 15.09 0.89 1,684.91 450.00 0.00 0.00 0.00 450.00 2,700.00 0.41 15.50 0.57 2,684.50 TOTAL Cable TV 81,650.00 7,626.34 21,654.40 26.52 59,995.60 Administrative Services Personal Services 101-4-1210-9101 Regular Pay 295,100.00 33,897.67 91,523.72 31.01 203,576.28 101-4-1210-9103 Part-time Pay 44,900.00 4,812.00 13,162.84 29.32 31,737.16 101-4-1210-4104 PERA 23,800.00 2,709.69 8,110.07 34.08 15,689.93 101-4-1210-4105 FICA 21,100.00 2,327.92 6,923.55 32.81 19,176.95 101-4-1210-4106 Other Retirement Contributions 4,800.00 400.00 1,600.00 33.33 3,200.00 101-4-1210-4107 Medicare 4,950.00 594.45 1,619.27 32.71 3,330.73 101-4-1210-4108 Insurance 24,600.00 2,250.01 9,000.04 36.59 15,599.96 101-4-1210-4109 Workers Comp 1,500.00 0.00 802.00 53.47 698.00 TOTAL Person al Services 420,750.00 46,941.74 132,741.49 31.55 288,008.51 Supplies 101-4-1210-4201 Office Supplies 13,000.00 2,726.21 3,817.07 29.36 9,182.93 TOTAL Suppli es 13,000.00 2,726.21 3,817.07 29.36 9,182.93 Other Services & Charges 101-4-1210-4319 Other Professional Services 5,100.00 0.00 5,088.00 99.76 12.00 101-4-1210-4321 Telephone 900.00 62.23 183.08 20.34 716.92 101-4-1210-9322 Postage 1,500.00 164.49 164.49 10.97 1,335.51 101-4-1210-4331 Travel, Conferences & Schools 5,350.00 347.52 1,683.77 31.47 3,666.23 101-4-1210-9361 Insurance 250.00 0.00 46.50 18.60 203.50 101-4-1210-4404 Equip Repair/Maint Services 21,650.00 998.78 4,311.75 19.92 17,338.25 101-4-1210-4433 Dues & Subscriptions 2,000.00 119.00 269.00 13.45 1,731.00 TOTAL Other Services & Charges 36,750.00 1,692.02 11,746.59 31.96 25,003.41 TOTAL Administrative Services 470,500.00 51,359.97 148,305.15 31.52 322,194.85 Human Resources CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 5-12-2010 09:42 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 PAGE: 7 101-GENERAL FUND General Government 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services i01-4-1220-4101 Regular Pay 67,850.00 8,080.74 21,389.80 31.53 46,460.20 101-4-1220-4103 Part-time Pay 48,000.00 4,840.13 14,942.47 31.13 33,057.53 101-4-1220-4104 PERA 8,100.00 909.45 2,826.23 34.89 5,273.77 101-4-1220-9105 FICA 7,200.00 795.57 2,491.73 34.61 4,708.27 101-4-1220-4107 Medicare 1,700.00 186.06 582.74 34.28 1,117.26 101-4-1220-4108 Insurance 5,500.00 469.01 1,876.04 34.11 3,623.96 101-4-1220-4109 Workers Comp 500.00 0.00 273.50 54.70 226.50 TOTAL Personal Services 138,650.00 15,275.96 94,382.51 31.96 94,467.99 Supplies 101-4-1220-4201 Office Supplies 4,100.00 0.00 2,503.36 61.06 1,596.64 TOTAL Supplies 4,100.00 0.00 2,503.36 61.06 1,596.64 Other Services & Charges 101-4-1220-4319 Other Professional Services 3,000.00 0.00 0.00 0.00 3,000.00 101-4-1220-4322 Postage 350.00 59.42 59.42 15.55 295.58 i01-4-1220-4331 Travel, Conferences & Schools 2,250.00 20.00 305.50 13.58 1,949.50 101-4-1220-9433 Dues & Subscriptions 900.00 0.00 45.00 5.00 855.00 101-4-1220-4440 Miscellaneous 1,000.00 86.28 272.24 27.22 727.76 TOTAL Other Services & Charges 7,500.00 160.70 677.16 9.03 6,822.84 TOTAL Human Resources 150,450.00 15,436.66 47,563.03 31.61 102,886.97 Elections Personal Services 101-4-1230-4103 Part-time Pay 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Personal Services 30,000.00 0.00 0.00 0.00 30,000.00 Supplies 101-4-1230-4219 Operating Supplies 4,600.00 0.00 0.00 0.00 4,600.00 TOTAL Supplies 4,600.00 0.00 0.00 0.00 4,600.00 Other Services & Charges 101-4-1230-9322 Postage 700.00 142.26 142.26 20.32 557.74 101-4-1230-9331 Travel, Conferences & Schools 700.00 0.00 0.00 0.00 700.00 101-4-1230-9359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1230-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 101-4-1230-4415 Equipment Rental 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 3,500.00 142.26 142.26 4.06 3,357.74 TOTAL Elections 38,100.00 142.26 142.26 0.37 37,957.74 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Finance Personal Services 101-4-1310-4101 Regular Pay 101-4-1310-4103 Part-time Pay 101-4-1310-4104 PERA 101-4-1310-4105 FICA i01-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-9-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-9-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4904 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Finance Information Technology ---------------------- Personal Services 101-4-1350-9101 Regular Pay 101-4-1350-4109 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1350-4219 Operating Supplies TOTAL Supplies CURRENT CURRENT BUDGET PERIOD 33.330 OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 285,500.00 32,677.63 90,045.35 31.59 195,454.65 2,000.00 365.00 730.00 36.50 1,270.00 20,000.00 2,287.94 6,835.10 34.18 13,164.90 17,850.00 1,959.53 5,779.26 32.38 12,070.74 4,200.00 458.28 1,351.60 32.18 2,648.90 29,600.00 2,043.01 8,172.04 33.22 16,427.96 1,250.00 0.00 673.50 53.88 576.50 355,400.00 39,790.89 113,586.85 31.96 241,813.15 3,850.00 67.50 356.96 9.27 3,993.04 3,850.00 67.50 356.96 9.27 3,493.04 18,000.00 11,220.00 15,120.00 84.00 2,880.00 49,000.00 0.00 0.00 0.00 49,000.00 800.00 58.24 194.72 29.34 605.28 3,600.00 702.11 702.11 19.50 2,897.89 2,950.00 18.60 1,015.58 39.43 1,934.42 1,200.00 0.00 0.00 0.00 1,200.00 11,100.00 721.41 10,573.03 95.25 526.97 1,500.00 0.00 735.00 49.00 765.00 88,150.00 12,720.36 28,340.44 32.15 59,809.56 447,400.00 52,578.75 142,284.25 31.80 305,115.75 128,400.00 14,813.16 39,995.56 31.15 88,404.44 9,000.00 1,036.92 3,098.42 34.43 5,901.58 8,300.00 893.57 2,623.01 31.60 5,676.99 1,950.00 208.97 613.43 31.46 1,336.57 16,100.00 1,804.02 5,860.02 36.40 10,239.98 600.00 0.00 303.00 50.50 297.00 169,350.00 18,756.64 52,493.44 31.94 111,856.56 29,900.00 1,467.69 2,876.09 9.62 27,023.91 29,900.00 1,967.69 2,876.09 9.62 27,023.91 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 387.40 387.40 4.84 7,612.60 101-4-1350-4321 Telephone 750.00 49.37 166.91 22.19 583.59 101-4-1350-4331 Travel, Conferences & Schools 12,300.00 41.80 41.80 0.39 12,258.20 101-4-1350-4404 Equip Repair/Maint Services 16,950.00 840.00 840.00 9.96 16,110.00 TOTAL Other Services & Charges 38,000.00 1,318.57 1,435.61 3.78 36,564.39 Capital Outlay 101-4-1350-4560 Equipment 70,900.00 0.00 10,900.00 15.37 60,000.00 TOTAL Capita l Outlay 70,900.00 0.00 10,900.00 15.37 60,000.00 TOTAL Information Technology 303,150.00 21,542.90 67,705.14 22.33 235,449.86 Legal Other Services & Charges 101-4-1400-4304 Legal Fees 234,000.00 5,853.30 31,670.30 13.53 202,329.70 TOTAL Other Services & Charges 234,000.00 5,853.30 31,670.30 13.53 202,329.70 TOTAL Legal 234,000.00 5,853.30 31,670.30 13.53 202,329.70 Community Development Personal Services 101-4-1500-4101 Regular Pay 52,700.00 6,079.21 16,413.87 31.15 36,286.13 101-4-1500-9104 PERA 3,700.00 425.55 1,271.58 34.37 2,428.92 101-4-1500-4105 FICA 3,250.00 368.91 1,098.71 33.81 2,151.29 101-4-1500-4107 Medicare 750.00 86.28 256.98 34.26 493.02 101-4-1500-4108 Insurance 5,500.00 469.01 1,876.04 34.11 3,623.96 101-4-1500-4109 Workers Comp 600.00 0.00 124.50 20.75 475.50 TOTAL Personal Services 66,500.00 7,428.96 21,041.68 31.64 45,458.32 Supplies 101-4-1500-4201 Office Supplies 150.00 0.00 0.00 0.00 150.00 TOTAL Supplies 150.00 0.00 0.00 0.00 150.00 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00 TOTAL Other Services & Charges 500.00 0.00 0.00 0.00 500.00 TOTAL Community Development 67,150.00 7,428.96 21,041.68 31.34 46,108.32 5-12-2010 09:92 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4104 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies LO1-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101-4-1510-4319 Other Professional Services 101-9-1510-4321 Telephone 101-9-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-9-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Planning City Hall Maintenance Personal Services i01-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay 101-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 208,900.00 24,104.61 65,082.44 31.15 143,817.56 14,600.00 1,687.32 5,041.87 34.53 9,558.13 12,950.00 1,406.15 4,130.09 31.89 8,819.91 3,050.00 328.86 965.94 31.67 2,084.06 26,950.00 2,254.01 9,016.04 33.45 17,933.96 650.00 0.00 308.00 97.38 342.00 267,100.00 29,780.95 84,544.38 31.65 182,555.62 4,750.00 169.89 1,092.37 23.00 3,657.63 2,550.00 82.24 331.89 13.02 2,218.11 7,300.00 252.13 1,424.26 19.51 5,875.74 0.00 0.00 90.00 0.00 ( 90.00) 800.00 25.97 75.68 9.46 724.32 2,000.00 1,092.38 1,092.38 54.62 907.62 6,050.00 35.00 103.71 1.71 5,946.29 10,000.00 1,132.50 2,347.50 23.48 7,652.50 450.00 0.00 47.00 10.44 403.00 5,000.00 269.54 504.66 10.09 4,995.34 1,000.00 455.00 555.00 55.50 945.00 250.00 0.00 0.00 0.00 250.00 25,550.00 3,010.39 4,815.93 18.85 20,734.07 299,950.00 33,043.47 90,784.57 30.27 209,165.43 87,350.00 11,259.08 30,428.17 39.83 56,921.83 2,500.00 26.59 281.79 11.27 2,218.21 23,050.00 3,156.58 7,098.58 30.80 15,951.92 8,100.00 958.17 2,937.68 36.27 5,162.32 7,150.00 901.81 2,647.05 37.02 9,502.95 1,650.00 210.91 619.08 37.52 1,030.92 16,350.00 1,318.09 5,589.43 34.19 10,760.57 4,550.00 0.00 2,648.00 58.20 1,902.00 150,700.00 17,831.23 52,249.78 34.67 98,450.22 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 33.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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 101-4-1600-9331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4901 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services 101-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges 3,750.00 215.38 766.93 20.45 2,983.07 1,700.00 32.99 415.81 24.46 1,284.19 30,400.00 2,632.38 8,722.20 28.69 21,677.80 35,850.00 2,880.75 9,904.94 27.63 25,995.06 15,450.00 1,004.12 3,975.53 25.73 11,474.47 2,000.00 0.00 200.00 10.00 1,800.00 9,500.00 0.00 2,239.50 49.77 2,260.50 51,800.00 3,658.57 13,072.15 25.24 38,727.85 30,650.00 892.09 7,220.21 23.56 23,429.79 5,000.00 0.00 0.00 0.00 5,000.00 1,050.00 87.50 350.00 33.33 700.00 110,450.00 5,642.28 27,057.39 24.50 83,392.61 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Contingency 297,000.00 26,359.26 89,212.11 30.04 207,787.89 113,100.00 0.00 113,100.00 0.00 113,100.00 0.00 435.90 0.39 112,664.10 435.90 0.39 112,664.10 435.90 0.39 112,664.10 TOTAL General Government Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PERA 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 2,670,100.00 225,938.64 718,612.97 26.91 1,951,487.03 275,400.00 31,773.66 85,788.86 31.15 189,611.14 38,850.00 4,480.11 13,440.33 34.60 25,409.67 1,250.00 306.73 911.23 72.90 338.77 24,400.00 2,027.02 8,108.08 33.23 16,291.92 55,150.00 0.00 26,781.00 48.56 28,369.00 395,050.00 38,587.52 135,029.50 34.18 260,020.50 17,000.00 1,064.12 2,983.38 17.55 14,016.62 2,150.00 620.16 1,247.24 58.01 902.76 1,950.00 3.11 130.27 6.68 1,819.73 21,100.00 1,687.39 4,360.89 20.67 16,739.11 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-9-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-9-2110-4433 Dues & Subscriptions 101-9-2110-4437 Taxes & Licenses TOTAL Other Services & Charges 5,500.00 0.00 0.00 0.00 5,500.00 27,400.00 1,869.67 6,383.18 23.30 21,016.82 2,100.00 973.55 978.63 22.79 1,621.37 4,300.00 0.00 1,280.00 29.77 3,020.00 500.00 0.00 0.00 0.00 500.00 9,850.00 0.00 4,460.50 95.28 5,389.50 68,900.00 3,743.49 39,044.56 56.67 29,855.49 8,400.00 1,318.00 2,763.00 32.89 5,637.00 700.00 94.00 94.00 13.43 606.00 127,650.00 7,998.71 54,503.87 92.70 73,146.13 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PE RA 101-4-2120-4105 FICA 101-4-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-9331 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 543,800.00 47,773.62 193,894.26 35.66 349,905.74 1,441,800.00 160,552.68 439,936.26 30.17 1,006,863.79 90,000.00 5,205.95 11,549.68 12.83 78,450.32 216,000.00 23,372.04 70,004.78 32.41 145,995.22 0.00 0.00 12.36 0.00 ( 12.36) 19,900.00 2,009.22 5,868.05 29.49 14,031.95 163,500.00 14,435.34 56,394.36 34.49 107,105.64 1,931,200.00 205,575.23 578,765.99 29.97 1,352,434.51 118,350.00 7,683.90 24,022.71 20.30 94,327.29 15,850.00 1,798.64 3,805.84 24.01 12,044.16 69,650.00 5,108.01 7,305.07 10.49 62,344.93 28,000.00 523.10 2,901.24 8.58 25,598.76 231,850.00 15,113.15 37,534.86 16.19 194,315.14 15,300.00 855.80 3,445.80 22.52 11,854.20 27,350.00 1,947.78 2,281.87 8.34 25,068.13 550.00 0.00 190.00 34.55 360.00 38,900.00 3,241.67 12,966.68 33.33 25,933.32 82,100.00 6,045.25 18,884.35 23.00 63,215.65 TOTAL Patrol 2,245,150.00 226,733.63 635,184.70 28.29 1,609,965.30 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Investigations Personal Services 101-4-2130-9101 Regular Pay 505,400.00 56,784.60 149,208.84 29.52 356,191.16 101-4-2130-4102 Overtime Pay 40,000.00 687.30 4,123.80 10.31 35,876.20 101-4-2130-4104 PERA 76,900.00 8,103.57 23,950.90 31.15 52,949.10 101-4-2130-4107 Medicare 4,750.00 549.66 1,563.99 32.93 3,186.06 101-4-2130-4108 Insurance 61,650.00 5,136.86 20,547.44 33.33 41,102.56 TOTAL Personal Services 688,700.00 71,261.99 199,394.92 28.95 489,305.08 Supplies 101-4-2130-4217 Uniform Allowance 5,050.00 197.11 1,794.55 35.54 3,255.45 101-4-2130-9219 Operating Supplies 6,800.00 1,479.87 2,233.24 32.84 9,566.76 TOTAL Supplies 11,850.00 1,676.98 9,027.79 33.99 7,822.21 Other Services & Charges 101-4-2130-4319 Other Professional Services 11,900.00 220.00 880.00 7.39 11,020.00 101-9-2130-4331 Travel, Conferences & Schools 4,050.00 30.00 2,469.60 60.98 1,580.90 101-4-2130-4433 Dues & Subscriptions 800.00 0.00 305.00 38.13 495.00 101-4-2130-4460 Equip Replacement Charge 14,050.00 1,170.83 4,683.32 33.33 9,366.68 TOTAL Other Services & Charges 30,800.00 1,420.83 8,337.92 27.07 22,462.08 TOTAL Investigations Police Support Services Personal Services 101-4-2150-9101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-9104 PERA 101-4-2150-4105 FICA 101-4-2150-9107 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 731,350.00 74,359.80 211,760.63 28.95 519,589.37 347,300.00 36,319.22 103,879.90 29.91 243,420.10 6,500.00 0.00 0.00 0.00 6,500.00 24,750.00 2,542.35 8,111.86 32.78 16,638.14 21,950.00 2,221.96 7,052.91 32.13 14,897.09 5,150.00 519.68 1,652.59 32.09 3,497.41 44,150.00 3,183.06 14,046.38 31.82 30,103.62 449,800.00 44,786.27 134,743.64 29.96 315,056.36 1,000.00 58.78 58.78 5.88 941.22 2,750.00 442.84 490.84 17.85 2,259.16 9,150.00 466.72 737.22 8.06 8,412.78 12,900.00 968.34 1,286.84 9.98 11,613.16 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 i01-GENERAL FUND Public Safety 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges i01-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-4-2150-9409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101-4-2150-4560 Equipment TOTAL Capital Outlay 3,550.00 200.00 250.00 7.04 3,300.00 2,650.00 0.00 1,207.69 45.57 1,442.31 16,000.00 260.12 1,957.51 12.23 19,042.99 500.00 0.00 222.50 44.50 277.50 5,100.00 425.00 1,700.00 33.33 3,400.00 27,800.00 885.12 5,337.70 19.20 22,462.30 11,400.00 0.00 0.00 0.00 11,900.00 11,900.00 0.00 0.00 0.00 11,900.00 TOTAL Police Support Services 501,900.00 46,639.73 141,368.18 28.17 360,531.82 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 327.08 5.95 5,172.92 101-9-2160-4105 FICA 350.00 0.00 22.75 6.50 327.25 101-4-2160-4107 Medicare 100.00 0.00 5.32 5.32 94.68 TOTAL Personal Services 5,950.00 0.00 355.15 5.97 5,594.85 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 0.00 7.47 0.15 4,992.53 101-4-2160-4219 Operating Supplies 6,000.00 0.00 0.00 0.00 6,000.00 TOTAL Supplies 11,000.00 0.00 7.47 0.07 10,992.53 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2160-4321 Telephone 1,600.00 139.67 558.23 34.89 1,041.77 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0.00 1,700.00 101-4-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 518.00 51.80 482.00 TOTAL Other Services & Charges 5,950.00 139.67 1.,076.23 18.09 4,873.77 TOTAL Police Reserves Public safety building 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-4107 Medicare 22,900.00 139.67 1,438.85 6.28 21,461.15 100,600.00 11,298.66 29,400.75 29.23 71,199.25 0.00 34.20 39.20 0.00 ( 34.20) 7,050.00 793.28 2,240.11 31.77 4,809.89 6,250.00 700.99 1,960.38 31.37 4,289.62 1,450.00 163.95 458.53 31.62 991.47 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2190-4108 Insurance 12,650.00 1,038.15 3,783.04 29.91 8,866.96 101-4-2190-4109 Workers Comp 9,050.00 0.00 1,536.00 37.93 2,514.00 TOTAL Personal Services 132,050.00 19,029.23 39,413.01 29.85 92,636.99 Supplies 101-4-2190-9219 Operating Supplies 18,200.00 782.03 8,648.86 47.52 9,551.14 TOTAL Supplies 18,200.00 782.03 8,648.86 47.52 9,551.14 Other Services & Charges 101-4-2190-4361 Insurance 6,500.00 0.00 3,123.00 48.05 3,377.00 101-4-2190-4389 Utilities 18,200.00 2,566.44 9,881.47 54.29 8,318.53 101-4-2190-4401 Bldg Repair/Maint Services 31,300.00 2,302.59 3,598.02 11.50 27,701.98 TOTAL Other Services & Charges 56,000.00 4,869.03 16,602.49 29.65 39,397.51 TOTAL Public safety building Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4102 Overtime Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions 101-4-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-9321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-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 206,250.00 19,680.29 64,664.36 31.35 141,585.64 76,250.00 10,180.44 27,372.88 35.90 98,877.12 0.00 3.80 3.80 0.00 ( 3.80) 153,000.00 20,694.78 46,851.42 30.62 106,148.58 13,250.00 1,419.24 4,242.11 32.02 9,007.89 10,100.00 1,230.85 3,207.82 31.76 6,892.18 30,000.00 1,000.00 0.00 0.00 30,000.00 3,500.00 398.05 1,079.56 30.84 2,420.44 9,900.00 721.70 2,807.87 28.36 7,092.13 16,700.00 0.00 9,122.00 54.62 7,578.00 312,700.00 35,648.86 94,687.46 30.28 218,012.54 1,200.00 2.11 32.79 2.73 1,167.21 9,000.00 521.33 1,629.96 18.11 7,370.04 1,100.00 136.22 1,333.72 121.25 ( 233.72) 22,700.00 1,999.73 5,816.79 25.62 16,883.21 34,000.00 2,659.39 8,813.26 25.92 25,186.74 5,050.00 1,537.50 1,537.50 30.45 3,512.50 3,000.00 213.53 779.12 25.97 2,220.88 500.00 114.14 114.14 22.83 385.86 20,000.00 1,241.82 2,708.08 13.54 17,291.92 500.00 0.00 0.00 0.00 500.00 18,800.00 0.00 8,125.50 43.22 10,674.50 15,150.00 1,630.62 5,937.88 39.19 9,212.12 4,450.00 96.19 301.13 6.77 4,148.87 27,100.00 506.07 2,337.26 8.62 29,762.74 2,000.00 150.00 1,449.00 72.45 551.00 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2310-4460 Equip Replacement Charge 22,300.00 1,858.33 7,433.32 33.33 14,866.68 TOTAL Other Services & Charges 118,850.00 7,348.20 30,722.93 25.85 88,127.07 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-9108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs i01-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-9-2320-4359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 465,550.00 45,656.45 134,223.65 28.83 331,326.35 128,900.00 14,867.80 40,143.04 31.14 88,756.96 14,650.00 1,664.76 4,989.21 39.06 9,660.79 3,250.00 436.97 1,240.79 38.18 2,009.21 1,900.00 222.46 693.80 33.88 1,256.20 14,650.00 1,149.91 4,599.64 31.40 10,050.36 163,350.00 18,341.90 51,616.48 31.60 111,733.52 3,050.00 0.00 37.36 1.22 3,012.64 5,900.00 297.61 818.76 13.88 5,081.24 800.00 0.00 0.00 0.00 800.00 4,550.00 0.00 0.00 0.00 4,550.00 14,300.00 297.61 856.12 5.99 13,943.88 1,050.00 141.88 454.69 43.30 595.31 150.00 0.00 0.00 0.00 150.00 3,200.00 0.00 471.00 14.72 2,729.00 200.00 0.00 0.00 0.00 200.00 1,850.00 72.78 218.34 11.80 1,631.66 500.00 0.00 0.00 0.00 500.00 6,950.00 214.66 1,144.03 16.46 5,805.97 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-4101 Regular Pay i01-4-2330-4104 PERA i01-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services 184,600.00 18,854.17 53,616.63 29.04 130,983.37 8,300.00 959.73 2,591.27 31.22 5,708.73 1,400.00 135.30 405.90 28.99 994.10 150.00 13.76 41.12 27.41 108.88 1,100.00 44.90 179.60 16.33 920.40 10,950.00 1,153.69 3,217.89 29.39 7,732.11 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 33.33a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2330-9201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-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 900.00 0.00 0.00 0.00 400.00 8,500.00 0.00 186.22 2.19 8,313.78 8,900.00 0.00 186.22 2.09 8,713.78 1,500.00 116.33 410.03 27.34 1,089.97 100.00 0.00 0.00 0.00 100.00 1,850.00 0.00 225.00 12.16 1,625.00 500.00 0.00 0.00 0.00 500.00 1,500.00 107.51 355.70 23.71 1,144.30 5,100.00 0.00 57.53 1.13 5,042.47 400.00 0.00 100.00 25.00 300.00 10,950.00 223.84 1,198.26 10.49 9,801.74 TOTAL Emergency Management Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-9-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-2910-4201 Office Supplies 101-9-2410-4212 Fuels & Lubs 101-4-2910-4217 Uniform Allowance 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 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Building Safety 30,800.00 1,377.53 4,552.37 14.78 26,247.63 318,350.00 36,255.39 97,938.40 30.76 220,411.60 25,050.00 2,887.20 7,931.79 31.66 17,118.21 24,050.00 2,739.99 8,212.32 34.15 15,837.68 21,300.00 2,290.40 6,757.23 31.72 14,542.77 5,000.00 535.63 1,580.30 31.61 3,419.70 38,250.00 3,191.04 12,764.16 33.37 25,485.84 1,400.00 0.00 548.00 39.19 852.00 433,900.00 47,899.65 135,732.20 31.32 297,667.80 2,500.00 0.00 368.06 14.72 2,131.99 4,000.00 223.80 742.63 18.57 3,257.37 700.00 0.00 0.00 0.00 700.00 1,450.00 64.64 140.41 9.68 1,309.59 8,650.00 288.44 1,251.10 14.46 7,398.90 2,550.00 164.18 502.73 19.71 2,047.27 500.00 75.32 75.32 15.06 424.68 6,750.00 310.00 715.00 10.59 6,035.00 1,100.00 0.00 419.50 38.14 680.50 8,800.00 277.72 2,947.83 33.50 5,852.17 1,200.00 0.00 365.00 30.42 835.00 2,600.00 216.67 866.68 33.33 1,733.32 23,500.00 1,043.89 5,892.06 25.07 17,607.94 465,550.00 49,231.98 142,875.36 30.69 322,674.64 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA i01-4-2440-4105 FICA 101-4-2440-9107 Medicare 101-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-9201 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-9331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4409 Contractual Services 101-4-2490-4433 Dues & Subscriptions TOTAL Other Services & Charges 35,400.00 9,033.86 10,977.19 31.01 29,922.81 2,500.00 282.36 889.10 35.56 1,610.90 2,200.00 208.50 615.20 27.96 1,589.80 500.00 48.75 143.85 28.77 356.15 5,650.00 477.77 2,139.96 37.88 3,510.04 400.00 0.00 190.00 47.50 210.00 46,650.00 5,051.24 14,955.30 32.06 31,694.70 650.00 0.00 38.34 5.90 611.66 150.00 0.00 33.32 22.21 116.68 800.00 0.00 71.66 8.96 728.34 700.00 49.97 160.18 22.88 539.82 500.00 85.70 85.70 17.14 414.30 500.00 85.00 92.25 18.45 407.75 250.00 0.00 0.00 0.00 250.00 250.00 0.00 93.50 37.40 156.50 1,500.00 35.00 35.00 2.33 1,465.00 1,050.00 0.00 0.00 0.00 1,050.00 4,750.00 255.67 466.63 9.82 4,283.37 TOTAL Environmental TOTAL Public Safety Street Maintenance Personal Services 101-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-4107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services 52,200.00 5,306.91 15,493.59 29.68 36,706.41 5,450,050.00 535,753.78 1,599,072.58 29.34 3,850,977.42 439,050.00 56,595.45 115,369.46 26.28 323,680.54 2,000.00 0.00 0.00 0.00 2,000.00 73,750.00 5,916.15 15,929.75 21.60 57,820.25 34,450.00 9,366.39 10,089.47 29.29 24,360.53 31,900.00 3,713.73 8,526.56 26.73 23,373.44 7,450.00 868.51 1,994.04 26.77 5,455.96 58,600.00 9,690.97 14,535.09 24.80 44,064.91 20,950.00 0.00 11,305.00 53.96 9,695.00 668,150.00 76,151.20 177,749.37 26.60 490,400.63 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 33.33% OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 6,400.00 0.00 191.07 2.99 6,208.93 101-4-3120-4212 Fuels & Lubs 74,000.00 ( 65.11) 30,022.49 40.57 43,977.51 101-4-3120-4219 Operating Supplies 147,000.00 16,545.22 29,771.23 20.25 117,228.77 101-4-3120-4226 Street Signs 29,950.00 574.41 554.41 1.85 29,395.59 TOTAL Suppli es 257,350.00 17,054.52 60,539.20 23.52 196,810.80 Other Services & Charges 101-4-3120-4319 Other Professional Services 950.00 0.00 0.00 0.00 950.00 101-4-3120-4321 Telephone 8,950.00 404.33 2,352.86 26.29 6,597.14 101-4-3120-4322 Postage 200.00 6.06 6.06 3.03 193.94 101-4-3120-4331 Travel, Conferences & Schools 3,000.00 204.00 204.00 6.80 2,796.00 101-4-3120-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-3120-4361 Insurance 17,150.00 0.00 8,012.00 46.72 9,138.00 101-4-3120-4389 Utilities 33,000.00 3,186.06 11,274.69 34.17 21,725.31 101-4-3120-4401 Bldg Repair/Maint Services 6,500.00 662.55 2,699.12 41.52 3,800.88 101-4-3120-4909 Equip Repair/Maint Services 5,000.00 90.00 90.00 1.80 4,910.00 101-4-3120-4909 Contractual Services 211,700.00 0.00 3,656.20 1.73 208,043.80 101-4-3120-4415 Equipment Rental 5,500.00 816.27 1,008.65 18.34 4,491.35 i01-4-3120-4417 Uniform Rental 4,700.00 724.86 828.15 17.62 3,871.85 101-4-3120-4433 Dues & Subscriptions 700.00 0.00 211.25 30.18 488.75 101-4-3120-4437 Taxes & Licenses 500.00 14.50 428.25 85.65 71.75 101-4-3120-4460 Equip Replacement Charge 104,800.00 8,733.33 34,933.32 33.33 69,866.68 TOTAL Other Services & Charges 403,150.00 14,841.96 65,704.55 16.30 337,945.45 Capital Outlay 101-4-3120-4560 Equipment 8,300.00 3,740.63 3,740.63 45.07 4,559.37 TOTAL Capita l Outlay 8,300.00 3,740.63 3,740.63 45.07 9,559.37 TOTAL Street M aintenance 1,336,950.00 111,788.31 307,733.75 23.02 1,029,216.25 Snow Removal Personal Services 101-4-3130-4101 Regular Pay 114,900.00 4,130.96 58,476.74 101-4-3130-4102 Overtime Pay 3,000.00 0.00 944.39 101-4-3130-4104 PERA 8,900.00 289.14 5,542.50 101-4-3130-4105 FICA 8,250.00 235.19 4,684.86 101-4-3130-4107 Medicare 1,900.00 55.00 1,095.65 101-4-3130-4108 Insurance 16,250.00 1,018.57 10,315.83 101-4-3130-4109 Workers Comp 7,350.00 0.00 3,206.50 TOTAL Personal Services 160,550.00 5,728.86 84,266.47 50.89 56,423.26 31.48 2,055.61 62.28 3,357.50 56.79 3,565.14 57.67 804.35 63.48 5,934.17 43.63 4,143.50 52.49 76,283.53 5-12-2010 09:42 AM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES PAGE: 20 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies 86,000.00 0.00 78,198.63 90.93 7,801.37 86,000.00 0.00 78,198.63 90.93 7,801.37 TOTAL Snow Removal Equipment Services Personal Services 101-4-3150-4101 Regular Pay 101-9-3150-4102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-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-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4409 Equip Repair/Maint Services 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 246,550.00 5,728.86 162,465.10 65.90 84,084.90 162,750.00 18,571.04 47,784.14 29.36 114,965.86 0.00 0.00 20.69 0.00 ( 20.69) 11,400.00 1,299.97 3,692.93 31.96 7,757.07 10,100.00 1,085.23 3,005.00 29.75 7,095.00 2,350.00 253.79 702.77 29.91 1,647.23 24,150.00 1,821.01 6,417.06 26.57 17,732.94 6,050.00 0.00 3,189.00 52.71 2,861.00 216,800.00 23,031.04 64,761.59 29.87 152,038.41 14,500.00 1,732.40 4,903.75 33.82 9,596.25 11,700.00 0.00 0.00 0.00 11,700.00 26,200.00 1,732.40 4,903.75 18.72 21,296.25 500.00 0.00 0.00 0.00 500.00 2,800.00 240.31 771.43 27.55 2,028.57 3,300.00 240.31 771.43 23.38 2,528.57 246,300.00 25,003.75 70,436.77 28.60 175,863.23 86,850.00 0.00 6,100.00 0.00 5,400.00 0.00 1,250.00 0.00 16,350.00 0.00 200.00 0.00 116,150.00 0.00 0.00 0.00 86,850.00 0.00 0.00 6,100.00 0.00 0.00 5,400.00 0.00 0.00 1,250.00 0.00 0.00 16,350.00 210.50 105.25 ( 10.50) 210.50 0.18 115,939.50 5-12-2010 09:42 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Public Works CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL PAGE: 21 33.33°s OF YEAR COMP. a OF BUDGET BUDGET BALANCE Supplies 101-4-3300-4201 Office Supplies i01-4-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3300-4303 Engineering Fees 101-4-3300-4319 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 TOTAL Engineering 1,000.00 0.00 19.29 1.42 985.76 1,200.00 0.00 0.00 0.00 1,200.00 8,800.00 0.00 1,750.00 19.89 7,050.00 11,000.00 0.00 1,764.24 16.04 9,235.76 20,000.00 2,401.50 7,134.31 35.67 12,865.69 22,500.00 0.00 0.00 0.00 22,500.00 1,150.00 0.00 2.52 0.22 1,147.48 200.00 2.44 2.44 1.22 197.56 5,850.00 0.00 0.00 0.00 5,850.00 250.00 0.00 93.50 37.40 156.50 500.00 0.00 0.00 0.00 500.00 750.00 62.50 250.00 33.33 500.00 51,200.00 2,466.44 7,482.77 14.61 43,717.23 178,350.00 2,466.44 9,457.51 5.30 168,892.49 TOTAL Public Works Parks Department Personal Services 101-4-5110-4101 Regular 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 Workers Comp TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies 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 Bldg Repair/Maint Services 2,008,150.00 194,987.36 550,093.13 27.39 1,458,056.87 392,150.00 34,166.97 101,220.79 29.58 240,929.21 39,650.00 1,108.50 1,108.50 2.80 38,541.50 24,650.00 2,419.42 7,812.88 31.70 16,837.12 23,750.00 2,040.63 6,378.15 26.86 17,371.85 5,550.00 477.22 1,491.59 26.88 4,058.41 43,550.00 4,059.15 14,658.91 33.66 28,891.09 8,200.00 0.00 4,058.00 49.49 4,192.00 487,500.00 94,271.89 136,728.82 28.05 350,771.18 34,550.00 949.50 6,335.02 18.34 28,214.98 3,150.00 728.89 808.87 25.68 2,341.13 73,800.00 5,287.67 14,877.94 20.16 58,922.06 111,500.00 6,966.06 22,021.83 19.75 89,478.17 3,900.00 332.42 1,023.15 26.23 2,876.85 100.00 0.00 0.00 0.00 100.00 3,350.00 381.28 701.48 20.94 2,648.52 25,850.00 0.00 12,320.50 47.66 13,529.50 27,200.00 269.50 1,002.75 3.69 26,197.25 4,000.00 0.00 0.00 0.00 4,000.00 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Culture & Recreation 33.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5110-4404 Equip Repair/Maint Services 11,700.00 1,414.22 1,760.58 15.05 9,939.42 101-9-5110-4409 Contractual Services 7,100.00 0.00 132.00 1.86 6,968.00 101-4-5110-4415 Equipment Rental 24,500.00 1,073.56 2,444.04 9.98 22,055.96 101-4-5110-4460 Equip Replacement Charge 60,450.00 5,037.50 20,150.00 33.33 40,300.00 TOTAL Other Services & Charges 168,150.00 8,508.48 39,534.50 23.51 128,615.50 TOTAL Parks Department Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-4102 Overtime Pay 101-4-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-4105 FICA 101-4-5210-9107 Medicare 101-4-5210-9108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5210-4321 Telephone 101-4-5210-4322 Postage 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Parks & Rec Admin Recreation Programs 767,150.00 59,746.43 198,285.15 25.85 568,864.85 338,400.00 38,172.95 102,925.86 30.42 235,974.14 0.00 11.40 11.40 0.00 ( 11.40) 20,850.00 2,406.00 6,717.45 32.22 14,132.55 25,150.00 2,841.29 8,478.82 33.71 16,671.18 22,300.00 2,427.83 7,186.77 32.23 15,113.23 5,200.00 567.79 1,680.74 32.32 3,519.26 38,350.00 3,131.82 12,497.08 32.59 25,852.92 3,400.00 0.00 1,689.50 49.69 1,710.50 453,650.00 49,559.08 141,187.62 31.12 312,462.38 13,700.00 1,148.18 3,494.43 25.51 10,205.57 13,700.00 1,148.18 3,494.43 25.51 10,205.57 4,800.00 260.89 938.97 19.56 3,861.03 6,000.00 250.28 1,652.58 27.54 4,347.42 6,950.00 327.70 742.26 10.68 6,207.74 26,900.00 2,760.99 3,636.81 13.78 22,763.19 1,550.00 0.00 668.50 43.13 881.50 7,800.00 1,398.32 4,547.09 58.30 3,252.91 12,850.00 1,212.65 4,314.50 33.58 8,535.50 7,950.00 488.47 1,273.08 16.01 6,676.92 1,650.00 1,297.00 1,327.00 80.42 323.00 75,950.00 7,995.80 19,100.79 25.15 56,849.21 543,300.00 58,703.06 163,782.84 30.15 379,517.16 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES Personal Services 101-4-5220-4102 Overtime Pay 101-4-5220-4103 Part-time Pay 101-4-5220-4104 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-4404 Equip Repair/Maint Services 101-4-5220-4409 Contractual Services i01-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 19.13 64.13 0.00 ( 64.13) 80,000.00 3,459.88 10,876.41 13.60 69,123.59 2,200.00 206.18 538.53 24.48 1,661.47 4,250.00 215.70 756.26 17.79 3,493.74 1,150.00 50.48 176.92 15.38 973.08 87,600.00 3,951.37 12,412.25 14.17 75,187.75 25,550.00 2,445.07 3,031.90 11.87 22,518.10 25,550.00 2,445.07 3,031.90 11.87 22,518.10 400.00 0.00 407.72 101.93 ( 7.72) 55,200.00 184.18 4,436.98 8.04 50,763.02 2,500.00 709.75 709.75 28.39 1,790.25 3,300.00 805.51 1,080.71 32.75 2,219.29 61,400.00 1,699.44 6,635.16 10.81 54,764.84 TOTAL Recreation Programs Concessions 174,550.00 8,095.88 22,079.31 12.65 152,470.69 Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 87.50 936.25 25.65 2,713.75 101-4-5230-4104 PERA 150.00 1.78 77.53 51.69 72.47 101-4-5230-4105 FICA 250.00 5.42 80.13 32.05 169.87 101-4-5230-4107 Medicare 50.00 1.26 18.74 37.48 31.26 TOTAL Personal Services 4,100.00 95.96 1,112.65 27.14 2,987.35 Supplies 101-4-5230-4219 Operating Supplies 1,450.00 0.00 0.00 0.00 1,450.00 101-4-5230-4259 Other Merchandise For Resale 8,200.00 0.00 418.00 5.10 7,782.00 TOTAL Supplies 9,650.00 0.00 418.00 4.33 9,232.00 Other Services & Charges 101-4-5230-4901 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 SOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 TOTAL Concessions 13,850.00 95.96 1,530.65 11.05 12,319.35 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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 i01-4-5510-4109 Workers Comp TOTAL Personal Services Supplies i01-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-9321 Telephone 101-4-5510-9322 Postage 101-4-5510-9331 Travel, Conferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 56,300.00 6,374.90 17,254.98 30.65 39,045.02 59,200.00 5,124.59 14,882.56 25.14 44,317.44 8,100.00 804.94 2,518.15 31.09 5,581.85 7,200.00 675.55 2,090.60 29.04 5,109.40 1,700.00 158.01 488.99 28.76 1,211.01 13,000.00 1,080.10 9,320.40 33.23 8,679.60 400.00 0.00 217.50 54.38 182.50 145,900.00 19,217.59 41,773.18 28.63 109,126.82 16,100.00 710.69 1,884.25 11.70 19,215.75 16,100.00 710.69 1,889.25 11.70 19,215.75 2,900.00 211.19 855.54 35.65 1,544.46 2,100.00 49.63 1,049.63 49.98 1,050.37 2,900.00 20.50 168.50 7.02 2,231.50 1,650.00 0.00 746.50 45.24 903.50 11,800.00 938.58 2,953.03 25.03 8,846.97 11,500.00 636.87 2,532.28 22.02 8,967.72 8,200.00 172.00 388.00 4.73 7,812.00 1,200.00 177.00 219.50 18.29 980.50 41,250.00 2,205.77 8,912.98 21.61 32,337.02 TOTAL Sr Citizen Programs 203,250.00 17,134.05 52,570.41 25.86 150,679.59 TOTAL Culture & Recreation Economic Development 1,702,100.00 143,775.38 438,248.36 25.75 1,263,851.64 Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 5,118.70) 15,356.10 0.00 ( 15,356.10) 101-4-6210-4103 Part-time Pay 0.00 ( 1,050.32) 1,050.32 0.00 ( 1,050.32) 101-4-6210-4104 PERA 0.00 ( 380.41) 1,097.03 0.00 ( 1,097.03) 101-4-6210-4105 FICA 0.00 ( 338.05) 963.47 0.00 ( 963.47) 101-4-6210-4107 Medicare 0.00 ( 79.05) 227.51 0.00 ( 227.51) i01-4-6210-4108 Insurance 0.00 ( 918.01) 918.01 0.00 ( 918.01) 101-4-6210-4109 Workers Comp 0.00 ( 67.75) 0.00 0.00 0.00 TOTAL Personal Services 0.00 ( 7,952.29) 19,612.44 0.00 ( 19,612.44) 5-12-2010 09:42 AM 101-GENERAL FUND Economic Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 PAGE: 25 33.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-6210-4322 Postage 0.00 145.56 145.56 0.00 ( 145.56) 101-4-6210-4361 Insurance 0.00 ( 702.65) 0.10 0.00 ( 0.10) 101-4-6210-4440 Miscellaneous 0.00 ( 180.51) 8.08 0.00 ( 8.08) TOTAL Other Services & Charges 0.00 ( 737.60) 153.74 0.00 ( 153.74) TOTAL Economic Development 0.00 ( 8,689.89) 19,766.18 0.00 ( 19,766.18) Energy City Personal Services i01-4-6220-9101 Regular Pay 24,550.00 2,811.42 7,616.93 31.03 16,933.07 101-4-6220-9104 PERA 1,700.00 196.80 595.22 35.01 1,109.78 101-4-6220-4105 FICA 1,500.00 147.54 420.64 28.09 1,079.36 101-4-6220-4107 Medicare 350.00 34.51 98.39 28.11 251.61 101-4-6220-9108 Insurance 3,250.00 263.51 1,098.14 33.79 2,151.86 TOTAL Personal Services 31,350.00 3,453.78 9,829.32 31.35 21,520.68 Other Services & Charges 101-4-6220-4319 Other Professional Services 5,000.00 79.90 130.39 2.61 4,869.61 101-4-6220-4331 Travel, Conferences & Schools 2,500.00 1,545.63 ( 5,782.13) 231.29- 8,282.13 101-4-6220-4359 Publishing 12,500.00 515.20 945.60 7.56 11,554.40 TOTAL Other Services & Charges 20,000.00 2,140.23 ( 4,706.14) 23.53- 24,706.14 TOTAL Energy City 51,350.00 5,594.01 5,123.18 9.98 46,226.82 TOTAL Economic Development 51,350.00 ( 3,095.88) 24,889.36 48.97 26,460.64 Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 126,600.00 0.00 0.00 0.00 126,600.00 101-4-7000-4724 Transfer - Pinewood 37,450.00 0.00 0.00 0.00 37,450.00 TOTAL Transfers Out 164,050.00 0.00 0.00 0.00 164,050.00 TOTAL Transfers Out 164,050.00 0.00 0.00 0.00 164,050.00 TOTAL General 164,050.00 0.00 0.00 0.00 164,050.00 TOTAL EXPENDITURES 12,045,800.00 1,047,359.28 3,330,916.40 27.65 8,714,883.60 REVENUES OVER/(UNDER) EXPENDITURES ( 325,000.00)( 833,238.92)( 2,736,353.00) 2,411,353.00 5-12-2010 09:42 AM 221-ICE ARENA FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 3.33°s OF ~ OF BUDGET PAGE: 1 EAR COMP. BUDGET BALANCE REVENUE SUMMARY Ice Arena 656,050.00 47,053.73 234,227.62 35.70 421,822.38 Hockey 60,000.00 2,050.00 44,670.00 74.45 15,330.00 Skating 75,650.00 600.50 16,510.00 21.82 59,140.00 Concessions 67,750.00 220.76 34,761.06 51.31 32,988.94 TOTAL REVENUES 859,450.00 49,924.99 330,168.68 38.42 529,281.32 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 744,900.00 50,121.76 175,848.90 23.61 569,051.10 Hockey 28,200.00 5,243.92 6,010.28 21.31 22,189.72 Skating 35,500.00 2,923.00 6,996.94 19.71 28,503.06 Arena Concessions 50,850.00 3,251.82 21,602.91 42.48 29,247.09 TOTAL Culture & Recreation 859,450.00 61,040.50 210,459.03 24.49 698,990.97 TOTAL EXPENDITURES 859,450.00 61,090.50 210,459.03 24.49 648,990.97 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 11,115.51) 119,709.65 ( 119,709.65) 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 221-ICE ARENA REVENUES Ice Arena 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Charges for Services 221-3-0000-3464 Ice Rental 449,800.00 40,651.11 197,773.99 43.97 252,026.01 221-3-0000-3465 Admissions 22,550.00 0.00 15,041.18 66.70 7,508.82 221-3-0000-3466 Dry Floor Events 12,000.00 5,461.00 7,886.00 65.72 9,114.00 221-3-0000-3468 Skate Sharpening 9,800.00 164.00 2,386.00 49.71 2,414.00 221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 17,000.00 ( 345.00)( 345.00) 2.03- 17,345.00 TOTAL Charges for Services 508,750.00 45,931.11 222,742.17 43.78 286,007.83 Other Revenue 221-3-0000-3622 Vending Machines 18,700.00 1,082.04 5,915.49 31.63 12,784.51 221-3-0000-3626 Contributions 0.00 0.00 4,619.00 0.00 ( 4,619.00) 221-3-0000-3629 Miscellaneous Revenue 2,000.00 90.58 950.96 47.55 1,099.04 TOTAL Other Revenue 20,700.00 1,122.62 11,485.45 55.49 9,214.55 Transfers In 221-3-0000-3922 Transfer-General Fund 126,600.00 0.00 0.00 0.00 126,600.00 TOTAL Transfers In 126,600.00 0.00 0.00 0.00 126,600.00 TOTAL Ice Arena 656,050.00 47,053.73 234,227.62 35.70 421,822.38 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-3465 Admissions TOTAL Charges for Services 60,000.00 2,050.00 94,670.00 74.45 15,330.00 60,000.00 2,050.00 94,670.00 74.45 15,330.00 60,000.00 2,050.00 94,670.00 74.45 15,330.00 70,000.00 3,500.00 73,500.00 510.50 16,375.00 23.39 53,625.00 0.00 0.00 0.00 3,500.00 510.50 16,375.00 22.28 57,125.00 5-12-2010 09:42 AM 221-ICE ARENA REVENUES CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 33.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue 2,150.00 90.00 135.00 6.28 2,015.00 TOTAL Other Revenue 2,150.00 90.00 135.00 6.28 2,015.00 TOTAL Skating 75,650.00 600.50 16,510.00 21.82 59,140.00 Concessions Charges for Services 221-3-5430-3467 Concessions 67,750.00 220.76 34,761.06 51.31 32,988.94 TOTAL Charges for Services 67,750.00 220.76 34,761.06 51.31 32,988.94 TOTAL Concessions 67,750.00 220.76 34,761.06 51.31 32,988.94 TOTAL REVENUE 859,450.00 49,924.99 330,168.68 38.42 529,281.32 5-12-2010 09:92 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 221-ICE ARENA DEPARTMENTAL EXPENDITURES 33.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ice Arena Personal Services 221-4-5400-4101 Regular Pay 221-4-5400-4102 Overtime Pay 221-9-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-9105 FICA 221-4-5400-9107 Medicare 221-4-5900-9108 Insurance 221-4-5400-4109 Workers Comp TOTAL Personal Services Supplies 221-4-5400-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/Mist 221-4-5400-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5400-4331 Travel, Conferences & Schools 221-4-5400-4359 Publishing 221-4-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5400-4415 Equipment Rental 221-4-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Transfers Out 221-4-5400-9730 Transfer-Debt Service TOTAL Transfers Out TOTAL Ice Arena Hockey 148,700.00 19,115.16 49,267.20 33.13 99,932.80 0.00 0.00 100.32 0.00 ( 100.32) 73,900.00 6,185.97 27;058.04 36.61 46,841.96 11,750.00 1,629.83 4,958.04 42.20 6,791.96 13,800.00 1,568.71 5,242.33 37.99 8,557.67 3,250.00 366.86 1,226.00 37.72 2,024.00 17,950.00 1,195.90 5,938.12 34.03 11,511.88 4,750.00 0.00 2,498.00 52.59 2,252.00 273,600.00 30,062.43 96,288.05 35.19 177,311.95 350.00 0.00 9.15 2.61 340.85 1,000.00 0.00 0.00 0.00 1,000.00 41,450.00 1,803.28 9,470.08 22.85 31,979.92 9,000.00 0.00 3,100.64 34.45 5,899.36 900.00 0.00 69.80 7.76 830.20 52,700.00 1,803.28 12,649.67 24.00 40,050.33 3,300.00 280.32 962.60 29.17 2,337.90 600.00 24.21 24.21 4.09 575.79 1,050.00 15.00 15.00 1.43 1,035.00 2,800.00 449.68 449.68 16.06 2,350.32 8,700.00 0.00 3,867.00 44.45 4,833.00 175,900.00 16,110.37 51,457.46 29.25 124,442.54 20,200.00 1,316.47 9,475.35 46.91 10,724.65 1,100.00 60.00 130.40 11.85 969.60 4,600.00 0.00 391.98 7.43 4,258.02 450.00 0.00 187.50 41.67 262.50 218,700.00 18,256.05 66,911.18 30.59 151,788.82 199,900.00 0.00 0.00 0.00 199,900.00 199,900.00 0.00 0.00 0.00 199,900.00 744,900.00 50,121.76 175,848.90 23.61 569,051.10 5-12-2010 09:42 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE PAGE: 5 Personal Services 221-4-5410-4103 Part-time Pay 221-4-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-4-5410-4359 Publishing 221-4-5910-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges 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 15,250.00 9,123.70 4,123.70 27.04 11,126.30 15,250.00 4,123.70 9,123.70 27.04 11,126.30 50.00 0.00 0.00 0.00 50.00 500.00 0.00 0.00 0.00 500.00 6,300.00 345.60 369.60 5.87 5,930.40 2,200.00 774.62 1,516.98 68.95 683.02 9,050.00 1,120.22 1,886.58 20.85 7,163.42 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5920-4104 PERA 221-4-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-5420-9359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Skating Arena Concessions 28,200.00 5,243.92 6,010.28 21.31 22,189.72 20,000.00 1,998.19 4,710.33 23.55 15,289.67 1,000.00 70.39 149.97 15.00 850.03 1,250.00 123.89 304.88 24.39 945.12 300.00 28.97 71.28 23.76 228.72 22,550.00 2,221.44 5,236.46 23.22 17,313.54 6,900.00 0.00 1,052.99 15.26 5,847.01 6,900.00 0.00 1,052.99 15.26 5,847.01 500.00 0.00 0.00 0.00 500.00 2,550.00 196.00 236.00 9.25 2,314.00 3,000.00 5.56 471.49 15.72 2,528.51 6,050.00 201.56 707.49 11.69 5,392.51 35,500.00 2,923.00 6,996.94 19.71 28,503.06 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 ' 221-ICE ARENA Culture & Recreation ' DEPARTMENTAL EXPENDITURES 33.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 807.63 6,865.13 32.85 14,034.87 221-4-5430-4104 PERA 200.00 26.03 181.89 90.95 18.11 221-9-5430-4105 FICA 1,300.00 50.09 468.47 36.04 831.53 221-4-5430-4107 Medicare 300.00 11.72 109.60 36.53 190.40 TOTAL Personal Services 22,700.00 895.47 7,625.09 33.59 15,074.91 Supplies 221-4-5430-4219 Operating Supplies 7,150.00 2.45 64.65 0.90 7,085.35 221-4-5430-9259 Other Merchandise For Resale 21,000.00 2,353.90 13,913.17 66.25 7,086.83 TOTAL Supplies 28,150.00 2,356.35 13,977.82 99.65 14,172.18 TOTAL Arena Concessions 50,850.00 3,251.82 21,602.91 42.48 29,247.09 TOTAL Culture & Recreation 859,450.00 61,040.50 210,459.03 24.49 648,990.97 TOTAL EXPENDITURES 859,450.00 61,040.50 210,459.03 24.49 648,990.97 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 11,115.51) 119,709.65 ( 119,709.65) 5-12-2010 09:42 AM 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 238,450.00 32,133.24 42,236.02 17.71 196,213.98 TOTAL REVENUES 238,450.00 32,133.24 42,236.02 17.71 196,213.98 EXPENDITURE SUMMARY Culture & Recreation Golf Course 238,450.00 24,304.59 48,264.73 20.24 190,185.27 TOTAL Culture & Recreation 238,450.00 24,304.59 48,264.73 20.29 190,185.27 TOTAL EXPENDITURES 238,450.00 24,304.59 48,264.73 20.24 190,185.27 REVENUES OVER/(UNDER) EXPENDITURES 0.00 7,828.65 ( 6,028.71) 6,028.71 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 ^ 222-PINEWOOD GOLF COURSE ' REVENUES 33.33°s 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-3476 Green Fees 222-3-0000-3477 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 22,000.00 6,484.00 8,524.00 38.75 13,476.00 19,000.00 1,497.38 1,622.69 8.54 17,377.31 5,000.00 502.95 581.20 11.62 4,418.80 115,000.00 15,367.99 17,499.49 15.22 97,500.51 14,000.00 6,000.00 11,540.00 82.43 2,460.00 18,500.00 2,301.50 2,486.00 13.94 16,014.00 7,000.00 0.00 0.00 0.00 7,000.00 500.00 0.00 0.00 0.00 500.00 201,000.00 32,153.82 92,253.38 21.02 158,746.62 0.00 ( 20.58)( 17.36) 0.00 17.36 0.00 ( 20.58)( 17.36) 0.00 17.36 37,450.00 0.00 0.00 0.00 37,450.00 37,450.00 0.00 0.00 0.00 37,450.00 238,450.00 32,133.24 42,236.02 17.71 196,213.98 ^ TOTAL REVENUE 238,450.00 32,133.24 92,236.02 17.71 196,213.98 5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2010 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 33.33 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 91,550.00 11,360.07 23,290.89 25.94 68,259.11 222-4-5300-4102 Overtime Pay 0.00 19.13 19.13 0.00 ( 19.13) 222-4-5300-9103 Part-time Pay 28,900.00 2,722.19 2,741.82 9.49 26,158.18 222-4-5300-4109 PERA 8,450.00 930.40 1,909.32 22.60 6,540.68 222-4-5300-4105 FICA 7,450.00 858.78 1,712.36 22.98 5,737.64 222-4-5300-4107 Medicare 1,750.00 200.85 400.49 22.89 1,349.51 222-4-5300-4108 Insurance 11,050.00 898.02 2,295.05 20.32 8,809.95 222-4-5300-4109 Workers Comp 1,250.00 0.00 622.50 49.80 627.50 TOTAL Persona l Services 150,400.00 16,989.39 32,941.56 21.90 117,458.44 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 848.49 848.49 16.97 4,151.51 222-4-5300-4217 Uniform Allowance 500.00 163.00 199.00 39.80 301.00 222-4-5300-4219 Operating Supplies 25,600.00 2,211.65 3,002.38 11.73 22,597.62 222-4-5300-4259 Other Merchandise For Resale 14,000.00 2,712.60 3,394.72 24.25 10,605.28 TOTAL Supplies 45,100.00 5,935.79 7,449.59 16.51 37,655.41 Other Services & Charges 222-4-5300-4321 Telephone 3,100.00 291.79 541.76 17.48 2,558.24 222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 127.96 25.59 372.04 222-4-5300-9349 Advertising/Marketing 1,000.00 150.00 150.00 15.00 850.00 222-4-5300-4361 Insurance 11,850.00 0.00 5,162.00 43.56 6,688.00 222-4-5300-4389 Utilities 7,150.00 180.57 330.50 4.62 6,819.50 222-4-5300-4401 Bldg Repair/Maint Services 1,000.00 20.04 60.12 6.01 939.88 222-4-5300-4404 Equip Repair/Maint Services 2,500.00 136.52 1,091.52 41.66 1,458.48 222-4-5300-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00 222-4-5300-4437 Taxes & Licenses 850.00 ( 982.70)( 1,127.46) 132.64- 1,977.46 222-4-5300-4438 Credit Card Fees 4,500.00 167.24 176.18 3.92 4,323.82 TOTAL Other Services & Charges 34,450.00 ( 36.54) 6,462.58 18.76 27,987.42 Debt Service 222-4-5300-4601 Principal 8,500.00 1,916.00 1,416.00 16.66 7,084.00 TOTAL Debt Service 8,500.00 1,416.00 1,416.00 16.66 7,084.00 TOTAL Golf Course 238,450.00 24,304.59 48,264.73 20.29 190,185.27 TOTAL Culture & Recreation 238,450.00 24,304.59 48,264.73 20.24 190,185.27 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 238,450.00 0.00 24,304.59 7,828.65 ( 98,264.73 20.24 6,028.71) 190,185.27 6,028.71 5-12-2010 09:43 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2010 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE 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 240-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 - 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 333-1010 Cash - 2002A Pub Safety Bonds 340-1010 Cash - Equipment Certificates 349-1010 Cash - 2006C Cap Imp Bonds Lby 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 440-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 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 24,141.95 1,217.59 25,359.04 3,787,313.69 ( 960,539.86) 2,826,778.83 396,395.63 ( 3,163.70) 393,231.93 116,336.41 ( 32,468.51) 83,867.90 ( 11,078.21) 7,325.54 ( 3,752.67) 11,310.66 229.69 11,540.35 ( 96,741.75) 0.00 ( 96,741.75) 1,134,017.79 ( 21,438.01) 1,112,579.78 677,155.04 0.00 677,155.04 863,580.69 4,967.11 868,547.80 221,546.94 4,828.04 226,374.98 150,683.53 5,000.00 155,683.53 1,334,695.45 ( 13,208.00) 1,321,437.95 502,509.41 22,286.10 524,795.51 2,461,488.40 94,428.93 2,555,917.33 2,075.41 1,746.98 3,822.39 140,922.84 0.00 140,922.84 825,358.22 0.00 825,358.22 25,000.00 0.00 25,000.00 86,099.39 0.00 86,099.39 116,479.58 0.00 116,479.58 192,534.49 0.00 192,539.49 175,120.99 137.45 175,258.49 7,776.45 ( 9,000.00) 3,776.45 ( 431.25) 0.00 ( 431.25) ( 76,171.25) 0.00 ( 76,171.25) 2,446,101.07 2,644.00 2,448,745.07 2,819,596.15 10,582.81 2,830,178.96 298,174.91 ( 1,575.33) 296,599.58 271,708.20 0.00 271,708.20 3,546,462.61 0.00 3,546,462.61 741,101.52 ( 191,510.38) 599,591.14 1,574,757.15 0.00 1,574,757.15 ( 75,884.93) ( 4,624.66) ( 80,509.59) 16,727.13 ( 3,087.82) 13,639.31 546,673.16 0.00 546,673.16 ( 760.00) 0.00 ( 760.00) 3,968,519.00 30,169.18 3,998,688.18 3,749,529.91 57,486.82 3,807,016.73 374,529.19 19,589.84 394,119.03 0.00 69,464.32 69,464.32 45,796.86 ( 420.62) 45,376.24 33,391,101.93 ( 853,927.49) 32,537,179.44