Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 02-21-2012
INFORMATION V~'~` MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: February 21, 2012 SUBJECT: January 2012 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and 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 January, actual revenues (except fox property taxes and state aids) and expenditures should run slightly over 8% of the annual budget. It is natural for some of the items to vary .from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget axe highlighted below accompanied with a general discussion for the variance. General Fund Kevenues: • Property taxes, our largest revenue source, will be received in July and December. • The first half state-aid street maintenance payment was received in January, and the second half will be received in July. • Charges for services revenue includes the semi-annual billing for school liaison services and the fire contract with the City of Otsego. • Contributions include the $14,000 donation by The Bank of Elk River for the 2012 parks and recreation programs. • The negative interest income is related to the reversal of the prior year's interest receivable which was done as of January. • The transfers in will be recorded mid-year. Expenditures: • Excluding transfers, the total departmental expenditures are under 4.5% and most departments axe well within or below budget. • Many departments' expenditures include the first quarter allocation of insurance and annual software maintenance agreements, as is the case for Mayor & Council and Police Administration. • The transfers out to Pinewood Golf axe made at the end of the year. Ice Arena Fox January, revenues exceeded expenditures by $20,890. Revenues are about 9.5% of budget due mainly to ice rental, hockey admissions and concessions while expenditures axe slightly over 3% attributable mainly to personal services. Pinewood Golf Revenue collections consist of league registrations but most of the golf revenues will not be generated until spring. Expenditures are slightly over 3% of the budget due mainly to personal services and insurance. 2-14-2012 08:17 AM ___ ,_, i.F t-- ___.I CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE, RE PORT (UNAUDITED) ~ ~ F 4 RMpT 1 4 N AS OF: ,'=~N ;7_'-`_PY °1~T, "'C 1~ .,_.__~ ~- :~-gin COMP. ~~RRE?~T ....~nKEIv.T ~ _. ~ J=-TF e Or ~ DG__ 31_ 9C2 00 6 __ ,6 _ __,C _ 9r vc _ral _:nd , . _ TOTAi REJENUES 12,31',90C.00 ?97,6.0.04 ^_97,640.04 ..42 _.',014,259.96 EXPENDITURE SUMMARY General Government Mayor & Council 172,25C.00 17,677.13 17,677.13 10.26 154,572.87 Cable TV 86,600.00 3,704.05 3,704.05 4.28 82,895.95 Administrative Services 482,950.00 27,497.08 27,497.08 5.69 455,452.92 Human Resources 164,500.00 9,498.52 9,498.52 5.77 155,001.48 Elections 38,050.00 0.00 O.CO 0.00 38,050.00 Finance 464,450.00 28,133.16 28,133.16 6.06 436,316.84 Information Technology 242,000.00 8,255.51 8,255.51 3.41 233,744.49 Legal 228,000.00 0.00 0.00 0.00 228,000.00 Community Development 69,250.00 3,181.98 3,181.98 4.59 66,068.02 Planning 304,700.00 13,994.57 13,994.57 4.59 290,705.43 City Hall Maintenance 304,150.00 13,217.35 13,217.35 4.35 290,932.65 Contingency 241,550.00 0.00 0.00 0.00 241,550.00 TOTAL General Government 2,798,450.00 125,159.35 125,159.35 4.47 2,673,290.65 Public Safety Police Administration 565,500.00 54,490.37 54,490.37 9.64 511,009.63 Patrol 2,350,050.00 102,562.38 102;562.38 4.36 2,247,487.62 Investigations 764,750.00 34,148.14 34,148.14 4.47 730,601.86 Police Support Services 503,500.00 20,920.92 20,920.32 4.15 482,579.68 Police Reserves 18,900.00 0.00 0.00 0.00 18,900.00 Public safety building 210,150.00 10,471.44 10,471.44 4.98 199,678.56 Fire Administration 555,500.00 18,994.00 18,994.00 3.42 536,506.00 Fire Inspections 188,000.00 8,917.99 8,417.49 9.48 179,582.51 Emergency Management 103,900.00 505.70 505.70 0.49 103,394.30 Building Safety 473,350.00 21,472.08 21,472.08 4.54 451,877.92 Environmental 48,850.00 2,382.81 2,382.81 4.88 46,467.19 TOTAL Public Safety 5,782,950.00 274,364.73 274,364.73 4.74 5,508,085.27 Public Works Street Maintenance 1,505,300.00 40,691.88 40,691.88 2.70 1,464,608.12 Snow Removal 288,400.00 9,923.38 9,923.38 3.44 278,476.62 Equipment Services 247,900.00 10,258.81 10,258.81 4.14 237,691.19 Engineering 133,550.00 5,357.94 5,357.94 4.01 128,192.06 TOTAL Public Works 2,175,150.00 66,232.01 66,232.01 3.04 2,108,917.99 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS 0~ ; JLl`it.nR',, ?1C'j', ^n~ ^ .l'_v_-_v ~._-~ .. .._~..-_KY _tnre & Retreat-o-! _ar}.s Department Parts & Rec h.~. __ Recreation Progra.-ns Concessions Sr Citizen Programs ^OTAL Culture & Recrea*_lon Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 3UD2=_ PE =.-O= --`-~-- 3~DGE= B=~-*1C_ ci: .,..._.. 3', ._ r3,-97.c, 4.03 _,602.,., ..i ,_..~.~_ i -a. _.~ 26, ~ri4.~J z.,,_ ,. ~, SJ __-,0~_. 1 91.~~ _, -.__ ~.~- 1,,608.76 i~,_OC.00 _r'.39 16.39 0.12 '_~,0~3.61 226,500.00 ,936.18 7,936.18 _~.50 218,563.82 1, 830,650.00 68,,05.53 68,705.53 ..75 _,761,9c4_e7 0.00 15,662.74 15,662.74 0.00 ( 15,662.74) 50,850.00 1,697.35 1,697.35 3.34 49,152.65 50,850.00 17,360.09 17,360.09 34.14 33,489.91 40,500.00 0.00 0.00 0.00 40,500..00 40,500.00 0.00 0.00 0.00 40,500.00 12,678,050.00 ------------- - 551,821.71 ------------ - 551,821.71 ----------- 4.35 ------- 12,126,228.29 ------------- ( 366,150.00)( 254,181.67)( 254,181.67) ( 111,968.33) 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, ~01^ G5 . ~. e ~F =~r_R ~Ob`_= . DURREN..T NRZEN'" - ~.,='_K^0 DATE _ CF 11~DYF_ YL`vF:NJES 3JDGET. PERIOD :_ _?'_L BIIDGET-,.y'1CE ~~_"__al Find ~_e s _._-3-OC-00-3111 Cnrren~ Ad `.'alcrem Tares 9,142,200.00 G.OC C. 00 0.00 _, 42,200.00 =~1-3-0006-3121 Graael Ta_~; 70,000.00 0.70 6.00 0.00 70,000.00 TOTAS~ Taffies 9,212,206.00 O.OC 0.00 0.00 9,212,200.00 icenses Permits 101-3-0000-3211 Liquor License 53,000.00 2,165.00 2,165.00 4.08 50,835.00. 101-3-0000-3212 Amusement License 1,000.00 0.00 0.00 0.00 1,000.00 X01-3-0660-3213 Cigarette License 3,000.00 0.00 0.00 0.00 3,000.00 i01-3-0600-3214 Apartment License 17,000.06 2,535.00 2,535.00 14.91 14,465.00 101-3-0000-3216 Mining License 20,000.00 0.00 0.00 0.00 20,000.00 161-3-0000-3217 Garbage Hauler License 2,100.00 345.00 345.00 16.43 1,755.00 101-3-0000-3218 Other Business License/Permit 17,000.00 4,135.00 4,135.00 24.32 12,865.00 101-3-0000-3229 NPDES Permit 2,500.00 175.00 175.00 7.00 2,325.00 101-3-0000-3231 Building Permit 153,000.00 4,057.15 4,057.15 2.65 148,942.85 101-3-0000-3232 Plumbing/Heating Permit 129,150.00 4,323.96 4,323.96 3.35 124,826.09 101-3-0000-3233 Permit Surcharge 400.00 346.77 346.77 86.69 53.23 101-3-0000-3235 Animal License 3,500.00 552.00 552.00 15.77 2,948.00 101-3-0000-3236 Parking Permit 3,000.00 110.00 110.00 3.67 2,890.00 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 20.00 20.00 0.25 7,980.00 TOTAL Licenses & Permits 412,650.00 18,764.88 18,764.88 4.55 393,885.12 Intergovernmental Rev 101-3-0000-3311 Federal Grant 101-3-0000-3324 PERA Aid 101-3-0000-3325 Police 2~ Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3327 State-Aid Street Maint 101-3-0000-3329 State Crime Prevention Grant 101-3-0000-3330 Other State Grants TOTAL Intergovernmental Rev 3,000.00 0.00 0.00 14,000.00 0.00 0.00 205,000.00 0.00 0.00 12,000.00 0.00 0.00 275,450.00 140,991.02 190,991.02 30,000.00 0.00 0.00 3,000.00 0.00 0.00 542,450.00 190,991.02 140,991.02 0.00 3,000.00 0.00 19,000.00 0.00 205,000.00 0.00 12,000.00 51.19 139,458.98 0.00 30,000.00 0.00 3,000.00 25.99 401,958.98 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 300.00 300.00 2.00 14,700.00 101-3-0000-3413 Plan Check Fee 41,000.00 1,346.50 1,346.50 3.28 39,653.50 101-3-0000-3915 Special Assessment Search 1,000.00 20.00 20.00 2.00 980.00 101-3-0000-3417 Copies 2,500.00 189.00 189.00 7.56 2,311.00 101-3-0000-3418 Other General Govt Services 4,000.00 20.00 20.00 0.50 3,980.00 101-3-0000-3930 Lockout Fees 7,500.00 500.00 500.00 6.67 7,000.00 101-3-0000-3431 Police Services 2,000.00 0..00 0.00 0.00 2,000.00 101-3-0000-3432 School Liaison 75,000.00 37,500.00 37,500.00 50.00 37,500.00 101-3-0000-3934 Animal Impound Fee 3,000.00 395.00 395.00 13.17 2,605.00 101-3-0000-3936 Fire Contracts 199,600.00 87,907.52 87,907.52 44.04 111,692.48 101-3-0000-3937 Fire Calls 4,000.00 0.00 0.00 0.00 4,000.00 101-3-0000-3451 Street Services 35,000.00 0.00 0.00 0.00 35,000.00 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) A~ OF: ~n~rLrpRv 31ST, ^_012 -_-. JC3~- ~- ----'r-___ _ .~ ~_~_c Leisb __--_-OS00-~_6- Rec-~a,c~ -__. _ _-_ ~G00- =_6~ ~~ss ~.~ -- J~ ~-_ _ _~ ~. n~ __~ __-. 6000-~~ -~ _~y ti~ - _~_ 101-3-6000-3c-, ~~-_~~ng 3e-_~ l~,1-~-0000-3=0,< Se -_spe~__on Fee ~01-3-0000-ace= C~i_ra-~._ .ice^a e Check TCT~T Charges for Services -fines Forfei-s 101-3-0000-3510 Court Fines 101-3-0000-3511 FarY.irg Fines 101-3-0000-3512 Ordinance Violations TCT_.~iI: Fines & Forfeits Special Assessments 101-3-0000-3610 Special Assmts-County TOTAL Special Assessments Other Revenue 101-3-0000-3621 Interest Income 101-3-0000-3625 Refunds & Reimbursements 101-3-0000-3626 Contributions 101-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101-3-0000-3921 Transfers 101-3-0000-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-WWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3949 Transfer-Garbage 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund ,_ .33 ~ OF =_~K CONP. ~~R~Eiv?T ~_'RR?F_ 1c.. ~-c ~ ___ a OF ~UDG~T ~?~G~_ P~R_~~ _'-'.CT,._'-_L 3UDGET _ _~.'=.NCE ,_50.00 ~.~., ^_-. 00 G.OC "50.00 1^_9,000.00 10,416.50 1C,~i6.50 8.07 __ _5.50 --,y00.G0 0.00 0.00 0.00 -'.,100.00 17,000.00 400.00 ~G0.00 3.35 16,600.00 5,700.00 2,580.00 2,580.00 45.26 ,20.00 ",400.00 300.00 200.00 8.33 2,200.00 3,000.00 130.00 "130.00 4.33 2,870.00 400.00 15.00 15.00 3.75 385.00 650,350.00 141,919.52 141,919.52 21.82 508,430.48 120,000.00 7,976.10 7,976.10 6.65 112,023.90 12,000.00 3,740.00 3,740.00 31.17 8,260.00 500.00 0.00 0.00 0.00 500.00 132,500.00 11,716.10 11,716.10 8.84 120,783.90 0.00 714.12 714.12 0.00 ( 714.12) 0.00 714.12 714.12 0.00 ( 714.12) 100,000.00 ( 33,425.28)( 33,425.28) 33.43- 133,425.28 66,500.00 111.15 111.15 0.17 66,388.85 25,650.00 15,900.00 15,900.00 61.99 9,750.00 8,000.00 998.53 948.53 11.86 7,051.47 200,150.00 ( 16,465.60)( 16,465.60) 8.23- 216,615.60 122,100.00 0.00 0.00 0.00 122,100.00 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 100,000.00 0.00 0.00 0.00 100,000.00 300,000.00 0.00 0.00 0.00 300,000.00 25,000.00 0.00 0.00 0.00 25,000.00 500,000.00 0.00 0.00 0.00 500,000.00 25,000.00 0.00 0.00 0.00 25,000.00 15,000.00 0.00 0.00 0.00 15,000.00 1,161,600.00 0.00 0.00 0.00 1,161,600.00 12,311,900.00 297,640.04 297,640.04 2.42 12,014,259.96 ~ TOTAL REVENUE 12,311,900.00 297,640.04 297,640.04 2.42 12,019,259.96 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: „'~N~?~RY 31ST, "O1^ __.~3% ..- _~.R COQ~P. .,~K't~7~T .. Y.Z=>\'__ ~L_ K v iJT.T- c v~ ~Du__ 3=IDLE" PE:=01 - _~__'-_i 30DC__ "~iNCE - al Servrces 101-4-1110-4103. Parr-t_me ?ay 101-4-1110-4104 PDT=. 101-4-1_10-4105 FIC~_ 101-4-1110-4107 Medicare 101-a_-1110-4109 Workers Comp TOTAL Persona' Services Saaclies 101-4-1110-4201 Office Supplies TOTAL Sllpp lies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges ,500.00 ,_~-.99 _,207.99 8.33 35,292.01 _,900._0 10_.6" =CT.67 5.35 ,"98.33 2,40G.00 _L1.06 '-ll.06 4.63 2,288.94 550.00 46.51 46.51 8.46 SC3.49 50.00 0.00 0.00 0.00 50.00 43,400.00 3,467.23 3,467.23 7.99 39,932.77 3,200.00 0.00 0.00 0.00 3,200.00 3,200.00 0.00 0.00 O.OC 3;200.00 11,050.00 1,320.00 1,320.00 11.95 9;730.00 400.00 0.00 0.00 0.00 900.00 2,600.00 0.00 0.00 0.00 _ 2,600.00 17,700.00 189.15 189.15 1.07 17,510.85 69,450.00 12,700.75 12,700.75 18.29 56,749.25 16,000.00 0.00 0.00 0.00 16,000.00 8,450.00 0.00 0.00 0.00 8,450.00 125,650.00 14,209.90 14,209.90 11.31 111,440.10 TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-4105 FICA 101-4-1120-9107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 172,250.00 17,677.13 17,677.13 10.26 154,572.87 57,950.00 2,167.20 2,167.20 3.77 55,282.80 6,500.00 210.38 210.38 3.24 6,289.62 4,150.00 311.17 311.17 7.50 3,838.83 3,950.00 261.97 261.97 6.62 3,688.53 950.00 61.15 61.15 6.44 888.85 8,700.00 680.00 680.00 7.82 8,020.00 250.00 0.00 0.00 0.00 250.00 81,950.00 3,691.37 3,691.37 4.50 78,258.63 1,700.00 12.68 12.68 0.75 1,687.32 1,700.00 12.68 12.68 0.75 1,687.32 2-14-2012 08:17 AM ~_ne_~_ ~~ ~__....,.r.t CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JP__TSLLF R.Y 31ST, ^01^ __._.,~ .,- _7AR CON_P. ,....SPE.I':'1 .._KYEi':_ -. J ='~' a .,_ .'~ IDGJ_ r_r~ -- ~l:a raes ___ ___~ .5 ~ __St3C= -__- ____-331 T'r~Se 1, .. __reRCeS a ~G'1JOi _~_-4-11_.-404 Ecuia Rev~'_r/Maine Services _ ___, Ot~er ..er~-_ces ~ Charges ~aoital Outlay I TOTAL Cable TV Administrative Services Personal Services 1C1-4-1210-4101 Regular Pay 101-4-1210-4103 Part-time Pay 101-4-1210-4104 PERA 101-9-1210-4105 FICA 101-4-1210-4107 Medicare 101-4-1210-4108 Insurance 101-4-1210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1210-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1210-4319 Other Professional Services 101-4-1210-4321 Telephone 101-4-1210-4322 Postage 101-4-1210-4331 Travel, Conferences & Schools 101-4-1210-4334 Car Allowance 101-4-1210-4361 Insurance 101-4-1210-4404 Equip Repair/Maint Services 101-4-1210-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay JC.OC _,?JC.OO 1,650.00 2,950.00 O.CG 0.00 ,6~C ~~ 0.00 0.00 0.00 _,_SC.Cu 86,600.00 3,704.05 3,704.05 4.28 82,895.95 306,650.00 11,745.83 11,745.83 3.83 294,904.17 41,200.00 1,437.75 1,437.75 3.49 39,762.25 25,200.00 1,950.44 1,950.44 7.74 23,249.56 21,550.00 1,664.48 1,664.48 7.72 19,885.52 5,050.00 389.27 389.27 7.71 4,660.73 26,650.00 2,339.32 2,339.32 8.78 24,310.68 2,100.00 0.00 0.00 0.00 2,100.00 428,400.00 19,527.09 19,527.09 4.56 408,872.91 9,500.00 253.59 253.59 2.67 9,246.41 9,500.00 253.59 253.59 2.67 9,246.41 5,500.00 5,508.00 5,508.00 100.15 ( 8.00) 800.00 8.07 8.07 1.01 791.93 1,000.00 0.00 0.00 0.00 1,000.00 7,300.00 234.00 234.00 3.21 7,066.00 4,800.00 369.24 369.24 7.69 4,430.76 300.00 45.50 45.50 15.17 254.50 23,550.00 1,551.59 1,551.59 6.59 21,998.41 1,800.00 0.00 0.00 0.00 1,800.00 45,050.00 7,716.40 7,716.40 17.13 37,333.60 ' TOTAL Administrative Services 482,950.00 27,497.08 27,997.08 5.69 455,452.92 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) T2 OF: J~!7.7._R]' 31ST, "'Oi _~____a- U~ ~ _rar,:er_t :SENT ~ -.._= - -~~` 10 -_~ F C= D.,-- i.:an Resources - -- yes ___-` 1220-=-101 R?ca e_ Paj; _,_-^-1220-4103 Fart-time Pay 101-4-L220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 Wori:ers Comp TOTAL Perscnal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 101-4-1220-4560 Equipment TOTAL. Capital Outlay I TOTAL Human Resources Elections Personal Services 101-4-1230-4103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1230-4322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4404 Equip Repair/Maint Services 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges 69,%00.,~ _,Cn1._~ _,6c..__ ,.85 66,38. c 4, 300.00 _,252.01 _, ~_.~~ 4.57 47,047.99 8,600.00 705.47 -05.47 8.20 7,899.53 7,350.00 575.28 575.28 7.83. 6,774.72 1,700.00 134.53 134.53 7.91 1,565.47 10,750.00 1,164.00 1,164.00 10.83 9,586.00 700.00 0.00 0.00 0.00 700.00 147,600.G0 7,493.10 7,493.10 5.08 140,106.90 4,300.00 1,937.82 1,937.82 45.07 2,362.18 4,300.00 1,937.82 1,937.82 45.07 2,362.18 3,000.00 0.00 0.00 0.00 3,000.00 550.00 0.00 0.00 0.00 550.00 2,350.00 0.00 0.00 0.00 2,350.00 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 67.60 67.60 6.76 932.40 7,900.00 67.60 67.60 0.86 7,832.40 4,700.00 0.00 0.00 0.00 4,700.00 4,700.00 0.00 0.00 0.00 4,700.00 164,500.00 9,498.52 9,498.52 5.77 155,001.48 30,000.00 0.00 0.00 0.00 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 4,650.00 0.00 0.00 0.00 4,650.00 4,650.00 0.00 0.00 0.00 .9,650.00 600.00 0.00 0.00 0.00 600.00 700.00 0.00 0.00 0.00 700.00 1,000.00 0.00 0.00 0.00 1,000.00 100.00 0.00 0.00 0.00 100.00 1,000.00 0.00 0.00 0.00 1,000.00 3,400.00 0.00 0.00 0.00 3,400.00 2-19-2012 08:17 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: TA1@LARY 31ST, 201°_ -_-~-_'-_ ~-;PSN_~ ~~ES .._.11s .,_ =LFR COMP. CURRENT ~..FnKFNT lE_=.R v i~rTE s OF 3UDC.~_ 3CDG~~ _ER_OD = _~rL :37OCE- PFi~.NCE i sonal Services 101-4-1310-4101 Regular Pay '-01-4-1310-4'04 PERA 101-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-4-1310-4109 Workers Comp TOT RI, Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-9-1310-4322 Postage 101-4-1310-9331 Travel, Conferences & Schools 101-4-1310-9359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions 101-4-1310-4438 Credit Card Fees TOTAL Other Services & Charges Capital Outlay 8,050.00 00.00 C.00 O.OC ~~,050.00 293,600.00 11,290.97 11,290.97 3.85 282,309.03 21,300.00 1,621.13 1,621.13 7.61 19,678.87 18,200.C0 1,320.45 1,320.45 7.26 16,879.55 4,250.00 308.82 308.82 7.27 3,991.18 26,650.00 2,187.01 2,187.01 8.21 24,462.99 1,800.00 0.00 0.00 0.00 1,800.00 365,800.00 16,728.38 16,728.38 4.57 349,071.62 5,350.00 126.79 126.79 2.37 5,223.21 5,350.00 126.79 126.79 2.37 5,223.21 18,300.00 0.00 0.00 0.00 18,300.00 50,000.00 0.00 0.00 0.00 50,000.00 400.00 2.54 2.54 0.64 397.46 2,600.00 0.00 0.00 0.00 2,600.00 2,350.00 294.00 294.00 12.51 2,056.00 950.00 0.00 0.00 0.00 950.0.0 12,200.00 10,861.45 10,861.45 89.03 1,338.55 1,500.00 120.00 120.00 8.00 1,380.00 5,000.00 0.00 0.00 0.00 5,000.00 93,300.00 11,277.99 11,277.99 12.09 82,022.01 TOTAL Finance Information Technology Personal Services 101-4-1350-9101 Regular Pay 101-4-1350-9103 Part-time Pay 101-4-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services 464,450.00 28,133.16 28,133.16 6.06 436,316.84 130,950.00 5,117.96 5,117.96 3.91 125,832.04 5,000.00 0.00 0.00 0.00 5,000.00 9,500.00 729.04 729.04 7.67 8,770.96 8,450.00 563.16 563.16 6.66 7,886.84 2,000.00 131.71 131.71 6.59 1,868.29 20,450.00 1,706.00 1,706.00 8.34 18,744.00 800.00 0.00 0.00 0.00 800.00 177,150.00 8,247.87 8,247.87 4.66 168,902.13 2-14-2012 08:17 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) PAGE: 9 ~_.33F ~- E= K CO.4P. .._.._.E!~T ,.~n1Lr:_ =~_=c =., D= TE ~ v_ 3UDGET 3~DC-^ ?E=.-0~ _.,. ~_ _ 3JuC~"' E~_LzNCE 1C'-- i_-- ~ ~ __~ - _l~_.CO 0.20 0.00 15,600.00 _., ___ SLpplSes 1-,600.00 _.__ _.00 0.00 1,600.00 - - -ice - es ___-~ 1350-~ ~__ _,_ ~_~_~a_ rvices °,000.00 0.00 0.00 0.00 8,000.00 _ 1-4-1350-4321 Telephone 1,450.00 7.64 7.64 0.53 1,442.36 _,'~-4-1350-4331 Travel, Conferences & Schools a, 000.00 0.00 0.00 0.00 8,000.00 1 1-4-1350-4404 Ecuip Pepair/Maim Services 20,900.00 0.00 O.GO 0.00 20,900.00 TCTFi Other Services & Char^es 38,350.00 7.64 7.64 0.02 38,342.36 Capi~_al Outlay TC1-4-1350-560 Equi~men~ 10,900.00 0.00 0.00 0.00 10,900.00 TOTAL Capital Outlay 10,900.00 0.00 0.00 0.00 10,900.00 TOTAL Information Technology 242,000.00 8,255.51 8,255.51 3.41 233,744.49 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 228,000.00 0.00 0.00 0.00 228,000.00 TOTAL Other Services & Charges 228,000.00 0.00 0.00 0.00 228,000.00 TOTAL Legal Community Development Personal Services 101-4-1500-9101 Regular Pay 101-4-1500-4104 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1:500-4109 Workers Comp TOTAL Personal Services 228,000.00 0.00 0.00 0.00 228,000.00 53,750.0.0 2,067.20 2,067.20 3.85 51,682.80 3,900.00 296.78 296.78 7.61 3,603.22 3,350.00 240.71 240.71 7.19 3,109.29 800.00 56.29 56.29 7.04 743.71 6,000.00 521.00 521.00 8.68 5,479.00 900.00 0.00 0.00 0.00 900.00 68,700.00 3,181.98 3,181.98 4.63 65,518.02 2-14-2012 08:17 AM PAGE: 10 __..3~ CF <~_. CJr~P. ..~_._~EIQ`` _~RREIy1 _=-K -~ ~ _- ~ CF 3JDv~_ ~_- .r -~^_'- -.,~c'.rd ~R=.S 3JDC_- -__~_C:. ._T, 3.~D3== ~ _1.~.'_QCE _Ol-_ _.,_.,- __ C. _ce ~~^-_~.. T~_ _- 'es _~C. ,~ Other Se^~~-ces 4 Charces 101-4-_50C-43~_ Trave-~, ~.__~___._ces ~ ,:hnols 400.00 TCTFi O~7er Services & ,._.arges 400.~~~.; 0.00 .0~=: _50.00 ~.00 0.00 150.00 0.00 0.-00 40C.00 TCTAL Comm-rarity Development Planning Personal Services 101-4-1510-4101 Regular Fay 101-4-1510-4104 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-9108 Insurance '101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs 101-4-1510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1510-4321 Telephone 101-4-1510-9322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-9359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4940 Miscellaneous 101-4-1510-4460 Equip Replacement Charge TOTAL Other-Services & Charges Capital Outlay 69,250.00 3,181.98 3,181.98 4.59 66,068.02 216,150.00 8,313.37 8,313.37 3.85 207,836.63 15,700.00 1,193.66 1,193.66 7.60 14,506.34 13,400.00 940.04 940.04 7.02 12,459.96 3,150.00 219.84 219.84 6.98 2,930.16 29,150.00 2,442.00 2,442.00 8.38 26,708.00 1,300.00 0.00 0.00 0.00 1,300.00 278,850.00 13,108.91 13,108.91 4.70 265,741.09 4,250.00 190.18 .190.18 4.47 4,059.82 1,600.00 0.00 0.00 0.00 1,600.00 200.00 0.00 0.00 0.00 200.00 6,050.00 190.18 190.18 3.14 5,859.82 800.00 0.32 0.32 0.04 799.68 3,200.00 0.00 0.00 0.00 3,200.00 1,650.00 474.00 474.00 28.73 1,176.00 8,000.00 0.00 0.00 0.00 8,000.00 450.00 74.50 74.50 16.56 375.50 3,600.00 0.00 0.00 0.00 3,600.00 1,050.00 80.00 80.00 7.62 970.00 250.00 0.00 0.00 0.00 250.00 800.00 66.66 66.66 8.33 733.34 19,800.00 695.48 695.48 3.51 19,104.52 ' TOTAL Planning CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: ~?~NL'PRT 3~Sm ~0_~ 304,700.00 13,999.57 13,994.57 9.59 290,705.43 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) I „~.neral-Gc e-r ~~.ent CB.i_~ .._ `_~~n C03C?. \"i~}' ._c 1. ,~.L_._~.,anc_ - .al Services 101-4-1600-4101 Regu-ar Ray 101-4-1600-4102 Overtime Pap 101-4-1600-4103 Part-time Pay 101-4-1600-4104 PERA 101-4-1600-41^u5 FICA 101-4-1600-4107 medicare 101-4-1600-4108 Insurance 101-4-1600-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone 101-4-1600-4331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4401 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services 101-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay "d0~,500.0^v -,i-1.36 ~,1Z .36 .,.84 10,328.64 ?,SOO.CO 17.14 1'_7.14 4.69 2,382.86 ^0,800.00 69x.61 699.61 3.36 20,100.39 9,550.00 699.08 699.08 7.32 8,850.92 ~8,20C.00 607.61 607.61 7.41 7,592.39 1,900.00 142.08 _2.08 7.48 1,757.92 17,700.00 1,296.72 1,296.72 7.33 16,403.28 ,550.00 0.00 0.00 0.00 5,550.00 174,700.00 7,733.60 7,733.60 4.43 166,966.40 4,650.00 0.00 0.00 0.00 4,650.00 1,700.00 0.00 0.00 0.00 1,700.00 29,400.00 2,897.13 2,897.13 9.85 26,502.87 35,750.00 2,897.13 2,897.13 8.10 32,852.87 13,950.00 724.77 724.77 5.20 13,225.23 1,500.00 0.00 0.00 0.00 1,500.00 5,100.00 1,047.25 1,047.25 20.53 4,052.75 36,700.00 157.90 157.90 0.43 36,542.10 31,150.00 423.37 423.37 1.36 30,726.63 2,500.00 0.00 0.00 0.00 2,500.00 2,800.00 233.33 233.33 8.33 2,566.67 93,700.00 2,586.62 2,586.62 2.76 91,113.38 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 304,150.00 13,217.35 13,217.35 4.35 290,932.65 241,550.00 0.00 241,550.00 0.00 0.00 0.00 241,550.00 0.00 0.00 241,550.00 TOTAL Contingency 241,550.00 0.00 0.00 0.00 241,550.00 TOTAL General Government 2,798,450.00 125,159.35 125,159.35 4.47 2,673,290.65 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF• JANU?1RY 31ST, 20'_2 I J1b_= :-_~__ _ =51 _~_b=RT~~i,_-- --_~N2 _s=.. ~~~DG-_ Pmt! O~ ~_.~.,~ CF ~~~R COM?. -.-r T'~K TO D__T~ ~ OF ~;J7C 1 _ __~~ A~m__._: __a__cn s~ral Seri^es 101- -2"-10-x_01 Reguar Pay 101-4-2110-4104 PIRA "_01-4-2110-4107 Medicare 101-4-2110-4'08 Insurance 101=4-2110-4109 worYers Comp TOTPS. Persor.~a1 Services J u^L^+l i 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges i01-4-2110-4319 Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-4322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-4361 Insurance 101-4-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay __~,,, G00.00 40,450.00 ~,~50.00 23,700.00 64,850.00 412,450.G0 14,000.00 2,300.00 4,600.00 20,900.00 3,400.00 29,300.00 2,600.00 3,350.00 500.00 7,550.00 80,400.00 9,250.00 i0,BC3.04 1C, 803.4 3.85 ^_70,096.96 3,080.79 3,080.79 7.62 x.,369.^_1 19-.33 192.33 7.54. _,357.67 1,900.OC 1,900.00 8.02 21,800.00 0.00 0.00 0.00 64,850.00 15,976.16 15,976.16 3.87 396,473.89 0.00 0.00 0.00 14,000.00 2,095.00 2,095.00 91.09 205.00 O.OC O.CO 0.00 4,600.00 2,095.00 2,095.00 10.02 18,805.00 0.00 0.00 0.00 3,400.00 103.26 103.26 0.35 29,196.74 0.00 0.00 0.00 2,600.00 0.00 0.00 0.00 3,350.00 0.00 0.00 0.00 500.00 2,153.00 2,153.00 28.52 5,397.00 33,822.70 33,822.70 42.07 46,577.30 200.00 200.00 4.71 4,050.00 140.25 140.25 17.53 659.75 36,419.21 36,419.21 27.56 95,730.79 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PERA 101-4-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services 565,500.00 54,490.37 54,990.37 9.64 511,009.63 1,479,700.00 53,034.97 53,034.97 3.58 1,426,665.03 90,000.00 872.21 872.21 0.97 89,127.79 226,050.00 15,662.93 15,662.43 6.93 210,387.57 20,400.00 1,292.65 1,292.65 6.34 19,107.35 179,350.00 14,323.54 14,323.54 7.99 165,026.46 1,995,500.00 85,185.80 85,185.80 4.27 1,910,314.20 2-14-2012 06:17 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) _.S OF: ,?.~NLLARY 31ST, 101_ ,, ;'RY~L.'=' ..TRRE!TT 'i=-.R TO DzTE _T?_ ~ 1d,". ___~ SRS :~JTC=:"_ pEBOD ~- J_T_•_i, PAGE: 13 C8.~3~ OF ~~_, .,OLiP. r G: ~ 'D3-- 31~DGET B~I~-~JCE ~-- ---.,- ~ ~ ~ -_ s T;~..~ - - ~ ---~- --- 6p _~_ng .lpp-_e~ ___-~ ___~-_-_~ _ '_ .c _.~ arts Other Serv-c ~araes 101-4-2120-4331 T_~._ Conferences & Schools 101-4-2120-4404 Ecuip Reaair/?~iaint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120--_460 Ecuip Replacement Charge TOTAL Other Services & Charges C=pital Ou-lay -^-°,_~OC.CO .1.62 __. 63 O.On' _~,~18.38 -~',3JO.O0 '13,3....v=- _~,.i00.00 .._.__ ur5JC.00 63,,5C.00 65.61 65.61 0.10 63,684.39 8,000.00 0.00 0.00 0.00 28,600.00 _7,600.00 13,447.23 13,447.23 5.22 244,152.77 25,150.00 0.00 0.00 0.00 25,150.00 26,70C.00 176.85 176.85 0.66 26,523.15 550.00 40.00 40.00 7.27 510.00 44,550.00 3,712.50 3,712.50 8.33 40,837.50 96,950.00 3,929.35 3,929.35 4.05 93,020.65 TOTP_L Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-9102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-9-2130-4331 Travel, Conferences & Schools 101-4-2130-9433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,350,050.00 102,562.38 102,562.38 4.36 2,247,487.62 514,100.00 18,865.63 18,865.63 3.67 495,234.37 45,000.00 183.09 183.09 0.41 44,816.91 80,500.00 5,329.76 5,329.76 6.62 75,170.24 6,900.00 408.96 408.96 5.93 6,491.04 69,100.00 5,534.03 5,534.03 8.01 63,565.97 715,600.00 30,321.47 30,321.47 4.24 685,278.53 5,350.00 2,460.00 2,460.00 45.98 2,890.00 12,900.00 0.00 0.00 0.00 12,900.00 18,250.00 2,460.00 2,460.00 13.98 15,790.00 5,450.00 0.00 0.00 0.00 5,450.00 13,250.00 400.00 400.00 3.02 12,850.00 600.00 0.00 0.00 0.00 600.00 11,600.00 966.67 966.67 8.33 10,633.33 30,900.00 1,366.67 1,366.67 4.42 29,533.33 TOTAL Investigations 764,750.00 34,148.14 34,148.14 4.47 730,601.86 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) .... OF: ~--N"zPY 315 °'C1"' _2=~K ~s 1~T== ~__ _:_.. ~3DS -`--~,. rt .,~_~_~~.. '_C1-4-2_r0-~--C2 Oce°rzme ?ay 101-4 ."-5G-~'-~4 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medic~__ 101-4-2150-4108 Insurance TOTAL Personal Sera_ces Supplies 161-4-2150-4201 Cffice Supplies 101-4-2156-4217 Un~form Allowance 101-4-2156-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-4-2150-4409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay __.33~ .._ _~_F CO'~P. .,gin:=D:= .,___.LI~" '-k -~ .~_- ~ Oc 3~DG-- B;'J;=_ PT-.-..2 A :u=L 3~D'vDT ~1"~~ 342, __, _.41 __,__.!_ 1. ,_ ~-°,751.59 ,5 C. ~ 69.03 69.03 _.97 3,430.97 ,100.00 1,794.16 _ 794."-6 7.15 23,305.84 _",450.00 1,485.12 ',485."-2 6.92 19,964.88 5,000.00 347.32 347.32 6.95 4,652.68 59,300.00 4,062.76 5,062.'0 6.85 -5,237.3C 456,700.00 20,356.74 2G, 356.74 4.46 436,343.26 1,000.00 0.00 0.00 0.00 1,000.00 3,000.00 0.00 0.00 0.00 3,000.00 14,900.00 ( 38.09)( 38.09) 0.26- 14,938.09 18,900.00 ( 38.09)( 38.09) 0.20- 18,938.09 3,350.00 0.00 0.00 0.00 3,350.00 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 0.00 0.00 0.00 16,000.00 500.00 85.00 85.00 17.00 415.00 6,200.00 516.67 516.67 8.33 5,683.33 27,900.00 601.67 601.67 2.16 27,298.33 I TOTAL Police Support Services Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA 101-4-2160-4107 Medicare TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies , TOTAL Supplies 503,500.00 20,920.32 20,920.32 4.15 482,579.68 5,500.00 350.00 100.00 0.00 0.00 0.00 5,950.00 0.00 3,500.00 0.00 5,000.00 0.00 8,500.00 0.00 0.00 0.00 5,500.00 0.00 0.00 350.00 0.00 0.00 100.00 0.00 0.00 5,950.00 0.00 0.00 3,500.00 0.00 0.00 5,000.00 0.00 0.00 8,500.00 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) I _ 1."__." J..f et1 •l ,"_itRE!~'1 ..gin?.=~~_ __'-n TJ ~__L ~ v~ 3'JDG_, ~.`'C.`="' =3-0~ ~TU_._ 3CDCFi ~ ?NCE Ctre rv_ - Ch=ra 101-4--_60-_~__ .tr~~ ~~~__~_ ~ ~_ ._~._~es 101-4-216C-.,~_ Te_ephoWe 101-4-316G-~__ _-.~ Corferences o .,.;Wools 1G1-4-2160-4359 P_. _ishi~.g 101-4-2160-4433 T~__ ~ Subscriptions TOTP_L Other S__~1ces & Charges Capital Outlay TOTAL Police Reserves Public safety building Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-4107 Medicare 101-4-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2190-4361 Insurance 101-4-2190-4389 Utilities 101-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges Capital Outlay TOTAL Public safety building Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions _. ._ _.00 _.CO ..OC .,`00.00 ~.~~ ~.oo _.c~ ~.~c "_oc.oo _, ~.,~ .00 _.CO ..00 OO.GO -~C.C0 0.00 ~.CO 0.00 150.00 "-,000.CO 0.00 0. CO 0.00 1,000.00 ~,~50.OC 0.00 O.CO 0.00 ,450.00 18,900.00 0.00 0.00 0.00 18,900.00 104,700.00 3,849.27 3,849.27 3.68 100,850.73 7,600.00 560.11 560.11 7.37 7,039.89 6,500.00 473.70 473.70 7.29 6,026.30 1,500.00 110.79 110.79 7.39 1,389.21 13,700.00 1,222.60 1,222.60 8.92 12,477.90 4,550.00 0.00 0.00 0.00 4,550.00 138,550.00 6,216.47 6,216.47 4.49 132,333.53 15,000.00 2,096.21 2,096.21 13.97 12,903.79 15,000.00 2,096.21 2,096.21 13.97 12,903.79 5,550.00 1,191.50 1,191.50 21.47 9,358.50 19,450.00 157.90 157.90 0.81 19,292.10 31,600.00 809.36 809.36 2.56 30,790.64 56,600.00 2,158.76 2,158.76 3.81 54,441.24 210,150.00 10,471.44 10,471.44 4.98 199,678.56 91,000.00 3,617.56 3,617.56 3.98 87,382.44 182,250.00 3,563.85 3,563.85 1.96 178,686.15 13,750.00 1,046.90 1,046.90 7.61 12,703.10 12,250.00 691.53 691.53 5.24 11,608.47 30,000.00 0.00 0.00 0.00 30,000.00 2-14-2012 08:17 AM REVENUE ?iblic So-et; T____RT~~i`__'-.L En~E~QIu~UKES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS 0^: J~_Nr.~,,Rti 3icm~ ^pi^ CUR3EP'T ~liR3_N. 3UDvn _=RIOT -=~ ~.0 ~_'-_TE ~_.. --=:L _.2_~ ~ OF 3?DC=_ PAGE: 16 OF ':EFR COUP. 3UD:,-- -~T.~-~JCE --_-~ __0-107 N,ed`c~-e ,950.00 _.~ -.,~ - 86 ,718.43 .Ol-^ 2310-~ 8 --_~rar,ce 6,100.00 776. L^ '76.!2 __. i_ _r.88 -C1-r 3i0--a Tno_kers Co^,c~ °3,650.00 O.OC C.00 0.00 23,60.00 TCT=- __ a- vices 362,950.C0 .~: °,_ ..53 _.-_ l~ ,72.4 Sucplie 101-4-2310-5201 Office Supplies _,250.00 O.CO C.OC .. ~ 4,^_50.60 101-4-2310-4212 Fuels & Lubs 6,950.00 O.CO ~-.00 0.06 6,950.00 101-4-231C-4217 Uniform Allcwance 7,450.00 0.00 C.00 0.00 7,450.00 101-4-2310-4219 Operating Supplies 32,100.00 1,346.45 1,346.45 4.i9 3C, 753.55 101-4-2310-4221 Equipment Parts 7,000.00 0.00 C.00 0.00 7,COC.00 TOTPS, Supplies 57,750.60 1,346.45 1,346.45 2.33 56,403.55 Other Services & Charges 1C1-4-2310-4319 Other Professional Services 5,400.00 0.00 C.00 0.00 5,400.00 1^v1-4-2310-4321 Telephone 3,150.00 109.62 109.62 3.48 3,040.38 i01-4-2310-4322 Postage 500.00 0.00 0.00 0.00 SOO.CO i01-4-2310-4331 Travel, Conferences & Schools 17,450.00 130.00 130.00 0.74 17,320.00 101-4-2310-4359 Publishing 300.00 0.00 0.00 0.00 300.00 101-4-2310-4361 Insurance 16,100.00 3,386.75 3,386.75 21.04 12,713.25 101-4-2310-9389 Utilities 11,700.00 0.00 0.00 0.00 11,700.00 101-4-2310-4401 Bldg Repair/Maint Services 5,450.00 0.00 0.00 0.00 5,450.00 101-4-2310-4404 Equip Repair/Maint Services 40,550.00 943.32 943.32 2.33 39,606.68 101-4-2310-4433 Dues & Subscriptions 1,400.00 467.00 467.00 33.36 933.00 101-4-2310-4460 Equip Replacement Charge 32,800.00 2,733.33 2,733.33 8.33 30,066.67 TOTAL Other Services & Charges 139,800.00 7,770.02 7,770.02 5.76 127,029.98 Capital Outlay TOTAL Fire Administration 555,500.00 18,994.00 18,994.00 3.42 536,506.00 Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 132,350.00 5,084.11 5,084.11 3.84 127,265.89 101-4-2320-4104 PERA 15,.200.00 1,157.13 1,157.13 7.61 14,042.87 101-4-2320-4105 FICA 3,350.00 257.13 257.13 7.68 3,092.87 101-4-2320-4107 Medicare 1,900.00 143.74 143.79 7.57 1,756.26 101-4-2320-4108 Insurance 15,300.00 1,240.11 1,240.11 8.11 14,059.89 TOTAL Personal Services 168,100.00 7,882.22 7,882.22 9.69 160,217.78 Supplies 101-4-2320-4201 Office Supplies 2,250.00 0.00 0.00 0.00 2,250.00 101-4-2320-9212 Fuels & Lubs 2,600.00 0.00 0.00 0.00 2,600.00 101-4-2320-4217 Uniform Allowance 1,400.00 0.00 0.00 0.00 1,400.00 101-4-2320-4219 Operating Supplies 5,150.00 0.00 0.00 0.00 5,150.00 TOTAL Supplies 11,400.00 0.00 0.00 0.00 11,400.00 2-14-2012 08:17 AM 1 _I-=P- -~~`==-- ~--=I~1I_~RES CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) ~S OF: JA17U=_RY 31ST, ''0~ ,..33o CF YD?R CO1sP. CtiRREN'" _;RRE!~l ~-t TO __~ a v- .~JD~C-- 3JD0?0 PER-O:; _ ~ J_~1: BSD:~=.- E .N~_= - - -- =rae -~--°-------~-~1 le-ep--`-~ -_-- ___~- _ ._a _-, ~~f ~__~es & Schools ___-_-_.,_~-:404 Eaui~ Repair/D1air_t ,.~-;ices 101-4-2320-4423 Dues ~ SLbs~riotiore TOT__L ~~__.._ ..~_~-ces & Charges ,350..,,, 51.21 _, ~ ,.. ,. 0.00 -'_,550.00 484.06 350.00 0.00 8,500.00 535.27 51.21 1.53 ',298.79 0.00 O.CO _,2~~.00 _84.06 3L 23 1,065.9= 0.00 0.00 1,350.00 535.27 6.30 7,964.73 TCT .~ ~'___ ! nsoec=l0;_S Emergency Management ------------------- ------------------ rsonal Services 101-4-2330-4101 Regular Pay 101-4-2330-4104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-4322 Postage 101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4389 Utilities 101-4-2330-4404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 188,000.00 8,417.49 8,417.49 4.48 179,582.51 9,400.00 355.10 355.10 3.78 9,044.90 1,350.00 101.27 101.27 7.50 1,248.73 150.00 10.20 10.20 6.80 139.80 600.00 39.13 39.13 6.52 560.87 11,500.00 505.70 505.70 4.40 10,999.30 500.00 0.00 0.00 0.00 500.00 9,150.00 0.00 0.00 0.00 9,150.00 9,650.00 0.00 0.00 0.00 9,650.00 1,650.00 0.00 0.00 0.00 1,650.00 1,000.00 0.00 0.00 0.00 1,000.00 3,700.00 0.00 0.00 0.00 3,700.00 1,500.00 0.00 0.00 0.00 1,500.00 5,800.00 0.00 0.00 0.00 5,800.00 100.00 0.00 0.00 0.00 100.00 13,750.00 0.00 0.00 0.00 13,750.00 69,000.00 0.00 0.00 0.00 69,000.00 69,000.00 0.00 0.00 0.00 69,000.00 TOTAL Emergency Management Building Safety 103,900.00 505.70 505.70 0.49 103,394.30 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) _~ub__., ..___- -~ -I 2=_ ~~__~ ~Tr~ ~7,P_AC~ ~ kkS ., ,:K-TAT .._ _..~~i\_ --.K ~. -_- c V[- BUDGET B:'DvET 3. i -~NrE. _- _'- Sen-~ es _.,_- _-10- .._ Reg~._ =ai, _.._-` -__- _~.. _~_ ~ _..e -a}; -`-- -~~- rl --_` --~-i-2910-41C7 _~edicare `_C1-4-^_41C-_108 =assurance IC1-4-241C-4109 wo-kers Comp TOTP_~ Personal Services Supplies 101-4-2410-4201 Cffice Supplies 101-4-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOT~I. Supplies Other Services & Charges 101-4-2910-9321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-9-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4933 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay .6, ~_._ _-, ~~.OC 1GC.00 1,650.00 447,750.00 4,30C.00 3,200.00 900.00 1,SSC.00 9,950.00 !7_.9y J. ~7 _,~ _.~_ 366.r-~ _~.01 C.00 __, ,.__ ~.85 3~~, _,.88 -..99 2.... ""~,~,~.Cl 1,640.82 7.60 23,609.18 "_ 568.32 .18 '=0,281.68 366.78 7.19 4,733.22 3,213.01 ..76 38,186.99 0.00 0.00 1,650.00 20,596.64 4.60 427,153.96 190.18 4.42 4,109.82 10.60 0.33 3,189.40 0.00 0.00 900.00 0.00 0.00 1,550.00 200.78 2.02 9,749.22 7.97 0.64 1,242.03 0.00 0.00 400.00 35.00 2.26 1,515.00 147.50 22.69 502.50 189.79 2.46 7,510.21 20.00 2.50 780.00 275.00 8.33 3,025.00 675.26 4.31 14,974.74 I TOTAL Building Safety Environmental Personal Services 101-4-2440-9101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-9-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-9109 Workers Comp TOTAL Personal Services _C,596.04 190.18 "_0.60 0.00 0.00 200.78 1,250.00 7.97 400:00 0.00 1,550.00 35.00 650.00 147.50 7,700.00 189.79 800.00 20.00 3,300.00 275.00 15,650.00 675.26 473,350.00 21,972.08 21,472.08 4.54 451,877.92 31,600.00 1,216.04 1,216.04 3.85 30,383.96 2,300.00 197.02 197.02 8.57 2,102.98 1,950.00 150.90 150.90 7.74 1,799.10 450.00 35.29 35.29 7.89 414.71 5,300.00 510.90 510.90 9.64 4,789.10 600.00 0.00 0.00 0.00 600.00 42,200.00 2,110.15 2,110.15 5.00 40,089.85 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) -=_'-R-. NT__~ ~S PES~~~ .,RTS ..OPnEdQ; ,.::F3=A'~ - =~` = - e ..P : i1 o__ ". C1-~_=~_0- 201 0~__~_ .,:cpcl-es _v1-_ ~44C-~_~2 __e~s x Lsbs TOT.i~ Suppl-es Other .,ervices Chases 101-c-2c40-4321 Telephone 101-e-~e40-4322 Pos`_aae 101-4-2440-4331 Travel, Conferences & Schocis 101-4-2440-4359 Publishing 101-4-2440-4409 Contractual Services "rC1-4-2440-4433 Dues & Subscriptions TOTAS~ Other Services & Charges ,.._~ c~.__ - r~.__ l~ - __.68 _36.61 _3- 65~~.C. X6.11 6.-1 __.-_ C-_._~ SSO.CO _.~~ !.55 0.28 548.45 800.00 C.00 0.00 0.00 800.00 SOO.CO 155.00 155.00 31.00 345.00 100.00 0.00 0.00 0.00 100.00 3,000.00 0.00 0.00 0.00 3,000.00 1,050.00 40.00 40.00 3.81 1,010.00 6,000.00 196.55 196.55 3.28 5,803.45 TOTAL Environ_mertal I TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3120-4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-4-3120-9219 Operating Supplies 101-4-3120-9226 Street Signs TOTAL Supplies Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Insurance 101-4-3120-4389 Utilities 48,850.00 2,382.81 2,382.81 4.88 46,467.19 5,782,450.00 274,364.73 274,364.73 4.74 5,508,085.27 386,700.00 14,814.96 0.00 116.28 116,600.00 2,433.00 32,200.00 2,589.70 31,200.00 2,289.97 7,300.00 535.57 64,700.00 5,697.39 27,600.00 0.00 666,300.00 28,476.87 4,200.00 87,250.00 110,750.00 35,850.00 12.68 104.94)( 149.30 0.00 238,050.00 250.00 7,450.00 200.00 2,500.00 500.00 18,750.00 36,000.00 57.04 0.00 122.21 0.00 0.00 0.00 3,844.00 0.00 14,814.96 3.83 371,885.04 116.28 0.00 ( 116.28) 2,433.00 2.09 114,167.00 2,589.70 8.04 29,610.30 2,289.97 7.34 28,910.03 535.57 7.34 6,764.43 5,697.39 8.81 59,002.61 0.00 0.00 27,600.00 28,476.87 4.27 637,823.13 12.68 0.30 4,187.32 104.94) 0.12- 87,354.94 149.30 0.13 110,600.70 0.00 0.00 35,850.00 57.04 0.02 237,992.96 0.00 0.00 250.00 122.21 1.64 7,327.79 0.00 0.00 200.00 0.00 0.00 2',500.00 0.00 0.00 500.00 3,844.00 20.50 14,906.00 0.00 0.00 36,000.00 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) .. OF: ~r~iU-.R Y. 3,LLcm ~0,,. _.~ __ CON_P. E~~OE T, __.._„~ =,.7- 3~DC=_ 5 ~-e CE 1C1-~ X120-4 .v1 E1dg Rena, ,~~~int _,-ces 4, ., _. ~ ,.00 O.OC .,~ i01-t-31?0-x'04 -au Rcpa iI.~int Ser-aices O.CO ~. ~_ C.00 0.00 ^,000.CO 101-c-3 L^0-«C9 ~,__ _„__a -er:_ces .19; .C._~ .. CC C.OC ..CC 4__,000.CO 101-a 120-=~-5 Ear me ;t Rer_tal 5,~~70.00 O. OC C.00 0.00 S,SOC.00 _; _- "_1C--4.' .--- a Rental 4,700.00 '_6. 34 26.34 C.56 4,673.66 101-4 3-~0-4433 Dues & Subo~riations 350.00 ~e6. 25 X6.25 C~._- _63."'5 101-4-3_20-4437 T~.=~. & Licenses 500.00 0. 00 x.00 ~~.OC 500.00 i01-4-3120-4460 Equip Replacement Charge 95,750.00 - 979. 17 - _- _ ,"70.83 TOTPS, Other Services & Charges 600,950.00 _ ,157. 97 12,"-57.97 2.02 SB~S,~r92.03 Cacti*_al Outlay I TOTP.L Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4103 Part-time Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 101-4-3130-9560 Equipment TOTAL Capital Outlay 1,505,300.00 40,691.88 40,691.88 2.70 1,464,608.12 100,300.00 20,000.00 9,100.00 8,350.00 8,000.00 1,900.00 17,100.00 7,650.00 172,400.00 96,000.00 96,000.00 9,193.93 4,193.93 4.18 96,106.07 3,276.72 3,276.72 16.38 16,723.28 0.00 0.00 0.00 9,100.00 783.61 783.61 9.38 7,566.39 705.36 705.36 8.82 7,294.64 164.98 164.98 8.68 1,735.02 798.78 798.78 4.67 16,301.22 0.00 0.00 0.00 7,650.00 9,923.38 9,923.38 5.76 162,476.62 0.00 0.00 20,000.00 0.00 20,000.00 0.00 0.00 0.00 96,000.00 0.00 0.00 96,000.00 0.00 0.00 20,000.00 0.00 0.00 20,000.00 TOTAL Snow Removal 288,400.00 9,923.38 9,923.38 3.94 278,476.62 Equipment Services 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 3zoT, 201_ t. .i~Y~ C V RZE?~,-. BUDGE PER.OD _~_'~~R TO DATE ~ OF 3UDC--' _ ~. JP'_L EUDGET E..~~NCE ~ 1PP~~ / I:~-._ 1?END .URES =1 J'er ---- ~.,-410' Reg -- =aY _. _-_-,"-50-._04 7E~ =,_-4-3150-9105 FICA 101-4-3150-4107 Neuicare 101-^_-3150-4108 Ins:ran ce i0i-4-3150-4109 Workers Como TOTAL Personal Services Suoclie- 1G1-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4417 Uniform Rental TOTPS. Other Services & Charges Capital Outlay ', 66, V50.GG 1L,G5G. lei 1,: 10,300.00 2,_00.00 23,400.00 4,500.00 218,700.00 20,200.00 6,000.00 26,200.00 3,000.00 3,000.00 €,_6.40 F,3=6.40 ~._~ _~~,663.60 __6.~5 916. ,J .6! 11,-.,_.-., -_3.19 743.:? -.22 M,~56.81 173.81 ?73.81 7:24 2,226.19 1,778.00 1,778.00 7.60 ^_1,622.00 0.00 0.00 0.00 4,500.00 9,998.25 9,998.25 4.57 208,701.75 208..13 208.13 1.03 19,991.87 0.00 G.00 0.00 6,000.00 208.13 208.13 0.79 25,991.87 52.43 52.43 1.75 2,947.57 52.43 52.43 1.75 2,947.57 TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-9108 Insurance 101-9-3300-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies 101-4-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL S~spplies Other Services & Charges 101-4-3300-4319 Other Professional Services 101-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-4-3300-4331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maiht Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges 247,900.00 10,258.81 10,258.81 4.14 237,641.19 79,250.00 3,517.31 3,517.31 4.44 75,732.69 5,750.00 505.00 505.00 8.78 5,245.00 4,900.00 917.06 417.06 8.51 9,482.99 1,150.00 97.54 97.54 8.48 1,052.46 14,050.00 521.00 521.00 3.71 13,529.00 550.00 0.00 0.00 0.00 550.00 105,650.00 5,057.91 5,057.91 4.79 100,592.09 500.00 0.00 0.00 0.00 500.00 600.00 0.00 0.00 0.00 600.00 1,000.00 0.00 0.00 0.00 1,000.00 2,100.00 0.00 0.00 0.00 2,100.00 13,500.00 0.00 0.00 0.00 13,500.00 700.00 5.00 5.00 0.71 695.00 150.00 0.00 0.00 0.00 150.00 2,700.00 0.00 0.00 0.00 2,700.00 200.00 45.50 45.50 22.75 154.50 7,800.00 187.03 187.03 2.40 7,612.97 750.00 62.50 62.50 8.33 687.50 25,800.00 300.03 300.03 1.16 25,499.97 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) _.., O°: J_"-NUp~y "'~ cT, ?011 _T?-.R.M~D_=~ ~_._EI1Di __v_ Oc..,~~ v .E_'-.R .,~_ P. C?;RiDP:'" ~"=RRErT __.R TO DATE € CF 3LTDvFT 3T~;-E°' PER_O~ .-CTUZ-:L _:.~DG~T BALANCE _.- ~ I in=eri~ _1-,550.00 -,357.94 `~,"~57.94 4.01-28,192.06 T~'iTr'~L P'1bl _:; Wor k9 _arks Dea=-`m~.ent - rsonal Services 1C1-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-4163 Fart-time Pay i01-4-5110-4104 PERA 101-4-511G-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-9217 Uniform Allowance 101-4-5110-9219 Operating Supplies 101-4-5110-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-9-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-5110-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4401 Bldg Repair/Maint Services 101-4-5110-4404 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-9415 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,75,150.00 66,_32.01 66,232.01 3.04 2,108,917.99 344,300.00 13,449.82 13,449.82 3.91 330,850.18 6,600.00 310.08 310.08 4.70 6,289.92 58,250.00 0.00 0.00 0.00 58,250.00 26,900.00 1,953.49 1,953.44 7.26 24,946.56 25,500.00 1,611.76 1,611.76 6.32 23,888.24 6,000.00 376.94 376.94 6.28 5,623.06 46,200.00 .3,878.36 3,878.36 8.39 42,321.64 10,850.00 0.00 0.00 0.00 10,850.00 524,600.00 21,580.40 21,580.40 4.11 503,019.60 39,100.00 0.00 0.00 0.00 39,100.00 3,200.00 0.00 0.00 0.00 3,200.00 78,250.00 85.48 85.48 0.11 78,164.52 13,000.00 227.62 227.62 1.75 12772.38 133,550.00 313.10 313.10 0.23 133,236.90 3,800.00 34.82 34.82 0.92 3,765.18 50.00 0.00 0.00 0.00 50.00 3,150.00 595.00 595.00 18.89 2,555.00 27,600.00 6,010.25 6,010.25 21.78 21,589.75 24,700.00 0.00 0.00 0.00 29,700.00 4,000.00 0.00 0.00 0.00 9,000.00 13,100.00 0.00 0.00 0.00 13,100.00 7,300.00 0.00 0.00 0.00 7,300.00 20,500.00 376.20 376.20 1.84 20,123.80 51,950.00 4,287.50 4,287.50 8.33 47,162.50 155,650.00 11,303.77 11,303.77 7.26 144,346.23 I TOTAL Parks Department 813,800.00 33,197.27 33,197.27 4.08 780,602.73 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 23 REVENUE &-EXPENSE REPORT (UNAUDITED) "~ OF: JANUFRF 3fi cm ^nl^ ~_~_~__ ~ Pe~--a-ron RE!T ~RREA'"^ _.. _., D_'-IE e CF ~JDCE- B2D:~-. PE.3IC_ --~ -=- BUDG~_ L ''lC- I _arks r Re. _.._.._.. 101-4 __,-4'~1 3~gLar may i01-4 2L^:-4.03 Par_ -me Paj, 101-4-5210-4105 iL,~_ "-C1-4-5210-4107 Medicare 101-4-5210-4108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services S~~aplies 101-4-5210-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5210-4321 Telephone 101-4-5210-4322 Pos*_age 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare TOTAL Personal Services 302,02.00 _-, _, .26 _ ;.26 ~.__ 33Y,936.-4 --,.0.:.00 ',465.30 "_,465.30 .6.88 _ _4.70 _-,200.00 °,i29.-~ ,___.29 ._. _-, "0.71 23,300.00 ~,719.i3 1,719.13 .38 _1,580.87 ,.450.00 402.04 402.04 7.38 5,047.96 52,700.00 3,784.07 3,784.07 7.18 48,915.93 4,450.00 0.00 0.00 0.00 4,450.00 486,750.00 22,913.09 22,913.09 4.71 463,836.91 10,200.00 63.39 63.39 0.62 10,136.61 10,200.00 63.39 63.39 0.62 10,136.61 4,800.00 128.24 128.24 2.67 4,671.76 6,000.00 0.00 0.00 0.00 6,000.00 6,850.00 134.00 134.00 1.96 6,716.00 32,400.00 1,581.00 1,581.00 4.88 30,819.00 650.00 147.50 197.50 22.69 502.50 7,400.00 0.00 0.00 0.00 7,400.00 13,300.00 930.99 930.99 7.00 12,369.01 9,350.00 266.24 266.24 2.85 9,083.76 1,550.00 0.00 0.00 0.00 1,550.00 82,300.00 3,187.97 3,187.97 3.87 79,112.03 579,250.00 26,164.45 26,164.45 4.52 553,085.55 82,000.00 1,246.63 2,400.00 19.92 4,350.00 101.07 1,200.00 23.62 89,950.00 1,391.24 1,246.63 1.52 80,753.37 19.92 0.83 2,380.08 101.07 2.32 4,248.93 23.62 1.97 1,176.38 1,391.24 1.55 88,558.76 2-14-2012 08:17 AM „Attire n 3~__~~~-~_- _,?~A.~/~1c T_'-- ~?:PEpd~ JRES PAGE: 24 ~_..,_~ CF 1~R CON_P. 3t~DC~= PE_.TO~ %~. ~ _~ 3;'J:;~_ _ .~tiCE r~_ 101-z ~_^0-42~~ Operut~~g _ __ TOTAL 8urplies Other Services arges 101-4-5220-4409 Contractual Services 101-4-5220-5412 Buildir_g 3ert 101-4-5220-4438 Credit Card Fees TOTAL Other Services n Charges - r2 3,100. ,, ,.. 54,050.00 O.OC 1,00.00 0.00 4,500.00 0.00 70,050.00 0.00 ,,.0^, ,.;00.00 x.00 ~.OC _ _ 0.00 0.00 64,00.00 0.00 O.OC 1,500.00 0.00 O.OC 4,500.00 0.00 0.00 70,050.OG TOTAL Recreation Programs 197,000.00 1,391.24 1,391.24 0.71 195,608.76 Concessions Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 0.00 0.00 0.00 3,650.00 101-4-5230-4104 PERA 150.00 7.98 7.98 5.32 142.02 101-4-5230-4105 FICA 250.00 6.82 6.82 2.73 243.18 101-4-5230-4107 Medicare 50.00 1.59 1.59 3.18 48.41 TOTAL Personal Services 4,100.00 16.39 16.39 0.40 4,083.61 Supplies 101-4-5230-4219 Operating Supplies 2,900.00 0.00 0.00 0.00 2,900.00 101-4-5230-4259 Other Merchandise For Resale 7,000.00 0.00 0.00 0.00 7,000.00 TOTAL Supplies 9,900.00 0.00 0.00 0.00 9,900.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4109 PERA 101-4-5510-4105 FICA 101-4-5510-4107 Medicare .101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) -'.. OF: Jn~~r1rRY 31S'", "OL 14,100.00 16.39 16.39 0.12 14,083.61 58,550.00.. 2,252.01 2,252.01 3.85 56,297.99 62,350.00 2,479.92 2,479.92 3.98 59,870.08 8,750.00 679.33 679.33 7.76 8,070.67 7,500.00 547.43 547.43 7.30 6,952.57 1,750.00_ 128.03 128.03 7.32 1,621.97 14,100.00 1,154.51 1,159.51 8.19 12,945.49 650.00 0.00 0.00 0.00 650.00 153,650.00 7,241.23 7,241.23 4.71 146,408.77 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) & Re r C=~. ~~% ., _~=~ic CO'~F. ~~~R3ET:_ ~~3_.E?7- _~_=~ TO ~P_TE ~_ 3"~'7G~- 3IIDCET PE,.=O~' _-.. ~__~ 3:::CnT b '-.1~CP. uPPl,es _ 1- 510---= Operating Supp'__. =~.-J SLao1_es Othe Servi Charges 101-4-55"=C-4321 Telechone =-4-5510-4322 _ ,. _ ge 101-4-5510-4331 Travel, Cor.-ferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 'C1-4-5510-4404 Ecuip Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-5510-4560 Equipment TOTAL Capital Outlay 13,350.00 ~ 6~ ( r 1B) _ _ - - _ -- 13,350.00 654."_3,; t _."~31 _ ~0- _ 10=.',= 2,600.00 157.64 15?. 64 6.06 2,443.36 2,500.00 O.CO G.00 O.OG 3,SOO.G0 1,900.00 0.00 0.00 0.00 1,900.00 1,600.00 354.25 354.25 22.14 1,245.75 9,300.00 0.00 0.00 0.00 9,300.00 13,750.00 570.60 570.60 4.i5 13,179.40 1,950.00 144.23 144.28 7.40 1,805.72 7,950.00 ( 89.00)( 89.00) 1.19- 7,539.00 950.00 211.36 211.36 22.25 738.64 42,000.00 1,349.13 1,349.13 3.2i 40,650.87 17,500.00 0.00 0.00 0.00 17,500.00 17,500.00 0.00 0.00 0.00 17,500.00 TOTP.L Sr Citizen Programs 226,500.00 7,936.18 7,936.18 3.50 218,563.82 TOTAL Culture & Recreation Economic Development Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-9107 Medicare 101-4-6210-4108 Insurance TOTAL Personal Services Other Services & Charges 101-9-6210-4331 Travel, Conferences & Schools 101-4-6210-4361 Insurance 101-4-6210-4940 Miscellaneous TOTAL Other Services & Charges 1,830,650.00 68,705.53 68,705.53 3.75 1,761,944.47 0.00 9,472.11 9,472.11 0.00 ( 9,472.11) 0.00 1,050.33 1,050.33 0.00 ( 1,050.33) 0.00 702.15 702.15 0.00 ( 702.15) 0.00 595.51 595.51 0.00 ( 595.51) 0.00 141.46 141.46 0.00 ( 141.46) 0.00 1,491.00 1,491.00 0.00 ( 1,491.OD) 0.00 13,452.56 13,452.56 0.00 ( 13,452.56) 0.00 154.00 0.00 1,965.75 0.00 90.43 0.00 2,210.18 154.00 0.00 ( 154.00) 1,965.75 0.00 ( 1,965.75) 90.43 0.00 ( 90.93) 2,210.18 0.00 ( 2,210.18) TOTAL Economic Development 0.00 15,662.74 15,662.74 0.00 ( 15,662.74) 2-14-2012 08:17 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) F_S OF: SPNIIPRY 31ST, _^012 PAGE: 26 03.33% OF lE~-R CON_P. ~.'~iiRE1~T ~.'.!_t~",_\'T ._~i _~ J::T E, % Ct- ~'.,iD:~`T BuDJE". ---~-..T ~CTU_~.L 3IIDGET BALFNCE -Here __ 1C1-~ e ?C-'i~~- Reg ~~ __ 29,300.00 1,126.24 1,126.24 3.84 2R, _73.76 1C1-4-62C-4104 .ERA _,lOC.00 161.72 161.7_ 7.70 1,933.28 1C1-4-n220-4105 FICA 1,80G.00 126.45 1?6.45 7.03 1,673.55 101-4-6220-41C7 Medicare 400.00 29.58 29.58 7.40 370.42 _~1-4-6220-41C8 Insurance 3,250.00 253.36 253.36 7.8G 2,996.64 TOT_aJ Personal Services 36,850.00 1,697.35 1,697.35 4.61 35,152.65 SllPp 11eS Other Servi^ & Charges 101-4-6220-4319 Cther Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 0.00 0.00 0.00 7,500.00 1C1-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TCTAL Other Services & Charges 14,000.00 0.00 0.00 0.00 19,000.00 TOTAL Energy City 50,850.00 1,697.35 1,697.35 3.34 49,152.65 TOTAL Economic Development Transfers Out Transfers Out 101-4-7000-4724 Transfer - Pinewood TOTAL Transfers Out TOTAL Transfers Out 50,850.00 17,360.09 17,360.09 34.14 33,489.91 40,500.00 40,500.00 0.00 0.00 0.00 0.00 0.00 0.00 40,500.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL General 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,678,050.00 551,821.71 551,821.71 4.35 12,126,228.29 ( 366,150.00)( 254,181.67)( 254,181.67) ( 111,968.33) 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) _z~ 0_°: ?_'=NtLyR1' 31c'^, "Oi? --'-v_'1VC =_L ~'„1i -=c ,.TRiF*i_ C','RREI~T P:C~F'= PFR-CD . _ .33% CF FF~n CON°, -E_=.R v DATE ~ CF 3UDC~T :C'"C''L 3UDC~T SALF'_QCE _~~ __ __.~ 569,600 .0 ~_,-__.~~ 51,502.35 9.04 518,097.65 =-,o~c}.ey ~ 30,1:00 ,00 ",6x.5.00 2,685.00 8.95 27,315.00 Skating 65,800 .0~2~ 3,569.00 ,569.00 5.42 62,231.00 Concessicns 69,000 .00 2,635.75 12,635.75 8.31 56,364.25 TOTP1~ REVENUES 734,400 .00 70,382.10 70,392.10 9". 58 664,007.90 ' EXPENDITURE SiP.P~iARY Culture & Recreation Ice Arer.a Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 543,550.00 17,749.93 17,?49.93 25,000.00 0.00 0.00 28,750.00 310.77 310.77 47,150.00 2,829.12 2,829.12 644,450.00 20,889.82 20,889.82 644,450.00 20,889.82 20,889.82 89,950.00 49,502.28 49,502.28 3.27 525,800.07 0.00 25,000.00 1.08 28,439.23 6.00 44,320.88 3.29 623,560.18 3.24 623,560.18 90,447.72 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OP: ~"~NJARF 31ST, _0 L^ I RF1"~'v_ES ~_.~3f vc ._?n COM°. ....RR~i~_ ~... KYLI\ .-_ h _.. ;J=TL Ci_ -....+~~_ HL'D:R". P°.3=0?- :_CT1=- 3JLG?^ R :vCE - Ser ^_21-3 0000-3464 Ice Rental 221-3-0006-3465 Admissions 221-3-0000-3466 Dry Floor Events 231-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 22i-3-0000-3482 Advertising fee TOT~.L Charges for Services Othe Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221-3-0000-3791 ATM Revenue TOTAL Sales TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services 466,ooc.oo ~2, 70.39 42,2 0.39 6.66 ^_95,-_9.61 _2,900.00 -,871.00 5,871.00 25.69 ~7,C29.00 17,400.00 453.00 453.00 2.60 16,947.00 4,300.00 719.OC 719.00 16.72 3,581.00 2,600.00 0.00 O.OC 0.00 2,60-0.00 17,500.00 0.00 0.00 0.00 17,500.00 552,700.00 4.9,313.39 49,313.39 6.92 503,386.61 14,000.00 1,754.61 1,754.61 12.53 12,245.39 2,800.00 402.50 902.50 14.38 2,397.50 16,800.00 2,157.11 2,157.11. 12.84 14,642.89 100.00 31.85 31.65 31.85 68.15 100.00 31.65 31.85 31.85 68.15 569,600.00 51,502.35 51,502.35 9.04 S1S,097.65 30,000.00 2,685.00 2,685.00 8.95 27,315.00 30,000.00 2,685.00 2,685.00 8.95 27,315.00 30,000.00 2,685.00 2,685.00 8.95 27,315.00 62,000.00 3,569.00 3,569.00 5.76 58,431.00 3,800.00 0.00 0.00 0.00 3,800.00 65,800.00 3,569.00 3,569.00 5.42 62,231.00 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS Or• 1n_NU~~Ry ?i gm~ ^012 ~ --- -~_ =REI~=_ I Kr`'r_1~E~ 03.33% OF _-~S CO'_~:P. ,.RREhT' _~S_Tt.t\~ ~_'--n _., :DATE c Cc ~JJ~~: ni1DCET P=Y_O., .-.CT,J.-.- 3JL~.~i~_':> 1~=~-~VCE O~~:er Reeerue TCT=.L Sr;ating ~...~.,_ssions urges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services ~ TOTAL Concessions ~ TOTAL REVENUE 6~,80G.00 3,569.OC 3,569.00 ,. __ 62,23-.OG 69,000.00 12,635.75 12,635.75 18.31 56,364.25 69,000.00 12,635.75 12,635.75 18.31 56,364.25 69,000.00 i2, 635. 75 12,635.75 '_8.3i 56,364.25 734,400.00 70,392.10 70,392.10 9.58 664,007.90 2-19-2012 08:17 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JFNUZ~RY 31ST, ^_012 ~ -=--~= -~`=r-~ 08.33$ CF '~EPR C01^P. CURnEiIT C??RREI7T Y-E_'_n _~ -~ _~ ~ .,~ BUDGET BUDG__ PERIOD -_ T~ _~ EI~CC-_ ~A?QCE __~ __°n3 so~a1 - - rces 221-4-0400-4101 Regular Pay ~21-4-5400-4103 Part-time Pay 321-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-5400-4107 Medicare ^21-4-5400-4108 Insurance 221-4-5400-4109 Workers Comp TOTP.L Personal Services Supplies 221-4-5400-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/Misc 221-4-5400-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5400-4331 Travel, Conferences & Schools 221-4-5400-4359 Publishing 221-4-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5400-4415 Equipment Rental 221-4-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-4-5400-4560 Equipment TOTAL Capital Outlay 167,600.00 6,369.85 6,369.85 3.80 161,230.15 59,300.00 3,7C8.58 3,708.58 6.25 55,591.42 15,700.00 1,135.16 1,135.16 7.23 14,564.84 14,100.00 1,160.84 1,160.84 8.23 12, 939.16 3,350.00 271.50 271.50 8.10 3,078.50 26,400.00 1,881.00. 1,881.00 7.13 24,519.00 8,000.00 0.00 0.00 0.00 8,000.00 294,450.00 14,526.93 14,526.93 4.93 279,923.07 50.00 0.00 0.00 0.00 50.00 1,300.00 0.00 0.00 0.00 1,300.00 34,250.00 1,098.12 1,098.12 3.21 33,151.88 8,000.00 0.00 0.00 0.00 8,000.00 600.00 0.00 0.00 0.00 600.00 44,200.00 1,098.12 1,098.12 2.48 43,101.88 3,500.00 57.76 57.76 1.65 3,442.24 900.00 0.00 0.00 0.00 400.00 1,000.00 0.00 0.00 0.00 1,000.00 2,000.00 0.00 0.00 0.00 2,000.00 7,800.00 1,706.50 1,706.50 21.88 6,093.50 142,950.00 0.00 0.00 0.00 192,450.00 22,750.00 215.62 215.62 0.95 22,534.38 1,200.00 0.00 0.00 0.00 1,200.00 2,800.00 0.00 0.00 0.00 2,800.00 500.00 145.00 145.00 29.00 355.00 184,400.00 2,124.88 2,124.88 1.15 182,275.12 20,500.00 0.00 0.00 0.00 20,500.00 20,500.00 0.00 0.00 0.00 20,500.00 TOTAL Ice Arena 543,550.00 17,749.93 17,749.93 3.27 525,800.07 2-14-2012 08:17 AM ~1--`--- x Sec =~---~~~_ -eke. so _ - es --1-4-54"« -4103 Part-_-me _ay _21-4-5410-410J __~r. _.1-~'-J4i0-4''v7 I~ediCare TOTAL Personal Services Suaolies 221-4-5410-4219 Operating Supplies TOT=.L Supplies Cther Services Charges 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTPS. Other Services & Charges CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) nc OP'• J~NUF_B]' 3'-ST, '_013 PAGE: 5 08.33 ~_ 'iE:S~ COMP. ..:Y3EId_ CcP3FI~T :~--K TO DATA a CF _C~DG.F_ 3~OG~= _EP10~ _'-_CTUAL HUDG~~ .L?3CE 3,600.OQ 0.00 0.00 0.00 3,600.00 200.00 O.GC 0.00 0.00 200.00 50.00 0.00 C.00 0.00 50.00 3,850.00 O.OC 0.00 0.00 3,850.00 12,55C.C0 0.00 0.00 0.00 12,550.00 12,SSC.00 O.CO 0.00 0.00 12,550.00 6,400.00 O.OG 0.00 0.00 6,400.00 2,200.00 0.00 0.00 0.00 2,200.00 8,600.00 0.00 0.00 0.00 8,600.00 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-4-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4359 Publishing 221-4-5420-9409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAI. Other Services & Charges 25,000.00 0.00 0.00 0.00 25,000.00 15,000.00 263.00 263.00 1.75 14,737.00 1,000.00 12.07 12.07 1.21 987.93 950.00 28.93 28.93 3.05 921.07 200.00 6.77 6.77 3.39 193.23 17,150.00 310.77 310.77 1.81 16,839.23 5,300.00 0.00 0.00 0.00 5,300.00 5,300.00 0.00 0.00 0.00 5,300.00 650.00 0.00 0.00 0.00 650.00 2,850.00 0.00 0.00 0.00 2,850.00 2,800.00 0.00 0.00 0.00 2,800.00 6,300.00 0.00 0.00 0.00 6,300.00 I TOTAL Skating 28,750.00 310.77 310.77 1.08 28,439.23 2-14-2012 08:17 AM I__r __\..,_-•'~ _._~. Eta '1 ,`RCS CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) ~ iD~~T _=_(_,i _. -.,T .1_'-_L .~". 1D.~-. _,r I~.T.~V'`.t. oval - _-_- ~=3G-^1~° P--t-time ?ap =0,900.00 i, _. ,- -,__e.37 _. _„ 19, 771.63 _ ?-4-5450-4104 PEA 200.00 _ .__ 27.69 13.85 _...3i _21-4-s43c-4105 .~.~- -,300.00 ___.-_ _19.7a _.21 _, 'ao.2z _'21-4-5430-4107 Medicare 300.00 28.00 28.00 9.33 272.00 TOTAL Persona l Services 22,700.00 1,303.94 1,303.84 5.74 _1, 396.16 SliDDl2, 221-4-543C-4219 Operating Snpplies~ 2,950.00 73.60 73.60 2.49 2, 876.40 221-4-543C-4259 Other Merchandise For Resale 21,500.00 1,451.68 1,451.68 6.75 20, 048.32 TOTAL Supplies 24,950.00 1,525.28 1,525.28 6.24 22, 924.72 TOTAL Arena Concessions 47,150.00 2,829.12 2,829.12 6.00 44,320.88 TOTAL Culture & Recreation 644,450.00 20,889.82 20,889.82 3.29 623,560.18 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 644,950.00 20,889.82 20,889.82 3.24 623,560.18 89,950.00 49,502.28 49,502.28 90,447.72 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) LC OE: JnNtLARY 31ST, 201'_ 11QAN r SrigL~l 09.~~~ OF '~~ ~ COLP. CURREE'i ~;;RRENI F=~R TO D~_TE e .,. 3JPG__ ~,"JOG~= PE3-~~ ...~:??L EUDG__ ST:T ~QCE I REIN L-~ ~:iy'~~:-2Y Pir wod Got= Cotirse OTF Y_~-~N~E.. I E}:PENDITIIRS SU!"L"~.RY _ulture & Recreation Golf Course TCTAL Culture & Recreation TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 236,SOcC.Cp cta ,Oq egc .00 0.19 -3 E, 05E.U0 236,500.00 44 .00 444 .00 0.14 236,056.00 236,500.C0 8,010.75 9,010.75 3.39 229,489.25 236,506.00 8,010.75 8,010.75 3.39 229,489.25 236,500.00 8,010.75 8,010.75 3.39 228,489.25. 0.00 ( 7,566.75)( 7,566.75) 7,566.75 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JPNUP~2Y 31ST, °C12 ~ --- - ~2i4~O0i' ~.~= COC3SE I z=~J~1~~ES ..~..~RREt.T CUR_=EIIT' _Ep_R TO L1'.TE ~ OF 3JDGJ'` =:'?0_i PER=OI __ Ti._L 5;1uGET cs rL~NCE ^ =inewood ~_ -- Coarse -:arses - 222-3-0000-3461 Recreation Fees _22-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-000G-3476 .Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 2~2-3-000G-3479 Tournaments TOTAL Charges for Services Other Revenue Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In 16,SOC.00 16,000.00 3,500.00 120,000.00 16,50G.00 ,15,500.00 5,000.00 196,000.00 40,500.00 40,500.00 444.00 444.00 2.69 16,C56.00 0.00 O.OG O.CO 16,000.00 0.00 0.00 C.00 3,500.00 0.00 0.00 O.GO 120,OOO.OC 0.00 0.00 0.00 i6, 500.00 0.00 0.00 0.00 18,500.00 0.00 O.GO 0.00 5,000.00 444.00 444.C0 0.23 195,556.00 TOTAL Pinewood Golf Course 0.00 0.00 0.00 40,500.00 0.00 0.00 0.00 40_,500.00 236,500.00 444.00 444.00 0.19 236,056.00 ^ TOTAL REVENUE 236,500.00 444.00 944.00 0.19 236,056.00 2-14-2012 08:17 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: ?TINUARY 31ST, ^013 ..~ RREIT 3UDG__ - sonai Service -_--4-5300-4101 Reanlar Pay 87,100.00 ___-_-5300-4103 Pa_~-~_,_e Pau- 29,900.00 222-4-5500-4104 PEFcA 8,500.00 ~_2-a-5300-4105 FICP_ 7,250.00 ~22-~-5300-4107 Medicare 1,700.00 222-4-5300-4108 Insurance 6,100.00 222-4-5300-4109 Workers Comp 1,850.00 TOT~.L Person al Services 142,900.00 Su~pl'es 222-4-5300-4212 Fuels & Lubs 4,500.00 222-4-5300-4217 Uniform Allowance 500.00 222-4-5300-4219 Operating Supplies 29,700.00 222-4-530C-4259 Other Merchandise For Resale 12,000.00 TOTAL Suppli es 46,700.00 Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 222-4-5300-4331 Travel, Conferences & Schools 950.00 222-4-5300-4349 Advertising/Marketing 5,000.00 222-4-5300-4361 Insurance 12,100.00 222-4-5300-4389 Utilities 6,550.00 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 222-4-5300-4415 Equipment Rental 1,350.00 222-4-5300-4437 Taxes & Licenses 1,000.00 222-4-5300-4438 Credit Card Fees 5,000.00 TOTAL Other Services & Charges 47,400.00 Capital Outlay Debt Service ..~R~FN_ PF3IOD C_.3~E v. YE?2'. ~~M?. 1F.'=..R ='0 D:_~_ a Or BUDCF~T 2,404.08 2,404.08 2.76 84,695.92 0.00 0.00 0.00 29,900.00 345.18 345."~8 4.C6 8,154.82 294.19 294.19 4.06 6,955.81 68.80 68.80 4.05 1, 63 L. 20 465.00 465.00 7.62 .5,635.00 0.00 0.00 0.00 1,850.00 3,577.25 3,577.25 2.51 138,822.75 0.00 0.00 0.00 4,500.00 0.00 0.00 0.00 500.00 0.00 0.00 0.00 29,700.00 0.00 0.00 0.00 12,000.00 0.00 0.00 0.00 46,700.00 0.00 0.00 0.00 2,400.00 0.00 0.00 0.00 450.00 295.00 295.00 5.90 4,705.00 2,750.50 2,750.50 22.73 9,349.50 0.00 0.00 0.00 6,550.00 0.00 0.00 0.00 8,950.00 990.00 990.00 21.52 3,610.00 0.00 0.00 0.00 1,350.00 398.00 398.00 39.80 602.00 0.00 0.00 0.00 5,000.00 4,433.50 9,433.50 9.35 92,966.50 TOTAL Golf Course 236,500.00 8,010.75 8,010.75 3..39 228,489.25 TOTAL Culture & Recreation 236,500.00 8,010.75 8,010.75 3.39 228,489.25 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 236,500.00 8,010.75 8,010.75 3.39 228,489.25 0.00 ( 7,566.75)( 7,566.75) 7,566.75 2-14-2012 08:19 AM CITY OF ELK .RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JANUFRY 31ST, 2012 BEGINNING CURREIQT CURRENT FUND ACCOUNT# ACCOUNT NAME BA?~T~NCE ACTIVITY B.~~NCE C?i-AIM ON C~.SH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 221-1010 Cash - Ice plena 222-"_O10 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 240-1010 Cash - Micro Loan Fund 241-1010 Cash - DTED Loan 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - GRE Reserve 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Cash - 2010A GO Cap Imp Bonds 349-1010 Cash - 2006C Cap Imp Bonds Lby 350-1010 Cash - State-Aid Road Bonds 403-1010 Cash - Street Improvement 404-1010 Cash - Surface Water Managemnt 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash - Park Improvement 459-1010 Cash - TIF #19 Highway 169 962-1010 Cash - TIF #22 Downtown Redev 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 26,161.76 ( 2,803.86) 23,357.90 6,568,693.32 ( 643,865.14) 5,924,828.18 440,791.00 3,146.04) 437,644.96 ( 234,908.28) 146,583.04 ( 88,325.24) ( 44,052.47) ( 15,771.53) ( 59,824.00) 10,464.20 1,245.43 11,709.63 ( 116,695.38) 0.00 ( 116,695.38) 893,462.88 ( 5,860.79) 887,602.14 693,462.03 0.00 693,462.03 1,271,719.03 8,285.11 1,280,004.14 329,520.15 4,828.04 334,348.19 402,940.09 1,476.90 404,416.99 1,340,149.67 46,664.69 1,386,814.36 327,612.82 ( 142,262.39) 185,350.48 5,697,200.34 ( 145,353.10) 5,551,847.24 13,932.03 ( 219.50) 13,712.53 144,316.47 0.00 144,316.47 1,196,179.18 0.00 1,146,179.18 112,359.47 0.00 112,359.47 227,307.26 2,164.42 229,471.68 436,482.90 3,965.50 440,448.40 645,332.73 8,485.46 653,818.19 0.00 ( 2,000.00) ( 2,000.00) 6,496.01 0.00 6,496.01 4,870,394.86 19,128.02 4,889,522.88 277,853.95 984.20 278,838.15 4,146,531.07 28,174.14 4,179,705.21 1,061,491.12 67,717.37 1,129,208.49 1,106,188.98 0.00 1,106,188.98 29,068.00 0.00 29,068.00 103,506.66 ( 19,240.96) 84,265.70 541,856.07 0.00 541,856.07 618.83 ( 618.83) 0.00 5,015,247.36 38,975.75 5,054,223.11 1,800,201.42 ( 190,120.65) 1,610,080.77 518,391.03 11,559.88 529,950.91 0.00 128,368.39 128,368.39 59,798.90 ( 3,990.00) 55,808.90 39,870,075.46 ( 656,646.35) 39,213,429.11 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH 31,671,672.67 120,518.04 31,792,190.71 (20,183,786.77) ( 777,164.39) (20,960,951.16) 28,382,189.56 0.00 28,382,189.56 39,870,075.46 ( 656,646.35) 39,213,429.11