Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 03-15-2010
~~ C'~ C1 ~~~1 rJ l)!-.1 1. ~d la '4..;~ a ~:I C ty of Elk -~. River MEMORANDUM a~ n ~ a nii • Ti i n, Fin na ~ : r 1 , ~ T: F cur 1 and i in i I This report is designed to provide summary information regarding the overall level of xevenues and expenditures in the General Fund and Pinewood Golf and Ice Arena special revenue funds. These funds are the primary concern in analyzing the City's financial health, For the month of February, actual xevenues except for property taxes and state aids} and expenditures should run about 16.7% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget fox 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. ~e~eral Fu~a~. .A.evenue.~; Excluding transfers in, revenue collections axe slightly over 1 % of budget. Property taxes, our largest revenue source, will be received in July and December. Inteigove~•nmental revenue includes the collection of half the state-aid street maintenance; the other half will be collected in July, Recreation fee collections are right in line with budget estimates. The negative interest income is related to the reversal of the prior year's interest receivable which was done this month. The transfers in will be recorded mid-year. .~xpendititres; Excluding transfers out, the total departmental expenditures are at about 11.$% and most departments are well within o~.• below budget. The Snow Removal budget reflects the seasonal expenditures for• salaries and road salt, The negative expenditure amount ii1 Energy City is related to contributions fox the energy expo that was held in February. The transfers out to the Ice Arena and Pinewood Golf axe made at the end of the year. Yce ~e~a As of the end of February, revenues exceed expenditures by x$$,009. Excluding transfers, revenues are about 23.$% of budget due mainly to the hockey season receipts and program registrations while expenditures are about 13°/a of budget. Pi~ev~rood golf Golf revenues will not be generated until spring while expenditures are about G% of the budget due mainly to personal services and insurance, 3--10-2010 08x13 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT {UNAUDITED] As aF; FEBRUARY 2$TH, 2010 ~a i, ~ ~~ `~ ~~ ~ ~~~~~ ,~~ Ta t~ t_:r, 101-~GENERAL FUND FINANCIAL SUMMARY 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 11,719,800.00 113,853.07 178,091,14 1.52 11,591,708.86 TOTAL REVENUES 11,719,800.00 113,853.07 178,091.14 1.52 11,591,708.86 EXPENDITURE SUMMARY General Government Mayor & Council 167,65D.D0 8,157.14 30,795.87 18.37 136,859.13 Cable TV 81,550.DD 5,332.29 8,703.D7 10.66 72,946.93 Administrative Services 470,500.OD 33,796.59 61,741.26 13.12 908,758.79 Human Resources 150,45D.D0 11,815.32 20,875.67 13.88 129,574.33 Elections 38,100.00 0.00 0.00 D.00 38,100.00 Finance 947,400.00 27,577.31 61,387.81 3.3.72 386,012.1.9 Information Technology 303,150.00 13,596.$6 21,945.61 7.24 281,209.39 Legal 234,000.00 11,633.50 11,633,50 4.97 222,366.50 Community Development 67,150.00 5,105.71 8,444.80 12.58 58,705.20 Planning 299,95D.00 21,515.08 35,123.15 3.1.73. 269,826.85 City Hall Maintenance 297,000.00 23,719,35 90,198.89 13.53 256,801.16 Contingency 113,100.00 0.00 D.00 0.00 113,100.00 TOTAL General Government 2,670,10D.00 162,299.15 300,899.58 13..27 2,369,25D.92 Public Safety Police Administration 543,800.OD 32,47$.16 98,922.33 18.19 944,877.67 patrol 2,245,150.DD 156,DDO.D7 253,849.96 11.31 1,991,340.59 Investigations 731,350.00 51,895.17 87,008.54 13..90 694,391.96 Police Support Services 501,900.00 36,859.18 59,544.85 11.$6 442,355.15 Police ReSerVeS 22,900.00 405.66 641.66 2.80 22,258.34 Public safety building 206,250.00 1.9,3.85.22 29,839,97 14,47 176,41D.D3 Fire Administration 465,550.00 27,542.44 53,109.89 11.91 412,440.11 Fire inspections 184, 600 . QO 13,129.90 21, 300.33 3.3..59 3.63, 299.67 Emergency Management 30,800.00 3.,032.36 1,628.48 5.29 29,171.52 Building Safety 465,550.00 34,3.43.29 58,770.79 12.52 4D6,779.21 Environmental 52,200.00 3,575.35 5,918.56 12.30 95,781.44 TOTAL Public Safety 5,450,05D.D0 376,241.80 671,039.86 3.2,31 9,779,D15.19 Public Works Street Maintenance 1,336,950.00 60,689.68 101,967,63 7,63 1,239,982,37 Snow Removal 246,550.DD 87,100,40 107,950.55 43,78 138,599.45 Equipment Services 246,300.OD 14,152,1$ 25,906.$3. 3.0.32 220,893.19 Fngineer.~ng 178,350,00 9,678.81 9,899.83 2.74 173,955.3.7 TOTAL Public Works 2, 00$,150 . DD 3.66, 623..07 240, 219.82 11.96 1, 767, 930.3.8 3-1D-2010 08;13 AM CITY OF ELK RIVER PAGE; 2 REVENUE & EXPENSE REPORT {UNAUDITED} AS OF: FEBRUARY 2$TH, 2010 1D1-GENERAL FUND FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD 16.67°s aF YEAR car~P. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BAT,ANCE Culture & Recreation Par~CS Department Parfcs & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Ecanamic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/{UNDER} EXPENDITURES 767,150.00 50,043.59 86,613.39 11.29 680,536.61 543,30D.00 38,3D8.43 63,187,49 11.63 480,112.51 173,550.00 3,906.94 8,8D5.71 5.07 164,744.29 13,85D.D0 592.75 928.41 6.70 12,921.59 203,250.00 14,775.29 23,334,50 11.98 179,915.50 1,7D1,100.00 107,627.00 182,869.50 1D.75 1,518,230.50 0.00 { 1,099,83} 13,926.38 0.00 { 13,926.38} 51,35D.OD { 4,622.96){ 4!1$1.12) $.19- 55,531.12 51,35D.OD ( 5,722.79 9,745.26 18.98 41,604.74 169,05D.00 0.00 0.00 D.00 164,D50.D0 164,o5D.oo a.oo D.ao D.DD 164,a5D.0o 12,094,8DO.OD 807,011.23 1,404,719.02 11.66 1D,640,D80.98 ( 325,DDD.DD}( 693,158.16}{ 1,226,627.8$} 9D1,627.88 3-10-207.0 08:13 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: FEBRUARY 28TH, 2010 101-GENERAL FUND CURRENT CURRENT YEAR TO DATE REVENUES BUDGET PERIOD ACTUAL PAGE ; 3 16.67% OF YEAR COMB, OF BUDGET BUDGET BALANCE General Fund Taxes 101--3~ODQ0~-3111 Current Ad Valorem Taxes 9, 688, 950.00 101-3-0000-3121 Gravel Tax 135,000,00 TOTAL Taxes 9,823,950,00 Licenses & Permits 101-3-0000-3211 Liquor License 51,000.00 101-3-0000-3212 Amusement License 1,004.04 101--3--0000-3213 Cigarette License 3, DDO , 00 101-3-GOOD-3219 Apartment License 15,850.00 101-3-DODO-3216 Mining License 20,000.00 101-30000-3217 Garbage Hauler License 3,000.04 101--3-0000--3218 Other Business License/Permit 13,040.00 101-3-0000-3229 NPDES Permit 2,000.00 101-3-0000-3231 Building Permit 135,000.00 101-~3~-DDDD-3232 Plumbing/Heating Permit 40,000,00 101-3-0000--3233 Permit Surcharge 200.00 101-3-0000-3235 Animal License 3,000.00 101-3-0000-3236 Parking Permit 2,000.00 101--3--0000-3237 Other Non-Business I~ic/Permit 10,000.00 TOTAL Licenses & Permits 299,050.00 0.00 36.79 0.00 9,688,913.21 D.OD 0.40 0.00 135,000.00 O.DD 36.79 D.DD 9,823,913,21 O.OD 0.00 0.00 51,000.00 0.04 D.OD O.DO 1,004.00 0.00 0.00 0.00 3,000.00 750.00 750.00 4.73 15,100.00 O.OD 0.00 0.00 20,000.00 0.00 765,00 25,50 2,235.00 930.00 8,135.00 62.58 4,865.00 350.00 525.00 26.25 1,975.00 4,238.15 7,849.00 5.81 127,151.00 1,825.71 4,953.02 11.13 35,596.98 63.05 285.20 142,60 ( 85.20} 200.00 410.00 13.67 2,590.00 60.00 960.00 23,00 1,590.00 220.00 2,320.00 23.20 7,680.00 8,636.91 25,952.22 8.68 273,097.78 Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,000.00 O.DD 0,00 O.DO 3,000.00 101--3~OOOD~3322 MV Credit ~ 221,100.00} O.DO D,DO D,DO [ 221,100.00} 101-3-0000--3329 PERA Aid 14,000,00 0.00 0.00 0.00 19,000,00 101-3-0000-3325 Police 2% Aid 200,000,00 D.DO O.DD O.DD 200,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 O.DO O.DO O.DD 10,000.00 101-3-0000-3327 State-Aid Street Maint 39,000.00 28,905.39 28,905.39 74.12 10,094.61 101-~3~-DODO-3329 State Crime Prevention Grant 13,000.00 ( 12,129,00} 0.01 0.00 12,999.99 101-3-D000~-3330 Other State Grants 4,900.00 p,DO 0.00 D,Dp 9,900.00 101-3-0000-3391 County Reimb/Grant 5,000.04 0,00 0,00 D.DO 5,000.00 TOTAL Intergovernmental Rev 67,800.04 7.6,776,39 28,905.90 92.63 38,894,60 Charges for Services 101-3-0000-3912 Planning & Zoning Fees 15,000.00 630.00 2,851.00 19.01 12,199,00 101-3-0000-3413 Plan Check Fee 50,000.00 2,096.31 3,439.00 6.88 46,561.00 101-3-0000-3415 Special Assessment Search 500.00 40.00 260.00 52.00 240.00 101-~3~-000D-3417 Copies 1,500,00 402.42 469,67 31,31 1,030,33 1D1~-3-~DDDD-3918 Other General Govt Services 9,000.00 226.25 226,25 5.66 3,773.75 101-3--ODOOw3930 Lockout Fees B,DOO.DD 780,00 1,910.00 17,63 5,590.00 101-3-000 03937. Police Services 2,000,00 230,50 316,75 15.84 7.,683.25 101-3-0000-3432 School Liaison 75,000,00 D.OD 37,500,00 50.00 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 50.00 300.00 10.00 2,700.00 101-3-ODOR-3436 Fire Contracts 185,000.00 0.00 O.DD 0.00 185,000.00 3--10-2010 08:13 AM CITY OF ELK RrVER PAGE; 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS 0F; FEBRUARY 28TH, 2010 101--GENERAL FUND REVENUES 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TD DATE % OF BUDGET SUDGET PERIOD ACTUAL BUDGE`T' BALANCE 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-~3~-0000-3961 Recreation Fees 101-3-GOOD-3967 Concessions 101-3-0000-3972 Park Use Fee 101-3-GOOD-3979 Facility Use Fee 101-3-0000-3975 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101--3~-0000~-39$4 Contractor License Clieck TOTAL Charges for Services Fines & Forfeits 101--3~-0040--3510 Court Fines 101-3-HOOD-3511 Parking Fines TOTAL Fines & Forfeits 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-DODO-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-WWTS 101-~3W0000--3993 Transfer-Liquor 101-3-0000-3945 Transfer--Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3999 Transfer-HRA TOTAL Transfers In TOTAL General Fund 1,000.00 O.DO 25,000.00 752.00 119,200.00 15,114.85 14,100.00 253.02 18,000.00 ( 239.01)( 9,300.00 1,713.82 7,800.00 650.00 2,500.00 260.00 D.DO D.DD 1,000.00 752.00 3.01 24,298.00 19,129.85 16.75 95,070.15 768,37 5.95 13,331.63 99.011 0.55- 18,099.01 1,898.82 43.00 2,951.18 85a.D0 1a. 9o 6,95D.oD 390.00 15.60 2,110.00 40.00 13.33 260.00 531,200.00 22,935.16 70,952.70 13.26 960,747.30 125,000.00 7,449.00 7,449.00 5.96 117,551.00 10,000.00 2,285.00 3,795.00 37,95 6,255.00 135,000.00 9,739.00 11,199.00 8.29 123,806.00 160,000.00 0.00 ( 16,230.25) 10.19-- 176,230.25 72,000,00 100.00 200.00 0.28 71,800.00 22,200.00 1,669.00 2,899.00 12.83 19,351.00 3,000.00 2,006.61 2,731.28 91.09 268.72 257,200.00 3,770.61 ( 10,499.97 4.06- 267,649.97 35,000.00 0.00 39,500.00 0.00 50,000.00 0.00 248,600.00 D.Oo 206,000.00 52,000.00 17, ooD. Do o.oo 9,500.00 O.oO 605,600.00 52,000.00 0.00 0.00 35,000.00 0.00 0.00 39,500.00 0.00 0.00 50,000.00 0.00 0.00 298,500,00 52,000.00 25.24 159,000.00 o . oD o . Do 17, 000.00 0.00 0.00 9,500.00 52,000.00 8.59 553,600.00 11,719,800.00 113,$53.07 178,091.14 1.52 11.,541.,708.86 TOTAL REVENUE 11,719,800.00 113,853.07 178,091.19 1.52 11,541,708.86 3-1D-201D D8:13 AM CITY Off' ELK RTVER PAGE; 5 REVENUE & EXPENSE REPORT (UNAUDTTED~ AS DF: FEBRUARY 28TH, 2D1D 101-GENERAL FUND DEPARTMENTAI~ EXPENDITURES 16.67% OP' YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part--time Pay 1D1-4-1110-9109 PERA 1D1-4~-111D--9105 FTCA 101-4-1110-9107 Medicare 101-9-11.0-9109 Workers Comp TOTAL Personal Services Supplies 101-4-111D-42D1 Office Supplies TOTAL Supplies Other Services & Charges 1D1-9-111D-4319 Other Professional Services 1019--1110--4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-111.0-9359 Publishing 101-4-111D-9351 Tnsurance 1014-1110-9433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges 38,5DO.DD 3,208.D0 6,916.00 16.66 32,D84.D0 1,950.00 1DD.41 2D0.82 10.30 1,799.18 2,9DO.D0 Frn nn 198.9D n~ ~~ 397.80 n~ nn 16.58 ~G n~ 2,002.20 nFG nG 2,800.DD 23.57 195.62 5.20 2,654.38 2,8DD.D0 23,57 145.62 5.20 2,654.38 10,750.OD 1,597.61 3,176.61 29.55 7,573,39 50D.DD D.00 0.00 0.00 500.00 3,100.00 104.35 104.35 3.37 2,995.65 18,200.OD 2,825.98 2,882.08 15.89 15,317.92 68,050.00 0.00 17,266.75 25.37 50,783.25 15,5DO.DD 0.00 O.OD O.DO 15,500.00 5,300.00 101.80 1D1.8D 1.92 5,198.20 121,900.00 9,579.79 23,531.59 19.38 97,868.91 TOTAL Mayor & Council Cable TV Personal Services 101-9-1120-4101 Regular Pay 1D1-9-1120-4103 Part-time Pay 101w9--1120--4109 PERA 101-4-1120-4105 FICA 101-4-1120-9107 Medicare 101-4-112D-9108 Tnsurance 101-~4~1120-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-9201 Office Supplies TOTAL Supplies 167,650.00 8,157.19 30,795.87 18.37 136,859.13 52,000.00 3,918.91 6,073.53 11.68 45,926.97 11,750.00 353.13 993.76 4.20 11,256.24 3,650.00 274.28 543.67 14.90 3,106.33 3,950.00 262.86 516.03 13.06 3,433.97 900.00 61.48 120.7D 13.91 779.30 5,50D.D0 999.00 898.00 16.33 4,602.00 2DD.00 O.OD 44,25 22.13 155.75 77,950.00 5,319.16 8,689.94 11.15 69,260.06 1,000.00 D.00 D.DO 0.00 1,00D.OD 1, aoD . oD D. 00 0.0D D. 00 1, 000.00 3--14-zola as:13 AM 101--GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED AS OF: FEBRUARY 28TH, 2010 PAGE : 6 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF ~3UDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-9--112 09319 Other Professional Services 500.00 0.00 0.00 D.00 500.00 101-4-17.20-9322 Postage 50.00 0.00 0.00 0.00 50.00 101--4-1120-9331 Travel, Conferences & Schools 1,700.00 13.13 13.13 0.77 1,686.87 101-9-112 09909 Equip Repair/Maint Services 450,00 0.00 0.00 0.00 950.00 TOTAS, Other Services & Charges 2,700.00 13.13 13.13 0.49 2,b86.87 TOTAL Cable TV $1,650.00 5,332.29 8,703.07 10.66 72,946.93 Administrative Services Personal Services 101-9--121.0--9101 Regular Pay 295,100.00 22,598.45 35,027.61 11.87 260,072.39 101-9-121.0-4103 Part-time Pay 94,900.00 3,318.28 5,102.73 11.36 39,797.27 1D1-9-1214-9109 PERA 23,80D.00 1,814.18 3,591.12 15.09 2D,208.88 101--91210--9105 FICA 21,100 , DO 1, 539.77 3, 065.20 14.53 18, 039.8D 101-9-1270-4106 Other Retirement Contributions 9,800.00 900.00 80D.00 16.67 4,ODO.D0 101-4-1210-9107 Medicare 4,950.00 358.96 716.89 14.48 9,233.11 101-9-1210-910$ Tnsurance 29,600.00 2,250.01 9,500.02 18.29 20,099.98 1D1--9--1210--9109 Workers Comp 1, 500.00 O.OD 901.OD 26.73 1, 099.00 TOTAL Personal Services 920,750.00 32,274.65 53,209.57 12.65 367,595.43 Supplies 101--4--121.0--4201 Office Supplies 13, 000.00 173.29 312.23 2.9D 12, 687.77 TOTAL Supplies 13,OOO.OD 173.29 312.23 2.90 12,6$7.77 Other Services & Charges 101--9~121D~9319 Other Professional Services 5,100,00 0.00 5,D88.DD 99.76 12.00 101-4-~121.D-~9321 Telephone 900.00 58.3a 61.21 6.80 838.79 101-4-1210-4322 Postage 1,500.00 0.00 O.OD 0.00 1,500.00 101-9-1210-4331 Travel, Conferences & Schools 5,35D.D0 284.95 609,45 11.39 4,740.55 10 1-9-1214-9361 Tnsurance 250.00 4.04 23.25 9.30 226.75 101--9--127 04909 Equip Repair/Maint Services 21,650,00 1,005.90 2,292.55 10.59 19,357.45 101-9-1210-4433 Dues & Subscriptions 2,OD0.00 0.04 150.00 7.50 1,850.D0 TOTAL Other S ervices & Charges 36,750.00 1,348.65 8,224,96 22.38 28,525.54 TOTAL Administrative Services 974,500.00 33,796.59 61,791,26 13.12 908,758.79 Human Resources 3~-1D-2010 08;13 AM 101WGENERAL FUND General Government DEPARTMENTAL EXPENDTTURES CITY OE ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OE; FEBRUARY 28TH, 2010 PAGE; 7 16,670 0~' YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Personal Services 101-~9-~1220--91D1 Regular Pay 67,850.D0 5,219.29 8,089.$2 11.92 59,760.18 101-9-122D-4103 Part--time Pay 48,DOO.OD 4,016.43 b,399.D5 13.33 41,6DD.95 101-9-1220-41D9 PERA 8,100.D0 696.49 1,297.21 16.D1 6,842.79 101-4--1220-4105 FICA 7,200.00 567.07 1,148.50 15.95 6,051.50 1D1-9-1220-41D7 Medicare 1,700.00 132.62 268.60 15.80 1,931.9D 101-9-122D-9108 Tnsurance 5,50D.00 969,01 938.D2 17.D5 9,561.98 101-4--122D-4109 Workers Comp 500.00 D.00 136.75 27,35 363,25 TOTAI, Personal Services 138,850.00 11,050,86 18,277.95 13.1b 12D,572.05 Supplies 101-4-122D-9201 Office Supplies 9,100.00 699.6Q 2,296,26 56.D1 1,803,79 TOTAL Supplies 9,100.OD 699.6D 2,296.26 56.01 1,803.79 Other Services & Charges 1D1-4-1220-4319 Other Professional Services 3,DOO.OD O.DO D.00 0.00 3,OOD.00 101-9-122D-4322 Postage 350.00 O.OD D.DD 0.00 350.00 101--9~122D--9331 Travel, Conferences & Schools 2,25D.OD O.OD 175.OD 7.78 2,D75.00 101-4-1220-4433 Dues & Subscriptions 94D.OD 0.00 D.DD D.00 900.00 101-4-1220-9440 Miscellaneous 1,000.00 64.86 126.96 12.65 873.59 TOTAL Other Services & Charges 7,500.00 69.86 301,96 9.02 7,198.59 TOTAL Human Resources 154,45D.OD 11,815.32 20,875.67 13.$8 129,579.33 Elections Personal Services 101-9-1230-9103 Part-time Pay 30,OOD.00 0.00 D.OQ 0.00 30,000.00 TOTAL Personal Services 30,DDD.00 0,00 D.00 0.00 30,000.00 Supplies 101-4-1230-9219 Operating Supplies 4,6D0.00 D.00 0,00 0.00 4,6Q0.00 TOTAL Supplies 9,6D0,00 0.00 0.00 0.00 9x600.00 Other Services & Charges 101-9-123D-9322 Postage 7D0.00 O.OD 0.00 4,D0 7DD.OD 101-9-123D-9331 Travel, Conferences & Schools 7OD.OD 0.00 O.OD 0.00 700.00 101.4~-1230-~9359 Publishing 1, DOD . DD 0 , 00 0 . DO 0 , DO 1, 000.00 101-4-123 04909 Equip Repair/Maim Services 100.00 0.00 O.DD O.OD 100.00 101-9-1230-4415 Equipment Rental 1,40D.00 0.00 0.04 0.04 1,OOD.DD TOTAL Other Services & Charges 3,50D.OD O.DO O.OD O.OD 3,50D.00 TOTAL Elections 38x1DD.00 0.00 0.00 D.DD 38,1D0.00 3-10-201.0 08;13 AM CTTY OE ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT ~UNAUDITED~ AS OF: FEBRUARY 28TH, 2D1D 1.01-GENERAL FUND General. Government DEPARTMENTAL EXPENDITURES 16.670 OF YEAR CAMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Finance Personal Services 1D1-4-1310-4101 Regular Pay 101-9--1310-9103 Part-time Pay 101-4-1310--4104 PERA 101-4-1310-4105 FICA 101--9-131D-4107 Medicare 101-4--131.0--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-131D-4301 Audit Fees 101-4--1310-4319 Other Professional Services 101-4~-13104321 Telephone 101-4-1310-4322 Postage 1D1-4-1310-4331 Travel, Conferences & Schools 101--4~131D-9359 Publishing 101-4-1310-9404 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges 285,500.00 21,785.08 35,582.64 12.96 249,917,36 2,000.00 0.00 9D.D0 4.50 1,910.DD 2D, 000.00 1,529.96 3,022,70 15,11 16,977,30 17,850,00 1,261.56 2,591,12 14,24 15,308.88 4,20D.00 295.04 594.29 14.15 3,605.71 24,600.00 2,043.01 4,086,02 16.61 20,513.98 1,250,00 0.00 336.75 26,94 913.25 355,400.D0 26,909.65 46,253,52 13.01. 309,146.48 3,850.00 0,00 D.OD 0.00 3,850.00 3,85o.Da a.oo a.DD D.DO 3,85a.Do 18,000.00 0.00 3,900.00 21.67 14,100,00 49,000.00 0.00 0.00 0.00 49,DD0.00 80D,00 72.18 75.69 9.46 724.31 3,60D.00 0.00 0.00 O.DO 3,60D.OD 2,950,00 85.48 796,98 27.02 2,153.02 1,200.D0 0.00 0.00 O.DO 1,200.00 11,100.00 0.00 9,851.62 88.75 1,248.38 1,500.00 510.00 510.DD 34.00 990.00 88,150.00 667.66 15,134.29 17.17 73,015,71 TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101--4-1350-4104 PERA 101-4--1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 lnsurance 101-4-1350-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1350-9219 Dperating Supplies TOTAL Supplies 947,400.00 27,577,31 61,387,81 13,72 386,012.19 128,40D.DD 9,875.45 15,306.95 11.92 113,D93.05 9,OOO.D0 691.28 1,37D,22 15,22 7,629,78 8,300.00 581.08 1,168,96 19,08 7,131,09 1,950.OD 135.90 273.38 14,02 1,676.62 16,100,00 1,352.00 2,704.DD 16.80 13,396.00 600.00 D.00 151.5D 25.25 448.50 164,35D.00 12,635.71 20,975.01 12.76 143,374,99 29,900.00 912.39 912.39 3.05 28,987,61 29,900.00 912.39 912.39 3.05 28,987.61 3--1D-2D1D 08;13 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: FEBRUARY 28TI~, 2010 PAGE; 9 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1350-9319 Other Professional Services 8,000.00 101-4-~1350~9321 Telephone 750.D0 101-4-1350-9331 Travel, Conferences & Schools 12,3DD.00 101--4--1350-94D4 Equip Repair/Maint Services 16,950.00 TOTAL Other Services & Charges 38,DOD.00 Capital Outlay 101-4w1350--956D Equipment 7D,9DO.OD TOTAL Capital Outlay 7D,9DO.DD 0.00 0.00 0.00 8,DOD.OD 98.76 58.21 7.76 691.79 O.DO D.DD 0.00 12,300.00 0.00 0.00 0.00 16,950.00 48.76 58.21 4.15 37,991.79 O.DO 0.00 0.00 70,900,00 0.00 D.OD 0.00 70,900.00 TOTAL Information Technology Legal Other Services & Charges 101--9--19Q0--9309 Legal Fees TOTAL Other Services & Charges 303,150.D0 13,596.86 21,995.61 7.29 281,209.39 239,DOD.OD 11,633.50 11,633.50 4.97 222,366.50 239,OOD.OD 11,633.50 11,633.50 9.97 222,366.50 TOTAL Legal Community Development. Personal Services 101-4-1500-9101 Regular Pay 101-4-1500-9104 PERA 1D1-4-1500-9105 FICA 101-4-~150D-9107 Medicare 101-4-1500--4108 Insurance 101-4-1500-9109 ~Jorkers Comp TOTAL Personal Services Supplies 101-4-150D-42D1 Office Supplies TOTAL Supplies Other Services & Charges 101-4~-1500--9331 Travel, Conferences & Schools TOTAL Other Services & Charges 239,ODO.OD 11,633.50 11,633.50 9.97 222,366.50 52,7DD.D0 4,052.82 6,281.86 11.92 46,418.14 3,700.D0 2$3.7D 562.33 15.2D 3,137,67 3,250.00 243.28 986.54 19.97 2,763.96 750.00 c. inn nn 56.90 n Gn n1 113.80 n~o n~ 15.17 ~ ~ n~ 636.20 11 ~G1 no SoD.oD D.DD o.oo o.Da Soo.Do TOTAL Community Development 67,150.OD 5,105.71 8,949.80 12.58 58,705.2D 3-10-2D10 08:13 AM CITY OF ELK RIVER PAGE; 10 REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: FEBRUARY 28TH, 2D10 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 16,670 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Planning Personal. Services 1014-151D-4101 Regular Pay 101-9--1510--4169 PERA 101-4-1510-4105 FICA 161-9-1510-91D7 Medicare 101--9 151.0--4108 Insurance 101-4-151.0-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--9-151D-4319 Other Professional Services 101-9--1510w9321 Telephone 101-4-151.0-4322 Postage 101-4-1510-4337. Travel, Conferences & Schools 101-4-1510-4359 Publishing 101--9--157.Ow43G1 Insurance 101-4-1510-4904 Equip Repair/Maim Services 1D1-9-1510-9433 Dues & Subscriptions 161-9-151D-9490 Miscellaneous TOTAL Other Services & Charges 208,900,00 16,069.74 29,908,09 11,92 183,991.91 14,600,00 1,129.88 2,229.67 15.27 12,370.33 12,950.00 967,98 1,815,96 14.02 11,134,04 3,05p.DD 212,36 924,72 13.93 2,625.28 26,950,00 2,254,01 4,508.D2 16.73 22,441.98 650,00 0.00 154,60 23.69 496.06 267,100,00 20,568.97 34,040.96 12,74 233,059,54 4,75D,D0 61.22 61,22 1,29 9,688.78 2,556,60 126,66 139,25 5.46 2,910,75 7,300.00 187,88 200.47 2.75 7,099,53 0,60 90.00 90.00 0,00 ( 90,00} 800.00 24.96 25.45 3.18 774.55 2,000,00 0,00 0.00 0,00 2,606.00 6,050.00 36.71 30.71 0.51 6,019.29 . 10,666.66 995,00 495,00 4.95 9,505.00 450.00 0.00 23,50 5.22 426.50 S,OOO,DO 117,56 117,56 2.35 4,882,44 1,000.00 D.00 100.00 10,00 900.00 250,00 0.00 0.00 0,00 250.00 25,550,00 758,23 882.22 3.45 29,6&7.78 TOTAL Planning City Hall Maintenance Personal Services 101-4µ1G004101 Regular Pay 101-4-1600--4102 Overtime Pay 101-4-1600-4103 Part-time Pay 101-4-16D0-4104 PERA 1p1~4-1606-4105 FICA 101-9~1600~-91D7 Medicare 101-4-1640--9108 Insurance 101-4-1600-4109 Workers Comp TOTAL Personal. Services 299,950.00 21,515,08 35,123,15 11.71 269,826.85 87,350,00 7,107,56 11,0&7,33 12.67 75,282.67 2,50D.OD O.DD 255.2D 10,21 2,244.SD 23,050,00 1,683,76 2,572,40 11.16 20,477,60 8,106.00 615,40 1,316,50 16.25 6,783.50 7,150,D0 539.89 1,164.32 16.28 5,985.68 1,650,00 126.27 272,31 16.50 1,377,69 16,350,00 1,268.D9 2,989,01 18,25 13,365,99 4,550,00 0.00 1,324.00 29,10 3,226,00 150,700.00 11,340,97 20,956.07 13,91 129,793,93 3--1D-2D1o 08:13 AM 1 D 1--GENERAL FUND General Government DEPARTMENTAL EXPENDTTURES PAGE: 11 16.67a OE YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERrOD ACTUAL BUDGET BALANCE Supplies 1D1-~4--T6Q0~4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-160D-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4--160D--4321 Telephone 101-4-1600-4331 Travel, Conferences & Schools 101-9-1600-4361 Tnsurance 101-~4--1600--4389 Utilities 1D1-4-1600-4401 Bldg Repair/Maim Services 101-4-160D-4404 Equip Repair/Maim Services 1D1~-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges 3,750.00 265.D8 290,25 7,74 3,459.75 1,700.DD 353,D8 382,82 22.52 1,317.18 3D,440.D0 1,166.16 5,554,18 18,27 24,845.82 35,850,00 1,784.32 6,227.25 17,37 29,622.75 15,450,00 95D.D3 1,780.07 11,52 13,669.93 2,000,00 D.DO 0.00 0.04 2,D00.00 4,50D.OD 4.00 1,119,75 29,88 3,380.25 51,800.OD 4,9D9,71 4,909.71 9.48 46,890.29 30,650.00 4,641,82 5,030,99 16.41 25,619,01 5,OOD,OD 0,00 D.OD D.DD 5,OD0.00 1,D5D.00 87,50 175.D0 16,67 875.00 110,450.DD 10,589.D6 13,015.52 11,78 97,434,4$ TOTAL City Hall Maintenance 297,DDO.DO 23,714.35 40,198.84 13.53 256,801.16 Contingency Other Services & Charges 101-9-1900-4940 Miscellaneous 113,10D.00 0.00 0.00 0.00 113,100.00 TOTAL Other Services & Charges 113,10D.D0 0.00 D.DO 0.00 113,100.00 TOTAL Contingency 113,100.00 0.00 0,00 D.DO 113,100.00 TOTAL General Government Police Administration Personal Services 101-4-211D-4101 Regulax Pay 101-4-211Q-4104 PERA 101-4--2110~41D7 Medicare 101-4-2110-4108 insurance 101-4-217D-4109 Workers Camp TOTAL Personal Services Supplies 1014-~2110-~4201 Office Supplies 101-4-217D-4217 Uniform Allowance 101-4-2170-4219 Operating Supplies TOTAL Supplies CITY OE ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2010 2,67D,100.00 162,294.15 3DD,849.58 11.27 2,369,250,42 275,9DD.D0 21,182,44 32,832,76 11.92 242,567,24 38,850.00 2,986,74 5,973,48 15,38 32,876,52 1,250.00 2D1.5D 403.00 32.24 847.D0 24,9DO.D0 2,027,02 4,054.D4 1&. 61 20,395,96 55,15D.DD O.OD 13,390.50 24.28 91,759.5D 395,050.Q0 26,397,70 56,&53.78 14.39 338,396,22 17,ODO,DO 433,71 433.71 2.55 16,566.29 2,150,00 455.D8 455.08 21.17 1,694,92 1,950,00 127.16 127.16 6.52 1,822.84 21,10D,DD 1,015.95 1,015.95 9,81 2Q,084,D5 3-10-2010 08;13 AM CITY Off' ELK RIVER PAGE; 12 REVENUE & EXPENSE REPORT (UNAUDITED] As oF; FEBRUARY 28Tx, 2D1a 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET aALANCE Other Services & Charges 101-4-2110-9319 Other Professional. Services 101-92110--9321 Telephone 1D1-4-211D-9322 Postage 101.4-2110--9331 Travel, Conferences & Schools 141-4-2110-9359 Publishing 101-4-2110-9361 lnsurance 101-9-21109909 Equip Repair/Maint Services 101-4-211D-4433 Dues & Subscriptions 101-4-21.0-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 5,500.00 0.00 0.00 0.00 5,500.00 27,900.D0 1,844.25 2!073.05 7.57 25,326.95 2,100.00 5,08 5.08 0.29 2,099.92 4,300.00 1,779.00 650.00 15.12 3,650.00 500.00 0.00 0.00 0.00 500.00 9,854.00 0.00 2,234.25 22.64 7,619.75 68,900.00 1,356.18 35,179,22 51.06 33,720.78 8,9DO.D0 8D.00 1,115.00 13,27 7,285.00 700.00 D.00 0.00 0.00 7DO.D0 127,650.00 5,064.51 91,252.60 32.32 86,397.40 TOTAL Police Administration Patrol Personal Services 101-4-2120-9101 Regular Pay 101--9.2120--9102 Overtime Pay 107.-4-21.20-9104 PERA 101-4-2120-9107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-9-2120-4212 Fuels & Lubs 101--9-2120--9217 Uniform Allowance 101--4--2120--4219 Operating Supplies 101-9-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-9909 Equip Repair/Maint Services 101-4-2120-9433 Dues & Subscriptions 101-9~-2120-9960 Equip Replacement Charge TOTAL Other Services & Charges 543,800.00 32,978.16 98,922.33 18.19 494,877.67 1,441,80D.D0 1D 6,3D7.96 167,799,22 11.64 1,279,000.78 90,000.00 3,980.79 9,925.33 5.97 85,079.57 216,000.00 15,480.25 31,416.46 14.54 184,583.59 19,900.00 1,285.79 2,594.99 13.04 17,305,01 163,500.D0 13,986.34 27,972.68 17.11 135,527.32 1,931,200.00 190x541.08 234,708.68 12.7.5 1,696,491.32 118,350.D0 8,233.75 8,332.33 7.09 110,017.67 15,850.D0 839.99 1,D07.71 6.36 14,842.29 69,650.00 851.56 880.48 1.26 68,769.52 28,000.00 1,550.05 1,550.05 5.54 26,499.95 231,850.00 11,975.95 11,77D.57 5.08 220,079,43 15,300.00 370.00 475,00 3.10 19,825,00 27,350.00 221.87 221.87 0.81 27,128.13 550.00 150,00 19D.00 39.55 360,00 38,900.00 3x291.67 6x983.39 16.67 32,47.6.66 82,100.00 3,983.54 7x370.21 8.98 74,729.79 TOTAL Patrol 2,245,150,00 15&,000,07 253,849,96 11.31 1,991,300.59 3-1a--zolo 08:13 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; FEBRUARY 28TH, 2o1D 1D1-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-~4--21304104 PRRA 1D1-4-213D-4107 Medicare 101-9-2130-4108 Insurance TOTAL Personal Services Supplies 1D1--4-213D-4217 Uniform Allowance 101--4--2130--4219 Operating Supplies TOTAL Supplies Other Services ~ Charges 101-4--2130--4319 Other Professional Services 1D1-4-2130-4331 Travel, Conferences & Schools 1D1-4-2130-4433 Dues & Subscriptions 101--9-2130-446D Eguip Replacement Charge TOTAL Other Services & Charges 505,40D.00 36,249.80 56,179,44 11.12 449,220.56 4D,DOD.OD 1,327.20 2,976,65 6,19 37,523.35 76,9DD.00 5,297.67 1D,6D1.46 13.79 66,298,54 4,75D.00 341.26 b82.97 19.37 4,067,53 61,65D.00 5,136.86 1D, 273.72 16.66 51,376.28 688,7DD.00 98,347.79 80,213.74 11.65 608,986.26 5,05D.OD 1,344.32 1,349.32 26.62 3,7D5.68 6,8D0.00 983.79 540.38 7.95 6,259.62 11,85D.DD 1,828.11 1,884.7D 15.90 9,965.30 11,900.00 220.00 440.00 3.70 11,460.00 4,05D.DD 23.44 1,823.44 45.02 2,226.56 800.00 305.00 305.00 38.13 495.DD 14,050.D0 1,170,83 2,341.66 16.67 11,708,34 30,80D.D0 1,719.27 4,91D.10 15.94 25,889.90 `TOTAL Investigations Police Support Services Personal Services 101-4-215D~-9101 Regular Pay 101-4-2150-4102 Overtime Pay 101-9-215D-41D4 PERA 101--9--2150-9105 FICA 101-4--2150--9107 Medicare 101-4-2150-41.08 insurance TOTAL Personal Services Supplies 1D1-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies 731,350.00 51,895.17 87,008.54 11,90 644,391.96 397,3DO.D0 26,5D5.61 91,198.36 11.86 306,101.64 6,500.D0 O.OD 0.00 0.00 6,500.00 24,75D.OD 1,$55,90 3,711.99 15.D0 21,038.01 21,950.00 1,507.14 3,244,41 14,78 18,705,59 5,150.OD 375.90 758.84 14,73 4,391.16 49,150.00 3,621.81 7,221.01 16.36 36,928.99 449,800.D0 33,965.86 56,139.61 12.98 393,665.39 1,000,00 o.oD o.aa D.oo 1,000.00 2,750.OD { 47.9Dy{ 97.9DJ 1.74- 2,797.9D 9,15D.D0 15,70 67.62 D,74 9,D82.38 12,9DD.D0 ( 32.20) 19.72 0.15 12,880.28 3-10-2010 08:13 AM 101-GENERAL FUND Public Safety DEPARTMENTAT~ EXPENDITURES PAGE ; 14 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 101-4--21504404 Rquip Repair/Maim Services 101-4-2150-4409 Contractual Services 1D1-4-2150-4433 Dues & Subscriptions 101-4~-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101-4-2150-4560 Equipment TOTAL Capital Outlay 3,550.00 50.00 50.00 1.41 3,500.00 2,650.00 1,207.69 1,207.59 45.57 1,442.31 16,000.00 1,060.33 1,060.33 6.63 14,939.67 500.00 177.50 222.50 94.50 277.50 5,100.00 425,00 850.D0 16.67 9,250.00 27,800,00 2,920.52 3,390.52 12,20 29,409.48 11,400.00 0.00 0.00 D.OD 11,900.D0 11,900.00 0.00 D.00 O.OD 11,400.00 TOTAL Police Support Services 501,900.00 36,854.18 59,594.85 11,86 442,355,15 Police Reserves Personal Services 101-9-2160-4103 Part--time Pay 5,500.00 240.30 327.D8 5.95 5,172.92 101-9-2160-4105 FICA 350.00 14.89 22.75 6,50 327,25 1D1-9-2160-4107 Medicare 100.00 3.48 5.32 5.32 94.68 TOTAL Personal Services 5,950.00 258.67 355.15 5.97 5,594.85 Supplies 101-4-216D-9217 Uniforr~ Allowance 5,000.00 7.47 7.97 0.15 4,992,53 101--4-~2160~-9219 Operating Supplies 6, 000.00 0, 00 D. 00 0.00 6, OD0.00 TOTAL Supplies 11,000.00 7,47 7.47 D.07 1D,992.53 Other Services & Charges 101--42160-4319 Other Professional Services 1,500.00 D.OD .0.00 D.00 1,500.00 101--4~-2160--4321 Telephone 1, 600.00 139.52 279.04 17.49 1, 320.9& 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0,00 1,700.00 101-9-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 101-9-2160-4933 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 5,950.OD 139,52 279,04 4,69 5,670.96 TOTAL Police Reserves Public safety building Personal Services 101 42190-41D1 Regular Pay 101--4--219D--91D9 PERA 101-4~-2190.4105 FICA 101--4-2190-41D7 Medicare 101-4-2190--4108 Insurance CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; FEBRUARY 28TH, 2010 22,900.00 4D5.66 691.66 2.80 22,258.34 100,600.00 7,058,93 11,173.37 11,11 89,926.63 7,050.00 994.12 961.82 13.64 6,088,18 6,250.00 919,95 835,11 13.36 5,914,89 1,450.00 98.11 195.34 13.97 1,259,66 12,650.00 1,049.45 1,678.04 13.27 10,971,96 3-1D-2D1D D$:13 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPpRT [UNAUDITED AS OF: FEBRUARY 28TH, 2010 101-GENERAL FUND Public Safety 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES aUDGET PERIOD ACTUAL BUDGET BALANCE 101-9-2190-9109 Workers Camp 4,050,00 0.00 768.00 18.96 3,282.00 TOTAL Personal Services 132,050.00 9,120.06 15,611.68 11.82 116,438.32 Supplies 1D1-4-2190-9219 Operating Supplies 18,200.OD 5,676,11 7,536,78 41.91 10,663.22 TOTAL Supplies 18,200.00 5,676.11 7,536,78 41,91 10,663,22 Other Services & Charges 101--4~-2190--9361 Insurance 6, 50D, pD 0.00 1, 561.50 24.02 4, 938.50 101-4-219D-9369 Utilities 18,200.00 3,859.11 3,859.11 21.20 19,390,89 101-4-219D-4901 Bldg Repair/Maim Services 31,3D0.00 529.94 1,270.90 9.D6 30,029,10 TOTAL Other Services & Charges 56,DDD.00 9,389.05 6,691.51 11.95 99,3D8.49 TOTAL Public safety building 206,250.OD 19,185.22 29,839.97 14,97 176,910.03 Fire Administration Personal services 101-4-237.0-4107. Regular Pay 76,250.00 6,781.16 10,490.55 13.76 65,759.45 101-4-231D-9103 Part-time Pay 153,DOD.DO 8,886.83 17,1D2.49 11.18 135,897,51 101-4-2310-91D4 PERA 13,250.00 940.75 1,866.61 14,09 11.,383.39 1D1--9--231D~9105 FICA 10,1DD.D0 559.99 1,387.D9 13.73 8,712.91 101-4-231.0-4106 Other Retirement Contributions 30,000.00 0.00 0.00 O.DO 3D,OOD.OD 101-4-231D-4107 Medicare 3,5D0.00 202.$5 970.53 13.44 3,D29.97 101-4-2310-4108 Insurance 9,9D0.06 723.63 1,359.22 13.73 8,540.78 101--4--2310--4109 Workers Camp 15, 700 . DO D. 00 4, 561.OD 27.31 12,139 . DD TOTAL Person al Services 31.2,700.00 18,090.16 37,237.99 11.91 275,962,51 Supplies 101-9-231.0.9207. Office Supplies 1,2DD.00 D,Op 0.00 D.DO 1,200.DO 1.01.4--2310-4212 Fuels & Lubs 9, ODD , 00 639.83 669.20 7.44 $, 330.80 101-4-231.0-4217 Uniform Allowance 1,1DO.OD 897.51 897.51 81.59 202.99 101-4-2310-4219 Operating Supplies 22,700.00 2,839,43 2,839.93 12.51 19,860.57 TOTAL Suppli es 34,000.00 9,376,77 9,906.14 12,96 29,593.86 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,D50.00 O.OD D.DO 0.00 5,050.00 101-9-2310-4321 Telephone 3,OOD.00 163.32 272,99 9.1.0 2,727.01 101-~9--23104322 Postage 50D,00 0.00 O,DO O.DO 5DD.OD 101--4M2310-4331 Travel, Conferences ~ Schools 2p,OD0.D0 O.DO 0.00 0.00 2D,D06.60 101-4-2310-4359 Publishing 5DD.00 0.00 0.00 D.00 500,00 161-4-2310-4361 Insurance 18,80D.00 D.00 4,062,75 21,61 19,737,25 101-4-2316-4389 Utilities 15,15D.00 2,326.00 2,326.00 15.35 12,829.00 101-4-2310-4901 Bldg Repair/Maim Services 4,450.DD 2D4.94 209.99 9.61 4,245.06 101.4~231D--9409 Equip Repair/Maim Services 27,100.DD 995,92 495.42 1.83 26,604.58 101w9--231Dµ4433 Dues & Subscriptions 2,ODO,OD 27,50 387.50 7.9.38 1,612,50 101-~4M2310--4960 Equip Replacement Charge 22,3Dp,00 1,858,33 3,716.66 16.67 18,583.39 TOTAL Other Services & Charges 118,850.D0 5,075.51 11,466.26 9.65 107,383.79 3-10-2010 08.13 AM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CxTY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF. FEBRUARY 28TH, 2010 PAGE; 16 16.57% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Fire Administration 465,550.00 27,592.44 53,109,89 11.41 412,940.11 Fire Inspections -W_________-____ Personal Services 101-4-232D-91D1 Regular Pay 128,900.00 9,911.86 15,363.38 11.92 113,536.62 101-4-2320-9104 PERA 14,650.00 1,1D9.84 2,219.61 15.12 12,435.39 101~9~2320~9105 FICA 3,25D.D0 280.23 54$.28 16.87 2,701.72 1D1-4-2320-41D7 Medicare 1,9D4.OD 143.32 283.79 14.94 1,616,21 101-4-2320-9108 Insurance 14,65D.OD 1,199.91 2,299.82 15.70 12,350.18 TOTAL Personal Services 163,354.00 12,595.16 20,709.88 12.68 142,690.12 Supplies 101-9-232D-4201 Office Supplies 3,050.00 34.95 34.95 1.15 3,015.05 101~4~2320~4212 Fuels & Lubs 5,90D.D0 267.69 267.69 4.59 5,632.31 1D1-4-2320-4217 Uniform Allowance 8D0.40 4.00 D.OD D.DO 800.00 101-4-2320-4219 Operating Supplies 4,550.40 0.00 4.00 0.00 4,55D.D0 TOTAL Supplies 14,30D.D0 302.69 302.64 2.12 13,997.36 Othex Sexvices & Charges 101-4-2320-4321 Telephone 1,D5D.OD 138.32 199.03 18.48 855.97 101-4-2320-9322 Postage 154.00 O.DD D.OD O.OD 150.00 101~9~2320M9331 Travel, Conferences & Schools 3,200.00 21.DD 21.00 D.66 3,179.OD 101-4-2320-4359 Publishing 200.00 0.00 0.00 O.DO 200.D0 1D1-4-2320-9404 Equip Repair/Maint Services 1,850.04 72.78 72.78 3.93 1,777.22 101-9-23204433 Dues & Subscriptions 500.40 0.00 O.DO 0.04 50D.D0 TOTAL Other Services & Charges 6,950.00 232.10 287.81 4.19 6,562.19 TOTAL Fire Inspections Emergency Management Personal Services 101M4~2330~9101 Regular Pay 1D1-4-2330-4104 PERA 101-4-2330-9107 Medicare 101-4-233D-9108 Tnsurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 1D1-4-2330-4219 Operating Supplies TOTAL Supplies 184,600.00 13,129.9D 21,300.33 11.54 1&3,299.67 8,300.00 639.82 991.72 11.95 7,308,28 1,400.00 90.2D 1$0.44 12.89 1,219.6D 150.00 9.12 18,24 12.16 131.76 1,10D.D0 44.90 89,80 8.16 1,D1D.20 10,950.00 784.04 1,280.16 11.69 9,669.89 4DD.00 D.DO D.00 0.00 400.OD 8,540.00 D.OD 0.00 0.00 8,50D.OD 8,9DD.DD O.OD D.00 O.DO 8,9D0.00 3-1o-2o1a 08.13 AM 101-GENERAL P'UND Public Safety DEPARTMENTAL EXPENDTTURES PAGE ; 17 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s 0~' BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2330-9321 Telephone 1,500.00 116.15 115,15 7.74 1,383.85 101--9--2330-9322 Postage 100.00 0.00 0.00 O.OD 100.00 101-4-2330-4331 Travel, Conferences & Schools 1,850.00 0.00 0,00 0.00 1,850.04 101-9-2330-4359 Publishing 500.00 O.DO 0.00 O.DD 500.00 101--9~233D~-9389 Utilities 1x500.00 132,17 132.17 8.81 1.,367,83 101-4-2330-4909 Equip Repair/Maint Services 5x100.00 O.DO D.DD O.DD 5x100.00 101-4-2330-4933 Dues & Subscriptions 900.00 0.00 100,00 25.00 300.00 TOTAL Other Services & Charges 10,950.00 248.32 398.32 3.18 10,601.68 Capital Outlay TOTAL Emergency Management Building Safety Personal Services 101-4~-2410--4101 Regular Pay 101-4-291.0-4103 Part--time Pay 101-4-241.0-4104 PERA 101-9-2910-4105 FTCA 101-9-2410--9107 Medicare 101-4-2910-4108 Insurance 101-9-2410-9109 Woxkers Comp TOTAL Personal Services Supplies 101-4-2410-9201 Office Supplies 101-9-2910-9212 Fuels & Lubs 101--4--2910-9217 Uniform Allowance 101-9-2410-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101.-4-241Dw9321 Telephone 101-4-2910-9322 Postage 101-4-2910-9331 Travel, Conferences & Schools 101--9~-291D-4361 Tnsurance 101-~9--2910--4909 Equip Repair/Maim Services 101-4-2410--4933 Dues & Subscriptions 101-4-2910-4460 Equip Replacement Charge TOTAL Other Services & Charges 30,800.00 1,032.36 1,628.98 5.29 29,171.52 318,350.00 24,406.55 37,830.15 11.88 280,519.85 25,050.00 1,879.68 2,933,32 11.71 22,116.68 24,050.00 1,839.69 3,659.69 15.20 20,395.16 21x300.00 1x992.97 2,993.52 14.05 18,306.98 5,000.00 349.17 700.10 19.00 9,299.90 38,250.00 3,191.04 6,382.08 16.69 31,867.92 1,900.00 D.OD 279.00 19.57 1,126.00 433,400.00 33,159.10 54,768.01 12.69 378x631.99 2,500.00 0.00 0.00 O.OD 2,500.00 4,000.00 280.75 290.19 7.25 3,709.$1 700.00 0.00 0.00 O.OD 700.00 1,950.00 75.77 75.77 5.23 1,379.23 6,650.00 356.52 365.96 9.23 8,289.09 2x550.00 167,82 173.40 6.80 2,376,60 500.00 D . Do D . DD a . 00 5oD . o0 6,750.00 0.00 0.00 0.00 6,750.00 1,100.00 0.00 209.75 19.07 890.25 8,800.00 248.18 2,955.33 27.90 6,344.67 1,200.00 0.00 365.00 30.92 835.00 2,600.00 216.67 933.39 16.67 2x166.66 23,500.00 632,67 3,636.82 15..98 19x863.18 TOTAL Building Safety CTTY OF ELK RTVER REVENUE & EXPENSE REPORT (UNAUDTTED) AS 0~'; FEBRUARY 28TH, 2010 965,550.00 34x143.29 58x770.79 12.62 406,779.21 3-1o-2D~a 08;13 AM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDrTURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} A5 OF. FEBRUARY 28TH, 201D PAGE . ~. 8 16.670 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2440-4101 Regular Pay 35,400,00 2,689.24 4,259.09 12,02 31,195.91 101-4~2990~9109 PERA 2,500.00 188.24 918.50 16,74 2,081.50 101-4-2440-4105 FICA 2,200.00 125.14 281.56 12,80 1,918.44 101-4-294D-9107 Medicare 50D.00 29.26 65.89 13.17 439.16 1014--24g0~91D8 Insurance 5,650.OD 477,77 1,184.92 20,96 9,965.58 101-4-2940-9109 Workers Comp 400.00 0.00 95.00 23.75 305.00 TOTAL Personal Services 46,650.00 3,509,65 6,299.41 13.50 40,350,59 Supplies 101-4-2440-4201 Office Supplies 650.00 D.00 0.00 0,00 650.00 101-9-2440-4212 Fuels & Lubs 150.00 5.88 5.88 3.92 144.12 TOTAL Supplies $00.00 5.88 5.88 0.74 799,12 Other Services & Charges 101-4-2440-4321 Telephone 700,00 52.57 59.27 8.47 640.73 101--4--29409322 Postage 500.00 0. DO 0.00 D.00 500.00 101-4-2440-4331 Travel, Conferences & Schools 500.00 7,25 7.25 1.45 492.75 101-4-2490-4359 Publishing 250.OD 0.00 D.OD D.00 25D.DD 101-4-2490-4361 Insurance 250,00 0,00 46,75 18.70 203.25 101-~9--2990--4409 Contractual Services 1, 500.OD O. DD 0.00 0.00 1, 500. DO 101-4-2440-4433 Dues & Subscriptions 1,050.00 D.00 0,00 0.00 1,050.00 TOTAL other Services & Charges 9,750.00 59.82 113.27 2,38 4,636.73 TOTAL Environmental 52,200,00 3,575.35 6,418,56 12.30 95,781.49 TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-312D-4102 Overtime Pay 101-4-312D-4103 Part-time Pay 101-9--3120--4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare 101-9-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services 5,450,050.00 376,241,80 671,D39,86 12.31 4,779,D15.19 439,050.00 19,088,90 27,534.56 6,27 411,515.94 2,000.00 0.00 0.00 0.00 2,000.00 73,750.00 3,721.12 6,025.32 8.17 67,724.68 34,450,00 1,296.72 3,257.13 9.45 31,192,87 31,900.00 1,037,65 2,758.82 8,65 29,141.18 7,450,00 242,67 645.19 8.66 6,804.81 58,600.00 2,892,35 5,747.05 9.81 52,852.95 20,950.00 0.00 5,652,50 26.98 15,297.50 668,150.00 23,229.41 51,620,57 7.73 616,529.93 3-10-201D 08;13 AM CITY OF ELK RTVER PAGE; 19 REVENUE & EXPENSE REPORT UNAUDITED} AS OF: FEBRUARY 28TH, 2010 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES 16,67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-312D-4201 Office Supplies 101-4~312D-4212 Fuels & Lubs 1D1-4-312D-4219 Operating Supplies 101-4-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101--4-312D-~4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-9322 Postage 1D1--4-312D~4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Tnsurance 1D1-4-312D-4389 Utilities 101-4--3120--4401 Bldg Repair/Maim Services 101-4-3120-4404 Equip Repair/Maim Services 101-9-3120-4409 Contractual Services 101-4--312D-~4415 Equipment Rental 1D1--4 --312D--4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-312D-4437 Taxes & Licenses 1D1-4-312D-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101--9~312D--456D Equipment TOTAL Capital Outlay 6,4DO.OD O.DD O.DO D.DO 6,4o0.OD 74,000.00 14,642.27 14,429.36 19.50 59,570.64 195,OOO.D4 7,262.89 7,360.98 5.08 137,639,D2 29,95D.OD 0.00 0.00 0.04 29,950,DD 255,350,00 21,905.16 21,790.34 8.53 233,559,66 950.00 0.00 0.00 O.DO 950.00 8,950.00 407,16 525.69 5.87 8,924.31 2DO.OD O.DD 0.00 0.00 2DO.D0 3,ODD.OD D.00 D.00 0.00 3,D00.00 SaD.oo O.OD o.oo 0.00 Soo,Do 17,150.00 0.00 4,OD6.OD 23.36 13,144.DD 33,DDD.DO 4,222,31 4,222.31 12,79 28,777,69 8,500.00 1,610.14 1,610,14 18,94 6,889.86 5,000.00 O.DO D.00 D.DO 5,oD0,00 211,7DD.OD O.DO 0.00 0.00 211,7DD.00 5,500.OD 96.19 96,19 1.75 5,403,81 4,700.00 72.23 39.73 0.85 4,660.27 700,00 0.00 17&.25 25.18 523.75 5oD.DD 913.75 413.75 82.75 85.25 1D4,80D,D0 8,733,33 17,466.66 16.67 87,333,34 405,150.D0 15,555.11 28,556.72 7,05 376,593.28 8,3oD.D0 0.00 0,00 O.DO 8,300,00 8,300.00 O.OD 0,00 D.DO 8,30D.D0 TOTAL Street Maintenance Snow Removal Personal Services 101-9-3130.4101 Regular Pay 101-4-3130-4102 Overtime Pay 1D1-4-313D-41D9 PERA 101-4-3130-4105 FICA 1D1--4--3130--4107 Medicare 101-4-3130-4108 insurance 1D1-4-3130-4109 Workers Comp TOTAL Personal Services 1, 336, 95D . 00 60, 689.68 101, 967.53 7 , 63 1, 239, 982 , 37 114,900.00 34,103.49 43,660,90 38.00 71,239..10 3,DD0.00 113,99 949,39 31.48 2,055.61 8,900.00 2,395.21 4,505,45 50.62 4,394,55 8,250,00 1,986.93 3,832,96 96.46 4,417,04 1,9DD.D0 964,56 896.40 47,18 1,003,60 16,250.00 3,204,31 7,674.79 47,23 8,575,21 7,350,00 O.OD 1,603.25 21.81 5,796.75 160,550.00 42,267.99 63,118,14 39.31 97,431,86 3-1D-2D10 ae;13 AM 101--GENERAL FUND Public Works DEPARTMENTAL EXPENDTTURES PAGE: 20 16.67 °s dE YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 5~zpplies 101--4--31304219 Operating Supplies 86, 000.00 44, 832 , 41 49, 832.41 52.13 41,167.59 TOTAL Supplies 86,000.00 44,832,41 44,832,41 52.13 41,167,59 Capital outlay TOTAL Snaw Removal Equipment Services Personal Services 101--4W315D-91D1 Regular Pay 101-4-3150--9102 Overtime Pay 101-4-3150-4104 PERA 101-9-315D-41D5 FTCA 101-~4--315D--4107 Medicare 101-9-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services Supplies 1D1-4-315D-4219 Operating Supplies 101--9--3150-9221 Equipment Parts TOTAL Supplies Other Services & Charges 101--4-315D-4404 Equip Repair/Maim Services 101.-4--3150-9417 Uniform Rental TOTAL Other Services & Charges 296,550.00 $7,100.4D 1D7,95D.55 43.78 138,599,45 162,75D,00 9,807.10 16,693.10 10.26 146,056.9D 0,00 D.00 20.69 0,00 ( 20.69} 11,400.00 686.99 1,465.56 12.86 9,933.94 10!100.00 559,31 1,208.68 11,97 8,891,32 2,350.00 130.81 282.68 12.03 2,067,32 29,150.00 1,6D2,91 2,775.09 11.49 21,374,96 &,050.00 0.00 1,594.50 26.36 4,455.50 216,800.00 12,786,62 24,041,25 11.09 192,758.75 14,500.D0 1,072,60 1,072,60 7,40 13,427.40 11,700,00 0.00 0.00 D.DO 11,7DD.OD 26,200,00 1,072,60 1,072,&0 9.09 25,127,40 SDO,D0 0.00 D.00 0,00 500.00 2,sao.oD 292.96 292.96 10.96 2,507,09 3,300.00 292.96 292.96 8,88 3,007,09 TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-33 QO-4104 PERA 101-4-33nD-9105 FTCA 101--9-330-9107 Medicare 101--9~-33Q0-910$ Insurance 101-4-33009109 Workers Comp TDTAL Personal Services CTTY dF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED} AS dF: FEBRUARY 28TH, 2010 245,300,00 14,152,1$ 25,406.61 10,32 220,893.19 86,850.00 0,00 0.00 D.00 86,850.00 6,100.00 D.00 0.00 O.DO 6,100.00 5,400,00 0,00 O.OD 0,00 5,400,00 1,250,00 O.OD 0.00 0,00 1,250.00 16,350.00 0.00 0,00 O,OD 16,350.00 200.00 0,00 105,25 52,63 94,75 116,150.00 0,00 105.25 0.09 116,044,75 3-10-2010 48;13 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; FEaRUARY 28TH, 2D10 141-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES 16.670 OF YEAR CDMP. CURRENT CURRENT YEAR TO DATE OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101--9--3300--9201 Office Supplies 101-9-3300-9212 Fuels & Lubs 101-4-330D-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101--93300-9303 Engineering Fees 101-9-3300-9319 Other Pra£essional Services 101-9-3300-9321 Telephone 101--9--3300--9322 Postage 101-4-3300-9331 Travel, Conferences & Schools 101-9-3300-9361 Insurance 161-9-330D--9904 Equip Repair/Maint Services 101--9-~3300--996D Equip Replacement Charge TOTAL Other Services & Charges 1,DOO.OD 0.00 0.00 4.D0 1,DDD.DD 1,240.DD D.DO D.00 0.00 1,200.00 8,800.00 1,754.D0 1,750.D0 19.89 7,D50.00 11,0OO.OD 1,750.00 1,75D.44 15.91 9,25D.04 20,DOD.DO 2,855.31 2,865.31 19.33 17,139.69 22,500.00 0.00 0.00 0.00 22,500.00 1,150.00 1.00 2.52 0.22 1,197,98 200.00 D.DO 0.00 0.00 20D.OD 5,850.00 0.00 0.00 0.00 5,850.00 25D.00 D.00 46.75 18.70 203.25 50D.D0 O.DD 0.00 0.00 500.00 750,00 52.50 125.00 16.67 625.00 51,200.00 2,928.81 3,039.58 5.94 98,150.92 TOTAL Engineering 178,35D.00 9,578.81 9,899.$3 2.74 173,955,17 TOTAL Public Works Parks Department Personal Services 101-4-511.0-9101 Regular Pay 101-9-5110-4103 Part-time Pay 101-9-5110~91D4 PERA 101--4w511D--9105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-9-5110-4109 Workers Comp TOTAL Personal Services Supplies 101-9-511D-9212 Fuels & Lubs 1D1-4-5110-9217 Uniform Allowance 101--4--5110--4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-511D-4321 Telephone 101-95110-9322 Postage 101--9--511D~-9331 Travel, Conferences ~ Schools 101--4~-5110--4361 Insurance 101-9-5110--4389 Utilities 101--9--5110-4401 Bldg Repair/Maint Services 2,008,150.00 166,621.07 290,219.82 11.96 1,767,930.18 392,150.00 25,538.33 91,391.18 12.10 300,758.82 39,650.00 0.00 0.00 O.DD 39,65Q.D0 29,650.04 1,787.69 3,597.07 14.59 21,052.93 23,75D.D0 1,931,69 2,912.99 12.26 2Q,837.51 5,550.00 339.81 681.11 12.27 9,$6$.89 93,550.00 3,583.14 6,898.91 15.89 36,651.49 8,200.00 O.DO 2,029.00 24.79 6,171.00 487,500.00 32,575.66 57,5D9.76 11.8D 929,990.29 34,550.00 2,928.49 2,955,76 8.56 31,599,29 3,15D.00 79.98 79.98 2.54 3,470.02 73,80D.D0 8,DD8.39 8,113.13 10.99 65,68$.87 111,500.00 11,D16.86 11,148.87 10.00 100,351.13 3,90D.D0 331.76 351.50 9.27 3,538,50 1DO.DD a.OD D.aD D.DO 1oo.DD 3,350.00 10.2D 10.20 0.34 3,339.80 25,850.04 D.QD 6,160.25 23.83 19,689.75 27,24D.44 394.69 394.69 1.99 26,809.31 9,004.44 4.D4 D.00 O.DO 4,000.00 3w10--2010 08;13 AM CITY OF ELK RIVER PAGE; 22 REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: FEBRUARY 2$'~'H, 2010 101--GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 1&.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OE BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1D1-4-511.0-9404 Equip Repair/Maint Services 11,700.00 D.00 O.DD O.DD 11,700.OD 101-4--5110-9409 Contractual Services 7,1D0.00 132.OD 132,00 1.86 6,96$.DO 101-45110--9415 Equipment Rental 24, 500 , 00 448.92 825.7.2 3.37 23, 674 , 88 101-4-511.0-9460 Equip Replacement Charge 6D,45D.00 5,037.50 1D,075.DD 16.67 50,375.OD TOTAL Other Services & Charges 168,150.00 6,351.07 17,954.76 10.68 15D,195.24 TOTAL Parks Department Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 101--4--5210--4103 Part-time Pay 101-4-521.0-4109 PERA 101-4-521.0-4105 FICA 1D1-4-5210-91D7 Medicare 101-4~-52104108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5214-4321 Telephone 101-4-5210-4322 Postage 101-4-5210-4331 Travel, Conferences & Schools 7.07.--4--5210--4349 Advertising/Marketing 101-4-5210--4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Mai.nt Services 101-4-5210--4409 Equip Repair/Maint Services 1019--52104433 Dues & Subscriptions TOTAL Other Services & Charges 767,150.00 50,043.59 86,513.39 11,29 6$0,536.61 338,400.00 25,29&.55 39,297,18 11,61 299,102.82 20,850.00 1,604,00 2,486.20 11.92 18,363.80 25,150.00 1,883.01 3,743.37 19.88 21,406,63 22,300.00 1,573.72 3,159.29 14,17 19,140.71 5,2DO.OD 368.03 738.83 14.21 4,461.17 38,350.00 3,125.36 6,233.43 15.25 32,116.57 3,4D0.00 0.00 844.75 24.85 2,555.25 453,65D.00 33,$50.67 56,503.05 12.46 397,146.95 13,700.40 834,04 1,206.17 8.80 12,493.83 13,700.00 834.04 1,206.7.7 8.80 12,993.83 4,800.00 269.89 413.52 8.62 4,385,48 b,DOD.00 0.00 0.00 0.00 6,000.00 b, 950.00 302,88 328,88 9,73 6,621,12 26,400.00 539.72 539.72 2.04 25,860.28 1,550.00 0,00 339,25 21.56 1,215.75 7,800.00 1,605.47 1,605.47 20.58 6,194.53 12,850.00 880,76 1,795,49 13.58 11,104.51 7,95D.04 0.00 480.94 6.05 7,469.06 1,650,04 30.00 30.00 1.82 1,620.00 75,950.00 3,623.72 5,478,27 7.21 70,971.73 TOTAL Parks & Rec Admin Recreation Programs Personal Services 101--4--5224-4102 Overtime Pay 101-4-522D-4103 Part--time Pay 101-4-5220-4104 PERA 101-4-5220-41D5 FICA 101-4-5220-4147 Medicare TOTAL Personal Services 543,300.00 38,308,43 63,187,99 11,63 98D,112.51 0,00 O.DO 45.DD 0,00 ( 45.00} 80,000.00 2,819.14 9,29&,58 5,37 75,703.42 2,200.00 109.35 192.67 8.76 2,007,33 4,250.00 179,49 397,13 8.17 3,902,87 1,150,00 90,83 81.20 7.06 1,068.80 87,60D.D0 3,138,81 4,962,58 5.67 82,637,92 3-1o-zD1a °8:13 AM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF EJ~K RIVER REVENUE & EXPENSE REPORT UNAUDITED} AS OF: FEBRUARY 28TH, 2010 PAGE; 23 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PER10D ACTUAL BUDGET BALANCE Supplies 101-4-5220-9219 Operating Supplies 25,550.00 194.13 194.13 0.76 25,355.87 TOTAL Supplies 25,554.00 194.13 194.13 0.76 25,355.87 Other Services & Charges 101--4--522 04404 Equip Repair/Maim Services 400,00 407.72 407.72 101.93 { 7,72} 101-4-522D-4409 Contractual Services 54,200.00 49.00 3,129.00 5.76 51,076.00 101-4-5220-4412 Building Rent 2,500,00 D.DO 0.00 0.00 2,500.DD 1D1--4--522DW4938 Credit Gard Fees 3,3D0.00 117.28 117.28 3.55 3,182.72 TOTAL Other Services & Charges 60,400.00 574.00 3,699.00 6.09 56,751.00 TOTAL Recreation Programs 173,550,00 3,906.94 8,805.71 5.07 164,749.29 Concessions Personal Services 101-~4--523D-4103 Part-time Pay 3,650.00 33D.00 584.75 16.02 3,065.25 101--4~-5230--4104 PERA 150 , 00 23.1D 57 , 27 38.18 92.73 101-4-5230-4105 FICA 250,00 20.46 58.34 23.34 191.66 101-4-5230-4107 Medicare 50.00 4,79 13.65 27.30 36.35 TOTAL Personal Services 9,100.00 378.35 714.01 17.41 3,385.99 Supplies 101-4-5230-4219 Operating Supplies 1,450.00 0.00 0.00 0.00 1,450.00 1D1~-4--523D-4259 Other Merchandise For Resale 8,20D,D0 214.40 214.40 2,61 7,985.60 TOTAL Supplies 9,650.00 214.40 214.40 2.22 9,435.60 Other Services & Charges 101-4-5230-9401 Bldg Repair/Maim Services 100.00 O.OD O.OD O.DO 100.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.D0 TOTAL Concessions 13,850,00 592.75 928,41 6.70 12,921.59 Sr Citizen Programs Personal Services 101--4-5510-4101 Regular Pay 56, 3D0. DO 4, 293.70 6, 630.98 11.78 49, 669.02 101-4-5510-4103 Part--time Pay 59,204.00 4,597.75 7,1$1.09 12,13 52,018,91 101-4-5510-4104 PERA 8,100.00 622.90 1,235.34 15.25 6,864.b6 101-4-5510-4105 FICA 7,200.00 513.9D 1,029.20 14.29 6,170.80 101-4-5510-4107 Medicare 1,700,00 120.20 240.73 14.16 1,459.27 101--4--5510-4108 Insurance 13, OD0.00 1, 08D.10 2,160.20 16.62 10, 839.80 101--4--5510--41D9 Workers Comp 400.00 0.00 108.75 27.19 291.25 TOTAL Personal Services 145,90D.D0 11,228.05 18,586.29 12.74 127,313.71 3-10-2010 08:13 AM 101-GENERAL FUND Culture & Recreatian DEPARTMENTAL EXPENDITURES PAGE : 2 9 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101--4--5510-4321 Telephone 101-4-55109322 Postage 101-4-5510-9331 Travel, Conferences & Schaals 101--9--551D-9361 Insurance 101-4-553.0--9389 Utilities 101-4-5510-9401 Bldg Repair/Maint Services 101-4-551D-4409 Contractual Services 101--9--5510--4433 Dues & Subscriptions TOTAL Other Services & Charges 16,1DD.00 1,112.79 593,93 3.38 15,556.57 16,100.00 1,112.79 593.43 3.38 15,556.57 2,400.D0 212.04 933.13 18.05 1,966.87 2,100.0D O.OD 500.00 23.81 1,6DO.0D 2,400.00 148.00 198.00 6.17 2,252.D0 1,650.00 0.00 373.25 22.62 1,276,75 11,800.D0 1,172.48 1,172.48 9.99 10,627.52 11,5DO.DD 835.43 1,365.42 11.87 10,134.58 8,200.00 39.00 170.00 2.07 8,030.D0 1,204.00 27.50 42.50 3.54 1,157.50 91,250.D0 2,439.45 9,204.78 10.19 37,045.22 TOTAL Sr Citizen Programs 203,250.00 7.4,775.29 23,339.50 11.98 179,915.50 TOTAL Culture & Recreation 1,701,100.00 107,627.00 182,869.50 10.75 1,518,230.50 Economic Development Personal Services 101-4-621D-4101 Regular Pay O.OD 0.00 10,237.90 0.00 { 10,237.40} 101-4--6210-9103 Part-time Pay 0,00 0.00 1,05D.32 0,00 { 1,050.32} 101-9--621o--41D4 PERA o. oD 12. sD 73$ . 72 0. aD { 738.72} 101-9-6210M9105 FICA 0.00 0,00 655.91 0.00 { 655.41} 101-4-621.0-9107 Medicare D.00 O.OD 153.28 0.D0 { 153,28} 101-4-6210-4108 Insurance 0.00 0.04 91$.01 0.00 { 918.01} 101--4--621D-4109 Workers Comp 0,00 ( 165.75} 0.00 D.DO D.DO TOTAL Personal Services 0.00 [ 152.95} 13,753.19 D.00 ( 13,753.14} Other Services & Charges 101--46210-4331 Travel, Conferences & Schools D.OD { 441.OD} 4.00 D.00 0.00 101-4~-6210--9361 Insurance 0.00 { 702.75} 0,00 0.00 0.00 7.01-4-6210-4490 Miscellaneous O.OD 196.87 173,24 D.OD { 173.24} TOTAL Other Services & Charges O.DO ( 996.88) 173.24 0.00 { 173.24) TOTAL Economic Development D.OD ( 1,099.83) 13,926.38 0.00 { 13,926.38} Energy City CTTY OF ELK RTVER REVENUE & EXPENSE REPORT {UNAUDITED} AS OF. FEBRUARY 28TH, 201D 3-10-~2D10 08;13 AM 101-GENERAL FUND Economic Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT {UNAUDITED} AS OE': FEBRUARY 28TH, 2010 PAGE; 25 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAI, BUDGET BALANCE Personal services 101-4-6220-4101 Regular Pay 24,55D.00 1,874,28 2,931.23 11,99 21,618,77 101-4-6220-4104 PERA 1,7D4.00 131.20 267.22 15.72 1,432,78 101--4--6220--4105 FICA 1, 504.00 89.44 183.66 12, 29 1, 316.39 101-4-6220-4107 Medicare 350.00 20.92 42.96 12.27 307.D4 101-4-6220-41D8 Insurance 3,250.04 263.51 571.12 17,57 2,678.88 TOTAL Personal Services 31,350.D0 2,379.35 3,996.19 12.75 27,353.81 Other Services & Charges 101w4w622D--4319 Other Professional Services 5,000.DO 50.99 50.99 1.02 4,949.D1 101-4-622D-4331 Travel, Conferences & Schools 12,500.D0 { 7,474.75}{ 8,649.75} 69.20- 21,149,75 1D1-4-6220-4359 Publishing 2,500.00 421.45 421.95 16.86 2,D78.55 TOTAL Other Services & Charges 20,400.00 { 7,002.31}{ 8,177.31} 40.89- 28,177.31 TOTAL Energy City 51,350.40 ( 4,622.96)( 4,181,12} 8.14- 55,531.12 TOTAL Economic Development 51,350.00 ( 5,722.79} 9,745.26 18.98 41,604.74 Transfers Out Transfers Out 101-~4--7000--4723 Transfer--Ice Arena 126, 600.00 O.DO 0.00 0.00 126, 600.00 101-4-700D-4724 Transfer ~- Pinewood 37,450,00 0.00 0.00 0.00 37,450.00 TOTAL Transfers Out 164,050.00 0.00 O.OD D.OD 164,D5D.00 TOTAL Transfers Out 164,050.00 D.00 0.00 0.00 164,D50.00 TOTAL General 164,054.00 0,00 O.OD 0.40 164,454.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER} EXPENDITURES 12,049,800.00 -_W--~-_~__~- ~ { 325,DOO.D4}{ 807,011.23 -.~.._-_~.._____-- 693,15$.16}( 1,404,719.02 ------------- 1,226,627.$$} 11.66 10,640,080.98 ---.._-__ ~--...-.-.--~~-_- 941!627.88 3-10-20 TO 08;13 AM CxTY OF ELK RIVER PAGE; 1 REVENUE & EXPENSE REPORT ,UNAUDITED) AS OF; FEDRUARY 28TH, 2010 221-ICE ARENA FINANCIAL SUMMARY 16,67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Tce Arena 656,050.00 100,799.65 116,829.52 17.81 539,225.48 Hockey 60,OD0.00 15,60D.00 18,060.00 30.10 91,990.00 Skating 75,650.00 9,191.20 12,636,20 16,70 63,013.80 Concessions 67,750.00 1.3,321.06 27,075.31 39.96 40,679,69 TOTAL REVENUES 859,450.00 138,911.91 174,596.03 2D.31 684,853.97 EXPENDITURE SUMMARY Culture & Recreation Tce Arena 749,900.00 55,D67.17 73,588.53 9.88 671,311.47 Hockey 28,200.00 113.94 113.94 0.40 28,0$6.06 Skating 35,500.00 2,309.35 2,651.64 7.47 32,848.36 Arena Concessions 50,850.00 8,281.61 10,232,93 20.12 40,617,07 TOTAL Culture & Recreation 859,45D.00 65,767,07 86,5$7,04 10.07 772,862.96 TOTAL EXPENDITURES 859,450.00 65,767,07 86,587.04 10.07 772,862.96 REVENUES OVER/(UNDER} EXPENDITURES D.DD 73!144.$9 88,008.99 ( 88,008.99 3-10-2010 08:1.3 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2D10 221-ICE ARENA REVENUES 1&.670 OF YEAR COM£', CURRENT CURRENT YEAR Tp DATE o pF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221--30000--3464 Ice Rental 221-3-D000-3465 Admissions 221-3-ODOD-34&6 Dry Floor Events 221--3~DOOOW3968 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-DD00-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-30000-3626 Contributions 221--3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 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 Othex Revenue `TOTAL Hockey Skating Charges for Services 221-3-5420-3461. Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges far Services 449,800,00 78,578.97 8D, 641,97 17.93 369,158,03 22,550.DD 14,089,30 25,146.30 111,51 ( 2,596,30) 12,OD0.00 1,249,00 1,299.00 10.91 10,751.DD 4,800.00 756.D0 1,730,00 36.D4 3,070.00 2,600.00 D.DO O,OD O.OD 2,600,00 17,ODO,DO 0.00 0.00 0.00 17,DD0.00 508,750,D0 94,668.27 108,7&7.27 21,38 399,982.73 18,700,D0 1,35&.15 3,033.27 16.22 15,66&,73 0.00 9,619,D0 9,619.00 O,DD ( 4,619,00) 2,OOD,00 156.23 404.98 20,25 1,595,02 20,700,00 6,131.38 8,057.25 38.92 12,692.75 126, 6DO,D0 O,DD D.00 O.OD 126, 600.00 126,6D0.04 0.00 0.00 0.00 126,&00.00 656,D50,D0 1DD,799.65 116,824,52 17.81 539,225,98 60,ODO.OD 15,600.00 18,06D.00 30,10 91,940.00 60,000,00 15,600.OD 18,D6D,00 30.1D 41,940.D0 60,000,00 15,&00.00 18,060.DD 30,10 41,940,00 70,OOD,00 9,191,20 12,&36.20 18,05 57,363.80 3,50D.00 0,00 0,00 0,00 3,500.00 73,5DD.D0 9,191..20 12,636.20 17.19 60,863,8D 3-10-2010 08:13 AM CTTY OF ELK RTVER PAGE; 3 REVENUE & EXPENSE REPORT (UNAUDITED} AS OE; FEBRUARY 28TH, 2010 221-TCE ARENA REVENUES 16.67 o OF YEAR CAMP. CURRENT CURRENT YEAR TO DATE Q OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE Other Revenue 221-3-542D-3629 Miscellaneous Revenue TOTAL Other Revenue TOTAL Skating Concessions Charges for Services 221--3--5430~34G7 Concessions TOTAL Charges for Services TOTAL Concessions 2,150.00 0.00 D.00 D.00 2,150.00 2,150.DD D.00 0.00 0.00 2,150.00 75,650.00 9,191.20 12,636.20 16.70 63,013.80 67,75D.00 13,321.D6 27,D75.31 39.96 90,674.69 67,750.00 13,321,06 27,075.31 39.96 40,674.69 67,75D.DD 13!321.06 27,D75.31 39.96 40,674.69 TOTAL REVENUE $59,45D.00 138,911.91 174,596.03 20.31 684,$53.97 3~10--201D 0$:13 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2010 221--rCE ARENA DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-9-5900-9101 Regular Pay 221-9--5900-9102 Overtime Pay 221-9-5900-9103 Part-time Pay 221-9-5900-4104 PERA 221-9--540D~9105 FICA 221-4-5400-4107 Medicare 221-9-5400-9108 Insurance 221--9-~5400~9109 Workers Corp TOTAL Personal. Services Supplies 221--9-~590D~9212 Fuels & Lubs 221-4-5900-9217 Uniform A1lawance 221-4-5400-9219 Operating Supplies 221-9~-59D0~9255 5ott Drinks/Misc 221--4--5400-4259 Qther Merchandise For Resale TOTAL Supplies Other Services & Charges 221-9-5900-4321 Telephone 221-4-5900-4322 Postage 221-9-5400-4331 Travel, Conferences & Schools 221--9-~54D0--4359 Publishing 221-4--5400-4361 insurance 221-4-5400-4389 Utilities 221-4-5400-4901 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221--4--54004415 Equipment Rental 221-4-5900-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay Transfers Out 221-9-5940-9730 Transfer-Debt Service TOTAL Transfers Out 198,700.00 11,767,01 17,443,87 11,73 131,256.13 0,00 58,25 93.85 0,00 ( 93.85) 73,900.00 8,980,60 19,058,95 19.02 59,891.05 11,750.00 1,084.58 2,168,34 18.45 9,581.65 13,800,00 1,276.93 2,479.17 17,97 11,320.83 3,250,40 298.62 579.81 17.89 2,670,19 17,950.00 1,594.01 3,188,02 18.27 14,261.98 4,750.00 0,00 1,299.00 25.29 3,501,00 273,600.00 25,060.00 41,261,01 15.08 232,338.99 350,00 D.DO 0.00 0.00 350,00 1,000,00 D.OD 0.00 0.00 1,000.00 41,450.00 6,399.09 6,498.83 15,56 35,001.17 9,000.00 1,859.04 1,859.04 20.66 7,190.96 900.00 O.DO 0.00 D.DD 900,00 52,700.00 8,203.13 8,307.87 15.76 44,392.13 3,300.00 297.79 389,85 11,81 2,910.15 600.00 0.00 0,00 0,00 600.00 1,050,00 O.OD D.DO O.OD 1,050.00 2,800.00 0.00 0.00 0.00 2,800,00 8,700.00 0,00 1,933.50 22.22 6,766,50 175,900.00 17,023,01 17,023,01 9.68 158,876,99 20,200.00 9,083.81 4,083,81 20.22 16,116.19 1,100.00 60,00 60.00 5.95 1,090.00 9,b00.00 391.98 391.98 7.93 9.258.02 218,700.00 21,809.09 24,019.65 10.98 194,680.35 199,900.00 0.00 0.00 0.00 199,900,00 199,900,00 0.00 O.D0 0.00 199,900.00 TOTAI, Ice Arena 794,900.00 55,057,17 73,588,53 9.88 671,311.47 3-10-201.0 08:13 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY Off' ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED AS OF: FEaRUARY 28TH, 2010 PAGE; 5 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-9-5410-4103 Part-time Pay 3,600.Op 0.00 0.00 0.00 3,600.00 221--4-~541p--4105 FICA 250.00 0.00 0, QO 0.00 250 . DO 221-4-5910-4107 Medicare 50.00 0,00 0.00 0.00 50.00 TOTAL Personal Services 3,900.00 0.00 0.00 0.00 3,900.00 Supplies 221-4-5410-4219 Operating Supplies 15,250.00 0.00 0.00 0.00 15,250.00 TOTAL Supplies 15,250.p0 0.00 0.00 0.00 15,250.00 Other Services & Charges 221-4-5410-9322 Postage 50.Op 0.00 0.00 0.00 50.00 221--9~-541p-~9359 Publishing 500.00 O.OD 0.00 0.00 500.00 221-4-5410-9409 Contractual Services 6,300.00 0.00 0.00 0.00 6,300.00 221-4-541.0-443$ Credit Card Fees 2,200.00 113.94 113,94 5.18 2,086.06 TOTAL Other Services & Charges 9,050.00 113.94 113.94 1,26 8,936,05 TOTAL Hockey Skating Personal Services 221-4~-5420.4103 Part-time Pay 221-4-5420-4104 PERA 221-4-5420-9105 FICA 221-9-5420-9107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5920-4359 Publishing 221-4-5420-4909 Contractual Services 221--4--5420--4438 Credit Card Fees TOTAT~ Other Services & Charges 28,200.00 113.94 113.94 0.40 28,086.06 20,000.00 1,057.78 1,354,97 6.77 18,645.03 1,000.00 24.57 36.19 3.62 9&3.81 ~ 7~n nn ~~, ~n ati an ~ ~~ 1 1 ~'~ 1 F 6,9p0.00 985.25 985.25 19.28 5,914.75 6,900.00 985.25 985.25 19.28 5,914.75 500.00 0.00 4.00 0,00 500.00 2,550.00 0.00 0.00 0.00 2,550.00 3,000.00 155.76 155.76 5.19 2,$44.24 6,050.00 155.7fi 155.76 2.57 5,894.24 TOTAL Skating 35,500.00 2,304.35 2,651.64 7,97 32,898,36 3-10-2010 08:13 AM CITY OF ELK RzVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS 0~'; ~"EBRUARY 28TH, 2010 227.-zCE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES 16.67fl OE YEAR COMP. CURRENT CURRENT YEAR TO DATE o 0~' BUDGET SUDGET PERZOD ACTUAL BUDGET BAIANCE Arena Concessions Personal Services 221-4-5930-9103 Part-time Pay 2D, 900,00 221--9-5930-9109 PERA 20D.D0 221-4-5430-4105 FICA 1,300.00 221-4-5430-4107 Medicare 300.00 TOTAL Personal Services 22,700.00 Supplies 221-4-5430-4219 Operating Supplies 7,15D.00 221--9--593D--4259 Other Merchandise For Resale 21, ODD, 00 TOTAL Supplies 28,150.00 2,735.85 9,459,10 21.31 16,995.90 70,35 7.19,13 59.57 80.87 7.69.62 318.97 29.54 981,03 39.69 79,63 24,88 225,37 3,015,51 4,966.83 21.88 17,733.7.7 15.56 15.56 0,22 7,134,49 5,250,59 5,250,54 25.00 15,749,96 5,266.10 5,266.10 18.71 22,883.9D TOTAL Arena Concessions 5D, 850,00 8,281,61 10,232.93 20,12 40,617,07 TOTAL Culture & Recreation 859,450,00 65,767.07 85,587,04 7.0.07 772,862.96 TOTAL EXPENDITURES REVENUES OVER/UNDER} EXPENDZTURES 859,950,00 0.00 65,767.07 73,199.89 86,587,09 10,07 88,008,99 ( 772,862,96 88,D08,99} 3-14-20.0 08;13 AM CITY OF ELK RTVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF. FEBRUARY 2$TH, 2010 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Gold Course TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Gall Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER} EXPENI]ITURES 238,950.00 0.00 238,950.00 0.00 0.00 0.00 238,950.00 0.00 D.00 238,950.OD 238,950.00 7,131,52 15,285.38 6.91 223,169.62 238,950.00 7,131,52 15,285.38 6.91 223,169.62 238,95D.00 7,131,52 15,285.38 6.91 223,164.62 0.00 f 7,131.52}( 15,285.38} 7.5,285.38 3-10-2010 08:13 AM CITY OF E~,K RIVER PAGE; 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF; FEBRUARY 28TH, 2010 222-PINEWOOD GOZF COURSE REVENUES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERrOD ACTUAD BUDGET BAT~ANCE Pinewood Golf Course Charges for Services 222-3~-0000-~3961 Recreation Fees 222-3-0000-3467 Concessions 222-3--0000-3469 Qther Sales 222--3-0000.3976 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Galf Cart Rental. 222--3-~oD00--3979 Tournaments 222--3-ODOOw3482 Advertising fee TOTAZ Charges for Services Sales Transfers Tn 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In 22,000.00 0.00 O.OD O.DD 22,000.00 19,000.00 0.00 0.00 D.DO 19,000.00 5,000.00 0.00 0.00 0.00 5,000.00 115,000.00 O.DO 0.00 O.DD 115,000.00 14,000.00 0.00 0.00 0.00 19,000.00 18,500.00 0.00 O.DO 0.00 18,500.00 7,000.00 a.oD o.oo D.oD 7,oDD.ao 500.00 O.DO 0.00 0.00 500.00 201,000.00 0.00 0.00 0.00 201,000.00 37,950.00 0.00 0.00 O.DO 37,450.00 37,450.00 0.00 0.00 0,04 37,450.00 TOTAL Pinewood Golf Course 238,450.00 0.00 0.00 0.00 238,450.00 TOTAL REVENUE zzs,450.0o D.oD D.oO D.DO 238,950.00 -------------- ------------- ------------- ------- ------------- 3-10-2D10 08;13 AM CITY OF ELK RTVER PAGE; 3 REVENUE & EXPENSE REPORT (UNAUDITED} AS OF: FEBRUARY 28TH, 2010 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDTTURES Golf Course Personal Services 16.67% OF YEAR COMP, CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERTOD ACTUAL BUDGET BALANCE 222-95300-9101 Regular Pay 91,55D.00 5,173.51 7,584,28 8.28 83,965.72 222-4-530 09103 Part time Pay 28,900,00 3D.DD 49,68 0.17 28,850.32 222-4-5300-9104 PERA 8,450.00 364,25 676.76 8,01 7,773.24 222- 45300-9105 FTCA 7,450.00 316,91 592,16 7,95 6,857,89 2224-5300~41D7 Medicare 1,750,00 74,01 138,50 7.91 1,611.50 222-4-5300-4108 Insurance 11,050.00 449,01 898.D2 $.13 10,151,98 222-4-5300-9109 Workers Comp 1,250.OD 0.00 311.25 24.90 938.75 TOTAL Personal Services 150,900.00 6,4D7.19 10,250.65 6.82 140,149.35 Supplies 222-9-5300-4212 Fuels & Lubs 5,000,00 D.DO 0,00 0,00 5,000.00 222M4~5300~4217 Uniform Allowance 500,00 0.00 0.00 0.00 50D,OD 222-9-5300-4219 Operating Supplies 25,600.00 272.06 552.95 2.16 25,D47.D5 222-4-530D-9259 Other Merchandise For Resale 14,DOO,DD 0.40 D,OD O,DO 14,000,00 TOTAL Supplies 45,100.00 272.D6 552.95 1.23 44,597.05 Other Services & Charges 222-4-5300-4321 Telephone 3,100.00 233.59 379,05 12.23 2,720,95 222~4~5300-4331 Travel, Conferences & Schools 500.D0 127.96 127,96 25,59 372,09 222-4-530 04399 Advertising/Marketing 1,000.DO O,DD 0.00 D.OD 1,ODD.00 222-4-5300-4361 Insurance 11,850,00 D,DO 2,581.00 21,78 9,269.00 222-4-53D0-4389 Utilities 7,150,00 66.26 56,26 0,93 7,083.74 222-4T5300-9901 Bldg Repair/Maint Services 1,DDD.OD 20.09 20.09 2.00 979.96 222-4-5300ry49D9 Equip Repair/Maint Services 2,50D.00 0.00 905,00 36.20 1,595.D0 222-4-5300-4915 Equipment Rental 2,DD4.00 0.04 0.00 0,00 2,ODO.DO 222-9-5300-4437 Taxes & Licenses 850,00 O.DO 398,40 45,82 452.00 222-9-5300-4438 Credit Card Fees 4,5DD,OD 4.47 4,47 0,14 4,495.53 TOTAL Other Services & Charges 34,450.00 952,27 4,4$1,78 13.01 29,968,22 Debt Service 222-4-530D-9601 Principal 8,50D.00 O.DD 0,00 0.00 8,50D.D0 TOTAL Debt Service 8,540,00 D.DO 0.00 O.DO 8,500,00 TOTAL Golf Course 238,950,00 7,131,52 15,285,38 6,41 223,164.62 TOTAL Culture & Recreation 238,450.00 7,131.52 15,2$5.38 5.41 223,164,62 TOTAL EXPENDITURES REVENUES OVER/{UNDER} EXPENDITURES 238,450.00 O.OD ( 7,131,52 7,131,52}( 15,285,38 6,41 15,285.38} 223,164.62 15,285.38 3-10-201D 08;17 AM FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE ACTIVITY PAGE: 1 CURRENT BALANCE 0D2-1010 Cash - Section 125 101-101D Cash - General Fund 2111010 Cash - - Library 221-1010 Cash - Ice Arena 222-101Q Cash - Pinewood Gold' Course 223--1D10 Cash - - Sr Citizen Account 225-101D Cash - Park Dedication 228-101D Cash - LandFill 231--1010 Cash - Landfill Const Debris 240-1010 Cash - Micro Loan Fund 241-1010 Cash - DIED Loan 245-1010 Gash - - Development Fund 290--101D Gash - Capital Outlay Reserve 291-101D Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 299w101O Cash - - Drug Far~eiture 295-101D Cash - Severance Pay Reserve 296-101D Cash - NSP/RDF Reserve 3D8--1010 Cash - - 1999A GO Bonds 311-1010 Cash - 2003A GO Bonds 312-1.010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Gash ~ 2002A Pub Safety Bonds 340-1D10 Gash - Equipment Certificates 375-1010 Cash - TIF #19 East Elk River 401-1010 Cash - Capital Projects 403--1D10 Cash ~- Street Improvement Resr 404-1010 Cash - Surface Water Managemnt 4D5-101D Cash - NE Area Trunk Utilities 406-1010 Cash - City Wide Trunk Util 410-101D Cash - - Equipment Replacement 4261010 Cash -- YMCA 427-1010 Cash - 193rd Avenue 44D-1010 Cash - Park Improvement 959-1010 Gash - TIF #19 Highway 169 602--1.010 Gash -- Wastewater Treatment 603-101D Cash - Liquor 605-1010 Cash - Garbage 8D1-1010 Cash - Interest 821--1014 Cash -- Developer Escrow TOTAL CLAIM ON CASH 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 CITY OF ELK RIVER POOLED CASH REPORT {FUND 999} AS OF; FEBRUARY 28TH, 2010 22,028.33 998.25 23,026.58 5,D80,166.1D { 709,240.31) 4,375,925.79 407,382.46 { 5,056.18} 4D2,326.28 ( 8,495,13) 122,663.40 114,168.27 ( 5,335,97) ( 7,131,52) { 12,466.99} 10,063.10 1,337,50 11,4D0.6D 7,642.00 O.DO 7,642.00 1,153,523.61 { 5,081.46} 1,198,442.15 676,330.36 0.00 676,330,36 854,962.93 3,872.63 858,835,56 206,796.64 4,828.09 211,624.68 196, 619.93 5, ODD. DO 151, 619 , 93 1,336,635,27 ( 14,536.09} 1,322,099,18 49D,663.36 51,984,18 542,647.54 2,5D3,571.40 { 99,993,26) 2,903,578.14 239,58 67,30 306.88 140,751.24 O.OD 140,751,24 824,353.D6 O.DO 824,353.06 D.00 25,D00.D0 25,oDD.DD 179,360.23 { 1.02,558.75} 76,8D1.4$ 234,772.57 { 118,032.5D} 1.16,740.07 553,782.82 { 365,600,00} 1.88,182.82 176,D57.28 O.DD 176,057.28 7,766,97 0.00 7,766,97 0.40 { 76,171.25} ( 76,171,25) 2,925,791.92 ( 158,94} 2,425,582.98 2,795,188,15 14,794,55 2,8D9,982.70 298,701.,69 D.00 298,701,69 271,377,31 D.OD 271,377,31 3,542,143.58 D.00 3,542,143.58 1,161,327,92 { 289,329.22} 871,99B.7D 1,572,839.39 0.00 1,572,839.39 ( 96,688.30} 29,388.D5 ( 67,30D.25} 16,204.98 106.11 16,31D.59 596,DD7.41 D.DO 546,007.91 4,021,709,92 ( 127,178.95} 3,894,526,97 3,724,404.D9 { 29,220.93) 3,700,183.61 357,056.14 { 28,766.79} 328,289,40 O.OD 13,089.03 13,089,03 45,430,86 ( 232.D0} 45,198.86 35,681,073.10 { 1, 695,158.D6} 33,985,915,04 8,072,919.96 ( 947,426.14} 7,125,493,82 ( 779,036,42) { 747,731..92) (1,521,768.34) 28,382,189,55 0.00 28,382,189.56 35,681,073.10 { 1,695,158.06) 33,985,915.04 ~ , ,~ ,, i f. ;~ ~\ , fj,a` ,~~ 4~...~~~~~~ilu`it.~`~~ ~, ~``'