Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #2 10-18-2010
Y MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: October 18, 2010 SUBJECT: September 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 September, actual revenues (except fox property taxes and state aids) and expenditures should run 75% 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 about 52.7% of budget. • Collection of the cable franchise tax from Sherburne-Wright Cable Commission was received in September. • License and permit collections are slightly over 100% of the budget. Building permit revenue includes permit fee collections in September for The Depot @ Elk River Station and storm damage repairs. • Intergovernmental revenue police aid will be received in October. • Charges for services are 85% of budget and continue to exceed budget estimates as of the end of September. • Fine collections are slightly below budget at 71% due to a one month lag in the collection of court fines. • All revenue transfers in to the general fund have been recorded. Expenditures: • Excluding transfers out, the total departmental expenditures are about 66% and most departments are well within or below budget. • The transfers out to the Ice Arena and Pinewood Golf are made at the end of the year. Ice Arena As of the end of September, revenues exceed expenditures by $5,715. Revenue collections of $423,382 are about 58% of budget estimates (excluding transfers in) and dry floor revenues exceed 100% of the budget. Expenditures of $417,667 are about 49% of budget estimate. Pinewood Golf For the month ended September, expenditures exceed revenues by $9,305 with the arrival of the fall season. Golf revenues collected through September of $172,176 account for about 85.6% of budget estimates, excluding transfers in, and expenditures of $181,481 are about 76% of budget. I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND FINANCIAL SUMMARY 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY General Fund ~ TOTAL REVENUES ' EXPENDITURE SUMMARY 11,719,800.00 163,095.09 6,463,802.01 55.15 5,255,997.99 11,719,800.00 163,095.09 6,463,802.01 55.15 5,255,997.99 General Government Mayor & Council 167,650.00 1,668.97 82,183.84 49.02 85,466.16 Cable TV 81,650.00 5,325.46 48,960.50 59.96 32,689.50 Administrative Services 470,500.00 33,799.90 322,032.97 68.44 148,467.53 Human Resources 150,450.00 10,803.98 102,575.88 68.18 47,874.12 Elections 38,100.00 893.91 13,780.01 36.17 24,319.99 Finance 447,400.00 27,852.79 333,182.25 74.47 114,217.75 Information Technology 303,150.00 19,787.77 167,199.42 55.15 135,950.55 Legal 234,000.00 39,572.00 139,868.64 59.77 94,131.36 Community Development 67,150.00 5,105.69 46,379.79 69.07 20,770.21 Planning 299,950.00 23,029.27 209,134.03 69.72 90,815.97 City Hall Maintenance 297,000.00 21,833.72 196,365.51 66.12 100,634.49 Contingency 113,100.00 0.00 3,865.52 3.42 109,234.48 TOTAL General Government 2,670,100.00 189,661.96 1,665,527.86 62.38 1,004,572.19 Public Safety Police Administration 543,800.00 29,484.45 366,770.19 67.45 177,029.81 Patrol 2,245,150.00 162,768.10 1,462,134.33 65.12 783,015.67 Investigations 731,350.00 50,034.73 482,258.86 65.94 249,091.14 Police Support Services 501,900.00 38,933.34 329,610.89 65.67 172,289.11 Police Reserves 22,900.00 370.65 4,554.96 19.89 18,345.04 Public safety building 206,250.00 10,840.81 136,004.21 65.94 70,245.79 Fire Administration 965,550.00 24,888.68 310,705.80 66.74 159,844.20 Eire Inspections 184,600.00 15,022.27 126,106.40 68.31 58,493.60 Emergency Management 30,800.00 1,323.28 14,031.57 45.56 16,768.43 Building Safety 465,550.00 34,799.01 317,188.26 68.13 198,361.74 Environmental 52,200.00 4,187.78 35,552.69 68.11 16,647.36 TOTAL Public Safety 5,450,050.00 372,653.10 3,584,918.11 65.78 1,865,131.89 Public Works Street Maintenance 1,336,950.00 119,537.80 926,599.92 69.31 410,350.08 Snow Removal 246,550.00 0.00 164,392.88 66.66 82,207.12 Equipment Services 246,300.00 17,790.16 162,171.62 65.84 84,128.38 Engineering 178,350.00 11,988.33 32,756.73 18.37 145,593.27 TOTAL Public Works 2,008,150.00 149,316.29 1,285,871.15 64.03 722,278.85 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND FINANCIAL SUMMARY 75.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I 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 72,349.67 553,824.52 72.19 213,325.48 593,300.00 30,392.37 349,076.22 64.25 194,223.78 173,550.00 19,852.00 150,649.61 86.80 22,900.39 13,850.00 1,254.34 10,087.19 72.83 3,762.81 203,250.00 15,935.04 127,942.97 62.95 75,307.03 1,701,100.00 134,783.42 1,191,580.51 70.05 509,519.49 0.00 13,678.44 55,429.61 0.00 ( 55,429.61) 51,350.00 8,112.53 30,496.74 59.39 20,853.26 51,350.00 21,790.97 85,926.35 167.33 ( 34,576.35) 164,050.00 0.00 0.00 0.00 164,050.00 164,050.00 0.00 0.00 0.00 164,050.00 12,044,800.00 863,205.74 7,813,823.98 64.87 4,230,976.02 ( 325,000.00)( 700,110.65)( 1,350,021.97) 1,025,021.97 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND 75.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,688,950.00 0.00 9,586,732.82 47.34 5,102,217.18 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 138,752.72 0.00 ( 138,752.72) 101-3-0000-3119 My Reduction ( 221,100.00) 0.00 0.00 0.00 ( 221,100.00) 101-3-0000-3121 Gravel Tax 135,000.00 0.00 22,229.69 16.47 112,770.31 101-3-0000-3123 Franchise Tax 0.00 44,922.02 131,111.55 0.00 ( 131,111.55) 101-3-0000-3131 Penalties/Interest 0.00 0.00 5,458.20 0.00 ( 5,458.20) TOTAL Taxes 9,602,850.00 44,922.02 4,884,284.98 50.86 4,718,565.02 Licenses & Permits 101-3-0000-3211 Liquor License 51,000.00 4,196.64 58,869.14 115.43 ( 7,869.14) 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 87.50 2.92 2,912.50 101-3-0000-3214 Apartment License 15,850.00 915.00 19,385.00 90.76 1,465.00 101-3-0000-3216 Mining License 20,000.00 0.00 20,932.65 109.66 ( 932.65) 101-3-0000-3217 Garbage Hauler License 3,000.00 0.00 885.00 29.50 2,115.00 101-3-0000-3218 Other Business License/Permit 13,000.00 ( 640.00) 15,480.00 119.08 ( 2,480.00) 101-3-0000-3229 NPDES Permit 2,000.00 350.00 2,450.00 122.50 ( 450.00) 101-3-0000-3231 Building Permit 135,000.00 49,768.45 191,161.70 104.56 ( 6,161.70) 101-3-0000-3232 Plumbing/Heating Permit 40,000.00 7,377.38 29,659.69 74.15 10,340.31 101-3-0000-3233 Permit Surcharge 200.00 2,090.64 3,734.94 1,867.47 ( 3,534.94) 101-3-0000-3235 Animal License 3,000.00 154.00 3,178.00 105.93 ( 178.00) 101-3-0000-3236 Parking Permit 2,000.00 0.00 880.00 49.00 1,120.00 101-3-0000-3237 Other Non-Business Lic/Permit 10,000.00 1,685.00 9,720.00 97.20 280.00 TOTAL Licenses & Permits 299,050.00 65,847.11 301,423.62 100.79 ( 2,373.62) Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,000.00 2,665.74 3,913.13 130.44 ( 913.13) 101-3-0000-3324 PERA Aid 14,000.00 0.00 6,992.00 49.94 7,008.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 11,113.35 111.13 ( 1,113.35) 101-3-0000-3327 State-Aid Street Maint 39,000.00 0.00 42,827.72 109.81 ( 3,827.72) 101-3-0000-3329 State Crime Prevention Grant 13,000.00 0.00 14,826.08 114.05 ( 1,826.08) 101-3-0000-3330 Other State Grants 4,900.00 0.00 0.00 0.00 4,900.00 101-3-0000-3391 County Reimb/Grant 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Intergovernmental Rev 288,900.00 2,665.74 79,672.28 27.58 209,227.72 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 2,470.00 13,506.00 90.04 1,494.00 101-3-0000-3413 Plan Check Fee 50,000.00 18,210.77 90,305.24 80.61 9,694.76 101-3-0000-3415 Special Assessment Search 500.00 120.00 890.00 168.00 ( 390.00) 101-3-0000-3417 Copies 1,500.00 71.38 1,878.12 125.21 ( 378.12) 101-3-0000-3418 Other General Govt Services 4,000.00 188.75 1,943.33 48.58 2,056.67 101-3-0000-3430 Lockout Fees 8,000.00 690.00 6,080.00 76.00 1,920.00 101-3-0000-3431 Police Services 2,000.00 380.00 2,909.00 145.95 ( 909.00) I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 1 101-GENERAL FUND ~ REVENUES 75.00 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 101-3-0000-3432 School Liaison 101-3-0000-3434 Animal Impound Fee 101-3-0000-3435 Vehicle Impound 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Calls 101-3-0000-3951 Street Services 101-3-0000-3461 Recreation Eees 101-3-0000-3967 Concessions 101-3-0000-3972 Park Use Fee 101-3-0000-3974 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Other 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 75,000.00 0.00 75,000.00 100.00 0.00 3,000.00 300.00 2,550.00 85.00 450.00 0.00 0.00 170.00 0.00 ( 170.00) 185,000.00 0.00 124,759.00 67.94 60,291.00 1,000.00 4,425.00 9,425.00 942.50 ( 3,425.00) 25,000.00 200.00 19,074.79 76.30 5,925.21 114,200.00 5,388.07 118,856.68 104.08 ( 4,656.68) 14,100.00 1,972.00 8,775.26 62.24 5,324.74 18,000.00 2,872.78 18,137.44 100.76 ( 137.94) 4,300.00 ( 156.02) 4,096.95 95.28 203.05 7,800.00 1,100.00 5,850.00 75.00 1,950.00 2,500.00 195.00 3,120.00 124.80 ( 620.00) 300.00 90.00 295.00 98.33 5.00 531,200.00 38,417.73 452,571.81 85.20 78,628.19 125,000.00 10,968.99 89,506.48 71.61 35,493.52 10,000.00 80.00 6,425.00 64.25 3,575.00 0.00 0.00 650.00 0.00 ( 650.00) 135,000.00 11,098.99 96,581.48 71.54 38,418.52 160,000.00 0.00 13,692.38 8.56 146,307.62 72,000.00 36.20 3,490.36 4.85 68,509.69 22,200.00 88.00 20,287.00 91.38 1,913.00 3,000.00 69.30 6,198.10 206.60 ( 3,198.10) 257,200.00 193.50 43,667.84 16.98 213,532.16 101-3-0000-3925 Transfer-Landfill 35,000.00 0.00 35,000.00 100.00 0.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 39,500.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 50,000.00 0.00 50,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 248,600.00 0.00 248,600.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 206,000.00 0.00 206,000.00 100.00 0.00 101-3-0000-3948 Transfer-EDA 17,000.00 0.00 17,000.00 100.00 0.00 101-3-0000-3949 Transfer-HRA 9,500.00 0.00 9,500.00 100.00 0.00 TOTAL Transfers In 605,600.00 0.00 605,600.00 100.00 0.00 TOTAL General Fund 11,719,800.00 163,095.09 6,463,802.01 55.15 5,255,997.99 TOTAL REVENUE 11,719,800.00 163,095.09 6,463,802.01 55.15 5,255,997.99 10-13-2010 07:96 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND ~ DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 75.OOo OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-9104 PERA 101-4-1110-9105 FICA 101-4-1110-9107 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-9-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-9-1110-4433 Dues & Subscriptions 101-4-1110-9440 Miscellaneous TOTAL Other Services & Charges I TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-9105 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 38,500.00 3,208.00 28,872.00 74.99 9,628.00 1,950.00 100.91 903.69 46.34 1,046.31 2,400.00 162.73 1,445.97 60.25 954.03 550.00 46.52 418.68 76.12 131.32 50.00 0.00 33.00 66.00 17.00 43,450.00 3,517.66 31,673.34 72.90 11,776.66 2,800.00 257.23 949.87 16.07 2,350.13 2,800.00 257.23 449.87 16.07 2,350.13 10,750.00 ( 2,650.00) 1,509.51 14.09 9,290.49 500.00 0.00 82.02 16.40 417.98 3,100.00 159.58 1,002.66 32.34 2,097.34 18,200.00 375.00 9,171.48 50.39 9,028.52 68,050.00 0.00 34,533.50 50.75 33,516.50 15,500.00 0.00 500.00 3.23 15,000.00 5,300.00 9.00 3,261.96 61.54 2,038.54 121,400.00 ( 2,106.92) 50,060.63 41.24 71,339.37 167,650.00 1,668.47 82,183.89 49.02 85,466.16 52,000.00 9,083.20 35,890.01 69.02 16,109.99 11,750.00 146.88 2,628.16 22.37 9,121.84 3,650.00 285.82 2,630.78 72.08 1,019.22 3,950.00 260.29 2,483.14 62.86 1,966.86 900.00 60.87 580.79 64.53 319.21 5,500.00 949.00 9,041.00 73.47 1,459.00 200.00 0.00 132.75 66.38 67.25 77,950.00 5,286.06 48,386.63 62.07 29,563.37 1,000.00 0.00 285.32 28.53 714.68 1,000.00 0.00 285.32 28.53 714.68 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OE: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND General Government 1 DEPARTMENTAL EXPENDITURES Other Services & Charges 101-4-1120-4319 Other Professional Services 101-4-1120-4322 Postage 101-4-1120-9331 Travel, Conferences & Schools 101-4-1120-9404 Equip Repair/Maint Services TOTAL Other Services & Charges 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 500.00 0.00 0.00 0.00 500.00 50.00 0.00 1.34 2.68 48.66 1,700.00 39.40 277.21 16.31 1,922.79 450.00 0.00 10.00 2.22 940.00 2,700.00 39.40 288.55 10.69 2,411.45 TOTAL Cable TV Administrative Services Personal Services 101-4-1210-4101 Regular Pay 101-4-1210-4103 Part-time Pay 101-4-1210-4104 PERA 101-4-1210-4105 FICA 101-4-1210-4106 Other Retirement Contributions 101-4-1210-4107 Medicare 101-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-4322 Postage 101-4-1210-4331 Travel, Conferences & Schools 101-4-1210-4361 Insurance 101-4-1210-4409 Equip Repair/Maint Services 101-4-1210-4433 Dues & Subscriptions TOTAL Other Services & Charges 81,650.00 5,325.46 48,960.50 59.96 32,689.50 295,100.00 22,806.29 205,056.30 69.49 90,043.70 44,900.00 3,208.01 30,771.81 68.53 14,128.19 23,800.00 1,821.00 17,289.99 72.65 6,510.01 21,100.00 1,540.82 19,694.01 69.64 6,405.99 4,800.00 900.00 3,600.00 75.00 1,200.00 4,950.00 360.36 3,436.61 69.43 1,513.39 24,600.00 2,250.01 20,250.09 82.32 4,349.91 1,500.00 0.00 1,203.00 80.20 297.00 420,750.00 32,386.49 296,301.81 70.42 124,448.19 13,000.00 13.89 6,290.14 98.39 6,709.86 13,000.00 13.84 6,290.14 98.39 6,709.86 5,100.00 0.00 5,318.00 104.27 ( 218.00) 900.00 61.24 485.90 53.99 414.10 1,500.00 0.00 431.16 28.74 1,068.84 5,350.00 217.64 2,792.20 52.19 2,557.80 250.00 0.00 96.50 18.60 203.50 21,650.00 1,115.19 9,849.86 95.50 11,800.14 2,000.00 0.00 516.90 25.85 1,483.10 36,750.00 1,394.07 19,940.52 52.90 17,309.48 TOTAL Administrative Services Human Resources 470,500.00 33,799.90 322,032.47 68.94 148,467.53 10-13-2010 07:46 AM 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES PAGE: 7 75.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 67,850.00 5,346.15 47,818.94 70.48 20,031.06 101-4-1220-4103 Part-time Pay 48,000.00 3,904.61 32,151.95 66.98 15,848.05 101-4-1220-4104 PERA 8,100.00 612.54 5,880.88 72.60 2,219.12 101-4-1220-4105 FICA 7,200.00 537.02 5,169.68 71.80 2,030.32 101-4-1220-4107 Medicare 1,700.00 125.58 1,208.99 71.12 491.01 101-4-1220-4108 Insurance 5,500.00 469.01 4,221.09 76.75 1,278.91 101-4-1220-4109 Workers Comp 500.00 0.00 410.25 82.05 89.75 TOTAL Personal Services 138,850.00 10,494.91 96,861.78 69.76 41,988.22 Supplies 101-4-1220-4201 Office Supplies 4,100.00 309.12 9,113.45 100.33 ( 13.45) TOTAL Supplies 4,100.00 309.12 9,113.45 100.33 ( 13.45) Other Services & Charges 101-4-1220-4319 Other Professional Services 3,000.00 0.00 378.00 12.60 2,622.00 101-4-1220-4322 Postage 350.00 0.00 267.26 76.36 82.74 101-4-1220-4331 Travel, Conferences & Schools 2,250.00 0.00 384.35 17.08 1,865.65 101-4-1220-4433 Dues & Subscriptions 900.00 0.00 45.00 5.00 855.00 101-4-1220-4440 Miscellaneous 1,000.00 4.95 526.04 52.60 473.96 TOTAL Other Services & Charges 7,500.00 4.95 1,600.65 21.39 5,899.35 TOTAL Human Resources Elections Personal Services 101-4-1230-9103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1230-4322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4404 Equip Repair/Maint Services 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges ~ TOTAL Elections CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 150,450.00 10,803.98 102,575.88 68.18 47,879.12 30,000.00 0.00 12,260.73 40.87 17,739.27 30,000.00 0.00 12,260.73 40.87 17,739.27 4,600.00 808.51 851.84 18.52 3,748.16 4,600.00 808.51 851.84 18.52 3,748.16 700.00 0.00 194.54 20.65 555.46 700.00 84.90 107.90 15.41 592.10 1,000.00 0.00 405.00 90.50 595.00 100.00 0.00 10.00 10.00 90.00 1,000.00 0.00 0.00 0.00 1,000.00 3,500.00 84.90 667.44 19.07 2,832.56 38,100.00 893.41 13,780.01 36.17 24,319.99 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OE: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 75.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Finance Personal Services 101-4-1310-4101 Regular Pay 101-9-1310-4103 Part-time Pay 101-4-1310-4104 PERA 101-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-9-1310-4108 Insurance 101-9-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-9201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-9-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-9-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4909 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges 285,500.00 22,139.37 199,891.92 70.01 85,608.08 2,000.00 160.00 890.00 44.50 1,110.00 20,000.00 1,549.76 14,529.38 72.62 5,475.62 17,850.00 1,293.44 12,159.07 68.09 5,695.93 9,200.00 302.50 2,842.99 67.68 1,357.51 24,600.00 2,043.01 18,387.09 74.79 6,212.91 1,250.00 0.00 1,010.25 80.82 239.75 355,400.00 27,488.08 249,700.20 70.26 105,699.80 3,850.00 5.77 1,037.05 26.99 2,812.95 3,850.00 5.77 1,037.05 26.94 2,812.95 18,000.00 0.00 17,760.00 98.67 290.00 49,000.00 0.00 98,725.00 99.49 275.00 800.00 58.99 991.91 61.49 308.09 3,600.00 0.00 1,139.37 31.65 2,460.63 2,950.00 0.00 1,113.69 37.75 1,836.31 1,200.00 300.00 827.00 68.92 373.00 11,100.00 0.00 10,943.03 98.59 156.97 1,500.00 0.00 1,445.00 96.33 55.00 88,150.00 358.94 82,445.00 93.53 5,705.00 TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101-4-1350-4103 Part-time Pay 101-4-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-9108 Insurance 101-9-1350-4109 Workers Comp TOTAL Personal Services 447,400.00 27,852.79 333,182.25 74.47 114,217.75 128,400.00 9,875.46 89,372.80 69.60 5,000.00 1,450.00 3,135.00 62.70 9,000.00 691.28 6,554.82 72.83 8,300.00 653.90 5,655.92 68.14 1,950.00 152.92 1,322.72 67.83 16,100.00 1,578.01 13,750.07 85.40 600.00 0.00 454.50 75.75 169,350.00 14,401.57 120,245.83 71.00 39,027.20 1,865.00 2,445.18 2,644.08 627.28 2, 399.93 49,104.17 10-13-2010 07:46 AM 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 CURRENT CURRENT BUDGET PERIOD PAGE: 9 75.00$ OF YEAR COMP. YEAR TO DATE a OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-1350-4219 Operating Supplies 29,900.00 372.24 17,754.53 59.38 12,195.97 TOTAL Supplies 29,900.00 372.29 17,754.53 59.38 12,195.97 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 1,593.90 5,503.50 68.79 2,496.50 101-4-1350-4321 Telephone 750.00 59.23 426.63 56.88 323.37 101-4-1350-4331 Travel, Conferences & Schools 7,300.00 62.15 571.40 7.83 6,728.60 101-4-1350-4904 Equip Repair/Maint Services 16,950.00 653.39 9,147.29 53.97 7,802.76 TOTAL Other Services & Charges 33,000.00 2,363.67 15,698.77 97.42 17,351.23 Capital Outlay 101-4-1350-9560 Equipment 70,900.00 2,650.29 13,550.29 19.11 57,349.71 TOTAL Capital Outlay 70,900.00 2,650.29 13,550.29 19.11 57,349.71 TOTAL Information Technology 303,150.00 19,787.77 167,199.42 55.15 135,950.58 Legal Other Services & Charges 101-4-1400-9304 Legal Fees 234,000.00 34,572.00 139,868.64 59.77 94,131.36 TOTAL Other Services & Charges 234,000.00 34,572.00 139,868.64 59.77 94,131.36 TOTAL Legal Community Development Personal Services 101-4-1500-4101 Regular Pay 101-4-1500-4109 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-9-1500-4108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1500-4201 Office Supplies TOTAL Supplies 234,000.00 39,572.00 139,868.64 59.77 94,131.36 52,700.00 4,052.81 36,475.27 69.21 16,224.73 3,700.00 283.70 2,675.90 72.32 1,024.10 3,250.00 293.27 2,302.89 70.86 947.11 750.00 56.90 538.69 71.82 211.36 5,500.00 469.01 4,181.28 76.02 1,318.72 600.00 0.00 186.75 31.13 413.25 66,500.00 5,105.69 46,360.73 69.72 20,139.27 150.00 0.00 19.06 12.71 130.99 150.00 0.00 19.06 12.71 130.94 10-13-2010 07:46 AM 101-GENERAL FUND General Government 1 DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD PAGE: 10 75.00 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Other Services & Charges 101-9-1500-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 TOTAL Other Services & Charges 500.00 0.00 0.00 0.00 TOTAL Community Development 67,150.00 5,105.69 46,379.79 69.07 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-9109 Workers Comp TOTAL Personal Services Supplies 101-9-1510-4201 Office Supplies 101-4-1510-9212 Fuels & Lubs 101-4-1510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1510-4321 Telephone 101-4-1510-4322 Postage 101-4-1510-9331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-9-1510-4433 Dues & Subscriptions 101-4-1510-4440 Miscellaneous TOTAL Other Services & Charges 500.00 20,770.21 208,900.00 16,301.68 146,034.29 69.91 62,865.76 14,600.00 1,141.12 10,708.50 73.35 3,891.50 12,950.00 922.36 8,707.38 67.24 9,242.62 3,050.00 215.72 2,036.47 66.77 1,013.53 26,950.00 2,254.01 20,286.09 75.27 6,663.91 650.00 0.00 962.00 71.08 188.00 267,100.00 20,834.89 188,234.68 70.47 78,865.32 4,750.00 161.38 2,778.70 58.50 1,971.30 2,550.00 102.52 1,023.59 40.14 1,526.41 0.00 35.49 35.49 0.00 ( 35.49) 7,300.00 299.39 3,837.78 52.57 3,462.22 800.00 93.21 421.61 52.70 378.39 2,000.00 0.00 1,981.96 99.10 18.04 6,050.00 250.00 3,403.62 56.26 2,646.38 10,000.00 1,215.00 6,015.00 60.15 3,985.00 450.00 0.00 97.00 10.94 403.00 5,000.00 331.78 4,359.38 87.19 690.62 1,000.00 0.00 695.00 69.50 305.00 250.00 0.00 138.00 55.20 112.00 25,550.00 1,889.99 17,061.57 66.78 8,488.43 TOTAL Planning City Hall Maintenance Personal Services 101-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 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 299,950.00 23,024.27 209,134.03 69.72 90,815.97 87,350.00 8,238.02 70,467.73 80.67 2,500.00 0.00 373.40 14.99 23,050.00 2,131.26 19,851.71 86.12 8,100.00 703.88 6,352.39 78.42 7,150.00 641.09 5,906.49 82.61 1,650.00 149.98 1,381.44 83.72 500.00 16,882.27 2,126.60 3,198.29 1,747.66 1,243.51 268.56 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 75.OOa OF YEAR COMP. $ OF BUDGET BUDGET BALANCE 101-4-1600-9108 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 101-4-1600-4331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-9389 Utilities 101-4-1600-4401 Bldg Repair/Maint Services 101-4-1600-9404 Equip Repair/Maint Services 101-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges I TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 16,350.00 1,214.92 11,951.10 73.10 4,550.00 0.00 3,972.00 87.30 150,700.00 13,079.15 120,256.21 79.80 30,943.79 3,750.00 262.58 1,937.95 51.68 1,812.05 1,700.00 0.00 792.63 96.63 907.37 30,400.00 2,235.08 19,377.70 63.74 11,022.30 35,850.00 2,497.66 22,108.28 61.67 13,741.72 15,950.00 1,126.60 9,215.41 59.65 6,234.59 2,000.00 0.00 200.00 10.00 1,800.00 4,500.00 0.00 2,239.50 99.77 2,260.50 51,800.00 1,293.18 23,057.83 44.51 28,742.17 30,650.00 3,799.63 18,440.78 60.17 12,209.22 5,000.00 0.00 60.00 1.20 4,940.00 1,050.00 87.50 787.50 75.00 262.50 110,450.00 6,256.91 54,001.02 48.89 56,448.98 297,000.00 21,833.72 196,365.51 66.12 100,634.49 113,100.00 0.00 3,865.52 3.42 109,234.48 113,100.00 0.00 3,865.52 3.42 109,234.98 TOTAL Contingency 113,100.00 0.00 3,865.52 3.42 109,234.98 TOTAL General Government Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PERA 101-9-2110-4107 Medicare 101-4-2110-9108 Insurance 101-4-2110-9109 Workers Comp TOTAL Personal Services 2,670,100.00 184,661.96 1,665,527.86 62.38 1,004,572.14 275,400.00 21,182.94 191,701.06 69.61 83,698.94 38,850.00 2,986.74 28,374.03 73.03 10,475.97 1,250.00 201.50 1,918.73 153.50 ( 668.73) 29,400.00 2,027.02 18,243.18 74.77 6,156.82 55,150.00 0.00 90,171.50 72.84 14,978.50 395,050.00 26,397.70 280,408.50 70.98 114,641.50 4,398.90 578.00 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Public Safety 1 DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies 17,000.00 230.30 5,654.45 33.26 11,345.55 2,150.00 14.98 1,939.48 90.21 210.52 1,950.00 0.00 1,420.14 72.83 529.86 21,100.00 245.28 9,014.07 42.72 12,085.93 Other Services & Charges 101-4 -2110- 4319 Other Professional Services 5,500.00 0.00 0.00 0.00 5,500.00 101-4 -2110- 9321 Telephone 27,400.00 1,916.92 15,107.85 55.14 12,292.15 101-4 -2110- 9322 Postage 2,100.00 8.85 1,022.53 48.69 1,077.47 101-4 -2110 -4331 Travel, Conferences & Schools 4,300.00 ( 1,039.10) 1,686.50 39.22 2,613.50 101-4 -2110-4359 Publishing 500.00 0.00 224.40 49.88 275.60 101-4 -2110 -4361 Insurance 9,850.00 0.00 4,460.50 45.28 5,389.50 101-4 -2110 -4404 Equip Repair/Maint Services 68,900.00 863.30 45,775.64 66.44 23,124.36 101-4 -2110 -4933 Dues & Subscriptions 8,900.00 1,071.50 8,922.45 106.22 ( 522.45) 101-4 -2110 -4937 Taxes & Licenses 700.00 20.00 197.75 21.11 552.25 TO TAL Other Services & Charges 127,650.00 2,841.47 77,397.62 60.59 50,302.38 TOTAL Police Administration ~ Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-9104 PERA 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-9-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-9460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Patrol 543,800.00 29,484.45 366,770.19 67.45 177,029.81 1,441,800.00 103,885.56 961,752.57 66.70 480,047.93 90,000.00 8,156.70 48,671.76 54.08 91,328.24 216,000.00 15,797.97 199,520.18 69.22 66,479.82 19,900.00 1,324.70 12,557.22 63.10 7,342.78 163,500.00 13,533.33 129,251.14 75.99 39,248.86 1,931,200.00 142,698.26 1,296,752.87 67.15 634,447.13 118,350.00 9,824.72 66,545.20 56.23 51,809.80 15,850.00 609.44 7,777.78 49.07 8,072.22 69,650.00 3,818.02 31,878.07 95.77 37,771.93 28,000.00 1,249.49 6,944.35 24.80 21,055.65 231,850.00 15,501.67 113,145.40 48.80 118,704.60 15,300.00 820.00 19,118.45 92.28 1,181.55 27,350.00 506.50 8,752.58 32.00 18,597.92 550.00 0.00 190.00 34.55 360.00 38,900.00 3,241.67 29,175.03 75.00 9,729.97 82,100.00 4,568.17 52,236.06 63.62 29,863.94 2,245,150.00 162,768.10 1,962,134.33 65.12 783,015.67 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 13 REVENGE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4-2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Investigations Police Support Services Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-9102 Overtime Pay 101-4-2150-9104 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 505,900.00 36,264.80 344,531.31 68.17 160,868.69 40,000.00 592.50 10,775.27 26.94 29,224.73 76,900.00 5,194.08 50,734.35 65.97 26,165.65 4,750.00 390.15 3,574.21 75.25 1,175.79 61,650.00 5,569.86 98,142.13 78.09 13,507.87 688,700.00 48,011.39 457,757.27 66.47 230,942.73 5,050.00 53.38 2,700.94 53.48 2,349.06 6,800.00 529.13 4,159.72 61.17 2,640.28 11,850.00 582.51 6,860.66 57.90 4,989.34 11,900.00 245.00 2,248.93 18.89 9,651.57 4,050.00 25.00 4,900.03 108.64 ( 350.03) 800.00 0.00 955.00 56.88 345.00 14,050.00 1,170.83 10,537.97 75.00 3,512.53 30,800.00 1,490.83 17,640.93 57.28 13,159.07 731,350.00 50,034.73 482,258.86 65.94 249,091.19 347,300.00 28,197.92 232,680.85 67.00 114,619.15 6,500.00 0.00 148.14 2.28 6,351.86 24,750.00 2,095.49 17,301.70 69.91 7,448.30 21,950.00 1,605.38 19,752.65 67.21 7,197.35 5,150.00 399.74 3,482.97 67.63 1,667.03 44,150.00 3,632.07 30,964.18 70.13 13,185.82 449,800.00 35,930.60 299,330.49 66.55 150,469.51 1,000.00 0.00 179.21 17.92 825.79 2,750.00 185.96 1,137.19 41.35 1,612.81 9,150.00 1,213.63 4,591.94 50.19 4,558.06 12,900.00 1,399.59 5,903.34 45.76 6,996.66 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,550.00 0.00 1,458.38 41.08 2,091.62 101-4-2150-4404 Equip Repair/Maint Services 2,650.00 0.00 2,182.69 82.37 467.31 101-4-2150-9409 Contractual Services 16,000.00 1,178.15 6,385.79 39.91 9,614.26 101-4-2150-9433 Dues & Subscriptions 500.00 0.00 222.50 44.50 277.50 101-4-2150-4460 Equip Replacement Charge 5,100.00 425.00 3,825.00 75.00 1,275.00 TOTAL Other Services & Charges 27,800.00 1,603.15 14,074.31 50.63 13,725.69 Capital Outlay 101-4-2150-4560 Equipment 11,400.00 0.00 10,302.75 90.38 1,097.25 TOTAL Capital Outlay 11,400.00 0.00 10,302.75 90.38 1,097.25 TOTAL Police Support Services 501,900.00 38,933.39 329,610.89 65.67 172,289.11 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 146.86 2,172.76 39.50 3,327.24 101-4-2160-4105 FICA 350.00 9.11 137.19 39.20 212.81 101-4-2160-4107 Medicare 100.00 2.13 32.07 32.07 67.93 TOTAL Personal Services 5,950.00 158.10 2,342.02 39.36 3,607.98 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 22.29 119.75 2.40 4,880.25 101-9-2160-4219 Operating Supplies 6,000.00 50.80 319.24 5.32 5,680.76 TOTAL Supplies 11,000.00 73.09 438.99 3.99 10,561.01 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.46 1,255.95 78.50 344.05 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0.00 1,700.00 101-4-2160-9359 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.46 1,773.95 29.81 4,176.05 TOTAL Police Reserves Public safety building Personal Services 101-9-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4104 PERA 101-4-2190-9105 FICA 101-4-2190-4107 Medicare 22,900.00 370.65 4,554.96 19.89 18,345.04 100,600.00 7,404.19 66,685.99 66.29 33,914.51 0.00 0.00 85.50 0.00 ( 85.50) 7,050.00 518.28 4,844.31 68.71 2,205.69 6,250.00 451.66 4,212.65 67.40 2,037.35 1,950.00 105.64 985.31 67.95 464.69 1 10-13-2010 07:46 AM I 101-GENERAL FUND Public Safety 1 DEPARTMENTAL EXPENDITURES I 101-4-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 75.00 OF YEAR COMP. 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 CURRENT CURRENT YEAR TO DATE ~ OE BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 12,650.00 1,111.95 9,077.82 71.76 3,572.18 4,050.00 0.00 2,304.00 56.89 1,746.00 132,050.00 9,591.72 88,195.08 66.79 93,854.92 18,200.00 18,200.00 6,500.00 18,200.00 31,300.00 56,000.00 619.18 18,211.81 100.06 ( 11.81) 619.18 18,211.81 100.06 ( 11.81) 0.00 3,123.00 38.19 13,810.99 591.72 12,663.83 629.91 29,597.32 98.05 3,377.00 75.88 4,389.51 40.46 18,636.17 52.85 26,402.68 TOTAL Public safety building ~ Fire Administratio^ Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-9102 Overtime Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-9-2310-4105 FICA 101-9-2310-4106 Other Retirement Contributions 101-4-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-9109 Workers Comp 101-9-2310-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-9212 Fuels & Lubs 101-9-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-4321 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-9401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 206,250.00 10,840.81 136,009.21 65.94 70,245.79 76,250.00 7,022.36 61,816.80 81.07 14,433.20 0.00 0.00 9.50 0.00 ( 9.50) 153,000.00 8,296.82 98,378.52 69.30 59,621.48 13,250.00 981.14 9,059.15 68.33 4,195.85 10,100.00 523.15 6,421.85 63.58 3,678.15 30,000.00 0.00 30,000.00 100.00 0.00 3,500.00 198.70 2,205.05 63.00 1,294.95 9,900.00 737.02 6,431.31 64.96 3,468.69 16,700.00 0.00 13,683.00 81.93 3,017.00 0.00 0.00 49.09 0.00 ( 44.09) 312,700.00 17,759.19 228,044.22 72.93 84,655.78 1,200.00 42.30 704.44 58.70 995.56 9,000.00 1,142.75 5,333.94 59.27 3,666.06 3,100.00 86.98 1,926.05 46.00 1,673.95 30,700.00 1,382.19 13,373.53 43.56 17,326.47 44,000.00 2,654.22 20,837.96 97.36 23,162.04 5,050.00 0.00 1,837.50 36.39 3,212.50 3,000.00 229.33 1,875.15 62.51 1,124.85 500.00 0.00 210.61 92.12 289.39 10,000.00 384.26 5,883.07 58.83 4,116.93 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 ( 22.51) 7,604.07 50.19 7,545.93 4,450.00 328.25 1,844.76 41.46 2,605.29 27,100.00 1,973.61 16,039.99 59.19 11,060.01 10-13-2010 07:96 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTOAL BUDGET BALANCE 101-4-2310-4433 Dues & Subscriptions 2,000.00 229.00 1,678.00 83.90 322.00 101-4-2310-4460 Equip Replacement Charqe 22,300.00 1,858.33 16,724.97 75.00 5,575.03 TOTAL Other Services & Charges 108,850.00 4,475.27 61,823.62 56.80 47,026.38 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-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-9201 Office Supplies 101-9-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-9331 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 965,550.00 24,888.68 310,705.80 66.74 159,844.20 128,900.00 9,940.08 89,775.71 69.65 39,129.29 14,650.00 1,113.82 10,548.76 72.01 4,101.24 3,250.00 259.95 2,586.80 79.59 663.20 1,900.00 138.97 1,398.52 70.97 551.48 19,650.00 1,149.91 10,399.19 70.64 4,300.81 163,350.00 12,602.73 114,608.98 70.16 48,741.02 3,050.00 64.06 1,767.10 57.94 1,282.90 5,900.00 270.51 2,153.42 36.50 3,796.58 800.00 0.00 374.98 46.87 425.02 4,550.00 1,916.61 4,763.83 109.70 ( 213.83) 14,300.00 2,251.18 9,059.33 63.35 5,240.67 1,050.00 193.95 1,177.25 112.12 ( 127.25) 150.00 0.00 0.00 0.00 150.00 3,200.00 0.00 595.51 18.61 2,604.49 200.00 0.00 0.00 0.00 200.00 1,850.00 24.41 665.33 35.96 1,189.67 500.00 0.00 0.00 0.00 500.00 6,950.00 168.36 2,938.09 35.08 9,511.91 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-4104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services 184,600.00 15,022.27 126,106.40 68.31 58,493.60 8,300.00 668.09 5,863.74 70.65 2,436.26 1,400.00 94.18 867.25 61.95 532.75 150.00 9.54 87.81 58.54 62.19 1,100.00 44.90 404.10 36.74 695.90 10,950.00 816.66 7,222.90 65.96 3,727.10 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OE: SEPTEMBER 30TH, 2010 101-GENERAL FOND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 75.00$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-2330-4201 Office Supplies 400.00 0.00 51.52 12.88 348.98 101-4-2330-4219 Operating Supplies 8,500.00 229.91 2,453.54 28.87 6,046.96 TOTAL Supplies 8,900.00 229.41 2,505.06 28.15 6,394.94 Other Services & Charges 101-4-2330-9321 Telephone 1,500.00 26.02 775.30 51.69 724.70 101-4-2330-4322 Postage 100.00 0.00 61.90 61.90 38.10 101-4-2330-4331 Travel, Conferences & Schools 1,850.00 0.00 225.00 12.16 1,625.00 101-4-2330-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2330-4389 Utilities 1,500.00 0.00 800.30 53.35 699.70 101-4-2330-4409 Equip Repair/Maint Services 5,100.00 251.19 2,341.11 45.90 2,758.89 101-4-2330-4933 Dues & Subscriptions 400.00 0.00 100.00 25.00 300.00 TOTAL Other Services & Charges 10,950.00 277.21 4,303.61 39.30 6,646.39 TOTAL Emergency Management 3.0,800.00 1,323.28 14,031.57 45.56 16,768.43 Building Safety Personal Services 101-4-2410-4101 Regular Pay 318,350.00 24,568.15 220,022.18 69.11 98,327.82 101-4-2410-9103 Part-time Pay 25,050.00 2,291.72 18,915.95 73.52 6,639.05 101-4-2410-4104 PERA 24,050.00 1,880.20 17,492.11 72.73 6,557.89 101-9-2410-9105 FICA 21,300.00 1,528.89 19,294.10 67.11 7,005.90 101-4-2410-4107 Medicare 5,000.00 357.55 3,342.93 66.86 1,657.07 101-4-2410-4108 Insurance 38,250.00 3,191.04 28,719.36 75.08 9,530.64 101-4-2410-4109 Workers Comp 1,400.00 0.00 822.00 58.71 578.00 TOTAL Personal Services 433,400.00 33,817.50 303,108.63 69.94 130,291.37 Supplies 101-4-2410-4201 Office Supplies 2,500.00 11.77 1,057.99 42.32 1,442.01 101-4-2410-4212 Fuels & Lubs 4,000.00 339.83 2,398.27 59.96 1,601.73 101-4-2410-4217 Uniform Allowance 700.00 0.00 0.00 0.00 700.00 101-4-2410-4219 Operating Supplies 1,450.00 10.01 732.05 50.49 717.95 TOTAL Supplies 8,650.00 361.61 4,188.31 48.92 4,461.69 Other Services & Charges 101-4-2410-4321 Telephone 2,550.00 162.35 1,314.82 51.56 1,235.18 101-4-2410-4322 Postage 500.00 0.00 173.55 34.71 326.45 101-4-2910-4331 Travel, Conferences & Schools 6,750.00 0.00 1,135.00 16.81 5,615.00 101-4-2910-4361 Insurance 1,100.00 0.00 419.50 38.14 680.50 101-4-2410-4409 Equip Repair/Maint Services 8,800.00 240.88 4,433.42 50.38 4,366.58 101-4-2410-4433 Dues & Subscriptions 1,200.00 0.00 465.00 38.75 735.00 101-4-2410-4460 Equip Replacement Charge 2,600.00 216.67 1,950.03 75.00 649.97 TOTAL Other Services & Charges 23,500.00 619.90 9,891.32 42.09 13,608.68 I TOTAL Building Safety 465,550.00 34,799.01 317,188.26 68.13 148,361.74 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2940-4101 Regular Pay 35,400.00 2,755.44 24,589.58 69.46 10,810.42 101-4-2440-9104 PERA 2,500.00 192.88 1,841.95 73.68 658.05 101-4-2440-4105 FICA 2,200.00 133.54 1,268.39 57.65 931.61 101-4-2440-4107 Medicare 500.00 31.22 296.56 59.31 203.94 101-4-2490-4108 Insurance 5,650.00 444.65 4,396.33 77.81 1,253.67 101-4-2440-4109 Workers Comp 400.00 0.00 285.00 71.25 115.00 TOTAL Personal Services 96,650.00 3,557.73 32,677.81 70.05 13,972.19 Supplies 101-4-2490-4201 Office Supplies 650.00 7.30 332.26 51.12 317.74 101-4-2490-4212 Fuels & Lubs 150.00 7.89 71.11 47.91 75.89 TOTAL Suppli es 800.00 15.19 403.37 50.42 396.63 Other Services & Charges 101-9-2440-4321 Telephone 700.00 51.42 415.31 59.33 284.69 101-4-2440-4322 Postage 500.00 0.00 146.19 29.24 353.81 101-4-2490-4331 Travel, Conferences & Schools 500.00 563.44 1,299.36 258.87 ( 799.36) 101-4-2940-4359 Publishing 250.00 0.00 0.00 0.00 250.00 101-4-2440-9361 Insurance 250.00 0.00 93.50 37.40 156.50 101-4-2440-4409 Contractual Services 1,500.00 0.00 522.10 34.81 977.90 101-4-2440-4433 Dues & Subscriptions 1,050.00 0.00 0.00 0.00 1,050.00 TOTAL Other Services & Charges 4,750.00 614.86 2,971.46 52.03 2,278.54 TOTAL Environmental 52,200.00 4,187.78 35,552.64 68.11 16,647.36 TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-9-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4109 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 5,450,050.00 372,653.10 3,584,918.11 65.78 1,865,131.89 439,050.00 40,292.93 316,603.91 72.11 122,446.09 2,000.00 0.00 474.95 23.75 1,525.05 73,750.00 6,009.66 51,602.07 69.97 22,147.93 34,450.00 3,074.22 25,499.40 74.02 5,950.60 31,900.00 2,695.29 22,375.14 70.14 9,524.86 7,450.00 630.35 5,232.81 70.29 2,217.19 58,600.00 5,630.81 92,855.69 73.13 15,744.31 20,950.00 0.00 16,957.50 80.94 3,992.50 668,150.00 58,333.26 481,601.47 72.08 186,548.53 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Public Works ~ DEPARTMENTAL EXPENDITURES 75.00°s OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 101-9-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-4-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-4404 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-9-3120-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services 6,400.00 188.67 1,014.23 15.85 5,385.77 74,000.00 ( 7,750.51) 96,278.76 62.54 27,721.24 147,000.00 6,831.76 57,261.92 38.95 89,738.58 29,950.00 2,997.45 24,737.96 82.60 5,212.04 257,350.00 2,267.37 129,292.37 50.24 128,057.63 950.00 0.00 0.00 0.00 950.00 8,950.00 498.92 4,747.57 53.05 4,202.43 200.00 0.00 30.52 15.26 169.48 3,000.00 14.81 1,945.80 48.19 1,559.20 500.00 0.00 225.00 45.00 275.00 17,150.00 0.00 8,012.00 46.72 9,138.00 33,000.00 426.93 29,733.18 74.95 8,266.82 6,500.00 0.00 3,945.37 60.70 2,554.63 5,000.00 96.19 325.70 6.51 4,674.30 211,700.00 49,101.26 184,984.34 87.38 26,715.66 5,500.00 0.00 1,954.16 35.53 3,545.89 4,700.00 115.73 2,342.39 49.84 2,357.66 700.00 0.00 211.25 30.18 988.75 500.00 0.00 408.25 81.65 91.75 104,800.00 8,733.33 78,599.97 75.00 26,200.03 403,150.00 58,937.17 311,965.45 77.38 91,184.55 8,300.00 0.00 3,740.63 45.07 4,559.37 8,300.00 0.00 3,790.63 45.07 4,559.37 1,336,950.00 119,537.80 926,599.92 69.31 410,350.08 119,900.00 0.00 58,701.65 51.09 56,198.35 3,000.00 0.00 949.39 31.48 2,055.61 8,900.00 0.00 5,558.25 62.45 3,341.75 8,250.00 0.00 4,698.67 56.95 3,551.33 1,900.00 0.00 1,098.87 57.84 801.13 16,250.00 0.00 10,332.67 63.59 5,917.33 7,350.00 0.00 4,809.75 65.44 2,540.25 160,550.00 0.00 86,144.25 53.66 79,905.75 10-13-2010 07:46 AM 101-GENERAL FUND Public Works I DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 CURRENT CURRENT BUDGET PERIOD PAGE: 20 75.OOo OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies 86,000.00 0.00 78,198.63 90.93 7,801.37 TOTAL Supplies 86,000.00 0.00 78,198.63 90.93 7,801.37 TOTAL Snow Removal 296,550.00 0.00 169,342.88 66.66 82,207.12 Equipment Services Personal Services 101-4-3150-4101 Regular Pay 162,750.00 12,520.01 110,389.16 67.82 52,365.84 101-4-3150-4102 Overtime Pay 0.00 0.00 20.69 0.00 ( 20.69) 101-4-3150-4104 PERA 11,400.00 876.90 8,024.93 70.39 3,375.07 101-4-3150-4105 FICA 10,100.00 710.06 6,555.30 69.90 3,549.70 101-4-3150-4107 Medicare 2,350.00 166.06 1,533.07 65.24 816.93 101-4-3150-9108 Insurance 24,150.00 1,821.01 15,522.11 64.27 8,627.89 101-4-3150-4109 Workers Comp 6,050.00 0.00 9,783.50 79.07 1,266.50 TOTAL Personal Services 216,800.00 16,093.54 146,823.76 67.72 69,976.29 Supplies 101-4-3150-4219 Operating Supplies 14,500.00 1,279.14 12,884.38 88.86 1,615.62 101-4-3150-4221 Equipment Parts 11,700.00 0.00 345.21 2.95 11,359.79 TOTAL Supplies 26,200.00 1,279.14 13,229.59 50.99 12,970.41 Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 500.00 182.16 317.16 63.43 182.89 101-9-3150-4417 Uniform Rental 2,800.00 235.32 1,801.11 64.33 998.89 TOTAL Other Services & Charges 3,300.00 417.48 2,118.27 69.19 1,181.73 TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-9-3300-4104 PERA 101-9-3300-4105 FICA 101-9-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services 246,300.00 17,790.16 162,171.62 65.84 84,128.38 86,850.00 6,100.00 5,400.00 1,250.00 16,350.00 200.00 6,627.92 463.96 378.54 88.54 882.01 0.00 11,598.86 13.36 811.93 13.31 654.35 12.12 153.05 12.24 1,764.02 10.79 315.75 157.88 f 75,251.14 5,288.07 9,745.65 1,096.95 14,585.98 116,150.00 8,440.97 15,297.96 13.17 100,852.09 1 10-13-2010 07:46 AM I 101-GENERAL FUND Public Works ~ DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-3300-4201 Office Supplies 101-4-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3300-9303 Engineering Fees 101-4-3300-4319 Other Professional Services 101-4-3300-9321 Telephone 101-9-3300-4322 Postage 101-4-3300-4331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4904 Equip Repair/Maint Services 101-4-3300-4960 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Engineering 1,000.00 60.92 75.16 7.52 924.84 1,200.00 3.94 3.94 0.33 1,196.06 8,800.00 0.00 1,811.00 20.58 6,989.00 11,000.00 64.86 1,890.10 17.18 9,109.90 20,000.00 3,420.00 14,779.31 73.90 5,220.69 22,500.00 0.00 0.00 0.00 22,500.00 1,150.00 0.00 2.52 0.22 1,197.48 200.00 0.00 130.89 65.42 69.16 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 562.50 75.00 187.50 51,200.00 3,482.50 15,568.67 30.41 35,631.33 178,350.00 11,988.33 32,756.73 18.37 145,593.27 I TOTAL Public Works Parks Department Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-4103 Part-time Pay 101-4-5110-4104 PERA 101-4-5110-9105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp 101-4-5110-9110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-9-5110-9219 Operating Supplies TOTAL Supplies 2,008,150.00 149,316.29 1,285,871.15 64.03 722,278.85 392,150.00 29,522.17 247,393.16 72.31 94,756.89 0.00 0.00 7.13 0.00 ( 7.13) 39,650.00 4,979.99 33,506.29 84.51 6,143.71 24,650.00 2,273.56 19,440.25 78.87 5,209.75 23,750.00 1,980.63 16,640.4.0 70.06 7,109.60 5,550.00 963.19 3,891.51 70.12 1,658.49 43,550.00 9,141.93 35,200.05 80.83 8,399.95 8,200.00 0.00 6,087.00 74.23 2,113.00 0.00 0.00 3,264.00 0.00 ( 3,264.00) 487,500.00 43,361.47 365,929.79 74.96 122,070.21 39,550.00 4,953.68 20,023.98 57.96 14,526.52 3,150.00 0.00 1,471.78 46.72 1,678.22 73,800.00 9,606.07 58,639.02 79.96 15,160.98 111,500.00 14,559.75 80,139.28 71.87 31,365.72 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Culture & Recreation 1 DEPARTMENTAL EXPENDITURES 75.00 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 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-9-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 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-9104 PERA 101-4-5210-9105 FICA 101-4-5210-4107 Medicare 101-4-5210-4108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services I 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-9401 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 3,900.00 375.63 3,257.93 83.54 642.07 100.00 0.00 10.41 10.41 89.59 3,350.00 270.00 1,092.39 31.12 2,307.61 25,850.00 0.00 12,320.50 97.66 13,529.50 27,200.00 3,479.01 15,826.96 58.19 11,373.04 9,000.00 0.00 1,360.00 34.00 2,640.00 11,700.00 1,442.80 11,828.89 101.10 ( 128.89) 7,100.00 3,557.82 8,984.95 126.55 ( 1,889.95) 24,500.00 265.69 8,290.92 33.84 16,209.08 60,450.00 5,037.50 45,337.50 75.00 15,112.50 168,150.00 14,428.45 108,260.45 64.38 59,889.55 767,150.00 72,349.67 553,824.52 72.19 213,325.48 338,400.00 15,967.58 211,340.45 62.45 127,059.55 0.00 0.00 28.50 0.00 ( 28.50) 20,850.00 2,791.75 18,248.39 87.52 2,601.66 25,150.00 1,258.09 15,834.47 62.96 9,315.53 22,300.00 1,063.76 14,182.92 63.60 8,117.08 5,200.00 248.76 3,316.90 63.79 1,883.10 38,350.00 3,677.41 27,279.59 71.13 11,070.91 3,400.00 0.00 2,534.25 74.54 865.75 453,650.00 25,007.35 292,765.42 69.54 160,884.58 13,700.00 329.61 7,509.04 54.81 6,190.96 13,700.00 329.61 7,509.04 54.81 6,190.96 4,800.00 186.65 1,995.59 41.57 2,804.41 6,000.00 199.63 3,486.17 58.10 2,513.83 6,950.00 22.00 2,267.37 32.62 4,682.63 26,400.00 3,028.96 15,406.96 58.36 10,993.04 1,550.00 0.00 668.50 43.13 881.50 7,800.00 98.71 6,004.70 76.98 1,795.30 12,850.00 1,139.39 11,197.35 87.14 1,652.65 7,950.00 930.07 6,423.12 80.79 1,526.88 1,650.00 0.00 1,352.00 81.94 298.00 75,950.00 5,055.41 48,801.76 64.26 27,148.24 543,300.00 30,392.37 399,076.22 64.25 199,223.78 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 I 101-GENERAL FUND Culture & Recreation I DEPARTMENTAL EXPENDITURES 75.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I Recreation Programs Personal Services 101-4-5220-4102 Overtime Pay 101-4-5220-4103 Part-time Pay 101-4-5220-4109 PERA 101-4-5220-9105 FICA 101-9-5220-4107 Medicare 101-4-5220-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-5220-4404 Equip Repair/Maint Services 101-4-5220-4409 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 0.00 0.00 69.13 0.00 ( 69.13) 80,000.00 4,824.26 60,936.56 76.17 19,063.44 2,200.00 181.14 1,787.76 81.26 412.24 4,250.00 299.12 3,860.07 90.83 389.93 1,150.00 69.96 902.89 78.51 297.11 0.00 0.00 84.97 0.00 ( 84.97) 87,600.00 5,374.48 67,636.38 77.21 19,963.62 25,550.00 3,208.19 27,190.92 106.42 ( 1,640.42) 25,550.00 3,208.19 27,190.42 106.42 ( 1,640.42) 400.00 0.00 0.00 0.00 400.00 54,200.00 5,876.70 50,892.80 93.90 3,307.20 2,500.00 0.00 1,360.00 54.40 1,140.00 3,300.00 392.63 3,570.01 108.18 ( 270.01) 60,400.00 6,269.33 55,822.81 92.42 4,577.19 TOTAL Recreation Programs 173,550.00 Concessions Personal Services 14,852.00 150,649.61 86.80 22,900.39 5,125.72 190.43 ( 1,475.72) 110.93 73.62 39.57 339.87 135.95 ( 89.87) 79.98 158.96 ( 29.48) 5,655.50 137.94 ( 1,555.50) 101-4-5230-4103 Part-time Pay 3,650.00 708.25 101-4-5230-4104 PERA 150.00 0.00 101-4-5230-4105 FICA 250.00 43.92 101-4-5230-4107 Medicare 50.00 10.27 TOTAL Personal Services 4,100.00 762.94 Supplies 101-4-5230-4219 Operating Supplies 1,450.00 101-4-5230-9259 Other Merchandise For Resale 8,200.00 TOTAL Supplies 9,650.00 Other Services & Charges 0.00 100.00 6.90 1,350.00 991.90 4,331.69 52.83 3,868.31 491.90 4,431.69 45.92 5,218.31 I 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 100.00 TOTAL Concessions 13,850.00 1,254.34 10,087.19 72.83 3,762.81 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 56,300.00 4,414.42 39,013.22 69.30 17,286.78 101-4-5510-9103 Part-time Pay 59,200.00 4,676.65 36,000.19 60.81 23,199.81 101-4-5510-4104 PERA 8,100.00 636.36 5,519.96 68.14 2,580.59 101-4-5510-4105 FICA 7,200.00 526.27 9,562.00 63.36 2,638.00 101-4-5510-4107 Medicare 1,700.00 123.07 1,066.99 62.76 633.01 101-4-5510-4108 Insurance 13,000.00 1,155.48 9,796.28 75.36 3,203.72 101-4-5510-4109 Workers Comp 400.00 0.00 326.25 81.56 73.75 TOTAL Personal Services 145,900.00 11,532.25 96,284.39 65.99 49,615.61 Supplies 101-4-5510-4219 Operating Supplies 16,100.00 2,783.23 11,102.16 68.96 9,997.84 TOTAL Supplies 16,100.00 2,783.23 11,102.16 68.96 9,997.84 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 211.88 1,914.83 79.78 485.17 101-4-5510-4322 Postage 2,100.00 14.47 1,910.26 90.96 189.74 101-4-5510-4331 Travel, Conferences & Schools 2,400.00 50.00 566.50 23.60 1,833.50 101-4-5510-4361 Insurance 1,650.00 0.00 746.50 45.24 903.50 101-4-5510-4389 Utilities 11,800.00 155.29 4,971.56 42.13 6,828.44 101-4-5510-4401 Bldg Repair/Maint Services 11,500.00 891.23 8,846.97 76.93 2,653.03 101-4-5510-4409 Contractual Services 8,200.00 211.00 925.00 11.28 7,275.00 101-4-5510-9433 Dues & Subscriptions 1,200.00 85.69 679.80 56.23 525.20 TOTAL Other Services & Charges 41,250.00 1,619.56 20,556.42 49.83 20,693.58 TOTAL Sr Citizen Programs 203,250.00 15,935.04 127,942.97 62.95 75,307.03 TOTAL Culture & Recreation 1,701,100.00 139,783.42 1,191,580.51 70.05 509,519.99 Economic Development Personal Services 101-4-6210-4101 Regular Pay 0.00 10,237.40 91,152.24 0.00 ( 41,152.24) 101-4-6210-9103 Part-time Pay 0.00 1,050.32 4,201.28 0.00 ( 4,201.28) 101-4-6210-9104 PERA 0.00 738.72 2,969.06 0.00 ( 2,969.06) 101-4-6210-4105 FICA 0.00 646.11 2,596.60 0.00 ( 2,596.60) 101-4-6210-4107 Medicare 0.00 153.28 615.96 0.00 ( 615.96) 101-4-6210-4108 Insurance 0.00 918.01 3,711.85 0.00 ( 3,711.85) 101-4-6210-4109 Workers Comp 0.00 0.00 165.75 0.00 ( 165.75) TOTAL Personal Services 0.00 13,743.84 55,412.74 0.00 ( 55,412.74) 10-13-2010 07:46 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 101-GENERAL FUND Economic Development CURRENT DEPARTMENTAL EXPENDITURES BUDGET Other Services & Charges CURRENT PERIOD 101-4-6210-4349 Advertising/Marketing 0.00 ( 20.77) 101-4-6210-4940 Miscellaneous 0.00 ( 44.63) TOTAL Other Services & Charges 0.00 ( 65.40) TOTAL Economic Development 0.00 13,678.94 Energy City Personal Services 101-4-6220-9101 Regular Pay 24,550.00 101-4-6220-4104 PERA 1,700.00 101-4-6220-4105 FICA 1,500.00 101-4-6220-4107 Medicare 350.00 101-4-6220-9108 Insurance 3,250.00 TOTAL Persona l Services 31,350.00 Other Services & Charges 101-4-6220-9319 Other Professional Services 5,000.00 101-9-6220-9331 Travel, Conferences & Schools 2,500.00 101-4-6220-4359 Publishing 12,500.00 TOTAL Other Services & Charges 20,000.00 PAGE: 25 75.00$ OF YEAR COMP. YEAR TO DATE °s OE BUDGET ACTUAL BUDGET BALANCE 0.00 0.00 0.00 16.87 0.00 ( 16.87) 16.87 0.00 ( 16.87) 55,429.61 0.00 ( 55,429.61) 1,899.12 17,050.69 69.45 7,499.31 132.99 1,255.59 73.86 494.41 96.34 893.17 59.54 606.83 22.54 208.93 59.69 141.07 222.10 2,250.05 69.23 999.95 2,373.09 21,658.43 69.09 9,691.57 15.33 242.65 4.85 4,757.35 5,672.71 9,247.47 169.90 ( 1,797.47) 51.45 4,348.19 34.79 8,151.81 5,739.49 8,838.31 44.19 11,161.69 TOTAL Energy City 51,350.00 8,112.53 30,496.74 59.39 20,853.26 TOTAL Economic Development 51,350.00 21,790.97 85,926.35 167.33 ( 34,576.35) 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-9724 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 169,050.00 0.00 0.00 0.00 164,050.00 TOTAL EXPENDITURES 12,044,800.00 863,205.74 7,813,823.98 69.87 4,230,976.02 REVENUES OVER/(UNDER) EXPENDITURES ( 325,000.00)( 700,110.65)( 1,350,021.97) 1,025,021.97 1 10-13-2010 07:46 AM 221-ICE ARENA FINANCIAL SUMMARY CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 75.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I 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 656,050.00 10,987.13 297,735.26 45.38 358,314.79 60,000.00 300.00 34,361.25 57.27 25,638.75 75,650.00 7,638.50 51,357.34 67.89 24,292.66 67,750.00 2,140.25 39,928.49 58.93 27,821.56 859,950.00 20,565.88 423,382.29 49.26 436,067.71 744,900.00 32,055.20 360,279.98 48.37 389,625.52 28,200.00 7,286.88 17,212.73. 61.04 10,987.27 35,500.00 926.86 15,780.68 44.45 19,719.32 50,850.00 540.63 24,398.82 47.98 26,451.18 859,450.00 40,309.57 917,666.71 48.60 441,783.29 859,450.00 40,309.57 917,666.71 48.60 441,783.29 0.00 ( 19,743.69) 5,715.58 ( 5,715.58) 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 221-ICE ARENA I REVENUES CURRENT CURRENT BUDGET PERIOD 75.00 OF YEAR COMP. YEAR TO DATE a OF BUDGET ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charges for Services Other 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-3922 Transfer-General Fund TOTAL Transfers In I 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-5920-3461 Recreation Fees 221-3-5920-3465 Admissions TOTAL Charges for Services 449,800.00 8,560.27 249,747.88 55.52 200,052.12 22,550.00 0.00 15,041.18 66.70 7,508.82 12,000.00 935.64 15,657.47 130.48 ( 3,657.47) 4,800.00 196.00 2,878.00 59.96 1,922.00 2,600.00 0.00 0.00 0.00 2,600.00 17,000.00 0.00 83.50 0.49 16,916.50 508,750.00 9,691.91 283,408.03 55.71 225,341.97 18,700.00 707.67 8,539.49 95.67 10,160.56 0.00 0.00 4,619.00 0.00 ( 4,619.00) 2,000.00 87.55 1,168.79 58.44 831.21 20,700.00 795.22 14,327.23 69.21 6,372.77 126,600.00 0.00 0.00 0.00 126,600.00 126,600.00 0.00 0.00 0.00 126,600.00 656,050.00 10,487.13 297,735.26 95.38 358,314.74 60,000.00 300.00 39,361.25 57.27 25,638.75 60,000.00 300.00 34,361.25 57.27 25,638.75 60,000.00 300.00 34,361.25 57.27 25,638.75 70,000.00 7,638.50 46,664.00 66.66 23,336.00 3,500.00 0.00 3,831.34 109.47 ( 331.34) 73,500.00 7,638.50 50,995.34 68.70 23,004.66 10-13-2010 07:96 AM 221-ICE ARENA ' REVENUES CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 75.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue 2,150.00 0.00 862.00 90.09 1,288.00 TOTAL Other Revenue 2,150.00 0.00 862.00 40.09 1,288.00 TOTAL Skating 75,650.00 7,638.50 51,357.39 67.89 24,292.66 Concessions Charges for Services 221-3-5430-3467 Concessions 67,750.00 2,190.25 39,928.94 58.93 27,821.56 TOTAL Charges for Services 67,750.00 2,140.25 39,928.44 58.93 27,821.56 TOTAL Concessions 67,750.00 2,140.25 39,928.49 58.93 27,821.56 I TOTAL REVENUE ---859=950.00 ----20=565.88 ---423=382-29 --49-26 ---436=067-71 10-13-2010 07:46 AM 221-ICE ARENA I DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 75.00$ OE YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OE BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1 Ice Arena Personal Services 221-9-5400-9101 Regular Pay 221-9-5400-4102 Overtime Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-5400-4107 Medicare 221-4-5400-4108 Insurance 221-4-5400-4109 Workers Comp 221-4-5400-4110 Re-employment Compensation TOTAL Personal Services Supplies 221-4-5900-4212 Euels & Lubs 221-4-5400-4217 Uniform Allowance 221-9-5400-9219 Operating Supplies 221-9-5400-4255 Soft Drinks/Misc 221-4-5400-9259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5900-4331 Travel, Conferences & Schools 221-4-5400-9359 Publishing 221-4-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4909 Contractual Services 221-4-5900-4415 Equipment Rental 221-4-5400-9433 Dues & Subscriptions TOTAL Other Services & Charges Transfers Out 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out 148,700.00 9,593.72 97,235.81 65.39 51,464.19 0.00 0.00 100.32 0.00 ( 100.32) 73,900.00 4,131.55 46,722.88 63.22 27,177.12 11,750.00 878.79 9,242.96 78.66 2,507.04 13,800.00 839.62 9,390.96 68.05 4,409.04 3,250.00 196.35 2,196.24 67.58 1,053.76 17,450.00 1,125.00 11,563.12 66.26 5,886.88 4,750.00 0.00 3,747.00 78.88 1,003.00 0.00 0.00 931.23 0.00 ( 931.23) 273,600.00 16,765.03 181,130.52 66.20 92,469.98 350.00 0.00 31.77 9.08 318.23 1,000.00 0.00 256.30 25.63 743.70 91,450.00 3,166.82 22,115.46 53.35 19,334.54 9,000.00 0.00 3,542.89 39.36 5,457.16 900.00 57.57 236.95 26.33 663.05 52,700.00 3,229.39 26,183.32 49.68 26,516.68 3,300.00 281.27 2,365.35 71.68 934.65 600.00 0.00 94.97 15.83 505.03 1,050.00 0.00 129.90 12.37 920.10 2,800.00 446.54 2,071.36 73.98 728.69 8,700.00 0.00 3,867.00 44.95 4,833.00 175,900.00 9,501.78 104,823.31 59.59 71,076.69 20,200.00 587.80 16,140.83 79.91 4,059.17 1,100.00 1,229.30 1,510.63 137.33 ( 410.63) 4,600.00 19.09 1,819.79 39.56 2,780.21 450.00 0.00 187.50 91.67 262.50 218,700.00 12,065.78 133,010.69 60.82 85,689.36 199,900.00 0.00 19,950.00 9.98 179,950.00 199,900.00 0.00 19,950.00 9.98 179,950.00 TOTAL Ice Arena 794,900.00 32,055.20 360,274.48 48.37 384,625.52 10-13-2010 07:46 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 PAGE: 5 75.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 3,600.00 500.00 569.04 15.81 3,030.96 221-4-5410-4105 FICA 250.00 31.00 35.28 14.11 214.72 221-4-5410-4107 Medicare 50.00 7.25 8.25 16.50 41.75 TOTAL Personal Services 3,900.00 538.25 612.57 15.71 3,287.93 Supplies 221-4-5910-9219 Operating Supplies 15,250.00 6,400.71 10,529.91 69.01 9,725.59 TOTAL Supplies 15,250.00 6,400.71 10,524.41 69.01 4,725.59 Other Services & Charges 221-4-5410-9322 Postage 50.00 0.00 0.00 0.00 50.00 221-4-5410-9359 Publishing 500.00 0.00 0.00 0.00 500.00 221-4-5410-4409 Contractual Services 6,300.00 79.20 3,991.00 63.35 2,309.00 221-4-5410-4438 Credit Card Fees 2,200.00 268.72 2,084.75 94.76 115.25 TOTAL Other Services & Charges 9,050.00 347.92 6,075.75 67.14 2,974.25 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-9-5420-4105 FICA 221-9-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4359 Publishing 221-4-5920-4409 Contractual Services 221-4-5420-9438 Credit Card Fees TOTAL Other Services & Charges TOTAL Skatinq 28,200.00 7,286.88 17,212.73 61.09 10,987.27 20,000.00 64.00 8,930.20 49.65 11,069.80 1,000.00 0.00 363.65 36.37 636.35 1,250.00 3.96 566.50 45.32 683.50 300.00 0.92 132.44 44.15 167.56 22,550.00 68.88 9,992.79 44.31 12,557.21 6,900.00 0.00 3,188.75 46.21 3,711.25 6,900.00 0.00 3,188.75 46.21 3,711.25 500.00 0.00 426.93 85.29 73.57 2,550.00 39.20 772.00 30.27 1,778.00 3,000.00 318.78 1,400.71 96.69 1,599.29 6,050.00 357.98 2,599.14 42.96 3,450.86 35,500.00 426.86 15,780.68 44.45 19,719.32 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 221-ICE ARENA Culture & Recreation 75.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 174.25 8,032.87 38.43 12,867.13 221-4-5430-4104 PERA 200.00 4.08 206.35 103.18 ( 6.35) 221-4-5930-9105 FICA 1,300.00 10.80 540.86 41.60 759.19 221-4-5930-4107 Medicare 300.00 2.52 126.51 42.17 173.49 TOTAL Personal Services 22,700.00 191.65 8,906.59 39.24 13,793.91 Supplies 221-4-5430-4219 Operating Supplies 7,150.00 0.00 64.65 0.90 7,085.35 221-4-5430-4259 Other Merchandise For Resale 21,000.00 348.98 15,427.58 73.46 5,572.42 TOTAL Supplies 28,150.00 348.98 15,992.23 55.03 12,657.77 I TOTAL Arena Concessions 50,850.00 540.63 24,398.82 47.98 26,451.18 I TOTAL Culture & Recreation 859,450.00 40,309.57 917,666.71 48.60 941,783.29 TOTAL EXPENDITURES 859,950.00 40,309.57 417,666.71 48.60 441,783.29 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 19,743.69) 5,715.58 ( 5,715.58) 10-13-2010 07:96 AM 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY REVENUE SUMMARY Pinewood Golf Course TOTAL REVENUES I EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 CURRENT CURRENT BUDGET PERIOD PAGE: 1 75.00$ OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 238,450.00 14,110.91 172,175.79 72.21 66,274.21 238,450.00 14,110.91 172,175.79 72.21 66,274.21 ------------- ------------- ------------- ------ ------------- 238,950.00 25,896.10 181,480.69 76.11 56,969.31 238,450.00 25,896.10 181,480.69 76.11 56,969.31 238,950.00 25,896.10 181,480.69 76.11 56,969.31 0.00 ( 11,785.19)( 9,304.90) 9,309.90 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 222-PINEWOOD GOLF COURSE 1 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-3975 Building Rent 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments 222-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 222-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 222-3-0000-3792 Cash Over TOTAL Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In I TOTAL Pinewood Golf Course 75.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 22,000.00 0.00 16,396.06 74.30 5,653.94 19,000.00 1,240.42 14,992.74 78.65 4,057.26 5,000.00 413.38 4,410.96 88.22 589.04 0.00 370.00 557.03 0.00 ( 557.03) 115,000.00 9,795.73 100,114.27 87.06 14,885.73 19,000.00 0.00 13,410.00 95.79 590.00 18,500.00 1,665.50 17,067.50 92.26 1,932.50 7,000.00 654.94 5,319.73 76.00 1,680.27 500.00 0.00 0.00 0.00 500.00 201,000.00 14,139.97 172,168.29 85.66 28,831.71 0.00 0.00 4.50 0.00 ( 4.50) 0.00 0.00 4.50 0.00 ( 9.50) 0.00 ( 29.06) 3.00 0.00 ( 3.00) 0.00 ( 29.06) 3.00 0.00 ( 3.00) 37,450.00 0.00 0.00 0.00 37,450.00 37,950.00 0.00 0.00 0.00 37,450.00 238,450.00 14,110.91 172,175.79 72.21 66,274.21 I TOTAL REVENUE 238,950.00 14,110.91 172,175.79 72.21 66,274.21 I 10-13-2010 07:46 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 ~ 222-PINEWOOD GOLF COURSE 1 DEPARTMENTAL EXPENDITURES Golf Course Personal Services 222-9-5300-4101 Regular Pay 222-9-5300-4102 Overtime Pay 222-9-5300-4103 Part-time Pay 222-9-5300-4104 PERA 222-4-5300-4105 FICA 222-4-5300-4107 Medicare 222-4-5300-4108 Insurance 222-4-5300-4109 Workers Comp 222-4-5300-4110 Re-employment Compensation TOTAL Personal Services Supplies 222-4-5300-4212 Fuels & Lubs 222-4-5300-4217 Uniform Allowance 222-4-5300-4219 Operating Supplies 222-4-5300-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 222-4-5300-9321 Telephone 222-4-5300-9331 Travel, Conferences & Schools 222-9-5300-9349 Advertising/Marketing 222-9-5300-4361 Insurance 222-4-5300-4389 Utilities 222-4-5300-4401 Bldq Repair/Maint Services 222-4-5300-4404 Equip Repair/Maint Services 222-4-5300-4415 Equipment Rental 222-4-5300-9437 Taxes & Licenses 222-4-5300-9438 Credit Card Fees TOTAL Other Services & Charges Debt Service 222-4-5300-4601 Principal TOTAL Debt Service 75.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 91,550.00 7,972.16 62,194.63 67.94 29,355.37 0.00 0.00 19.13 0.00 ( 19.13) 28,900.00 4,107.41 30,447.94 105.35 ( 1,547.44) 8,450.00 762.79 5,865.56 69.41 2,589.44 7,450.00 733.46 5,769.67 77.38 1,685.33 1,750.00 171.56 1,348.24 77.04 401.76 11,050.00 898.02 6,735.15 60.95 9,319.85 1,250.00 0.00 933.75 74.70 316.25 0.00 0.00 4,159.00 0.00 ( 9,159.00) 150,400.00 19,645.40 117,462.57 78.10 32,937.43 5,000.00 1,159.62 3,685.20 73.70 1,319.80 500.00 0.00 219.10 42.52 285.90 25,600.00 3,358.97 19,880.62 77.66 5,719.38 14,000.00 1,222.18 11,771.00 89.08 2,229.00 45,100.00 5,740.77 35,550.92 78.83 9,549.08 3,100.00 217.05 1,555.96 50.19 1,594.04 500.00 7.73 135.69 27.14 364.31 1,000.00 107.30 755.60 75.56 294.40 11,850.00 0.00 5,162.00 93.56 6,688.00 7,150.00 1,180.16 3,813.32 53.33 3,336.68 1,000.00 420.04 880.32 88.03 119.68 2,500.00 147.91 2,054.44 82.18 445.56 2,000.00 506.29 1,261.45 63.07 738.55 850.00 988.31 392.35 46.16 457.65 4,500.00 519.14 3,960.07 88.00 539.93 34,450.00 4,093.93 19,971.20 57.97 14,478.80 8,500.00 1,416.00 8,996.00 99.95 8,500.00 1,416.00 8,496.00 99.95 4.00 TOTAL Golf Course 238,950.00 25,896.10 181,480.69 76.11 56,969.31 TOTAL Culture & Recreation 238,450.00 25,896.10 181,480.69 76.11 56,969.31 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 238,450.00 25,896.10 181,980.69 76.11 56,969.31 0.00 ( 11,785.19)( 9,304.90) 9,304.90 4.00 10-13-2010 07:52 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: SEPTEMBER 30TH, 2010 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 35,807.29 ( 1,395.10) 34,462.19 101-1010 Cash - General Fund 5,097,995.34 ( 732,530.69) 4,314,964.65 211-1010 Cash - Library 406,897.94 ( 8,755.38) 398,192.06 221-1010 Cash - Ice Arena 64,876.27 ( 21,690.22) 43,236.05 222-1010 Cash - Pinewood Golf Course 5,020.88 ( 10,830.89) ( 5,810.01) 223-1010 Cash - Sr Citizen Account 12,954.60 ( 1,034.09) 11,920.51 225-1010 Cash - Park Dedication 122,974.44 ( 110,013.25) 12,961.19 228-1010 Cash - Landfill 1,029,022.22 ( 18,232.18) 1,005,790.04 231-1010 Cash - Landfill Const Debris 680,462.20 0.00 680,462.20 240-1010 Cash - Micro Loan Fund 899,736.13 ( 71,363.95) 823,372.18 241-1010 Cash - DTED Loan 246,825.06 4,828.04 251,653.10 245-1010 Cash - Development Fund 222,452.55 5,000.00 227,452.55 290-1010 Cash - Capital Outlay Reserve 1,211,490.69 14,913.70 1,226,409.39 291-1010 Cash - Insurance Reserve 969,235.41 ( 5,747.13) 463,488.28 292-1010 Cash - Govt Bldgs Reserve 2,981,099.07 92,130.08 3,073,229.15 294-1010 Cash - Drug Forfeiture 1,290.29 22,900.00 24,190.29 295-1010 Cash - Severance Pay Reserve 141,611.11 0.00 141,611.11 296-1010 Cash - NSP/RDF Reserve 1,122,854.25 0.00 1,122,859.25 308-1010 Cash - 1999A GO Bonds 40,000.00 0.00 40,000.00 311-1010 Cash - 2003A GO Bonds 111,280.61 0.00 111,280.61 312-1010 Cash - 2005A GO Bonds 165,840.75 1,719.30 167,555.05 313-1010 Cash - 2007C GO Bonds 327,724.47 0.00 327,724.47 333-1010 Cash - 2002A Pub Safety Bonds 418,313.74 0.00 918,313.79 340-1010 Cash - Equipment Certificates 49,507.29 0.00 49,507.29 344-1010 Cash - 2006C Cap Imp Bonds Lby ( 57,333.75) 0.00 ( 57,333.75) 350-1010 Cash - State-Aid Road Bonds 921.33 0.00 421.33 401-1010 Cash - Capital Projects 2,523,698.76 0.00 2,523,698.76 903-1010 Cash - Street Improvement Resr 2,559,098.15 ( 176,583.58) 2,377,514.57 404-1010 Cash - Surface Water Managemnt 319,023.10 ( 42,608.93) 276,419.17 405-1010 Cash - NE Area Trunk Utilities 273,035.22 0.00 273,035.22 406-1010 Cash - City Wide Trunk Util 3,668,117.88 0.00 3,668,117.88 410-1010 Cash - Equipment Replacement 761,558.17 90,280.47 851,838.69 426-1010 Cash - YMCA 1,332,178.62 0.00 1,332,178.62 427-1010 Cash - 193rd Avenue ( 34,560.33) ( 2,019.97) ( 36,580.30) 440-1010 Cash - Park Improvement 93,227.88 ( 8,681.65) 84,546.23 956-1010 Cash - TIF #16 King/Main 22,520.48 0.00 22,520.48 459-1010 Cash - TIF #19 Highway 169 536,177.08 ( 427.50) 535,749.58 462-1010 Cash - TIF #22 Downtown Redev 0.00 ( 522.50) ( 522.50) 602-1010 Cash - Wastewater Treatment 4,161,938.10 242,919.70 4,404,357.80 603-1010 Cash - Liquor 3,764,266.87 ( 8,971.25) 3,755,295.62 605-1010 Cash - Garbage 419,588.35 95.65 419,684.00 801-1010 Cash - Interest 0.00 22,648.58 22,648.58 821-1010 Cash - Developer Escrow 38,747.24 52,526.00 91,273.29 TOTAL CLAIM ON CASH 36,181,475.25 ( 671,851.74) 35,509,623.51