Loading...
INFORMATION 02-22-2011INFORMATION o€ .VCS MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: February 22, 2011 SUBJECT: January 2011 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Pinewood Golf and Ice Arena special revenue funds. These funds axe the primary concern in analyzing the City's financial health. For the month of January, actual revenues (except fox property taxes and state aids) and expenditures should run slightly over 8% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below 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 fox the variance. General Fund Kevenues: • Property taxes, our largest revenue source, will be received in July and December. • Revenue collections in other business licenses & permits are related to solid waste and apartment license annual renewals. • Charges for services revenue includes the semi-annual billing fox school liaison services for January through June and the annual fire contract with the City of Otsego. • The negative interest income is related to the reversal of the prior year's interest receivable which was done as of January. • The transfers in will be recorded mid-year. E.xpenditurer: • Excluding transfers, the total departmental expenditures are under 5% and most departments are well within ox below budget. • Many departments' expenditures include the first quarter allocation of liability and workers comp insurance and annual software maintenance agreements, as is the case for Mayor & Council and Police Administration. • The Snow Removal budget reflects the seasonal expenditures for personal services. • The transfers out to the Ice Arena and Pinewood Golf axe made at the end of the year. Ice Arena Fox January, revenues exceeded expenditures by $21,108. Excluding transfers in, revenues axe about 6% of budget due mainly to hockey admissions and concessions while expenditures are about 2.5% attributable mainly to personal services and insurance. Pinewood Golf Revenue collections consist of league registrations but most of the golf revenues will not be generated until spring. Expenditures axe about 3% of the budget due to personal services, insurance, and equipment maintenance of mowers. 2-16-2011 08:09 AM I 101-GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I 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,163,450.00 141,878.01 141,878.01 1.17 12,021,571.99 12,163,450.00 141,878.01 141,878.01 1.17 12,021,571.99 177,800.00 24,506.64 24,506.64 13.78 153,293.36 77,800.00 3,504.99 3,504.99 9.51 79,295.01 473,650.00 26,844.74 26,844.74 5.67 946,805.26 150,750.00 8,273.46 8,273.46 5.49 142,476.54 459,700.00 27,231.11 27,231.11 5.99 427,468.89 266,600.00 8,169.25 8,169.25 3.06 258,430.75 240,000.00 0.00 0.00 0.00 240,000.00 67,100.00 3,457.32 3,457.32 5.15 63,642.68 303,550.00 13,684.62 13,684.62 4.51 289,865.38 300,850.00 11,693.31 11,693.31 3.89 289,156.69 75,000.00 100.00 100.00 0.13 74,900.00 2,587,800.00 127,465.44 127,465.44 9.93 2,460,339.56 563,800.00 70,394.21 70,394.21 12.49 493,905.79 2,252,800.00 91,760.36 91,760.36 4.07 2,161,039.64 752,450.00 31,850.17 31,850.17 4.23 720,599.83 491,700.00 22,945.94 22,945.94 4.67 468,754.06 22,900.00 295.30 295.30 1.29 22,604.70 205,000.00 10,865.12 10,865.12 5.30 194,134.88 589,600.00 27,907.84 27,407.84 4.65 562,192.16 184,850.00 7,769.49 7,769.49 4.20 177,080.51 107,400.00 583.98 583.98 0.54 106,816.02 465,200.00 24,636.14 24,636.14 5.30 490,563.86 56,950.00 2,559.13 2,559.13 4.49 54,390.87 5,692,650.00 291,067.68 291,067.68 5.11 5,401,582.32 1,524,450.00 31,601.15 31,601.15 2.07 1,492,848.85 262,850.00 36,146.95 36,146.95 13.75 226,703.05 245,950.00 8,833.04 8,833.04 3.59 237,116.96 177,800.00 5,590.61 5,590.61 3.14 172,209.39 2,211,050.00 82,171.75 82,171.75 3.72 2,128,878.25 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND FINANCIAL SUMMARY 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 CURRENT CURRENT BUDGET PERIOD 08.330 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 790,350.00 34,769.31 34,769.31 4.40 755,580.69 550,300.00 20,413.06 2D, 913.06 3.71 529,886.94 192,500.00 6,510.02 6,510.02 3.38 185,989.98 19,100.00 0.00 0.00 0.00 14,100.00 209,450.00 8,435.93 8,435.43 4.13 196,014.57 1,751,700.00 70,127.82 70,127.82 4.00 1,681,572.18 0.00 14,975.56 14,975.56 0.00 ( 14,975.56) 51,650.00 1,717.69 1,717.69 3.33 49,932.31 51,650.00 16,693.25 16,693.25 32.32 34,956.75 205,200.00 0.00 0.00 0.00 205,200.00 205,200.00 0.00 0.00 0.00 205,200.00 12,500,050.00 587,525.94 587,525.94 4.70 11,912,524.06 ( 336,600.00)( 445,647.93)( 445,647.93) 109,047.93 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 101-GENERAL FUND REVENUES 08.33$ 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 9,758,500.00 0.00 0.00 0.00 9,758,500.00 101-3-0000-3119 MV Reduction ( 221,100.00) 0.00 0.00 0.00 ( 221,100.00) 101-3-0000-3121 Gravel Tax 75,000.00 0.00 0.00 0.00 75,000.00 TOTAL Taxes 9,612,400.00 0.00 0.00 0.00 9,612,400.00 Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 Amusement License 101-3-0000-3213 Cigarette License 101-3-0000-3214 Apartment License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3236 Parking Permit 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Licenses & Permits 53,000.00 0.00 0.00 0.00 53,000.00 1,000.00 195.00 195.00 19.50 805.00 3,000.00 0.00 0.00 0.00 3,000.00 16,000.00 1,260.00 1,260.00 7.88 14,740.00 20,000.00 0.00 0.00 0.00 20,000.00 4,000.00 555.00 555.00 13.88 3,445.00 14,000.00 4,380.00 4,380.00 31.29 9,620.00 2,500.00 350.00 350.00 14.00 2,150.00 100,000.00 5,969.35 5,969.35 5.97 94,030.65 25,000.00 2,385.78 2,385.78 9.54 22,614.22 200.00 419.29 419.29 209.65 ( 219.29) 3,000.00 450.00 450.00 15.00 2,550.00 3,000.00 120.00 120.00 4.00 2,880.00 8,000.00 530.00 530.00 6.63 7,470.00 252,700.00 16,614.42 16,614.42 6.57 236,085.58 Intergovernmental Rev 101-3-0000-3311 Federal Grant 4,000.00 0.00 0.00 0.00 4,000.00 101-3-0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2S Aid 205,000.00 0.00 0.00 0.00 205,000.00 101-3-0000-3326 Police Training Reimb 12,000.00 0.00 0.00 0.00 12,000.00 101-3-0000-3327 State-Aid Street Maint 254,050.00 0.00 0.00 0.00 259,050.00 101-3-0000-3329 State Crime Prevention Grant 35,000.00 0.00 0.00 0.00 35,000.00 101-3-0000-3330 Other State Grants 4,000.00 0.00 0.00 0.00 4,000.00 TOTAL Intergovernmental Rev 528,050.00 0.00 0.00 0.00 528,050.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 40.00 40.00 0.27 14,960.00 101-3-0000-3413 Plan Check Fee 30,000.00 2,527.01 2,527.01 8.42 27,472.99 101-3-0000-3415 Special Assessment Search 600.00 80.00 80.00 13.33 520.00 101-3-0000-3417 Copies 1,500.00 419.75 419.75 27.98 1,080.25 101-3-0000-3418 Other General Govt Services 4,000.00 13.00 13.00 0.33 3,987.00 101-3-0000-3430 Lockout Fees 7,500.00 740.00 740.00 9.87 6,760.00 101-3-0000-3431 Police Services 2,000.00 50.00 50.00 2.50 1,950.00 101-3-0000-3432 School Liaison 75,000.00 37,500.00 37,500.00 50.00 37,500.00 101-3-0000-3439 Animal Impound Fee 3,000.00 100.00 100.00 3.33 2,900.00 101-3-0000-3436 Fire Contracts 194,000.00 84,902.72 84,902.72 43.76 109,097.28 101-3-0000-3437 Fire Calls 4,000.00 0.00 0.00 0.00 4,000.00 2-16-2011 08:09 AM 1 101-GENERAL FUND 1 REVENUES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 08.335 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3451 Street Services 101-3-0000-3452 Engineering Services Reimb 101-3-0000-3461 Recreation Fees 101-3-0000-3467 Concessions 101-3-0000-3472 Park Use Fee 101-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines & Forfeits I Special Assessments 101-3-0000-3621 Interest Income i01-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-3944 Transfer-Garbage 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund ~ TOTAL REVENUE 30,000.00 0.00 0.00 0.00 99,100.00 0.00 0.00 0.00 123,000.00 12,779.50 12,779.50 10.39 14,100.00 0.00 0.00 0.00 18,000.00 440.00 440.00 2.44 6,200.00 350.00 350.00 5.65 13,200.00 200.00 200.00 1.52 2,500.00 130.00 130.00 5.20 400.00 15.00 15.00 3.75 643,100.00 140,286.98 140,286.98 21.81 502,813.02 120,000.00 0.00 0.00 0.00 120,000.00 10,000.00 3,805.50 3,805.50 38.06 6,194.50 130,000.00 3,805.50 3,805.50 2.93 126,194.50 120,000.00 ( 20,984.84)( 20,984.84) 17.49- 140,984.84 65,000.00 225.45 225.45 0.35 64,774.55 23,700.00 1,817.00 1,817.00 7.67 21,883.00 4,000.00 113.50 113.50 2.84 3,886.50 212,700.00 ( 18,828.89)( 18,828.89) 8.85- 231,528.89 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 75,000.00 0.00 0.00 0.00 75,000.00 270,000.00 0.00 0.00 0.00 270,000.00 25,000.00 0.00 0.00 0.00 25,000.00 300,000.00 0.00 0.00 0.00 300,000.00 25,000.00 0.00 0.00 0.00 25,000.00 15,000.00 0.00 0.00 0.00 15,000.00 784,500.00 0.00 0.00 0.00 784,500.00 12,163,450.00 191,878.01 141,878.01 1.17 12,021,571.99 12,163,450.00 141,878.01 141,878.01 1.17 12,021,571.99 30,000.00 99,100.00 110,220.50 14,100.00 17,560.00 5,850.00 13,000.00 2,370.00 385.00 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 ~ 101-GENERAL FUND ' DEPARTMENTAL EXPENDITURES 08.33a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-9103 Part-time Pay 101-4-1110-4104 PERA 101-4-1110-9105 FICA 101-4-1110-4107 Medicare 101-4-1110-4109 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-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges ' TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-9104 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 38,500.00 3,366.48 3,366.48 8.74 35,133.52 1,900.00 100.41 100.41 5.28 1,799.59 2,400.00 120.89 120.89 5.04 2,279.11 550.00 48.81 48.81 8.87 501.19 50.00 76.75 76.75 153.50 ( 26.75) 43,400.00 3,713.34 3,713.34 8.56 39,686.66 3,400.00 0.00 0.00 0.00 3,400.00 3,400.00 0.00 0.00 0.00 3,900.00 11,050.00 1,309.00 1,309.00 11.85 9,741.00 400.00 0.00 0.00 0.00 400.00 2,600.00 220.00 220.00 8.46 2,380.00 17,700.00 3,028.55 3,028.55 17.11 14,671.45 74,800.00 16,135.75 16,135.75 21.57 58,664.25 16,000.00 0.00 0.00 0.00 16,000.00 8,450.00 100.00 100.00 1.18 8,350.00 131,000.00 20,793.30 20,793.30 15.87 110,206.70 177,800.00 24,506.64 24,506.64 13.78 153,293.36 54,150.00 2,041.60 2,091.60 3.77 52,108.40 6,500.00 193.75 193.75 2.98 6,306.25 3,950.00 296.04 296.04 7.49 3,653.96 3,750.00 246.06 246.06 6.56 3,503.94 900.00 57.54 57.54 6.39 842.46 5,800.00 670.00 670.00 11.55 5,130.00 200.00 0.00 0.00 0.00 200.00 75,250.00 3,504.99 3,504.99 4.66 71,745.01 700.00 0.00 0.00 0.00 700.00 700.00 0.00 0.00 0.00 700.00 2-16-2011 08:09 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES PAGE: 6 06.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1120-4322 Postage 101-4-1120-4331 Travel, Conferences & Schools 101-4-1120-4404 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 50.00 0.00 0.00 0.00 50.00 1,650.00 0.00 0.00 0.00 1,650.00 150.00 0.00 0.00 0.00 150.00 1,850.00 0.00 0.00 0.00 1,850.00 TOTAL Cable TV 77,800.00 3,504.99 3,504.99 9.51 74,295.01 Administrative S --------------- --------------- ervices ------- ------- Personal Services 101-4-1210-4101 Regular Pay 296,950.00 11,403.15 11,903.15 3.85 285,046.85 101-4-1210-4103 Part-time Pay 44,900.00 1,283.20 1,283.20 2.86 43,616.80 101-4-1210-4104 PERA 24,750.00 1,827.15 1,827.15 7.38 22,922.85 101-9-1210-4105 FICA 21,150.00 1,629.50 1,629.50 7.70 19,520.50 101-4-1210-4106 Other Retirement Contributions 4,800.00 400.00 400.00 8.33 4,400.00 101-4-1210-4107 Medicare 4,950.00 381.09 381.09 7.70 4,568.91 101-4-1210-4108 Insurance 28,500.00 2,100.02 2,100.02 7.37 26,399.98 101-4-1210-4109 Workers Comp 1,800.00 467.25 467.25 25.96 1,332.75 TOTAL Persona l Services 927,300.00 19,491.36 19,491.36 4.56 407,808.64 Supplies 101-4-1210-4201 Office Supplies 9,500.00 25.00 25.00 0.26 9,475.00 TOTAL Supplies 9,500.00 25.00 25.00 0.26 9,475.00 Other Services & Charges 101-4-1210-4319 Other Professional Services 5,500.00 5,328.00 5,328.00 96.87 172.00 101-4-1210-4321 Telephone 800.00 2.99 2.99 0.37 797.01 101-4-1210-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1210-4331 Travel, Conferences & Schools 5,300.00 0.00 0.00 0.00 5,300.00 101-4-1210-4361 Insurance 100.00 73.75 73.75 73.75 26.25 101-4-1210-4404 Equip Repair/Maint Services 23,050.00 1,523.64 1,523.64 6.61 21,526.36 101-4-1210-4433 Dues & Subscriptions 1,100.00 400.00 400.00 36.36 700.00 TOTAL Other Services & Charges 36,850.00 7,328.38 7,328.38 19.89 29,521.62 Capital Outlay CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I TOTAL Administrative Services 473,650.00 26,844.74 26,844.74 5.67 446,805.26 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND General Government ~ DEPARTMENTAL EXPENDITURES Human Resources 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-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 67,850.00 2,653.76 2,653.76 3.91 65,196.24 48,350.00 1,859.57 1,859.57 3.85 46,490.43 8,450.00 676.44 676.44 8.01 7,773.56 7,200.00 568.14 568.14 7.89 6,631.86 1,700.00 132.86 132.86 7.82 1,567.14 5,800.00 486.00 986.00 8.38 5,314.00 600.00 159.00 159.00 26.50 441.00 139,950.00 6,535.77 6,535.77 4.67 133,414.23 3,200.00 1,676.49 1,676.49 52.39 1,523.51 3,200.00 1,676.49 1,676.49 52.39 1,523.51 .3,000.00 0.00 0.00 0.00 3,000.00 350.00 0.00 0.00 0.00 350.00 2,350.00 0.00 0.00 0.00 2,350.00 900.00 0.00 0.00 0.00 900.00 1,000.00 61.20 61.20 6.12 938.80 7,600.00 61.20 61.20 0.81 7,538.80 TOTAL Human Resources Elections Personal Services Supplies Other Services & Charges Capital Outlay 150,750.00 8,273.46 8,273.96 5.49 142,976.54 ' Finance 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: B REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Personal Services 101-4-1310-4101 Regular Pay 101-4-1310-4104 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-9301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-9-1310-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101-4-1350-4103 Part-time Pay 101-4-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1350-4219 Operating Supplies TOTAL Supplies CURRENT CURRENT BUDGET PERIOD 08.33 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 287,800.00 11,069.70 11,069.70 3.85 276,730.30 20,850.00 1,605.10 1,605.10 7.70 19,244.90 17,850.00 1,289.54 1,289.54 7.22 16,560.46 4,200.00 301.58 301.58 7.18 3,898.42 25,850.00 2,100.01 2,100.01 8.12 23,749.99 1,500.00 393.75 393.75 26.25 1,106.25 358,050.00 16,759.68 16,759.68 4.68 341,290.32 3,850.00 0.00 0.00 0.00 3,850.00 3,850.00 0.00 0.00 0.00 3,850.00 18,300.00 0.00 0.00 0.00 18,300.00 53,500.00 0.00 0.00 0.00 53,500.00 800.00 2.22 2.22 0.28 797.78 3,600.00 0.00 0.00 0.00 3,600.00 2,500.00 125.00 125.00 5.00 2,375.00 1,300.00 0.00 0.00 0.00 1,300.00 11,300.00 10,344.21 10,344.21 91.54 955.79 1,500.00 0.00 0.00 0.00 1,500.00 92,800.00 10,471.43 10,471.43 11.28 82,328.57 454,700.00 27,231.11 27,231.11 5.99 427,468.89 128,400.00 4,937.74 4,937.74 3.85 123,462.26 5,000.00 0.00 0.00 0.00 5,000.00 9,300.00 715.98 715.98 7.70 8,584.02 8,250.00 569.81 569.81 6.91 7,680.19 1,950.00 133.27 133.27 6.83 1,816.73 19,850.00 1,626.01 1,626.01 8.19 18,223.99 650.00 182.50 182.50 28.08 467.50 173,400.00 8,165.31 8,165.31 4.71 165,234.69 25,100.00 0.00 0.00 0.00 25,100.00 25,100.00 0.00 0.00 0.00 25,100.00 2-16-2011 08:09 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 PAGE: 9 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 101-4-1350-4321 Telephone 1,450.00 101-4-1350-4331 Travel, Conferences & Schools 8,000.00 101-4-1350-4404 Equip Repair/Maint Services 19,750.00 TOTAL Other Services & Charges 37,200.00 Capital Outlay 101-4-1350-4560 Equipment 30,900.00 TOTAL Capita l Outlay 30,900.00 0.00 0.00 0.00 8,000.00 3.94 3.94 0.27 1,446.06 0.00 0.00 0.00 8,000.00 0.00 0.00 0.00 19,750.00 3.94 3.94 0.01 37,196.06 0.00 0.00 0.00 30,900.00 0.00 0.00 0.00 30,900.00 TOTAL Information Technology Legal Supplies Other Services & Charges 101-4-1400-4309 Legal Fees TOTAL Other Services & Charges 266,600.00 8,169.25 8,169.25 3.06 258,430.75 240,000.00 0.00 0.00 0.00 290,000.00 240,000.00 0.00 0.00 0.00 240,000.00 TOTAL Legal Community Development --------------------- --------------------- Personal Services 101-4-1500-4101 Regular Pay 101-4-1500-4104 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance i01-4-1500-4109 Workers Comp TOTAL Personal Services Supplies i01-4-1500-4201 Office Supplies TOTAL Supplies 240,000.00 0.00 0.00 0.00 240,000.00 52,700.00 2,183.48 2,183.48 4.14 50,516.52 3,800.00 293.82 293.82 7.73 3,506.18 3,250.00 241.54 241.54 7.43 3,008.46 750.00 56.48 56.48 7.53 693.52 5,800.00 486.00 486.00 8.38 5,314.00 250.00 196.00 196.00 78.40 54.00 66,550.00 3,957.32 3,457.32 5.20 63,092.68 150.00 0.00 0.00 0.00 150.00 150.00 0.00 0.00 0.00 150.00 2-16-2011 08:09 AM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES PAGE: 10 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools TOTAL Other Services & Charges 400.00 0.00 0.00 0.00 400.00 400.00 0.00 0.00 0.00 400.00 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-4321 Telephone 101-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 67,100.00 3,457.32 3,457.32 5.15 63,642.68 211,900.00 8,150.84 8,150.84 3.85 203,749.16 15,350.00 1,181.88 1,181.88 7.70 14,168.12 13,150.00 922.90 922.90 7.02 12,227.10 3,100.00 215.84 215.89 6.96 2,884.16 28,300.00 2,324.03 2,324.03 8.21 25,975.97 700.00 285.50 285.50 90.79 414.50 272,500.00 13,080.99 13,080.99 4.80 259,419.01 4,750.00 0.00 0.00 0.00 4,750.00 1,550.00 0.00 0.00 0.00 1,850.00 6,600.00 0.00 0.00 0.00 6,600.00 1,150.00 0.97 0.97 0.08 1,199.03 3,200.00 0.00 0.00 0.00 3,200.00 3,000.00 255.00 255.00 8.50 2,745.00 8,000.00 97.50 97.50 1.22 7,902.50 400.00 103.50 103.50 25.88 296.50 6,900.00 0.00 0.00 0.00 6,900.00 1,000.00 80.00 80.00 8.00 920.00 800.00 66.66 66.66 8.33 733.34 24,450.00 603.63 603.63 2.47 23,846.37 TOTAL Planning City Hall Maintenance --------------------- --------------------- Personal Services 101-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay 101-4-1600-4103 Part-time Pay 101-4-1600-4104 PERA 101-4-1600-4105 FICA CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 303,550.00 13,684.62 13,684.62 4.51 289,865.38 104,350.00 3,862.60 3,862.60 3.70 100,487.40 2,500.00 0.00 0.00 0.00 2,500.00 19,050.00 586.00 586.00 3.08 18,464.00 9,150.00 743.44 743.44 8.13 8,406.56 7,800.00 631.07 631.07 8.09 7,168.93 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1600-4107 Medicare 1,800.00 147.60 147.60 8.20 1,652.40 101-4-1600-4108 Insurance 17,200.00 1,663.06 1,663.06 9.67 15,536.94 101-4-1600-4109 Workers Comp 5,850.00 1,229.00 1,229.00 21.01 9,621.00 TOTAL Personal Services 167,700.00 8,862.77 8,862.77 5.28 158,837.23 Supplies 101-4-1600-4212 Fuels & Lubs 3,450.00 0.00 0.00 0.00 3,450.00 101-4-1600-4217 Uniform Allowance 1,700.00 0.00 0.00 0.00 1,700.00 101-4-1600-4219 Operating Supplies 28,900.00 117.69 117.69 0.41 28,782.31 TOTAL Supplies 34,050.00 117.69 117.69 0.35 33,932.31 Other Services & Charges 101-4-1600-4321 Telephone 12,250.00 993.25 943.25 7.70 11,306.75 101-4-1600-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00 101-4-1600-4361 Insurance 4,850.00 1,186.25 1,186.25 24.46 3,663.75 101-4-1600-4389 Utilities 43,800.00 0.00 0.00 0.00 43,800.00 101-4-1600-4901 Bldg Repair/Maint Services 30,600.00 491.68 991.68 1.61 30,108.32 101-4-1600-4909 Equip Repair/Maint Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-1600-4460 Equip Replacement Charge 1,100.00 91.67 91.67 8.33 1,008.33 TOTAL Other Services & Charges 99,100.00 2,712.85 2,712.85 2.74 96,387.15 Capital Outlay TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 300,850.00 11,693.31 11,693.31 3.89 289,156.69 75,000.00 100.00 100.00 0.13 79,900.00 75,000.00 100.00 100.00 0.13 74,900.00 TOTAL Contingency 75,000.00 100.00 100.00 0.13 74,900.00 TOTAL General Government Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PERA 101-4-2110-9107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services 2,587,800.00 127,465.44 127,465.94 4.93 2,460,334.56 275,400.00 8,444.04 8,449.04 3.07 266,955.96 39,650.00 2,239.89 2,239.89 5.65 37,410.11 2,750.00 119.46 114.96 4.16 2,635.54 25,650.00 1,386.02 1,386.02 5.40 24,263.98 59,350.00 14,375.25 14,375.25 24.22 44,974.75 402,800.00 26,559.66 26,559.66 6.59 376,240.34 2-16-2011 08:09 AM ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 08.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Cther 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-9404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges ' Capital Outlay 19,000.00 0.00 2,250.00 ( 23.60)( 9,600.00 0.00 25,850.00 ( 23.60)( 4,950.00 0.00 29,300.00 217.15 2,200.00 9.42 3,350.00 975.00 500.00 0.00 9,600.00 1,750.25 75,250.00 36,541.33 9,200.00 9,241.25 800.00 123.75 135,150.00 43,858..15 0.00 0.00 19,000.00 23.60) 1.05- 2,273.60 0.00 0.00 4,600.00 23.60) 0.09- 25,873.60 0.00 0.00 4,950.00 217.15 0.74 29,082.85 9.42 0.93 2,190.58 975.00 29.10 2,375.00 0.00 0.00 500.00 1,750.25 18.23 7,849.75 36,541.33 48.56 38,708.67 4,241.25 46.10 4,958.75 123.75 15.47 676.25 43,858.15 32.45 91,291.85 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-9104 PERA 101-4-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Euels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies 563,800.00 70,394.21 70,394.21 12.49 493,405.79 1,444,350.00 54,858.00 54,858.00 3.80 1,389,492.00 90,000.00 656.46 656.46 0.73 89,343.54 220,950.00 15,676.71 15,676.71 7.10 205,273.29 19,950.00 1,290.62 1,290.62 6.47 18,659.38 171,450.00 13,839.76 13,839.76 8.07 157,610.24 1,946,700.00 86,321.55 86,321.55 4.43 1,860,378.45 108,500.00 104.55 104.55 0.10 108,395.45 23,900.00 ( 123.48)( 123.48) 0.52- 24,023.48 58,650.00 1,738.57 1,738.57 2.96 56,911.43 28,000.00 0.00 0.00 0.00 28,000.00 219,050.00 1,719.64 1,719.64 0.79 217,330.36 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 15,650.00 0.00 0.00 0.00 15,650.00 101-4-2120-4404 Equip Repair/Maint Services 26,700.00 0.00 0.00 0.00 26,700.00 101-4-2120-4433 Dues & Subscriptions 550.00 40.00 40.00 7.27 510.00 101-4-2120-4460 Equip Replacement Charge 49,150.00 3,679.17 3,679.17 8.33 40,470.83 TOTAL Other Services & Charges 87,050.00 3,719.17 3,719.17 4.27 83,330.83 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Patrol Investigations Personal Services LO1-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4109 PERA 101-4-2130-9107 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 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Investigations Police Support Services Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4109 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services 2,252,800.00 91,760.36 91,760.36 4.07 2,161,039.64 505,600.00 18,122.41 18,122.41 3.58 487,477.59 45,000.00 450.30 450.30 1.00 44,549.70 79,300.00 5,354.05 5,354.05 6.75 73,945.95 5,850.00 391.98 391.48 6.69 5,458.52 70,100.00 5,969.64 5,969.64 8.52 64,130.36 705,850.00 30,287.88 30,287.88 4.29 675,562.12 5,150.00 ( 10.34)( 8,700.00 0.00 13,850.00 ( 10.34)( 10.34) 0.20- 5,160.34 0.00 0.00 8,700.00 10.34) 0.07- 13,860.39 11,900.00 235.13 235.13 1.98 11,664.87 5,550.00 0.00 0.00 0.00 5,550.00 1,050.00 150.00 150.00 14.29 900.00 14,250.00 1,187.50 1,187.50 8.33 13,062.50 32,750.00 1,572.63 1,572.63 4.80 31,177.37 752,450.00 31,850.17 31,850.17 4.23 720,599.83 347,050.00 14,276.68 14,276.68 4.11 332,773.32 3,500.00 178.02 178.02 5.09 3,321.98 25,900.00 2,048.42 2,048.42 8.06 23,351.58 21,750.00 1,621.18 1,621.18 7.45 20,128.82 5,100.00 390.44 390.44 7.66 4,709.56 46,350.00 3,860.37 3,860.37 8.33 92,489.63 449,150.00 22,375.11 22,375.11 4.98 426,774.89 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2150-9201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges i01-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-9-2150-4409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 1,000.00 0.00 0.00 0.00 1,000.00 3,000.00 0.00 0.00 0.00 3,000.00 10,100.00 ( 20.00)( 20.00) 0.20- 10,120.00 14,100.00 ( 20.00)( 20.00) 0.14- 14,120.00 3,550.00 0.00 0.00 0.00 3,550.00 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 0.00 0.00 0.00 16,000.00 500.00 45.00 45.00 9.00 955.00 6,550.00 545.83 545.83 8.33 6,004.17 28,450.00 590.83 590.83 2.08 27,859.17 I TOTAL Police Support Services Police Reserves Personal Services 101-4-2160-4103 Part-time Pay i01-4-2160-4105 FICA 101-4-2160-4107 Medicare TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies 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 Capital Outlay 491,700.00 22,945.94 22,945.94 4.67 468,754.06 5,500.00 213.60 213.60 3.88 5,286.40 350.00 66.21 66.21 18.92 283.79 100.00 15.49 15.49 15.49 84.51 5,950.00 295.30 295.30 4.96 5,654.70 5,000.00 0.00 0.00 0.00 5,000.00 6,000.00 0.00 0.00 0.00 6,000.00 11,000.00 0.00 0.00 0.00 11,000.00 1,500.00 0.00 0.00 0.00 1,500.00 1,600.00 0.00 0.00 0.00 1,600.00 1,700.00 0.00 0.00 0.00 1,700.00 150.00 0.00 0.00 0.00 150.00 1,000.00 0.00 0.00 0.00 1,000.00 5,950.00 0.00 0.00 0.00 5,950.00 TOTAL Police Reserves 22,900.00 295.30 295.30 1.29 22,609.70 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 08.33$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE I Public-safety building Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-4107 Medicare i01-4-2190-9108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2190-4361 Insurance 101-4-2190-4389 Utilities 101-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 101,850.00 3,707.47 3,707.47 3.69 98,192.53 7,400.00 502.88 502.88 6.80 6,897.12 6,300.00 420.14 420.19 6.67 5,879.86 1,500.00 98.27 98.27 6.55 1,401.73 13,300.00 888.88 888.88 6.68 12,411.12 3,400.00 1,005.75 1,005.75 29.58 2,394.25 133,750.00 6,623.39 6,623.39 4.95 127,126.61 15,000.00 1,990.91 1,990.91 13.27 13,009.09 15,000.00 1,990.91 1,990.91 13.27 13,009.09 6,750.00 1,285.00 1,285.00 19.04 5,465.00 18,200.00 0.00 D.00 0.00 18,200.00 31,300.00 965.82 965.82 3.09 30,334.18 56,250.00 2,250.82 2,250.82 4.00 53,999.18 I TOTAL Public safety building Fire Administration Personal Services 101-4-2310-9101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions 101-4-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-9-2310-4219 Operating Supplies 101-4-2310-9221 Equipment Parts TOTAL Supplies 205,000.00 10,865.12 10,865.12 5.30 194,139.88 86,200.00 3,459.17 3,454.17 4.01 82,745.83 186,250.00 8,603.97 8,603.97 4.62 177,646.03 13,500.00 1,021.70 1,021.70 7.57 12,478.30 12,500.00 872.61 872.61 6.98 11,627.39 38,500.00 0.00 0.00 0.00 38,500.00 3,950.00 281.55 281.55 7.13 3,668.45 7,200.00 602.63 602.63 8.37 6,597.37 20,200.00 5,295.50 5,245.50 25.97 14,954.50 368,300.00 20,082.13 20,082.13 5.45 348,217.87 5,150.00 0.00 0.00 0.00 5,150.00 7,350.00 0.00 0.00 0.00 7,350.00 4,400.00 0.00 0.00 0.00 4,400.00 26,150.00 ( 36.50)( 36.50) 0.14- 26,186.50 7,400.00 0.00 0.00 0.00 7,400.00 50,450.00 ( 36.50)( 36.50) 0.07- 50,486.50 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES Other Services & Charges 101-4-2310-9319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-4-2310-4389 Utilities 101-4-2310-4901 Bldg Repair/Maint Services 101-4-2310-4409 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101-4-2310-4560 Equipment TOTAL Capital Outlay 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 5,100.00 0.00 0.00 0.00 5,100.00 4,950.00 102.15 102.15 2.06 4,847.85 500.00 0.00 0.00 0.00 500.00 27,450.00 0.00 0.00 0.00 27,450.00 300.00 0.00 0.00 0.00 300.00 17,500.00 3,733.75 3,733.75 21.34 13,766.25 15,150.00 0.00 0.00 0.00 15,150.00 5,650.00 0.00 0.00 0.00 5,650.00 31,550.00 310.48 310.48 0.98 31,239.52 1,950.00 745.00 745.00 38.21 1,205.00 29,650.00 2,470.83 2,470.83 8.33 27,179.17 139,750.00 7,362.21 7,362.21 5.27 132,387.79 31,100.00 0.00 0.00 0.00 31,100.00 31,100.00 0.00 0.00 0.00 31,100.00 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-9101 Regular Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-9201 Office Supplies 101-4-2320-4212 Euels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4409 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 589,600.00 27,407.84 27,407.84 4.65 562,192.16 129,900.00 4,970.04 9,970.04 3.84 124,429.96 19,850.00 1,141.60 1,141.60 7.69 13,708.40 3,250.00 262.85 262.85 8.09 2,987.15 1,900.00 193.17 143.17 7.54 1,756.83 14,850.00 1,195.86 1,195.86 8.05 13,654.14 164,250.00 7,713.52 7,713.52 4.70 156,536.48 2,750.00 0.00 0.00 0.00 2,750.00 3,200.00 0.00 0.00 0.00 3,200.00 1,400.00 0.00 0.00 0.00 1,400.00 4,450.00 0.00 0.00 0.00 4,450.00 11,800.00 0.00 0.00 0.00 11,800.00 2,950.00 55.97 55.97 1.90 2,894.03 2,500.00 0.00 0.00 0.00 2,500.00 2,000.00 0.00 0.00 0.00 2,000.00 1,350.00 0.00 0.00 0.00 1,350.00 8,800.00 55.97 55.97 0.64 8,744.03 TOTAL Fire Inspections 184,850.00 7,769.49 7,769.49 4.20 177,080.51 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES 08.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Emergency Management ------------------ ------------------ Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-9104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4389 Utilities 101-4-2330-4904 Equip Repair/Maint Services 101--4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 8,900.00 1,300.00 150.00 600.00 10,950.00 500.00 9,150.00 9,650.00 1,650.00 4,000.00 1,500.00 7,800.00 100.00 15,050.00 71,750.00 71,750.00 339.02 334.02 3.75 8,565.98 96.20 96.20 7.40 1,203.80 9.70 9.70 6.47 140.30 39.84 39.84 6.64 560.16 479.76 479.76 4.38 10,470.29 0.00 0.00 0.00 500.00 0.00 0.00 0.00 9,150.00 0.00 0.00 0.00 9,650.00 0.00 0.00 0.00 1,650.00 0.00 0.00 0.00 4,000.00 104.22 104.22 6.95 1,395.78 0.00 0.00 0.00 7,800.00 0.00 0.00 0.00 100.00 104.22 104.22 0.69 14,945.78 0.00 0.00 0.00 71,750.00 0.00 0.00 0.00 71,750.00 TOTAL Emergency Management Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4103 Part-time Pay 101-4-2410-9104 PERA 101-4-2910-4105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2410-4201 Office Supplies 101-4-2410-4212 Fuels & Lubs 101-4-2410-4219 Operating Supplies TOTAL Supplies 107,400.00 583.98 583.98 0.54 106,816.02 319,400.00 12,284.08 12,284.08 3.85 307,115.92 25,950.00 992.48 992.48 3.82 24,957.52 25,050.00 1,926.72 1,926.72 7.69 23,123.28 21,400.00 1,535.55 1,535.55 7.18 19,864.45 5,000.00 359.12 359.12 7.18 4,640.88 40,150.00 3,286.02 3,286.02 8.18 36,863.98 1,200.00 370.25 370.25 30.85 829.75 438,150.00 20,754.22 20,754.22 4.74 417,395.78 2,500.00 0.00 0.00 0.00 2,500.00 4,700.00 7.84 7.84 0.17 4,692.16 2,250.00 0.00 0.00 0.00 2,250.00 9,450.00 7.84 7.84 0.08 9,442.16 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES 08.330 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2410-9321 Telephone 101-9-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-9460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 1,600.00 9.68 9.68 0.61 1,590.32 400.00 0.00 0.00 0.00 400.00 4,650.00 1,370.00 1,370.00 29.46 3,280.00 900.00 149.75 149.75 16.64 750.25 7,200.00 2,207.15 2,207.15 30.65 4,992.85 1,200.00 0.00 0.00 0.00 1,200.00 1,650.00 137.50 137.50 8.33 1,512.50 17,600.00 3,874.08 3,874.08 22.01 13,725.92 TOTAL Building Safety Environmental Personal Services 101-4-2940-4101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2940-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs SOTAL Supplies Other Services & Charges 101-9-2440-4321 Telephone 101-4-2440-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4409 Contractual Services 101-4-2440-4433 Dues & Subscriptions TOTAL Other Services & Charges 465,200.00 24,636.14 24,636.14 5.30 440,563.86 39,050.00 1,501.38 1,501.38 3.84 37,548.62 2,850.00 208.74 208.79 7.32 2,641.26 2,400.00 153.29 153.29 6.39 2,246.71 550.00 35.85 35.85 6.52 514.15 4,850.00 479.60 479.60 9.89 4,370.40 400.00 _ 136.75 136.75 34.19 263.25 50,100.00 2,515.61 2,515.61 5.02 47,584.39 650.00 0.00 0.00 0.00 650.00 150.00 0.00 0.00 0.00 150.00 800.00 0.00 0.00 0.00 800.00 700.00 3.52 500.00 0.00 soo.oo o.oo 100.00 0.00 200.00 0.00 3,000.00 0.00 1,050.00 40.00 6,050.00 43.52 3.52 0.50 696.48 0.00 0.00 500.00 o.oo o.oo soo.oo o.oo o.o0 100.00 0.00 0.00 200.00 0.00 0.00 3,000.00 40.00 3.81 1,010.00 43.52 0.72 6,006.48 I TOTAL Environmental 56,950.00 2,559.13 2,559.13 4.49 54,390.87 I TOTAL Public Safety 5,692,650.00 291,067.68 291,067.68 5.11 5,401,582.32 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 101-GENERAL FUND Public Works 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Street Maintenance Personal Services i01-4-3120-4101 Regular Pay 426,650.00 4,490.62 4,490.62 1.05 422,159.38 101-4-3120-4102 Overtime Pay 0.00 183.64 183.64 0.00 ( 183.69) 101-4-3120-4103 Part-time Pay 78,400.00 1,934.88 1,934.88 2.47 76,465.12 101-4-3120-4104 PERA 34,950.00 1,144.79 1,144.74 3.28 33,805.26 101-9-3120-4105 FICA 31,300.00 929.88 929.88 2.97 30,370.12 101-4-3120-4107 Medicare 7,350.00 217.96 217.46 2.96 7,132.54 101-4-3120-4108 Insurance 57,050.00 2,029.61 2,024.61 3.55 55,025.39 101-4-3120-4109 Workers Comp 25,050.00 6,120.00 6,120.00 24.43 18,930.00 TOTAL Personal Services 660,750.00 17,045.83 17,045.83 2.58 643,704.17 Supplies 101-4-3120-4201 Office Supplies 3,600.00 0.00 0.00 0.00 3,600.00 101-4-3120-4212 Fuels & Lubs 69,250.00 ( 112.39)( 112.39) 0.17- 64,362.39 101-4-3120-4219 Operating Supplies 146,750.00 0.00 0.00 0.00 146,750.00 101-4-3120-4226 Street Signs 42,000.00 0.00 0.00 0.00 42,000.00 TOTAL Supplies 256,600.00 ( 112.39)( 112.39) 0.04- 256,712.39 Other Services & Charges 101-4-3120--9319 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-4401 Bldg Repair/Maint Services 101-4-3120-4404 Equip Repair/Maint Services 101-4-3120-4909 Contractual Services 101-4-3120-9415 Equipment Rental 101-4-3120-4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-3120-4437 Taxes & Licenses 101-4-3120-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 250.00 0.00 0.00 0.00 250.00 8,950.00 114.98 114.98 1.28 8,835.02 200.00 ( 7.92)( 7.92) 3.96- 207.92 3,000.00 79.00 79.00 2.63 2,921.00 500.00 0.00 0.00 0.00 500.00 17,250.00 4,358.25 4,358.25 25.27 12,891.75 36,000.00 2,156.50 2,156.50 5.99 33,843.50 4,500.00 0.00 0.00 0.00 4,500.00 5,000.00 0.00 0.00 0.00 5,000.00 422,750.00 0.00 0.00 0.00 922,750.00 10,000.00 0.00 0.00 0.00 10,000.00 4,700.00 23.15 23.15 0.49 4,676.85 350.00 181.25 181.25 51.79 168.75 500.00 0.00 0.00 0.00 500.00 93,150.00 7,762.50 7,762.50 8.33 85,387.50 607,100.00 14,667.71 14,667.71 2.42 592,432.29 TOTAL Street Maintenance 1,524,950.00 31,601.15 31,601.15 2.07 1,492,848.85 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Public Works ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 08.33$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE ' Snow-Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA i01-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 115,500.00 18,410.09 18,410.09 15.99 97,089.91 15,000.00 5,175.31 5,175.31 34.50 9,829.69 9,050.00 3,097.95 3,097.95 34.23 5,952.05 8,100.00 2,504.52 2,504.52 30.92 5,595.48 1,900.00 585.72 585.72 30.83 1,314.28 15,950.00 4,677.36 4,677.36 29.33 11,272.64 7,350.00 1,696.00 1,696.00 23.07 5,654.00 172,850.00 36,146.95 36,146.95 20.91 136,703.05 90,000.00 0.00 0.00 0.00 90,000.00 90,000.00 0.00 0.00 0.00 90,000.00 TOTAL Snow Removal Equipment Services ~rsonal Services 10~-4-3150-4101 Regular Pay 101-9-3150-4109 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 Supplies 101-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4409 Equip Repair/Maint Services 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges 262,850.00 36,146.95 36,146.95 13.75 226,703.05 162,750.00 5,141.55 5,141.55 3.16 157,608.45 11,800.00 680.75 680.75 5.77 11,119.25 10,100.00 541.21 541.21 5.36 9,558.79 2,350.00 126.58 126.58 5.39 2,223.42 22,700.00 1,216.38 1,216.38 5.36 21,483.62 7,050.00 999.50 999.50 14.18 6,050.50 216,750.00 8,705.97 8,705.97 4.02 208,044.03 14,500.00 80.00 80.00 0.55 14,420.00 11,200.00 0.00 0.00 0.00 11,200.00 25,700.00 80.00 80.00 0.31 25,620.00 500.00 0.00 0.00 0.00 500.00 3,000.00 47.07 47.07 1.57 2,952.93 3,500.00 47.07 47.07 1.34 3,452.93 2-16-2011 08:09 AM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 PAGE: 21 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Equipment Services 245,950.00 8,833.04 8,833.04 3.59 237,116.96 Engineering Personal Services 101-4-3300-4101 Regular Pay 116,750.00 3,313.96 3,313.96 2.84 113,436.04 101-4-3300-4104 PERA 8,450.00 480.52 480.52 5.69 7,969.48 101-4-3300-4105 FICA 7,250.00 360.58 360.58 4.97 6,889.42 101-4-3300-4107 Medicare 1,700.00 84.32 84.32 4.96 1,615.68 101-4-3300-4108 Insurance 13,000.00 928.01 928.01 7.14 12,071.99 101-4-3300-4109 Workers Comp 950.00 123.00 123.00 27.33 327.00 TOTAL Person al Services 147,600.00 5,290.39 5,290.39 3.58 142,309.61 Supplies 101-4-3300-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-3300-4212 Fuels & Lubs 700.00 0.00 0.00 0.00 700.00 101-4-3300-4219 Operating Supplies 9,800.00 0.00 0.00 0.00 9,800.00 TOTAL Suppli es 11,500.00 0.00 0.00 0.00 11,500.00 Other Services & Charges 101-4-3300-9319 Other Professional Services 10,000.00 0.00 0.00 0.00 10,000.00 101-4-3300-4321 Telephone 1,150.00 0.52 0.52 0.05 1,149.48 101-4-3300-4322 Postage 200.00 0.00 0.00 0.00 200.00 101-4-3300-4331 Travel, Conferences & Schools 5,850.00 0.00 0.00 0.00 5,850.00 101-4-3300-4361 Insurance 200.00 46.00 46.00 23.00 159.00 101-4-3300-4409 Equip Repair/Maint Services 500.00 187.03 187.03 37.41 312.97 101-4-3300-4460 Equip Replacement Charge 800.00 66.67 66.67 8.33 733.33 TOTAL Other Services & Charges 18,700.00 300.22 300.22 1.61 18,399.78 Capital Outlay TOTAL Engineering 177,800.00 5,590.61 5,590.61 3.14 172,209.39 TOTAL Public Works Parks Department 2,211,050.00 82,171.75 82,171.75 3.72 2,128,878.25 2-16-2011 08:09 AM I 101-GENERAL FUND Culture & Recreation ^ DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4103 Part-time Pay 101-4-5110-4104 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies 101-4-5110-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-51].0-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4401 Bldg Repair/Maint Services 101-4-5110-4409 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4460 Equip Replacement Charqe TOTAL Other Services & Charges I Capital Outlay 350,250.00 12,912.63 12,912.63 3.69 337,337.37 40,000.00 0.00 0.00 0.00 40,000.00 25,400.00 1,838.72 1,838.72 7.29 23,561.28 29,200.00 1,446.05 1,446.05 5.98 22,753.95 5,650.00 338.21 338.21 5.99 5,311.79 46,900.00 3,674.92 3,674.92 7.89 43,225.08 9,000.00 2,409.50 2,409.50 26.77 6,590.50 501,900.00 22,620.03 22,620.03 4.51 478,779.97 33,200.00 0.00 0.00 0.00 33,200.00 3,250.00 ( 50.94)( 50.94) 1.57- 3,300.94 72,900.00 426.68 426.68 0.59 72,973.32 11,000.00 0.00 0.00 0.00 11,000.00 120,350.00 375.74 375.74 0.31 119,974.26 4,400.00 29.86 29.86 0.68 4,370.14 100.00 0.00 0.00 0.00 100.00 3,150.00 79.77 79.77 2.53 3,070.23 26,700.00 6,407.25 6,407.25 24.00 20,292.75 27,800.00 55.46 55.46 0.20 27,794.54 4,000.00 0.00 0.00 0.00 9,000.00 12,000.00 0.00 0.00 0.00 12,000.00 7,550.00 0.00 0.00 0.00 7,550.00 25,000.00 376.20 376.20 1.50 24,623.80 57,900.00 4,825.00 4,825.00 8.33 53,075.00 168,600.00 11,773.54 11,773.59 6.98 156,826.46 TOTAL Parks Department Parks & Rec Admin 790,350.00 34,769.31 34,769.31 4.40 755,580.69 Personal Services 101-4-5210-4101 Regular Pay 338,950.00 9,504.82 9,504.82 2.80 329,445.18 101-4-5210-4103 Part-time Pay 20,850.00 1,387.30 1,387.30 6.65 19,462.70 101-4-5210-4104 PERA 26,100.00 1,562.69 1,562.69 5.99 24,537.31 101-4-5210-4105 FICA 22,300.00 1,223.04 1,223.04 5.48 21,076.96 101-9-5210-4107 Medicare 5,200.00 286.05 286.05 5.50 4,913.95 101-4-5210-4108 Insurance 95,600.00 2,912.01 2,912.01 6.39 42,687.99 101-4-5210-4109 Workers Comp 3,750.00 988.50 988.50 26.36 2,761.50 TOTAL Personal Services 462,750.00 17,864.91 17,864.41 3.86 444,885.59 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD 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 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-9349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Maint Services 101-4-5210-9404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 11,700.00 0.00 0.00 0.00 11,700.00 11,700.00 0.00 0.00 0.00 11,700.00 4,800.00 117.60 117.60 2.45 4,682.40 4,000.00 0.00 0.00 0.00 4,000.00 6,950.00 55.00 55.00 0.79 6,895.00 26,400.00 0.00 0.00 0.00 26,400.00 1,450.00 153.75 153.75 10.60 1,296.25 8,500.00 0.00 0.00 0.00 8,500.00 12,850.00 1,021.83 1,021.83 7.95 11,828.17 9,350.00 1,200.47 1,200.47 12.84 8,149.53 1,550.00 0.00 0.00 0.00 1,550.00 75,850.00 2,548.65 2,598.65 3.36 73,301.35 TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-4105 FICA i01-4-5220-4107 Medicare TOTAL Personal Services Supplies i01-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-9438 Credit Card Fees TOTAL Other Services & Charges 550,300.00 20,413.06 20,413.06 3.71 529,886.94 82,000.00 1,891.19 1,891.19 2.31 80,108.81 2,400.00 49.50 49.50 2.06 2,350.50 4,350.00 181.19 181.19 9.17 9,168.81 1,200.00 42.37 42.37 3.53 1,157.63 89,950.00 2,164.25 2,164.25 2.41 87,785.75 31,000.00 395.77 395.77 1.28 30,604.23 31,000.00 395.77 395.77 1.28 30,604.23 500.00 0.00 0.00 0.00 500.00 64,050.00 3,950.00 3,950.00 6.17 60,100.00 3,000.00 0.00 0.00 0.00 3,000.00 9,000.00 0.00 0.00 0.00 4,000.00 71,550.00 3,950.00 3,950.00 5.52 67,600.00 TOTAL Recreation Programs 192,500.00 6,510.02 6,510.02 3.38 185,989.98 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 101-GENERAL FUND Culture & Recreation I DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 08.33$ OF YEAR COMP. YEAR TO DATE a OF BUDGET ACTUAL BUDGET BALANCE I Concessions Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 0.00 0.00 0.00 3,650.00 101-4-5230-4104 PERA 150.00 0.00 0.00 0.00 150.00 101-4-5230-4105 FICA 250.00 0.00 0.00 0.00 250.00 101-4-5230-4107 Medicare 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 4,100.00 0.00 0.00 0.00 4,100.00 Supplies 101-4-5230-4219 Operating Supplies 2,900.00 0.00 0.00 0.00 2,900.00 101-4-5230-9259 Other Merchandise For Resale 7,000.00 0.00 0.00 0.00 7,000.00 TOTAL Supplies 9,900.00 0.00 0.00 0.00 9,900.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-9101 Regular 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-9322 Postage 101-4-5510-4331 Travel, Conferences & Schools 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-4404 Equip Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions 'DOTAL Other Services & Charges 14,100.00 0.00 0.00 0.00 14,100.00 57,400.00 2,207.21 2,207.21 3.85 55,192.79 62,000.00 2,300.72 2,300.72 3.71 59,699.28 8,650.00 657.38 657.38 7.60 7,992.62 7,400.00 526.10 526.10 7.11 6,873.90 1,750.00 123.04 123.04 7.03 1,626.96 13,700.00 1,110.20 1,110.20 8.10 12,589.80 500.00 141.50 141.50 28.30 358.50 151,400.00 7,066.15 7,066.15 4.67 144,333.85 12,400.00 ( 382.12)( 382.12) 3.08- 12,782.12 12,400.00 ( 382.12)( 382.12) 3.08- 12,782.12 2,600.00 180.13 180.13 6.93 2,419.87 2,500.00 500.00 500.00 20.00 2,000.00 2,400.00 0.00 0.00 0.00 2,400.00 1,600.00 371.25 371.25 23.20 1,228.75 9,700.00 132.42 132.42 1.37 9,567.58 12,900.00 570.60 570.60 4.60 11,829.40 1,500.00 0.00 0.00 0.00 1,500.00 6,950.00 ( 3.00)( 3.00) 0.04- 6,953.00 1,000.00 0.00 0.00 0.00 1,000.00 40,650.00 1,751.40 1,751.40 4.31 38,898.60 2-16-2011 08:09 AM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES PAGE: 25 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Sr Citizen Programs 209,450.00 8,435.43 8,435.43 4.13 196,014.57 TOTAL Culture & Recreation Economic Development Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4103 Part-time Pay i01-4-6210-4104 PERA 101.-4-6210-4105 FICA 101-4-6210-9107 Medicare 101-4--6210-4108 Insurance 101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges i01-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 1,751,700.00 70,127.82 70,127.82 4.00 1,681,572.18 0.00 10,530.78 10,530.78 0.00 ( 10,530.78) 0.00 891.84 891.84 0.00 ( 891.84) 0.00 778.08 778.08 0.00 ( 778.08) 0.00 651.92 651.92 0.00 ( 651.92) 0.00 154.64 154.64 0.00 ( 154.64) 0.00 1,050.96 1,050.96 0.00 ( 1,050.96) 0.00 195.25 195.25 0.00 ( 195.25) 0.00 14,253.47 14,253.47 0.00 ( 19,253.47) 0.00 716.50 716.50 0.00 ( 716.50) 0.00 5.59 5.59 0.00 ( 5.59) 0.00 722.09 722.09 0.00 ( 722.09) TOTAL Economic Development 0.00 14,975.56 14,975.56 0.00 ( 14,975.56) Energy City Personal Services 101-4-6220-4101 Regular Pay 28,700.00 1,104.16 1,104.16 3.85 27,595.84 101-4-6220-4104 PERA 2,100.00 148.91 148.91 7.09 1,951.09 101-4-6220-4105 FICA 1,800.00 113.55 113.55 6.31 1,686.45 101-4-6220-4107 Medicare 400.00 26.56 26.56 6.64 373.44 101-4-6220-4108 Insurance 3,150.00 249.51 249.51 7.92 2,900.49 TOTAL Personal Services 36,150.00 1,642.69 1,692.69 4.54 34,507.31 Supplies Other Services & Charges 101.-4-6220-9319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-6220-9331 Travel, Conferences & Schools 7,500.00 75.00 75.00 1.00 7,425.00 101-4-6220-4359 Publishing 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Other Services & Charges 15,500.00 75.00 75.00 0.48 15,925.00 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 TOTAL Energy City 51,650.00 1,717.69 1,717.69 3.33 49,932.31 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 101-GENERAL FUND Economic Development I DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Economic Development 51,650.00 16,693.25 16,693.25 32.32 34,956.75 Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 156,250.00 0.00 0.00 0.00 156,250.00 101-4-7000-4724 Transfer - Pinewood 48,950.00 0.00 0.00 0.00 48,950.00 TOTAL Transfers Out 205,200.00 0.00 0.00 0.00 205,200.00 TOTAL Transfers Out 205,200.00 0.00 0.00 0.00 205,200.00 TOTAL General 205,200.00 0.00 0.00 0.00 205,200.00 ^ TOTAL EXPENDITURES ^ REVENUES OVER/(UNDER) EXPENDITURES 12,500,050.00 587,525.94 587,525.94 4.70 11,912,524.06 ( 336,600.00)( 445,647.93)( 445,647.93) 109,047.93 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 221-ICE ARENA FINANCIAL SUMMARY I REVENUE SUMMARY Ice Arena Hockey Skating Concessions TOTAL REVENUES I EXPENDITURE SUMMARY I Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOT.AI~ EXPENDITURES ~. REVENUES OVER/(UNDER) EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 678,900.00 18,335.21 18,335.21 2.70 660,564.79 49,500.00 2,415.00 2,415.00 4.88 47,085.00 73,350.00 5,092.00 5,092.00 6.94 68,258.00 63,100.00 16,959.25 16,959.25 26.88 96,190.75 864,850.00 42,801.46 42,801.46 4.95 822,098.54 756,500.00 19,390.35 19,390.35 2.56 737,109.65 27,050.00 0.00 0.00 0.00 27,050.00 34,050.00 594.60 594.60 1.75 33,955.40 47,250.00 1,708.66 1,708.66 3.62 45,541.34 864,850.00 21,693.61 21,693.61 2.51 843,156.39 869,850.00 21,693.61 21,693.61 2.51 843,156.39 0.00 21,107.85 21,107.85 ( 21,107.85) 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 ~ 221-ICE ARENA I REVENUES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1 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-3975 Building Rent 221-3-0000-3982 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221-3-0000-3791 ATM Revenue TOTAL Sales 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 Other Revenue TOTAL Hockey Skating 443,000.00 1,966.43 1,966.43 0.44 941,033.57 22,900.00 11,990.75 11,990.75 52.36 10,909.25 14,600.00 1,064.45 1,064.45 7.29 13,535.55 4,100.00 944.00 944.00 23.02 3,156.00 2,600.00 0.00 0.00 0.00 2,600.00 17,000.00 0.00 0.00 0.00 17,000.00 504,200.00 15,965.63 15,965.63 3.17 488,234.37 16,650.00 2,008.88 2,008.88 12.07 14,641.12 1,800.00 321.50 321.50 17.86 1,478.50 18,450.00 2,330.38 2,330.38 12.63 16,119.62 0.00 39.20 39.20 0.00 ( 39.20) 0.00 39.20 39.20 0.00 ( 39.20) 156,250.00 0.00 156,250.00 0.00 0.00 0.00 156,250.00 0.00 0.00 156,250.00 678,900.00 18,335.21 18,335.21 2.70 660,564.79 49,500.00 2,415.00 2,915.00 4.88 47,085.00 49,500.00 2,915.00 2,415.00 4.88 47,085.00 49,500.00 2,415.00 2,415.00 4.88 47,085.00 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 221-ICE ARENA I REVENUES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Charges for Services 221-3-5420-3461 Recreation Fees 68,000.00 5,092.00 5,092.00 7.49 62,908.00 221-3-5420-3465 Admissions 3,800.00 0.00 0.00 0.00 3,800.00 TOTAL Charges for Services 71,800.00 5,092.00 5,092.00 7.09 66,708.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 1,550.00 0.00 0.00 0.00 1,550.00 TOTAL Other Revenue 1,550.00 0.00 0.00 0.00 1,550.00 TOTAL Skating 73,350.00 5,092.00 5,092.00 6.94 68,258.00 Concessions Charges for Services 221-3-5430-3467 Concessions 63,100.00 16,959.25 16,959.25 26.88 46,190.75 TOTAL Charges for Services 63,100.00 16,959.25 16,959.25 26.88 46,140.75 TOTAL Concessions 63,100.00 16,959.25 16,959.25 26.88 46,140.75 TOTAL REVENUE 869,850.00 42,801.46 42,801.46 4.95 822,048.54 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 ~ 221-ICE ARENA ~ DEPARTMENTAL EXPENDITURES ~ Ice Arena Personal Services 221-4-5400-4101 Regular Pay 221-9-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-5400-4107 Medicare 221-4-5400-4108 Insurance 221-4-5400-9109 Workers Comp TOTAL Personal Services Supplies 221-4-5400-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/Misc 221-4-5400-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5400-4331 Travel, Conferences & Schools 221-4-5400-9359 Publishing 221-4-5400-9361 Insurance 221-4-5900-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5400-4415 Equipment Rental 221-4-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-4-5400-4560 Equipment TOTAL Capital Outlay Transfers Out 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out CURRENT CURRENT BUDGET PERIOD 08.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 148,700.00 5,596.48 5,596.48 3.76 143,103.52 73,200.00 5,263.34 5,263.34 7.19 67,936.66 12,250.00 1,145.67 1,195.67 9.35 11,104.33 13,750.00 1,252.63 1,252.63 9.11 12,497.37 3,200.00 292.97 292.97 9.16 2,907.03 17,150.00 1,554.42 1,554.42 9.06 15,595.58 5,550.00 1,775.50 1,775.50 31.99 3,774.50 273,800.00 16,881.01 16,881.01 6.17 256,918.99 400.00 0.00 0.00 0.00 400.00 1,500.00 0.00 0.00 0.00 1,500.00 34,500.00 413.75 413.75 1.20 34,086.25 9,000.00 0.00 0.00 0.00 9,000.00 900.00 0.00 0.00 0.00 900.00 96,300.00 913.75 413.75 0.89 45,886.25 3,450.00 143.34 143.34 4.15 3,306.66 500.00 0.00 0.00 0.00 500.00 1,000.00 0.00 0.00 0.00 1,000.00 2,200.00 0.00 0.00 0.00 2,200.00 8,350.00 1,807.25 1,807.25 21.64 6,542.75 148,950.00 0.00 0.00 0.00 148,950.00 22,300.00 0.00 0.00 0.00 22,300.00 1,200.00 0.00 0.00 0.00 1,200.00 2,800.00 0.00 0.00 0.00 2,800.00 450.00 145.00 145.00 32.22 305.00 191,200.00 2,095.59 2,095.59 1.10 189,104.41 49,400.00 0.00 0.00 0.00 44,400.00 44,400.00 0.00 0.00 0.00 49,400.00 200,800.00 0.00 0.00 0.00 200,800.00 200,800.00 0.00 0.00 0.00 200,800.00 TOTAL Ice Arena 756,500.00 19,390.35 19,390.35 2.56 737,109.65 2-16-2011 08:09 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 PAGE: 5 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 221-4-5410-4105 FICA 221-4-5410-4107 Medicare TOTAL Personal Services Supplies 221-4-5410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5410-4359 Publishing 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Hockey Skating Personal Services 221-4-5920-4103 Part-time Pay 221-4-5420-4109 PERA 221-4-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-9-5420-4438 Credit Card Fees TOTAL Other Services & Charges 3,600.00 0.00 0.00 0.00 3,600.00 250.00 0.00 0.00 0.00 250.00 50.00 0.00 0.00 0.00 50.00 3,900.00 0.00 0.00 0.00 3,900.00 14,050.00 0.00 0.00 0.00 19,050.00 14,050.00 0.00 0.00 0.00 14,050.00 500.00 0.00 0.00 0.00 500.00 6,400.00 0.00 0.00 0.00 6,900.00 2,200.00 0.00 0.00 0.00 2,200.00 9,100.00 0.00 0.00 0.00 9,100.00 27,050.00 0.00 0.00 0.00 27,050.00 20,000.00 518.56 518.56 2.59 19,481.44 1,000.00 20.12 20.12 2.01 979.88 1,250.00 45.32 45.32 3.63 1,204.68 300.00 10.60 10.60 3.53 289.40 22,550.00 594.60 594.60 2.69 21,955.40 5,500.00 0.00 0.00 0.00 5,500.00 5,500.00 0.00 0.00 0.00 5,500.00 650.00 0.00 0.00 0.00 650.00 2,550.00 0.00 0.00 0.00 2,550.00 2,800.00 0.00 0.00 0.00 2,800.00 6,000.00 0.00 0.00 0.00 6,000.00 I TOTAL Skating 34,050.00 594.60 594.60 1.75 33,455.40 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 221-ICE ARENA Culture & Recreation I DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-9-5430-4103 Part-time Pay 20,900.00 1,492.88 1,492.88 7.14 19,407.12 221-9-5430-4104 PERA 200.00 30.66 30.66 15.33 169.34 221-4-5430-4105 FICA 1,300.00 150.04 150.04 11.54 1,149.96 221-4-5430-4107 Medicare 300.00 35.08 35.08 11.69 264.92 TOTAL Personal Services 22,700.00 1,708.66 1,708.66 7.53 20,991.34 Supplies 221-4-5430-4219 Operating Supplies 3,550.00 0.00 221-4-5430-4259 Other Merchandise For Resale 21,000.00 0.00 TOTAL Supplies 24,550.00 0.00 0.00 0.00 3,550.00 0.00 0.00 21,000.00 0.00 0.00 24,550.00 I TOTAL Arena Concessions 97,250.00 1,708.66 1,708.66 3.62 45,541.34 I TOTAL Culture & Recreation 864,850.00 21,693.61 21,693.61 2.51 843,156.39 ~ TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 864,850.00 21,693.61 21,693.61 2.51 843,156.39 0.00 21,107.85 21,107.85 ( 21,107.85) 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 I 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY I Pinewood Golf Course TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 249,550.00 668.00 249,550.00 668.00 668.00 0.27 248,882.00 668.00 0.27 248,882.00 249,550.00 8,046.20 8,046.20 3.22 291,503.80 249,550.00 8,096.20 8,046.20 3.22 241,503.80 249,550.00 8,046.20 8,046.20 3.22 241,503.80 0.00 ( 7,378.20)( 7,378.20) 7,378.20 2-16-2011 08:09 AM ^ 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-3975 Building Rent 222-3-0000-3976 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments TOTAL Charges for Services Other Revenue Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 17,000.00 668.00 668.00 3.93 16,332.00 19,000.00 0.00 0.00 0.00 19,000.00 5,000.00 0.00 0.00 0.00 5,000.00 100.00 0.00 0.00 0.00 100.00 120,000.00 0.00 0.00 0.00 120,000.00 14,000.00 0.00 0.00 0.00 14,000.00 18,500.00 0.00 0.00 0.00 18,500.00 7,000.00 0.00 0.00 0.00 7,000.00 200,600.00 668.00 668.00 0.33 199,932.00 48,950.00 0.00 0.00 0.00 48,950.00 48,950.00 0.00 0.00 0.00 48,950.00 249,550.00 668.00 668.00 0.27 248,882.00 ~ TOTAL REVENUE 249,550.00 668.00 668.00 0.27 298,882.00 2-16-2011 08:09 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2011 222-PINEWOOD GOLF COURSE 08.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 93,650.00 2,265.12 2,265.12 2.42 91,384.88 222-4-5300-9103 Part-time Pay 29,900.00 0.00 0.00 0.00 29,900.00 222-4-5300-4109 PERA 8,950.00 328.44 328.44 3.67 8,621.56 222-4-5300-4105 FICA 7,650.00 275.06 275.06 3.60 7,374.99 222-4-5300-4107 Medicare 1,800.00 64.32 64.32 3.57 1,735.68 222-4-5300-4108 Insurance 10,150.00 458.01 458.01 4.51 9,691.99 222-4-5300-4109 Workers Comp 1,400.00 414.00 414.00 29.57 986.00 TOTAL Person al Services 153,500.00 3,809.95 3,804.95 2.48 149,695.05 Supplies 222-9-5300-4212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4217 Uniform Allowance 500.00 0.00 0.00 0.00 500.00 222-4-5300-4219 Operating Supplies 30,400.00 0.00 0.00 0.00 30,400.00 222-4-5300-4259 Other Merchandise For Resale 14,500.00 0.00 0.00 0.00 14,500.00 TOTAL Suppli es 50,400.00 0.00 0.00 0.00 50,400.00 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 0.00 0.00 0.00 2,500.00 222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00 222-4-5300-4349 Advertising/Marketing 1,300.00 0.00 0.00 0.00 1,300.00 222-4-5300-4361 Insurance 11,900.00 2,648.25 2,648.25 22.25 9,251.75 222-4-5300-9389 Utilities 7,150.00 0.00 0.00 0.00 7,150.00 222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 0.00 0.00 0.00 2,300.00 222-4-5300-4404 Equip Repair/Maint Services 3,000.00 1,195.00 1,195.00 39.83 1,805.00 222-4-5300-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00 222-4-5300-4437 Taxes & Licenses 1,000.00 398.00 398.00 39.80 602.00 222-9-5300-4438 Credit Card Fees 5,500.00 0.00 0.00 0.00 5,500.00 TOTAL Other Services & Charges 37,150.00 4,241.25 4,241.25 11.42 32,908.75 Capital Outlay Debt Service 222-4-5300-4601 Principal 8,500.00 0.00 0.00 0.00 8,500.00 TOTAL Debt S ervice 8,500.00 0.00 0.00 0.00 8,500.00 TOTAL Golf Cou rse 299,550.00 8,046.20 8,046.20 3.22 241,503.80 TOTAL Culture & Recreation 249,550.00 8,046.20 8,046.20 3.22 241,503.80 TOTAL EXPENDITURES 249,550.00 8,046.20 8,046.20 3.22 241,503.80 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 7,378.20)( 7,378.20) 7,378.20 2-16-2011 08:13 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JANUARY 31ST, 2011 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE ACTIVITY CURRENT BALANCE 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 221-1010 Cash - Ice Arena 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 290-1010 Cash - Micro Loan Fund 241-1010 Cash - DTED Loan 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - GRE Reserve 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Cash - 2002A Pub Safety Bonds 390-1010 Cash - Equipment Certificates 350-1010 Cash - State-Aid Road Bonds 403-1010 Cash - Street Improvement 404-1010 Cash - Surface Water Managemnt 406-1010 Cash - City Wide Trunk Util 910-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 490-1010 Cash - Park Improvement 456-1010 Cash - TIF #16 King/Main 459-1010 Cash - TIF #19 Highway 169 462-1010 Cash - TIF #22 Downtown Redev 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 25,862.56 ( 6,474.93) 19,387.63 6,328,344.03 ( 792,246.87) 5,536,097.16 415,662.86 ( 2,504.57) 413,158.29 ( 117,675.69) 57,513.21 ( 60,162.98) ( 45,988.72) ( 10,531.84) ( 56,520.56) 11,175.26 ( 412.75) 10,762.51 11,827.87 0.00 11,827.87 999,843.74 19,056.48 1,018,900.22 684,072.21 0.00 684,072.21 1,058,649.53 ( 26,841.30) 1,031,808.23 266,861.38 5,491.04 272,352.42 354,980.44 9,318.49 364,298.93 1,287,105.24 2,980.59 1,290,085.83 316,234.59 121,388.94 437,623.53 3,331,527.52 79,331.19 3,405,858.71 772.19 139.11 911.30 142,362.37 0.00 142,362.37 1,128,811.24 0.00 1,128,811.24 126,840.57 15,127.53 141,968.10 229,687.75 974.66 230,662.41 504,780.67 2,287.03 507,067.70 702,151.01 108,922.81 811,073.82 94,508.23 ( 87,907.29) 6,600.94 921.33 0.00 421.33 5,138,795.56 15,438.06 5,154,233.62 274,043.44 ( 877.88) 273,165.56 4,132,403.09 7,965.93 4,140,369.02 933,796.82 90,059.39 1,023,851.21 1,339,246.13 0.00 1,339,246.13 ( 33,764.55) ( 2,232.00) ( 35,996.55) 62,280.32 15,861.47 78,191.79 45,668.46 ( 1,755.25) 43,913.21 542,896.76 0.00 542,896.76 693.31 ( 693.31) 0.00 4,562,948.54 32,786.43 4,595,734.97 4,133,587.38 ( 136,471.66) 3,997,115.72 467,613.87 21,242.84 488,856.71 0.00 49,697.41 49,697.41 83,205.84 354.00 83,559.84 39,542,233.15 ( 418,018.04) 39,129,215.11 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH 21,174,533.43 355,695.36 21,530,228.79 (10,014,489.84) ( 773,713.40) (10,788,203.24) 28,382,189.56 0.00 28,382,189.56 39,542,233.15 ( 418,018.04) 39,124,215.11 INFORMATION c V~~ MEMORANDUM TO: Mayor and City Council FROM: Nicola Blake-Bradley, Environmental Technician DATE: January 31, 201 I SUBJECT: Lake Orono Drawdown Request Denied In August 2010, the Elk River Lake Orono Improvement Association presented a petition to the City Council and requested that the City of Elk River apply fox a permit to draw down Lake Orono by approximately five feet to proactively treat the Curly Leaf Pondweed (CLP) infestation within the lake. Curly Leaf Pondweed is an invasive plant, spread both by sexual and asexual reproduction, which allows it to rapidly cause navigational and recreational problems. An annual permit for hand pulling the plant has not been successful in eradicating the CLP so an alternative method was sought. Because Lake Orono is a reservoir with a "flow-through" river, chemical application for CLP is not a viable option due to low retention time in Lake Orono. On September 7, 2010, the City Council approved staff's request to submit an application to the MN Department of Natural Resources (DNR) to draw down the lake following a public hearing where people spoke both in favor and against the proposal. A permit request was submitted to the Area Hydrologist on September 8, 2010 for the drawdown. The City received a letter denying the permit request dated January 12, 2011. The DNR staff has determined that significant effects to the resources would result. The consensus of the staff is that "a drawdown would not be appropriate due to the low level of infestation and the impacts on flora and fauna (not targeted, but that would nevertheless suffer or be eradicated)". In an a-mail message, the Area Hydrologist shared comments from the DNR Invasive Species Specialist Brittany Hummel as listed below: • Considering the fact that the CLP infestation is not extensive, and • Considering that a threatened species lives in the lake, and • Considering that a drawdown may adversely affect the fishery, and • Considering that CLP turions are coming from upstream, the lake will always be colonized by CLP turions, and • Considering that a hard freeze can damage water lily tubers In my opinion, a drawdown is not the best management tactic to use on Lake Orono. [We require that at least 25% of the littoral zone contains invasive species. It seems as if Lake Orono would not meet that 25% minixnum.J Ms. Hummel added the following comment in conclusion: "If the small area of CLP on Lake Orono hasn't changed much over the years - I would just leave the CLP alone. For some reason, certain lakes have never had their respective invasive species population "explode". These lakes just leave the invasive species alone." The CLP infestation has grown over time but does not meet the 25% coverage required by the DNR for review of a permit application. Therefore, it appears that the DNR will not allow a drawdown request in 2011 or until such time as there are significant negative impacts to the ecosystem that would outweigh those listed above by Ms. Hummel. INFORMATION MEMORANDUM Fire Department TO: Mayor and City Council FROM: T. John Cunningham, Fire Chief DATE: February 22, 201 1 SUBJECT: January and Year to Date Response Information Beginning in 2011, I will be submitting regular updates to the City Council regarding response statistics of the Elk River Fire Department. I will also include any announcements or upcoming events that might be of interest to the Council. 2010 Summary In 2010, the Elk River Fire Department responded to 444 calls for service. In 2009, the Department responded to 364 calls. This is an increase of 80 calls (22%) compared to the pnor year. Fires ...............................................................:................................................. 58 (13%) Overpressure Ruptures, Explosion and Overheat (no fire) .................... 2 Rescues (including vehicle accidents) .........................................................118 (27%) Hazardous Conditions (gas leaks, electrical problems, etc.) .................... 44 (10%) Service Calls (water leaks, unauthorized burning, etc.) ............................6 (1%) Good Intent Calls (canceled en-route, HazMat investigation, etc.) .......116 (26%) False Alarm and False Calls ......................................................................... 92 (21 %) Severe Weather Calls .....................................................................................7 (2%) Othex ...............................................................................................................1 The average firefighter turn-out per incident in 2010 was 17. January, 2011 Summary In the month of January, 2011, the Elk River Fire Department responded to 49 calls for service. Fires ................................................................................................................. 5 (10%) Rescues (including vehicle accidents) .........................................................19 (39%) Hazardous Conditions (gas leaks, electrical problems, etc.) ....................3 (6%) Service Calls (water leaks, unauthorized burning, etc.) ............................ 2 (4%) Good Intent Calls (canceled en-route, HazMat investigation, etc.) .......12 (24%) False Alarm and False Calls ......................................................................... 8 (16%) The average firefighter turn-out per incident for the month of January was 17. The average response time to calls for the month of January was 6 minutes 23 seconds. Year-to-Date Comparison Through January 31 of last year, the Elk River Fire Department responded to 36 calls for service (compared to 49 this year). Year-to-Date Analysis The Elk River Fire Department continues to see an increase in the number of calls for service. The beginning of 2011 has been extremely busy. Despite the increase in call volume, on-call firefighters continue to stand ready to serve and protect the community. While it is difficult to forecast year-end personnel costs this early, staff will continue to monitor call volume and its potential impact on year-end financials. Other Updates • The Department is scheduled to take delivery of its new heavy rescue truck on Thursday, February 24, 2011. The apparatus committee will be traveling to Appleton, WI to conduct a final inspection the day before and will drive the truck back to Elk River the following day. A public open house and "wet down" ceremony will be scheduled at a later date when the truck is fully outfitted and in-service. • Our three newest members, probationary firefighters Provo, Lees, and Grosskreutz have successfully passed their Firefighter I certification exams. • On the emergency management end, planning has begun for possible spring flooding. Preliminary work has also begun on replacing one outdoor warning siren and upgrading some of the siren radio controller boards.