Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 11-16-2009
INFORMATION City of EI. ~'°`.. ever MEMORANDUM T y~r n icy ~unc~~ F Tim Srm®n, Fence i~c®~ T ; everner l , 2009 SU JcT: c~®e~ 20x9 ®nly Finnc~~ a®r~ This report is designed to provide summa~.y information regarding the overall level of revenues and expenditures In the General Fund and the Ice Arena and Pinewood Golf special revenue funds. These funds are the primary concern in analyzing the City's financial health, For the month of Gctober•, actual revenues except for property taxes and state aids} and expenditures should run about S3% 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 Ser-vices, This is not considered serious as long as the total expencliture budget amount is not overspent, Significant variances from budget are highlighted below accompanied with a general discussion for the variance. Gerlera~ Fund Re~~enues: ~ Excluding transfers in, total revenue collections are about 52% of budget. The second half property taxes will be collected in December. Intergovernmental revenues of MV credit and police aid were collected in October, The second half LGA and MV credit payments will be collected in December. ® Licenses/permits and charges for services are slightly below the S3% budget benchmarl~ due mainly to budding-related permits and services. ® Interest income is lower than budget due to reversal of the prior year's interest receivable and marl~et conditions, ~ All revenue transfers in have been recorded, .~x~enditi~res: ~ Excluding transfers out, the total departmental expenditures are at about 75% and most departments are within or below budget estimates, ~ Payment of the semi-annual insurance premium through December was paid in actober and reflected in many departments budgets. ® Expenditures for rec~:eation programs axe exceeding its annual budget due to the reco~:ding of sponso:~sl~ips for special event programs. ~ The transfers out to the Ice Arena and Pinewood Golf Course are made at the end of the year based on actual results. ice arena Fo.r the month. ended October, expenditures exceed revenues by $44,018, Excluding transfers, revenue collections of X430,371 are about 57% of budget estimates and ex endinires of X457,725 are about f0% of budget estimates for 200. October indicates an p increase i~1 ice rental revenues due to the stmt of the upcoming hockey season, Pinewood golf For the t~nonth ended actober, expenditures exceed revenues by $40,538. Excluding transfers, golf revenues of $200,071 exceed budget estimates by about 4% and expenditures of ~24Q,008 are about 94% of budget. October's cool and rainy weather negatively impacted the collection of golf revenues for the month, 11-122009 :08:15 AM FUND ACCDUNT# ACCOUNT NAME BEGINNTNG CURRENT BALANCE ACTIVITY PAGE: 1 CURRENT BALANCE D42-1D1D Cash - Section 125 101-1010 Cash - General fund 211~1D10 Cash - Library 221-1010 Cash ~ Tce Arena 222-1010 Cash .. Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1014 Cash - Park Dedication 228-1010 Cash - Landfill 231-101D Cash - Landfill Const Debris 240-101D Cash .. Micro Loan Fund 291-101D Cash - DTED Loan 245 1410 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash .. Insurance Reserve 292-1010 Cash - Gavt Sldgs Reserve 294-1D1D Cash - Drug Forfeiture 295-1410 Cash - Severance Pay Reserve 296-1010 Cash ~ NSP/RDF Reserve 3D8-1010 Cash ~ 1999A GO Bonds 311-141D Cash ~ 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 20470 GO Bonds 331-101D Cash - 19940 Storm Sewer Bonds 333-101D Cash - 2D02A Fub Safef.y Bonds 340-1010 Cash - Equipment Certificates 4011010 Cash ~ Capa.tal Projects 403-1010 Cash _ Street Improvement Resr 404 1010 Cash - Surface Water Managemnt 405-1010 Cash - NE Area Trunk Utilities 406-1410 Cash - City Wide Trunk Util 410-1D10 Cash . . Equ~.pment Replacement 426-1010 Cash _ YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash ~ Park Improvement 459-1010 Cash ~ TTY` #19 Highway 169 462-1010 Cash ~ TIF #22 Downtown Redev b02-1010 Cash - Wastewater Treatment 603-101D Cash - Liquor 605-101D Cash - Garbage 807.-101D Cash - Interest 821 1010 Cash - Developer Escrow TOTAL CLAIM ON CASH CITY OF ELK RTVER POOLED CASH REPQRT (FUND 999} AS OF: OCTOBER 31ST, 2009 36,569.83 { 6,3D9,7D} 3D,260,13 3,755,917,22 { 799,969,33} 2,965,947,89 389,433,07 { 3,928,73) 385,504,34 14,299,93 { 39,489,58} { 25,189,65} ( 14,341,78} ( 23,655.25) { 37x997,D3} 9,137,58 199.74 9,337.32 ( 167,897,41) 0.00 ( 167,897,41} 1,239,26D,23 { 20x083,97} 1,219,176.26 570,348,24 0,00 670,308.24 799,526,31 4,138,83 803,665,14 190,508,24 4,828,04 195,336,28 109,745,66 3,861,00 113,506.66 1,375,482,28 = 31,698,40} 1,343,783.88 530,514.4$ ( $2,676,30} 447,838.18 2x082,504.87 118,731.82 2,201,236.69 2,877.82 1,459,90 4,337,72 139,498.00 0,00 139,498,00 536,291,46 0,00 636,291,46 35,000.00 0,00 35,400,D0 155,780.21 ( 431,25} 156,348.96 156,493,79 1,533,DD 168,026.79 338,822,31 13x685,D0 352,507,31 130,404,32 2,018,00 132,422.32 339,722,15 10x458.OD 350,180,15 171,151.25 5,112,00 177,273,26 2,215,163,35 160,00 2,215,323,35 2,747,661,84 ( 48,OD6,91} 2,599,654.93 1.91,884,28 ( 898,00} 190,986,28 268,960,89 0,00 268,950,89 3,308,069,D6 { 60,29) 3,308,OD8,77 1,3.1.0,750,94 { 8,343.05) 1,102,407,89 1,558,834,54 0,00 1,558,834,54 { 239,021,45} { 211,121,29} { 450,1.42,74} 68,037,71 { 128,635.78} { 60,598.D7} 540,723,07 0,00 54Dx723.07 { 380,001 { 95.00} { 475.00} 3,884,431,12 { 3,342,59} 3,8$1,088,53 3,447,646.90 { 3,919,04} 3,443,727,85 342,279.21 21,912,58 354,191,79 { 4,994.00) 44,287.03 35,293.03 115,1.03.26 { 33,167,18) 81,936.08 32,703,170.89 ( 1,216,446,701 31,486,724,19 e -• ~, r:~^~ t a f,~ ~ ~ ~ ~ fry Cr * '~. d 11-12-20D9 08 :17 AM CITY OF NLK RIVER PAGE: ._-' 1 ' c.e ~ ~ ~~ c_z a't r, „ '~ <~ REVENUE & EXPENSE REPORT (UNAUDITED} ~~~- ~ ~~:~+~~ r~~~~l~ff ;;: ~~ ~; ~w~;-;;~; '~ AS oF: oCTOaER 31ST, 2009 101-GENERAL FUND FINANCIAL SUMMARY 83.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,650,100.00 433,747,87 6,832,382,97 54.01 5,817,717.03 TOTAL REVENUES 12,650,100.00 433,747,87 6,832,382.97 54.D1 5,817,717.03 EXPENDITURE SUMMARY General Government Mayor & Council 168,100.D0 42,394.48 143,059,96 85.10 25,040.04 Cable TV 81,800,D0 9,109.19 56,148.30 68.64 25,651.70 Administrative Services 971,650.00 99,373,85 362,797,33 76,91 108,902.57 Human Resources 197,950,00 15,838.72 115,373,24 77,98 32,576,76 Finance 497,300.00 40,968,53 370,645.19 82.86 75,654,81 Information Technology 278,050.00 19,562,14 155,520.90 55.93 122,529,10 Legal 239,000,00 19,098,25 164,956,11 70,49 69,043,89 Community Development 126,950,00 7,431,70 87,254,47 68.73 39,695,53 Planning 321,200.00 38,756,88 241,878.97 75.30 79,321,03 City f-~a1.1 Maintenance 286,350.00 28,911.31 212,081.11 79.06 74,268,89 Contingency '10,050.00 2,196.39 6,434,95 9.19 63,615.55 TOTAL General Government 2,633,900.00 273,591,99 1, 916,100,03 72.76 717,299,97 Public Safety Police Administration 597,700.00 62,173,17 487,960,76 81.56 110,239.24 Patrol 2,1$2,800,00 215,961.90 1,589,598,69 72.82 593,251,31 Investigations 714,150.00 73,828.51 522,492.50 73.16 191,657.50 Police Support Services 492,050,00 50,876.20 375,289.69 76,27 116,760.31 Police Reserves 22,750.00 733.19 7,337.76 32,25 15,912.24 Public safety building 202,700.00 20,42$,82 199,237,50 71.16 58,962.50 Fire Administration 972,200.00 97,361,64 359,315,54 75,09 112,884.96 Fire Inspections 188,850.00 18,971,19 149,826.49 79,34 39,023.51 Emergency Management 99,150.00 937,40 13,591.43 27,65 35,558.57 Building Safety 588,600,00 51,113.40 963,912.62 78.73 125,187,38 Environmental 75,350,00 7,953,91 57,8$3,89 76,82 17,966.16 TOTAL Public Safety 5,586,300.00 550,338,33 4,170,396,82 79,65 1,415,903,18 Public Works Street Maintenance 1,300,650.00 157,485.53 1,043,650.87 80.29 256,999.13 Snow Removal 308,750.00 1,791,28 151,830,40 99,18 156,919.60 Equipment Services 250,950,00 25,552.37 186,165,62 74.33 64,289,38 Engineering 191,150.00 8,863.38 69,202,14 36.20 121,947.$6 TOTAL Public Works 2,051,000,00 193,692,56 1, 450,$49.03 70,74 6aa,15a.97 11-12-2pp9 08;17 AM 1D1-GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDZTED~ AS OF; OCTOBER 31ST, 2009 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 3.330 a OF BUDGET PAGE; 2 F YEAR COMP. BUDGET BALANCE Culture & Recreation Parks Department 733,150.00 96,555.8$ 608,223.86 82.96 124,926.19 Parks & Rec Admin 541,45D.OD 53,979,71 921,081,26 77.77 120,368.79 Recreation Programs 178,300.00 18,332.87 181,$79.19 102.D1 ( 3,579.14) Concessions 19,500.00 879.$8 10,739.41 55.07 8,76D.59 Sr Citizen Programs 193,350,00 20,615.29 152,573,02 78.91 90,776.98 TOTAL Culture & Recreation 1,665,750.DD 19D,363.63 1,379,496.69 82.52 291,253.31 Economic Development Econamic Development D.00 21,37D.25 35,102.57 0,00 ( 35,102,57} Energy City 55,800.D0 9,136.48 29,102.93 52,16 26,697,07 TOTAL Economic Development 55,800.00 25,506.73 b4,205.50 115.D6 { 8,905.50 General Transfers Out 229,300,00 0,00 66,600.00 29.09 162,700.00 TOTAL General 229,300.00 0.00 66,6DO.D0 29.09 162,74D.DD TOTAL EXPENDITURES 12,221,55D.OD 1!233,492.59 91092,698.07 73.99 31178,901.93 REVENUES AVER/(UNDER) EXPENDITURES 428,550.00 ( 799,794.82)( 2,210,265.10) 2,638,815.1D 11-12-2D09 08:17 AM CITY OF ELK RxVER PAGE: 3 REVENUE & EXPENSE REPQRT (UNAUDITED] AS OF: OCTOBER 31ST, 2409 101-GENERAL FUND 83.330 QF YEAR COMP, CURRENT CURRENT YEAR TO DATE o QE BUDGET REVENUES BUDGET PERrOD ACTUAL BUDGET BALANCE General Fund Taxes 101W3~0000~3111 Current Ad Valorem Taxes 9,547,550.00 O.DD 4,50D,716.25 97,19 5,046,833.75 101-3-000 03112 Delinquent Ad Valorem Taxes 0,00 D.00 70,113.75 0.00 { 70,113,75} 101~3~0000-3121 Gravel Tax 150,000.00 29,308,66 60,007,70 90,01 89,992.30 101-30000-3123 Franchise Tax D.DO 0.00 82,461.12 D.DO ( 82,4&1,12} 101-3-D400~3131 Penalties/Interest O.DD O,00 3,169,37 0,00 ( 3,159.37} 101-3-0004-3132 Tax Forfeited Land Sale O.OO 0.00 25.55 4.00 { 25.55} TOTAL Taxes 9,597,550.40 29,308.66 4,716,993,74 9$.64 9,981,D56.26 Licenses & Permits 101-30000-3211 Liquor License 51,DOD.D0 4.00 49,225.00 96.52 1,775.00 101-3-DODO-3212 Amusement License 1,000.00 O.DO O.DO D.40 1,000.00 101-3-DODO-3213 Cigarette License 3,OOD.00 75O.OD $5D,D0 2$.33 2,15D.D0 101~3W0400w3214 Apartment License 15,850,00 O.OD 16,470.00 103,91 { 620,00} 101-3-DODO-3216 Mining License 9,ODO,OD 0,00 20,562,45 228.47 ( 11,562,45} 101-3-D000-3217 Garbage Hauler License 3,000.00 0.40 3,095,00 103.17 { 95.OD} 101-3-0000-3218 Other Business License/Permit 13,000.00 160.00 19,5O5.OD 150.D4 { 6,505.00} 101- 30000-3229 NPDES Permit 5,000.00 350.00 1,575,00 31.50 3,425,00 101~3~OOD0~3231 Building Permit 188,3DD,DD $,220,95 116,356.97 61.80 71,933.03 101-3-0000-3232 Plumbing/Heating Permit 97,600.DO 3,173.00 44,759.71 94,03 2,$40.29 101-3-GOOD-3233 Permit Surcharge 240.00 { 91.28) 572,31 286.16 ( 372,31) 1D1-3-OOOQ-3234 Electric Permit 100.00 0,00 0,00 O.OD 100.00 141~3~0000µ3235 Animal License 3,OOO.DD 122,00 3,746.D0 123,53 ( 706.D0) 101-3-0000-3236 Parking Permit 1,500,00 0.00 1,340.00 89.33 160.00 1D1-3-GOOD-3237 Other Non-Business Lic/Permit 12,000.D0 1,310.00 7,505,00 62,59 4,495.00 TOTAL Licenses & Permits 353,550.OO 14,094.&7 285,532,44 80.76 68,017.56 Intergovernmental Rev 101-3~0000~3321 Laval Government Aid 686,800,00 D.44 146,672,00 21,36 590,128.00 101-3-DOOD-3322 MV Credit D,OQ 165,530.73 165,530.73 O.OO ( 165,530,73} 101-3-DODO-3324 PERA Aid 15,000.00 0.00 6,992.D0 46.61 8,D08.D0 101-3~D000-3325 Police 20 Aid 215,000.00 206,473.00 206,473,00 96,03 8,527,00 101~3M0000~3326 Police Training Reimb 10,DDD.00 0,00 12,288,82 122,89 { 2,288.82} 101-3-GOOD-3327 StateMAid Street Maint 36,800.00 0.00 36,721,64 99,79 78.36 101-3-GOOD-3329 State Crime Prevention Grant 12,500,00 ( 9,569,13} 14,606,68 116.85 ( 2,1D6.68) 101-3-0000-3391 County Reimb/Giant 7,500.00 0.00 D.OO O.DO 7,500.00 TOTAL Intergovernmental Rev 983,60D.04 367,434,60 589,284,87 59.91 394,315.13 Charges for Services 101-3-040D-3912 Planning & Zoning Fees 25,DOD.OD 1,630.00 12,880.00 51.52 12,124.00 101-3-OOD4-3413 Plan Check Fee 75,300.00 1,995,44 38,998.51 51.13 36,801.99 101-3-OD00-3915 Special Assessment Search 500.00 40.OD 440.OD 88.00 6D.00 101-3-D400-3417 Copies 1,500.00 251.15 1,797,85 119,$6 { 297.85) 101-3-ODOO-3918 Other General Govt Services 5,000.00 252,5D 3,146.13 62,92 1,853.87 101-3-OD00-3430 Lockout Fees 8,500,00 560.04 6,279,58 73,82 2,225,42 11-12-2009 08:17 AM CITY OF ELK RIVER PAGE; 9 REVENUE & EXPENSE REPORT UNAUDITED) AS OF; OCTOBER 31ST, 2D09 1D1-GENERAL FUND 83,33% OF YEAR COMP, REVENUES CURRENT BUDGET CURRENT PERIOD YEAR TO DATE ACTUAL fl OF BUDGET BUDGET BALANCE 7.01--3-0000--3931 Police Services 2, 000. DD 90.25 2, 696.44 134.82 ( 696, 44) 101-3-0000-3932 School Liaison 75,DOO.DD O.OD 75,000.00 100.OD 0.00 101-3-DDO0-3434 Animal Impound Fee 3,OOD.DD 625.00 3,595.00 119,83 ( 595.00) 1D1--3-000 03936 Fire Contracts 208,000.00 D.OD 158,192.00 76.05 49,808.DD 101-3-0400-3437 Fire Calls 1,0OO.OD 0,00 0.00 0.00 1,000,00 101-3-0000-3951 Street Services 25,000.00 987,38 32,19D.29 128.56 ( 7,140,29} 101-~3-00003461 Recreation Fees 133,000.00 88D,63 114,493.6b 86.09 18,506.39 101-3-0000-3967 Concessions 20,1DD.00 348.54 10,834.70 53.90 9,265.30 101-~3--OD00-3472 Park Use Fee 2,600.00 ( 115.38) 13,918,59 516.10 ( 10,81$,54y 101-3-0000--3474 Facility Use Fee 3,100.OD 527,12 5,629.97 181.61 ~ 2,529,97) 101-3-ODO0-3975 Building Rent 2,40D.OD 200,00 5,600.OD 233.33 t 3,200.00) 101-3-ODOO-3483 Sewer Inspection Fee S,000.OD 735.OD 2,315.00 46.30 2,685.00 101-3-0000-3484 Contractor License Check 500.OD 95.00 365.00 73,00 135.00 TOTAL Charges for Services 596,500.OD 9,002.63 487,317,62 87..70 1D9,182.38 Fines & Forfeits 101-3-ODO0-3510 Court Fines 150,004.00 13,405,01 89,115.83 59,41 60,889.17 101--3--0000-3511 Parking Fines 7,000.OD 20,00 10,895,75 155,65 ( 3,895.75) 101--3~-0000.3512 Ordinanace Violations D.00 0.00 300.00 0.00 ( 300.D0) TOTAL Fines & Forfeits 157,000.00 13,425.01 100,311.58 63,89 56,688.42 Other Revenue 101--3--0000--3621 Interest Income 180, 000.00 D. DO 26, 784.56 14.88 153, 215 , 44 101-3-000 03525 Refunds & Reimbursements 59,OOD.00 224.91 2,339.28 4.33 51,b60.72 101-3-0000-3626 Contributions 25,300.00 0.00 18,5b2.00 73.37 6,738,00 101-3-0000-3629 Miscellaneous Revenue 3,OOD.00 307.39 6,156,88 205,23 ~ 3,156.88} TOTAL ether Revenue 262,300.00 532.3D 53,842.72 20.53 208,457,28 Transfers In 101-3-0000-3925 Transfer-Landfill 35,000.00 0,00 35,000.00 10D.00 O.OD 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 D.00 39,500,00 100.00 0.00 101--3-~0000~3942 Transfer-WWTS 50,OOD,OD D.00 50,000.00 10D.00 0,00 101--3-0000-3943 Transfer-Liquor 248,600.DD D.DO 298,600.00 1DD.00 O.OD 101-3-0000-3945 Transfer-Utilities 200,DDO.DO 0.00 200,OOD.00 100.00 0.00 101-3-0000-3948 Transfex-EDA 17,000,04 0.00 17,000.00 100.00 0.00 1D1-3-0000-3999 Transfer-HRA 9,500.00 0.00 9,500.00 1DD.00 O.OD TOTAL Transfers In 599,600.00 D.DO 599,600.00 100.00 0.00 TOTAL General Fund 12,650,100.00 433,747,87 6,832,382,97 54,01 5,817,717,03 TOTAL REVENUE 12, 650,1D0.00 933,747,87 6,832,382,97 54,01 5,817,717,03 __~_~.--.-___~- ------------- ------.~~~____ __-_.-__ W~_-~_____-_W ~~~.~.~~..___.---- ------------- ------.~~-____ -___W__ W~-~-_____-_.~ 11-12-2009 08;17 AM CITY OF ELK RrVER PAGE; 5 REVENUE & EXPENSE REPORT (UNAUDITEp} AS OF; OCTOBER 31ST, 20D9 101-GENERAL FUND 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGNT DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101~9~1110~9103 Part-time Pay 38,500.00 3,208.00 32,080.0D 83.32 6,420.0D 1D1-4-1110-41D4 PERA 1,95D.00 102.07 1,020.70 52.39 929.30 101-9-1110W4105 FICA 2,900.00 19$.90 1,989.00 82.88 911.DD 1D1~9~1110~41D7 Medicare 550.00 96.52 965.20 89.58 89.80 10 19-1110-4109 Workers Comp 5D.D0 11.0D 40.25 80.50 9.75 TOTAL Personal Services 93,450.00 3,566.99 35,595.15 81,92 7,859.85 Supplies 101-9-1110-9201 Office Supplies 3,200.OD 47.03 960.61 30.02 2,239.39 TOTAL Supplies 3,200.D0 47.03 960.61 30.02 2,239.39 Other Services & Charges 101M4~1110-9319 Other Professional Services 6,750.00 2,706.08 8,580.09 127.11 ( 1,830.09} 101-9-1110-9322 Postage 80D.D0 D.00 106.34 13.29 693.66 101-4-1110-9331 Travel, Conferences & Schools 6,50D.00 51.70 1,918.80 29.52 4,581.20 1D1-4-11109359 Publishing 18,200.00 0.00 9,387.98 51,58 8,812.52 101~4~1110~9361 Insurance 69,800.00 39,971.50 65,283.50 102.29 ( 1,483.50} 101~4~1110-4933 Dues & Subscriptions 15,000.00 D.DO 15,730.00 104.87 ( 73D.0D} 101-9-1110-4940 Miscellaneous 9,900.00 1,051.68 4,997.99 47.85 4,902.01 TOTAL Other Services & Charges 121,450,00 38,78D.96 106,509.20 87.69 14,945.80 TOTAL Mayor & Council 168,100.00 92,394.98 143,059.96 85.10 25,040.D4 Cable TV Personal Services 101-9-1120-9101 Regular Pay 50,6D0.00 5,877.60 90,961.78 79.96 10,138.22 101-4-1120-4103 Part-time Pay 11,800.00 543.76 3,137.52 26.59 8,562.98 101-4-1120M4104 PERA 3,550.0D 396.75 2,826.90 79.62 723.60 1014-1120-4105 FICA 9,000.00 395.56 2,769.23 69.23 1,23D.77 101-4-1120-4107 Medicare 950.00 92.51 697,62 68.17 302.38 101-9-1120-4108 Insurance 5,250.0D 938.01 4,380.10 83.93 869.90 101-9-1120-4109 Workers Comp 200,00 99.25 179.00 87.00 26.00 TOTAL Personal Services 75,350.00 7,788.94 59,396.65 71.25 21,953.35 Supplies 101-4-1120-4201 Office Supplies 3,350.DD 1,316.61 1,620.35 48,55 1,723,65 TOTAL Supplies 3,350.D0 1,316.61 1,626.35 98,55 1,723.65 11-12-2aa9 D8:17 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF; OCTOBER 31ST, 2009 PAGE; 6 83.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Othex Services & Charges 101-4-1120-4319 Other Professional Services 500,00 0,00 O,DO 0.00 500.00 101-~4w112D-4322 Postage 100,OD D,00 b,b2 6.&2 93,38 101-4-1120--9331 Travel, Conferences & Schools 1,4DD,OD D,DD 119,54 8.18 1,285,46 101-4-1120-4404 Equip Repair/Maint Services 1DO.OD 4,14 4.14 4.14 95.86 TOTAL Other Services & Charges 2,100.00 4,14 125.30 5,97 1,979.70 TOTAL Cable TV 81,8DO,OD 9,109.19 56,148.30 &8,69 25,b51,7D Administrative Services Personal Services 101-4-1210--4101 Regular Pay 296,750.D0 33,897,67 238,203,93 80.27 5$,546,57 101-9-1210-4102 Ovextime Pay 2,000.00 0,00 D.OD 0.00 2,DOD.00 1D1-9-1210-9103 Part-time Pay 95,600,00 5,373.42 35,6b9.D4 78.22 9,93D,96 101-4--1210-4144 PERA 23, 25D. DO 2, 65D.79 19,137 . D3 82.31 4,112.97 101-4-1210-9105 FICA 21,35D.00 2,392,85 17,184.29 80,49 4,165.71 1D1-4-1210-9106 Other Retirement Contributions 4,840.00 900.00 9,000,00 83,33 800.D0 1D1-4-1210-4107 Medicare 5,000.00 559,&3 4,018.97 80,38 981.03 101--9-1210-4108 Insurance 23,450,00 1,954.03 19,590.30 83.33 3,9D9.70 101-4-1210-4109 Workers Comp 1,3DD.DD 901.DD 1,952.54 111,73 { 152,50} TOTAL Personal Services 423,500.OD 97,629,39 339,205.56 80.10 84,294,44 Supplies 101.4-~121D~4241 Office Supplies 9,900,00 391,D2 4,68D,83 97,28 5,219,17 TOTAL Supplies 9,900.44 391,42 4,680.83 97,28 5,219.17 Other Services & Charges 141-4-1210-4319 Other Professional Services 9,50D.00 O,OD 4,860,D0 108,OD { 350,04} 101--4--1210-4321 Telephone 600.00 57,40 569.42 94,90 34,5$ 101-4-121 09322 Postage 1,500.D0 D,DQ 256.39 17,09 1,243.66 101-4-1210-4331 Travel, Conferences & Schools S,bOD.00 17,77 1,532,39 27,36 4,067,61 101-4-1210-9361 Insurance 200.00 46,50 158,50 79,25 91,5D 101--4--1210-94D4 Equip Repair/Maint Services 22,600,00 1,199.94 10,990.99 48.41 11,659.41 101--9-1210w9433 Dues & Subscriptions 2,60D,00 4.00 22D.00 8,46 2,380,04 101-4-1210-4464 Equip Replacement Charge 650,00 32.33 323.30 49,74 326,70 TOTAT~ Othex Services & Charges 38,250.00 1,353.44 18,860.94 49,31 19,389.06 TOTAL Administrative Services 471,650.OD 49,373.85 362,747,33 76.91 108,942.67 Human. Resources 11-12--2009 08;17 AM 1p1~-GENERAL FUND General Government DEPARTMENTAL EXPENDTTURES PAGE; 7 $3.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101--4--122p-~41p1 Regular Pay 68, 850 , 00 7, 828 , 86 55, 323.94 80.35 13, 526, 06 101-4-1220-4103 Part-time Pay 45,200,00 5,446.01 37,538,68 83,27 7,561.32 101-4-1220-4104 PERA 7,700,00 896,05 6,512,85 84,58 1,187,15 101--4~-1220--4105 FTCA 7, 3.Qp , 00 817 , 4 9 5, 937 , 33 83 , 62 1,162 , 67 101-4-1220-4107 Medicare 1,650.00 191.19 1,388,53 84,15 261,47 101-9-1220-4108 Tnsurance 5,250.00 438.00 9,380,00 83.43 870.00 101-9--1220--4109 Workers Comp 450,00 136.75 485.50 107.89 ( 35.50) TOTAL Personal Services 136,200,00 15,754.35 111,666.83 81,99 24,533.17 Supplies 101-4~-1220-9201 Office Supplies 3,000.00 0.00 2,562,44 85,41 437,56 TOTAL Supplies 3,000.00 0,00 2,562.99 $5.41 437,56 Other Services & Charges 101--4--1220--4319 Other Professional Services 3,ODO,pO 0.00 0.00 0.00 3,000,00 101-4-1220--4322 Postage 350.00 0.17 200.78 57,37 199,22 101-9-1220-9331 Travel, Conferences & Schools 3,750.OD 0,00 251.54 6.71 3,998,46 101-4-1220-4359 Publishing 0.00 p,DO 37,50 O,DO ( 37.50f 101-4--1220--4433 Dues & Subscriptions 650.00 0,00 0,00 0.00 650.00 101-4-1220-4440 Miscellaneous 1,000.00 84,20 654.15 65.92 345.85 TOTAL Other Services & Charges 8,750.00 $9.37 1,143.97 13.07 7,606.03 TOTAL Human Resources Finance Personal Services 101-4-1310-4101 Regular Pay 101-4-1310-4103 Part-time Pay 101-4-1310-9104 PERA 101--41310--4105 FICA 101-4-1310-4107 Medicare 101-4-1310-9108 Insurance 101-9-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-9-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101--4--1310--9301 Audit Fees 101-4~-1310.4319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-4322 Postage 1D1-4-1310-9331 Travel, Conferences & Schools CTTY OF ELK RIVER REVENUE & EXPENSE REPORT UNAUDITED} AS OF: OCTOBER 31ST, 2009 197,950.00 15,838.72 115,373.24 77,98 32,576.76 289,350,00 32,677.63 227,955,35 80.17 56,399,64 5,150,00 1,140.00 3,355,00 65,15 1,795.00 19,550,00 2,205,75 15,927,99 81.47 3,622,D6 17,950.00 1,999.66 13,888.70 77,37 9,061,30 4,200,00 467,67 3,248.10 77,34 951,90 23,450,00 1,959.03 19,540,30 83,33 3,909.70 1,100.00 335.75 1,222,50 111,14 ( 122,50) 355,750.00 90,781,49 285,137,90 80,15 70,612.10 3,850.00 0,00 1,982.22 51,49 1,867.78 3,850.00 0.00 1,982.22 51.49 1,867.78 17,300.00 0,00 17,280,00 99,88 20.00 48,150,00 0,00 98,788,00 101,33 ( 638.00) 850.00 57,90 524.21 61,67 325.79 3,600.00 0.00 932,74 25,91 2,667.26 9,150.00 129.64 2,542.92 61,28 1,607.08 11-12-2009 08;17 AM CTTY OF ELK RTVER PAGE; $ REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; OCTOBER 31ST, 2009 101-GENERAL FUND General Government 83.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERTOD ACTUAL BUDGET BALANCE 1014-1310W4359 Publishing 2,000.00 0.00 1,290.00 62.00 760.00 101-4-1310-4404 Equip Repair/Maint Services 10,100.04 0.00 10,709,20 105,98 ~ 604.20} 101-4-1310-4433 Dues & Subscriptions 1,550.00 0.00 1,375.00 88.71 175,00 101~4M1310~444D Miscellaneous 0.00 0.00 138.00 0.00 ~ 138.OD} TOTAU Other Services & Charges 87,700.00 187.04 83,525.07 95.24 4,179.93 TOTAL Fznance 447,300.00 40,968.53 37D,645.19 82.86 76,654.81 information Technology Personal Services 101-91350-9101 Regular Pay 129,300.D0 19,813.17 103,665.33 80.17 25,639.67 1014-135D~9103 Part time Pay 12,85D.D0 O.DO O.DD 0.00 12,850.00 101-4-1350-4104 PERA 9,600.00 999.90 7,249,11 75.96 2,355.89 101-4-1350-9105 FICA 8,800.00 9D5.92 6,407.$8 72.82 2,392.12 101~4W1350-9107 Medicare 2,050.OD 211.86 1,498.62 73.10 551.38 101-4-13509108 Tnsurance 15,350.00 1,280.02 12,396.18 80.76 2,953.82 101-4-135D-4109 Workers Comp 55D.00 151.50 586,50 106.64 ~ 36.50) TOTAL Personal Services 178,500.00 1$,362.37 131,798.62 73.84 46,701.38 Supplies 101-4-135D~4219 Operating Supplies 23,300.x0 1,135.86 7,414.17 3D.10 16,285.83 TOTAL Supplies 23,300.00 1,135.86 7,019.17 3D.10 16,285.83 Other Services & Charges 101-4-13504319 Other Professional Services 8,000.40 0.00 330.00 4.13 7,67D.00 101-9-1350-4321 Telephone 800.00 47.32 954.90 56.80 395.60 101-9-1350-9331 Travel, Conferences & Schools 4,500.04 16.59 3,9$9.67 77.55 1,010.33 1D 19-1350-9404 Equip Repair/Maint Services 19,950.00 0.00 7,824.59 39.22 12,125.91 TOTAL Other Services & Charges 33,250.00 63.91 12,098.66 36.39 21,151.39 Capital Outlay 101-4-1350-456D Equipment 43,OOD.OD O,OD 4,609.95 10.72 38,390.55 TOTAL Capital Outlay 43,004.00 O.DD 4,609.45 1D.72 38,390.55 TOTAL Tnformation Technology 278,050.00 19,562.19 155,520.90 55.93 122,529.1D Legal Other Services & Charges i41-4-14D0-4304 Legal Fees 234,000.00 19,098.25 169,956.11 70.99 69,D43.89 TOTAL Other Services & Charges 234,40D.00 19,D98.25 169,956.11 70.99 69,093.89 TOTAL Legal 239,OOD.00 19,098.25 164,956.11 70.99 69,D43.89 11-12-2009 08;17 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: OCTOBER 31ST, 20D9 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES $3.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Community Development Personal Services 101-9-1500-4101 Regular Pay 84,550,00 6,079.21 68,235.79 80.70 16,314,21 101-9-1500-4104 PERA 5,700.DD 410,34 3,877.68 68.03 1,822.32 101~9~15O0~41D5 FICA 5,300.00 358.14 4,295,69 80.11 1,054.31 101-4-1500-4107 Medicare 1,250,00 $3.76 992.98 79.44 257,02 101-4-1500-4108 Insurance 8,700.DD 438,00 6,867,38 78.94 1,832,62 1D1~9W150D~4109 Workers Camp 550.00 62,25 489.75 89.05 6D,25 101w4-150 04110 Reemployment Compensation 18,100,00 0,00 1,865.70 10,31 15,234.30 TOTAL Personal Services 124,150,00 7,431.70 86,574,97 69,73 37,575,03 Supplies 101-4-1500-4201 Office Supplies 250.00 0.00 32.71 13.08 217.29 TOTAL Supplies 250.00 0.00 32.71 13.08 217.29 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 O.OD 696,79 25.36 1,903,21 TOTAL Other Services & Charges 2,550.00 0.00 646,79 25.36 1,903,21 TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4104 PERA 101W4~1510-41D5 FICA 101µ4~1510~4107 Medicare 101-4M1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-9201 Office Supplies 101-4-1510-4212 Fuels & Lubs 101-4-1510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1510-4319 Other Professional Services 101-9-1510-4321 Telephone 1D1-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-9-1510-4359 Publishing 101-9-1510-4361 Insurance 126,950.D0 7,431,70 87,254.97 68,73 39,695.53 210,300.00 24,104.61 168,293.39 80,03 42,D06.66 14,200.00 1,627.D5 11,637,23 81.95 2,562.77 13,D50.OD 1,397.05 9,741.74 74,65 3,308.26 3,050,00 326,72 2,278.39 74.70 771.61 28,3D0.00 2,140,02 20,760.19 73.36 7,539.81 500.00 154.00 620.50 124,10 ( 120.50) 269,900.D0 29,749.45 213,331,39 79,19 56,068,61 4,850.00 201,33 3,621,91 74,68 1,228,09 850,00 205,38 1,106,90 137,23 ~ 316.46) D.DD 0.00 109.19 0.00 t 109.19) 5,7DD.00 906.71 4,897,56 85,92 802.44 20,OOD.00 0.00 6,952.39 34,76 13,047.66 8D0.00 23,66 296,59 30.82 553,96 2,000,00 D.OD 1,105,06 55.25 894,94 6,350.00 3,19D.D0 9,020,83 63,32 2,329.17 10,OOD.D0 352.50 9,591.95 45,91 5,408.55 700.00 338,00 338.00 48,29 362.00 1112-2009 08;17 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2009 PAGE; 10 $3.330 OE YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL SUDGET BALANCE 101M9~1510-4409 Equip Repair/Maim Services 5,000.00 9,796.56 5,791.80 115.84 [ 791.80) 101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 945.00 94.50 555.00 101-4-1510-9440 Miscellaneous 250.00 D.OD 159.00 63.60 91.00 TOTAL Other Services & Charges 96,100.00 $,600.72 23,650.02 51.30 22,449.98 TOTAL Planning 321,200.00 38,756.88 291,878.97 75.30 79,321.03 City Ha11 Maintenance Personal Services 101-9-1600-4101 Regular Pay 83,750.00 11,249.12 79,570.34 95.01 9,179.66 101-9-160 04102 Overtime Pay 9,100.00 0.00 0.00 0.00 9,100.00 101~4~1600-4103 Part time Pay 18,450.00 2,59$.55 18,935.29 102.63 ( 485.29 101-4-1600-4104 PERA 7,800.00 915.88 6,552.42 84.01 1,297.58 101-4-1600-9105 FICA 7,150.00 871,52 6,255.84 87.63 889.16 101-4-160 09107 Medicare 1,700.00 203.82 1,965.93 86.20 234.57 101- 91600-9108 Insurance 11,900.00 1,069.18 11,982.25 100.69 { 82.25) 101-4-1600-9109 Workers Comp 2,550.00 1,324.00 4,530.25 177.66 ( 1,980.25 TOTAL Personal Services 192,900.00 18,177.07 129,301.82 90.80 13,09$.18 Supplies 101-4-1600-4212 Fuels & Lubs 3,750.00 253.87 1,801.22 98.03 1,948,78 101-4-1600-4217 Uniform Allowance 1,700.00 O.DO 820.67 98.27 879.33 101-9-1600-9219 Operating Supplies 30,000.00 9,099.54 19,506.93 65.02 10,493.57 TOTAL Supplies 35,450.00 9,298,41 22,128.32 62.42 13,321,68 Other Services & Charges 101-9-1600-4321 Telephone 15,450.00 $30,65 91325.87 60.36 6,129.13 101-9-1600-9331 Travel, Conferences & Schools 2,000.00 0.00 1,310.71 65.59 689.29 101~9~1600~9361 Insurance 5,700.00 2,316.50 9,636.50 81.39 1,063.50 101~9~1600M9389 Utilities 51,800.00 2,312.80 29,437.69 56.83 22,362.31 101-4-1600-4401 Bldg Repair/Maint Services 32,300.00 975.88 15,411.54 47.71 16,888,96 101-4-1600-4904 Equip Repair/Maim Services 1,250.00 0.00 528,66 42.29 721.39 TOTAL Other Services & Charges 108,500.00 6,435,83 60,650.97 55.90 47,899.03 TOTAL City Hall Maintenance 286,350.00 28,911.31 212,081.11 74.06 74,268.89 Cantingency Other Services & Charges 101-4-1900-4440 Miscellaneous 70,050.00 21196.39 6,434.95 9.19 63,615,55 TOTAL Other Services & Charges 70,050.00 2,196.39 6,439,45 9,19 63,615.55 TOTAL Contingency 70,050.00 2,196.39 6,939.95 9.19 63,615.55 TOTAL General Government 2,633,400.00 273,591.49 1,916,100.03 72,76 717,299.97 11-12-2009 08;17 AM CITX OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT {UNAUDITED} AS OF; OCTOaER 31sT, 2D09 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDrTURES $3.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET aALANCE Folice Administration Personal Services 101-9-2110-9101 Regular Pay 101~4~211D~9104 PERA 101-4-2110-4105 ErGA 101-4-2110-4107 Medicare 101W9W2110~9108 Insurance 101-4-211 09109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-9-2110-4217 Uniform Allowance 101-9-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-9319 Other Professional Services 101W9~211D-9321 Telephone 101-4-2110-9322 Postage 101-4-2110-9331 Travel, Conferences & Schools 101-9-2110-9359 Publishing 101-9-2110-4361 Insurance 101~4~2110~9904 Equip Repair/Maint Services 101-4-2110-9433 Dues & Subscriptions 101-4-2110-9437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-21109560 Equipment TOTAL Capital Outlay 279,400.00 31,773,66 229,533.87 80.36 54,866,13 39,90D.00 9,980.11 32,815,70 83.29 6,589.3D O,DD 0.00 1,116.38 O.DD { 1,116.38} 2,550.00 306.93 2,987,32 97.54 62.68 23,250.00 1,938.D1 19,380,10 83.36 3,869.90 98,500.00 13,390.50 52,301,25 107,89 [ 3,801.25} 393,100,00 51,889,21 332,634,62 84.62 60,965.38 16,DDD.00 92D.39 8,222.09 51.39 7,777.91 2,500.00 92,74 1,589.11 63.56 910.89 3,150.00 0.00 1,115.82 35.92 2,039.18 21,65D.00 963.08 10,927.D2 50,97 10,722,98 5,500,00 32,78 1,969.88 26.63 4,035.12 25,000.00 1,179.06 16,891.07 67.36 8,158.93 2,100.D0 D.00 969.89 22,37 1,630.16 9,2DD.OD D.OD 723.69 17,23 3,476.31 500.D0 0.00 112.20 22.44 387.80 12,450.00 4,960.50 9,037,00 72.59 3,413,00 69,250.00 3,562.29 53,101,99 76,68 16,198,56 5,850.D0 D,DO 9,259,00 72,72 1,596,00 50D.00 91,25 296.00 59,20 209.00 125,350.00 9,320.88 86,300.12 68.85 39,449,88 57,600.00 0.00 57,599.00 100,00 1,00 57,60D.D0 0,00 57,599.00 100,00 1.00 TOTAL Police Administration Patrol Personal Services 101-4-2120-9101 Regular Pay 101-4-2120-9102 Overtime Pay 101-9-2120-4104 PERA 101-9-2120-4107 Medicare 101-9-2120-4108 Insurance TOTAL Personal Services 597,704.00 62,173.17 987,460.76 $1,56 110,239.24 1, 435,250.OD 151,390.66 1,08D,560.31 75,29 359,689.69 90,ODO.OD 8,597.61 92,692,10 97,3$ 97,357,90 215,050,DD 22,558.90 163,774,90 76.16 51,275,10 19,84D.00 1,932.82 13,795.77 69,68 6,004.23 150,400.00 12,118.06 128,920.69 85.72 21,479.31 1,910,500.00 196,597,55 1,429,693.77 74.83 980,806.23 11-12-2009 x8;17 AM CITY OF ELK RTVER PAGE; 12 REVENUE & EXPENSE REPORT ~UNAUDTTED) AS OF; OCTOBER 31ST, 2009 101-GENERAL FUND Public Safety pEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 83.33°s OF YEAR COMP, YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-9217 Uniform Allowance 101~9~2120~9219 Operating Supplies 101-4-2120-9221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101~9~2120-4404 Equip Repair/Maim Services 101-4w2120M9933 Dues & Subscriptions 101-4-2120-9960 Equip Replacement Charge TOTAL Othex Services & Charges TOTAL Patrol Investigations Personal Services 101W4-2130-4101 Regular Pay 101~9~2130~9102 Overtime Pay 101-4-2130-4109 PERA 101-9-2130-4107 Medicare 101-9-2130-9108 Tnsurance TOTAL Personal Services Supplies 101-4-2130-9217 Uniform Allowance 101-9-2130-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101~9~213D-4331 Travel, Conferences & Schools 101~9~2130rv9933 Dues & Subscriptions 101-4-2130-9960 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Investigations Police Support Services 95,D00.00 1D,576.76 62,904.89 66.22 32,095.11 17,200.00 1,939.33 6,350.48 36.92 10,849,52 99,000.00 2,054,53 28,466.09 58,09 20,533.91 25,000,00 1,537.61 15,224.02 60.90 9,775.98 186,200,00 16,103,23 112,945.48 60,66 73,259,52 14,650,00 435.00 9,OOD.79 61.44 5,699,21 27,200.00 596.21 15,384,55 56.56 11,815.45 550.00 0,00 230.00 91.82 320.00 43,700,00 2,229.91 22,294.10 51.02 21,905.90 86,10D,DD 3,260.62 46,909.44 54.48 39,190.56 2,182,800,00 215,961.40 1,589,548.69 72.82 593,251.31 495,8D0,00 59,367,21 382,836,06 77,22 112,963.99 90,ODD.00 3,113.91 19,077.0D 35.19 25,923.00 75,550.00 8,923.82 58,604.35 77,57 16,995.65 5,600.00 540.05 3,697.98 66.03 1,9D2.52 58,60D.D0 4,914,94 99,149.4D 83.87 9,950.60 675,550,00 71,859,93 508,364.29 75.25 167,185.71 4,850,00 104.41 1,487,92 30.67 3,362,5$ 8,400,00 1,363.7$ 3,801,12 45.25 4,598,88 13,250,00 1,968.19 5,288.59 39,91 7,961.46 10,750.00 ( 93.6D~ 1,767.29 16,44 8,982,71 4,000.00 72.78 1,805.28 45.13 2,194,72 200.00 O.DD 50,00 25,00 150,00 10,900.00 521,71 5,217,10 50.16 5,182.90 25,350.00 500.89 8,839.67 34.87 15,510,33 714,150,00 73,$28,51 522,992,50 73,15 191,657.50 11-12-2009 08;17 AM CITY OF ELK RIVER PAGE; 13 REVENUE & EXPENSE REPDR T [UNAUDITED) AS OF; OCTOBER 31ST, 2009 101-GENERAL FUND Public Safety 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-9-215D-4101 Regular Pay 346,900,00 39,758,45 278,379.21 8D.25 68,520.79 101~9~2150~9102 Overtime Pay 6,500.00 37,59 98,68 1,52 6,401.32 101-9-2150-4104 PERA 23,850.00 2,686,22 19,456.23 81,58 9,393,77 101-9-215D-4105 FTCA 21,900.D0 2,425,19 17,47$,86 79.81 4,421.14 101~4W2150w9107 Medicare 5,100.00 567.16 4,087.66 8D.15 1,012,34 101-4-2150-4108 Insurance 42,05D.00 3,5D4,02 35,040.20 83.33 7,009.80 TOTAL Personal Services 996,300,00 48,97$,63 359,590.84 79.44 91,759.16 Supplies 101-4-215D-9201 Office Supplies 1,DOO.DD 68,90 493.24 49,32 506.76 101-4-2150-9217 Uniform Allowance 3,250.OD [ 8.25} 974.49 29.98 2,275.56 101~4~2150M9219 Operating Supplies 8,050.00 159.16 3,911.57 48,59 4,138.43 TOTAL Supplies 12,300.OD 219.31 5,379.25 43.73 6,920.75 Other Services & Charges 101~9~2150~4331 Travel, Conferences & Schools 3,550,00 10D.D0 455.00 12.82 3,095.DD 101-4-2150-4404 Equip Repair/Maim Services 5,500.00 D.00 3,765.00 68.45 1,735.00 1D1-4-2150-4909 Contractual Services 16,OOD.00 1,181,45 6,959.10 93.49 9,D90.9D 101-4-2150-4433 Dues & Subscriptions 500.DD 0.00 222.50 94.50 277.50 101w4~2150~4460 Equip Replacement Charge 7,900.00 396.80 3,968.00 50,23 3,932,00 TOTAL Other Services & Charges 33,450.00 1,678,26 15,369,60 45.95 18,080.40 TOTAL Police Support Services 992,050,00 50,876.20 375,289.69 76.27 116,760.31 Police Reserves Personal Services 101- 42160-4103 Part time Pay 5,500.00 D.DD 934,51 16,99 4,565,99 101-4-2160-4105 FICA 350,00 0,00 57,93 16,55 292,07 101-4-2160-9107 Medicare 1DD.00 0.00 13.54 13,54 86.96 101-9-2160-411D Re-employment Compensation O.DO 0.00 55.83 0.00 ( 55.83} TOTAL Personal Services 5,950,00 O.DO 1,061.81 17.85 4,888.19 Supplies 101-4-216D-4217 Uniform Allowance S,DOO.DO 54.00 898.62 17,97 4,101,38 101~4~2160~4219 Operating Supplies 6,000.00 539.9D 1,833.98 3D.57 9,166.02 TOTAL Supplies 11,000,00 593.90 2,732.60 24,84 8,267,40 Other Services & Charges 101-4-2160-9319 Other Professional Services 1,500.00 0.00 1,683.80 112,25 [ 183.80) 101-4-2160-9321 Telephone 1,500,00 139,29 1,378,55 86.16 221.45 1D1~4W2160~4331 Travel, Conferences & Schools 1,70D.00 0,00 D.00 O.DD 1,7DO.D0 1D1~9~216DM4433 Dues & Subscriptions 1,000.00 0,00 481,00 48,1D 519,00 TOTAL Other Services & Charges 5,800,00 139.29 3,543.35 61,09 2,256,65 TOTAL Police Reserves 22,750.00 733,19 7,337,76 32,25 15,912.24 11-122009 08;17 AM CITY OF ELK RIVER PAGE; 14 REVENUE & EXPENSE REPORT UNAUDITED) AS OF; OCTOBER 31ST, 2009 101~GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Public safety building Personal Services 101-9-21904101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4103 Part-time Pay 101~4M2190~9109 PERA 101-4-2190-4105 FICA 101-9-2190-4107 Medicare 101W9-219D-4108 Insurance 101~9~2190~9109 Workers Comp TOTAL Personal Services Supplies 101~9~219D~9219 Operating Supplies TOTAL Supplies Other Services & Charges id1~9~2190µ4361 Insurance 101-4-2190-4389 Utilities 1D1-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges 98,200,00 11,235.66 74,284.22 75.65 23,915.78 450,00 0.00 0.00 0,00 450.00 0.00 0,00 1,047,33 0,00 ( 1,047.33) 6,650,00 758.41 5,239.82 78.79 1,410,18 6,100.00 709.24 9,727,41 77,50 1,372.59 1,950,00 165.90 1,105,76 76.26 344,24 19,250,00 1,055.69 10,139,82 71.12 4,115.18 2,200.00 768,00 3,611,25 164.15 ( 1,411.25) 129,300.00 19,692,90 100,150,61 77,46 29,149,39 17,000.00 575.34 15,111.62 88.89 1,888.38 17,000.00 575,34 15,111,62 88.89 1,888,38 6,900.00 3,213.00 &,219.50 90.19 680.50 18,200.00 752,&7 8,686,82 97,73 9,513,18 31,300,00 1,199.91 19,068,95 94,95 17,231.05 56,900.00 5,160,58 28,975,27 51,37 27,424.73 TOTAL Public safety building Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101M4~2310~4109 PERA 101-4-2310-4105 FICA 1D1-4-2310-4106 Other Retirement Contributions 101-4-231D-4107 Medicare 101~4~231D-4108 Insurance 101-4M2310~4109 Workers Camp 101-4-231D-4110 Re-employment Compensation TOTAL Personal Services Supplies 101W9~2310-4201 Office Supplies 101~4~2310~9212 Fuels & Lubs 101-4-231 04217 Uniform Allowance 101-4-2310-9219 Operating Supplies TOTAL Supplies 2D2,7DD,DD 2D, 928,82 199,237,5D 71,16 58,462,50 9D,850.00 7,690.45 69,402.90 76,39 21,447,10 150,350.00 18,755.46 118,635,51 78,91 31,714,49 13,250.00 682.93 6,506.50 49.11 6,743.50 10,05D.00 1,152,D0 7,722,84 76,89 2,327,16 30,DDD.00 0.00 30,000.00 100.00 0.00 3,500,00 342,45 2,571,36 73.47 928.64 9,150.OD 386.94 5,615.25 61.37 3,539.75 15,350,00 4,561.OD 16,348,OD 1D6.50 t 998,00) 0,00 0.00 179,12 O.OD ~ 179,12) 322,5DD.DD 33,571.23 256,981.48 79,68 65,518.52 1,200,00 0.00 774,11 64.51 425.89 7,950.D0 885.13 4,38D.39 55,10 3,569,61 1,1DD.OD 223,99 2,236.63 203,33 ( 1,136,63) 32,40D.D0 462.20 23,517.62 72,59 8,882.38 42,65D,DD 1,571,32 30,908,75 72,97 11,791.25 11-12-2009 08:17 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT {UNAUDITED} AS OF. OCTOBER 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 83.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2310-9319 Other Professional Services 101~4~2310-9321 Telephone 101-4-231 09322 Postage 101-4-2310-4331 Travel, Conferences & Schools 1014-2310-9359 Publishing 101-4-2310M4361 Insurance 1D1-9-2310-4389 Utilities 1019-2310-9401 Bldg Repair/Maim Services 101-9~2310~4909 Equip Repair/Maim Services 101-4-2310M4933 Dues & Subscriptions 101-9-2310-496D Equip Replacement Charge TOTAL Other Services & Charges 9,950.00 D.00 2,872.64 58.03 2,077,36 2,70D.OD 184.92 2,166.39 80.23 533.66 500.00 0.00 217.59 43.52 282.91 19,850.00 2,051.98 5,193.69 26.16 14,656.31 500.00 O.OD 3D1.00 60.2D 199.00 21,300.OD 8,166.06 16,899.00 79.31 4,406.DD 15,150.00 342.98 9,57D.67 63.17 5,579.33 4,DDD.D0 907.61 3,992.96 98.57 57,09 2D, 850.00 ( 262.60} 20,883.92 100.16 ( 33.92) 2,000.00 65.00 1,790.50 87.03 259,50 15,250.00 769.2D 7,692.00 50.11 7,608.00 1D7,D5D.DD 12,219,09 71,425,31 66.72 35,629.69 TOTAL Fire Administration Fire Inspections Personal Services 101~4~2320-9101 Regular Pay 101-4-232D~9102 Overtzme Pay 101-4-2320-9103 Part-time Pay 10 19-232D-9104 PERA 101-4-232D-4105 FICA 101-4~2320~4107 Medicare 101-4-2320-4108 Insurance 101-4-2320-4110 Reemployment Compensation TOTAL Personal Services Supplies 101-4-2320~42Q1 Office Supplies 101-4-2320-4212 Fuels & Lubs 1Q1W4-2320-4217 Uniform Allowance 101~4M2320-4219 Operating Supplies TOTAL Supplies Dther Services & Charges 1014-2320-9321 Telephone 101~4~2320-4322 Postage 101-4-2320W4331 Travel, Conferences & Schools 101-4-2320-4359 Publishing 101-9-2320-4404 Equip Repair/Maim Services 1D1-9-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 472,200.D0 97,361.64 359,315.59 76.09 112,884.46 132,250.DQ 14,893.26 108,187.95 81.81 29,062.05 2,000.00 0.40 0.00 0.00 2,000.00 0.00 674.40 6,097.70 0.00 ~ 6,097.70 19,700.DD 1,233.02 11,674.38 79,92 3,025.62 7,600.OD 972.02 3,366.35 44.29 9,233.65 1,900.00 232,53 1,694.61 89.19 205,39 13,700.OD 1,078.OD 11,036.00 80.55 2,664.Q0 0.00 D.DO 369.42 O.D6 ( 364.42 172,150.00 18,533.23 142,421.41 82.73 29,728.59 1,950.00 17.29 34.37 1.76 1,915.63 3,000.00 154.01 1,762.73 58.76 1,237.27 840.D0 O.DO 239,78 29.97 56D.22 4,15D.DD 184.66 3,816.84 91.97 333.16 9,900.00 355.96 5,853.72 59.13 4,646.28 1,350.OD 82.00 888.D1 65,78 461,99 150.OD 0.00 O.QO D.DD 150.D0 2,750.00 0.00 35D.00 12.73 2,4DO.OD 200.00 0.00 0.00 D.00 200.00 1,850.00 0.00 293.35 13.15 1,606.65 6,800.00 82.00 1,551.36 22.81 5,248.64 TOTAL Fire Inspections 188,85D.D0 18,971.19 149,826.49 79.34 39,D23.51 11-12-2009 08;17 AM 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES PAGE; 16 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO QATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Emergency Management Personal Services 101-9-2330-4101 Regular Pay 101-4-2330-4104 PERA 101-4-2330-9107 Medicare 101-9-2330-4108 Insurance TOTAL Personal Services Supplies 101.4-2330-9201 OLfice Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2330-4321 Telephone 101-4-2330-4322 Postage 101--9--23304331 Travel, Conferences & Schools 101-4~-2330-4359 Publishing 101-4-2330-4389 Utilities 101-4-2330-4904 Equip Repair/Maim Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-233 04560 Equipment TOTAL Capital Outlay 9,950.DD 639.82 6,625,63 66.59 3,329,37 1,400,00 45,10 517,55 36,97 882,45 150.00 9.13 95.71. 63.81 54.29 800.0D 0.00 256.D4 32.D1 593.96 12,3D0.00 694.05 7,494,93 60.93 4,8D5.D7 2,500,00 D.DD D.00 0.00 2,50D.DD 8,500.00 D.OD 399.57 4,70 8,1D0.43 11,aoo.oa o.o0 399.57 3.63 1a,~oo.43 1,500.00 70,98 1,D61,30 70.75 438.70 100.00 o.ao o.oo o.o0 100.00 1,850.D0 0.00 255.60 13,82 1,594,90 5D0.0D 0,00 O.DD 0.00 500.00 1,5D0.0D 99,59 962.17 69.14 537.83 5,100.DD 72.78 3,217.86 63.10 1,882.14 900.00 O.OD 200.00 50,00 200.00 10,950.00 293.35 5,696.93 52.03 5,253.07 14,900.00 D.DO 0.00 0,00 14,900.00 14,900.00 0.00 0.00 D.00 19,900.00 TOTAL Emergency Management 49,15D.0D 937.40 13,591.43 27,65 35,558,57 Building Safety Personal Services 101-4-2910-9101 Regular Pay 375,30D.D0 36,609.81 318,799.84 84.95 56,500.16 101~-9~2410~--9102 Overtime Pay 500.00 0,00 0.00 0.00 500,00 101-4--241.0-4103 Part time Pay 23,450.00 3,017.53 20,795.67 88.68 2,654.33 101-4-2910-41D4 PERA 26,950.00 2,674.85 20,804,90 77.20 6,195.10 101-4-2910-4105 FICA 24,750,00 2,313,27 20,374.70 82.32 4,375.30 101-4-2910-9107 Medicare 5,800.00 541,00 9,765.00 82.16 1,035.OD 101--9--2910-91D8 Insurance 41, 600 , 00 3, 039 . D1 36, 066 , 07 $ 6.70 5, 533.93 101-~9--2910--9109 Workers Comp 1, 400. DO 274. DO 1, 261, 75 90.13 138, 25 101-4-2910-4110 Re--employment Compensation 29,350.DD 0.00 7,533.00 25.67 21,817,00 TOTAL Personal Services 529,100.00 48,464,97 43D,4D0.93 81.35 98,699.07 CITY OF ELK RTVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; OCTOBER 31ST, 20D9 11--12-2DO9 08;17 AM 1D1--GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES PAGE : 17 83.33°s OF YEAR COMP. CURRENT CURRENT YFAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-241 04201 O~~ice Supplle5 3,000.00 73.74 1,19$.35 39.95 1,801.65 101-9~-2410-4212 Fuels & Lubs 5,95D.00 926.65 2,489,15 91.$3 3,460.85 1D1-4-2410-4217 Uniform Allowance 700.00 253.98 263.4$ 37.64 436.52 101--4-2410--4219 Operating Supplies 2,b5D.D0 40.99 1,450.81 59.75 1,199.19 TOTAL Supplies 12,300.00 804.37 5,401,79 93.92 6,898.21 Other Services & Charges 101-~4--24104321 Telephone 6,9DD.OD 152.D4 2,D95.86 29.65 9,854.14 101-4-241.0-4322 Postage 1,5D0.04 0.00 195.99 13.07 1,304.01 101-4-291D-9331 Travel, Conferences & Schools 9,400.00 870.00 3,395.43 36.12 6,004.57 101-4-241D-9351 Insurance 16,500.00 419.50 14,933.00 90.50 1,557,00 101--9--241.0-4404 Equip Repair/Maim Services 9,400.DD 256.54 5,279,82 56.17 9,120.18 101-4-2410-4433 Dues & Subscriptions 1,200.D0 20.00 495.00 41.25 705.DD 101-4-2910-4460 Equip Replacement Charge 2,300.00 126.48 1,264.80 54.99 1,035.20 TOTAL Other Services & Charges 47,200.00 1,849.56 27,609.90 58.50 19,590.10 TOTAL Building Safety Environmental Personal Services 101.9-~2940--91D1 Regular Pay 101-4-2440-4109 PERA 1D1-4-2490-9105 FICA 101-4-2490-4107 Medicare 101--4-299 D-~41D8 Insurance 101--4--2490--4109 Workers Camp TOTAL Personal Services Supplies 101-9-2440-4201 Office Supplies 101.4.2940-4212 Fuels & Lubs 101-4-2440-4217 Uniform Allowance TOTAL Supplies Other Services & Charges 101-4-2940-4321 Telephone 141-4-2440-9322 Postage 101-4-2490-4331 Travel, Conferences & Schools 101-9-2440-4359 Publishing 101-4-2990-4361 Insurance 101--9--2490-9909 Equip Repair/Maim Services 101-~4--29AQ--9409 Contractual Services 101-9-2440-9433 Dues & Subscriptions 101-4-2440-9460 Equip Replacement Charge TOTAL Other Services & Charges CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: OCTOBER 31ST, 2009 588,500.00 51,113.40 963,912.62 78.73 125,1$7.38 52,200.00 6,050.73 42,495.77 81.41 9,703,23 3,500.00 408.92 2,985.82 85.31 519.18 3,200.OD 308.17 2,D74.77 54.84 1,125.23 750.00 72.09 485.33 54.71 264.67 8,450.00 659.60 b,747.20 79.85 1,702.80 350.00 95,00 389.00 111.14 ( 39.00} 68,45D.DD 7,604.D1 55,178.89 SD.61 13,271.11 650.00 0.00 4b2.23 71.11 187.77 20D.D0 21.84 98.13 24.07 151.87 200,00 O.DD D.OD D.OD 200.00 1,050.00 21,89 510.35 98.61 539.64 70D.DD 97.32 421.66 60.24 278.34 SDD.DO D.DD 35D.66 70.13 149,34 5DD.p0 150.DD 599.57 118.91 ~ 94.57} 5D0.00 0.00 0.00 0.00 500.00 300.D0 93.50 205.50 68.50 94.50 SD.oo o.DO o.oo D.DD So.Do 1,500.OD 0.00 259.80 16.99 1,245.20 1,D50.OD O.DD O.DD O.DO 1,05D.D0 750.OD 36.74 367.40 98.99 382.6D 5,85D.DD 327.56 2,199.59 37.51 3,&55.41 11-12-2009 08:17 AM CITY OF ELK RIVER PAGE; 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2009 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDrTURES 83.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Environmental 75,35D.00 7,953.91 57,883.84 76.82 17,466.16 TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-91D2 Overti€~e Pay 101--43120-9103 Part-time Pay 1D1-4-312 09104 PERA 101-4-3120-9105 FICA 101--4-3120-9107 Medicare 101--4--3120-4108 Tnsurance 101-4-312 0-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3120--4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-4-3120-4219 Operating Supplies 101-~4~3120-4226 Street Signs TOTAL Supplies Other Services & Changes 101-4-3120-4319 Other Professional Services 1014--3120-9321 Telephone 101-4-3120--4322 Postage 101-4-3120--9331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Tnsurance 101-4--3120-4389 Utilities 101-4-3120--4901 Bldg Repair/Maim Services 1D1-9-3120-4404 Equip Repair/Maim Services 101-4-3120-4409 Contractual Services 101--43120-4415 Equipment Rental 141-4--3120-9417 Uniform Rental 101-4-3120--4433 Dues & Subscriptions 101-4-3120w9437 Taxes & Licenses 101-4-3120-4460 Equip Replacement Charge TOTAL Other Services & Charges 5, 586,3DD.00 55D,338.33 4,17D,396.82 74.65 1,415,903.1$ 391,850.D0 60,647.79 386,475.59 98.63 5,374.41 1D,4DD.00 O.OD D.DO D.00 10,40D.D0 78,950.OD 5,288.37 55,8D6.D6 70.69 23,143,94 31,050.D0 4,450.64 29,187.55 94.00 1,862.45 28,750.D0 9,029.17 26,285.40 91.43 2,463.60 6,70D.00 941.12 6,147.39 91,75 552.61 5D,400.00 5,763,7$ 51,928,$9 103.03 ( 1,528.89a 20,000.00 5,652.50 20,420.75 102.10 ( 420.75) 618,100.00 86,76$,37 576,252.63 93.23 41,$47.37 4,800.00 144.34 1,775.36 35.99 3,024.64 82,950.00 10,0$$.15 46,D02.63 55.46 36,947.37 149,OOO.D0 27,733.54 101,909.49 6$,40 47,090.51 32,50D.00 8,853.59 30,558.40 94.03 1,941.60 269,250.00 46,819.62 180,245.88 66.94 89,004.12 950.00 0.00 920.96 44.26 529.54 9,450.00 420.21 3,766.11 39.85 5,683.89 200.00 D.00 61.83 30.92 13$.17 3,000.00 175.00 2,248.87 74.96 751.13 5D0.00 0.00 82.50 16.50 417.50 18,250.00 8,003.OD 15,966.50 87.49 2,283.50 33,ODD.00 2,758.$0 28,035.79 $4.96 4,964.21 6,500.00 1,535.00 3,113.08 97.89 3,385.92 0.00 O.OD 2,240.59 D.00 { 2,240.59) 195,DDD.DD 4,315.67 155,995.46 $0.00 39,OD4.59 3,500.00 96.19 1,6D8.77 45.96 1,891.23 4,850.D0 56.44 2,057,16 42.42 2,792.$4 700.00 O.OD 241.25 34.46 458,75 500.00 9.5D 9.50 1.90 490.50 13D,2DO.D0 6,517.73 65,177.30 50.D6 65,022.70 406,6DD.OD 23,897.54 281,025.17 69.12 125,574.83 11-12-2009 08;17 AM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES CrTY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; OCTOBER 31ST, 2009 PAGE; 19 83.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-3120--9560 Equipment 6,700.00 0.00 6,127.19 91.45 572.81 TOTAL Capital Outlay 6,700.00 0.00 6,127.19 91.45 572.81 TOTAL Street Maintenance Snow Removal Personal Services 101-9-3134-4101 Regular Pay 101--4--3130-4102 Qvertime Pay 141-4-3130-4109 PERA 101-4-3130-91D5 FICA 101-4-3130--4107 Medicare 101-4--3130-4108 Insurance 101-4-3130-9109 Workers Comp TOTAL Personal Services Supplies 1.01-4-3130-4219 Operating Supplies TOTAL Supplies Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 1,30D,650.OD 157,985,53 1,043,650.87 80.29 256,999.13 159,150.00 113.99 51,234.99 32.19 107,915.01 12,450.00 O.DO 401.74 3.23 12,048.26 11,800.D0 7.69 9,851.37 41.11 6,948.63 10,950.00 7,00 9,210.11 38.45 6,739.89 2,550.00 1.&9 984.61. 38.61 1,565.39 21,300,00 0.40 8,908.07 41.82 12,391.93 6,55D.D0 1,603.25 6,773,75 103.92 ( 223.75} 229,750.00 1,733.57 77,364,64 34.42 147,385.36 79,OOD.00 57.71 73,265.76 92.79 5,734.24 79,OOO.DO 57.71 73,265.76 92.74 5,734.24 5,OOO.DO 0,00 1,200.00 24.OD 3,800.00 5,DOO.OD 0.00 1,20D.00 29.00 3,800.00 TOTAL Snow Removal Equipment Services Personal Services 1D1-4-3150-4101 Regular Pay 101-9-3150-4102 Overtime Pay 141-4-315D-41D9 PERA 101--4- 3154--9105 FICA 1D1--4--3150-4107 Medicare iD1-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services 308,750,00 1,791.28 151,830.40 49.18 156,919.60 165,200.OD 18,552.D3 129,674.73 78.50 35,525.27 2,5D0.40 D.00 D.OD 4.00 2,500.00 11,30D.D0 1,252.26 8,981.50 79.48 2,318.54 1D,400.40 1,068,79 7,353.73 70.71 3,046.27 2,450.00 249.96 1,719.89 70.20 730.11 23,000.00 1,718,02 17,999.87 78.26 5,DD0.13 5,250.OD 1,594.50 5,860.5D 111,63 ~ 61D.50} 220,1DD.00 24,435.56 171,59D.22 77,96 48,509.78 11-1z-20D9 Ds;17 AM 101-GENERAL FUND Public W arks I]EPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT {UNAUDITED} AS OF; OCTOBER 31ST, 2009 PAGE; 20 83,33a OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-3150-4219 Operating Supplies 16,350,00 1014--3150-4221 Equipment Parts 9, 200 , 00 TOTAL Supplies 25,550.00 Other Services & Charges 101-4-3150-9909 Equip Repair/Maim Services 2,DO0,o0 101-4-3150-9417 Uniform Rental 2,800,00 TOTAL Dther Services & Charges 4,800.OD 888.51 11,093.92 67.85 5,256.08 D.OD 431,42 4,69 8,768.58 888,51 11,525,34 95.11 19,024.b6 0,00 788.03 39.90 1,211.97 228,30 2,262.03 80,79 537,97 228,30 3,050,06 63.54 1,749.94 TOTAL Equipment Services 250,450.00 25,552.37 186,165.62 79,33 64,289.38 Engineering Personal Services 101-4-3300-4101 Regular Pay 49,500.00 O,DO 0.00 0.00 99,500.00 101-4-3300-4104 PERA 3,35D.00 0,00 0,00 O,DD 3,350,00 101-4-3300-9105 FICA 3,05D.00 0.00 O.DD O.OD 3,D50.00 101--4--3300-4107 Medicare 700,00 0.00 D.00 0,00 700.00 101-4--3300--4108 Insurance 7,700.00 D,OD 0.00 0,00 7,700.00 101-4-3300-9109 Workers Comp 100,00 105.25 232.00 232.00 { 132.DD) TOTAL Personal Services 64,4D0,00 105,25 232.OD 0,36 64,168,00 Supplies 101-4-3300-4201 Office Supplies 85D.00 0.00 207,57 24.92 692.43 101-9-3300-4212 Fuels & Lubs 350,D0 D.OD 76,D8 21,74 273.92 101-9-3300-4219 Operating Supplies 6,350.00 4,322,54 6,145.93 96.79 204.07 TOTAL Supplies 7,550,00 4,322,5D 6,429,58 85.16 1,120.42 Other Services & Charges 101-9-3300-4303 Engineering Fees $6,5DD.D0 4,305,39 51,469,60 59.50 35,030.90 1D1-4-330D-4319 Other Professional Services 3D,ODD.00 0.00 10,DOO.D0 33.33 20,D00,00 101--9~-33OD--4321 Telephone 750,00 0.00 8,26 1,10 741,74 101-4~-3300--4322 Postage 200.DO D.DD 24,60 12.30 175.90 101-9-3300-4331 'gavel, Conferences & Schools 200,00 0.00 60,OD 30,D0 140.D0 101-4-3300-9361 Insurance 300,DD 93,50 205,50 58.50 94.50 101-4-3300-9404 Equip Repair/Maim Services 500,00 0,00 905,20 $1,04 94,80 101--4--330 04460 Equip Replacement Charge 750.00 36.74 367.90 98.99 382,60 TDTAL Other Services & Charges 119,200,00 9,935.63 62,540.56 52,47 56,659,94 TOTAL Engineering 191,15D.D0 8,863.38 69,202,14 36.20 121,947.86 TOTAL Public Works 2,051,OOO,D0 193,692,56 1,450,899,03 70,74 600,150,97 11-12-2DO9 08:17 AM CITY DF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT {UNAUDITED) AS O~; OCTOBER 31ST, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 83.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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-9104 PERA 1D1-4-5110-9105 FICA 101--4--511.0--4107 Medicare 101-4-5110-9108 Insurance 101-4-5110-4109 Workers Comp 1D1-4-5110-411D Re-employment Compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-9--5110--4217 Uniform Allowance 101-4-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5110--4321 Telephone 101-9-5114-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4--51104389 Utllltie5 101-4-5110--4401 Bldg Repair/Maim Services 101-4-5110-9904 Equip Repair/Maim Services 101-4-511D-9409 Contractual Services 101-4-5110-9415 Equipment Rental 101--4--511D~-9460 Equip Replacement Charge TOTAL Other Services & Charges 338,150.00 41,207,40 282,336,87 83.99 55,813.13 1, 000.00 0 . DO D . o0 0 . DO 1, oao . o0 43,350,00 5,174,13 37,895.51 87.42 5,454.49 23,$50,00 2,949.66 20,215.25 89.76 3,639.75 24,150.00 2,828.28 18,915.04 78,32 5,234,96 5,650.D0 661,94 4,423.59 78,29 1,226.41 51,20D.D0 3,892,02 36,429,91 71,14 14,775.09 6,500,00 2,029,00 7,807,00 120.11 ( 1,307,OD} 0.00 0,00 737.92 D.00 ( 737,92) 493,850.00 5$,741.93 408,756.09 $2.77 85,093.91 31,350.00 4,839.42 17,928.78 57.19 13,421,22 3,200.00 142,57 2,170.54 &7,83 1,029.46 68,550,DD 5,832,79 62,897,57 91,75 5,652.43 103,100,00 10,814.78 82,996.89 80,50 20,103.11 3,90D.OD 392.71 3,364,98 86,28 535.02 2,550.00 152,38 2,627,97 103.06 ~ 77.97} 27,000.00 12,472,50 24,282.50 89.94 2,717,50 15,050.00 7,656.33 27,966.26 185,82 { 12,916.26} 5,50D.00 O.DD 232,5D 4,23 5,267,50 13,500.OD 2,274.69 12,769.39 94,59 730.61 6,100,00 610.92 14,075.14 230.74 ( 7,975,14) 29,500.00 1,601.78 12,773.54 52,14 11,726.96 38,100,00 1,837.8& 18,378.60 48,24 19,721,40 136,200,00 26,999,17 116,47D.88 85.51 19,729,12 TOTAL Parks Department Parks & Rec Admin Personal Services 101-4-5210--4101 Regular Pay 101-4-5210-4102 Overtime Pay 1D1-4-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-521D-4105 FICA 101--4--521D-4107 Medicare 101--4--521D--4108 Insurance 101--4--5210--4109 Workers Comp TOTAL Personal Services 733,150.D0 96,555,88 6D8,223.86 82.96 7.24,926.14 335,550,00 38,183,58 263,671,18 78,58 71,878,82 7DO.D0 0,00 D,DD D.00 700.OD 21,150.D0 2,4D6.00 20,809.10 98.36 395,9D 24,15D.00 2,739,83 19,852.94 82.21 4,297,06 22,2D0.00 2,445,42 17,43D.65 78.52 4,769.35 5,200.00 571,88 4,076.34 78,39 1,123,66 39,85D.00 2,788,56 29,976,90 75.22 9,873.10 4,950.00 844,75 3,223,00 65.11 1,727,00 453,750.00 49,980,02 359,035.11 79,13 94,714,89 11-12-2009 08:17 AM CITY OF EL[< RxVER PAGE; 22 REVENUE & EXPENSE REPORT (UNAUDITEQ) AS OF; OCTOBER 31ST, 20D9 101-GENERAL FUNQ Culture & Recreation DEPARTMENTAL EXPENDITURES $3,33% OE YEAR CAMP, CURRENT CURRENT YEAR TO DATE °s OE BUDGET BUDGET PERIOD ACTUAL BUDGET BAT~ANCE Supplies 101-4-5210-9219 Operating Supplies 12,900,00 999.D9 10,224.39 79,26 2,675,66 TOTAL Supplies 12,900,00 999.09 10,224,34 79.26 2,675,66 Other Services & Charges 101-4-5210-4321 Telephone 4,100.00 279.6D 2,775,19 67,69 1,324,81 101-4-5210-4322 Postage 6,DOO.DD 50.60 2,970.19 49.50 3,029.81 1D1-9-5210-4331 Travel, Conferences & Schools 5,650.00 386.69 2,693,11 51.21 2,756.89 101-4-5210-4349 Advertising/Marketing 26,400.00 D.00 16,784,21 63.58 9,615,79 101~4~521D~4361 Insurance 1,500.D0 681,50 1,395.50 93.03 104.50 101-4-5210-4389 Utilities 7x$OO.DO 309,99 7,833.23 1DD.43 ( 33.23) 101-4-5210-4401 Bldg Repair/Maim Services 14,950,00 1,051.75 10,286.98 68.81 4,663.02 101-4-521D-4404 Equip Repair/Maim Services 6,750.00 240.47 5,573.9D $2,57 1,176.60 101~4~5210~9433 Dues & Subscriptions 1,650.00 D.DD 1,310.00 79,39 340.00 TOTAL Other Services & Charges 74,8DD.00 3,000,60 51,821,81 69,28 22,978.19 TOTAL Pars & Rec Admin 541,450.00 53,979,71 921,081,26 77,77 120,368.74 Recreation Programs Personal Services 101-4-5220-4101 Regular Pay D.DO 778.90 1,973.97 D.DD ( 1,973.97) 1D1-4-5220-4102 Overtime Pay 0,00 0,00 24,00 4.00 ( 24,00) 101~4W522D-4103 Part-time Pay 80,000.00 9,091,14 76,559.92 95,69 3,445,08 101-4~5220M4109 PERA 1,600.00 424.49 1,92$,09 120,51 ( 328.09) 101-9-5220-4105 FIGA 4,5DD.00 616.46 9,963.52 11D.30 ~ 463.52) 101-4-5220-9107 Medicare 1,30D.00 144,20 1,161.00 89.31 139.OD TOTAL Personal Services 87,400.00 11,059.79 $6,605,50 99.D9 794,50 Supplies 101-4-5220-9219 Operating Supplies 27,5DO.DD 3x742,97 26,005.08 94,56 1,499.92 TOTAL Supplies 27,5DD.40 3x742,97 26,DD5.D8 94.56 1,499,92 Other Services & Charges 101-4-522 04404 Equip Repair/Maim Services 400,00 O,4D 480,10 12D.03 ( 80.10f 101-9-5220-9409 Contractual Services 57x5D0.DD 3,295,77 61,675,94 107,26 ( 4,175.94` 101-9-5220-4912 Building Rent 2,540,00 0.00 3,288,D0 131,52 ( 788,44) 10 19-52.20-4938 Credit Card Fees 3,000,00 239,34 3x824.52 127,48 ( 824,52) TOTAL Other Services ~ Charges 63,400.00 3,535.11 69,268.56 109,26 ( 5,86$,56) TOTAL Recreation Programs 178,3D0.40 18,332,87 181,879.19 102.01 ~ 3,579.14) 11-12-2009 D8:17 AM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES PAGE: 23 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Concessions Personal Services 101-4-5230-9103 Part time Pay 4,750.00 "_01-4-5230-9109 PERA 250.00 101--4--52309105 FICA 300,00 101-4-5230-9107 Medicare 100.00 TOTAL Person al. Services 5,900.00 Supplies 101-4-5230-4219 Operating Supplies 600.D0 101-9-5230-9259 Other Merchandise For Resale 13,900.00 TOTAL Suppli es 19,000.00 Other Services & Charges 101-9-5230-4901 Bldg Repair/Maint Services 100.00 TOTAL Other Services & Charges 1.00.00 199.88 4,020.99 89,65 729.06 2.01 39.86 15.94 210,14 1.2,08 257.37 $5.79 42,63 2,83 60.16 60.16 39,84 211.8D 4,378.33 81.08 1,021,67 0.00 35.04 5.84 569.96 668.08 6,246.16 46.61 7,153.84 668.48 6,281.20 49.87 7,71$.80 0.00 79,88 79,88 20.12 TOTAL Concessions Sr Citizen Programs Personal Services 101-~9--5510--4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-551.0-4103 Part--time Pay 101-4-5510-4109 PERA 10 1.9-5510-4105 FTCA 101--9~-5510-4107 Medicare 101-4-~551.0~43.08 Insurance ?01-4-5510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-551 04219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4--5510--9321 Telephone 101-4--55109322 Postage 101-4-5510-9331. Travel, Conferences & Schools 101-4-5510-4359 Publishing 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-9-5510-4401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services CTTY OF ELK RTVER REVENUE & EXPENSE REPORT {UNAUDITED) AS OF: OCTOBER 31ST, 2009 19,500.00 879.88 10,739.41 55.07 8,760.59 54,950.00 5,51.9,59 44,117,68 80,29 10,832.32 500.00 0.00 0.00 0.00 500,00 58,700.00 6,661.33 47,279,86 80,54 11.,920,19 7,700.00 889.70 6,389.01 82,91 1,315.99 7,100.00 778,71 5,488.19 77,30 1,611,81 1,650.00 1$2,12 1,283,60 77,79 3&6,40 12,900.00 1,034,22 10,342,20 83.90 2,057.80 700.00 108.75 387,75 55.39 31.2,25 193,7DD,DD 15,174.42 115,283,29 80.22 28,916,71 10,950.00 1,290.77 8,637.38 78.$8 2,312.62 10,950.00 1,290.77 8,637,38 78.88 2,312,62 2,900,00 207.67 2,066.72 86.11 333.2$ 4, 000.00 8.1.4 1, 664 , 38 41..61 2, 335.62 2,400.00 160,42 1,550,65 64,61 849.34 a.oa 42,a0 92,00 o.ao { 4z.DO~ 904.D0 771,50 1,547,00 171,89 { 647.00} 8,15D,00 803.13 7,130.94 87,50 1,019.06 11,800,D0 977.24 9,566.05 81.D7 2,233.95 8,100.D0 180.00 4,565.29 56.36 3,534.71 11-12-2009 08;17 AM 1.01-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RxVER REVENUE & EXPENSE REPORT {UNAUDITED} AS OF; OCTOBER 31ST, 2009 PAGE; 24 83.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5510-9433 Dues & Subscriptions TOTAL Other Services & Charges 950.00 38,7DD.00 0.00 3,150.10 519,31 28,652,35 54.66 74.04 430.69 10,D47.65 TOTAL Sr Citizen Programs 193,350.00 20,615,29 152,573,02 78.91 40,776,98 TOTAL Culture & Recreation 1,665,75D,D0 190,363,63 1,374,496.59 82.52 291,253.31 Economic Development Personal Services 101-4-621D-4141 Regular Pay 0.00 15,35&.10 25,593,5D 0.00 ( 25,593.50E 101-4-6210-91D3 Part-time Pay 0.00 1,D50.32 2,100,64 0.00 ~ 2,100,64E 101--4--621.09104 PERA D . DO 1, 059, 05 1, 772 , 59 O . oo { 1, 772 , 59 ` 101-4-621.0-9105 FICA 0.00 972.03 1,625.82 D.00 { 1,625.82) 101-4-6210-9107 Medicare 0.00 227.35 380.27 D.DD { 380.27) 101-4-6210-41D8 Insurance D.OD 876.00 1,752,00 0.00 [ 1,752,00} 101--4--621.04109 Workers Comp O.OD 165.75 165.75 0.00 ( 165.75} TOTAL Personal Services 0.00 19,706.60 33,390.57 0.00 ( 33,390,57) Other Services & Charges 101W4~-6210~4361 Insurance O.DD 1,712.00 1,712,00 D.00 ( 1,712,00} 101-4-62104940 Miscellaneous 0.00 ( 48.35) O.OD O.DO 0.00 TOTAL Other Services & Charges 0.00 1,663.65 1,712.00 0,00 { 1,712.OD} TOTAL Economic Development 0.00 21,370.25 35,102,57 0.00 ( 35,102.57 Energy City Personal Services 101-4-622 04101 Regular Pay 27,250.OD 3,130,05 22,179,82 $1.39 5,070.18 1D1-4-6220-9104 PERA 1,550.00 211.26 1,545.41 99,70 4,59 101-4-6220-41D5 FTCA 1,500.00 162.61 1,108.48 73.90 391.52 1D1--4--6220-~41D7 Medicare 400.OD 38,03 259,24 64.81 140.76 101-4-6220-4108 Insurance 3,600,00 300.01 2,974,49 82.62 625.51 TOTAL Personal Services 34,300.00 3,891,96 28,D67,49 81.83 6,232.56 Other Services & Charges 101--4--6220-4319 Other Professional Services 2,D00.00 6,99 206.99 10.35 1,793.01 101--4--622Oµ4331 Travel, Conferences & Schools 17,DOD,DO 203.58 { 1,930,59} 11.36w 1$,930.59 101-4-622 0-4359 Publishing 2,50D.00 83.95 2,759.09 11D.36 { 259.09) TOTAL Other Services & Charges 21,500,D0 294.52 1,D35.49 4.82 20,469,51 TOTAL Energy City 55,800,00 4,136.48 29,102,93 52,16 26,697.07 TOTAL Economic Development 55,800.00 25,505,73 69,2D5,50 115,06 { 8,4D5.5O) 11-12-2009 08;17 AM CITY OF ELK RIVER PAGE; 25 REVENUE & EXPENSE REPORT ~UNAUDITED~ AS OE; OCTOBER 31ST, 2009 101-GENERAL FUND General DEPARTMENTAL EXPENDITURES $3.33°s OF YEAR COMP, CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Transfers Out Transfers Out 101-4-70D0--4723 Transfer--rce Arena 101-4-70D0-4724 Transfer - Pinewood 1D1-~9-7000-4730 Transfer-Debt Serva.ce TOTAL Transfers Out 100,400,00 0.00 O.OD 0.00 100,4DD.00 62,30D.DD O.DD 0.00 0.00 62,300.0D 66,600.0D O.DO 66,60D.DD 1DO.00 0.00 229,300.00 0.00 &6,600.00 29.04 162,7D0.0D TOTAL Transfers Out 229, 300 . o0 0 , ao 66, 600 , 00 29 . D9 162, 7Da . 00 TOTAL General 229,300.00 0.00 66,600.00 29,04 162,700.00 TOTAL EXPENDITURES 1212211550.00 1,233,492.69 9,092,648.07 73.99 3, 178,9D1.93 REVENUES OVER/[UNDER) EXPENDITURES 428155D.00 { 799,794.82)( 2,2101265.10} 2,6381815.10 11-12-2009 08;17 AM CITY OF ELK RIVER PAGE, 1 REVENUE & EXPENSE REPORT UNAUDITED} AS OF: OCTOBER 31ST, 2D09 221-ICE ARENA FINANCIAL SUMMARY 83.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 735,000.00 33,509.29 2$7,385.95 39.10 947,614,05 Hockey 70,000.00 0,00 52,367.00 74,81 17,633.00 Skating 84,700.00 1.,069.54 59,359.10 70,0$ 25,340,90 Concessions 73,000.00 9,151.12 38,219.77 52.36 34,78x.23 TOTAL REVENUES 962,700.00 38,724.91 937,331.82 95.43 525,368.18 EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAI, Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER} EXPENDI"I'URES 897,900.00 56,617,01 417,508.62 49,29 430,391.38 30,150,00 653,95 23,137,35 76.74 7,012.65 39,450,00 1,589.09 19,495.02 56.59 14,954,98 50,200.00 5,289.94 21,808.98 93,94 28,391.02 962,700.00 64,199,49 981,949.97 50,06 980,750.03 962,700.00 64,194.49 481,999.97 50.06 48O,750.D3 0.00 ( 25,419.58}t 44,618.1.5) 99,618.15 11-12-2009 08;17 AM CITY OF ELK RIVER PAGE; 2 REVENUE & EXPENSE REPORT (UNAUDITED} A5 OF; OCTOBER 31ST, 2009 221-TCE ARENA REVENUES $3,33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Tce Arena Charges for Services 221-3-0000-3969 Tce Rental 221~3~OOD0~3465 Admissions 221-3-DODO-3966 Dry F1aar Events 221-3-000D-3968 Skate Sharpening 2213-OD00-3975 Building Rent 221~3~ODOOM39$2 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 Tn 221-3-0000-3921 Transfers 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Ice Arena hockey Charges for Services 221M3~5410~3961 Recreation Fees TOTAL Charges far Services Other Revenue 221~3~5410-3626 Contributions TOTAL Other Revenue TOTAL Hockey Skating 932,000,00 21,567,47 232,879.20 53.91 199,120.80 33,000,00 0.00 12,175,14 36.89 20,824.86 15,000,00 173.13 13,911,21 92.74 1,088.79 9,500.00 390.00 3,345.00 74,33 1,155.00 2,600.00 2,60D.00 2,600.00 100.00 0.00 18,500.00 0.00 ( 85.007 0.96- 18,585.00 505,600.00 24,730,60 269,825,55 52.36 290,774.45 22,000.00 1,667.70 11,040,06 50.18 10,959.94 0,00 0.00 3,443.00 0.00 ~ 3,993.00} 2,000.00 194.99 1,116.34 55,82 883.66 24,000.OD 1,812.69 15,599.9D 65.00 8,900.60 100,000.00 6,961.00 6,961.00 6.96 93,039.00 105,400.00 0.00 0.00 0.00 105,400.00 205,900.00 6,961.00 6,961.00 3.39 198,939.00 735,000,00 33,509,29 287,385.95 39.10 447,614,05 70,000.00 0.00 50,867.00 72.67 19,133,00 70,000,00 0.00 50,$67,00 72.67 19,133.00 0.00 0.00 1,500,00 0.00 ( 1,500.00} 0.00 0,00 1,500.00 0,00 t 1,500.00} 70,000,00 0.00 52,367,00 74,81 17,633.00 11W12-2009 0$:17 AM CITY OE ELK RIVER PAGE; 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; OCTOBER 31ST, 2D09 221-ICE ARENA REVENUES 83,330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Charges for Services 221-3-5420-3461 Recreation Fees 221~3~5420~3465 Admissions TOTAL Charges for Services Other Revenue 221-3-5420-3629 Miscellaneous Revenue TOTAL Other Revenue TOTAL Skating Concessions Charges far Services 221M3~5930~3467 Concessions TOTAL Charges far Services TOTAL Concessions 84,7DO.OD 1,D69.54 53,864.70 63,59 30,835.30 D.00 0.00 3,734.40 0.00 ( 3,739,00) 84,700.D0 1,069,50 57,598,70 68.00 27,141.3D 0.00 0.00 1,7b0.40 D.00 ( 1,760.40) O.DO O.DD 1,760.40 0.00 ( 1,76D.40) 89,7D0.00 1,Db9.50 59,359.10 70,08 25,390,90 73,040,00 4,151,12 3$,219,77 52.36 39,7$0.23 73,400.40 4,151.12 38,219.77 52.3b 34,784,23 73,DD4.D0 4,151,12 38,219,77 52.36 34,784.23 TOTAL REVENUE 9b2,700.00 38,724,91 937,331.82 45.93 525,368.18 11M12-2DD9 D8:17 AM CITY OF ELK RIVER PAGE; 9 REVENUE & EXPENSE REPORT (UNAUDITED A5 OF; OCTOBER 31ST, 2009 221~ICE ARENA DEPARTMENTAL EXPENDITURES $3.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE p OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4~544D~4101 Regular Pay 221-4-5400-4102 Overtime Pay 2214-5400-4103 Part-time Pay 221-9W59pD-4109 PERA 221-4-59009105 FICA 221-4-5400-4107 Medicare 2214-5400-4108 insurance 221-95900-4109 Workers Comp TOTAL Personal Services Supplies ?_21-45900-4212 Fuels & Lubs 221-4-540 04217 Uniform Allowance 221-4-5400-4219 Operating Supplies 2219-5400-4255 Soft Drinks/Mist 221~9~59DD-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221~9~5400-9321 Telephone 221-4µ5900W9322 Postage 221-4-540079331 Travel, Conferences & Schools 221-4-5400-4359 Publishing ?_214-5400-4361 Insurance 221~9~5400-9389 Utilities 221-4M5444~9401 Bldg Repair/Maim Services 221-4-540 09409 Contractual Services 221-4-5400-4415 Equipment Rental 2214-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-4-5400-4520 Buildings & Structures TOTAL Capital Outlay Transfers Out 221-4-540 09730 Transfer-Debt Service TOTAL Transfers Out 150,300.00 15,797,87 119,237.91 79.33 31,062.59 O.DD D.OD 6.38 D.OD ( 6.38} 72,850.D0 8,829.97 50,263.31 69.00 22,586.69 11,350.00 1,448.63 11,161.65 9$.34 188.35 14,150.00 1,538.01 10,854.96 76.71 3,295.54 3,3DO,DD 359.72 2,538.55 76.93 751.45 16,600.00 1,078.02 13,040.82 78.56 3,559.18 4,350.00 1,249.00 9,598,50 105.71 ( 248.50) 272,900.00 30,301.22 211,701,08 77.57 &1,198.92 300,00 25.39 ( 177,54y 59.18- 977.54 1,500.00 0.00 427.85 28,52 1,072.15 91,1oo.oa 2,509.13 25,963,99 63.17 15,136,01 13,500.00 ( 663.50] 3,74$.33 27,77 9,751.67 1,200.00 241.28 463,13 38.59 736.87 57,600.00 2,112.20 30,425,76 52.82 27,179.24 2,900.00 248.87 1,969.40 67.91 930.60 500.00 8.56 117.1D 23.42 382,90 1,05D.00 0.00 258.52 29.62 791,98 2,ODD.OD 458,75 2,946,49 147,32 ( 946,99) 9,DDD.00 3,949,5D 7,992.OD $8.$0 1,008.00 175,850.00 10,692,28 111,310,32 63.30 69,539.68 26,70D.00 8,883.38 21,953.58 62.22 9,746,42 2,D00.00 7,25 1,768,36 88.42 231.64 5,400.00 0.00 2,653.51 49,14 2,746.49 45D.DD 0.00 187,50 41,67 262.50 225,850.00 24,243.59 151,156.78 66.93 79,693.22 93,45D,D0 D.00 93,05D.OD 0.00 0,00 O.D4 93,050.00 0,00 0.00 93,050.00 198,50D.00 O.DO 24,225.00 12,20 174,275.00 19$,50D,DD O.DO 24!225.00 12.2D 174,275,00 TOTAL Ice Arena $47,90D.DD 56,617.01 917,508.62 49.24 430,391.38 11-12-2ao9 Ds;17 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2009 PAGE: 5 83.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-541D-9103 Part-time Pay 3,600.D0 60D.66 2,570.65 71.41 1,029.34 221-4-5410--9105 FICA 200.D0 37,24 159.39 79.70 40.61 221-4--5410-9107 Medicare 50.00 8.71 37.28 74.56 12.72 TOTAL Personal Services 3,85D.DD 646,61 2,767,33 71.88 1,082.67 Supplies 221-4-5410-9219 Operating Supplies 14,854.OD O.DO 12,697.78 85.51 2,152.22 TOTAL Supplies 14,854.00 D.OD 12,697.78 85,51 2,152,22 Other Services & Charges 221-4-5414-4322 Postage 500.DD 0.00 D.DD O.OD 5pD.D0 221-4-541D-4359 Publishing 1,7DO.DD 0.00 0,00 0.04 1,700.00 221-4--541D-99D9 Contractual Services 7,D5D.00 0.00 5,671,20 80.94 1,378.80 221--4--5910.9938 Credit Card Fees 2, 200.OD 6.84 2, 001. D4 90.96 198.96 TOTAL Other Services & Charges 11,450.00 b.84 7,672.24 67.01 3,777.76 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-9-5420-41D4 PERA 221-9-5920--4105 FICA 221--9w5424M4107 Medicare TOTAL Personal Services Supplies 221-~4~-5420-~4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-542D-4322 Postage 221~4~592D~4359 Publishing 221-~4-5920-4409 Contractual Services 221-4-542D-4438 Credit Card Fees TOTAL Other Services & Charges 3D,15D.00 653.45 23,137.35 76.74 7,412.65 20,000.00 1,269.1D 10,893.21 59.47 9,106.79 5DD.DD 31.19 490.99 98.10 9.51 1,250.00 78.69 692.47 55.90 557.53 30D.DD 18.4D 161.93 53.98 138.07 22,050.00 1,397.38 12,238.10 55.50 9,811.90 6,DDO.DD D.DO 3,407,71 56.8D 2,592.29 6,000,00 0.00 3,407.71 5b.80 2,592,29 20D.D0 D.00 D.DO O.OD 200.00 1,30D.DD 4.40 358.91 27.61 941.D9 2,950.00 0.00 1,87D.98 76.37 579.02 2,45D.OD 191.71 1,619.32 66.D9 834.68 6,4DD.DD 191.71 3,849.21 60.19 2!550.79 TOTAL Skating 34,95D.DD 1,589.09 19,995.02 56.59 1.4,959.98 11-12-2009 08;17 AM CITY OF ELK RIMER PAGE; 6 REVENUE & EXPENSE REPORT (UNAUDITED} AS OF; OCTOBER 31ST, 2009 221-TCE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES 83.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAI, BUDGET BALANCE Arena Concessions Personal Services 221-9-5930-9103 Part-time Pay 221-4--59309109 PERA 221-9-5930-4105 FICA 221-4-5930-4107 Medicare TOTAL Personal Services Supplies 221-9-5930-9219 Operating Supplies 221--4--5930--9259 Other Merchandise ~'or Resale TOTAL Supplies 20,900.00 2,977,39 9,936.66 45.15 11,963,34 0.00 63.37 252.98 D.00 ( 252.98) 1,3D0.00 153,59 605.93 46.57 699.57 30D.00 35.92 191.59 97.20 158.41 22,500.00 2,730.22 10,936.16 96.38 12,063.84 6,700.00 108.86 820.19 12.29 5,879.86 21,000.00 2,945.86 1D,552.68 50.25 10,947.32 27,700.00 2,559,72 11,372.82 91.06 16,327.18 TOTAL Arena Concessions 50,200.00 5,289.99 21,808.98 93.94 28,391.02 TOTAL Culture & Recreation 962,700.OD 69,199.49 481,999.97 50.06 980,750.03 TOTAL EXPENDITURES 962,700.D0 69,199.99 981,949.97 50.06 980,750.03 REVENUES OVER/(UNDER} EXPENDITURES O.OD ( 25,419.58}( 99,618,15} 94,618.15 11-12--2009 08;17 AM 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY CITY of ELx RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; OCTOBER 31ST, 2009 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 3.33 °s OF BUDGET PAGE; ~ F YEAR COMP, BUDGET BALANCE REVENUE SUMMARY Pa.newood Gold Course 254,800.00 4,163.01 20Dx070.55 78.52 59,729,95 TOTAL REVENUES 254,80D.00 4,163.01 200,07D.55 7$.52 54,729,95 EXPENDITt7RE SUMMARY Culture & Recreation Gall Course 259,$00.00 27,813,29 290,b08.91 94.43 14,191.59 TOTAL Culture & Recreation 259,$00.00 27,$13.29 24D,6D8.91 99,93 14,191,59 TOTAL EXPENDITURES 254,$OO,OD 27,$13.29 290!60$.41 94,93 19x191.59 REVENUES OVER/(UNDER) EXPENDITURES O.DD ( 23,650,28)( 4D,537.86) 40,537,$6 11-12-2009 08;17 AM 222-PINEWOOD GOLF COURSE REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITEDI AS OF; OCTOBER 31ST, 2009 CURRENT CURRENT BUDGET PERTOD EAR TO DATE ACTUAL 3.330 °s OF BUDGET PAGE; 2 F YEAR COMP. BUDGET gAIANCE Pinewood Galt Course Charges for Services 222-~3--0000~3461 Recreation Fees 20,ooo.OD D.00 20,693.05 103.47 ( 693.051 222-3-0000-3967 Concessions 19,000.40 285.20 18,608.99 97.99 391,51 222-3-0000-3469 Other Sales 9,000.00 54.95 5,390.90 134.77 ( I,390.901 222M3w0000-3475 Building Rent 0,00 0.00 80.OD O.OD ( 80.041 222-3-000 03976 Green Fees 112,ODO.OD 1,551.5D 114,286.19 102.09 ( 2,286.141 222-3-0000-3477 Membership Fees 18,000.00 0.00 14,250.09 79.17 3,799.91 222-3-0000-3478 Golf Cart Rental 19,000.00 929.00 19,342.78 101.80 ( 342.7$1 z22--30000-3479 Tournaments 0,00 1,$91.86 7,019,79 0.00 ( 7,019.741 222-3-OOOOM3982 Advertising tee 500.00 0.00 400.D0 80.00 100.00 TOTAL Charges far Services 192,50D.00 4,162.D1 200,066.19 103.93 ( 7,566.191 Other Revenue 222-3-0000-3629 Miscellaneous Revenue D.00 0.00 9.50 0.00 ~ 9.501 TOTAL Other Revenue 0.00 0.00 4.50 O.OD ( 9.50} Sales 222-3-0000--3792 Cash Over 0.00 1,00 ~ D.141 0.00 0.14 TOTAL Sales O.DO 1..00 t 0.191 D.00 0.14 Transfers In 222-3-0000-3922 Transfer-General Fund 62,300,00 0.00 0.00 0.00 62,300.00 TOTAL Transfers In 62,300.00 0.00 0.00 0,00 62,300,00 TOTAL Pinewood Golt Course 254,$00.00 9,163.01. 200,070.55 78,52 59,729.95 TOTAL REVENUE 254x800.00 9,163.01. 200xD70.55 78.52 59,729.95 11-1z-2ao9 a8:17 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT {UNAUDITED) AS OF: OCTOBER 31ST, 2009 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES 83.33°s OE YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 89,300,00 11,360.07 77,934.16 86.71 11,865.84 222~4~53D0~4102 Overtime Pay 10D.00 0,00 169.38 169.38 { 69.38) 222-4-5300-4103 Part time Pay 28,650,00 2,617,14 34,927,20 121,91 { 6x277.2DJ 222-4-5300-4104 PERA 8,10D.00 902.95 6,534.63 80,67 1,565.37 222w4-5300-4105 FICA 7,950,00 862.90 7xD64.40 94.82 385.60 222-4~5300~4107 Medicare 1,750,00 201,83 1,652.18 94.41 97,82 222-4-5300-4108 Insurance 9,200.00 876.OD 8,970.00 92.07 730.0D 222-4-5300-4109 Workers Comp 1,05D,D0 311.25 1,193.25 113.64 { 143.25) TOTAL Personal Services 145,600.00 17,132,19 137,445,20 94.4D 8,154,80 Supplies 222-4-5300-4212 Euels & Lubs 5,DOD.DD 2224-5300-4217 Uniform Allowance 500.0D 222-4~5300~4219 Operating Supplies 25,100.D0 222-4-5300-4259 Other Merchandise Ear Resale 10,800.00 TOTAL Supplies 41,400.0D Other Services & Charges 222-4-5300-4321 Telephone 2,500,00 222-9-5300-4331 Travel, Conferences & Schools 4D0.00 222-9-5300-9399 Advertising/Marketing 1,500.00 222~9~53D0~4361 Insurance 11,550,00 222-4-5300-4389 Utilities 6,S0D.00 222-9-5300-4401 Bldg Repair/Maim Services 2,000.00 222-9-5300-9404 Equip Repair/Maim Services 2,500,00 2229-5300-9415 Equipment Rental D,00 222w9~53DD~4437 Taxes & Licenses 1,D00.D0 222~4~5300~9438 Credit Card Fees 3,500,00 TOTAL Other Services & Charges 31,750.00 Debt Service 222~4~5300~4601 Principal 36,050.D0 TOTAL Debt Service 36,D50.00 478.70 2,962,24 49.24 2,537,76 O.OD 421.39 84.28 78,61 758,01 21,296,89 84.85 3,803.11 647,00 13,679.07 126.66 ( 2,879.07) 1,883.71 37,859,59 91.45 3,540.91 218.34 1,730,32 69,21 769.68 0.00 426,56 106.69 { 26.56) O.OD 602.75 40,18 897.25 5,914.50 11,061.00 95.77 489.00 862.20 5,601.27 82.37 1,198.73 20,04 784,39 39.22 1,215.61 O.OD 2,023.85 80.95 475,15 332.28 1,721.72 0,00 ( 1,721,72) 976.81 582,05 58.21 917.95 473.27 4,72D.23 134.85 ( 1,220.23) 8,797,44 29,254,14 92.14 2,495.86 0.00 36,049.98 100.00 D.52 0,00 36,049.98 1D0.D0 0.52 TOTAL Golf Course 254,8DD.00 27,813.29 240,608.91 99,43 14,191,59 TOTAL Culture & Recreation 254,800.00 27,813.29 24D,60$.41 94.43 14x191.59 TOTAL EXPENDITURES 254,800,00 _--W----~~~__ _ 27,813.29 ____________ _ 24D,608.41 94.43 ____________ _______ _ 14,191,59 ____________ REVENUES OVER/(UNDER) EXPENDITURES 0.00 { 23,65D.28){ 4D, 537,86) 40,537,$6