Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 02-16-2010
City of El -._-~ River MEMORANDUM ~®r and icy ~unc~l e ° °~rr~ ~~n, Finance ~r~c~r ° ruary ~ by . o January ~ ®nhly inanciai ~p~rt 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 i.n analyzing the City's financial health, For the month of January, actual :revenuesexcept fox property taxes and state aids} and expenditures should tun slightly over S% 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 fox 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. GeneraX Fund. revenues: ~ Property taxes, our largest revenue source, will be received in July and December. ~ Much of the revenue collections in licenses & permits are related to solid waste and apartment annual license renewals, Charges for services revenue includes the semiannual billing for school liaison services for January through June, ® The negative interest income is related to the reversal of the prior year's interest receivable which was done this month, ® The transfers in will be recorded midWyear. expenditures: ~ Excluding transfers, the total departmental expenditures are at about 5°/o and most departments are well within or below budget. ® Many departments' expenditures include the f:~st quarter allocation of liability and worl~ers comp insurance and annual software maintenance agreements, as is the case for Mayor & Council and Police Adntinist~ation. ~ The Snow Removal budget reflects the seasonal expenditures for personal services, ® The transfers out to the Zce Arena and Pinewood Golf are made at the end of the year. ice ~e~a For January, revenues exceeded expenditures by $~ 5,099, Excluding transfers in, revenues are about 5% of budget due mainly to hockey admissions and concessions while expenditures are about Z°/a attributable mainly to personal services and insurance. Charges for January ice rental will be billed to customers in February. Pinewood golf Golf revenues will not be generated until spring while expenditures are about 3% of the budget due to personal set~vices and insurance, 2~-D9--2010 12:91 PM 101--GENERAL FUND FINANCIAL SUMMARY CURREN'T' CURRENT BUDGET PERIOD PAGE ; 1 r ~~ n ,.-~ ~ ~ ~ rs 1~ ~ ~:~ r ~~ F r~', tl~ey~F rj r rn t "J ~~, ~` " ~ `~;:~~ a ~~; Fa{;~ 08,33a OF Y~I~K'{~pMP, YEAR TQ DATE °s OF aUDGET ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 11,719,80D.00 37,863.22 37,863,22 0,32 11,681,936,78 TOTAL REVENUES 11,719,800,OD 37!863.22 37,863.22 0,32 7.1,681.,936.78 _~~~.~________ _____.~_.~~____ _~___~...~____-- -____-- _.._~~~.____.....W~~ EXPENDITURE SUMMARY General Government Mayor & Council Cable TV Administrative Services Human Resources Elections Finance Information Technology Legal. Community Development Planning City Hall Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fare Administration Fire Inspections Emergency Management Building Safety Environmental TOTAL Public Safety Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works CxTY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF; JANUARY 31ST, 2D10 167,65D,00 22,638.73 22,638,73 13.5D 145,011.27 81,650,00 3,370,78 3,370,78 4.13 78,279,22 470,500.00 27,944,67 27,999.67 5,99 942,555.33 150,95D,00 9,060,35 9,060,35 6,02 141,389,65 3$,1DD,D0 0.00 0.00 0.00 38,100.00 497,400,00 33,81D,5D 33,810.50 7.56 913,589,50 303,150,00 8,348.75 8,398,75 2.75 294,801,25 239,OD0.00 0.00 O,OD O,OD 234,000,00 67,150.00 3,339,09 3,339,09 4.97 63,810,91 299,950.00 13,6D8,07 13,608.D7 4,54 286,391,93 297,000.00 16,484,49 16,984,49 5,55 280,515.51 113,10D,00 0.00 O.OD 0.00 113,100.00 2, 67 D,10D.00 13$,605,93 138,605.43 5.19 2,531,999.57 543,804,OD 66,944.17 66,994.17 12.22 477,355.$3 2,295,150.00 97,849.39 971849.39 4.36 2,197,300,61 731,350.00 35,113.37 351113.37 4,80 696,236,63 501,900.00 22,690.67 221690,67 9.52 479,209,33 22,900,DD 236,00 236,D0 1,03 22,664.00 206,250,OD 10,654.75 10,659,75 5,1.7 195,595,25 965,550,00 25,567,45 25,567,45 5.49 439,982,55 184,600,00 8,170,43 8,170.93 9,43 176,429.57 30,800,00 596.12 596,12 1,94 30,203.88 965,550,00 24,627.50 29,627,50 5,29 990,922,50 52,20D,00 21843,21 2,843,21 5,45 991356.79 5,450,050.00 299,793,06 299,793.06 5,91 5,155,256.94 1, 336,950.D0 41,277.95 41,277.95 3.09 1,295,672,05 246,550,D0 20,850,15 20,850.15 8,46 225,689,85 246,300,00 11,259,63 11,254.63 9,57 235,095.37 178,35D.00 216.02 216,02 0,12 178,133.98 2,008,15D,OD 73,598.75 73,598,75 3,67 11934,551.25 2-09-2D1D 12;41 PM 141-GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: ~3ANUARY 31ST, 2010 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 8.33°s o 0~' BUDGET PAGE; 2 F YEAR COMP. BUDGET BALANCE Culture & Recreation Parks Department 767,154.DD 36,569.80 36,569,80 9.77 734,580.20 Parks & Rec Admin 543,30D.OD 24,879,06 29,879.06 4.58 518,42D.94 Recreation Programs 173,550.00 9,898.77 4,898.77 2.82 1b8,651.23 Concessions 13,850.OD 335.66 335,66 2,92 13,514,39 Sr Citizen Programs 203,250.00 8,559,21 8,559.21 4,21 194,690.79 TOTAL Culture & Recreation 1,701,100.00 75,242.50 75,242.50 9,42 1,625,857.50 Economic Development Economic Development 0.00 15,42G.21 15,026.21 D.00 ( 15,026.21} Energy City 51,350.00 441.84 991.89 D.86 50,908.16 TOTAL Economic Development 51,354.OD 15,468.05 15,968.05 3D.12 35,881.95 General Transfers Out 169,D54.D4 0.00 0.00 D. 0.0 169,054.04 TOTAL General 164,050.00 0.00 O.DO 0.00 1.64,050.00 TOTAL EXPENDITURES 12,044,800.40 597,707.79 597,707.79 4.96 11,447,D92.21 REVENUES OVER/{UNDER} EXPENDITURES { 325,000.00}{ 559,$49,57}( 559,844,57} 239,844.57 2-09-201.0 12:41 PM CI'T'Y OF ELK RIVER PAGE; 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; JANUARY 31ST, 2010 101-GENERAL FUND REVENUES 08.330 OF YEAR COMP. CURRENT` CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,688,950.00 101-3-DO00-3121 Gravel Tax 135,000.00 TOTAL Taxes 9,823,950.00 Licenses & Permits 1D1-3-DODO-3211 Liquor License 51,OOO.DO 101-3--000 03212 Amusement License 1,DOp.00 101--3-0000-3213 Cigarette License 3,000.00 101-3-GOOD-3214 Apartment License 15,850.00 101-3-ODOp--3216 Mining License 20,DOO.OD 101-3-~p00D-3217 Garbage Hauler License 3,000.00 101-3-DODO-3218 Other Business License/Permit 13,oD0.OD 101-3-0000-3229 NPDES Permit 2,ODD.00 101--3Wp000~3231 Building Permit 135,OOp.pD 101--3-0000-3232 Plumbing/Heating Permit 90,000.00 141-3-0000-3233 Permit Surcharge 240.00 101-3-DODO-3235 Animal License 3,OOO.D0 101-3-GOOD--3236 Parking Permit 2,000,00 101-~3~-400D-3237 Other Non~Business Lic/Perm~.t 1D, DDO.00 TOTAL Licenses & Permits 299,050.00 Intergovernmental Rev 101--3-0000-3311 Federal Grant 3,400.00 101-3-DODO-3322 MV Credit ( 221,100.00} 101-3-0000-3324 PERA Aid 14,D00.00 101-3-DODO-3325 Police 2~ Aid 20D,OO0.D0 101-3-D000--3326 Police Training Reimb 10,DD0.00 101--3w000p-3327 State-~Aid Street Maint 39, Oo0 , po 101-3-Op00-3329 State Crime Prevention Grant 13,000.00 101-3-0000-333D Other State Grants 4,900.00 101-3-GOOD--3341 County Reimb/Grant S,DDO.DD TOTAL Intergovernmental Rev 67,$00.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,ODO.DD 101~3~Opp0~-3413 Plan Check Fee 5D,Op0.p0 101--3-0000-3415 Special Assessment Search 5DO.OD 101-3-4000-3417 Copies 1,500.00 101-3-0000-3418 Other General Govt Services 4,400,00 101-3-GOOD-3430 Lockout Fees 8,000.00 101-3-DODO--3931 Police Services 2,000.00 101-3--0000--3932 School Liaison 75, DOp. 00 101-3--OODD~-3434 Animal Impound Fee 3, 000.00 101--3--0400--3436 Fire Contracts 185, 000.00 36.79 36.79 0.00 9,688,913.21 0,00 0,00 O.OD 135,ODp.OD 36.79 36.79 O.DO 9,823,913.21 0.00 0.00 O.pp 51,D40.04 O.DD 0.00 0.00 1,D4D.OD 0,00 0.00 0.00 3,p00.Dp o . po D~. DD p . Da 15, 850.00 a.oo o.pa a.oo 20,ooo.Do 765.00 765.00 25.50 2,235.00 7,205.00 7,205.OD 55.92 5,795.00 175, 00 175. oD s . 75 1, s25. 00 5,610.85 5,610,85 4.16 129,389.15 2,627.31 2,627,31 6.57 37,372.69 222,15 222.15 111.08 ( 22,15) 210.00 210.00 7.00 2,790.00 400.00 400.00 20.00 1,600.00 100.D0 100.00 1.00 9,9D0.00 17,315.31 17,315.31 5.79 281,734,69 0.00 0.00 O.OD 3,ODO.OD D.Dp o.oo D.pD ~ 221,1pD.op~ 0.00 D.00 0.00 14,OOO.OD 0.00 D.Op 0.00 20D,OOO.D0 0.00 p.D0 0.00 1D,DDD.D0 0.00 0.00 0.00 39,DDp.00 O, ap D. oD D, as 13, oOD. oD 0.00 O.p0 0,00 4,900.00 0.00 0.00 0.00 5,OOD.OD O.00 0.00 0.00 67,800.00 2,221,OD 2,221,00 14,81 12,779.00 1,392.69 1,392,69 2.79 48,607.31 220.00 220,00 94.00 280.00 67.25 67.25 4.48 1,432.75 0.00 0.00 p.po 4,040.00 630.00 630.00 7.88 7,370.00 86.25 86.25 4,31 1,913,75 37,500.00 37,500.40 50.00 37,500.00 250.00 250.00 8.33 2,750.00 0.00 0,00 0.00 185,000.00 2-O9-2D7.0 12;41 PM CxTY OF ELK RTVER PAGE; 4 REVENUE & EXPENSE REPOR T {UNAUDITED} AS OF: JANUARY 31ST, 2010 101-GENERAL FUN D 08.330 OF YEAR COMP, CURRENT CURRENT YEAR TO BATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101--3~DDOOw3437 Fire ca11s 1,DOO.oo D.oo o.DD D.oD 1,DDD.oD 101-3-0000-3457. Street Services 25,D00.00 O.OD D.DD D.DD 25,D04.00 101-3-DDDO-3461 Recreation Fees 114x2DD.DD 4,D15.OD 4,015.00 3.52 11D,185.00 101M3--OODD--3467 Concessions 19,100.00 515.35 515.35 3,65 13,584.65 101-3-ODDO-3472 Park Use Fee 18,000.OD 140.DD 14D.D0 0.78 17,86D.OD 1D1--3-OOOD-3474 Facility Use Fee 9, 3DD, oD 7.35.00 135.00 3.7.4 4,155.00 101-3~-ODDO---3975 Building Rent 7,800.00 200.00 200.00 2.56 7,600.00 101-3-0000-3483 Sewer Inspection Fee 2,500.00 130.00 130.00 5.20 2,370.00 101-3-0000-3484 Contractor License Check 300.00 15.00 15.00 5.00 285.00 TOTAL Charges for Serv.ice5 531,200.00 47,517.54 47,517.54 8,95 483,6$2.46 Fines & Forfeits 101-3-DDDD~351D Court Fines 125,000.00 O.DO 0.00 0.00 125,000.00 101-3~-DOOD--3511 Parking Fines 10, ODO. DO 1, 460. DD 1, 460.00 14.60 8, 540.OD TOTAL Fines & Forfeits 135,000.00 1,960.00 1,960.00 1.08 133,540.00 Other Revenue 101-3-0000-3621 Interest Income 160,000.00 ( 30x475.09}( 30,476.09} 19.05-- 190,476.09 101-3-0000-3625 Refunds ~ Reimbursements 72,000.00 100.00 100.00 0.14 71,900.00 101--3--0000-3626 Contributions 22,200.00 1,185.00 1,185.00 5.34 21,015.00 101--3-~OODD--3629 Miscellaneous Revenue 3,000.00 724,67 729.67 24.16 2,275.33 TOTAL Other Revenue 257,200.00 { 28,456.42){ 28,466.42) 11.07-- 285,666.42 Transfers In 101-~3~-OODD--3925 Transfer-Landfill 35, ODO.OD D, DO D. 00 0, 00 35, 000.00 107.-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 D.OD 0.00 O.DO 39,500.00 101-3-0000-3942 Transfer-WWTS 50,000.00 0.00 O.OD 0,00 50,000.00 101-3--DODO-3943 Transfer--Liquor 248,600.00 0.00 0,00 O.OD 248,600.00 101--3--0000--3945 Transfer-Utilities 206, x00.00 0.00 0.00 D. DO 206, 000.00 101-3-0000-3948 Transfer-EDA 17,000.00 0.00 D.DO 0.00 17,000.00 101-3-GOOD-3949 Transfer-HRA 9,500.00 0.00 0.00 0.00 9,500.00 TOTAL Transfers In 605,600.00 D.DO D.DO D.DO 605,600.00 TOTAL General Fund 11,719,800,00 37,863,22 37,863.22 0.32 7.1,681,936,78 TOTAL REVENUE 11x719x8D0.D0 37x863.22 37,863.22 0,32 11,681,936.78 z-a9--2010 12:41 PM CT~'Y OP' ELK RxVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDTTED} AS OF; ~7ANUARY 31ST, 2010 101~-GENERAL FUND DEPARTMENTAL EXPENDTTURES 08.33% OF YEAR COMP, CURRENT CURRENT YEAR TO DATF~ 0 0~' BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council ~'ersonal Services 101-4-1110-4103 Part-time Pay 101--9--113.0-9104 PERA 101-4-1110--9105 FTCA 101-4-1110-9107 Medicare 101-4-1110-9109 Workers Comp TOTAL Personal Services Supplies 101.9-1110-9201 Office Supplies TOTAL Supplies Other Services & Charges 1D1~-4w1110-9319 Other Professional Services 101--4-1110--4322 Postage 101-4-111.0-4331 Travel., Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101~4~-11104433 Dues & Subscriptions 101-4-1110w494D Miscellaneous TOTAL Other Services & Charges 38,500,00 3,208.00 3,208.00 8.33 35,292.00 1,950.00 100.41 100,91 5,15 1,849.59 2,400.00 ~~n nn 198.90 nG ~~ 198.90 8.29 nG ~~ a nG 2,201,10 ~n~ na 2,800.00 122.05 122,05 9.36 2,677,95 2,$00,00 122,05 122.05 9.36 2,677.95 10,750.00 1,629.00 1,629.00 15.15 9,121.00 500.00 D.OD 0,00 0.00 500.00 3,100,00 0.00 0.00 0.00 3,100.00 18,200,00 56.10 56.10 0,31 18,143.90 68,050.00 17,266.75 17,266,75 25.37 50,783.25 15,500.00 0,00 0.00 0.00 15,500.00 5,300.00 O.DO 0.00 0.00 5,300.00 121,400.00 18,951.85 18,951.85 15.61 102,448.15 TOTAL Mayor & Council Cable TV Personal. Services 101-4-1120-4101 Regular Pay 101- 41120-4103 Part-time Pay 101--4--1120-4104 PERA 101-4-1120.4105 FTCA 101-9-1120-4107 Medicare 101-4-1120-4108 Insurance 101--4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-9201 Office Supplies TOTAL Supplies 167,650.00 22,638.73 22,638.73 13.50 145,011.27 52,000,00 2,1.55.12 2,155.12 4.14 49,894.88 11,750.00 140.63 140,63 1,20 11,609.37 3,650.00 269,39 259.39 7.38 3,380.61 3,950.00 253.17 253.17 6.41 3,696.83 900.00 59.22 59,22 6,58 890,78 5,500.00 449.00 449.00 8,16 5,051,00 200.00 94.25 44,25 22,13 155.75 77,950.00 3,370.78 3,370.78 4.32 74,579.22 1,000.00 0,00 O,OD 0.00 1,000.00 1, DOO . DO D . oo a . DD o , 00 1, DOO . o0 z-o9-201D 12;91 PM 1D1-GENERAL FUND General Government DF~PARTMENTAT~ EXPENDITURES PAGE; 6 08,330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-7120-4319 Other Professional Services 101--9-~1120-~4322 Postage 101-4-112D-4331 Travel, Conferences & Schools 101-4-1120-9409 Equip Repair/Maint Services TOTAL Other Services & Charges 500,00 0.00 50.00 0, 00 1,700.OD 0.00 450.00 D,OD O,OD D.00 500,D0 0.00 D.00 50.OD n nn n nn ~ inn nn 2,740.00 0,00 0,00 0.00 2,700,00 TOTAL Cable TV 81,650,D0 3,37D,78 3,370,78 4,13 78,279,22 Administrative Services Personal Services 101-9--1210-4101 Regular Pay 295,100.OD 12,929,16 12,429,16 9,21 282,670.89 1019--121.0--4103 Part time Pay 44, 900.00 1, 784 , 45 1, 789 , 45 3.97 43,115 , 55 101-4-1210-43.09 PERA 23,SOD.DD 1,775,99 1,776,94 7,47 22,D23.D6 101-9-121D-9105 FICA 21,100.00 1,530.43 1,530,93 7,25 19,569.57 101--4--1210-9106 Other Retirement Contributions 4,80D.00 4DO.D0 900,00 8,33 4,400.00 101-9~-121D~-9107 Medicare 9, 950.OD 357 , 93 357 , 93 7 , 23 4, 592.07 101-4-121D-9108 Insurance 24,600,DD 2,250.01 2,250,01 9,15 22,349.99 101-4-1210-9109 Workers Comp 1,500,00 401.00 401.D0 26,73 1,D99.D0 TOTAL Personal Services 420,750,00 20,929.92 20,929,92 4,97 399,820.08 Supplies 1D1-4-1210-4201 Office Supplies 13,000.00 138.94 138.94 1,07 12,851.06 TOTAL Supplies 13,OOO.OD 138,94 138,94 1,07 12,861.06 Other Services & Charges 101-9-1210-4319 Other Professional Services 5,100.00 5,088.00 5,088.00 99,76 12,00 101-4-121D-4321 Telephone 900.00 2,91 2.91 0.32 897,09 1014--1210-4322 Postage 1,5D0.00 0.00 0,00 0,00 1,500.D0 101--9--121.0--4331 Travel, Conferences & Schools 5, 350.00 325, 00 325.00 6, 07 5, 025 , 00 101-4-1210-9361 Insurance 250.00 23,25 23.25 9,30 226.75 101-4-121D-9404 Equip Repair/Maint Services 21,650,00 1,286.65 1,286.65 5,94 2D,363.35 101-9-1210-9933 Dues & Subscriptions 2,000.00 1.50.00 15D.00 7,50 1,850.00 TOTAL Other Services & Charges 36,750,00 6,875,81 6,875.81 18,71 29,879.19 TOTAL Administrative Services 470,500.00 27,944,67 27,949,67 5,94 492,555,33 Human Resources CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDT'~ED} AS OF; JANUARY 31ST, 2010 2-09-201.0 12;41 PM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES PAGE; 7 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-9-1220-4101 Regular Pay 67,850.00 2,870.5$ 2,870,58 4,23 64,979.42 101-~9--1220--4103 Part-time Pay 48, 000.00 2, 382.62 2, 382.62 9.96 95, 617 , 38 101-9-1220-4109 PERA $,100.00 650.72 650.72 8.03 7,449.28 101-4-1220-9105 FICA 7,200.00 581.43 5$1.43 8.D8 6,61$.57 101~9~1220--4107 Medicare 1,700.00 135.98 135.98 $.00 1,569.02 101-4-1220-9108 Insurance 5,500.00 469,01 469.01 8.53 5,030.99 101-4-1220-9109 'Workers Comp 500.00 136.75 136.75 27.35 363,25 TOTAL Personal. Services 138,850.00 7,227.09 7,227.09 5.20 131,622.91 Supplies 1D1-9-1220-4201 Office Supplies 9,100.00 1,596.66 1,596.56 3$.94 2,503,34 TOTAL Supplies 4,100,00 1,596.66 1,596.65 3$.94 2,503.34 Other Services & Charges 101-9-122 09319 Other Professional Services 3,OOO.DO 0.00 0.00 D.00 3,000.00 10 14-1220-4322 Postage 350,00 0.00 0.00 0.00 350.00 101-4-1220-4331 Travel, Conferences & Schools 2,250.00 175.00 175.OD 7.78 2,075.00 101-9-1220-9933 Dues & Subscriptions 900.00 0.00 O.Op 0.00 900.00 101--9--1220--4940 Miscellaneous 1, 000.00 61.60 61.60 6.16 938.40 TOTAL Other Services & Charges 7,500.00 236.60 236.6D 3.15 7,263.40 TOTAL Human Resources 150,95x,00 9,060.35 9,060.35 6.02 141,389.65 Elections Personal Services 101-9-1230-4103 Part-time Pay 30,OOD.00 O.OD 0.00 0.00 30,000.00 TOTAL Personal Services 3p,000.OD 0.00 0,00 0.00 30,000,00 Supplies 101--9-1230-4219 Operating Supplies 4,60D.00 O.DO 0.00 D.DO 9,600.DD TOTAL Supplies 4,600.00 O.pp 0.00 0,00 4,600,00 Other Services & Charges 1014--1230-4322 Postage 70D.00 D . OD 0.00 D . pD 700. DO 101-4-1230-4331 Travel, Conferences & Schools 70D.00 0,00 0.00 0.00 700.00 101-4-1230-4359 Publishing 1,000.00 D.00 O.DO 0.00 1,ODO.DO 101-4-1230-9904 Equip Repair/Maim Services 100.00 0.00 0.00 0.00 100.00 101.9--1230-4415 Equipment Rental 1,OflD.OD 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 3,500,00 0.00 0.00 0.00 3,500.00 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: ,7ANUARY 31ST, 2D1D TOTAL Elections 38,100.00 0.00 0.00 0.04 38,100.00 2-09-207.0 12:91 PM 101-GENERAL FUND General Government DEPARTMENT'AI, EXPENDrTURES PAGE : 8 08.33°s Off' YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Finance Personal Services 101-9-1310-4101 Regular Pay 101--4-1310--4103 Part--time Pay 107.-4-1310-4104 PERA 101-4-1310-9105 FICA 101-~4~1310--9107 Medicare 101-4-1310-4108 insurance 101-4-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-93D1 Audit Fees 101--4--1310-4319 Other Professional. Services 101-4w1310--9321 Telephone 101-4-1310-4322 Postage 101-4-1310-9331 Travel, Conferences & Schools 101-4.1310-4359 Publishing 101--4~-1310.4404 Equip Repair/Maim Services 101-4-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges 285,500.D0 13,797,56 13,797.56 4,83 271,702.49 2,000,00 90.0D 90,00 4,5D 1,910.00 20,000,00 1,997.74 1,997.79 7,99 18,502.26 17,85D,00 1,279.56 1,279,56 7,17 16,570.99 4,20D.00 299,25 299.25 7,13 3,900.75 29,600.00 2,043.D1 2,043,01 8,30 22,556,99 1,25D.00 335,75 336,75 26.99 913,25 355,4DD.0D 19,343.87 19,343.87 5.94 336,056,13 3,850.00 0,00 O.OD D.00 3,85D.00 3,s5o.DO D.oO a,oa o,DO 3,85o,Do 18,000.00 3,900.00 3,90D.D0 21.67 14,10D,D0 49,0DD,D0 0,00 0.00 0.00 49,DD0,DD 800,00 3,51 3.51 0.49 796.49 3,500.00 D.QO 0.00 O,OD 3,500.00 2,950,00 711,50 711,5D 24,12 2,238,50 1,200,0D 0,00 O.DO 0.00 1,20D.00 11,100.00 9,851.62 9,$51.62 88.75 1,248.38 1,500.D0 0.00 0.00 0,00 1,500.00 88,150.00 14,466.63 19,466.63 16.41 73,683,37 TOTAL Finance Information Technology Personal Services 101-4-1350-9101 Regular Pay 101-4-1350-4104 PERA 101-4--1350-4105 FICA 101-4-135D-4107 Medicare 101-9-1350-41D8 Insurance 101-4-1350-41D9 Workers Comp TOTAL Personal Services Supplies 101-4-1350-4219 Operating Supplies TOTAL Supplies CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED AS OF: ~7ANUARY 31ST, 2010 447,400.00 33,810,50 33,810,50 7,56 413,589.50 128,400.00 5,431,50 5,431,50 4,23 7.22,968.50 9,0DD,00 678,94 678.99 7,54 8,321,06 8,300.00 587,88 587,88 7,08 7,712,12 1,950,00 137,48 137,48 7,D5 1,812,52 16,1.00,00 1,352,00 1,352,00 8,40 14,748,00 600.00 151.50 151,50 25,25 448,50 164,350,00 8,339.30 8,339,30 5,07 156,010,70 29,90D,DD 0,00 0.00 D,DO 29,900,D0 29,900.00 D,00 D,00 0,00 29,900.DD 2~D9~2Dla 12;91 PM 101--GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RxVER REVENUE & EXPENSE REPORT ~UNAUDITEDJ AS OF; ~7ANUARY 31ST, 2010 PAGE; 9 08.330 OF YEAR COMP. CURRENT CURRENT YBAR TO DATE s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1350-9319 Other Professional Services 8,D00.00 0.00 0.00 0.00 8,DOO.OD 101-4-1350-9321 Telephone 750.00 9.45 9.95 1,26 740.55 101--9--135 09331 Travel, Conferences & Schools 12x300.00 D.00 O.OD 0.00 12x300.00 101-4-1.350-9909 Equip Repair/Faint Services 16x950.00 0.00 0.00 0.00 16x950.00 TOTAL Other Services & Charges 38,000.00 9.95 9.95 0.02 37,990,55 Capital. Outlay 101-9-1350-9560 Equipment 70,900.00 0.00 0.00 O.DO 7D,9DD.00 TOTAL, Capital Dutlay 70,900.OD 0.00 O.DO 0.00 70,900.00 TOTAL Information Technology Legal Other Services & Charges TOTAL Other Services & Charges 303,150.00 8,348.75 8,398.75 2.75 299,801.25 234,000.00 0.00 0.00 0.00 234,000.00 234,000.00 0.00 0.00 0.00 234,000.00 TOTAL Legal 234,000.00 D.OD 0.00 0.00 234,D00.00 Community Development Personal Services 101-9-1500-4101 Regular Pay 52,70D.00 2,229.04 2,229.04 4.23 50,470,96 101-4-15004109 PERA 3,700,00 278.63 278.63 7.53 3,421.37 101--4--1500--9105 FICA 3, 250.00 243.26 243 , 26 7 , 48 3, 006.74 101-4-1500--4107 Medicare 750.00 56.90 56,90 7,59 693.1D 101-9-1500-4108 Insurance 5,500.00 469.D1 469,01 8,53 5,030.99 101-4-1500-4109 Workers Comp 600,00 62.25 62.25 10,38 537,75 TOTAL Personal Services 66,5DD.D0 3,339.09 3,339.09 5.02 63,160.91 Supplies 101-4-1500-9201 Office Supplies 150.00 O.DO D.DO 0.00 150.D0 TOTAL Supplies 150.00 0.00 0.00 0,00 150.D0 Other Services & Charges 101-4-1500-4331 Travel., Conferences & Schools 500.00 0.00 D.DO D.OD 500.00 TOTAL Other Services & Charges 500,00 0.00 D.00 0,00 SDO.OD TOTAL Community Development 67,15D.00 3,339.D9 3,339.09 9.97 63,810.91 2-~09-~2010 12:41 PM CITY OE ELK RIVER PAGE; 10 REVENUE & EXPENSE REPORT (UNAUDITED} AS OE; JANUARY 31ST, 2010 101--GENEf~AL FUND General Government DEPARTMENTAL EXPENDITURES 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAI, BUDGET BALANCE Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4109 PERA 101-9-~1510--A105 FICA 101-4-1510-4107 Medicare 101-4-1510-9108 Insurance 101-4-1510-4109 Workers Comp TaTAL Personal services Supplies 101-4--1510--4201 Cfifice Supplies 101--9--1510--4212 Fuels & Lubs T4TAI, Supplies Other Services & Charges 101--4-1510-4321. Telephone 101-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101--4--1510.4359 Publishing 101--4--1.510.4361 insurance 101-4-1510-9404 Eguip Repair/Maim Services 101-4-1510-4433 Dues & Subscriptions 101--4~-1510--9940 Miscellaneous TOTAL Other Services & Charges 2D8,9D0,00 8,838,35 8,838.35 9,23 200,061.65 14,600,D0 1,104.79 1,109,79 7,57 13,495.21 12,950,OD 947.98 907.98 7.01 12,092,02 3,D50.D0 212,36 212.36 6.96 2,837.59 26,950,00 2,254,D1 2,259.01 8,36 24,695,99 650.00 159,00 154,DD 23,69 996,00 267,100,00 13,471,49 13,471,99 5.09 253,628.51 4,750,00 0.00 0.00 D.OD 9,75D,DD 2,55D,D0 12,59 12.59 0.99 2,537,91 7,300,00 12,59 12.59 0,17 7,287,41 800,00 0.49 0,99 D.D6 799,51 2,000,00 0.04 0,00 D.DO 2,400,OD 6, D50.00 0 , aD o . 00 0 . aD 6, a5o . DD 10,OOO.D0 0.00 0.4D D.DD 1D,OOD.D0 950.00 23,50 23.5D 5,22 426,50 5,OOD.00 0.40 0.00 0.00 5,000.00 1,000.00 100,OD 1D4,00 10,00 90D,00 25,550,00 123,99 123,99 0.49 25,426.01. TOTAL Planning City Hall Maintenance Personal Services 101-9-~1600~-4101 Regular Pay 101-4-1600-9102 Overta.me Pay 101-4-1600-9103 Part-time Pay i01--9-1600-9109 PERA 101--4~-1600--4105 FICA 101.--4--1600--41D7 Medicare 101-4-1600-4108 Insurance 1D1-4-1600-4149 Workers Comp TOTAL Personal Services 299,950,00 13,608,07 13,608,07 9,54 286,341.93 87,350,00 3,959,77 3,959,77 9,53 83,390,23 2,500.DD 255.20 255,20 10,21 2,244.80 23,050.00 888,69 888.64 3,86 22,161.36 s,lao.oa 701,10 701,10 8,G6 7,398.90 7,150,00 624,93 629.43 8,73 6,525.57 1,65D,DD 146,04 146,04 8,85 1,503,96 16,350.D0 1,715,92 1,715,92 10,49 14,634,08 4,550.40 1,324,00 1,324,D0 29.10 3,226,00 15D,700,00 9,615,1D 9,615.1D 6,38 141,084,90 2-09--2D1.0 12 ; 41 PM 101-GENERAL FUND General. Government DEPARTMENTAL EXPENQITURES CITY OF ELK RIVER PAGE; 11 REVENUE & EXPENSE REPORT UNAUDITED) AS OF; JANUARY 31ST, 2010 08.330 4F YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAI, BUDGET BAIANCE Supplies 101-9-1600-4212 Fuels & Lubs 3,750.00 25.17 25.17 0.67 3,729.83 101-9-160D-4217 Uniform Allowance 1,700.00 29.79 29.74 1.75 1,670.26 101--9--1600--4219 Operating Supplies 3D,900.D0 9,388.D2 4,388.02 19.43 26,011.98 TOTA1, Supplies 35,850.00 4,442.93 4,442,93 12.39 31,4D7.07 Other Services & Charges 101-9-1600-9321 Telephone 15,950.00 830.09 830.04 5.37 14,619.96 1D1-4-1600-9331 Travel, Conferences & Schools 2,000.00 0.00 D.DO 0.00 2,DOD.D0 101--9--1600--9361 insurance 4,500.OD 1,119.75 1,119.75 24.88 3,380.25 101-4-1500-9389 Utilities 51,8DD.D0 O.DD 0.00 0.00 51,800.OD 101-4-1600-4901 Bldg Repair/Maine Services 3D,650.OD 389,17 389.17 1.27 30,250.83 101-9-1600-9404 Equip Repair/Maine Services 5,000,00 0.00 O.OD D.aa 5,000.00 101--9~-1600-9460 Equip Replacement Charge 1,050.D0 87.50 87.50 8.33 962.50 TOTAL Other Services & Charges 110,450.00 2,426.46 2,426.45 2.20 108,023.54 TOTAL City Hall Maintenance 297,DDD,40 16,484.49 16,484.49 5.55 280,515.51 Contingency Other Services & Charges 101-4-1900-949D Miscellaneous 113,100.D0 O.OD D.DO 0.00 113,100,00 TOTAL Other Services & Charges 113,100.00 O.OD D.00 0.00 113,100.00 TOTAL Contingency 113,100.00 0.00 D.DO 0.00 113,100.00 TOTAZ General Government Police Administration Personal Services 101-4-2110-4101 Regular ~'ay 101-92110-4104 PERA 101-~q--2.10--4107 Medicare 101-4-2110-9108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-~4-211.0-9201 Office Supplies 101-9-21.1.0-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies 2,670,10D.OD 138,605.43 138,605.43 5.19 2,531,999.57 275,400,00 11,650.32 11,65D.32 4.23 263,749.68 38,850.00 2,986.74 2,986.74 7.69 35,863.26 1,25D.DD 201.50 201.50 16.12 1,098.50 24,4D0.00 2,027.02 2,D27.02 8.31 22,372.98 55,15D.00 13,39D.5D 13,390.5D 24.28 91,759.50 395,050.00 30,256.08 30,256.08 7.66 364,793.92 17, ooo. a0 0, Da a, o0 0. DD 17, aoD, oD 2,15D.00 D.DO 0.00 D.00 2,150.D4 1,950.00 D.00 O.OD 0.00 1,95D.DD 21,100.00 D.00 O.DD 0.00 21,100.00 2~-09~201D 12;41 PM CxTY OF ELK RIVER PAGE; 12 REVENUE & EXPENSE REPORT (UNAUDxTED) AS OF; JANUARY 31ST, 201D 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 08.330 OE YEAR COMP. CURRENT CURRENT YEAR TO DATE p OF BUDGET BUDGET PERrOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2110-9319 Other Professional. Services 101-~4~2110~9321 Telephone 101-4-2110-9322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101--4--2110-9359 Publishing 101-4-2110-4361 insurance 101-4-2110-4404 Equip Repair/Maint Services 101--4--21109433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Qutlay 5,500.00 0.00 0.40 0.00 5,500.00 27,9DO.D0 228.80 228.80 D.84 27,171.20 2,100.00 0.00 0.00 0.00 2,100.00 4,300.OD t 1,129.00)( 1,129.00) 26.26- 5,929.00 500.OD 0.00 0.00 0.40 500.D0 9,850.00 2,230.25 2,230.25 22.69 7,619.75 68,900.00 33,823.04 33,823.04 49.09 35,076.96 8,400.00 1,035,00 1,D35.00 12,32 7,365.00 7DD.oo D.oo o.4D 0.04 740.04 127x650.OD 36,18$.09 36x1$8.09 28.35 91,461.91 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 1D1-~9-~2120-~9109 PERA 101--9-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-427.2 Fuels & Lubs 101-4-2120-9217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101--9--2120-9221 Equipment Parts TOTAL Supplies Other Services & Charges 101--9--21209331 Travel, Conferences & Schools 101-4~-2120-9404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-9460 Equip Replacement Charge TOTAL Other Services & Charges 543,8D0.00 66,444.17 66,444.17 12.22 477x355.83 1,441,800,00 61,491.26 61,491.26 4.26 1,380,3D8.79 90,ODO.D4 1,444.59 1,444.59 1.61 88,555.41 216,OOD.40 15,936.21 15,936.21 7,38 200,063.79 19,900.00 1,309.20 1,3D9.20 6.58 18,590.8D 163,500.00 13x986.34 13,986.34 8.55 149,513.66 1,931,2DD.Da 94,167.6D 94,167.60 4.88 1,837,032.40 118,350.D0 98.58 98.58 0.08 118,251.42 15,850.00 167.72 167.72 1.06 15,682.28 69,65D.00 28.82 28.82 0.04 69,621.18 2$x000.00 0.00 0.00 0.00 28,000.00 231x850.00 295.12 295.12 0.1.3 231,554.88 15,304.00 1D5.DD 27,350.04 0.00 550,00 4D.00 38,900.00 3,291.67 82,100.44 3,386.67 105.00 0.69 15,195.00 0.00 0.00 27,350.00 90.00 7.27 510.00 3x241.67 8,33 35,658.33 3x386.67 9.13 78,713.33 TOTAL Patrol 2x245,150.00 97x849.39 97,849.39 4.36 2, 147,3DD.61 2-09-2010 12;91 PM CITY OF ELK RxVER PAGE; 13 REVENUE & EXPENSE REPORT (UNAUDTTED) AS OF; JANUARY 31ST, 2010 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Investigations Personal Services 101-9-2130-9101 Regular Pay 101-9-2130-4102 Overtime Pay 101-9-2130-9109 PERA 101-4-2130-9107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-9-2130-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2130W9319 Other Professional Services 101-9-2130-9331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-946D Equip Replacement Charge TOTAL Other Services & Charges 505,90D.D0 19,939.69 19,934.69 3.99 985,465.36 40,000.00 1,199.45 1,149.95 2.87 38,850.55 76,900.00 5,303.79 5,303.79 6.9D 71,596.21 9,750.D0 391.21 341.21 7.18 4,408.79 61,650.00 5,136.86 5,136.86 8.33 56,513.19 688,700.00 31,865.95 31,865.95 9.63 656,839.05 5,D50.D0 0.00 0.00 D.00 5,050,00 6,800.00 56.59 56.59 0.83 5,793.41 11,850.00 55.59 56.59 0.98 11,793.91 11,900.00 220.OD 220.00 1.85 11,680.00 9,050.00 1,800.00 1,800.00 99.94 2,25D.00 800.00 0.00 D.00 0.00 800.00 14,050.00 1,170.83 1,170.83 8.33 12,879,17 30,800.00 3,19D.83 3,190.83 10.36 27,609.17 TOTAL Investigations Police Support Services Personal Services 101-9-2150-9101 Regular Pay 101-9M2150M9102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-9105 FICA 101-9-2150-9107 Medicare 101M9-2150-4108 Insurance TOTAL Personal Services Supplies 101-9~2150~9201 Office Supplies 101-9-2150-4217 Uniform Allowance 101-4-215D-9219 Operating Supplies TOTAL Supplies 731,350.D0 35,113.37 35,113.37 4.80 696,236.63 397,300.00 14,692,75 14,692.75 9.23 332,607.25 6,500.00 0.00 0.00 0.00 6,5DD.00 24,75D.DD 1,856.59 1,856.59 7.50 22,893.91 21,950.00 1,637.27 1,637.27 7,46 20,312.73 5,150.00 382,99 382.99 7,94 9,767.06 99,150.00 3,599.20 3,599.20 8.15 9D,55D.80 499,800.DD 22,168.75 22,168,75 4.93 927,631.25 1,000.00 0.00 0.00 0,00 1,000.00 2,750.00 0.00 D.DO 0.00 2,75D.0D 9,15D.00 51.92 51.92 0.57 9,098,08 12,9DD.00 51.92 51.92 0.40 12,898.08 2-09-2010 12:41 PM 1D1-GENERAL FUND Public Safety DEPARTMENTAL, EXPENDTTURES CITY OF ELK RTVER REVENUE & EXPENSE REPORT ~UNAUDTTED) AS OF: JANUARY 31ST, 2010 PAGE: 14 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Other ~er'V1CeS & Charges 101-4-2150-9331 Travel, Conferences & Schaols 3,550.OD O.DO 0.40 D.DO 3,55D.DD 101--42150--4409 Equip Repair/Maim Services 2,650.00 0.00 O.DD D.DD 2,65D.00 101-4-2150-4409 Contractual Services 16,000.00 0.00 O.OD 0.00 16,ODD.DO 1D1-9-2150-9933 Dues & Subscriptions 5DD.OD 45.OD 45.00 9,DD 955.00 101--9-2150--4960 Equip Replacement Charge 5,1DO.OD 425.OD 925.00 8,33 4,675,00 TOTAL Other Services & Charges 27,800,00 970.00 47D.OD 1.69 27,33D.00 Capital Outlay 101-9-2150-456D Equipment 11,900.00 D.DD D.OD 0.00 11,440.DD TOTAL Capital Outlay 11,900.OD O.DD 0.00 0.00 11,400.D0 TOTAL Police Support Services 501,9DD.00 22,690.67 22,690.67 9.52 979,2D9.33 Palice Reserves --------------- Personal Services 101--4--216D-~4103 Part-time Pay 5, 500 , DD 86.78 86.78 1.58 5, 913.22 101-4-2160-4105 FICA 350.D0 7.86 7,86 2,25 342.14 101-9-216D-9107 Medicare 10D.D0 1.89 1,84 1.89 98.16 TOTAL Personal Services 5,950.DD 96.98 96,9$ 1,62 5,853,52 Supplies 101-4-2160-4217 Uniform Allowance 5,DD0.00 O.DO 0.00 D.OD S,DDD.DD 101-9-2160-4219 Operating Supplies 6,DOO.DD 0.00 0.00 D.OD 6,ODD.00 TOTAL Supplies 11,OOD.DO 0.00 O.DO 0.00 11,OD0.00 Other Services & Charges 101-9-2160-4319 Other Professional Services 1,500.40 0,00 0.00 O.DO 1,5DD,OD 101-9-216D-4321 Telephone 1,6DO.OD 139.52 1.39,52 8,72 1,960,48 101-4--2160-4331 Travel, Conferences & Schools 1,700,00 0,00 D.DD D.00 1,704,00 1D1M4--216D-~9359 Publishing 150,00 0.00 D,00 0,00 150,00 101-9-2160-9433 Dues & Subscriptions 1,040,00 D.DD 0,00 O.DO 1,ODO,DD TOTAL Other Services & Charges 5,950,00 139,52 139,52 2.34 5,810.4$ TOTAL Police Reserves Public safety building ~'ersonal Services 101-9-2190-9101 Regular Pay 101-9-219D-41D4 PERA 1D1-4-219D-41D5 FICA 1D1-4-2190-9107 Medicare 101-4-2190-9108 Insurance 22,900,00 236.D0 236.D0 1.03 22,669.00 1D0,60D.00 4,114,94 9,114,44 9,09 96,485,56 7,050.00 467,70 467,74 6.63 6,582.30 6,254.00 415.66 415,66 6,65 5,834,34 1,95D.OD 97.23 97,23 6,71 1,352,77 12,650,00 628.59 628.59 4,97 12,021.,41 z-o9-2010 12;41 PM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDTTED~ AS OF; JANUARY 31ST, 2010 PAGE : 15 08.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-9-2190-9109 G~or~exs Comp 4,050.00 768,00 768.00 18,96 3,282,00 TOTAL Personal Services 132,05D.OD 6,991.62 6,991.62 9.92 125,558.38 Supplies 101-4-2190-9219 Operating Supplies 18,2DD,DD 1,860.67 1x86D.67 10.22 16,339,33 TOTAL Supplies 18,200,00 1,860,67 1,860.67 10,22 16,339.33 Other Services & Charges 101--9--2190--4361 Insurance 6, 500, 00 1, 561, 50 1, 561.50 29.02 4, 938 , 50 101-4-219D-4389 Ut.llities 18,200,00 0.00 O.DD D,DD 18,200.00 101-9-2190-4401 Bldg Repair/Maim Services 31,300.00 790,96 74D.96 2.37 30,559,04 TOTAL Other Services & Charges 56x0OD.0O 2,302.46 2,302,96 4.11. 53,697.54 TOTAL Public safety building 206,25D.OD 10,654,75 10x654,75 5.17 195,595,25 Fire Admanistratian Personal Services 101-4-2310-4101 Regular Pay 76x250,00 3,709.39 3,709.39 4.86 72,540.61 7.01-4-2310-4103 Part-time Pay 153,DOD.D0 8,215.66 8,215.65 5.37 144,784.34 1D1-9-2310-41D4 PERA 13,25D,D0 925.86 925,86 6.99 12,329.14 1D1--9--23104105 FICA 10,100.00 832,15 832.15 B. 24 9, 267.85 101-4-2310--4106 Othex Retl.rement Contributions 30,000.00 0,00 0.00 D,OD 30,000.00 101-4-2310-4107 Medicare 3,500.D0 267.68 267,68 7,65 3,232.32 101-4-2310-4108 Insurance 9,900.D0 635.59 635.59 6.92 9,264.91 101.9-~231D-~91D9 Workers Camp 16, 700.00 4, 561.OD 9, 561.00 27 , 31 12,139 , DD TOTAL Personal Services 312,700.00 19,197.33 1.9,197,33 6.12 293,552,67 Supplies 1014-2310-9201 Office Supplies 1x2DD.00 D.DO 0.00 D.00 1,2DD.D0 101--4--2310--4212 Fuels & Lubs 9, DOD. DD 29, 37 29.37 D, 33 8, 97D. 63 101-4-2310-921.7 Uniform Allowance 1,100.00 0.00 0.00 D,DO 1,100.D0 101-9-2310-4219 Operating Supplies 22,700,00 0.00 O,DD D.OD 22,700.00 TOTAL Supplies 34,DDO,D0 29.37 29.37 0,09 33,970.63 Other Services & Charges 101-9-231D-9319 Other Professional Services 5,050,00 O.DD D,DD D,DD 5,050.00 1D1-4-2310-9321 Telephone 3,DOD.00 109,67 109.67 3.66 2,89D,33 1D1-~4--231D-9322 Postage 50D.DD 0.00 D.DO 0.00 500.D0 101.--9--231D--9331 Travel, Conferences & Schools 20, 000.00 0, DO D, 00 0. DO 20, 000.00 101.-4-23104359 Publisha.ng 50D.DD D.DO 0.00 D.DD 50D.00 101-4-2310-4361 Insurance 18,80D.OD 4,062,75 4,062,75 21.61 14,737.25 101-9-2310-4389 Utilities 15,150.00 0.00 D.DO 0,00 15,150,00 101-9-231D-4401 Bldg Repair/Maim Services 4,450,D0 D.00 0,00 0,00 4,450.DD 101.9w231D-94D4 Equip Repair/Maim Services 27,100.D0 O,OD 0,00 O.DD 27,100.00 101--9--231.0--9433 Dues & Subscriptions 2x ODD.00 36D, OD 360.00 18.OD 1x 640.00 101--4--231.0--9460 Equip Replacement Charge 22x300.00 1,$58,33 1,858.33 8.33 20,991,67 TOTAL Other Services & Charges 118,850.00 6,390,75 6,390.75 5.38 11.2,459.25 2--09-2010 12;41 PM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES PAGE; 16 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Fire Administration 465,550,00 25,567.45 25,567.45 5.99 439,982.55 Eire Inspections Personal Services 1.01-4-2320-9101 Regular Pay 128,900.00 5,451.52 5,451.52 4.23 123,448.48 1D1-4-2320-4104 PERA 19,650.00 1,1D4.77 1,109.77 7.59 13,545.23 101-~4-2320-9105 FICA 3,250.00 268.05 268.05 8,25 2,981,95 101--4-~2320-41D7 Medicare 1,900.00 190.97 190.47 7.39 1,759.53 101-4-2320-4108 Insurance 19,650.00 1,199.91 1,199.91 7.85 13,500.09 TOTAL Personal Services 163,350.OD 8,114.72 8,119,72 4.97 155,235.28 Supplies 101-4-2320-9201 Office Supplies 3,050.00 0.00 0.00 0.00 3,050.00 1D1-92320--9212 Fuels & Lubs 5,900.00 0.00 0.00 0.00 5,900.OD 101--9~2320~--9217 Uniform Allowance 800,00 0.00 0.00 0.00 800.Dp 101-4-2320-4219 Operating Supplies 4,550.00 0.00 0.00 0.00 4,550.00 TOTAL Supplies 19,300.00 O.OD 0.00 0.00 14,300.D0 Other Services & Charges 101-4-2320-4321 Telephone 1,050.00 55.71 55,71 5.31 994.29 101-4--2320-4322 Postage 150.00 0.00 0.00 0.00 150.00 1D1-9-2320-9331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,20D.00 101--9--2320--4359 Publishing 200,00 0.00 0.00 D.DO 200.00 101-4-2320-4404 Equip Repair/Maim Services 1,850.00 O.DO O.DO 0.00 1,850.00 101-4-2320-4433 Dues & Subscriptions 500.00 0.00 0.00 0.00 500.00 TOTAL Ofher Services & Charges 6,950.00 55.71 55.71. 0.80 6,894.29 TOTAL Fire Inspections 184,6pD.00 $,170.43 8,17D.43 9.43 176,429.57 Emergency Management _________~..__-~m___-- Personal Services 101--9-2330-9101 Regular Pay 8,300.00 351.90 351.90 4.24 7,998.10 1D1--92330--9104 PERA 1,400.00 90.20 90.20 6.44 1,309.80 ].01-9--2330-4.07 Medicare 150.00 9,12 9.12 5.08 190.88 101-4-2330-4108 Insurance 1,100.00 44,90 49.90 4.08 1,055.10 TOTAL Personal Services 10,950.00 496.12 996.12 4.53 10,453.$8 Supplies 101- 92330.4201 Office Supplies 900.D0 0.00 0.00 0,00 900.00 101-4-2330-4219 Operating Supplies 8,500.00 0.00 0.00 0.00 8,500.00 TOTAI, Supplies 8,900.00 0.00 D.00 0.00 8,900.D0 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2010 2-09-2010 12;91 PM 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF EL~f RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OE: JANUARY 31ST, 2D10 PAGE; 17 08.330°-0 0~' YFaAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 1019--233fl--9321 Telephone 1, 500 , 00 O.OD 0.00 0 , 00 1, 500.00 101-4-2330-9322 Postage 100,00 0,00 0.00 O.OD 10D.00 i01-4-2330-9331 Travel, Conferences & SChaolS 1,650.00 0.00 0.00 0.00 1,850.OD 101.9--233 09359 Publishing 500.00 0.00 0,00 D.00 500.00 101-4-2330-9389 Utilities 1,5DO.OD 0,00 0.00 D.00 1,500,00 101-4-2330-9909 Equip Repair/Maim Services 5,100.OD 0,00 0.00 D.00 5,100.00 101--9--2330--9433 Dues & Subscriptions 900.00 1D0.00 1DD, 00 25, 00 30D.00 TOTAL Other Services & Charges 10,950.00 10D.00 1D0.00 0.91 10,850,00 Capital Outlay TOTAL Emergency Management 3D,800.00 596.12 596.12 1.99 30,203.88 Building Safety Personal Services 101--4~-2410-4101 Regular Pay 318,350.OD 13,423.60 13,923,60 4.22 304,925,40 101-4-2410-4103 Part-time Pay 25,050.00 1,058.64 1,058.64 4.23 23,991,36 1D1-4-2910-9104 PERA 29,050,00 1,815,15 1,$15,15 7,55 22,239,85 101-4-29104105 FICA 21,300,00 1,500.55 1,5D0.55 7,04 19,799,45 101--9~-2410w4107 Medicare 5,OOO.DO 350.93 350.93 7.02 9,699.07 101-4-2410-4108 Insurance 38,250.00 3,191.09 3,191,04 8.34 35,058.96 101-9-2410-9109 Workers Camp 1,900,00 274,00 274,00 19.57 1,126.00 TOTAL Personal Services 933,900.00 21,513.91 21,613,91 9.99 411,786,09 Supplies 101-4-2910-9201 Office Supplies 2,500.00 0.00 0.00 0.00 2,500.00 101-4-2410-4212 Fuels & Lubs 9,000,00 9,94 9,44 0.29 3,990,56 101-4-241D-9217 Uniform Allowance 700.OD 0.00 O.DO D.00 700,DD 101--9--2910--4219 Operating Supplies 1,450.D0 0,00 0,00 0,00 1,950,00 TOTAL Supplies 8,650,00 9.44 9.44 0,11 8,640.56 Other Services & Charges 101--9--29104321 Telephone 2,550.00 5.58 5.58 0.22 2,599.42 101-4-2410-4322 Postage 500,00 0.00 O.DO 0.00 500.00 101-4-2910-4331 Travel, Conferences & Schools 5,750,00 0,00 4.00 D,00 6,750.00 101-4-2910-9361 Insurance 1,100.OD 209.75 209,75 19.07 890,25 101--92910-4909 Equip Repair/Maint Services 8,$00,00 2,207.15 2,2D7.15 25,08 6,592,85 101--4--2910--4433 Dues & Subscriptions 1,2DD.D0 365.00 365,00 30,42 835,00 101-4-2410-9460 Equip Replacement Charge 2,600,OD 216.67 216.67 8.33 2,383.33 TOTAL Other Services & Charges 23,50D.D0 3,004.15 3,004.15 12,78 20,495.85 TOTAL Building Safety 965,550.00 29,627,50 24,627.50 5,29 440,922,50 2-09-2010 12:41 PM CITY OF ELK RTVER PAGE: 18 REVENUE & EXPENSE REPORT ,UNAUDITED) AS OF: JANUARY 31ST, 2010 1D1~GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES D8.33o OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUnGET BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101~9~244D~9101 Regular Pay 35,400.00 1,569.85 1,569.85 9.42 33,835.15 101-4-2440-4104 PERA 2,500,00 230.26 230,26 9,21 2,269.79 1019-244D-4105 FICA 2,200.00 156.42 156,92 7.11 2,093,58 101w9~249D~4107 Medicare 500.00 36.58 36,58 7.32 463,92 101-4-2440-9108 insurance 5,650.00 706.65 706,65 12.51 9,993.35 101-4-2440-4109 Workers Comp 400.00 95.00 95.DD 23.75 305.00 TOTAL Personal Services 46,65D.D0 2,789,76 2,789.76 5.98 93,860,29 Supplies 1D1-4-294D-9201 Office Supplies 650.OD D.DO D.DD D.00 65D.00 101M9~249D~9212 Fuels & Lubs 15D.00 D.OD D.OD 0.00 15D.00 TOTAL Supplies 800.00 0,00 0.00 0.00 800.00 Other Services & Charges 101-4-24904321 Telephone 7DO.DD 6.70 6.70 0.96 693.30 101-4-2940-4322 Postage 500.00 0.00 O.DO 0.00 500.00 101-4-2990-4331 Travel, Conferences & Schools 500.00 D.00 0.00 0.00 500.00 1D1-4-2990-4359 Publishing 250.DD D.00 0,00 0.00 250.DD 101~4~249DW4361 Insurance 250.D0 46.75 96.75 1$.7D 203.25 101-4-2440-4409 Contractual Services 1,500.00 0.00 0.00 0.00 1,500.00 101-9-2440-4933 Dues & Subscriptions 1,D50.00 0.00 O.DD D.DO 1,050.00 TOTAL Other Services & Charges 4,750.00 53,45 53,45 1.13 9,696.55 TOTAL Environmental 52,200,00 2,843.21 2,893.21 5.45 49,356.79 TOTAL public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-9-3120-4102 Overtime Pay 101~9~312D-4103 Part-time Pay 101-4-312D~4109 PERA 101-4-3120-4105 FrCA 101-9-3120-4107 Medicare 101-9-312D-4108 Insurance 101~9~312D-41D9 Workers Comp TOTAL Personal Services 5,950,050.00 299,793.06 294,793.06 5.41 5,155,256.99 439,050.00 13,995,66 13,445.66 3.06 425,604.39 2,OOO.DO O.DD D.OD D.DO 2,DDD,00 73,750.00 2,309,20 2,304,20 3.12 71,445,80 34,45D.DD 2,010.41 2,010.41 5.84 32,439.59 31,900.00 1,721.17 1,721.17 5.40 30,178,83 7,450.00 402.52 902.52 5.40 7,047,48 56,600.00 2,854.7D 2,854.70 9.87 55,745.30 20,950.00 5,652,50 5,652.5D 26.98 15,297.50 668,15D.OD 28,391.16 28,391.16 9.25 639,758.89 2-09-2010 12:41 PM 101-GENERAL FUND Public Warks DEPARTMENTAL EXPENDITURES CTTY OF ELK RTVER REVENUE & EXPENSE REPORT (UNAUDTTED} AS OF: JANUARY 31ST, 2010 PAGE; 19 os,33~ a~ YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 6,400.00 0.00 D,DO O.OD 6,9D0.00 1D1--4--31204212 Fuels & Lubs 74, DDD.00 ( 27.2.91} [ 212, 91) 0.29- 74, 212, 91 101-4-3120-4219 Operating Supplies 145,000.00 98,D9 98,09 0,07 144,901,91 101-4-3120-4226 Street Signs 29,950,00 0.00 D.00 0.00 29,950.00 TOTAL Supplies 255,350,00 ( 17.9.82]( 114,82) D.09- 255,464.82 Other Services & Charges 1D1-4~-312D-9319 Other Professional Services 950.OD 0.00 0,00 0,00 950.OD 101--4-3124--4321 Telephone 8,950.00 118.53 118.53 1.32 8,831.97 1D1-9-37.20-9322 Postage 200.D0 D.DO D.DD 0,00 200.00 101-4-3120-4331 Travel, Conferences & Schools 3,OOD,D0 0.00 O.OD O.DO 3,400,00 101~4~-312d~-4359 Publishing 50D,00 O.DO O.DO 0.00 5DO.DD 101-4-3120-4361 Insurance 17,150.00 4,D06,DD 4,006.00 23.36 13,144.00 101-4-3120-4389 Utilities 33,000,00 0.00 D,OD O.OD 33,DD0.00 1D1-4-3120-49D1 Bldg Repair/Maim Services 8,50D,D0 0.00 0,00 0,00 8,5D0.00 101-4--312 04409 Equip Repair/Maim Services 5,004.00 D.DO 0.00 D.00 S,DOD,DQ 101-9-3120-4909 Contractual Services 211,700.00 D,OD D.00 D,04 211,704,00 101-9-3120-9415 Equipment Rental 5,5DD,DD 0,00 O,DD 0.00 5,500.00 101-9-3120-9417 Uniform Rental 4,7DO.D0 ~ 32.50}t 32.50} 0,69- 9,732.5D 101.4M3120--4433 Dues & Subscriptions 74D.00 7.76.25 176,25 25.18 523.75 101-9-3120-9437 Taxes & Licenses 5D0.00 D,OD 0.00 O.DD 500.OD 7.01-4-37.20-9450 Equip Replacement Charge 104,800.D0 8,733.33 @,733.33 8.33 96,066.67 TOTAL Other S ervices & Charges 9D5,150.00 13,001.61 13,001.61 3.21 392,19$.39 Capital Outlay 101-4-3120-4560 Equipment 8,300.04 0.00 0,00 4.00 8,300,00 TOTAL Capital Outlay 8,300,00 0.00 4.00 D.DO 8,300.00 TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-41D1 Regular Pay 1D1--9-~3~.3D--4102 Overtime Pay 101-~4-3130-4104 PERA 1D1-4-3130-4105 FTCA 101-4-3130-4107 Medicare 101-9-3130-4108 Tnsurance 101--9~313D~4109 Workers Camp TOTAL Personal Services 1,336,950,00 41,277.95 91,277.95 3.09 1,295,672,05 17.9,900.00 9,557,91 9,557,41 8,32 105,342,59 3,000.00 83D.40 830.40 27,68 2,169.60 8,900.00 2,110,24 2,17.0,24 23,71 6,789.76 8,250,00 1,846,53 1,846.53 22,38 6,903,97 1,900.00 431,84 431.89 22,73 1,468.16 16,250.00 4,470,48 4,470.48 27,51 11,779,52 7,350.00 1,603.25 1,603.25 21,81 5,746,75 160,550.00 20,850.15 20,850,15 12,99 139,699.85 2-49-2010 12;41 PM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDxTURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED AS OF. JANUARY 31ST, 2010 PAGE; 2D 08.33°s OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 1D1-4-3130-9219 Operating Supplies TOTAL Supplies Capital Outlay 86,DOD,00 O.OD 0.00 0,00 86,D00,00 s6,oDD.oD o.oo D.aa D.DD 86,DDD.DD TOTAL Snow Removal 246,550,00 20,850.15 20,850.15 8,46 225,699.85 Equipment Services Personal Services 101-9-3150-4101 Regular Pay 162,750,OD 6,886,D0 6,8$6,00 4,23 155,864,00 101-4-3150-4102 Overtime Pay 0,00 20.69 20.69 0.00 ( 20,69) 101-4-3150--9104 PERA 11,90D,00 780,07 780.07 6,84 10,619.93 101-4--3150-9105 FICA 10,100, OD 649.37 649, 37 6, 93 9, 950, 63 101-4-3150-9107 Medicare 2,35D,00 151,87 151,87 6,46 2,198.13 101-4-3150-4108 Tnsurance 24,150,OD 7.,172,13 1,172.13 9.85 22,977,87 101-4-3150--91D9 Workers Coop 6,D50.D0 1,594,50 1,594.50 26.36 9,455,50 TOTAL Personal. Services 216,804.00 11,259.63 11,254,63 5,19 205,545,37 Supplies 101-9-3150-4219 Operating Supplies 19,500.00 0.00 0.00 0.00 14,500.OD 101-9~-3150-9221 Equipment Parts 11,700,DO O.OD O.DO D,00 11,700,04 TOTAL Supplies 26,200.00 0,00 D,DO 0,00 26,2DO.D0 Other Services & Charges 101-9--37.50--4409 Equip Repair/Maim Services 500, OD 0, DO D, DO 0, 00 500.00 1D1-4-3150-4417 Uniform Rental. 2,800,D0 D.DO O,DO 0,00 2,800.DD TOTAL other Services & Charges 3,3DD.00 O,OD 0.00 0,00 3,300.00 `TOTAL Equipment Services Engineering Personal Services 101-9-3300-4101 Regular Pay 101-9-3300-41D9 PERA 101-9-3300-9105 FICA 101--9--3304--4107 Medicare 101-~9--3300--4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services 296,3DD.D0 11,254.53 11,254,63 9,57 235,095,37 86,850,00 0,00 6,100.00 0,00 5,400,OD 0.00 1,250.00 7F ~~n nn 0.00 n nn 116,150,OD 105,25 D,D4 0,00 86,850.OD o.oo D,oo 6,10D,DD 0.00 O,OD 5,4DD.00 0.00 0,00 1,250,00 0.00 0,00 16,350.D0 105,25 52,63 94,75 105.25 0.09 116,049.75 2-09-2D10 12:41 PM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES PAGE ; 2 ~. 08.330 0~' YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-3300-9201 Office Supplies 1,000.00 0.00 D.OD 0.00 1,OD0.00 101--4~-330D--9212 Fuels & Lubs 1, 200.OD 0.00 0 . DD 0.00 1, 200.00 101-4-3300-9219 Operating Supplies 8,80D.00 O.DO 0.00 D.DD 8,800.00 TOTAL Supplies 11,000.00 0.00 D.DD 0.00 11,000.00 Other Services & Charges 101--4-33D0-9303 Engineering Fees 20,000.00 0.00 O.OD 0.00 20,ODD.00 101--9--3300--4319 Other Professional Services 22,5DD.00 0.DO D,o0 0.00 22,50D.DO 101-4-3300-4321 Telephone 1,150.D0 1.52 1.52 D.13 1,198.48 101-4-3300-4322 Postage 200.00 D.00 O.DO 0.00 200.00 101-4-3300-4331 Travel, Conferences & Schools 5,850.00 0.00 D.DD 0,00 5,850.DD 101--9--3300--9361 insurance 250.DD 46.75 96.75 18.70 203.25 101-4-3300-94D9 Equip Repair/Maim Services 500.D0 O.DD 0.00 O.DD 500.00 '01-9-33D0-9960 Equip Replacement Charge 750.00 62.50 62.5D 8.33 687.5D TOTAL Other S ervices & Charges 51,200.00 110.77 110.77 0.22 51,089.23 TOTAL Engineering 17$,35D.OD 216.02 216,02 0.12 17$,133.98 TOTAL Public Works Parks Department ---------------- Personal Services 1D1--9~-5110-9101 Regular Pay 101--9-5110--41D3 Part-time Pay 1D1-4-5110-4104 PERA 101-9-5110-4105 FICA 101-4-5110-4107 Medicare 1D1--9-5110-9108 Insurance 101--4--5110--4109 Workers Camp TOTAL Personal Services Supplies 101-95110--9212 P'uels & hubs 101-4-5110--9217 Uniform Allowance 101-4-5110-4219 Operating Supplies TOTAL Supplies other Services & Charges 101.-9-51104321 Telephone 101-9-5110-9322 Postage 101-9-5110-9331 Travel, Conferences & Schools 101-9-511D-9361 Insurance 101-9-511D-4389 Utilities 1D1--4-511D-9401 Bldg Repair/Maim Services CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; UANUARY 31ST, 2010 2,D08,150.00 73,598,75 73,598.75 3.67 1,939,551.25 392,150.00 15,852.85 15,852.85 4.63 326,297.15 39,65D.00 0.04 0.00 0.00 39,650.00 29,650,00 1,809.38 1,809.38 7.34 22,890.62 23,75D.00 1,98D.B0 1,980.80 6.23 22,269.20 5,550.00 346.30 396.30 6.29 5,203.70 93,550.00 3,315.77 3,315.77 7.61 90,239.23 8,200,00 2,029.00 2,029.00 29.74 5,171.00 487,5DD.00 24,839.10 24,839.10 5.D9 962,665.90 34,550.00 27.27 27.27 0.08 34,522.73 3,150.00 D.OD 0.00 D.DO 3,150.00 73,800.00 144.79 1D4.74 0.19 73,695.26 111,500.00 132.01 132.D1 0.12 111,367.99 3,90D.00 29.74 29.74 0.76 3,870.26 10D.oo o.oo o.oa o.ao 14o.Do 3,350.00 D.00 D.00 0,00 3,350.OD 25,850.00 6,16D.25 6,16D.25 23,83 19,689.75 27,2ao.DO o.0o D,oD o.o0 27,20D.Do 9,040.00 0.00 0,00 0.00 4,DDO.OD 2-09-2010 12:41 PM CITY OF ELK RIVER PAGE; 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2010 101-GENERAL FUND Culture & Recreation DEPARTMENTAL, EXPENDITURES 08.330 Off' YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE 101-4-511D--9404 Equip Repair/Maim Services 11,7D0.00 0,00 D.00 0.00 11,700,00 101-9-5110-9409 Contractual Services 7,100.00 O.OD 0.00 D.00 7,100,00 101-9.5110-9415 Equipment Rental 24,500.00 376.20 376.2D 1.54 24,123.80 101-4-51109960 Equip Replacement Charge 6D,450.00 5,037,50 5,037.50 8.33 55,412,50 TOTAL Other Services & Charges 168,150.00 11,603.69 11,603,69 6.90 156,546,31 TOTAL Parks Department Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-4103 Part time Pay 101--95210-4104 PERA 101-4-5210--4105 FICA 101-4-521D-4107 Medicare 101-9-5210-4108 Insurance 101--9-~521D-91D9 Workers Comp TOTAL Personal Services Supplies 101-9-5210-9219 Operating Supplies TOTAL Supplies Other Services & Charges 1D1- 9 5210-4321 Telephone 7 0~.--4-~52~.D--4322 Postage 101-4-521.D--4331 Travel, Conferences & Schools 101-9-5210-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-9389 Utilities 101--4-521.0--9401 Bldg Repair/Maim Services 101-4-5210-4404 Equip Repair/Maim Services 101-9-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges 767,150.00 36,569,80 36,569.80 4,77 730,58D.20 338,400,00 14,000,63 14,000.63 9.14 329,399.37 20,850.00 882,20 882,20 9,23 19,967.80 25,150.00 1,860,36 1,860.36 7,90 23,289,64 22,300.D0 1,585.57 1,585,57 7.11 20,714,43 5,200,00 370,$0 370,80 7,13 4,829,20 38,350,00 3,108,07 3,108.07 8.10 35,291.93 3,400.00 844.75 849,75 29.85 2,555,25 953,650.00 22,652.38 22,652.38 9.99 430,997.62 13,700.D0 372.13 372,13 2.72 13,327,87 13,700,00 372.13 372.13 2.72 13,327.87 9,800.00 198,63 14$,63 3.10 4,651.37 6,000,00 0,00 0.00 O.OD 6,D00.00 6,950.00 26.00 26,OD 0.37 6,924,00 26,400.00 O.DD D.DO 0.00 26,900.00 1,550.00 339,25 339,25 21,56 1,215,75 7,80D,00 0,00 0.00 0.00 7,800.00 12,850,00 869.73 864,73 6,73 11,985,27 7,950.00 480.94 480.94 6.05 7,969.06 1,650.OD D.00 D.00 O.DD 1,65D.00 75,95D.00 1,854.55 1,859,55 2,44 74,095,45 TOTAL Parks & Rec Admin Recreation Programs Personal Services 1D1-4-5220-4102 Overtime Pay 101-4-5220-4103 Part-time Pay 1D1.--9-5220-4104 PERA 101--4--5220-4105 FICA 101.--4--5220--4107 Medicare TOTAL Personal Services 543,300.00 29,879.06 29,879.06 9.58 518,920.94 D.00 45,00 95,00 0.00 ( 45.OD~ 80,000,00 1,482,44 1.,482,94 1.85 78,517,56 2,200,00 83,32 83.32 3.79 2,116,68 9,250,00 172,64 172,69 4.06 9,077.36 1,150,00 40,37 40,37 3.51 1,109.63 87,600.00 1,823.77 1,823,77 2.08 85,776,23 2-09-2010 12;91 PM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ET,K RIVER REVENUE & EXPENSE REPORT (UNAUDITEDy AS OF; ~7ANUARY 31ST, 2010 PAGE: 23 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET aALANCE Supplies 101-9--5220-4219 Operating Supplies 25,550.OD D.DO 0.00 0.00 25,550.OD TOTAL Supplies 25,55D.DD 0.00 0.00 0.00 25,550.00 Other Services & Charges 101-9-5220-9404 Equip Repair/Maint Services 400.OD 0.00 0.00 D.OD 400.00 101-4-5220--9909 Contractual Services 59,200.OD 3,075.OD 3,075.00 5.67 51,125.D0 1D1-~9--5220-9912 Building Rent 2,500.04 O.OD 0.00 0.00 2,500.00 101-9-5220-9938 Credit Card Fees 3,30D.OD 0.04 0.00 D.OD 3,300.00 TOTAL Other Services & Charges 6D, 900.00 3,D75.44 3,075.00 5.09 57,325.00 TOTAL Recreation Programs 173,55D.00 9,898.77 9,898.77 2.82 168,651.23 Concessions Personal Services 101--9--5230--9103 Pant-time Pay 3, 650. DD 101--9M5230-4109 PERA 150.40 101-9-5230-4105 FICA 250.00 101-4-5230-4107 Medicare 50.00 TOTAL Person al Services 9,100.D0 Supplies 101-9-5230-9219 Operating Supplies 1,950.00 1D1-9--523 09259 Other Merchandise For Resale 8,204.00 TOTAL Supplies 9,650,40 Other Services & Charges 101-4-5230-99D1 Bldg Repair/Maim Services 100.00 TOTAL Other Services & Charges 10D.00 259.75 259,75 6.98 3,395.25 34.17 39.17 22.78 115.83 37.88 37.88 15.15 212.12 8.86 8.86 17.72 41.14 335.66 335.66 8.19 3,769.34 O.DD 0.00 0.00 1,950,00 0.00 0,00 0.00 8,2DD.D0 0.00 0.00 0.00 9,650.00 o.DO a.DD o.Da 10a.oo TOTAL Concessions Sr Citizen Programs Personal Services 101--9W5510--9101 Regular Pay 101-9--5510-4103 Part-tiime Pay 101-4-5510-9104 PERA 101-9-551D-9105 FICA 101-9-551D-9107 Medicare 101-9-5510-4108 Insurance 101-9-5510-9109 Workers Comp TOTAL Personal Services 13,850.00 335,66 335.55 2.92 13,519.39 56,300.00 2,337.28 2,337.28 4.15 53,962.72 59,200.00 2,583.39 2,583.34 9.36 56,616.66 8,100.D0 612.94 612,99 7.57 7,987.D6 7,200.00 515.30 515.30 7.16 5,689.70 1,700.00 120.53 120.53 7.09 1,579.97 13,000.00 1,080.10 1,080.1D 8.31 11,919.90 900.00 108.75 108.75 27.19 291.25 195,900.OD 7,358.29 7,358.29 5.04 138,541.76 2-09--2010 12:91 PM 101--GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES PAGE : 2 4 08,33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-551.0-9321 Telephone 101--4~-5510µ932Z Postage 101-4-551.0-4331. Travel, Conferences & Schools 101-4-551.0-4361 Insurance 1D1-4-5510-4389 Utilities 1D1~9--5510--94D1 Bldg Repair/Maim Services 101-4-551.0-9909 Contractual Services 1D1-4-551.0-4933 Dues & Subscriptions TOTAL Other Services & Charges 16,1.00,00 ( 569.3&}( 569,36} 3.59- 16,669.35 16,10D.00 ( 569.36}( 569.36} 3.59- 16,669.36 2,4DD.00 221,09 221.09 9.21 2,178.91 2,100.00 5D4.00 50D.00 23.81 1,600.00 2,40D.00 D.OD 0.00 0.00 2,400.OD 1,650.00 373.25 373,25 22.62 1,276.75 11,800.DD D.00 0,00 0.00 11,800.00 11,500.00 529.99 529.99 9.61 10,970.01 8,200.00 131.00 131.00 1.60 8,D69.DD 1,20D.D0 15.00 15.OD 1.25 1.,185.00 41,250.00 1,770.33 1,770.33 4,29 39,479.67 TOTAL Sr Citizen Programs 203,25D.OD 8,559.21. 8,559.21 9,21. 194,690.79 TOTAL Culture & Recreation Economic Development Personal Services 101.4--6210--4101 Regular Pay 101-4--6210--4103 Part-time Pay 101-4-6210-4109 PERA 101-4-6210-4105 FICA 101-9-6210-4107 Medicare 101--9--621. D--4108 Insurance 101-4--6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-9-6210--4331 Travel, Conferences & Schools 101-4-621.0-9361 Insurance 101-4-6210-9490 Miscellaneous TOTAL Other Services & Charges 1,701,100,00 75,292.50 75,292.50 9,42 1,625,857.50 0.00 10,237.90 10,237.90 0.00 { 10,237.90) 0.00 1,050.32 1,D5D.32 D.DD { 1,050.32) 0.00 725,92 725.92 0.00 ~{ 725.92) O.DO 655.91 655.41 0.00 { 655.91) 0.00 153.28 153.28 0.00 { 153.28} 0.00 91.8.01. 918.01 0.00 ( 918,01} 0,00 165.75 165,75 0,00 ( 165,75} 0.00 13,906,09 13,906.09 0,00 ( 13,906.09} 0.00 941.00 941,00 0,00 { 991.00) O.OD 702,75 702.75 0,00 { 702.75) 0.00 ( 23.63){ 23.63) 0,00 23.63 O.DD 1,120.12 1,1.20.12 0,00 ( 1,120.12) TOTAL Economic Development Energy City CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: JANUARY 31ST, 2010 0.00 15,026.21 15,026.21 0.00 ~ 15,026,21) 2--09--2010 12; 41 PM 101--GENERAL FUND Ecanamic Development DEPARTMENTAL EXPENDITURES CITY 0~` ELK RIVER REVENUE & EXPENSE REPORT {UNAUDITED) AS OF: ~7ANUARY 31ST, 2D10 PAGE : 25 08.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Personal Services 101--4--6220--4101 Regular Pay 24, 550.00 1, 056.95 1, 056.95 4 , 31 23, 4 93 , 05 101-4-6220-4104 PERA 1,700.00 136.02 136.02 8.OD 1,563,98 101-46220-41D5 FICA 1,500.00 99.22 94.22 6,28 1,405.7$ 101-4-622D~-4107 Medicare 350.00 22,04 22.D4 6,30 327.96 101-4-6220-4108 lnsurance 3,250,00 3D7,61 307,61 9.46 2,942,39 TOTAL Personal Services 31,35D.OD 1,616.84 1,616.84 5,16 29,733,16 Other Services & Charges 101-4-6220-9319 Other Prafessianal Services S,ODD.OD 0.00 0.00 O,OD 5,000.00 101-4--6220-4331 Travel, Conferences & Schools 12,5DD.Ofl { 1,175,00}( 1,175.00} 9,4D-- 13,675,00 101-4-6220-4359 Publishing 2,50D.00 D.DO 0,00 0.00 2,500.00 TOTAL Other Services & Charges 20,000.00 ( 1,175,00}( 1,175,00} 5,88- 21,175.DD TOTAL Energy City 51,350,00 441.84 441,$4 0.$6 50,908.16 TOTAL Economic Development 51,350,00 15,468,05 15,468,05 30.12 35,881,95 Transfers Out Transfers Out 1D1-4-7000-4723 Transfer--Ice Arena 126,60D.DD 0.00 O.DO 0,00 126,60D.00 101-4--7000--4724 Transfer ~ Pinewood 37,950,00 O,OD 0.00 O.DO 37,450.00 TOTAL Transfers Out 164,05D.00 0,00 D.00 O.DD 164,050.00 TOTAL Transfers Out 164,050.00 0.00 0.00 D.DO 164,050.00 TOTAL General. 164,050.00 0.00 D.DD 0.00 164,05D.00 TOTAL EXPENDITURES 12,049,800.00 597,707.79 597,707.79 9,96 11,447,092.21 REVENUES OVER/{UNDER} EXPENDITURES { 325,000.00-{ 559,844,57}{ 559,844.57} 234,844.57 2-D9-2410 12:91 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; JANUARY 31ST, 2D10 221-ICE ARENA FINANCIAL SUMMARY 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY rce Arena 656,050.00 16,259.87 16,259,87 2,48 639,790.13 Hockey 60,OOO.OD 2,460,D0 2,960.00 4.10 57,540.00 Skating 75,650.00 3,445.00 3,445.D0 4.55 72,205.00 Concessions 67,750.00 13,759.25 13,754,25 20.3D 53,995.75 TOTAL REVENUES 859,95D.D0 35,919.12 35,919.12 9.18 $23,530.88 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 799,9DO.D0 18,521,36 18,521.36 2.49 726,378.64 Hockey 28,200.00 0.00 O.DD O.DD 28,200.OD Skating 35,500.00 347.29 347.29 0.98 35,152.71 Arena Concessions 50,850.00 1,951,32 1,951.32 3,84 48,898.68 TOTAL Culture & Recreation 859,450.00 20,819.97 20,819.97 2,42 838,630.03 TOTAL EXPENDITURES 859,450.00 20,819.97 20,819,97 2,92 838,630.D3 REVENUES OVER/(UNDER) EXPENDITURES 0.00 15,D99.15 15,099,15 ( 15,099.15) 2.09-20.0 12;91 PM CITY OF ELCi RIVER PAGE: 2 REVENUE & EXPENSE REPORT UNAUDITED} AS Off': ~7ANUARY 31ST, 2010 221-ICE ARENA REVENUES 08.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges far Services 221-3-0000-3464 Ice Rental 221--3--0000-3465 Admissians 221-3-0000-3466 Dry Floar Events 221-3-0000-3468 Skate Sharpening 221-3--0000-3475 Building Rent 221w3-0000-3482 Advertising fee TOTAL Charges far Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue mransfers In 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Ice Arena Haclcey Charges for Services 221--3--5410-39 61 Recreation Fees TOTAL Charges for Services 449,800,00 2,063.00 2,063.00 0,46 947,737,00 22,550.00 11,297,00 1.1,297.00 50,10 11,253.00 12,000.00 0.00 O.DD 0.00 12,000,00 4,800.00 974.00 979.00 20,29 3,826,00 2,600.00 0,00 O.DD O.OD 2,600.00 17,000.00 0.00 O.DO 0.00 17,000.00 508,750.00 14,339.00 14,334,00 2,82 494,916.00 18,700.00 1,677,1.2 1,677.12 8.97 17,022,88 2,000,00 248,75 248.75 12,44 1,751.25 20,700.00 1,925.87 1,925,87 9.30 18,774,13 126,600,00 D.DD 0.00 O.OD 126,600.00 126,600,00 0.00 0.00 0.00 126,600,00 656,050.00 16,259.87 16,259,87 2,48 539,790,13 60,000.00 2,460.00 2,460.00 4,10 57,540.00 60,000.00 2,460,00 2,460.00 4,10 57,590.00 TOTAL Hockey Skating 60,000.00 2,460,00 2,960.00 4.10 57,540.00 Charges for Services 221-3-5420-3461 Recreation Fees 70,000.00 3,445,00 3,495,00 4.92 66,555.00 221-3-5420-3465 Admissions 3,500,00 O.DO 0,00 0,00 3,500.00 TOTAL Charges far Services 73,500.00 3,445,00 3,995.00 4,69 70,055.00 2-09-203.0 12;91 PM CrTY OF ELK RrVER PAGE; 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; JANUARY 31ST, 2010 221-ICE ARENA REVENUES 08.33% 0~' YEAR COMP, CURRENT CURRENT YEAR TO DATE % OE ~3UDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5920-3529 Miscellaneous Revenue TOTAL Other Revenue TOTAL S~Cating Concessions Charges far Services 221--3-5930---3967 Concessions TOTAL Charges for Services 'T'OTAL Concessions 2,150.04 0.00 O.DO 0.00 2,150.00 2,150.00 0,00 0.00 0.00 2,150.00 75,650.00 3,995.00 3,445,00 4.55 72,205,00 67,750.00 13,754.25 13,759,25 20,30 53,995.75 67,750.00 13,759.25 13,754,25 2D.30 53,995,75 67,750.00 13,759.25 13,754.25 20.30 53,995.75 TOTAL REVENUE 859,450.00 35,919.12 35,919.12 4,18 823,530.88 2~D9~2010 12:41 PM CTTY OF ELK RxVER PAGE: 9 REVENUE & EXPENSE REPORT {UNAUDITED) AS OF; JANUARY 31ST, 2010 221~ICE ARENA DEPARTMENTAL EXPENDITURES D8.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 2219-54004102 Overtime Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221~9~5400~4107 Medicare 221-4-5900-9108 Insurance 221-9-5900-9109 Workers Comp TOTAL Personal Services Supplies 221-9-5400-9212 Fuels & Lubs 221~4~5400~4217 Uniform Allowance 221-95400-9219 Operating Supplies 221-9-5400-4255 Soft Drinks/Misc 221-9-5900-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-59D0-4321 Telephone 221-9-59D0-4322 Postage 221~4~5440~4331 Travel, Conferences & Schools 221-9-5900-9359 Publishing 221-9-5400-4361 Insurance 221-9-5400-93$9 Utilities 2219-5900W4401 Bldg Repair/Maim Services 221W4~5400-4409 Contractual Services 221-9-5900-9915 Equipment Rental 221-4-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay Transfers Out 221W9W5400~4730 Transfer-Debt Service TOTAL Transfers Out 148,700.00 5,676.86 5,676,85 3.82 143,023.19 D.00 35.6D 35.60 0.00 { 35.6D) 73,90D.00 5,078.35 5,078.35 6.87 68,821.65 11,754.40 1,D83.76 1,063.76 9.22 14,6b6.24 13,8D0.00 1,202.29 1,2D2.29 8.71 12,597.76 3,250,00 281.19 281,19 8.65 2,958.81 17,450.00 1,594.01 1,594.01 9.13 15,855,99 4,750.OD 1,249.04 1,299.DD 26.29 3,5D1.00 273,600.DD 16,2D1.01 1&,201,01 5,92 257,398.99 350.OD 0.00 D.DD 0.00 350.00 1,OOD.DO D.04 D.OD O,DO 1,DD0.00 91,450.00 109.79 1D4.74 0.25 91,345.26 9,ODD.00 O.DO 4.D0 0.00 9,DOD.00 900.OD D.00 O.DO 0.00 900.00 52,740.DD 104.74 1D9.74 0.20 52,595,26 3,300.00 192,11 192.11 4,31 3,157,89 600,00 0.00 O.OD 0.00 600.OD 1,D5D.00 O.OD 0.00 D.00 1,D5D.OD 2,800.40 O.DO 0.00 0.00 2,800.OD 8,70D.04 1,933.50 1,933,50 22,22 5,766.50 175,900.DD D.00 O.DD O.DO 175,900.00 20,2DO.D0 0.40 0.00 0.00 20,200,OD 1,1DO.D0 0.00 0.00 0.00 1,100.00 9,600.D0 D.00 0.04 O,DD 4,600.00 950.00 190.00 140.00 31.11 310.D0 218,700.00 2,215.61 2,215,61 1.01 216,989,39 199,900.00 0.00 D.DD 0,00 199,9DD.OD 199,900.DD 0.00 D.DO O.DD 199,9DD.00 TOTAL Ice Arena 794,900.40 18,521,36 18,521,36 2.49 726,378,64 2-o9-2D~D 12;41 PM 221-zCE ARENA Culture & Recreation DEPARTMENTAL EXPENDrTURES CITY OF ELK RxVER REVENUE & EXPENSE REPORT (UNAUDITED) AS a~: JANUARY 31ST, 2D10 PAGE; 5 08.33% 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,60D.00 O.DO O.DO 0.00 3,600.OD 221-~4~-541.0--4105 FICA 25D.D0 0.00 O.DO 0.00 25D.04 221-4-591.0-41D7 Medicare 50.00 0.00 O.DD O.OD 50,00 TOTAL Personal Services 3,9DO.D0 D.04 O.OD O.OD 3,900,00 Supplies 221-4-5910-9219 Operating Supplies 15,250.00 0.00 0.04 0.00 15,250.00 TOTAL Supplies 15,250.00 D.40 D.OD 0.00 15,250.OD Other Services & Charges 221-4-5910-9322 Postage 50.00 D.00 O.DD 0,00 50.OD 221-4-~541D~-4359 Publishing 500.00 O.OD 0.00 0,00 5fl0,OD 2214-541.0--4409 Contractual Services b, 304.00 O.DO D.DO 0.00 6,30D.00 221-4-5410-4938 Credit Card Fees 2,200.DD 0.00 O.OD O.DD 2,200.00 TOTAL Other Services & Charges 9,050.OD O.DO 0.00 4.00 9,D5D.D0 TOTAL Hockey 28,240.00 0.00 0.00 0.00 28,200.00 Skating Personal Services 224.--45920-9103 Part-time Pay 20,000.00 297.19 297.19 1.99 19,702,81 221-4--5420.4109 PERA 1, OOD.00 11.52 11.52 1.15 988.48 221-4-5920-4105 P'7CA 1,250.OD 31.27 31.27 2.50 4.,24.8.73 221-4-5420-4107 Medicare 300,00 7.31 7,31 2,44 292.69 TOTAL Personal Services 22,550.00 397.29 397.29 4.,54 22,202.71 Supplies 221-4-5420-4219 operating Supplies 6,900.00 0,00 D.DO 0.00 6,900.00 TOTAL Supplies 6,900.00 D.DO 0.00 0.00 6,900.DD other Services & Charges 221-9-5420-4359 Publishing 5D0.00 D.00 0.00 0.00 5DO.OD 7.21-4-5920-9409 Contractual Services 2,550.00 0.00 O.DO D.00 2,550.00 221-4--542D--4438 Credit Card Fees 3,000.DO O,OD 0.00 0,OD 3,ODD.40 TOTAL Other Services & Charges 6,D5D.D0 0,00 0.00 0.00 6,050.00 TOTAL Skating 35,500.00 397.29 347.29 0.98 35,152.71 2-09-zD1D 12;91 PM 221--ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT UNAUDITED) AS OF; ~7ANUARY 31ST, 2010 PAGE; 6 08.33a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions ------------------- -------------------- Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 1,718,25 1,71.8.25 8.22 19,181.75 221-4-543D-4109 PERA 200.00 9$.78 48.78 29,39 151,22 221--9--5930--9105 FICA 1,300.00 199.35 199,35 11.49 1,150.65 221-4-5430-4107 Medicare 300.0D 34.99 34,94 11.65 265.05 TOTAL Personal Services 22,700.D0 1,951,32 1,951.32 8.60 20,798.68 Supplies 221-4-5430-4219 Operating Supplies 7,150,00 D.00 0.00 D.OD 7,150,00 221-4-5930-4259 Other Merchandise Far Resale 21,0DD.0D O.DD O.OD 0.00 21,0D0.0D TOTAL Supplies 28,150.0D 0.00 0,00 O.DO 28,150.00 TOTAL Arena Concessions 50,850.00 1,951,32 1,951.32 3.89 98,898.68 TOTAL Culture & Recreation 859,450.D0 20,819.97 20,819.97 2.92 838,630.03 TOTAL EXPENDITURES REVENUES OVER/UNDER) EXPENDITURES 859,950,00 ---------_.~~.- ~ 0.00 20,819,97 __~~~m.~----- - 15,099.15 20,$19.97 -------~_~-~ _ 15,099.15 2.92 838,630.03 ~_~.~~~ -------------- ( 15,099.15 2-09-2010 12;41 PM 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT tUNAUDITED) AS OF; JANUARY 31ST, 2010 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 8.33s o OF BUDGET PAGE; 1 F YEAR COMP. BUDGET BALANCE REVENUE SUMMARY Pinewood Go1~ Course 238,450.00 0.00 0.00 0.00 238,950,00 TDTAL REVENUES 238,45D.D0 0.00 D.DO D.00 238,45D.D0 EXPENDITURE SUMMARY Culture & Recreation Galt Course 238,950.00 8,153.86 8,153.86 3.42 230,296,19 TOTAL Culture & Recreation 238,450.OD 8,153.86 $,153.86 3.92 230,296.19 TOTAL EXPENDITURES 23$,950.00 8,153.86 8,153.$6 3.42 23D,296.14 REVENUES OVER/(UNDER) EXPENDITURES 0,00 { 8,153.86)t 8,153.86) 8,153.86 2-09-2010 12:41 PM CITY OF ELK RIVER PAGE; 2 REVENUE & EXPENSE REPORT {UNAUDITED AS OF: JANUARY 31ST, 2010 222-PINEWOOD GOLF COURSE REVENUES 0$.33% OF YEAR CAMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course Charges for Services 222-30000-3961 Recreation Fees 222-3-0000-34 b7 Concessions 222-3-0000-3959 Other Sales 222- 3 0000-3975 Green Fees 222-3-0000-3977 Membership Fees 222-3-0000-347$ Golf Cart Rental 222~3~pODDW3979 Tournaments 222~3MDOD0-3482 Advertising fee TOTAL Charges for Services Other Revenue Sales Transfers rn 222-3-GOOD-3922 Txansfer-General Fund TOTAL Transfers Tn TOTAL Pinewood Golf Course 22,000.00 O.OD O.DO O.DO 22,000.00 19,000.00 0.00 0.00 0.00 19,000,00 5,000.00 0.00 0.00 O.DO 5,000.00 115,000.00 O.DO 0.00 O.OO 115,000.00 19,000.00 O.OD O.DO 0.00 19,000.00 18,500.00 0,00 0.00 0.00 18,500.00 7,000.00 0.00 0.00 0.00 7,000.00 SDO.D0 0.00 0.00 O.OD 500.00 201,000.00 0.00 0.00 0.00 201,000.00 37,450.00 0.00 0.00 0.00 37,450.00 37,450.00 0.00 0.00 0.00 37,950.00 238,950.00 0.00 O.DD 0.00 238,950.00 TOTAL REVENUE 238,450.00 0.00 0.00 0.00 238,950.00 -~m-~---T---- ------------- ------------- ------- W--_-~~_-~-~_ --T-~--~T---- ------------- ------------- ------- -~-~W~~~---W- 2-09-2010 12:91 PM CITY OF ELK RIVER PAGE; 3 REVENUE & EXPENSE REPORT ,UNAUDITED AS OF: JANUARY 31ST, 2010 222~-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES 08.330 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGBT PERIOD ACTUAL BUDGET BALANCE Galf Course Persanal Services 222-4-5300-4101 Regular Pay 91,550.00 2,410.77 2,410.77 2,63 89,139.23 222-4-5300-4103 Part-time Pay 28,900.00 19,68 19.68 0.07 28,880.32 222-9--53004109 PERA 6, 950.00 312.51 312.51 3.70 8,137.99 222-9-5300-4105 FICA 7,450.00 275.75 275.75 3.70 7,179.25 222-9-5300-4107 Medicare 1,750.00 64.49 b4.49 3.69 1,685.51 222--9~530D--4108 Insurance 11,050,00 449.01 499,01 4.06 10,600.99 222-4--5300-4109 Workers Comp 1,250.00 311.25 311.25 24.90 938.75 TOTAL Personal Services 150x400.00 3,843.46 3,843.46 2.56 146,556.54 Supplies 222-4-5300-423.2 Fuels & Lubs 5,000.00 222-9-5300-9217 Uniform Allowance 500.00 222--9-5300-9219 Operating Supplies 25,bD0.00 222-~4--5300-4259 Other Merchandise Far Resale 19,000.00 TOTAL Suppli es 95,100.00 Other Services & Charges 222--9--5300.4321 Telephone 3,100, OD 222-4-5300-4331 Travel, Conferences & Schools 500.00 222-4-5300-4349 Advertising/Marketing 1,oao.oo 222--4-53Q0-9361 Insurance 11,850.00 222.4--5300--4389 Utilities 7,150.00 222-4-5300-4401 Bldg Repair/Faint Services 1,000.00 222-9-5300-4404 Equip Repair/Maint Services 2,500.00 222-9-5300-4415 Equipment Rental 2,000.00 222~9~-530D--4437 Taxes & Licenses 850.00 222.4-5300--4938 Credit Card Fees 4, 5DD . DO TOTAT~ Other Services & Charges 34,450.00 Debt Service 222--9~-530Q--9601 Principal 8x 500.00 TOTAT~ Debt Service 8,500.00 0.00 0.00 0.00 5,000.00 0.00 0.00 0.00 500.00 280,89 280,89 1.10 25,319.11 0.00 O.QO O.DO 14,DOO.QO 280.89 280.89 0.62 94,819.11 195.51 145.51 4,69 2,954.99 0.00 0.00 0.00 500.00 o , oa o , o0 0.00 1, 000.00 2,581.00 2,581.00 21.78 9x2b9.00 D.DO D.DO 0.00 7x150,00 0.00 0.00 O.QD 3.,000.00 905.00 905.00 36.20 1x595.00 D.ao o.aa o.on 2x000.00 398.00 398.00 46.82 452.00 0,00 0.00 D.DO 9x500.00 9,029.53. 9,029.53. 13.,70 30,420.49 0.00 0,00 D.DO 8,5DQ.00 0.00 0.00 0.00 8,500.00 TOTAL Gaff Course 238,950.00 8,153,86 8,153,86 3,42 230x296.19 TOTAL Culture & Recreation 238,950.00 8,153.86 8,153.86 3.42 230,296.14 TOTAL EXPENDITURES 238,450,00 8,153.86 8,153,86 3,92 230,296.14 REVENUES OVER/UNDER) EXPENDITURES Q.00 ( 8x153.86)( 8x153.86) 8x3.53.86 2-09-201D 12:43 PM E'UND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE ACTZVZTY PAGE; 1 CURRENT BALANCE 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - - Library 221-1010 Cash - ice Arena 222-1010 Cash - Pinewood Golf Course 223--10~ 0 Cash - - Sr Citizen Account 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - - Landfill Const Debris 240-1010 Gash ~ M~.cro Loan Fund 291-1010 Cash - DIED Loan 245--1010 Cash - Development Fund 290--10~.p Cash - - Capital Outlay Reserve 291-1010 Cash - insurance Reserve 292-101D Cash - Govt Bldgs Reserve 299--1010 Cash - Drug Forfeiture 295-1010 Cash ~ Severance Pay Reserve 296-1010 Cash - NSP/RDF Reserve 311-1010 Cash - 2003A GO Bonds 31.2--~.p1Q Cash - 2pp5A GO Bonds 313-7.010 Cash - - 20p7C GO Bonds 333-1010 Cash - 2002A Pub Safety Bands 340-1010 Cash - Eguip~nent Certificates 901--1010 Cash - Capital Projects 403-1010 Cash - - Street Improvement Resr 404-1010 Cash - Surface Water Managemnt 405-1010 Cash - NE Area Trunk Utilities 406--1010 Cash - City Wide Trunk Util 410-1.010 Cash -- Equipment Replacement 426-1010 Gash - - YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash - Park Tmprovement 959--1010 Cash - TIF #19 Highway 1&9 462--1010 Cash -- TIF #22 Dawntawn Redev 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605--1010 Cash - Garbage 801-1.010 Cash -~ Interest 821-1010 Cash ~ Developer Escrow TOTAL CLAIM ON CASF-i CASH TN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED TNVESTMENTS SUBTOTAL CASH TN BANK - POOLED CASH CITY OF ELK RIVER POOLED CASH REPORT {FUND 999} AS OF; JANUARY 31ST, 2010 25,191.49 ( 3,163.11} 22,028,33 5,942,093,99 { 705,041.76} 5,237,051.73 909,902,07 ( 3,456.70} 406,445.37 ( 143, 313.94 } ( 6, 357.50 } ( 14 9, 671.44 } ( 59,015,07} ( 12,1$5.30) ( 66,200.37} 9,907,53 132.32 10,039,85 { 183,942,91} 3,692.00 ( 180,300,41} 1,175, 319.93 { 1p, 567.18 ~ 1,164, 652 , 75 674,774,65 0.00 674,774.65 848,662.09 4,339.22 852,996.31 201,492.91 4,828,D4 206,320,95 141,853,28 9,924,40 146,277.68 1,339,615.67 ( 1,733.94} 1,332,882.23 425,789,78 76,850.75 502,640.53 2,429,942.46 68,370.10 2,497,812,56 1,530.92 ( 1,296.98} 234,44 190,427,44 0.00 140,927,44 640,531.18 306,905.68 947,436.$6 177,220.13 1,727,53 17$,997,65 231,$12.31 2,420.21 234,232.52 599,998,00 8,010.97 552,508,97 634,403.88 { 458,751.62) 175,652.26 343,189.70 { 335,440.58} 7,749.12 2,924,690.79 ( 9,788.39} 2,414,902.45 2,779,603.18 14,41.5.03 2,794,018,21 294,581.96 3,432.60 298,019.56 270,753.05 0.00 270,753,05 3,532,115.09 1,880,65 3,533,995,79 1, 087, 977 , 23 71.,1.79.34 1.,158, 656.57 1,,569,221,43 O.OO 1,569,221,43 ( 77,028.47) ( 19,659,83] ( 96,688.3D} 79,674.24 { 976,98} 78,697,2& 541,632,19 3,119,23 549,751,42 535 . op ( 535 . oo } o . o0 3, 959,1.7.5.60 52, 507 , 53 4, 011, 623.13 3,837.,100,66 ( 115,584.65} 3,715,516,01 349,956,89 ( 7,504.55} 392,452,34 0,00 85,1.75.68 85,1.75.58 49,81.5.38 1,915,48 46,730,86 36, 639, 631.66 ( 97 b, 871.26 35, 662, 760, 4p 13,518,671,92 ( 199,760.91} 13,318,911.01 { 9,940,835.43} ( 777,110.35} (10,717,995,76} 33,061,795.17 0,00 33,061,795,17 36, 639, 631.66 ( 976, 871,26} 35, 662, 760,40 i , .~ fr s, ri t ~ c, ~ 4'~~ ~ fr <~~ ; LI ~r = f~