Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #2 07-20-2009
INFORMATION fiver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: July 20, 2009 SUBJECT: June 2009 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and the Ice Arena and Pinewood Golf special revenue funds. These funds axe the primary concern in analyzing the City's financial health. Fox the month of June, actual revenues (except fox property taxes and state aids) and expenditures should run 50% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below fox Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Kevenuer.• • Excluding transfers in, total revenue collections axe at about 32% of budget. • 70% of the first half property taxes were collected in June and the remaining 30% will be received in July. The second half payment for property taxes will be received in December. • Collection of the cable franchise tax from Sherburne-Wright Cable Commission was also received in June. • Total licenses and permits axe currently exceeding the budget benchmark as of the end of June due to the annual renewal of business licenses. Building-related permits are at about 42% of budget. • Charges for services are exceeding budget estimates due mainly to the collection of the annual fire & police contracts and recreation-related fees. • Transfers in will be reflected in the July report. Expenditures: • Excluding transfers out, the total departmental expenditures are at about 43% and most departments axe well within or below budget estimates. • The transfers out to the Ice Arena and Pinewood Golf Course are made at the end of the year based on actual results. Ice Arena For the month ended June, revenues exceed expenditures by $9,779. Excluding transfers in, revenue collections of $320,370 are at 42% of budget estimates, compared to 43% in 2008. Expenditures are at 32% of budget estimates for 2009 and were the same percent in 2008. Pinewood Golf For the month ended June, expenditures exceed revenues by $17,777. Excluding transfers in, golf revenues of $109,051 are at about 57% of budget estimates, compared to 47% in 2008. Collections for youth recreation programs and league fees have exceeded budget estimates. Expenditures of $126,828 are at about 50% of budget, compared to 55% in 2008. lD tP t`NOI~ln OlO OOD COMMHO\lf)NO~M V'ONt`~OlflM t`t71101n 61 t`O VI VIO W Lfl a\tbMO ~-i lfl VIHMOI L(1 r-IOOD O CO d\NMUI tn~O W NOOHL~01O Nl0MNMLII dI In [~Ml~ In Mln 00 ln~10 E W ZiU M0100MH61M d• W VI IOMMI~ODO01O41101~OMO~I~O~-i IO OEM 000 ~-IN W IOOC~O dI O~L~CO OI W w l~ VI H l0 l~ W T 111 r-I I~ l9 0D VI N W VI N ~O O L!1 N N H aD H M I~ OD M d' L~ H N M M N Ol H l~ N 0 01 0D a W II1[~ri 01 d1 ~O GOOMM~-IO I~r-I OD OLf10 [N 'dl lfl X010 W L~~-IO d10 M~ONMr-IMOIM OD dIO W l0 :~ p W 17. H W Mr-I Lf)rl 4110 W MHOl O1 M~010 O1MO VIHlO NMlO L~lOOL~ODHOMdIM dI I-i O10001~N UPS M1f101 VlriHt~OlOHLfllf1MM01 ML~NM VIN H W N t~HMO1~pN00~00 VI W ODMMHI~ OM M10 W Hr-I V'L(1 al Hl0 riHN HMri OdOHN V'OlW Mrl t` t`dIM HO dI .-i r-1 H N N M I-1 M M M M ML(1NHMOOMOL11OO1 Ol0NM0000L~ W a\t`N W OOt~HNOOt-IO lfl~ W OdINH~ln t` VI W OlONOLflO OlOO W O W Ul 000OOOMl~lO 111 Lfl dlOOlO VIOOONOdI l0 ~000O L~NL(1N V' H >+ 'ZIF Lfl~-IM dl Ol rvl t~l~Ol~Ol~dl dlMdl0000dl dIMO W 1000NO000l~OlO ri 1000MNN1~M01 W H OOL~Lf10011ON 61 NLl1N aDN 1f101MMU1 LAN Hlfl Ol ~~ NOM to to LSO VIM a~ HIfIODNOMLflO1 l~ NI-iHd>H H VIMMlOO V' L~tf)D\ Mt` LtIOIM I~OLnOMd' H E-I H'dl L~l~lOHOH L~ Hd> V'ML(1 010 Lfl W l0M L(1OO N ~D VI r~ OH W NHM UU lfl NM WMHI~ Nlfl M011-i H.-i tT tnOH OJM M l0 a' ~ HH NH HH P~ N N M'd1111MN1~Lf1M l0 ltl W OI M~MNIf)NO VI l0 l0 ~Lh lllOOlfl lD lO MlD lfl O l~L(1Ol0O d't`ODO W H (7 l~l~l01~100101-IOr-10010~OOD V1 111 01 0 00 00 N1O tf1Ntf10N0~01N MLfl l~tflNMOlll lllN IOOMN HU L~L~lO VINONOdI r-I V100610D0 W00100~r-INMNI-I r-IO r-iMW Lf101f10Nt~00l~~O L~[~Ota10 lO dIM HaD O1M W H W 101f10D V'I~L~Nl00tf1 L~MMODM VIN M~DMM VI I~HNHt`~a>ll1N Lf) to ll) LSO W d•tsOHI~OLf)M 01W W H~OtnO V'NOMNOI~ d'L~d'L(1 V'O t` VIN W 101 Ol lflTaO tnN d\ H 6101 UI O VI I11 CO r-1061000D 1f11-I L~OI L~Or-101MOdIN ~O l~lf10 M[~OO~IO W r-IMMI~r-IN OOH lOT 010 W al M000 VIN.-I ll1Ml0Ol(1 l~Ol VI I~.-1 Ml~NMHL~ l~ W H I~HH W 10 N 6100 M ONN H0 a O fY1 1DM MlO COH M111O Hl0 riHH H O Wr-IN V'dI CO (-I l~ lO IOM HM (\7 ~ ~ H H H N N N M I-I M M O H M awx ~ .~ ., ..„ .. ~ Ei O x H M as wow a w ' ~ 5 u~oC~~> aN,~IHC ~~ ~ w ~ ~ N s~ vworta-~ ts-~-~N rnNC H~ O ~+ +~ A N N N C W U O a N Id ,--i +-~ E ~6 a N H U q m C C N N N u1 O ~-1 -.~ tY1 C C -rl ~ N H ~ O C Q '~ a y '~ N CO N ?Iw .k cn N F U U a~ t~ 3 w~ uoC ro C ~+NNaN ~u-~+ro~~~~xxro C~~ro o a uo uC C7~INUIS-1 u1~ncnulrlNN+~CwuN CIH N~soN ~+ ~ p 4-1 U•~ rn C W r0 u1 N C 7~1 ~~bZf~ cqw ~ N N y ~+X C~ E 3 u~ U O 'LS I-1 ~~ C W .H N a 1~ td N C C C C «S rt N ~I u •n O N C ~1 N N N f." CC F W W InC O c6 O 1.1ua -.~W tg0000x~~Ur.Gm01-1~CNa C5tr13 W C ~ ~ -1 O•~10 NC C7CU UC CC vIN NWWWfYI ~~t21~ + H f~+ 16 N-.~ rtCNONb1W Na ~1O .u NWLL E3HN~ N~axAN ~ W C'LS t~'L3~.-+ O r0 8 U'~ }-1 U O OO O ~ u~ C U H '~ C > RI ~ ~ N C ~ ~+ N O •rl N r1 ~ 1-7 O C21 ~ C ~ O C W C7 C7 C7 C7 -~ u1 0.1 N H rn rl N rd -.~ N r.~ E ~ N r0 N u1 R, ora~ls~o,~Q•~+•~1 aortroaowcaA U E '-i101~UN3E HHN3~-Ib1No Z •~1 N r~ FC 3 -r-1 4-1 w O IH ~ 1-1 S-1 a FC FC FC U U r.G ~, U ~k u N rd ~ RI 'd ~ ~ N O ~ S-1 r-1 ~ N ~+ N U .~ 'L3 'C5 ~+ (~ N -~ C a~ b1 N \ m M In t` t` d' N -~ ~ •rl N I+-+ r•G ~v-~ FC ~+ .k u ~~.1 N N 1 ' N ~ 1 1 ~ U ~ G C>: W S S ' l " J -I . l dl O O O 01 d> O ~ a> M 1 -1 1 -I -I J- J L Q-I i A N C ~-I (-. C U W ~ C21 U1 y ~ U L I N U2 61 O O O dl Ol O a\ H ~ 1J ~ w •.-I CSI ~ O1 N H H (~ -ri (d Ci N 1 S l U - I (O fd (O - i H N RS C O ~ N N • - r r - r DUI-~HL1+Cq W ~ll-7 ~La ~lUHC')C1 Ul Zi r-INNNr-I riN W I-IF UC!) V]ZiU W'YI f-I W E-IH ~S I-a C7Hq O U 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 FC .C.C.C~.C.~fi~~~.C.C.t'i.si.C.ii.Li.C.C.C~~~~.Ci.C~.C~~~fi~~~.C.C~~~fi.s;~~x U1 Ul U7 U1 U1 W W U1 W W V! U1 U7 U1 W U1 W U1 !A Ul W W [A [l1 tl) W N U1 N U] OZ W UI UI W W W Ul U2 U] W W U7 U! U] N rt ~ t~ rt N r0 r0 c0 ~ ~ rt rt n5 rt r6 ~ rt 10 N 10 r~ r0 ~ rd rt{ rtl N rtl rt rd Id 10 rt rtl rt r~ N rd ~ r0 ~ ~ r0 r.C N U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U N ~ Z. o E-I x o H m O O U o0000000000000000000000000000000000000000000 O U Zi HH,~HHHH.-1Hr-1HHHHI--IH riH r-IHr-IH.-IH H.-iHHHHHH,~H.-1HHHHH,~HHH N FC O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O U I I-i H I-i .-I r-I H H f-I H r-I H H ri H H H r-I H H H H H H r-I H I-i H H H H H H .-I H r-I H .--I H H H r-I H H H 111 ~' 11 I 1 I 1 I I 1 I I I I 1 I 1 I 1 I 1 I I 1 I I I 1 I 1 I 1 I I 1 I 1 I I I I I 1 I I a H Q I ,7.~ H NHr-IHNMLfI W HOH1f10.-iN V11.f1 lO aD riNMOr-IMOMlfl riM dl lf116010 L~001NNMlf1 r-I f•i QI OOHNNNNNMdI V' VI OI 0\010101 D\O r-iHr-IMMM VI dI l~00000HNNdI Lfl 1000OONE-I L~ '~7 ~ O.-INNNNNNNNNNNNNNNNMMMMMMMMMMdI dI V'dI VI dI V' VI VI V' VI ~O ~D IO CONO W U h 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND FINANCIAL SUMMARY 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' REVENUE SUMMARY General Fund TOTAL REVENUES EXPENDITURE SUMMARY General Government Mayor & Council Cable TV Administrative Services Human Resources Finance Information Technology Legal Community Development Planning City Hall Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fire Administration Fire Inspections Emergency Management Building Safety Environmental TOTAL Public Safety Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works 12,636,100.00 3,330,288.56 4,097,439.22 32.43 8,538,660.78 12,636,100.00 3,330,288.56 4,097,439.22 32.43 8,538,660.78 168,100.00 4,215.19 67,128.87 39.93 100,971.13 81,800.00 5,216.15 31,187.22 38.13 50,612.78 471,650.00 34,420.66 211,428.69 44.83 260,221.31 147,950.00 10,498.84 66,820.07 45.16 81,129.93 447,300.00 76,694.38 290,778.69 53.83 206,521.31 278,050.00 13,639.31 92,911.74 33.42 185,138.26 234,000.00 9,902.75 78,088.75 33.37 155,911.25 126,950.00 4,939.30 62,803.33 99.47 64,146.67 321,200.00 21,793.83 137,014.44 42.66 184,185.56 286,350.00 19,161.69 125,024.31 43.66 161,325.69 70,050.00 2,598.60 2,598.60 3.71 67,451.40 2,633,400.00 203,080.70 1,115,784.71 42.37 1,517,615.29 597,700.00 44,825.67 326,499..44 54.63 271,200.56 2,182,800.00 154,443.83 896,672.51 91.08 1,286,127.99 714,150.00 49,300.00 293,572.37 41.11 420,577.63 492,050.00 35,054.21 217,224.81 44.15 274,825.19 22,750.00 1,739.09 4,105.23 18.04 18,644.77 202,700.00 15,649.17 84,979.37 41.92 117,720.63 472,200.00 23,381.89 205,675.13 43.56 266,524.87 188,850.00 19,288.49 84,627.82 44.81 104,222.18 49,150.00 837.68 11,791.29 23.99 37,358.71 588,600.00 39,174.76 301,211.60 51.17 287,388.40 75,350.00 5,301.40 32,903.18 43.67 92,946.82 5,586,300.00 378,996.19 2,459,262.75 44.02 3,127,037.25 1,300,650.00 101,669.13 488,466.80 37.56 812,183.20 308,750.00 2,055.05 148,625.90 48.14 160,124.10 250,950.00 18,684.90 105,552.10 42.14 144,897.90 191,150.00 9,412.16 40,453.22 21.16 150,696.78 2,051,000.00 126,821.24 783,098.02 38.18 1,267,901.98 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD 50.00 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 733,150.00 63,247.25 309,932.09 41.59 428,217.91 541,450.00 40,421.56 252,082.84 46.56 289,367.16 164,300.00 23,907.59 77,109.85 46.93 87,195.15 19,500.00 761.05 6,110.06 31.33 13,389.94 193,350.00 13,891.02 84,992.74 43.96 108,357.26 1,651,750.00 142,228.97 725,222.58 43.91 926,527.42 0.00 10,119.40 47,675.87 0.00 ( 47,675.87) 55,800.00 5,497.98 15,461.53 27.71 40,338.97 55,800.00 15,617.38 63,137.90 113.15 ( 7,337.40) 229,300.00 0.00 66,600.00 29.04 162,700.00 229,300.00 0.00 66,600.00 29.04 162,700.00 12,207,550.00 866,743.98 5,213,105.46 42.70 6,994,949.54 428,550.00 2,963,594.58 ( 1,115,666.24) 1,544,216.24 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND REVENUES 50.00 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3123 Franchise Tax 101-3-0000-3132 Tax Forfeited Land Sale TOTAL Taxes 9,547,550.00 150,000.00 0.00 0.00 9,697,550.00 3,185,547.70 3,144,633.16 0.00 40,914.54 o.oo 3,144,633.16 32.94 6,402,916.84 3,997.52 2.67 146,002.48 40,914.54 0.00 ( 40,914.54) 25.55 0.00 ( 25.55) 3,189,570.77 32.89 6,507,979.23 Licenses & Permits 101-3-0000-3211 Liquor License 51,000.00 5,240.00 99,030.00 96.14 1,970.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 100.00 3.33 2,900.00 101-3-0000-3214 Apartment License 15,850.00 1,440.00 13,650.00 86.12 2,200.00 101-3-0000-3216 Mining License 9,000.00 0.00 20,562.45 228.47 ( 11,562.45) 101-3-0000-3217 Garbage Hauler License 3,000.00 0.00 3,095.00 103.17 ( 95.00) 101-3-0000-3218 Other Business License/Permit 13,000.00 1,220.00 15,790.00 121.46 ( 2,790.00) 101-3-0000-3229 NPDES Permit 5,000.00 175.00 700.00 14.00 4,300.00 101-3-0000-3231 Building Permit 188,300.00 12,249.65 67,971.57 36.10 120,328.43 101-3-0000-3232 Plumbing/Heating Permit 47,600.00 3,107.85 31,529.91 66.24 16,070.09 101-3-0000-3233 Permit Surcharge 200.00 ( 740.68) 594.52 297.26 ( 394.52) 101-3-0000-3234 Electric Permit 100.00 0.00 0.00 0.00 100.00 101-3-0000-3235 Animal License 3,000.00 324.00 2,984.00 99.47 16.00 101-3-0000-3236 Parking Permit 1,500.00 0.00 1,180.00 78.67 320.00 101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 315.00 5,545.00 96.21 6,455.00 TOTAL Licenses & Permits 353,550.00 23,330.82 212,732.45 60.17 140,817.55 Intergovernmental Rev 101-3-0000-3321 Local Government Aid 101-3-0000-3324 PERA Aid 101-3-0000-3325 Police 2a 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-3341 County Reimb/Grant TOTAL Intergovernmental Rev 686,800.00 0.00 0.00 15,000.00 0.00 0.00 215,000.00 0.00 0.00 10,D00.00 0.00 0.00 36,800.00 0.00 19,987.34 12,500.00 2,079.19 4,745.59 7,500.00 0.00 0.00 983,600.00 2,079.19 24,232.93 0.00 0.00 0.00 0.00 52.95 37.96 2.46 686,800.00 15,000.00 215,000.00 10,000.00 17,312.66 7,754.41 7,500.00 959,367.07 Charges for Services 101-3-0000- 3412 Planning & Zoning Fees 25,000.00 1,040.00 8,540.00 34.16 16,460.00 101-3-0000- 3413 Plan Check Fee 75,300.00 3,325.15 22,775.16 30.25 52,524.84 101-3-0000- 3415 Special Assessment Search 500.00 60.00 320.00 64.00 180.00 101-3-0000- 3417 Copies 1,500.00 157.60 1,024.17 68.28 475.83 101-3-0000- 3418 Other General Govt Services 5,000.00 725.00 1,734.88 34.70 3,265.12 101-3-0000- 3430 Lockout Fees 8,500.00 560.00 9,124.58 48.52 4,375.92 101-3-0000- 3431 Police Services 2,000.00 200.00 1,020.75 51.04 979.25 101-3-0000- 3432 School Liaison 75,000.00 37,500.00 75,000.00 100.00 0.00 101-3-0000- 3434 Animal Impound Fee 3,000.00 550.00 2,320.00 77.33 680.00 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 i01-GENERAL FUND 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3461 Recreation Fees 101-3-0000-3467 Concessions 101-3-0000-3972 Park Use Fee 101-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee i01-3-0000-3484 Contractor License Check TOTAL Charges for Services Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinanace Violations TOTAL Fines & Forfeits al 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-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-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3999 Transfer-HRA TOTAL Transfers In 208,000.00 3,525.00 153,242.00 73.67 54,758.00 1,000.00 0.00 0.00 0.00 1,000.00 25,000.00 5,275.00 11,915.99 47.66 13,089.01 121,500.00 6,013.00 76,989.64 63.37 44,510.36 20,100.00 1,798.04 5,008.02 24.92 15,091.98 2,600.00 477.49 11,526.44 443.32 ( 8,926.44) 3,100.00 ( 17.17) 4,079.01 131.58 ( 979.01) 2,400.00 1,100.00 3,450.00 143.75 ( 1,050.00) 5,000.00 270.00 920.00 18.40 4,080.00 500.00 75.00 220.00 44.00 280.00 585,000.00 62,634.06 384,210.64 65.68 200,789.36 150,000.00 8,773.97 46,883.80 31.26 103,116.20 7,000.00 520.00 10,275.75 196.80 ( 3,275.75) 0.00 100.00 100.00 0.00 ( 100.00) 157,000.00 9,393.97 57,259.55 36.47 99,740.45 180,000.00 0.00 5,701.08 3.17 174,298.92 54,000.00 144.20 1,984.03 3.67 52,015.97 22,800.00 86.00 18,966.00 80.99 4,334.00 3,000.00 72.62 3,281.77 109.39 ( 281.77) 259,800.00 302.82 29,432.88 11.33 230,367.12 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 50,000.00 0.00 0.00 0.00 50,000.00 248,600.00 0.00 0.00 0.00 298,600.00 200,000.00 97,000.00 200,000.00 100.00 0.00 17,000.00 0.00 0.00 0.00 17,000.00 9,500.00 0.00 0.00 0.00 9,500.00 599,600.00 47,000.00 200,000.00 33.36 399,600.00 TOTAL General Fund 12,636,100.00 3,330,288.56 4,097,439.22 32.43 8,538,660.78 TOTAL REVENUE 12,636,100.00 3,330,288.56 9,097,439.22 32.43 8,538,660.78 ~ 7-15-2009 10:23 AM ~ 101-GENERAL FUND ~ DEPARTMENTAL EXPENDITURES Mayor & Council CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-4104 PERA 101-9-1110-4105 FICA 101-4-1110-4107 Medicare 101-9-1110-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1110-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-9-1110-4359 Publishing 101-4-1110-4361 Insurance 101-9-1110-4433 Dues & Subscriptions 101-9-1110-9440 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,208.00 19,248.00 49.99 19,252.00 1,950.00 102.07 612.42 31.41 1,337.58 2,400.00 198.90 1,193.40 49.73 1,206.60 550.00 46.52 279.12 50.75 270.88 50.00 9.75 29.25 58.50 20.75 43,450.00 3,565.29 21,362.19 49.16 22,087.81 3,200.00 0.00 772.22 24.13 2,427.78 3,200.00 0.00 772.22 24.13 2,427.78 6,750.00 231.00 4,043.16 59.90 2,706.89 800.00 0.00 69.95 8.74 730.05 6,500.00 230.45 442.69 6.81 6,057.31 18,200.00 127.50 6,343.78 34.86 11,856.22 64,800.00 0.00 31,312.00 48.32 33,488.00 15,000.00 0.00 500.00 3.33 14,500.00 9,400.00 61.00 2,282.88 24.29 7,117.12 121,450.00 649.95 44,994.46 37.05 76,455.54 TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4109 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare lOT-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 168,100.00 4,215.19 67,128.87 39.93 100,971.13 50,600.00 3,752.00 22,887.21 95.23 27,712.79 11,800.00 340.63 1,703.13 14.43 10,096.87 3,550.00 253.26 1,640.09 46.20 1,909.91 4,000.00 251.18 1,600.92 40.02 2,399.08 950.00 58.74 374.39 39.41 575.61 5,250.00 438.01 2,628.06 50.06 2,621.99 200.00 43.25 129.75 64.88 70.25 76,350.00 5,137.07 30,963.55 40.55 45,386.45 3,350.00 70.78 184.98 5.52 3,165.02 3,350.00 70.78 189.98 5.52 3,165.02 7-15-2009 10:23 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 PAGE: 6 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1120-9319 Other Professional Services 500.00 0.00 0.00 0.00 500.00 101-4-1120-4322 Postage 100.00 0.00 0.60 0.60 99.40 101-4-1120-4331 Travel, Conferences & Schools 1,400.00 8.30 38.09 2.72 1,361.91 101-9-1120-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 2,100.00 8.30 38.69 1.84 2,061.31 TOTAL Cable TV 81,800.00 5,216.15 31,187.22 38.13 50,612.78 Administrative Services Personal Services 101-4-1210-4101 Regular Pay 296,750.00 22,390.67 136,583.09 46.03 160,166.91 '_O1-4-1210-4102 Overtime Pay 2,000.00 0.00 0.00 0.00 2,000.00 101-4-1210-4103 Part-time Pay 45,600.00 3,328.32 20,240.52 44.39 25,359.48 101-4-1210-4104 PERA 23,250.00 1,736.03 11,236.27 48.33 12,013.73 101-4-1210-4105 FICA 21,350.00 1,552.29 10,096.08 47.29 11,253.92 101-4-1210-4106 Other Retirement Contributions 4,800.00 400.00 2,400.00 50.00 2,400.00 101-4-1210-4107 Medicare 5,000.00 363.04 2,361.21 47.22 2,638.79 101-4-1210-4108 Insurance 23,450.00 1,954.03 11,729.18 50.00 11,725.82 101-4-1210-4109 Workers Comp 1,300.00 350.50 1,051.50 80.88 248.50 TOTAL Personal Services 423,500.00 32,074.88 195,692.85 46.21 227,807.15 Supplies 101-4-1210-4201 Office Supplies 9,900.00 618.50 2,944.45 24.69 7,455.55 TOTAL Supplies 9,900.00 618.50 2,444.45 24.69 7,455.55 Other Services & Charges 101-4-1210-4319 Other Professional Services 4,500.00 0.00 4,860.00 108.00 ( 360.00) 101-4-1210-4321 Telephone 600.00 80.58 351.04 58.51 248.96 101-4-1210-9322 Postage 1,500.00 0.00 70.95 9.73 1,929.05 101-4-1210-4331 Travel, Conferences & Schools 5,600.00 87.13 937.11 16.73 4,662.89 101-4-1210-4361 Insurance 200.00 0.00 112.00 56.00 88.00 101-4-1210-4404 Equip Repair/Maint Services 22,600.00 1,457.24 6,546.31 28.97 16,053.69 101-4-1210-4433 Dues & Subscriptions 2,600.00 70.00 220.00 8.96 2,380.00 101-4-1210-9460 Equip Replacement Charge 650.00 32.33 193.98 29.84 956.02 TOTAL Other Services & Charges 38,250.00 1,727.28 13,291.39 34.75 24,958.61 TOTAL Administrative Services 471,650.00 34,420.66 211,428.69 44.83 260,221.31 Human Resources 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-9-1220-4107 Medicare 101-4-1220-4108 Insurance 101-9-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-9322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges 68,850.00 5,219.24 31,837.36 46.24 37,012.64 45,200.00 3,352.32 21,266.32 47.05 23,933..68 7,700.00 578.58 3,822.38 49.64 3,877.62 7,100.00 525.88 3,488.29 49.13 3,611.71 1,650.00 122.98 815.76 49.44 834.24 5,250.00 938.00 2,628.00 50.06 2,622.00 450.00 116.25 348.75 77.50 101.25 136,200.00 10,353.25 64,206.86 47.14 71,993.14 3,000.00 82.69 1,912.75 63.76 1,087.25 3,000.00 82.69 1,912.75 63.76 1,087.25 3,000.00 0.00 0.00 0.00 3,000.00 350.00 0.00 102.71 29.35 247.29 3,750.00 6.60 209.05 5.57 3,540.95 650.00 0.00 0.00 0.00 650.00 1,000.00 56.30 388.70 38.87 611.30 8,750.00 62.90 700.46 8.01 8,049.54 TOTAL Human Resources Finance Personal Services 101-4-1310-4101 Regular Pay 101-9-1310-4103 Part-time Pay 101-4-1310-9104 PERA 101-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-4-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-4322 Postage 101-4-1310-9331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 147,950.00 10,498.84 66,820.07 45.16 81,129.93 284,350.00 21,325.16 130,083.49 45.75 154,266.51 5,150.00 290.00 1,350.00 26.21 3,800.00 19,550.00 1,439.94 9,321.56 47.68 10,228.44 17,950.00 1,242.74 8,085.56 45.04 9,864.44 4,200.00 290.63 1,890.92 45.02 2,309.08 23,450.00 1,954.03 11,724.18 50.00 11,725.82 1,100.00 295.25 885.75 80.52 214.25 355,750.00 26,837.25 163,341.96 45.91 192,408.54 3,850.00 184.61 1,110.52 28.84 2,739.98 3,850.00 184.61 1,110.52 28.84 2,739.48 17,300.00 0.00 12,960.00 74.91 4,340.00 48,150.00 48,788.00 48,788.00 101.33 ( 638.00) 850.00 63.52 317.76 37.38 532.24 3,600.00 0.00 415.47 11.54 3,184.53 4,150.00 20.00 2,188.28 52.73 1,961.72 2,000.00 0.00 0.00 0.00 2,000.00 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1310-4904 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions 101-4-1310-4440 Miscellaneous TOTAL Other Services & Charges 10,100.00 250.00 10,349.20 102.42 ( 244.20) 1,550.00 505.00 1,175.00 75.81 375.00 0.00 96.00 138.00 0.00 ( 138.00) 87,700.00 99,672.52 76,326.71 87.03 11,373.29 TOTAL Finance 447,300.00 76,694.38 240,778.69 53.83 206,521.31 Information Technology Personal Services i01-4-1350-4101 Regular Pay 129,300.00 9,725.04 59,278.48 45.85 70,021.52 101-4-1350-4103 Part-time Pay 12,850.00 0.00 0.00 0.00 12,850.00 101-4-1350-4104 PERA 9,600.00 656.44 4,247.97 44.25 5,352.03 101-4-1350-4105 FICA 8,800.00 569.22 3,776.56 42.92 5,023.49 101-4-1350-9107 Medicare 2,050.00 133.13 883.23 43.08 1,166.77 101-4-1350-4108 Insurance 15,350.00 1,280.02 7,276.10 47.40 8,073.90 101-4-1350-4109 Workers Comp 550.00 145.00 935.00 79.09 115.00 TOTAL Personal Services 178,500.00 12,508.85 75,897.34 42.52 102,602.66 Supplies 101-4-1350-4219 Operating Supplies 23,300.00 416.88 3,901.61 16.75 19,398.39 TOTAL Supplies 23,300.00 916.88 3,901.61 16.75 19,398.39 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 101-4-1350-4321 Telephone 800.00 101-9-1350-4331 Travel, Conferences & Schools 4,500.00 101-4-1350-4909 Equip Repair/Maint Services 19,950.00 TOTAL Other Services & Charges 33,250.00 Capital Outlay 101-4-1350-4560 Equipment 43,000.00 TOTAL Capital Outlay 43,000.00 0.00 330.00 4.13 7,670.00 55.65 282.15 35.27 517.85 27.93 197.99 4.40 4,302.01 630.00 7,693.20 38.56 12,256.80 713.58 8,503.39 25.57 24,746.66 0.00 4,609.95 10.72 38,390.55 0.00 4,609.45 10.72 38,390.55 TOTAL Information Technology Legal Other Services & Charges 101-9-1400-4304 Legal Fees TOTAL Other Services & Charges 278,050.00 13,639.31 92,911.79 33.42 185,138.26 234,000.00 9,902.75 78,088.75 33.37 155,911.25 234,000.00 9,902.75 78,088.75 33.37 155,911.25 TOTAL Legal 239,000.00 9,902.75 78,088.75 33.37 155,911.25 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 50.00 OF YEAR COMP. CURRENT CURRENT YEAR.TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Community Development Personal Services 101-4-1500-4101 Regular Pay 84,550.00 3,862.83 101-4-1500-4104 PERA 5,700.00 260.74 101-4-1500-4105 FICA 5,300.00 221.60 101-4-1500-4107 Medicare 1,250.00 51.83 101-4-1500-4108 Insurance 8,700.00 399.80 101-4-1500-4109 Workers Comp 550.00 142.50 101-4-1500-4110 Re-employment Compensation 18,100.00 0.00 TOTAL Personal Services 124,150.00 4,939.30 Supplies 101-4-1500-4201 Office Supplies 250.00 0.00 TOTAL Supplies 250.00 0.00 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 0.00 TOTAL Other Services & Charges 2,550.00 0.00 49,998.16 59.13 34,551.89 2,646.66 46.93 3,053.34 3,190.05 60.19 2,109.95 746.08 59.69 503.92 5,115.38 58.80 3,584.62 427.50 77.73 122.50 0.00 0.00 18,100.00 62,123.83 50.04 62,026.17 32.71 13.08 217.29 32.71 13.08 217.29 646.79 25.36 1,903.21 646.79 25.36 1,903.21 TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4104 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101-4-1510-4319 Other Professional Services 101-4-1510-4321 Telephone 101-4-1510-4322 Postage 101-9-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-9404 Equip Repair/Maint Services 126,950.00 4,939.30 62,803.33 49.47 64,146.67 210,300.00 15,828.23 96,063.31 45.68 114,236.69 19,200.00 1,068.40 6,761.73 47.62 7,438.27 13,050.00 883.92 5,653.24 43.32 7,396.76 3,050.00 206.74 1,322.22 43.35 1,727.78 28,300.00 2,140.02 12,200.11 43.11 16,099.89 500.00 155.50 466.50 93.30 33.50 269,400.00 20,282.81 122,467.11 45.46 146,932.89 4,850.00 90.92 1,810.91 37.34 3,039.09 850.00 202.39 602.62 70.90 247.38 5,700.00 293.31 2,413.53 92.34 3,286.97 20,000.00 0.00 6,914.34 34.57 13,085.66 800.00 42.35 182.45 22.81 617.55 2,000.00 0.00 312.76 15.64 1,687.29 6,350.00 383.21 880.83 13.87 5,469.17 10,000.00 675.00 2,638.45 26.38 7,361.55 700.00 0.00 0.00 0.00 700.00 5,000.00 117.15 692.97 13.86 9,307.03 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 101-9-1510-4933 Dues & Subscriptions 101-4-1510-4940 Miscellaneous TOTAL Other Services & Charges TOTAL Planning City Hall Maintenance 50.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1,000.00 0.00 445.00 44.50 555.00 250.00 0.00 67.00 26.80 183.00 46,100.00 1,217.71 12,133.80 26.32 33,966.20 321,200.00 21,793.83 137,014.44 42.66 184,185.56 Personal Services 101-4-1600-4101 Regular Pay 83,750.00 7,137.52 49,505.77 53.19 39,244.23 101-4-1600-4102 Overtime Pay 9,100.00 0.00 0.00 0.00 9,100.00 101-4-1600-4103 Part-time Pay 18,450.00 2,043.02 8,552.83 96.36 9,897.17 101-4-1600-4104 PERA 7,800.00 565.90 3,704.70 97.50 4,095.30 101-4-1600-4105 FICA 7,150.00 570.99 3,457.48 48.36 3,692.52 101-4-1600-4107 Medicare 1,700.00 133.54 808.63 47.57 891.37 101-9-1600-4108 Insurance 11,900.00 1,137.65 7,186.73 60.39 4,713.27 101-4-1600-9109 Workers Comp 2,550.00 1,068.75 3,206.25 125.74 ( 656.25) TOTAL Persona l Services 142,900.00 12,657.32 71,422.39 50.16 70,977.61 Supplies 101-4-1600-4212 Fuels & Lubs 3,750.00 383.57 1,062.73 28.34 2,687.27 101-4-1600-4217 Uniform Allowance 1,700.00 61.20 571.46 33.62 1,128.54 101-4-1600-4219 Operating Supplies 30,000.00 1,629.93 13,230.76 44.10 16,769.24 TOTAL Supplies 35,450.00 2,074.70 14,864.95 41.93 20,585.05 Other Services & Charges 101-9-1600-4321 Telephone 15,950.00 1,012.72 5,595.38 36.22 9,854.62 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 1,240.00 62.00 760.00 101-4-1600-9361 Insurance 5,700.00 0.00 2,320.00 90.70 3,380.00 101-4-1600-9389 Utilities 51,800.00 1,505.51 19,384.85 37.42 32,415.15 101-4-1600-4401 Bldg Repair/Maint Services 32,300.00 1,911.44 10,196.08 31.41 22,153.92 101-4-1600-9404 Equip Repair/Maint Services 1,250.00 0.00 50.66 4.05 1,199.34 TOTAL Other S ervices & Charges 108,500.00 4,429.67 38,736.97 35.70 69,763.03 TOTAL City Hall Maintenance 286,350.00 19,161.69 125,029.31 43.66 161,325.69 Contingency Other Services & Charges 101-4-1900-4490 Miscellaneous 70,050.00 2,598.60 2,598.60 3.71 67,451.90 TOTAL Other Services & Charges 70,050.00 2,598.60 2,598.60 3.71 67,451.40 TOTAL Contingency 70,050.00 2,598.60 2,598.60 3.71 67,451.40 TOTAL General Government 2,633,400.00 203,080.70 1,115,789.71 42.37 1,517,615.29 7-15-2009 10:23 AM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PERA 101-4-2110-4105 FICA 101-4-2110-4107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 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 101-4-2110-4560 Equipment TOTAL Capital Outlay TOTAL Police Administration Patrol Personal Services 101-4-2120-9101 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 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 279,400.00 21,182.44 129,212.89 46.25 150,187.11 39,400.00 2,986.74 19,375.37 49.18 20,024.63 0.00 0.00 1,116.38 0.00 ( 1,116.38) 2,550.00 201.70 1,575.29 61.78 974.71 23,250.00 1,938.01 11,628.06 50.01 11,621.94 48,500.00 12,970.25 38,910.75 80.23 9,589.25 393,100.00 39,279.14 201,818.74 51.34 191,281.26 16,000.00 1,381.80 4,505.72 28.16 11,494.28 2,500.00 158.36 1,502.17 60.09 997.83 3,150.00 54.76 324.06 10.29 2,825.94 21,650.00 1,594.92 6,331.95 29.25 15,318.05 5,500.00 31.83 672.19 12.22 4,827.81 25,000.00 2,428.50 9,935.31 39.74 15,064.69 2,100.00 14.30 432.03 20.57 1,667.97 4,200.00 0.00 723.69 17.23 3,476.31 500.00 0.00 112.20 22.49 387.80 12,450.00 0.00 4,576.50 36.76 7,873.50 69,250.00 1,476.98 41,096.33 59.27 28,203.67 5,850.00 0.00 3,098.00 52.96 2,752.00 500.00 0.00 153.50 30.70 346.50 125,350.00 3,951.61 60,749.75 48.46 64,600.25 57,600.00 0.00 57,599.00 100.00 1.00 57,600.00 0.00 57,599.00 100.00 1.00 597,700.00 94,825.67 326,499.44 54.63 271,200.56 1,935,250.00 100,302.47 619,088.87 42.79 821,161.13 90,000.00 5,836.38 21,613.73 24.02 68,386.27 215,050.00 14,965.54 95,037.37 44.19 120,012.63 19,800.00 1,240.94 8,013.52 40.47 11,786.48 150,400.00 12,978.07. 77,868.42 51.77 72,531.58 1,910,500.00 135,323.40 816,621.91 42.74 1,093,878.09 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND i Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 50.00% OF YEAR COMP. °s OF BUDGET BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-4404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges 95,000.00 10,396.79 35,276.19 37.13 59,723.81 17,200.00 0.00 737.59 4.29 16,462.46 49,000.00 3,076.69 13,059.47 26.65 35,940.53 25,000.00 2,927.20 8,505.93 34.02 16,494.07 186,200.00 16,350.68 57,579.13 30.92 128,620.87 14,650.00 225.00 2,599.89 17.75 12,050.11 27,200.00 315.34 6,265.12 23.03 20,934.88 550.00 0.00 230.00 41.82 320.00 43,700.00 2,229.41 13,376.46 30.61 30,323.54 86,100.00 2,769.75 22,471.97 26.10 63,628.53 TOTAL Patrol Investigations Personal Services 101-4-2130-9101 Reqular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4-2130-4331 Travel, Conferences & Schools i01-4-2130-9433 Dues & Subscriptions TO1-9-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges 2,182,800.00 154,943.83 896,672.51 41.08 1,286,127.49 995,800.00 35,793.61 215,389.59 43.94 280,410.41 40,000.00 1,712.15 6,408.91 16.02 33,591.09 75,550.00 5,288.33 33,099.11 43.80 42,455.89 5,600.00 332.11 2,097.58 37.46 3,502.42 58,600.00 4,914.94 29,489.64 50.32 29,110.36 675,550.00 48,041.14 286,479.83 42.91 389,070.17 4,850.00 0.00 214.84 4.43 4,635.16 8,400.00 432.78 1,193.03 14.20 7,206.97 13,250.00 432.78 1,407.87 10.63 11,842.13 10,750.00 269.37 1,229.41 11.44 9,520.59 4,000.00 90.00 1,275.00 31.88 2,725.00 200.00 0.00 50.00 25.00 150.00 10,900.00 521.71 3,130.26 30.10 7,269.79 25,350.00 826.08 5,684.67 22.42 19,665.33 TOTAL Investigations Police Support Services 714,150.00 49,300.00 293,572.37 41.11 420,577.63 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 50.00$ OF YEAR COMP. $ OF BUDGET BUDGET BALANCE Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-9109 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-9217 Uniform Allowance 101-4-2150-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 346,900.00 26,083.20 159,240.67 45.90 187,659.33 6,500.00 61.09 61.09 0.94 6,438.91 23,850.00 1,764.74 11,411.88 47.85 12,438.12 21,900.00 1,578.76 10,258.64 46.84 11,641.36 5,100.00 369.21 2,399.13 47.04 2,700.87 42,050.00 3,509.02 21,024.12 50.00 21,025.88 446,300.00 33,361.02 204,395.53 45.80 241,904.47 1,000.00 0.00 284.29 28.43 715.71 3,250.00 798.11 851.67 26.21 2,398.33 8,050.00 ( 386.39) 2,081.94 25.86 5,968.06 12,300.00 411.72 3,217.90 26.16 9,082.10 3,550.00 0.00 10.00 0.28 3,540.00 5,500.00 0.00 3,675.00 66.82 1,825.00 16,000.00 884.67 3,323.08 20.77 12,676.92 500.00 0.00 222.50 44.50 277.50 7,900.00 396.80 2,380.80 30.14 5,519.20 33,450.00 1,281.47 9,611.38 28.73 23,838.62 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 101-4-2160-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2160-4319 Other Professional Services 101-4-2160-4321 Telephone 101-4-2160-4331 Travel, Conferences & Schools 101-4-2160-4359 Publishing 101-4-2160-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Police Reserves 492,050.00 35,054.21 217,224.81 49.15 274,825.19 5,500.00 0.00 0.00 0.00 5,500.00 350.00 0.00 0.00 0.00 350.00 100.00 0.00 0.00 0.00 100.00 0.00 0.00 29.07 0.00 ( 29.07) 5,950.00 0.00 29.07 0.99 5,920.93 5,000.00 453.52 732.52 14.65 4,267.48 6,000.00 260.00 1,131.88 18.86 4,868.12 11,000.00 713.52 1,864.40 16.95 9,135.60 1,500.00 891.90 841.90 56.13 658.10 1,600.00 183.67 776.66 48.54 823.34 1,700.00 0.00 0.00 0.00 1,700.00 0.00 0.00 112.20 0.00 ( 112.20) 1,000.00 0.00 481.00 48.10 519.00 5,800.00 1,025.57 2,211.76 38.13 3,588.24 22,750.00 1,739.09 9,105.23 18.04 18,644.77 7-15-2009 10:23 AM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Public safety building Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4104 PERA 101-9-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 SO.OOs OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 98,200.00 7,223.87 42,408.58 43.19 55,791.42 450.00 0.00 0.00 0.00 450.00 6,650.00 487.61 3,017.53 45.38 3,632.47 6,100.00 441.55 2,715.77 44.52 3,384.23 1,450.00 103.28 635.21 43.81 814.79 14,250.00 1,043.98 5,995.29 92.07 8,254.71 2,200.00 947.75 2,843.25 129.24 ( 643.25) 129,300.00 10,248.04 57,615.63 44.56 71,684.37 17,000.00 932.61 10,979.57 64.59 6,020.43 17,000.00 932.61 10,979.57 64.59 6,020.43 Other Services & Charges 101-4-2190-4361 Insurance 6,900.00 0.00 3,006.50 43.57 3,893.50 101-4-2190-4389 Utilities 18,200.00 1,088.75 6,529.90 35.88 11,670.10 101-4-2190-4401 Bldg Repair/Maint Services 31,300.00 3,379.77 6,847.77 21.88 24,452.23 TOTAL Other Services & Charges 56,400.00 4,468.52 16,384.17 29.05 40,015.83 TOTAL Public safety building Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-9-2310-4103 Part-time Pay 101-4-2310-4109 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions 101-4-2310-4107 Medicare i01-4-2310-4108 Insurance 1G1-4-2310-4109 Workers Comp 101-4-2310-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies TOTAL Supplies CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 202,700.00 15,649.17 84,979.37 91.92 117,720.63 90,850.00 1,649.89 57,353.89 63.13 33,496.11 150,350.00 13,036.00 69,495.76 46.22 80,854.24 13,250.00 222.74 5,202.56 39.26 8,047.44 10,050.00 784.96 9,705.87 46.82 5,349.13 30,000.00 0.00 0.00 0.00 30,000.00 3,500.00 183.55 1,792.76 51.22 1,707.24 9,150.00 415.03 4,201.10 45.91 4,948.90 15,350.00 3,929.00 11,787.00 76.79 3,563.00 0.00 0.00 632.04 0.00 ( 632.04) 322,500.00 20,221.17 155,170.98 48.12 167,329.02 1,200.00 15.93 378.91 31.58 821.09 7,950.00 977.32 2,138.23 26.90 5,811.77 1,100.00 871.46 871.46 79.22 228.54 32,400.00 2,216.96 12,953.98 39.98 19,446.02 42,650.00 4,081.67 16,342.58 38.32 26,307.42 7-15-2009 10:23 AM 101-GENERAL FUND Public Safety ^ DEPARTMENTAL EXPENDITURES SO.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-9331 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-9404 Equip Repair/Maint Services 101-4-2310-9433 Dues & Subscriptions 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges 4,950.00 0.00 2,400.00 48.48 2,550.00 2,700.00 271.19 1,320.19 48.89 1,379.86 500.00 0.00 119.57 22.91 385.43 19,850.00 ( 3,641.43) 297.45 1.50 19,552.55 500.00 0.00 301.00 60.20 199.00 21,300.00 0.00 8,728.00 40.98 12,572.00 15,150.00 508.61 8,741.96 57.70 6,408.59 4,000.00 1,036.96 1,356.46. 33.91 2,643.59 20,850.00 139.52 9,870.79 23.36 15,979.21 2,000.00 0.00 1,446.50 72.33 553.50 15,250.00 764.20 4,585.20 30.07 10,664.80 107,050.00 ( 920.95) 34,161.57 31.91 72,888.43 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-4103 Part-time 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 472,200.00 23,381.89 205,675.13 43.56 266,524.87 132,250.00 9,862.80 63,756.29 48.21 68,493.71 z,ooa.oo o.oo o.oo o.o0 2,000.00 0.00 1,236.40 1,376.90 0.00 ( 1,376.90) 14,700.00 1,092.78 7,163.02 48.73 7,536.98 7,600.00 350.47 1,814.17 23.87 5,785.83 1,900.00 159.21 977.75 51.46 922.25 13,700.00 1,078.00 6,724.00 49.08 6,976.00 172,150.00 13,779.66 81,812.13 47.52 90,337.87 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 352.37 1,149.98 38.33 1,850.02 800.00 0.00 111.78 13.97 688.22 4,150.00 76.38 759.68 18.31 3,390.32 9,900.00 428.75 2,021.44 20.42 7,878.56 Other Services & Charges 101-4-2320-4321 Telephone 1,350.00 80.08 580.90 43.03 769.10 101-4-2320-4322 Postage 150.00 0.00 0.00 0.00 150.00 101-4-2320-4331 Travel, Conferences & Schools 2,750.00 0.00 0.00 0.00 2,750.00 101-4-2320-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-2320-4904 Equip Repair/Maint Services 1,850.00 0.00 143.35 7.75 1,706.65 101-4-2320-4433 Dues & Subscriptions 500.00 0.00 70.00 14.00 430.00 TOTAL Other Services & Charges 6,800.00 80.08 794.25 11.68 6,005.75 CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 TOTAL Fire Inspections 188,850.00 19,288.49 84,627.82 44.81 104,222.18 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Emergency Management Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-4104 PERA 101-4-2330-4107 Medicare 101-9-2330-9108 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-9322 Postage 101-4-2330-4331 Travel, Conferences & Schools 101-9-2330-4359 Publishing 101-9-2330-4389 Utilities 101-4-2330-9404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay CURRENT CURRENT BUDGET PERIOD 50.00°s OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 9,950.00 0.00 5,985.81 60.16 3,964.19 1,400.00 0.00 972.45 33.75 927.55 150.00 0.00 86.58 57.72 63.42 800.00 0.00 256.09 32.01 543.96 12,300.00 0.00 6,800.88 55.29 5,499.12 2,500.00 0.00 0.00 0.00 2,500.00 8,500.00 0.00 399.57 4.70 8,100.43 11,000.00 0.00 399.57 3.63 10,600.43 1,500.00 154.99 100.00 0.00 1,850.00 0.00 500.00 0.00 1,500.00 108.83 5,100.00 573.86 400.00 0.00 10,950.00 837.68 14,900.00 0.00 14,900.00 0.00 678.50 45.23 821.50 0.00 0.00 100.00 255.60 13.82 1,594.40 0.00 0.00 500.00 565.77 37.72 939.23 2,890.97 56.69 2,209.03 200.00 50.00 200.00 4,590.84 41.93 6,359.16 0.00 0.00 14,900.00 0.00 0.00 14,900.00 TOTAL Emergency Management Building Safety Personal Services 101-4-2910-4101 Regular Pay 101-9-2410-9102 Overtime Pay 101-9-2410-4103 Part-time Pay 101-4-2410-4104 PERA 101-9-2410-4105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp 101-4-2410-4110 Re-employment Compensation TOTAL Personal Services 49,150.00 837.68 11,791.29 23.99 37,358.71 375,300.00 24,222.56 209,034.77 55.70 166,265.23 500.00 0.00 0.00 0.00 500.00 23,450.00 1,911.80 11,518.20 49.12 11,931.80 26,950.00 1,769.06 12,769.54 47.38 14,180.46 24,750.00 1,475.82 13,571.22 54.83 11,178.78 5,800.00 345.14 3,173.85 54.72 2,626.15 41,600.00 3,034.01 23,930.03 57.52 17,669.97 1,900.00 329.25 987.75 70.55 412.25 29,350.00 0.00 0.00 0.00 29,350.00 529,100.00 33,082.64 274,985.36 51.97 254,114.64 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2410-4201 Office Supplies 101-9-2410-4212 Fuels & Lubs 101-9-2410-4217 Uniform Allowance 101-9-2410-4219 Operating Supplies TOTAL 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-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Building Safety Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2490-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs 101-4-2440-4217 Uniform Allowance TOTAL Supplies Other Services & Charges 101-4-2440-9321 Telephone 101-4-2940-4322 Postage 101-4-2940-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2940-4404 Equip Repair/Maint Services 101-4-2440-4909 Contractual Services 101-4-2440-4433 Dues & Subscriptions 101-4-2440-4960 Equip Replacement Charge TOTAL Other Services & Charges 3,000.00 26.38 518.12 17.27 2,481.88 5,950.00 425.18 1,398.90 23.51 4,551.10 700.00 0.00 0.00 0.00 700.00 2,650.00 11.51 1,060.15 40.01 1,589.85 12,300.00 463.07 2,977.17 24.20 9,322.83 6,900.00 224.01 1,500.00 0.00 9,400.00 41.64 16,500.00 0.00 9,400.00 236.92 1,200.00 0.00 2,300.00 126.48 47,200.00 629.05 1,364.46 19.77 5,535.54 67.74 4.52 1,432.26 2,296.72 29.43 7,103.28 14,513.50 87.96 1,986.50 3,872.77 41.20 5,527.23 375.00 31.25 825.00 758.88 32.99 1,541.12 23,249.07 49.26 23,950.93 588,600.00 34,174.76 301,211.60 51.17 287,388.90 52,200.00 3,939.52 24,379.32 46.70 27,820.68 3,500.00 265.58 1,762.90 50.37 1,737.10 3,200.00 176.96 1,219.39 38.11 1,980.61 750.00 41.40 285.22 38.03 964.78 8,450.00 669.60 4,068.80 98.15 4,381.20 350.00 98.00 299.00 84.00 56.00 68,950.00 5,186.06 32,009.63 96.76 36,490.37 650.00 6.28 101.67 15.64 548.33 200.00 16.60 21.15 10.58 178.85 200.00 0.00 0.00 0.00 200.00 1,050.00 22.88 122.82 11.70 927.18 700.00 55.72 259.00 37.00 441.00 500.00 0.00 85.22 17.09 419.78 500.00 0.00 94.07 18.81 405.93 500.00 0.00 0.00 0.00 500.00 300.00 0.00 112.00 37.33 188.00 50.00 0.00 0.00 0.00 50.00 1,500.00 0.00 0.00 0.00 1,500.00 1,oso.oo o.oo o.oo o.o0 1,oso.oo 750.00 36.74 220.44 29.39 529.56 5,850.00 92.96 770.73 13.17 5,079.27 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES SO.OOa OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ TOTAL Environmental 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-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-9-3120-4219 Operating Supplies 101-9-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Insurance ' 101-4-3120-4389 Utilities 101-4-3120-9401 Bldg Repair/Maint Services 101-4-3120-4404 Equip Repair/Maint Services 101-4-3120-4409 Contractual Services 101-4-3120-4415 Equipment Rental 101-4-3120-4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-3120-4437 Taxes & Licenses 101-4-3120-4960 Equip Replacement Charge TOTAL Other Services & Charges 75,350.00 5,301.40 32,903.18 43.67 42,446.82 5,586,300.00 378,996.19 2,459,262.75 49.02 3,127,037.25 391,850.00 40,096.89 204,736.91 52.25 187,113.09 10,400.00 0.00 0.00 0.00 10,900.00 78,950.00 8,177.14 27,672.21 35.05 51,277.79 31,050.00 2,937.19 15,777.01 50.81 15,272.99 28,750.00 2,772.42 13,947.83 48.51 14,802.17 6,700.00 648.36 3,261.83 48.68 3,438.17 50,400.00 5,961.89 28,993.19 57.53 21,406.81 20,000.00 4,922.75 14,768.25 73.84 5,231.75 618,100.00 65,516.64 309,157.23 50.02 308,942.77 9,800.00 137.45 509.41 10.61 4,290.59 82,950.00 13,438.65 26,057.22 31.41 56,892.78 160,000.00 6,312.19 47,801.85 29.88 112,198.15 17,500.00 6,077.51 19,610.85 112.06 ( 2,110.85) 265,250.00 25,965.80 93,979.33 35.43 171,270.67 950.00 0.00 152.00 16.00 798.00 9,450.00 439.69 2,209.80 23.38 7,240.20 200.00 0.00 18.29 9.15 181.71 3,000.00 24.38 1,778.87 59.30 1,221.13 500.00 0.00 0.00 0.00 500.00 18,250.00 0.00 7,963.50 43.64 10,286.50 33,000.00 2,827.29 17,945.93 54.38 15,059.07 6,500.00 0.00 673.69 10.36 5,826.31 0.00 0.00 1,658.27 0.00 ( 1,658.27) 199,000.00 0.00 9,000.38 4.52 189,999.62 3,500.00 95.85 479.25 13.69 3,020.75 4,850.00 281.75 1,440.13 29.69 3,409.87 700.00 0.00 241.25 34.46 458.75 500.00 0.00 0.00 0.00 500.00 130,200.00 6,517.73 39,106.38 30.04 91,093.62 410,600.00 10,186.69 82,667.74 20.13 327,932.26 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ' 101-GENERAL FUND Public Works ~ DEPARTMENTAL EXPENDITURES Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay 50.OOe OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 6,700.00 0.00 2,662.50 39.74 4,037.50 6,700.00 0.00 2,662.50 39.79 9,037.50 TOTAL Street Maintenance Snow Removal Personal Services 101-9-3130-9101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-9-3130-4107 Medicare 101-9-3130-4108 Insurance 101-4-3130-9109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 1,300,650.00 101,669.13 488,466.80 37.56 812,183.20 159,150.00 0.00 51,121.00 32.12 108,029.00 12,450.00 0.00 401.74 3.23 12,048.26 11,800.00 0.00 4,843.68 41.05 6,956.32 10,950.00 0.00 9,203.11 38.38 6,746.89 2,550.00 0.00 982.97 38.55 1,567.03 21,300.00 0.00 8,908.07 41.82 12,391.93 6,550.00 1,723.50 5,170.50 78.94 1,379.50 224,750.00 1,723.50 75,631.07 33.65 199,118.93 79,000.00 331.55 72,994.83 92.40 6,005.17 79,000.00 331.55 72,994.83 92.90 6,005.17 5,000.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 0.00 0.00 5,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 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services 308,750.00 2,055.05 148,625.90 48.14 160,124.10 165,200.00 12,520.00 73,562.69 44.53 91,637.31 2,500.00 0.00 0.00 0.00 2,500.00 11,300.00 845.10 5,193.94 45.96 6,106.06 10,900.00 679.90 4,245.24 40.82 6,159.76 2,450.00 159.02 992.87 40.53 1,457.13 23,000.00 1,920.03 10,521.76 45.75 12,978.24 5,250.00 1,422.00 4,266.00 81.26 984.00 220,100.00 17,546.05 98,782.50 44.88 121,317.50 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Public Works 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-9-3150-4219 Operating Supplies 16,350.00 855.11 5,093.44 31.15 11,256.56 101-4-3150-4221 Equipment Parts 9,200.00 0.00 431.42 4.69 8,768.58 TOTAL Supplies 25,550.00 855.11 5,524.86 21.62 20,025.14 Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 2,000.00 0.00 0.00 0.00 2,000.00 101-4-3150-4417 Uniform Rental 2,800.00 283.74 1,244.79 44.46 1,555.26 TOTAL Other Services & Charges 4,800.00 283.74 1,244.74 25.93 3,555.26 TOTAL Equipment Services 250,450.00 18,684.90 105,552.10 42.14 144,897.90 Engineering Personal Services i01-4-3300-4101 Regular Pay 99,500.00 0.00 0.00 0.00 49,500.00 101-9-3300-4104 PERA 3,350.00 0.00 0.00 0.00 3,350.00 101-4-3300-4105 FICA 3,050.00 0.00 0.00 0.00 3,050.00 101-4-3300-4107 Medicare 700.00 0.00 0.00 0.00 700.00 i01-4-3300-4108 Insurance 7,700.00 0.00 0.00 0.00 7,700.00 101-4-3300-4109 Workers Comp 100.00 42.25 126.75 126.75 ( 26.75) TOTAL Person al Services 64,900.00 42.25 126.75 0.20 64,273.25 Supplies 101-4-3300-4201 Office Supplies 850.00 6.28 124.96 19.64 725.54 101-4-3300-4212 Fuels & Lubs 350.00 0.00 76.08 21.74 273.92 101-4-3300-9219 Operating Supplies 9,850.00 0.00 1,750.00 17.77 8,100.00 TOTAL Suppli es 11,050.00 6.28 1,950.54 17.65 9,099.46 ^vther Services & Charges 101-4-3300-4303 Engineering Fees 88,000.00 4,322.65 31,332.17 35.60 56,667.83 101-9-3300-4319 Other Professional Services 20,000.00 0.00 6,230.00 31.15 13,770.00 101-4-3300-4321 Telephone 750.00 4.24 7.88 1.05 742.12 101-4-3300-4322 Postage 200.00 0.00 8.24 4.12 191.76 101-4-3300-4331 Travel, Conferences & Schools 5,200.00 0.00 60.00 1.15 5,140.00 101-4-3300-4361 Insurance 300.00 0.00 112.00 37.33 188.00 101-9-3300-4404 Equip Repair/Maint Services 500.00 0.00 405.20 81.04 94.80 i01-4-3300-4460 Equip Replacement Charge 750.00 36.74 220.44 29.39 529.56 TOTAL Other Services & Charges 115,700.00 4,363.63 38,375.93 33.17 77,324.07 TOTAL Engineering 191,150.00 4,412.16 40,953.22 21.16 150,696.78 TOTAL Public Works 2,051,000.00 126,821.24 783,098.02 38.18 1,267,901.98 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES Parks Department CURRENT CURRENT BUDGET PERIOD 50.00$ OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-5110-4101 Regular Pay 338,150.00 28,016.01 156,617.45 96.32 181,532.55 101-4-5110-4102 Overtime Pay 1,000.00 0.00 0.00 0.00 1,000.00 101-4-5110-4103 Part-time Pay 93,350.00 7,402.05 14,337,94 33.07 29,012.06 101-4-5110-4104 PERA 23,850.00 1,989.83 11,453.77 48.02 12,396.23 101-4-5110-4105 FICA 24,150.00 2,031.73 10,201.88 42.24 13,948.12 101-4-5110-4107 Medicare 5,650.00 475.15 2,385.90 42.23 3,269.10 101-4-5110-4108 Insurance 51,200.00 3,848.22 20,985.49 40.99 30,214.51 101-4-5110-4109 Workers Comp 6,500.00 1,926.00 5,778.00 88.89 722.00 101-4-5110-4110 Re-employment Compensation 0.00 0.00 599.56 0.00 ( 599.56) TOTAL Personal Services 493,850.00 45,688.99 222,359.99 45.03 271,490.01 Supplies 101-4-5110-4212 Fuels & Lubs 31,350.00 2,930.14 7,245.36 23.11 24,104.64 101-4-5110-4217 Uniform Allowance 3,200.00 76.45 1,506.36 97.07 1,693.64 101-4-5110-4219 Operating Supplies 68,550.00 8,549.39 34,245.35 49.96 34,304.65 TOTAL Supplies 103,100.00 11,555.98 42,997.07 41.70 60,102.93 Other Services & Charges 101-4-5110-4321 Telephone 3,900.00 381.76 1,902.23 48.78 1,997.77 101-4-5110-4331 Travel, Conferences & Schools 2,550.00 0.00 1,948.00 76.39 602.00 101-4-5110-4361 Insurance 27,000.00 0.00 11,810.00 43.74 15,190.00 101-4-5110-4389 Utilities 15,050.00 1,625.34 5,530.30 36.75 9,519.70 101-4-5110-4401 Bldg Repair/Maint Services 5,500.00 0.00 108.75 1.98 5,391.25 101-9-5110-4409 Equip Repair/Maint Services 13,500.00 0.00 1,737.44 12.87 11,762.56 101-9-5110-4409 Contractual Services 6,100.00 176.15 495.55 8.12 5,604.45 101-9-5110-4915 Equipment Rental 24,500.00 1,981.17 5,015.60 20.47 19,484.40 101-4-5110-4460 Equip Replacement Charge 38,100.00 1,837.86 11,027.16 28.94 27,072.89 TOTAL Other Services & Charges 136,200.00 6,002.28 39,575.03 29.06 96,624.97 TOTAL Parks Department 733,150.00 63,247.25 304,932.09 41.59 928,217.91 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-4102 Overtime Pay 101-4-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-4105 FICA 101-4-5210-9107 Medicare 101-4-5210-4108 Insurance 101-4-5210-9109 Workers Comp TOTAL Personal Services 335,550.00 24,778.78 151,153.23 700.00 0.00 0.00 21,150.00 2,804.02 13,304.68 24,150.00 1,842.26 11,732.07 22,200.00 1,629.91 10,250.36 5,200.00 381.17 2,397.17 39,850.00 2,799.96 18,500.35 4,950.00 792.75 2,378.25 453,750.00 35,028.85 209,716.11 45.05 184,396.77 0.00 700.00 62.91 7,845.32 48.58 12,417.93 46.17 11, 949.69 46.10 2,802.83 46.42 21,349.65 48.05 2,571.75 46.22 294,033.89 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD SO.OOo OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5210-4321 Telephone 101-4-5210-4322 Postage i01-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 TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4101 Regular Pay 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-9105 FICA 101-4-5220-9107 Medicare 101-4-5220-4108 Insurance TOTAL Personal Services Supplies 101-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5220-4404 Equip Repair/Maint Services 101-4-5220-4409 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 12,900.00 1,691.20 7,370.39 57.13 5,529.61 12,900.00 1,691.20 7,370.39 57.13 5,529.61 4,100.00 260.70 1,711.13 41.73 2,388.87 6,000.00 220.88 1,987.61 33.13 4,012.39 5,650.00 256.04 1,650.24 29.21 3,999.76 26,400.00 725.67 11,500.40 43.56 19,899.60 1,500.00 0.00 714.00 97.60 786.00 7,800.00 505.94 6,794.31 87.11 1,005.69 14,950.00 1,112.32 6,067.63 40.59 8,882.37 6,750.00 619.96 3,261.02 48.31 3,488.98 1,650.00 0.00 1,310.00 79.39 340.00 74,800.00 3,701.51 34,996.34 46.79 39,803.66 541,450.00 40,421.56 252,082.84 46.56 289,367.16 0.00 0.00 1,195.07 0.00 ( 1,195.07) 80,000.00 10,179.75 39,155.41 48.94 40,844.59 1,600.00 211.59 1,145.62 71.60 454.38 4,500.00 631.15 2,636.25 58.58 1,863.75 1,300.00 147.63 616.61 47.93 683.39 0.00 0.00 290.00 0.00 ( 290.00) 87,400.00 11,170.12 45,038.96 51.53 42,361.04 24,000.00 1,859.11 9,945.85 41.44 14,054.15 29,000.00 1,859.11 9,945.85 41.44 14,054.15 900.00 239.63 239.63 59.91 160.37 47,000.00 10,227.74 17,887.63 38.06 29,112.37 2,500.00 0.00 1,427.00 57.08 1,073.00 3,000.00 410.99 2,565.78 85.53 434.22 52,900.00 10,878.36 22,120.04 41.81 30,779.96 TOTAL Recreation Programs 164,300.00 23,907.59 77,104.85 96.93 87,195.15 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 I 101-GENERAL FUND Culture & Recreation I DEPARTMENTAL EXPENDITURES 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Concessions Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 101-4-5230-4104 PERA 250.00 101-4-5230-4105 FICA 300.00 101-4-5230-4107 Medicare 100.00 TOTAL Personal Services 5,400.00 Supplies 101-4-5230-4219 Operating Supplies 600.00 101-4-5230-4259 Other Merchandise For Resale 13,400.00 TOTAL Supplies 14,000.00 Other Services & Charges 595.63 1,815.17 38.21 2,934.83 6.03 31.82 12.73 218.18 36.92 112.53 37.51 187.47 8.63 26.32 26.32 73.68 647.21 1,985.84 36.77 3,414.16 0.00 35.04 5.84 564.96 113.84 4,089.18 30.52 9,310.82 113.84 4,124.22 29.96 9,875.78 I 101-9-5230-4401 Bldg Repair/Maint Services 100.00 0.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs Personal Services 101-9-5510-4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4104 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 Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-4-5510-4331 Travel, Conferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4901 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 19,500.00 761.05 6,110.06 31.33 13,389.94 54,950.00 4,083.20 24,907.53 45.33 30,042.47 500.00 0.00 0.00 0.00 500.00 58,700.00 4,448.60 27,005.30 46.01 31,694.70 7,700.00 575.90 3,718.81 48.30 3,981.19 7,100.00 490.46 3,194.20 44.99 3,905.80 1,650.00 114.71 747.09 45.28 902.91 12,400.00 1,039.22 6,205.32 50.04 6,194.68 700.00 93.00 279.00 39.86 421.00 143,700.00 10,840.09 66,057.25 45.97 77,642.75 10,950.00 1,464.28 5,215.26 47.63 5,734.74 10,950.00 1,464.28 5,215.26 47.63 5,734.74 2,900.00 205.96 1,234.60 51.44 1,165.40 4,000.00 8.62 1,142.33 28.56 2,857.67 2,400.00 132.00 597.29 24.89 1,802.71 900.00 0.00 775.50 86.17 124.50 8,150.00 370.93 9,571.47 56.09 3,578.53 11,800.00 646.64 5,466.28 46.32 6,333.72 8,100.00 46.00 ( 306.71) 3.79- 8,406.71 950.00 177.00 239.47 25.21 710.53 38,700.00 1,586.65 13,720.23 35.45 24,979.77 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Sr Citizen Programs 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 i01-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-9322 Postage 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 193,350.00 13,891.02 84,992.74 43.96 108,357.26 1,651,750.00 142,228.47 725,222.58 93.91 926,527.42 0.00 6,995.20 35,305.62 0.00 ( 35,305.62) 0.00 1,050.32 3,150.96 0.00 ( 3,150.96) 0.00 494.70 2,950.71 0.00 ( 2,450.71) 0.00 452.78 2,219.67 0.00 ( 2,219.67) 0.00 105.90 519.15 0.00 ( 519.15) 0.00 876.00 3,050.00 0.00 ( 3,050.00) 0.00 149.50 144.50 0.00 ( 149.50) 0.00 10,119.40 46,890.61 0.00 ( 96,840.61) 0.00 0.00 110.75 0.00 ( 110.75) 0.00 0.00 729.51 0.00 ( 724.51) 0.00 0.00 835.26 0.00 ( 835.26) TOTAL Economic Development Energy City 0.00 10,119.40 47,675.87 0.00 ( 97,675.87) Personal Services 101-4-6220-4101 Regular Pay 27,250.00 2,053.58 12,801.26 96.98 19,448.74 101-4-6220-4104 PERA 1,550.00 138.62 912.41 58.87 637.59 101-4-6220-4105 FICA 1,500.00 95.86 652.83 43.52 847.17 101-4-6220-4107 Medicare 400.00 22.42 152.67 38.17 247.33 101-4-6220-4108 Insurance 3,600.00 300.01 1,774.45 49.29 1,825.55 TOTAL Personal Services 34,300.00 2,610.49 16,293.62 47.50 18,006.38 Other Services & Charges 101-4-6220-4319 Other Professional Services 2,000.00 0.00 0.00 0.00 2,000.00 101-4-6220-4331 Travel, Conferences & Schools 17,000.00 2,464.79 ( 3,236.63) 19.04- 20,236.63 101-4-6220-4359 Publishing 2,500.00 422.70 2,404.54 96.18 95.96 TOTAL Other Services & Charges 21,500.00 2,887.49 ( 832.09) 3.87- 22,332.09 TOTAL Energy City 55,800.00 5,497.98 15,461.53 27.71 40,338.47 TOTAL Economic Development 55,800.00 15,617.38 63,137.40 113.15 ( 7,337.90) 7-15-2009 10:23 AM 101-GENERAL FUND General DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 PAGE: 25 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 101-4-7000-4724 Transfer - Pinewood 101-4-7000-9730 Transfer-Debt Service TOTAL Transfers Out 100,400.00 0.00 0.00 0.00 100,900.00 62,300.00 0.00 0.00 0.00 62,300.00 66,600.00 0.00 66,600.00 100.00 0.00 229,300.00 0.00 66,600.00 29.04 162,700.00 TOTAL Transfers Out 229,300.00 0.00 66,600.00 29.04 162,700.00 TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 229,300.00 0.00 66,600.00 29.04 162,700.00 12,207,550.00 866,743.98 5,213,105.46 42.70 6,994,444.54 428,550.00 2,463,544.58 ( 1,115,666.24) 1,544,216.24 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 221-ICE ARENA FINANCIAL SUMMARY REVENUE SUMMARY Ice Arena Hockey Skating Concessions TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 735,000.00 15,610.58 219,419.62 29.85 515,580.38 70,000.00 940.00 30,216.00 43.17 39,784.00 84,700.00 6,894.50 39,187.90 46.27 45,512.10 73,000.00 ( 107.83) 31,545.98 43.21 41,454.02 962,700.00 23,337.25 320,369.50 33.28 642,330.50 847,900.00 31,048.31 261,091.22 30.79 586,858.78 30,150.00 19.68 12,903.48 42.80 17,246.52 34,450.00 1,094.22 16,286.10 47.27 18,163.90 50,200.00 142.15 20,359.58 40.56 29,890.42 962,700.00 32,259.36 310,590.38 32.26 652,109.62 962,700.00 32,254.36 310,590.38 32.26 652,109.62 0.00 ( 8,917.11) 9,779.12 ( 9,779.12) 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 221-ICE ARENA ~ REVENUES Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 221-3-0000-3921 Transfers 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services 50.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 432,000.00 14,777.15 184,963.37 42.82 247,036.63 33,000.00 ( 218.86) 12,175.14 36.89 20,824.86 15,000.00 1,688.77 8,752.09 58.35 6,247.91 4,500.00 56.00 2,568.00 57.07 1,932.00 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 ( 950.00)( 85.00) 0.46- 18,585.00 505,600.00 15,353.06 208,373.60 91.21 297,226.40 22,000.00 220.84 6,697.79 30.94 15,302.21 0.00 0.00 3,493.00 0.00 ( 3,443.00) 2,000.00 36.68 905.23 45.26 1,094.77 24,000.00 257.52 11,046.02 46.03 12,953.98 100,000.00 0.00 0.00 0.00 100,000.00 105,400.00 0.00 0.00 0.00 105,400.00 205,400.00 0.00 0.00 0.00 205,400.00 735,000.00 15,610.58 219,419.62 29.85 515,580.38 70,000.00 940.00 30,216.00 43.17 39,784.00 70,000.00 940.00 30,216.00 93.17 39,784.00 70,000.00 940.00 30,216.00 43.17 39,784.00 84,700.00 6,594.50 33,891.50 39.95 50,858.50 0.00 0.00 3,586.00 0.00 ( 3,586.00) 84,700.00 6,594.50 37,427.50 99.19 47,272.50 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 221-ICE ARENA 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 300.00 1,760.40 0.00 ( 1,760.40) TOTAL Other Revenue 0.00 300.00 1,760.40 0.00 ( 1,760.40) TOTAL Skating 89,700.00 6,899.50 39,187.90 46.27 45,512.10 Concessions Charges for Services 221-3-5430-3467 Concessions 73,000.00 ( 107.83) 31,545.98 43.21 41,954.02 TOTAL Charges for Services 73,000.00 ( 107.83) 31,545.98 43.21 41,454.02 TOTAL Concessions 73,000.00 ( 107.83) 31,545.98 43.21 41,454.02 TOTAL REVENUE 962,700.00 ------------- - ------------- - 23,337.25 ---------- -------- 320,369.50 ------------- ------------- 33.28 ------ ------ 642,330.50 ------------- ------------- 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 ~ 221-ICE ARENA ' DEPARTMENTAL EXPENDITURES 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Ice Arena Personal Services 221-4-5400-4101 Regular Pay 150,300.00 9,685.48 73,075.95 48.62 77,224.05 221-4-5400-4102 Overtime Pay 0.00 0.00 6.38 0.00 ( 6.38) 221-4-5400-4103 Part-time Pay 72,850.00 1,951.73 29,721.51 40.80 43,128.49 221-4-5400-4104 PERA 11,350.00 783.19 6,962.70 61.35 4,387.30 221-4-5400-4105 FICA 14,150.00 708.97 6,753.28 47.73 7,396.72 221-4-5400-4107 Medicare 3,300.00 165.81 1,579.39 47.86 1,720.61 221-4-5400-4108 Insurance 16,600.00 1,121.82 8,600.08 51.81 7,999.92 221-4-5400-4109 Workers Comp 4,350.00 1,116.50 3,349.50 77.00 1,000.50 TOTAL Personal Services 272,900.00 15,533.50 130,048.79 47.65 142,851.21 Supplies 221-4-5400-4212 Fuels & Lubs 300.00 221-9-5400-4217 Uniform Allowance 1,500.00 221-4-5400-4219 Operating Supplies 41,100.00 221-9-5400-4255 Soft Drinks/Misc 13,500.00 221-4-5400-4259 Other Merchandise For Resale 1,200.00 TOTAL Supplies 57,600.00 Other Services & Charges 221-4-5400-4321 Telephone 2,900.00 221-9-5400-4322 Postage 500.00 221-4-5400-4331 Travel, Conferences & Schools 1,050.00 221-9-5400-4359 Publishing 2,000.00 221-4-5400-4361 Insurance 9,000.00 221-4-5400-4389 Utilities 175,850.00 221-4-5400-4401 Bldg Repair/Maint Services 19,750.00 221-4-5400-4409 Contractual Services 2,000.00 221-4-5400-4415 Equipment Rental 5,400.00 221-4-5400-4433 Dues & Subscriptions 450.00 TOTAL Other Services & Charges 218,900.00 Capital Outlay 221-4-5400-4520 Buildings & Structures 100,000.00 TOTAL Capita l Outlay 100,000.00 Transfers Out 221-4-5400-9730 Transfer-Debt Service 198,500.00 TOTAL Transfers Out 198,500.00 0.00 ( 202.93) 67.64- 502.93 210.85 298.35 19.89 1,201.65 3,913.34 12,179.76 29.63 28,920.24 0.00 4,411.93 32.68 9,088.07 0.00 221.85 18.49 978.15 4,124.19 16,908.96 29.36 40,691.04 217.52 1,166.41 40.22 1,733.59 0.00 60.78 12.16 439.22 0.00 149.00 19.19 901.00 0.00 2,046.06 102.30 ( 46.06) 0.00 9,047.50 49.97 4,952.50 10,698.46 73,711.12 41.92 102,138.88 290.74 6,915.75 35.02 12,834.25 177.90 280.91 19.02 1,719.59 106.50 1,293.94 23.96 9,106.06 0.00 187.50 41.67 262.50 11,390.62 69,858.47 41.05 129,091.53 0.00 0.00 0.00 100,000.00 0.00 0.00 0.00 100,000.00 0.00 24,225.00 12.20 174,275.00 0.00 24,225.00 12.20 174,275.00 TOTAL Ice Arena 847,900.00 31,048.31 261,041.22 30.79 586,858.78 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REP ORT (UNAUDITED) AS OF: JUNE 30TH, 2009 221-ICE ARENA Culture & Recreation 50.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 3,600.00 0.00 154.00 4.28 3,446.00 221-4-5410-4105 FICA 200.00 0.00 9.55 4.78 190.45 221-4-5410-4107 Medicare 50.00 0.00 2.23 4.96 97.77 TOTAL Personal Services 3,850.00 0.00 165.78 9.31 3,684.22 Supplies 221-4-5410-4219 Operating Supplies 19,850.00 0.00 7,200.60 48.49 7,649.40 TOTAL Supplies 19,850.00 0.00 7,200.60 48.49 7,649.40 Other Services & Charges 221-4-5410-4322 Postage 500.00 0.00 0.00 0.00 500.00 221-4-5410-4359 Publishing 1,700.00 0.00 0.00 0.00 1,700.00 221-4-5410-4909 Contractual Services 7,050.00 7.20 4,135.60 58.66 2,914.40 221-4-5410-4438 Credit Card Fees 2,200.00 12.48 1,401.50 63.70 798.50 TOTAL Other Services & Charges 11,450.00 19.68 5,537.10 48.36 5,912.90 TOTAL Hockey 30,150.00 19.68 12,903.48 42.80 17,246.52 Skating Personal Services 221-4-5420-4103 Part-time Pay 20,000.00 0.00 9,013.36 45.07 10,986.64 221-9-5920-4109 PERA 500.00 0.00 428.60 85.72 71.40 221-9-5920-4105 FICA 1,250.00 0.00 575.90 46.07 674.10 221-4-5420-4107 Medicare 300.00 0.00 134.67 44.89 165.33 TOTAL Personal Services 22,050.00 0.00 10,152.53 46.04 11,897.47 Supplies 221-4-5420-4219 Operating Supplies 6,000.00 467.77 3,407.71 56.80 2,592.29 TOTAL Supplies 6,000.00 467.77 3,407.71 56.80 2,592.29 Other Services & Charges 221-9-5420-4322 Postage 200.00 0.00 0.00 0.00 200.00 221-4-5920-4359 Publishing 1,300.00 358.91 358.91 27.61 941.09 221-4-5420-4409 Contractual Services 2,450.00 174.00 1,583.78 64.64 866.22 221-4-5420-9438 Credit Card Fees 2,450.00 93.54 783.17 31.97 1,666.83 TOTAL Other Services & Charges 6,900.00 576.45 2,725.86 42.59 3,674.14 TOTAL Skating 34,450.00 1,049.22 16,286.10 47.27 18,163.90 7-15-2009 10:23 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES 50.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5930-4103 Part-time Pay 20,900.00 221-9-5430-4104 PERA 0.00 221-4-5430-4105 FICA 1,300.00 221-9-5430-4107 Medicare 300.00 TOTAL Personal Services 22,500.00 Supplies 221-4-5430-4219 Operating Supplies 6,700.00 221-9-5430-4259 Other Merchandise For Resale 21,000.00 TOTAL Supplies 27,700.00 0.00 7,500.87 33.34 14,999.13 0.00 711.28 10.62 5,988.72 142.15 12,147.93 57.84 8,852.57 142.15 12,858.71 46.92 14,841.29 TOTAL Arena Concessions TOTAL Culture & Recreation 0.00 6,780.08 32.44 14,119.92 0.00 177.00 0.00 ( 177.00) 0.00 440.72 33.90 859.28 0.00 103.07 34.36 196.93 50,200.00 142.15 20,359.58 40.56 29,840.42 962,700.00 32,254.36 310,590.38 32.26 652,109.62 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 962,700.00 32,254.36 310,590.38 32.26 652,109.62 0.00 ( 8,917.11) 9,779.12 ( 9,779.12) 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 50.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 254,800.00 32,636.26 109,051.26 42.80 145,748.74 TOTAL REVENUES 254,800.00 32,636.26 109,051.26 42.80 145,748.74 EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 259,800.00 26,652.32 126,828.28 49.78 127,971.72 259,800.00 26,652.32 126,828.28 49.78 127,971.72 254,800.00 26,652.32 126,828.28 49.78 127,971.72 0.00 5,983.94 ( 17,777.02) 17,777.02 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 222-PINEWOOD GOLF COURSE ~ REVENUES Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments 222-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 222-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 222-3-0000-3792 Cash Over TOTAL Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course SO.OOa OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 20,000.00 4,075.07 20,052.05 100.26 ( 52.05) 19,000.00 3,636.82 7,783.44 40.97 11,216.56 4,000.00 1,108.80 2,948.15 73.70 1,051.85 112,000.00 18,945.85 53,321.67 47.61 58,678.33 18,000.00 0.00 14,230.00 79.06 3,770.00 19,000.00 3,281.00 7,915.00 41.66 11,085.00 0.00 1,020.00 2,188.51 0.00 ( 2,188.51) 500.00 350.00 400.00 80.00 100.00 192,500.00 32,417.54 108,838.82 56.54 83,661.18 0.00 205.50 205.50 0.00 ( 205.50) 0.00 205.50 205.50 0.00 ( 205.50) 0.00 13.22 6.94 0.00 ( 6.94) 0.00 13.22 6.94 0.00 ( 6.99) 62,300.00 0.00 0.00 0.00 62,300.00 62,300.00 0.00 0.00 0.00 62,300.00 259,800.00 32,636.26 109,051.26 42.80 145,748.74 TOTAL REVENUE 254,800.00 32,636.26 109,051.26 42.80 145,748.74 7-15-2009 10:23 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2009 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES Golf Course CURRENT CURRENT BUDGET PERIOD SO.OOo OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE Personal Services 222-4-5300-4101 Regular Pay 89,300.00 7,358.29 43,429.22 48.63 45,870.78 222-4-5300-4102 Overtime Pay 100.00 0.00 169.38 169.38 ( 69.38) 222-4-5300-4103 Part-time Pay 28,650.00 6,639.09 10,629.15 37.10 18,020.85 222-4-5300-4104 PERA 8,100.00 662.04 3,396.70 41.93 4,703.30 222-4-5300-4105 FICA 7,450.00 851.91 3,488.70 46.83 3,961.30 222-4-5300-4107 Medicare 1,750.00 199.22 815.93 46.62 934.07 222-9-5300-4108 Insurance 9,200.00 876.00 4,966.00 53.98 4,234.00 222-9-5300-4109 Workers Comp 1,050.00 294.00 882.00 84.00 168.00 TOTAL Person al Services 145,600.00 16,875.50 67,777.08 46.55 77,822.92 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 644.52 1,252.24 25.04 3,747.76 222-4-5300-4217 Uniform Allowance 500.00 24.70 353.63 70.73 146.37 222-4-5300-4219 Operating Supplies 25,100.00 2,203.74 7,275.94 28.99 17,824.06 222-4-5300-4259 Other Merchandise For Resale 10,800.00 3,199.98 7,438.24 68.87 3,361.76 TOTAL Suppli es 41,900.00 6,072.94 16,320.05 39.42 25,079.95 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 224.22 883.95 35.36 1,616.05 222-4-5300-9331 Travel, Conferences & Schools 900.00 55.27 381.60 95.40 18.40 222-4-5300-4349 Advertising/Marketing 1,500.00 0.00 159.75 10.65 1,340.25 222-4-5300-9361 Insurance 11,550.00 0.00 5,146.50 94.56 6,403.50 222-4-5300-4389 Utilities 6,800.00 529.03 1,759.92 25.81 5,045.08 222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 19.97 99.85 4.99 1,900.15 222-4-5300-9404 Equip Repair/Maint Services 2,500.00 117.60 954.45 38.18 1,545.55 222-4-5300-4415 Equipment Rental 36,050.00 84.54 682.62 1.89 35,367.38 222-4-5300-4437 Taxes & Licenses 1,000.00 369.39 ( 948.97) 94.90- 1,948.97 222-4-5300-9438 Credit Card Fees 3,500.00 887.91 1,815.00 51.86 1,685.00 TOTAL Other Services & Charges 67,800.00 2,287.88 10,929.67 16.12 56,870.33 Debt Service 222-9-5300-4601 Principal 0.00 1,416.00 31,801.48 0.00 ( 31,801.48) TOTAL Debt S ervice 0.00 1,416.00 31,801.98 0.00 ( 31,801.48) TOTAL Golf Cou rse 254,800.00 26,652.32 126,828.28 49.78 127,971.72 TOTAL Culture & Recreation 254,800.00 26,652.32 126,828.28 49.78 127,971.72 TOTAL EXPENDITU RES 254,800.00 26,652.32 126,828.28 99.78 127,971.72 REVENUES OVER/( UNDER) EXPENDITURES 0.00 5,983.94 ( 17,777.02) 17,777.02