Loading...
INFORMATION 05-21-2012INFORMATION VE',~` MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: May 21, 2012 SUBJECT: April 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 axe the primary concern in analyzing the City's financial health. Fox the month of April, actual revenues (except for property taxes and state aids) and expenditures should run slightly over 33% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget axe highlighted below accompanied with a general discussion for the variance. General Fund Kevenue.r: • Excluding transfers, revenue collections are slightly over 5% of budget; however, property taxes, our largest revenue source, will be received in July and December. • The first quarter gravel tax was received during the month of April. • Licenses & permits collections are about 29% of budget estimates. • Charges for services axe slightly over budget estimate and recreation fee collections axe over 53%. • Fines & forfeits are about 28% of budget; however, court fines reflect collections received through the month of March. • Transfers in from other city department will be recorded mid-year. E.x~enditurer: • Excluding transfers, the total departmental expenditures are about 28% of budget estimates and most departments are well within or below budget. • The Finance Department expenditures for the month of April reflect the annual appraisal services payment to the County and the majority payment of the audit services contract. • The transfer out to Pinewood Golf will be made at the end of the year when all revenues and expenditures are finalized. Ice Arena For the month of April, revenues exceed expenditures by $84,847. Revenues of $291,496 are over 39% of budget and expenditures of $206,649 are 32% of budget estimates. Hockey recreation fees exceed the annual budget estimates at 155%. Pinewood Golf As of the end of April, expenditures exceed revenues by $4,497. Excluding transfers in, revenue collections of $44,910 are at 23% of budget estimate after only about a month and a half of operation and membership fees are at 83%. Expenditures of $49,407 are 21% of budget. 1 5-16-2012 09:31 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) PAGE: 1 ~NFORnnA~ria~r ~.~R_~c=\~ ~,.,RREI:- =~-n _., ~_ -~. 's ^vF EJDGET BJD G__ ?,R=C~ ACTS.; ~-_~ 3JDC~~ BF1=NCE nE~"DNi.E SC~/1 P-~Y Gene _= F~~__.. _~_AL REVENtiES =y'PENDITURE SJM ~~RY ,~11,90~2.00 2.66 754,409.35 6.13 1,557,996.65 _2,311,920.00 12'_,212.66 754,409.35 6.13 11,557,490.65 General Government Mayer & Council 172,250.00 6,993.26 55,259.08 32.08 116,990.92 Cable TV 86,600.00 6,290.11 24,666.87 28.48 61,933.13 Administrative Services 482,950.00 36,876.31 148,718.99 30.79 334,231.56 Human Resources 164,500.00 12,394.51 54,10.88 33.32 109,689.12 Elections 38,050.00 382.00 382.00 L 00 37,668.00 Finance 469,450.00 91,071.44 190,996.71 41.12 273,453.29 Information Technology 242,000.00 17,531.90 79,375.97 32.80 162,624.03 Legal 228,000.00 23,680.50 60,357.00 26.47 167,693.00 Community Development 69,250.00 5,563.27 21,490.04 31.03 47,759.96 Planning 309,700.00 24,829.56 94,887.96 31.14 209,812.04 City Hall Maintenance 304,150.00 21,370.42 84,565.30 27.80 219,584.70 Contingency 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL General Government 2,779,450.00 246,983.28 815,510.25 29.39 1,958,939.75 Public Safety Police Administration 565,500.00 34,580.66 202,405.19 35.79 363,094.81 Patrol 2,350,050.00 169,521.90 649,891.64 27.65 1,700,158.36 Investigations 764,750.00 65,382.41 224,492.04 29.35 540,257.96 Police Support Services 503,500.00 41,540.10 146,122.05 29.02 357,377.95 Police Reserves 18,900.00 2,398.88 4,667.62 24.70 14,232.38 Public safety building 210,150.00 14,979.49 59,135.20 28.14 151,014.80 Fire Administration 555,500.00 34,540.40 145,282.59 26.15 410,217.46 Fire Inspections 188,000.00 14,342.34 56,143.55 29.86 131,856.45 Emergency Management 103,900.00 3,655.97 7,632.72 7.35 96,267.28 Building Safety 473,350.00 37,819.05 147,165.18 31.09 326,184.82 Environmental 48,850.00 3,674.88 14,213.76 29.10 34,636.24 TOTAL Public Safety 5,782,450.00 422,435.58 1,657,151.49 28.66 4,125,298.51 Public Works Street Maintenance 1,505,300.00 106,990.51 353,033.76 23.45 1,152,266.24 Snow Removal 288,900.00 383.71 96,616.57 33.50 191,783.93 Equipment Services 247,900.00 19,063.89 68,819.18 27.76 179,080.82 Engineering 133,550.00 9,491.52 36,791.58 27.55 96,758.42 TOTAL Public Works 2,175,150.00 135,929.63 555,261.09 25.53 1,619,888.91 ~ 5-16-2012 09:31 AM I _- J_ N _N L ~rn.n~ KI CITY OF ELK RIVER PAGE: 2 REVENUE k EXPENSE REPORT (UNAUDITED) no _ _ _.33E ~~ ~ .O~~r, ...,RYEP;I __RRffiC- '._.--'~ TO -'_--- ~= L"~DU- 3;JDG-_ PER=~_ _ ~TJP.L ~~DG-_ :RAC=vO~ Culture k 3ecreation Parks Denart-ert _ ~r'rs k Rec Aa_mir. Recreation Precrams Concessions Sr Citizen Programs TOTP_L Culture k Recreation Economic Developmen*_ Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES ~13,3~~.C0 60,46x.68 ~L ,1i7,_a X6.93 59 ,r ,2 .76 603,_ _.00 5.,63°_.~2 _ 76.".3 30.~~ 42~ ,.87 197,OOO.OC ,416.'8 1x,458.10 8.35 -_ ,541.90 1',100.00 0.00 0.00 0.00 -_,"_00.00 226,500.00 15,BC2.^8 6C,"_28.31 =6.55 _6e',371.69 1,854,650.00 129,321.66 478,779.78 25.82 1,375,870.22 0.00 13,171.47 32,693.84 0.00 ( 32,693.84) 50,850.00 3,442.59 12,076. L 23.75 38,773.88 50,850.00 16,614.06 44,769.96 88.04 6,080.04 40,SOO.OC 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 951,284.21 3,551,472.57 28.01 9, L6, 577.43 ( 366,150.00)( 829,071.55)( 2,797,063.22) 2,430,913.22 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) -~ OF: _---_~ ~,._ _,1~ ..L RREr1T ~PPEi~.:` L:-K _ ___ ~ ~._ fir.-_ REvENUES 3UDGET PEP-GD =.. :;__'-'.L ~UDG-T ~ :.,_ „____sal Fund a.:es 101- 3- 0000-3111 Current P.d valorem Tat:es 9,142,200.00 O.CO 569.36 0.01 9,141,630.69 101- 3- 0000-3121 Gravel Ta~~ 70,000.00 6,562.70 6,562.70 9.38 63,437.30 TOT AL Taxes 9,212,200.00 6,562.70 7,132.06 0.08 9,205,067.94 Licens es & Permits 101- 3- 000C-3211 Liquor License 53,000.00 0.00 2,X5.00 4.16 50,795.00 101- 3- 0000-3212 Amusement License 1,000.00 0.00 0.00 0.00 1,000.00 101- 3- 0000-3213 Cigarette License 3,000.00 0.00 112.50 3.75 2,887.50 101- 3- 0000-3214 Apartment License 17,000.00 1,980.00 19,355.00 84.44 2,645.00 1G1- 3- 0000-3216 Mining License 20,000.00 2,771.80 2,771.80 13.86 17,228.20 101- 3- 0000-3217 Garbage Hauler License 2,100.00 15.00 570.00 27.14 1,530.00 101- 3- 0000-3218 Other Business License/Permit 17,000.00 1,105.00 6,410.00 37.71 10,590.00 101- 3- 0000-3229 NPDES Permit 2,500.00 175.00 1,225.00 49.00 1,275.00 101- 3- 0000-3231 Building Permit 153,000.00 10,202.95 58,147.55 38.00 94,852.45 101- 3- 0000-3232 Plumbing/Heating Permit 129,150.00 17,205.03 27,063.44 20.96 102,086.56 101- 3- 0000-3233 Permit Surcharge 400.00 ( 855.30) 1,221.42 305.36 ( 821.42) 101- 3- 0000-3235 Animal License 3,500.00 480.00 1,740.50 49.73 1,759.50 101- 3- 0000-3236 Parking Permit 3,000.00 18.39 239.88 8.00 2,760.12 101- 3- 0000-3237 Other Non-Business Lic/Permit 8,000.00 355.00 2,095.00 25.56 5,955.00 TOTAL Licenses & Permits 412,650.00 33,952.87 118,107.09 28.62 294,542.91 Intergovernmental Rev 101- 3- 0000-3311 Federal Grant 3,000.00 0.00 0.00 0.00 3,000.00 101- 3- 0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101- 3- 0000-3325 Police 2% Aid 205,000.00 0.00 0.00 0.00 205,000.00 101- 3- 0000-3326 Police Training Reimb 12,000.00 0.00 0.00 0.00 12,000.00 101- 3- 0000-3327 State-Aid Street Maint 275,450.00 0.00 140,991.02 51.19 134,458.98 101- 3- 0000-3329 State Crime Prevention Grant 30,000.00 ( 13,275.94) 5,313.79 17.71 24,686.21 101- 3- 0000-3330 Other State Grants 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Intergovernmental Rev 542,950.00 ( 13,275.94) 146,304.81 26.97 396,145.19 Charges for Services 101 -3- 0000-3412 Planning & Zoning Fees 15,000.00 800.00 3,550.00 23.67 11,950.00 101 -3- 0000-3413 Plan Check Fee 41,000.00 2,161.65 28,335.95 69.11 12,664.05 101 -3- 0000-3415 Special Assessment Search 1,000.00 60.00 160.00 16.00 840.00 101 -3- 0000-3417 Copies 2,500.00 251.20 933.98 37.36 1,566.02 101 -3- 0000-3418 Other General Govt Services 4,000.00 316.25 982.50 24.56 3,017.50 101 -3- 0000-3430 Lockout Fees 7,500.00 620.00 2,490.00 33.20 5,010.00 101 -3- 0000-3431 Police Services 2,000.00 1,507.25 1,607.25 80.36 392.75 101 -3- 0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101 -3- 0000-3934 Animal Impound Fee 3,000.00 300.00 1,100.00 36.67 1,900.00 101 -3-0000-3436 Fire Contracts 199,600.00 0.00 87,907.52 94.04 111,692.48 101-3- 0000-3437 Fire Calls 4,000.00 0.00 ( 675.00) 16.88- 4,675.00 101 -3- 0000-3451 Street Services 35,000.00 300.00 1,540.00 4.40 33,460.00 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) ~~°Ie ~~ ~...1_~ OF YEAR .,~___. .~"U RRENT ."1 h:i^_v_ 1F~_K _v L'-.TE c CF ~UDG-_ 3iDGFT PE3ZOC =.?U..L ~"JGFT E i'_QCE --_-~ O;CO-352 Eng .e_r-ny c_~_~_~ Re~mb _Ci-C w0_'^61 Recre~~_~on Fees -X11-3-0000-3467 ~ ~._. ~~_ -_- 1C1-3-0000-3472 Pack Use F__ -C1-3-0000-3474 Facili~y Use Fee `i01-3-0000-3475 3uilding Rent . "'~O1-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License ChecY_ TOTAL Charges for Services Mines Forfeits 101-3-0000-3510 Court Fires 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits 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-3944 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 ._,_~,.00 _.OC 6.00 ..._ __, x_.00 ~29,COO.C0 13,084.45 68,689.53 53._, 60,31'.17 14,100.00 0.00 0.00 C.OC 14,-00.00 17,000.00 -,800.00 8,174.27 48.08 T, 825.73 5,700.00 ,223.01) ,776.76 48.72 2,923.24 2,400.00 260.00 800.00 33.33 1,600.C0 3,000.00 165.00 1,010.00 33.67 1,990.00 650,350.00 24,357 .79 246,957.06 37.97 403,392.94 120,000.00 11,644 .31 29,349.03 24.46 90,650.97 12,000.00 370 .00 8,132.25 67.77 3,867.75 500.00 0 .00 0.00 0.00 50C.00 132,500.00 12,014 .31 37,481.28 28.29 95,018.72 100,000.00 0.00 8,225.84 8.23 91,774.16 66,500.00 ( 26.00) 658.35 0.99 65,841.65 25,650.00 1,350.00 18,154.00 70.78 7,496.00 8,000.00 1,011.58 2,628.05 32.85 5,371.95 200,150.00 2,335.58 29,666.24 14.82 170,483.76 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 56,765.35 168,760.81 33.75 331,239.19 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 56,765.35 168,760.81 14.53 992,839.19 12,311,900.00 122,212.66 754,409.35 6.13 11,557,490.65 ^ TOTAL REVENUE 12,311,900.00 122,212.66 754,409.35 6.13 11,557,490.65 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) ~ -- _-._-_ c __:_ ..'~; R3EN= J.'kREi~'~ 3:J2 Gn= PEk-OP 11.13E OF _E'Sa ,.O'_2P. TEAR T~ ~~-TE ~ OP 3UD33= L 3~DG-° E _I~'1CE I °=°=r=°==°_°°__ - -onal Seri-ices 1G1-4-1110-4103 Part-time wag 101-4-1110-4104 PERA 101-4-1110-4105 FICA i01-4-1110-4107 Medicare 101-4-1116-4109 workers Cemp TCTAL Perso.~al Services Supplies 1G1-4-1110-4201 Cffice Supplies TOTAL Supplies 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 18,500.00 3,207.99 12,831.96 3.33 25,668.04 1,900.00 203.34 406.68 21.40 1,493.32 2,400.C0 222.12 444.24 18.51 1,955.76 550.00 93.02 186.C4 33.83 363.96 50.00 G.OC 32.50 65.00 17.50 43,400.00 3,726.47 13,901.42 32.03 29,998.58 3,200.00 47.03 122.91 3.84 3,077.09 3,200.00 47.03 122.91 3.84 3,077.09 11,050.00 1.52 3,978.36 36.00 7,071.64 400.00 0.00 74.99 18.75 325.01 2,600.00 0.00 0.00 0.00 2,600.00 17,700.00 3,148.50 6,530.72 36.90 11,169.28 69,450.00 0.00 25,401.50 36.58 44,048.50 16,000.00 0.00 0.00 0.00 16,000.00 8,450.00 69.74 5,249.18 62.12 3,200.82 125,650.00 3,219.76 41,234.75 32.82 84,415.25 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-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 172,250.00 6,993.26 55,259.08 32.08 116,990.92 57,450.00 4,334.40 17,337.60 30.18 40,112.40 6,500.00 274.13 1,313.27 20.20 5,186.73 4,150.00 471.36 1,411.01 39.00 2,738.99 3,950.00 412.41 1,202.28 30.44 2,747.72 950.00 96.44 281.17 29.60 668.83 8,700.00 680.00 2,720.00 31.26 5,980.00 250.00 0.00 128.50 51.40 121.50 81,950.00 6,268.74 24,393.83 29.77 57,556.17 1,700.00 15.27 266.99 15.70 1,433.06 1,700.00 15.27 266.94 15.70 1,433.06 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) _ ~~ _ _ n3ES- _. .~, --.1~ ~ CF __, - -___ ~ ~- =gin ~.,___ . ~ 'DG-- 3JDC_'_` -.-.,_ = CTS __ 3~~DC2_ 3 ONCE Ctf12r .`. - - x CI"i3"deS 101-4-1"-20-422 Pos~~ge .. ~ ..,_ "_C1-4 1120-4331 __o~~ ~.af~_ences & .~:-Dols _,-~,.00 €.-, 101-4-1 L0-4_C~ Ecu~c Pen~~~/M~ rt a_rv~ces -,65C.00 x.00 TOTAL Other Services & Charges 2,950.00 6.i0 apical Outlay ... .. .,.~_ ~_.J2 6. '_0 .-_ ,43.50 00 .00 ,050.00 6.-0 ..21 _,G43.90 TOTP.L Cable TV Administrative Services Personal Services 101-4-1210-4101 Regular Fay 101-4-1210-4103 Part-time Pay 101-4-1210-4104 PERA 101-4-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 86,600.00 6,290."il 24,666.87 28.48 61,933.13 306,650.00 23,491.66 93,966.64 30.64 212,683.36 41,200.00 2,891.15 11,650.31 28.28 29,549.69 25,200.00 2,867.24 8,651.77 34.33 16,548.23 21,550.00 2,460.66 7,398.39 34.33 14,151.61 5,050.00 575.45 1,730.22 39.26 3,319.78 26,650.00 2,243.01 9,623.55 36.11 17,026.45 2,100.00 0.00 935.00 44.52 1,165.00 928,400.00 34,529.17 133,955.88 31.27 294,444.12 9,500.00 408.33 1,256.74 13.23 8,243.26 9,500.00 408.33 1,256.74 13.23 8,243.26 5,500.00 0.00 5,508.00 100.15 ( 8.00) 800.00 6.95 15.91 1.99 784.09 1,000.00 0.00 127.53 12.75 872.97 7,300.00 451.61 995.39 13.64 6,304.61 4,800.00 369.24 1,661.58 34.62 3,138.42 300.00 0.00 91.00 30.33 209.00 23,550.00 1,111.01 9,856.41 20.62 18,693.59 1,800.00 0.00 250.00 13.89 1,550.00 45,050.00 1,938.81 13,505.82 29.98 31,544.18 ~ TOTAL Administrative Services 982,950.00 36,876.31 148,718.94 30.79 334,231.56 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) e N`' __--- onm-1 -`-- ' ~~=_'-Ti'ii:-u NT._"-_°~ ~kn~ND11UnES CliRREhT_ ..:;R3EP; T ~'_K _ .-- „c ~-- 320GET PE3=C., __.. A~ ~JC-- L ~-_1CE ^ 2uT,an Pesources Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICF_ 101-4-1220-4107 Medicare 101-4-1220-4"108 Insurance 101-4-1220-4109 Workers Comp TOTAL Personal 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-9433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 101-4-1220-4560 Equipment TOTAL Capital Outlay 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,200.00 _3.62 _1,294."-.8 30.77 z?,905.52 49,300.00 3,663.22 16,144.08 32.75 33,155.92 8,600.00 979.98 3,063.51 35.62 5,536.99 7,350.00 826.38 2,540.46 39.56 4,809.54 1,760.00 193.26 599.11 34.95 1,105.89 10,750.00 949.60 9,226.OC 39.31 6,524.00 160.00 O.OG 329.00 47.C0 371.00 147,600.00 11,875.46 98,191.64 32.65 99,408.36 4,300.00 79.25 2,130.79 99.55 2,169.21 4,300.00 79.25 2,130.79 49.55 2,169.21 3,000.00 0.00 0.00 0.00 3,000.00 550.00 0.00 942.31 80.42 107.69 2,350.00 0.00 141.42 6.02 2,208.58 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 64.80 296.75 29.68 703.25 7,900.00 64.80 880.48 11.15 7,019.52 4,700.00 375.00 3,607.97 76.77 1,092.03 4,700.00 375.00 3,607.97 76.77 1,092.03 169,500.00 12,394.51 54,810.88 33.32 109,689.12 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 277.00 277.00 5.96 9,373.00 9,650.00 277.00 277.00 5.96 9,373.00 600.00 0.00 0.00 0.00 600.00 700.00 0.00 0.00 0.00 700.00 1,000.00 105.00 105.00 10.50 895.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 105.00 105.00 3.09 3,295.00 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) -- OF: ------ ---- ~ 1CI- I ___„_.._ .~~ __n_,~ent __.~_~ CF ~:5_R CC^'P. ..URREN' ;'RRE\"T `E ~R °0 P__TE e ~~F ~Dv-- 3UDGET ?En-'OT =.,.J_~"L 3UDvE"' L-.1•'=NCE C=o- Cu`1av I `-OTA1 ~=-cticns ~ance Personal Services ~~1-4-1310-4101 Regular Pay "~^u1-4-1310-4104 PERA "~C1-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-4-1310-4109 A~orkers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-9301 Audit Fees 101-4-1310-9319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-9322 Postage 101-4-1310-9331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-4-1310-4933 Dues & Subscriptions 101-4-1310-4438 Credit Card Fees TOTAL Other Services & Charges Capital Outlay TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101-4-1350-4103 Part-time Pay 101-4-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-9107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services 38,050.00 382.00 382.00 1.00 37,668.00 293,600.00 22,581.95 90,327.78 30.77 203,272.22 21,300.00 2,455.74 7,351.19 34.Si 13,948.81 18,200.00 2,034.20 6,022.97 33.09 12,177.03 4,250.00 475.75- 1,408.65 33.19 2,841.35 26,650.00 2,187.01 8,748.04 32.83 17,901.96 1,800.00 0.00 815.50 45.31 984.50 365,800.00 29,734.65 114,674.13 31.35 251,125.87 5,350.00 63.40 676.58 12.65 4,673.42 5,350.00 63.40 676.58 12.65 4,673.42 18,300.00 11,640.00 13,440.00 73.44 4,860.00 50,000.00 48,730.50 48,730.50 97.46 1,269.50 400.00 2.59 8.35 2.09 391.65 2,600.00 0.00 616.03 23.69 1,983.97 2,350.00 47.68 441.96 18.81 1,908.04 950.00 0.00 0.00 0.00 950.00 12,200.00 721.41 11,582.86 94.99 617.14 1,500.00 0.00 675.00 45.00 825.00 5,000.00 131.21 151.30 3.03 4,848.70 93,300.00 61,273.39 75,646.00 81.08 17,654.00 464,450.00 91,071.44 190,996.71 41.12 273,453.29 130,950.00 10,235.93 40,943.71 31.27 90,006.29 5,000.00 0.00 0.00 0.00 5,000.00 9,500.00 1,113.15 3,326.39 35.01 6,173.61 8,450.00 916.83 2,647.78 31.33 5,802.22 2,000.00 214.43 619.25 30.96 1,380.75 20,950.00 1,706.00 6,824.00 33.37 13,626.00 800.00 0.00 378.00 47.25 422.00 177,150.00 14,186.34 59,739.13 30.90 122,410.87 I 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) - -- o~mc 33.~~. ~ = sE=_. COM_. ~.,;Krt~RT .,.!C<EI~ _~ ~'C _.. D_.TE 3 ~._ :~J~~.~_ .-EDGE? PE3=0T =.CTUAL 3JCGF7 E.li=tiC= ~~- ~_-4 ~_-_ _ _ _ -, _-_. -5,600.00 1,105.27 ,4,.87 24.02 11,852.13 _~__". Scppl-es 15,60C.00 1,105.27 ',747.97 24.02 11,852.13 - J2 ~" ~ charge 1C1-4-135C-4319 Other Professional Services 8,000.00 0.00 0.00 0.00 8,000.00 "_C1-4-1350-4321 Te_ephone 1,450.00 151.45 663.36 45.75 786. n'4 1C1-4-1350-4331 Travel, Conferences & Schools 8,000.00 57.28 57.28 0.72 7,942.72 -C1-4-1356-44na gquip Repair/Maim Services 20,900.00 2,031.56 9,268.33 44.35 11,631.67 TOTAL Other Sen•_ces & Charges 38,350.00 2,250.29 9,988.97 26.G5 28,361.03 Capital Out'_ay :~1-4-135C-4560 Eanipment 10,900.00 0.00 10,900.00 100.00 0.00 T'OTFT Capital Outlay 10,900.00 0.00 10,900.00 100.00 0.00 TOTAL Information Technology Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 242,000.00 17,531.90 79,375.97 32.80 162,624.03 228,000.00 23,680.50 60,357.00 26.47 167,643.00 228,000.00 23,680.50 60,357.00 26.47 167,643.00 I TOTAL Legal Community Development Personal Services 101-4-1500-4101 Regular Pay 101-4-1500-4104 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services 228,000.00 23,680.50 60,357.00 26.47 167,643.00 53,750.00 4,134.40 16,537.60 30.77 3,900.00 449.61 1,345.87 34.51 3,350.00 371.41 1,098.60 32.79 800.00 86.85 256.90 32.11 6,000.00 521.00 2,084.00 34.73 900.00 0.00 149.50 16.61 68,700.00 5,563.27 21,472.47 31.26 37,212.40 2,554.13 2,251.40 543.10 3,916.00 47,227.53 5-16-2012 09:31 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) PAGE: 10 uc ,. _ _ =r<~ -_ _ _1 __ ._ ..c _:_ __ ~.. n3DC?" P?3.OJ ,.. =_~_~ 3JCCPI E ~+NCE npli __ 50C-4=01 Cf. ~~ .. __c 10 0. `l. 132.43 TCLJ .upo'_i es _50.00 .,.00 17.57 11. _ 152.43 - Se r'_~ - a-aes '~1-4-1500-4331 ^ravel, Conferences & Schools 400.00 C.CO O.OC 0.00 400.00 TCTA_L Other Services & Charges 400.00 0.00 0.00 0.00 400.00 TOTP.L Community Development 69,250.00 5,563.27 21,490.04 31.03 47,759.96 Planning Personal Services '~01-4-1510-4101 Regular Pay 216,150.00 16,626.74 66,506.96 30.77 149,643.04 101-4-1510-4104 PERA 15,70C.00 1,808.16 5,412.70 34.48 10,287.30 101-4-1510-4105 FICA 13,40C.00 1,465.55 4,305.83 32.13 9,094.17 101-4-1510-4107 Medicare 3,150.00 342.75 1,006.99 31.97 2,143.01 101-4-1510-4108 Insurance 29,150.00 2,442.00 9,768.00 33.51 19,382.00 101-4-1510-4109 Workers Comp 1,300.00 0.00 458.50 35.27 841.50 TOTAL Person al Services 278,850.00 22,685.20 87,458.98 31.36 191,391.02 Supplies 101-4-1510-4201 Office Supplies 4,250.00 151.07 591.54 13.92 3,658.46 101-4-1510-4212 Fuels & Lubs 1,600.00 124.14 330.54 20.66 1,269.46 101-4-1510-4219 Operating Supplies 200.00 0.00 316.58 158.29 ( 116.58) TOTAL Suppli es 6,050.00 275.21 1,238.66 20.47 4,811.34 Other Services & Charges 101-4-1510-4321 Telephone 800.00 149.40 256.96 32.12 543.04 101-4-1510-4322 Postage 3,200.00 0.00 240.85 7.53 2,959.15 101-4-1510-4331 Travel, Conferences & Schools 1,650.00 38.00 646.00 39.15 1,004.00 101-4-1510-4359 Publishing 8,000.00 757.50 1,515.00 18.94 6,485.00 101-4-1510-4361 Insurance 450.00 0.00 149.00 33.11 301.00 101-4-1510-4904 Equip Repair/Maint Services 3,600.00 367.59 2,545.87 70.72 1,054.13 101-4-1510-4433 Dues & Subscriptions 1,050.00 490.00 570.00 59.29 480.00 101-4-1510-4440 Miscellaneous 250.00 0.00 0.00 0.00 250.00 101-4-1510-4460 Equip Replacement Charge 800.00 66.66 266.64 33.33 533.36 TOTAL Other Services & Charges 19,800.00 1,869.15 6,190.32 31.26 13,609.68 Capital Outlay TOTAL Planning 304,700.00 24,829.56 94,887.96 31.14 209,812.04 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) __. ,._. ---- =0T-~ --- ~~n~TP"-, _~'F3E.r~" -_~ •-~0 LATE e .,_ ~.tD `.=- 3;"~~c= PE3_C_ _.. SAL ~JD3__ E ;_4C_ Cis. Ha11 ?~aintenance - rsonai Seri=i ,es _Oi-4-1600-4_C1 Recu=ar ~a}" 101-4-1600-4102 Overtime Pay "_O1-4-1600-4103 Part-time Pay '_C1-4-1600-4104 PE RA 101-4-1600-4105 FICA 101-4-1600-4107 Medicare 101-4-1600-4108 Insurance "i01-4-1600-4109 Workers Comp TOTP_L 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-4409 Equip Repair/Maint Services 101-4-1600-4960 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 108,500.00 ,356._5 ~ ,__1.51 30.3€ _5,578.49 2,500.00 ~.__ 351.^_1 14.06 ,48.59 2C,800.C0 1,597.0! -,583.19 26.84 _ ,216.81 9,550.00 1,055.9C ,132.99 32.81 6,417.Oi 8,200.00 937.70 2,733.87 33.34 5,466.13 1,900.00 219.31 639.38 33.65 -,260.62 17,70C.00 1,312.47 5,148.73 29.09 12,55'_.27 5,550.00 0.00 2,553.00 46.00 2,997.00 174,700.00 13,556.76 53,064.08 30.37 121,635.92 4,650.00 329.55 694.37 14.93 3,955.63 1,700.00 0.00 417.35 24.55 1,282.65 29,400.00 1,791.49 6,737.88 22.92 22,662.12 35,750.00 2,121.04 7,849.60 21.96 27,900.40 13,950.00 965.61 3,629.98 26.02 10,320.02 1,500.00 0.00 361.16 24.08 1,138.84 5,100.00 0.00 2,094.50 41.07 3,005.50 36,700.00 3,059.79 9,297.88 25.33 27,402.12 31,150.00 1,244.46 7,145.35 22.94 24,004.65 2,500.00 189.43 189.43 7.58 2,310.57 2,800.00 233.33 933.32 33.33 1,866.68 93,700.00 5,692.62 23,651.62 25.24 70,048.38 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4490 Miscellaneous TOTAL Other Services & Charges 304,150.00 21,370.42 84,565.30 27.80 219,584.70 217,550.00 0.00 0.00 0.00 217,550.00 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL Contingency 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL General Government 2,774,450.00 246,983.28 815,510.25 29.39 1,958,939.75 5-16-2012 09:31 AM _....-~~ „__ ~VI _~.~~.t ~i F ~Oi~o, .~,_~- _ - ."l~_(YENI ___ - _ ~S EPK _ __- £ .ice ~ .~~~_ Personal Services '-01-4-21"i0-4101 Regular Pay -0'-4-2110-4iC4 rERr. _~1-4-2116-41Gi Medicare 101-4-2116-4108 Insurance 101-4-2110-9109 Workers Comp TCT_AL Personal Services Supplies 101-4-2110-4201 Office Supplies i01-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-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 280,"00.00 21,o'C6.08 86,424.32 _0.77 194,475.68 40,450.00 4,666.95 13,970.34 34.54 26,479.66 2,550.OC 292.86 873.71 34.26 1,676 °9 23,700.00 1,900.00 7,600.00 32.07 16,100.00 64,850.00 0.00 29,187.00 45.01 35,663.00 412,450.00 28,465.89 138,055.37 33.47 274,394.63 14,000.00 1,006.98 1,870.95 13.36 12,129.05 2,300.00 7.18 2,195.00 95.43 105.00 4,600.00 2.18 1,256.37 27.31 3,393.63 20,900.00 1,016.34 5,322.32 25.47 15,577.68 3,400.00 37.56 698.98 20.56 2,701.02 29,300.00 1,507.91 4,553.89 15.54 24,746.11 2,600.00 0.00 847.44 32.59 1,752.56 3,350.00 0.00 1,230.00 36.72 2,120.00 500.00 0.00 0.00 0.00 500.00 7,550.00 0.00 4,306.00 57.03 3,244.00 80,400.00 3,552.96 45,676.94 56.81 34,723.06 4,250.00 0.00 1,574.00 37.04 2,676.00 800.00 0.00 140.25 17.53 659.75 132,150.00 5,098.43 59,027.50 44.67 73,122.50 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 CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) _- 0"' __--- -`- 20- 565,500.00 34,580.66 202,405.19 35.79 363,094.81 1,479,700.00 103,522.92 416,774.70 28.17 1,062,925.30 90,000.00 3,337.06 18,493.17 20.49 71,556.83 226,050.00 23,937.77 70,562.65 31.22 155,487.35 20,400.00 1,985.03 5,881.06 28.83 19,518.94 179,350.00 14,080.00 56,563.59 31.54 122,786.46 1,995,500.00 146,362.78 568,225.12 28.48 1,427,274.88 I 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) ~_~ ' _.-_Kmr.IQTZ1 .?E,P~~:~1.,,JRES ~.,.C ~ CF YE~~..R C~~P. s OE 3UDGE". 3 JDGET P'_~_NCE ^glieS _.,_- -2C-4_ _ _.__ ~ a _.., .. _~- _ --C-=2-7 Ji-'.,~_. L1'_ewance 1__-4-__2C-=2i9 Cperating SucP-__. __i-4-_'-20-4221 Equiament P iLa TCTA~ Supplies Other Services & Charges 1C1-4-2120-4331 Travel, Conferences & Schools 1C1-4-2120-4404 Equip Repair/Maine Services --i0T-4-212G-4433 Dues & Subscriptions 101-4-2120-4460 Ecuip Replacement Charge _OT_PL Other Services & Charges Capital Outlay 143,000.00 ,391.80 ~ ,_89.8'' 15.59 120,7'_0.13 ,850.GC 1=9.18 13,341.68 .,8.39 9,~08.CT 63,750.00 5,341.5"~ 12,=72.20 19.25 51,47 .80 28,000.00 863.65 7.48 6.88 26,072.52 257,60C.00 15,716.14 49,831.23 19.34 207,768.77 25,150.00 3,077.84 7,632.84 30.35 17,517.16 26,700.00 652.14 9,312.45 34.28 17,387.55 550.00 0.00 40.00 7.27 510.00 44,550.00 3,712.50 14,850.C0 33.33 29,700.00 96,950.00 7,442.48 31,835.29 32.84 65,114.71 TOTAL Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-9-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4-2130-9331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,350,050.00 169,521.40 649,891.64 27.65 1,700,158.36 514,100.00 37,331.21 149,296.87 29.04 364,803.13 45,000.00 3,276.71 7,034.45 15.63 37,965.55 80,500.00 8,551.47 25,103.19 31.18 55,396.81 6,900.00 665.03 1,920.77 27.84 4,979.23 69,100.00 5,721.57 22,698.74 32.85 46,901.26 715,600.00 55,545.99 206,059.02 28.79 509,545.98 5,350.00 382.50 3,990.00 74.58 1,360.00 12,900.00 5,742.25 5,732.73 44.44 7,167.27 18,250.00 6,124.75 9,722.73 53.28 8,527.27 5,450.00 245.00 753.61 13.83 4,696.39 13,250.00 2,500.00 4,095.00 30.91 9,155.00 600.00 0.00 0.00 0.00 600.00 11,600.00 966.67 3,866.68 33.33 7,733.32 30,900.00 3,711.67 8,715.29 28.20 22,184.71 TOTAL Investigations 764,750.00 65,382.41 224,492.04 29.35 540,257.96 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) -_` 0=' _-_-- ~ -'-- I -~cl ~ ..~ __:_ 3~CC~_ PERIOD' __.33. .,_ _~_~ ~Ot,rto_ Police Supo:r~ ~~-`-„-- rsonal - 101-4-2159-4101 Regular ?ay 101-4-2150-4102 Overtime Pay -O1-4-2150-4104 PFRA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4109 Insurance TCTAL Personal ..ervices Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOT.~I, 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 342,350.C0 _5,196.83 100,787.28 29.44 241,562.72 3,500.00 86.29 529.46 15.13 2,970.54 25,100.00 2,746.40 8,22E 20 32.75 16,878.80 21,450.00 2,299.44 6,832.34 31.85 14,617.66 5,000.00 537.74 1,597.80 31.96 3,402.20 59,300.00 4,159.01 16,539.73 27.89 42,760.27 456,700.00 35,025.71 134,507.81 29.45 322,192.19 1,000.00 45.93 222.89 22.29 777.11 3,000.00 625.94 727.57 24.25 2,272.43 14,900.00 3,957.66 5,556.47 37.29 9,343.53 18,900.00 4,629.53 6,506.93 34.43 12,393.07 3,350.00 0.00 149.93 4.48 3,200.07 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 1,368.19 2,640.70 16.50 13,359.30 500.00 0.00 250.00 5'0.00 250.00 6,200.00 516.67 2,066.68 33.33 4,133.32 27,900.00 1,884.86 5,107.31 18.31 22,792.69 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-9-2160-4219 Operating Supplies TOTAL Supplies 503,500.00 41,540.10 146,122.05 29.02 357,377.95 5,500.00 0.00 350.00 0.00 100.00 0.00 5,950.00 0.00 3,500.00 2,319.23 5,000.00 79.65 8,500.00 2,398.88 0.00 0.00 5,500.00 0.00 0.00 350.00 o.oo o.o0 100.00 0.00 0.00 5,950.00 3,393.36 96.95 106.64 149.26 2.99 4,850.74 3,542.62 41.68 4,957.38 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) -~_`~\~-fetl--a -1C - - _C1- _160-4., _ Oth., -_„-_.,s oral Ser,____ 101-4-2160-43^1 `~eleohone 101-4 _160-4x31 Travel, Coa~__._~~~ o Schocls _~1-4 2160-4359 Pnb1_shinc 101-4-2160-4433 Dues & S_.,~~r_otions TCTAL Other Services & Charges =vital Out~ay 3REzi I 3 ,.~D ~-.~ ..,. sDI:'~ -_._~~ _,500.GO .. ~. 100.00 ~~. 00 1,700.00 0. 3C 150.C0 O. OC 1,ooe.oo c. oo 4,450.00 0. 00 r.'3 -'"` D=^F ~ .,_ ~ ADO='= __~ ~__. ~~___ - .~.-L'QC_ _, - ~.v~ ,`.?5. 00 C.00 0 .00 _x.;. 00 0.00 0 .00 ,~~. OG 0.00 0 .00 "-SC. oo 0.00 ~ O .OC i,00C. 00 -,125.00 =5 .28 3,325. 00 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 18,900.00 2,398.88 4,667.62 24.70 14,232.38 109,700.00 7,767.14 30,384.37 29.02 74,315.63 7,600.00 842.77 2,483.91 32.68 5,116.09 6,500.00 723.15 2,100.14 32.31 4,399.86 1,500.00 169.12 491.18 32.75 1,008.82 13,700.00 1,222.24 4,774.39 34.85 8,925.61 4,550.00 0.00 2,088.50 45.90 2,961.50 138,550.00 10,724.42 42,322.49 30.55 96,227.51 15,000.00 569.20 4,556.55 30.38 10,443.45 15,000.00 569.20 4,556.55 30.38 10,443.45 5,550.00 0.00 2,383.00 42.94 3,167.00 19,450.00 2,497.80 6,590.54 33.88 12,859.46 31,600.00 1,188.07 3,282.62 10.39 28,317.38 56,600.00 3,685.87 12,256.16 21.65 44,343.84 210,150.00 14,979.49 59,135.20 28.14 151,014.80 91,000.00 7,183.89 28,776.30 31.62 62,223.70 182,250.00 12,258.98 40,214.11 22.07 142,035.89 13,750.00 1,585.96 9,720.71 34.33 9,029.29 12,250.00 1,514.58 2,934.93 23.96 9,315.07 30,000.00 1,620.80 0.00 0.00 30,000.00 5-16-2012 09:31 AM iC °ty __.~_c ~- __R COvP. 0~-(- -.~-417 ~~e~.~::a=e 101-4 51~-4i c_ ~.~~u ~_.,,_ 101-4-2310-41C9 ncrkers Co-.p TOTAL Personal .,ervices Supplies 101-4-2310-4201 Office Supplies 101-4-2310-42 i2 Fuels & Lobs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies 101-4-2310-4221 Equipment Parts TCTAL Supplies Cther Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-4-2310-4389 Utilities 101-4-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 6,_ J.~_ ~.__ -.-_ 51.-~ ..-_ ,650.C0 - _.50 64.57. - - - 362,950.00 25,414.^^-2 96,98."_3 26.48 __ ~ ._ 4,?50.OC ~L_._- 759.20 __.57 ,~6G.80 6,950.00 1,027.26 1,963.81 28.33 4,981.19 7,450.00 1,016.75 1,092.74 14.67 6,357.26 32,100.00 1,367.17 7,970.84 24.83 24,129.16 7, r, 00.00 142.22 732.37 10.46 6,267.63 57,750.00 3,666.27 12,553.96 21.74 45,196.04 5,4C0.00 102.50 1,871.02 34.65 3,528.98 3,150.00 188.37 668.14 21.21 2,481.86 500.00 0.00 190.88 38.18 309.12 17,450.00 377.78 2,261.85 12.96 15,188.15 300.00 0.00 0.00 0.00 300.00 16,100.00 0.00 7,109.50 44.13 8,995.50 11,700.00 1,114.8.9 3,660.72 31.29 8,039.28 5,450.00 7.18 374.06 6.86 5,075.94 40,550.00 735.66 8,223.96 20.28 32,326.04 1,400.00 200.00 1,342.00 95.86 58.00 32,800.00 2,733.33 10,933.32 33.33 21,866.68 134,800.00 5,459.71 36,630.45 27.17 98,169.55 TOTAL Fire Administration Fire Inspections ' Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-9107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) -- OF: =---- "- ~ ---- 555,500.00 34,540.40 195,282.54 26.15 410,217.46 132,350.00 10,168.22 40,672.88 30.73 91,677.12 15,200.00 1,752.90 5,247.23 34.52 9,952.77 3,350.00 444.38 1,242.87 37.10 2,107.13 1,900.00 231.90 670.70 35.30 1,229.30 15,300.00 1,240.11 4,960.44 32.42 10,339.56 168,100.00 13,837.51 52,794.12 31.41 115,305.88 2,250.00 0.00 0.00 0.00 2,250.00 2,600.00 292.79 595.23 20.97 2,054.77 1,400.00 ~ 0.00 0.00 0.00 1,400.00 5,150.00 24.37 651.89 12.66 9,498.11 11,400.00 317.16 1,197.12 10.50 10,202.88 5-16-2012 09:31 AM _-s1~c .ar_tY . _I?=.R _1/~WT~ ~_,rENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) PAGE: 17 CUR3EIdT ..~_._~ES7 'iE~n r'0 LL'-_TE ~ CF 3JDC-'" BUDGET rE3I0I~ -_CTJAL ~IIDG?'I 3 ~11C- ~'_her Services & Charges ___-4-2320-4321 __-ephone ,350.00 187.67 608._ 18.16 _,74'_. __r4-2320-4331 Travel, Conferences & Schools 2,250.00 C.00 "-00.00 4.44 ,150.00 101-4-2320-4404 Equip Repair/Maim Services 1,550.00 0.00 =84.C6 31.23 1,065.94 101-4-2320-4433 Dues & Subscriptions 1,350.00 O.OG 960.00 71.11 390.00 TCTP_L Other Services & Charges 8,500.00 187.67 2,152.31 25.32 6,347.69 TOTAL Fire Inspections 188,000.00 14,342.34 56,143.55 29.86 131,856.45 Emergency Management ------------------ Personal Services 101-4-2330-4101 Regular Pzy 9,400.00 710.20 2,840.80 30.22 6,559.20 101-4-2330-4104 PERA 1,350.00 153.42 459.25 34.02 890.75 101-4-2330-4107 Medicare 150.00 15.45 46.25 30.83 103.75 101-4-2330-4108 Insurance 600.00 39.13 156.52 26.09 443.48 TOTAL Personal Services 11,500.00 918.20 3,502.82 30.46 7,997.18 Supplies 101-4-2330-4201 Office Supplies 500.00 9.24 143.74 28.75 356.26 101-4-2330-4219 Operating Supplies 9,150.00 2,271.40 2,977.64 32.54 6,172.36 TOTAL Supplies 9,650.00 2,280.64 3,121.38 32.35 6,528.62 Other Services & Charges 101-4-2330-4321 Telephone 1,650.00 26.00 78.00 4.73 1,572.00 101-4-2330-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2330-4331 Travel, Conferences & Schools 3,700.00 0.00 0.00 0.00 3,700.00 101-4-2330-4389 Utilities 1,500.00 73.44 217.95 14.50 1,282.55 101-4-2330-4404 Equip Repair/Maint Services 5,800.00 257.69 613.07 10.57 5,186.93 101-4-2330-4433 Dues & Subscriptions 100.00 100.00 100.00 100.00 0.00 TOTAL Other Services & Charges 13,750.00 457.13 1,008.52 7.33 12,741.48 Capital Outlay 101-4-2330-4560 Equipment 69,000.00 0.00 0.00 0.00 69,000.00 TOTAL Capital Outlay 69,000.00 0.00 0.00 0.00 69,000.00 TOTAL Emergency Management 103,900.00 3,655.97 7,632.72 7.35 96,267.28 Building Safety 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) G-S ~- • ='-~-- "--~ -~-- 33.3? o OF '~~T,R COMP. ..~R'ta2l CtiRREKT =~-'_R _.. D=:TE a CF 3UDGEm B;iDG~_ _FPIO~ ~ ., ..=~ BUDGE" E._~.'-NCE sc-al ___ _Ol- _~-- Jl Rec ~ _a~, "_G1-='. ~1~-4 ~~ Part time Pay - _-_-241'„-4-15 _=~r_ ~__-_-2416-4107 Medicare _~2i-4-2410-4108 -.,surance 101-4-2410-4109 Tniorkers Comp TOTP.T~ Personal Services Supplies 01-4-2410-4201 Office Suaalies 101-4-2410-4212 Fuels & Lubs _01-4-2410-421"7 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTP.L Supplies Other Services & Charges 101-4-2410-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-9433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay I TOTAL Building Safety Environmental Personal Services 101-4-2940-4101 Regular Pay 101-4-2940-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services !25,750.00 2~,0~.25 LOC,2a2.97 30.71 __,517.0 26,450.00 _,086.92 8,376.33 31.67 18,;3.67 25,550.00 2,962.44 8,835.77 34.58 16,714.23 _1,850.00 2,464.79 7,213.29 33.01 14,636.71 5,100.00 576.44 1,686.95 33.08 3,413.05 41,400.00 3,2'3.01 12,852.04 31.04 28,547.96 1,650.00 0.00 764.50 46.33 885.50 447,750.00 36,361.95 139,961.85 31.26 307,788.15 4,300.00 118.88 737.08 17.14 3,562.92 3,200.00 436.37 992.45 31.01 2,207.55 900.00 0.00 353.62 39.29 546.38 1,550.00 0.00 100.66 6.99 1,449.34 9,950.00 555.25 2,183.81 21.95 7,766.19 1,250.00 118.58 316.19 25.30 933.81 400.00 0.00 72.71 18.18 327.29 1,550.00 14.36 358.34 23.12 1,191.66 650.00 0.00 295.00 45.38 355.00 7,700.00 214.01 2,362.28 30.68 5,337.72 800.00 280.00 515.00 64.38 285.00 3,300.00 275.00 1,100.00 33.33 2,200.00 15,650.00 901.95 5,019.52 32.07 10,630.48 473,350.00 37,819.05 147,165.18 31.09 326,184.82 31,600.00 2,432.08 9,692.32 30.67 2,300.00 261.90 811.60 35.29 1,950.00 207.73 627.75 32.19 450.00 48.59 146.84 32.63 5,300.00 968.09 1,915.17 36.19 600.00 0.00 281.50 46.92 42,200.00 3,416.39 13,475.18 31.93 21,907.68 1,488.40 1,322.25 303.16 3,384.83 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) _-F __ ~~_bRi~ ?1T_~, __._~IID__., .T., B-..'DG=_ ?LP1~., _.. .. _~ ~:JC:T_ T_ .~13~CE --.-4-=!4C-~.-_ ~_.-„_ Su~ao Les -C1-4 -4_,~'-C-__ Faels is Lucs mCT.'_L S°~pc_i~s - ~r - .,es ~ Ch~raes __1-4-^_440-4321 Tele~ho^:e _^1-4-2440-4322 Postage -101-4-24x0-4331 Travel, Conferences & Schools iC1-4-2440-4359 Publisting 101-4-2440-4409 Cor_tractual Services 101-4-2490-4433 Dues & Subscriptions TCTAL Other Services & Charges I TOTAL Environmental SCC.CC ..- -0._1 35.04 3-4.7~ ,_50.00 - ~6.'_^_ 30.83 103.76 650.00 56.15 22-._, 34.0; 428.55 S5G.00 11.63 19.96 3.63 530.04 800.00 0.00 113.66 14.18 686.54 500.00 188.71 343.71 68.74 156.29 100.00 o.oc o.oo o.oo -oo.co 3,000.00 0.00 0.00 0.00 3,000.00 1,050.00 0.00 90.00 3.81 1,010.00 6,000.00 200.34 517.13 8.62 5,482.87 48,850.00 3,614.88 19,213.76 29.10 34,636.24 I TCTAh Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-9-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-4219 Operating Supplies 101-4-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101.-4-3120-4361 Insurance 101-4-3120-9389 Utilities 101-4-3120-4401 Bldg Repair/Maint Services 5,782,450.00 422,435.58 1,657,151.49 28.66 4,125,298.51 386,700.00 39,192.39 120,557.24 31.18 266,142.76 116,600.00 5,575.91 17,799.84 15.27 98,800.16 32,200.00 4,299.20 10,804.97 33.56 21,395.03 31,200.00 3,732.93 9,300.27 29.81 21,899.73 7,300.00 673.00 2,175.09 29.80 5,124.91 64,700.00 6,469.38 20,766.47 32.10 43,933.53 27,600.00 0.00 12,382.50 44.86 15,217.50 666,300.00 60,142.81 193,786.38 29.08 972,513.62 9,200.00 54.53 921.83 21.95 3,278.17 87,250.00 21,855.73 26,481.56 30.35 60,768.44 110,750.00 3,623.38 36,305.01 32.78 74,444.99 35,850.00 5,530.50 6,027.82 16.81 29,822.18 238,050.00 31,064.14 69,736.22 29.29 168,313.78 250.00 0.00 212.33 84.93 37.67 7,450.00 504.83 1,621.14 21.76 5,828.86 200.00 0.00 49.21 24.61 150.79 2,500.00 442.28 742.28 29.69 1,757.72 500.00 0.00 0.00 0.00 500.00 18,750.00 0.00 7,688.00 91.00 11,062.00 36,000.00 3,958.68 11,209.38 31.14 24,790.62 4,500.00 0.00 1,413.43 31.41 3,086.57 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) I ...: 1` ,.:woks ~ .~ __.~_ _ ..c -_-. ~O~r~. 1C'--4 3_20-4404 ECUlo Rec~_:/1'._1r_t ~_ ,_~__ .00 ..Oi ~ .CO _. _ -,Sn"3.00 101-4 3120-4409 Con`s-~~u~l Services __,000.00 ,t~._~ ~_,_J.__ -._, ._ _.,.6" 101-4-3120-4~i5 Equ~p~_.~ _~._ta1 5,~ x.00 u6.L __._- ~._1 ,-~ ~..-4 312v-?'_ ~.__tor*~. ~~nta~ _,700._, 1 _.~~ a6.~_ _.44 x,_03.49 101-4-3120-=433 ~_~~ o Scbscrip _~.,~ .,~..~0 ,.00 _°~6.~5 __.~_ 63.5 161-4-3120-4437 Ta~_es & Licer_ses 500.00 30.00 446.00 59.20 54.00 101-4-3120-9460 Ecuip Replacement Charges _5,756.00 979.17 31,916.68 3.33 63,833.32 TOTP1, tither Services & Charges 600,956.00 15,7°,3.56 89,511.16 14.89 511,=_38.84 Capital Outlay TOTAL 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-9108 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-4560 Equipment TOTAL Capital Outlay 1,505,300.00 106,990.51 353,033.76 23.45 1,152,266.24 100,300.00 0.00 41,655.38 41.53 58,644.62 20,000.00 0.00 6,537.25 32.69 13,462.75 9,100.00 0.00 0.00 0.00 9,100.00 8,350.00 154.30 3,489.80 .41.79 4,860.20 8,000.00 185.93 3,028.56 37.86 4,971.44 1,900.00 43.48 708.26 37.28 1,191.74 17,100.00 0.00 6,210.18 36.32 10,889.82 7,650.00 0.00 3,059.50 39.99 4,590.50 172,400.00 383.71 64,688.93 37.52 107,711.07 96,000.00 0.00 31,927.64 33.26 64,072.36 96,000.00 0.00 31,927.64 33.26 64,072.36 20,000.00 0.00 0.00 0.00 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Snow Removal Equipment Services Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 288,400.00 383.71 96,616.57 33.50 191,783.43 166,050.00 12,772.80 98,181.92 29.02 117,868.08 0.00 232.56 232.56 0.00 ( 232.56) 12,050.00 1,405.89 3,963.87 32.90 8,086.13 10,300.00 1,157.94 3,239.57 31.90 7,065.43 2,400.00 270.80 756.46 31.52 1,643.54 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) :nm ~ -s A ~-.... '-CD ~ u~c. I ~_~nRTN_~N-F~ ~r_2~.NC'?_~_~KLS ~.~., F ~__~~ ..0'_I~. C~RPr\T OL:R~~I~T ]r.''.R _J J~.__ s .._ ~JIO-_ ~~'~DC__ PERIOD ~ ~T.:_ ~ -..~~__ __ .~-_'vCL ~C1-4 -50-41~ __~__^ance 23,100.09 1,7 B.CC e',57t,62 _3.1C 16 -_5.38 1C1-4-3'_50-4109 Wcrkers Como 4,500.00 O.CC ^,054.50 X5.66 _,445.50 TOTAL ~__.oral Services ~~ ,700.00 - ,617.99 64,9_°•8.50 29.7_ _~_,-__.~~ S '^ ies 101-4-3'_50-9219 Operating Supplies 20,200.00 1,169.27 3,13.03 '_4.92 1?,=Se'.97 101-4-3150-4221 Equipment Parts 6,000.00 O.CO 0.00 0.00 6,000.00 TOT?=L Supplies 26,200.00 1,169.21 3,013.03 11.50 23,1C6.9i Other Services & Charges ""~C1-4-3150-4417 Uniform Rental 3,000.00 276.63 807.65 26.92 2,192.35 TOTAL Other Services & Charges 3,000.00 276.63 807.65 26.92 2,192.35 Capital Outlay TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies 101-4-3300-4212 Fuels & Lubs 101-4-3300-9219 Operating Supplies TOTAL Supplies 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/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges 247,900.00 19,063.69 68,819.18 27.76 179,080.82 79,250.00 7,034.62 28,138.48 35.51 51,111.52 5,750.00 765.00 2,290.00 39.83 3,460.00 4,900.00 639.41 1,899.15 38.76 3,000.85 1,150.00 149.54 444.16 38.62 705.84 14,050.00 521.00 2,084.00 14.83 11,966.00 550.00 0.00 288.50 52.45 261.50 105,650.00 9,109.57 35,144.29 33.26 70,505.71 500.00 15.85 28.70 5.74 471.30 600.00 55.27 55.27 9.21 549.73 1,000.00 0.00 16.00 1.60 989.00 2,100.00 71.12 99.97 4.76 2,000.03 13,500.00 0.00 65.69 0.49 13,434.31 700.00 1.30 17.96 2.57 682.04 150.00 0.00 14.70 9.80 135.30 2,700.00 60.00 60.00 2.22 2,640.00 200.00 0.00 91.00 45.50 109.00 7,800.00 187.03 1,047.97 13.44 6,752.03 750.00 62.50 250.00 33.33 500.00 25,800.00 310.83 1,547.32 6.00 24,252.68 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) I _nnLc~~itioria=-•y ,.i <PEI1`_" CURREI:T. BJJ:.ET PER_OD .,3.33 0? °~~~ COLP. :~_P TC ~ __~ s ~_ EJDGET -~ ~.~ ~„~~~_ B_~F,NCE -~TAL EnC' .eeri.-ig TCTP?. Public W'vrks Parks Department Personal Services 1Ci-4-S1i0-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-9103 Part-time Pay 101-4-5110-4109 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies 101-4-5110-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-5110-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-9-5110-4401 Bldg Repair/Maint Services 101-4-5110-4409 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 133,550.00 9,491.53 36,791.58 27.55 96,758.42 2,175,150.00 135,929.63 555,261.09 25.53 1,619,888.91 344,300.00 28,589.13 108,990.94 31.66 235,309.06 6,600.00 0.00 310.08 4.70 6,289.92 58,250.00 2,204.48 2,204.48 3.78 56,045.52 26,900.00 2,824.85 8,657.15 32.18 18,242.85 25,500.00 2,699.61 7,398.32 29.01 18,101.68 6,000.00 631.36 1,730.22 28.84 4,269.78 46,200.00 3,878.36 15,513.44 33.58 30,686.56 10,850.00 0.00 5,164.00 47.59 5,686.00 524,600.00 40,827.79 149,968.63 28.59 374,631.37 39,100.00 2,913.34 4,815.41 12.32 34,284.59 3,200.00 19.06 839.76 26.24 2,360.24 78,250.00 7,270.08 18,815.96 24.05 59,434.04 13,000.00 2,593.08 7,516.49 57.82 5,483.51 133,550.00 12,795.56 31,987.62 23.95 101,562.38 3,800.00 216.40 673.33 17.72 3,126.67 50.00 0.00 0.00 0.00 50.00 3,150.00 ( 465.72) 1,942.40 61.66 1,207.60 27,600.00 0.00 12,020.50 43.55 15,579.50 24,700.00 341.95 903.85 3.66 23,796.15 4,000.00 0.00 0.00 0.00 4,000.00 13,100.00 1,740.73 2,467.39 18.89 10,632.61 7,300.00 191.00 191.00 2.62 7,109.00 20,500.00 529.47 1,812.52 8.84 18,687.48 51,450.00 4,287.50 17,150.00 33.33 34,300.00 155,650.00 6,841.33 37,160.99 23.87 118,489.01 TOTAL Parks Department 813,800.00 60,464.68 219,117.24 26.93 594,682.76 5-16-2012 09:31 AM I `v ~ n - ~~__.. Re .~..,.,o ,^~F Y~r.R .,OMP. ,.;._z_.~~_ CliR3EP;: _~_R ^_0 .,-- $ CF BUDGET _;:~,,,-T PERIOD ~_., __- BUDGE^_ B'.~zNCE ~ =arks ~ Rec -.~._ir sonal Serv_^ 101-4-5210-4"-0~ Regular Pay 101-4-5210-4103 .art-*_ime Pav 101-4-5210-4104 PEF~ '_O1-4-5210-4105 =~..: 101-4-5210-4107 Medicare '01-4-5216-4108 Insurance 301-4-5210-4109 Ldcrkers Comp TOTAL Personal Services Supplies 101-4-5210-4219 Operating Supaiies TOTAL Supplies Other Services & Charges 101-4-5210-4321 Telephone 101-9-5210-4322 Postage 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges ' Capital Outlay TOTAL Parks & Rec Admin ~ Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-9-5220-4105 FICA 101-4-5220-4107 Medicare TOTAL Personal Services CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) 352,350.00 26,929.29 11,7,177.42 30.42 245,172.58 45,300.C0 3,494.37 13,327.57 29.42 31,972.43 ~~,200.C0 3,305.94 9,787.13 35.98 17,412.87 23,300.00 2,703.91 7,886.78 33.85 15,413.22 5,450.00 632.33 1,844.42 33.84 3,605.58 52,700.00 3,998.91 15,746.13 29.88 36,953.87 4,450.00 0.00 2,052.00 46.11 2,398.00 510,750.00 41,064.75 157,821.45 30.90 352,928.55 10,200.00 374.60 4,324.23 42.39 5,875.77 10,200.00 374.60 4,324.23 42.39 5,875.77 4,800.00 369.61 1,240.45 25.84 3,559.55 6,000.00 1,357.36 1,528.55 25.48 4,471.45 6,850.00 166.20 1,703.46 24.87 5,146.54 32,400.00 5,608.26 6,376.96 19.68 26,023.54 650.00 0.00 295.00 45.38 355.00 7,400.00 526.28 1,631.21 22.04 5,768.79 13,300.00 930.99 4,866.62 36.59 8,433.38 9,350.00. 240.47 1,959.70 20.91 7,395.30 1,550.00 0.00 1,339.00 86.06 216.00 82,300.00 9,199.17 20,930.45 25.43 61,369.55 603,250.00 50,638.52 183,076.13 30.35 420,173.87 82,000.00 1,239.86 7,507.30 9.16 74,992.70 2,400.00 73.03 204.69 8.53 2,195.31 4,350.00 108.36 473.97 10.90 3,876.03 1,200.00 25.37 110.87 9.24 1,089.13 89,950.00 1,446.62 8,296.83 9.22 81,653.17 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) ~- -- - , .".,.1LL__ a _t e ."_..c _____ ^pl 101-~ 020-4=_~ Ope --_ __ries TO _L Supplies - ces Charges 101-4-5220-4409 Contractual Services i01-4-5226-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges I TCTAL Recreation Programs Concessions - ~r_,.00 ^~ ~92.~6 ~ 3=,30 M4 37,000.00 ~.=! _,c _._. -. _ ~ 307.94 64,050.00 O.OC -,964.?8 3.07 62,085.2 1,500.00 O.OC C.00 0.00 1,500.60 4,500.60 6?6.32 "_,504.43 33.43 2,995.57 70,C50.00 6+6.32 3,469.21 4.95 66,580.79 197,000.00 2,4"_6.18 16,458.10 8.35 180,541.90 Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 0.00 6.00 0.00 3,650.00 101-4-5230-4104 PERA 150.00 0.00 0.00 0.00 150.00 101-4-5230-4105 FICA 250.00 0.00 0.00 0.00 250.00 101-4-5230-4107 Medicare 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 4,100.00 0.00 0.00 0.00 9,100.00 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 14,100.00 0.00 0.00 0.00 14,100.00 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 58,550.00 9,504.01 62,350.00 4,866.36 8,750.00 1,016.48 7,500.00 835.75 1,750.00 195.46 14,100.00 1,154.51 650.00 0.00 153,650.00 12,572.57 18,016.04 30.77 90,533.96 19,505.51 31.28 42,844.49 3,056.59 39.93 5,693.41 2,479.86 33.06 5,020.14 579.94 33.14 1,170.06 4,618.04 32.75 9,481.96 290.50 49.69 359.50 48,596.48 31.60 105,103.52 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) __.. OF. . -__ _ ____ , _.,__ _~....,c ,._ __,. ~. ~^~iJD. CURRES~" ..._ RRE!1T =E_'-gin _.. ~-_~ £ .~~ D,:DG-_ BUDGE= ERIC=' _"~ v =- .~~~D;ET _ ~~_ ~L'~D 11ec '_01-4-5510-4i-9 Oper~t_ng S.,p-ies TOTAL Suoclies Cther Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-4-5510-4331 :ravel, Conferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 1U1-4-5510-4404 Equip Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TCTAL Other Services & Charges Capital Outlay 101-4-5510-4560 Equipment TOTAL Capital Outlay 13,350.00 627.OC _,n'9~.33 1"_, 65.67 13,350.00 627.00 1,694.33 __. _ _"'-,655.67 2,600.00 _.,7.79 632.01 24.31 1,967.99 2,500.00 500.00 1,034.22 41.37 1,565.78 1,900.00 55.50 155.50 8.18 -,744.50 1,600.00 0.00 705.50 44.28 891.50 9,300.00 880.94 2,647.77 28.47 6,652.23 13,750.00 629.38 3,720.17 27.06 10,029.83 1,950.00 180.39 694.46 35.61 1,255.54 7,450.00 8.00 ( 195.00) 2.62- 7,645.00 950.00 190.71 489.87 51.57 460.13 42,000.00 2,602.71 9,887.50 23.54 32,112.50 17,500.00 0.00 17,500.00 0.00 0.00 0.00 17,500.00 0.00 0.00 17,500.00 TOTAL Sr Citizen Programs 226,500.00 15,802.28 60,128.31 26.55 166,371.69 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-4107 Medicare 101-4-6210-4108 Insurance 101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-4322 Postage 101-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 1,854,650.00 129,321.66 478,779.78 25.82 1,375,870.22 0.00 9,607.92 23,982.34 0.00 ( 23,982.34) 0.00 1,050.33 2,100.66 0.00 ( 2,100.66) 0.00 1,075.68 1,769.53 0.00 ( 1,769.53) 0.00 957.60 1,503.38 0.00 ( 1,503.38) 0.00 228.29 355.93 0.00 ( 355.93) 0.00 1,991.00 2,982.00 0.00 ( 2,982.00) 0.00 ( 78.25) 0.00 0.00 0.00 0.00 14,332.57 32,693.84 0.00 ( 32,693.84) 0.00 ( 456.90) 0.00 0.00 0.00 0.00 ( 655.25) 0.00 0.00 0.00 0.00 ( 48.95) 0.00 0.00 0.00 0.00 ( 1,161.10) 0.00 .0.00 0.00 ' TOTAL Economic Development 0.00 13,171.47 32,693.84 0.00 ( 32,693.84) 5-16-2012 09:31 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) _~ 0°: so3,Tr _`mu, -`-- -- ~-'vsn.__ -~'d~ PAGE: 26 -co2om-c ~_._-ooment 33.33% OF ' ?n C01~P. CUKEL?'T CUnRE1_~_ __<n TO C=_,-.:„ c .._ 3JDv-_ R^'ii: N vL ~,PEL~ I~~RES BL~DC?T ~ERIOD -_,._v--L 3JDGET B>~-vNCE Euercy City - na1 Services 101-4-6220-4101 Regalar Pap 29,300.00 2,252.48 8,996.42 30.70 20,303.58 i01-4-6220-4104 PE RA 2,100.00 244.00 732.36 34.87 1,367.69 101-4-6220-4105 FICA 1,800.00 196.81 578.90 32.16 '!,221.10 '_0'.-4-6220-4107 Medicare 400.G0 46.03 135.41 33.85 264.59 101-4-622C-4108 Insurance 3,250.00 253.36 1,013.44 31.18 2,236.56 TvCTAL Personal Services 36,850.00 2,992.68 11,456.53 31.09 25,393.47 Supplies Cther Services & Charges 101-4-6220-4319 Other Professional Services 5,000.00 21.34 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 313.57 101-4-6220-4359 Publishing 1,500.00 115.00 TOTAL Other Services & Charges 14,000.00 449.91 52.09 1.04 4,947.91 452.50 6.03. 7,047.50 115.00 7.67 1,385.00 619.59 4.43 13,380.41 TOTAL Energy City 50,850.00 3,442.59 12,076.12 23.75 38,773.88 TOTAL Economic Development 50,850.00 16,614.06 44,769.96 88.04 6,080.04 Transfers Out Transfers Out 101-4-7000-9724 Transfer - Pinewood 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers Out 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers Out 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 12,678,050.00 951,284.21 3,551,472.57 28.01 9,126,577.43 REVENUES OVER/(UNDER) EXPENDITURES ( 366,150.00)( 829,071.55)( 2,797,063.22) 2,430,913.22 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) -_~ OF: _--~ _ 32mu, 201- 33..5iF ~' ._. ~R ~Dt`/P. .,~RRENT .,:;'RREp;I ~_R TO -_~ % CE 3QDGET BUDGET PER=OD ._.._~ _~ 3UDCET BALANCE _.=.-.tip;- .. ~i~%~- 2nc},c1; Concessio^a ...TAL REVENUES EXPENDITURE SUMIKP.RY Culture & Recreation Ice Arena Eockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 569,600.00 8,055.89 192,738.43 33.84 X76,861.57 30,000.00 682.50 46,597.50 155.33 ! 16,597.50) 65,°00.00 154.00 15,339.00 23.3'_ 50,461.00 69,000.00 ! 431.75) 36,821.14 53.36 32,178.86 734,400.00 8,500.64 291,496.07 39.69 442,903.93 543,550.00 39,861.42 169,461.08 31.18 374,088.92 25,000.00 768.02 7,737.34 30.95 17,262.66 28,750.00 1,048.03 5,328.03 18.53 23,421.97 47,150.00 3,214.39 24,122.83 51.16 23,027.17 644,450.00 44,891.86 206,649.28 32.07 437,800.72 644,450.00 44,891.86 206,649.28 32.07 437,800.72 89,950.00 ( 36,391.22) 89,846.79 5,103.21 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) =ce F_rena rges - Ser ces 221-3-0000-3464 Ice R_e r_ta1 _.1-3-0000-3465 Admissions ~~1-3-0000-3466 Dry Floor Ensats 221-3-0000-3468 Skate Shar~er_irg __~-3-0000-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charces for Services Other Revenue 221-3-0000-3621 interest Income 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 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 TOTAL Hockey Skating 33.~3F Or --=_R CO~rp. ...:RR=i~'~ _~_.RE^: - __. _R TO :~=TF e OF 3;JD C= _ 3UDsF_ ___.=OT __.,...AL 3ODGET 3AL.~IQC- _ N,000.CO ,255.1". '-59,679.56 32.'2 328,320.44 _ ,900.00 0.00 12,538.50 54.75 10,361.50 17,400.00 5,737.80 6,694.35 38.47 10,705.65 4,30C.00 132.00 2,163.G0 50.30 2,137.00 2,60C.C0 0.00 0.00 0.00 2,600.00 17,500.00 386.67 62C.O1 3.54 16,879.99 552,700.00 7,5"r1.58 181,695.42 32.87 371,004.58 0.00 0.00 44.91 0.00 ( 44.91) 14,000.00 453.81 5,822.71 41.59 8,177.29 0.00 0.00 3,997.00 0.00 ( 3,997.00) 2,800.00 64.60 1,042.94 37.25 1,757.06 16,800.00 518.41 10,907.56 64.93 5,892.44 100.00 25.90 135.45 135.45 ( 35.45) 100.00 25.90 135.45 135.45 ( 35.45) 569,600.00 8,055.89 192,738.43 33.84 376,861.57 30,000.00 682.50 46,597.50 155.33 ( 16,597.50) 30,000.00 682.50 46,597.50 155.33 ( 16,597.50) 30,000.00 682.50 46,597.50 155.33 ( 16,597.50) 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) _~ CL' -- - -`~T-~ -`-- ~ --- - ~~ T-`=L= ' S~.ENUES ..~nnEI3T ..~~RErC'~. '~E_ ~ _ `'_-'"=. a U= ~'TU-, PUuGL. PEPTCD -~_C-_ 3UDC2_ L=_~-?~~C_ Charges - Services 231-3-5420-3461 Recreation Fees 221-3-5420-3465 AcLmissions TOTED Charges for Services Other Revenue TOTAL Skating Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services ~ TOTAL Concessions ~ TOTAL REVENUE 63 , ~ 00 . ~.; ~~ ,8C JO 65,8GO.G0 '~94.OC --,39.00 __.-c 46,66-.02 O.OC .00 ,300.OC 194.00 _ .,9.00 _~.~_ 50,461.00 65,800.00 194.00 15,339.00 23.31 5C,461.00 69,OOO.CO ( 431.75) 36,821.14 53.36 32,178.86 69,000.00 ( 431.75) 36,821.14 53.36 32,118.86 69,000.00 ( 431.75) 36,821.14 53.36 32,178.86 734,400.00 8,500.64 291,996.07 39.69 442,903.93 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) _ _ _ _ _- .Y-i\ ,.,,P~Ei~_ CLRRFN~ x__-R T'0 EATS ~ Ct ~JDCF~ 3JDGT= PERIOC _~.. ..~ . 3J,CF'= ~ 1-!v CE ^ -~e Arena rsonal Services 221-4-5400-4101 Regular Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-540C-4107 Medicare 221-4-5400-91C8 Insurance 221-4-5400-4109 Workers Comp TOTAL Personal Services Supplies 221-4-5400-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/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-9-5400-9361 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-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-4-5400-4560 Equipment TOTAL Capital Outlay 167,600.00 10,529.97 45,646.23 27.24 121,953.77 59,300.00 4,592.76 26,259.22 44.28 33,040.78 15,700.00 1,594.89 5,Oi4.67 31.94 10,685.33 14,100.00 1,913.06 4,844.93 34.36 9,255.C7 3,350.00 330.48 1,133.10 33.82 2,216.90 26,400.00 1,881.00 7,524.00 28.50 18,876.00 8,000.00 0.00 3,579.50 49.74 9,420.50 294,450.00 20,342.16 94,001.65 31.92 200,448.35 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 3,859.89 11,818.15 34.51 22,431.85 8,000.00 0.00 2,879.04 35.99 5,120.96 600.00 0.00 0.00 0.00 600.00 44,200.00 3,859.89 14,697.19 33.25 29,502.81 3,500.00 142.34 481.79 13.77 3,018.21 400.00 9.49 17.76 4.44 382.24 1,000.00 0.00 73.45 7.35 926.55 2,000.00 644.90 799.90 40.00 1,200.10 7,800.00 0.00 3,413.00 43.76 4,387.00 142,450.00 13,689.03 42,913.16 30.13 99,536.84 22,750.00 676.34 3,793.49 16.67 18,956.51 1,200.00 0.00 326.60 27.22 873.40 2,800.00 502.27 601.01 21.46 2,198.99 500.00 0.00 230.00 46.00 270.00 184,400.00 15,659.37 52,650.16 28.55 131,749.84 20,500.00 0.00 8,112.08 39.57 12,387.92 20,500.00 0.00 8,112.08 39.57 12,387.92 TOTAL Ice Arena 543,550.00 39,861.42 169,461.08 31.18 374,088.92 5-16-2012 09:31 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) Lc QF; ~DR,T_ ___ , _.,__ ..__~~_~ ~ rcecr==-`on 33.rLo OF YE.'iR COMP. `. , kCnENT' CC I(KF~\-' T,-h _.. DrTG o ~,_ ~' .~__ /__t_KT' NT__L ~rP~I~:;_ '~_(.`~.~. 3JDG~T P~K_OL ~..~JP.~ 3J'J.~=T = y'\C.`~ _. i.,. ey --rsonal Services 221-4-5410-4103 Part-time Pay 3,600.00 0.00 0.00 0.00 3,600.00 221-4-5410-4105 F_„r. 200.00 0.00 O.GO 0.00 200.00 221-4-5410-4167 Medicare 50.00 0.00 0.00 0.00 50.00 TOTF.L Perscral Services 3,850.00 0.00 0.00 0.00 3,850.00 pplies 221-4-5410-4219 Opera*_ing Supplies 12,550.00 0.00 5,775.30 46.02 6,774.70 TOTAL Supplies 12,550.00 0.00 5,775.30 46.02 6,7'4.70 Other Services & Charges 221-4-5410-4409 Contractual Services 6,400.00 0.00 20.80 0.33 6,379.20 221-4-5410-4438 Credit Card Fees 2,200.00 768.02 1,941.24 88.24 258.76 TOTT~L Other Services & Charges 8,600.00 768.02 1,962.04 22.81 6,637.96 TOTAL Hockey 25,000.00 768.02 7,737.34 30.95 17,262.66 Skating Personal Services 221-4-5420-4103 Part-time Pay 15,000.00 881.03 3,323.58 22.16 11,676.42 221-4-5420-4109 PERA 1,000.00 53.56 123.72 12.37 876.28 221-4-5420-4105 FICA 950.00 86.27 218.71 23.02 731.29 221-4-5420-4107 Medicare 200.00 20.19 51.19 25.60 148.81 TOTAL Personal Services 17,150.00 1,041.05 3,717.20 21.67 13,432.80 Supplies 221-4-5420-4219 Operating Supplies 5,300.00 0.00 1,031.88 19.47 9;268.12 TOTAL Supplies 5,300.00 0.00 1,031.88 19.47 4,268.12 Other Services & Charges 221-4-5420-4359 Publishing 650.00 0.00 0.00 0.00 650.00 221-4-5420-4409 Contractual Services 2,850.00 0.00 46.40 1.63 2,803.60 221-4-5420-4438 Credit Card Fees 2,800.00 6.98 532.55 19.02 2,267.45 TOTAL Other Services & Charges 6,300.00 6.98 578.95 9.19 5,721.05 ' TOTAL Skating 28,750.00 1,048.03 5,328.03 18.53 23,421.97 5-16-2012 09:31 AM CITY OF. ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) 33.~I~~ OF '_~~~ COMP. ..~3YEr:= ~~_._~='T 1EAR -'0 D _TE a CF DJDC~= 3:5DC_--"' PEn=.,_ =CTUF_L 3UDGE~ 3. .'v:. 1 ~- ena Concessions _ .al Services ^_21-4-5430-4103 Part-t_me ?ay .0,900.00 249.56 5,78?.97 27.67 15,117.03 221-4-5430-4104 PERA 200. C0 ...... 101.67 50.84 98.33 221-4-5430-4105 FT CA 1,300.C0 58.92 415.16 31.94 884.84 221-4-5930-4107 1~edicare 300.00 13.79 97.08 32.36 202.92 TOTP.L Personal Services 22,700.00 329.47 6,396.88 28.18 16,303.12 Suoalies 221-4-5430-4219 Operatinc Supplies 2,950.00 97.99 2,437.41 82.62 512.59 221-4-5430-4259 Other Merchandise For Resale 21,500.00 2,786.93 15,288.54 71.11 6,211.46 TOTAL Supplies 24,450.00 2,884.92 17,725.95 72.50 6,724.05 TOTAL Arena Concessions 47,150.00 3,214.39 29,122.83 51.16 23,027.17 TOTAL Culture & Recreation 644,450.00 44,891.86 206,649.28 32.07 437,800.72 TOTAL EXPENDITURES 644,450.00 44,891.86 206,649.28 32.07 437,800.72 REVENUES OVER/(UNDER) EXPENDITURES 89,950.00 ( 36,391.22) 84,846.79 5,103.21 5-16-2012 09:32 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) CO- -.~_ REVENUE ;'?,7~L".k_ _l.~_wood Golf Course ,OTF_L REVENGES I EXPENDITURE SUNil 1P?2: Culture S Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES ~?DGET ?ER1OC .., ...3E V' _E:'.R ~~J~`~P. __ _. _~ ~__?- s C. 3JDG~_ ^_36,50C. 00 °3 - 4` 9u 59.56 236,500. 00 23 ,828.91 44,910.c2 _6.99 191 ,589.56 236,500.00 21,666.32 49,406.92 20.89 187,093.08 236,500.00 21,696.32 49,406.92 20.89 167,093.08 236,500.00 21,686.32 49,406.92 20.69 167,093.08 0.00 2,142.59 ( 4,496.50) 4,496.50 5-16-2012 09:32 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) __ 0~': npP,T~ ?~m_, ---- ~ __ -r rdE in 0OC =..~- O~n~= I RE~'aNLES ~...l..s ..= YEGA CO'_/_?. C ~.RP=1_~T C~nn~NT -F_'.R - ;~=_TE E CF 3 2~-_ 3UDJET P-K=C= -,CTJ~_L 3:'DG2T b-..-.'_:..~ Pinewood Golf Course urges for Services 222-3-0000-3461 Recreation Fees _ ?-3-0000-3467 Concessions 222-3-000C-3469 Other Sales 222-3-000G-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments TOTAL Charges-for Services Sales 222-3-0000-3792 Cash Over TOTAL Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In I TOTAL Pinewood Golf Course 16,500.00 3,944.00 7,556.00 45.79 8,944.G0 16,000.00 1,328.02 1,877.42 "_1.73 14,122.58 3,500.00 675.17 969.65 27.%0 2,530.35 120,000.00 _%,'10.22 18,072.53 15.06 101,927.07 16,500.00 3,870.00 13,685.G0 82.94 2,815.00 18,500.00 1,759.00 2,835.C0 15.32 15,665.00 5,000.00 0.00 0.00 0.00 5,000.00 196,000.00 23,886.41 44,996.00 22.96 151,004.00 0.00 ( 57.50)( 85.58) 0.00 85.58 0.00 ( 57.50)( 85.58) 0.00 85.58 40,500.00 0.00 0.00 0.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 236,500.00 23,828.91 44,910.42 18.99 191,589.58 TOTAL REVENUE 236,500.00 23,828.91 49,910.92 18.99 191,589.58 5-16-2012 09:32 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) --- CF' =--~- =CT- ~ ^OL ~-~apl2 ~'~~NTFS, EPDN:,! "'URES 33.33$ CF =_ _P .,C?/.?. CJRRENT ~;;RRE?~T iEF~K TC ~:T-~ ~ CE 3UDG-- 37DGFT PERIOD - -;;AL 'DG°_"- 3 is-'~C~' Golf Course ~sonal Servic es 222-4-530G-4101 Regular Zap 87,100.G0 7,208.16 22,952.69 26.35 64,147.36 222-4-5300-4103 Part-time Pay 29,900.00 1,711.67 2,270.32 7.59 27,629.18 222-4-5300-4104 PERA 8,500.00 917.21 1,968.29 23.16 6,531.71 222-4-5300-4105 FICA 7,250.00 806.41 1,694.76 23.38 5,555.24 222-4-5300-4107 Medicare 1,700.00 188.58 396.32 23.31 1,303.68 222-4-5300-4108 Insurance 6,100.00 465.00 1,860.00 30.49 4,240.00 222-4-5300-4109 Workers Comp 1,850.00 O.CO 797.00 43.G8 1,C53.00 TOTAL Personal Services 142,400.00 11,297.03 31,939.83 22.43 110,46C.17 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 0.00 0.00 0.00 4,500.00 222-4-5300-4217 Uniform Allowance 500.00 102.36 186.02 37.20 313.98 222-4-5300-4219 Operating Supplies 29,700.00 6,295.81 6,586.52 22.18 23,113.48 222-4-5300-4259 Other Merchandise For Resale 12,000.00 2,042.50 2,042.50 17.02 9,957.50 TOTAL Suppli es 46,700.00 8,440.67 8,815.04 18.88 37,884.96 Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 172.75 508.20 21.18 1,891.80 222-4-5300-4331 Travel, Conferences & Schools 450.00 0.00 17.69 3.93 432.31 222-4-5300-4349 Advertising/Marketing 5,000.00 1,135.00 1,746.20 34.92 3,253.80 222-4-5300-4361 Insurance 12,100.00 0.00 5,144.50 42.52 6,955.50 222-4-5300-4389 Utilities 6,550.00 124.29 401.90 6.14 6,198.10 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 105.04 145.12 1.62 8,804.88 222-9-5300-4404 Equip Repair/Maint Services 4,600.00 0.00 997.20 21.68 3,602.80 222-4-5300-4415 Equipment Rental 1,350.00 46.23 46.23 3.42 1,303.77 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 143.73)( 960.07) 96.01- 1,960.07 222-4-5300-4438 Credit Card Fees 5,000.00 509.04 605.08 12.10 4,394.92 TOTAL Other Services & Charges 47,400.00 1,948.62 8,652.05 18.25 38;797.95 Capital Outlay Debt Service ' TOTAL Golf Course 236,500.00 21,686.32 49,406.92 20.89 187,093.08 I TOTAL Culture & Recreation 236,500.00 21,686.32 49,406.92 20.89 187,093.08 ^ TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 236,500.00 21,686.32 49,406.92 20.89 187,093.08 0.00 2,192.59 ( 4,496.50) 4,496.50 5-16-2012 09:33 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) _~ND ACCOUNT# _CCOUNT VP.NF BEC-INN_NG C,.iRRENT C'JRRE'TT 3A_LANCE 002-1010 Casa - Section 125 _0"~-1010 Cash - Genera_ Fund 211-1010 Cash - Library 221-1010 Cash - Ice F_reza 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedicaticn 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 240-1010 Cash - Micro Loan Fund 241-1010 Cash - DIED 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 344-1010 Cash - 2006C Cap Imp Bonds Lby 345-1010 Cash - 2012A CIP Bonds-PW 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 440-1010 Cash - Park Improvement 459-1010 Cash - TIF #19 Highway 169 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 _6, ,,.~_ ,G50.52 2" 329.13 4,273,078.24 ( 922,582.91) 3,,50,495.33 432,988.47 3,124.16) 429,864.31 21,134.02 46,280.85 67,414.87 ( 4,223.98) 1,991.14 2,232.84) 12,201.07 ( 637.61) 11,563.46 0.00 ( 42,300.00) ( 42,30C.00) 875,390.81 ( 6,860.55) 868,530.26 698,152.00 C.00 698,152.00 1,292,960.32 18,120.99 1,311,081.31 346,293.00 4,828.04 351,121.04 450,355.22 0.00 450,355.22 1,391,665.78 ( 11,631.28) 1,380,034.50 273,824.00 73,919.23 347,743.23 12,346,585.20 ( 373,898.48) 11,972,686.72 14,80E 96 ( 93.67) 14,708.29 145,292.49 0.00 145,292.49 1,187,616.99 ( 42,300.00) 1,145,316.99 18,342.68 0.00 18,342.68 115,486.41 0.00 115,486.41 95,965.65 3,250.00 98,715.65 152,807.38 0.00 152,807.38 ( 182,053.75) 182,053.75 0.00 128,010.81 0.00 128,010.81 4,860,690.21 58,929.38 4,919,619.59 276,546.30 ( 3,054.80) 273,491.50 4,214,029.45 10,661.82 4,224,691.27 1,031,575.08 ( 169,179.66) 862,400.42 1,113,670.35 0.00 1,113,670.35 84,912.38 ( 495.46) 89,916.92 465,765.58 0.00 465,765.58 4,997,858.14 25,012.00 5,022,870.14 1,757,769.11 43,608.04 1,801,377.15 569,575.25 15,293.37 584,868.62 0.00 29,588.44 29,588.44 61,682.40 1,408.00 63,090.40_ 43,546,627.23 ( 1,059,257.61) 42,487,369.62 -------------- ------------- ------------ -------------- -------------- ------------- ' 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 37,875,448.59 ( 145,793.33) 37,729,655.26 (22,711,010.92) ( 913,464.28) (23,624,475.20) 28,382,189.56 0.00 28,382,189.56 43,546,627.23 ( 1,059,257.61) 42,487,369.62