Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 03-19-2012
INFORMATION V~'~` MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: March 19, 2012 SUBJECT: February 2012 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Axena and Pinewood Golf special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of February, actual revenues (except for property taxes and state aids) and expenditures should run slightly under 17% 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 for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget axe highlighted below accompanied with a general discussion for the variance. General Fund Revenuer: • Property taxes, our largest revenue source, will be received in July and December. • Charges for services revenue collected in February consist mainly of recreation program. fees and facility rentals collected for the spring/summer season. • The negative interest income is related to the reversal of the prior year's interest receivable. • The transfers in will be recorded mid-year. E.xj~enditure.r: • Excluding transfers, the total departmental expenditures are 11.5% and most departments are well within or below budget. • Many departments' expenditures include the first quarter allocation of insurance and annual software maintenance agreements, as is the case for Police Administration. • The Snow Removal budget reflects the seasonal expenditures for personal services and road salt. The transfer out to Pinewood Golf will be made at the end of the year when all revenues and expenditures are finalized. Ice Arena For February, revenues exceeded expenditures by $96,265. Revenues axe almost 25% of budget due mainly to ice rental, recreation fees and concessions while expenditures are slightly over 13% of budget. Pinewood Golf Revenue collections consist of league registrations for summer programs and expenditures are slightly over 6% of the budget due mainly to personal services and insurance. 3-13-2012 04:40 PM CITY OE ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) INFt~RMATICIN AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND FINANCIAL SUMMARY REVENUE SUMMARY General Fund TOTAL REVENUES EXPENDITURE SUMMARY 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 12,311,900.00 52,009.86 363,564.25 2.95 11,948,335.75 12,311,900.00 52,009.86 363,564.25 2.95 11,948,335.75 General Government Mayor & Council 172,250.00 9,724.07 27,401.20 15.91 144,848.80 Cable TV 86,600.00 6,101.52 9,805.57 11.32 76,794.43 Administrative Services 482,950.00 35,484.01 62,981.09 13.09 419,968.91 Human Resources 164,500.00 12,782.94 22,281.96 13.54 142,218.54 Elections 38,050.00 0.00 0.00 0.00 38,050.00 Finance 464,450.00 30,842.54 59,245.55 12.76 405,204.45 Information Technology 242,000.00 26,260.59 34,516.10 14.26 207,483.90 Legal 228,000.00 17,885.00 17,885.00 7.84 210,115.00 Community Development 69,250.00 5,347.58 8,529.56 12.32 60,720.44 Planning 304,700.00 24,458.28 38,452.85 12.62 266,247.15 City Hall Maintenance 304,150.00 25,485.62 38,702.97 12.72 265,447.03 Contingency 241,550.00 0.00 0.00 0.00 241,550.00 TOTAL General Government 2,798,450.00 194,372.15 319,801.35 11.43 2,478,648.65 Public Safety Police Administration 565,500.00 47,863.18 102,353.55 18.10 463,146.45 Patrol 2,350,050.00 156,041.84 258,604.22 11.00 2,091,445.78 Investigations 764,750.00 52,680.24 86,828.38 11.35 677,921.62 Police Support Services 503,500.00 36,807.99 57,728.31 11.47 445,771.69 Police Reserves 18,900.00 2,117.10 2,117.10 11.20 16,782.90 Public safety building 210,150.00 14,933.00 25,404.44 12.09 184,745.56 Fire Administration 555,500.00 39,154.59 58,148.59 10.47 497,351.41 Fire Inspections 188,000.00 14,232.39 22,649.88 12.05 165,350.12 Emergency Management 103,900.00 1,072.99 1,578.19 1.52 102,321.81 Building Safety 473,350.00 37,385.20 58,857.28 12.43 414,492.72 Environmental 48,850.00 3,406.89 5,789.70 11.85 43,060.30 TOTAL Public Safety 5,782,450.00 405,694.91 680,059.64 11.76 5,102,390.36 Public Works Street Maintenance 1,505,300.00 86,664.47 127,356.35 8.46 1,377,943.65 Snow Removal 288,400.00 55,485.69 65,409.07 22.68 222,990.93 Equipment Services 247,900.00 16,792.96 27,051.77 10.91 220,848.23 Engineering 133,550.00 9,044.85 14,402.79 10.78 119,197.21 TOTAL Public Works 2,175,150.00 167,987.97 234,219.98 10.77 1,940,930.02 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND FINANCIAL SUMMARY 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 813,800.00 51,555.16 84,752.43 10.41 729,047.57 579,250.00 45,865.98 72,029.93 12.44 507,220.07 197,000.00 7,557.12 8,948.36 4.54 188,051.64 14,100.00 482.56 498.95 3.54 13,601.05 226,500.00 16,339.57 24,275.75 10.72 202,224.25 1,830,650.00 121,799.89 190,505.42 10.41 1,640,144.58 0.00 11,521.17 27,183.91 0.00 ( 27,183.91) 50,850.00 2,826.88 4,524.23 8.90 46,325.77 50,850.00 14,348.05 31,708.14 62.36 19,141.86 40,500.00 0.00 0.00 0.00 40,500.00 90,500.00 0.00 0.00 0.00 40,500.00 12,678,050.00 904,202.97 1,456,294.53 11.49 11,221,755.47 ( 366,150.00)( 852,193.11)( 1,092,730.28) 726,580.28 3-13-2012 04:90 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 i0i-GENERAL FUND REVENUES General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax TOTAL Taxes 16.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 9,142,200.00 0.00 0.00 0.00 9,142,200.00 70,000.00 0.00 0.00 0.00 70,000.00 9,212,200.00 0.00 0.00 0.00 9,212,200.00 Licenses & Permits i01-3-0000-3211 Liquor License 53,000.00 0.00 2,165.00 4.08 50,835.00 101-3-0000-3212 Amusement License 1,000.00 0.00 0.00 0.00 1,000.00 101-3-0000-3213 Cigarette License 3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3214 Apartment License 17,000.00 3,705.00 6,240.00 36.71 10,760.00 101-3-0000-3216 Mining License 20,000.00 0.00 0.00 0.00 20,000.00 101-3-0000-3217 Garbage Hauler License 2,100.00 210.00 555.00 26.43 1,545.00 101-3-0000-3218 Other Business License/Permit 17,000.00 750.00 4,885.00 28.79 12,115.00 101-3-0000-3229 NPDES Permit 2,500.00 700.00 875.00 35.00 1,625.00 101-3-0000-3231 Building Permit 153,000.00 10,859.80 19,916.95 9.75 138,083.05 101-3-0000-3232 Plumbing/Heating Permit 129,150.00 1,619.30 5,943.26 4.60 123,206.74 101-3-0000-3233 Permit Surcharge 400.00 409.91 756.18 189.05 ( 356.18) 101-3-0000-3235 Animal License 3,500.00 336.50 888.50 25.39 2,611.50 101-3-0000-3236 Parking Permit 3,000.00 92.92 202.92 6.76 2,797.08 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 300.00 320.00 4.00 7,680.00 TOTAL Licenses & Permits 412,650.00 18,982.93 37,747.81 9.15 374,902.19 Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2~ Aid 205,000.00 0.00 0.00 0.00 205,000.00 101-3-0000-3326 Police Training Reimb 12,000.00 0.00 0.00 0.00 12,000.00 101-3-0000-3327 State-Aid Street Maint 275,450.00 0.00 140,991.02 51.19 134,458.98 101-3-0000-3329 State Crime Prevention Grant 30,000.00 0.00 0.00 0.00 30,000.00 101-3-0000-3330 Other State Grants 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Intergovernmental Rev 542,450.00 0.00 140,991.02 25.99 401,458.98 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 1,500.00 1,800.00 12.00 13,200.00 101-3-0000-3413 Plan Check Fee 41,000.00 5,179.11 6,525.61 15.92 34,474.39 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 80.00 8.00 920.00 101-3-0000-3417 Copies 2,500.00 124.84 313.84 12.55 2,186.16 101-3-0000-3418 Other General Govt Services 4,000.00 246.25 266.25 6.66 3,733.75 101-3-0000-3430 Lockout Fees 7,500.00 760.00 1,260.00 16.80 6,240.00 101-3-0000-3431 Police Services 2,000.00 0.00 0.00 0.00 2,000.00 101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 205.00 600.00 20.00 2,400.00 101-3-0000-3436 Fire Contracts 199,600.00 0.00 87,907.52 44.04 111,692.48 101-3-0000-3437 Fire Calls 4,000.00 0.00 0.00 0.00 4,000.00 101-3-0000-3451 Street Services 35,000.00 100.00 100.00 0.29 34,900.00 3-13-2012 04:40 PM 101-GENERAL FUND REVENUES CURRENT CURRENT BUDGES PERIOD PAGE: 4 16.67$ OF YEAR COMP. YEAR TO DATE °s OF BUDGET ACTUAL BUDGET BALANCE 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 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 101-3-0000-3610 Special Assmts-County TOTAL Special Assessments 101-3-0000-3621 Interest Income 101-3-0000-3625 Refunds & Reimbursements 101-3-0000-3626 Contributions 101-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101-3-0000-3921 Transfers 101-3-0000-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-WWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3944 Transfer-Garbage 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 89,150.00 0.00 0.00 0.00 89,150.00 129,000.00 20,934.02 30,788.52 23.87 98,211.48 14,100.00 0.00 0.00 0.00 14,100.00 17,000.00 ( 25.73) 374.27 2.20 16,625.73 5,700.00 1,514.04 4,094.04 71.83 1,605.96 2,400.00 200.00 900.00 16.67 2,000.00 3,000.00 325.00 455.00 15.17 2,545.00 400.00 30.00 45.00 11.25 355.00 650,350.00 30,652.53 172,510.05 26.53 477,839.95 120,000.00 0.00 0.00 0.00 120,000.00 12,000.00 2,642.25 6,382.25 53.19 5,617.75 500.00 0.00 0.00 0.00 500.00 132,500.00 2,642.25 6,382.25 4.82 126,117.75 0.00 ( 714.12) 0.00 0.00 0.00 0.00 ( 714.12) 0.00 0.00 0.00 100,000.00 0.00 ( 11,472.83) 11.47- 111,472.83 66,500.00 ( 151.14)( 39.99) 0.06- 66,539.99 25,650.00 483.00 16,383.00 63.87 9,267.00 8,000.00 114.41 1,062.94 13.29 6,937.06 200,150.00 446.27 5,933.12 2.96 194,216.88 122,100.00 0.00 0.00 0.00 122,100.00 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 100,000.00 0.00 0.00 0.00 100,000.00 300,000.00 0.00 0.00 0.00 300,000.00 25,000.00 0.00 0.00 0.00 25,000.00 500,000.00 0.00 0.00 0.00 500,000.00 25,000.00 0.00 0.00 0.00 25,000.00 15,000.00 0.00 0.00 0.00 15,000.00 1,161,600.00 0.00 0.00 0.00 1,161,600.00 12,311,900.00 52,009.86 363,564.25 2.95 11,948,335.75 I TOTAL REVENUE 12-311=900.00 ----52=009.86 ---363=564.25 ---2.95 11=948=335-75 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ~ 101-GENERAL FUND I DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 16.67$ OF YEAR COMP. ~ OF BUDGET BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-4109 PERA 101-4-1110-4105 FICA 101-4-1110-4107 Medicare i01-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-9361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,207.99 1,900.00 101.67 2,400.00 111.06 550.00 46.51 50.00 16.25 43,400.00 3,483.48 3,200.00 0.00 3,200.00 0.00 6,415.98 16.66 32,084.02 203.34 10.70 1,696.66 222.12 9.26 2,177.88 93.02 16.91 456.98 16.25 32.50 33.75 6,950.71 16.02 36,449.29 0.00 0.00 3,200.00 0.00 0.00 3,200.00 11,050.00 550.00 1,870.00 16.92 9,180.00 400.00 0.00 0.00 0.00 400.00 2,600.00 0.00 0.00 0.00 2,600.00 17,700.00 3,193.07 3,382.22 19.11 14,317.78 69,450.00 0.00 12,700.75 18.29 56,749.25 16,000.00 0.00 0.00 0.00 16,000.00 8,450.00 2,497.52 2,497.52 29.56 5,952.48 125,650.00 6,240.59 20,950.49 16.28 105,199.51 I TOTAL Mayor & Council Cable TV 172,250.00 9,724.07 27,401.20 15.91 149,848.80 Personal Services 101-4-1120-4101 Regular Pay 57,450.00 4,334.40 6,501.60 11.32 50,948.40 101-4-1120-4103 Part-time Pay 6,500.00 242.25 452.63 6.96 6,047.37 101-4-1120-4104 PERA 4,150.00 314.24 625.41 15.07 3,524.59 101-4-1120-4105 FICA 3,950.00 261.04 522.51 13.23 3,427.49 101-4-1120-4107 Medicare 950.00 61.05 122.20 12.86 827.80 101-4-1120-4108 Insurance 8,700.00 680.00 1,360.00 15.63 7,340.00 101-4-1120-4109 Workers Comp 250.00 64.25 64.25 25.70 185.75 TOTAL Personal Services 81,950.00 5,957.23 9,648.60 11.77 72,301.40 Supplies 101-4-1120-4201 Office Supplies 1,700.00 144.29 156.97 9.23 1,593.03 TOTAL Supplies 1,700.00 144.29 156.97 9.23 1,543.03 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1120-4322 Postage 50.00 0.00 0.00 0.00 50.00 i01-9-1120-4331 Travel, Conferences & Schools 1,250.00 0.00 0.00 0.00 1,250.00 101-4-1120-4404 Equip Repair/Maint Services 1,650.00 0.00 0.00 0.00 1,650.00 TOTAL Other Services & Charges 2,950.00 0.00 0.00 0.00 2,950.00 Capital Outlay TOTAL Cable TV Administrative Services 86,600.00 6,101.52 9,805.57 11.32 76,794.43 Personal Services 101-4-1210-4101 Regular Pay 306,650.00 23,491.66 35,237.49 11.49 271,412.51 101-4-1210-4103 Part-time Pay 41,200.00 2,993.42 4,431.17 10.76 36,768.83 101-4-1210-4104 PERA 25,200.00 1,920.14 3,870.58 15.36 21,329.42 101-4-1210-4105 FICA 21,550.00 1,639.28 3,303.76 15.33 18,246.24 101-4-1210-4107 Medicare 5,050.00 383.37 772.64 15.30 4,277.36 101-4-1210-4108 Insurance 26,650.00 2,303.01 4,642.33 17.42 22,007.67 101-4-1210-4109 Workers Comp 2,100.00 467.50 467.50 22.26 1,632.50 TOTAL Person al Services 428,400.00 33,198.38 52,725.47 12.31 375,674.53 Supplies 101-4-1210-4201 Office Supplies 9,500.00 277.70 531.29 5.59 8,968.71 TOTAL Suppli es 9,500.00 277.70 531.29 5.59 8,968.71 Other Services & Charges 101-4-1210-4319 Other Professional Services 5,500.00 0.00 5,508.00 100.15 ( 8.00) 101-4-1210-4321 Telephone 800.00 0.28 8.35 1.04 791.65 101-4-1210-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1210-4331 Travel, Conferences & Schools 7,300.00 304.01 538.01 7.37 6,761.99 101-4-1210-4334 Car Allowance 4,800.00 369.24 738.48 15.39 4,061.52 101-4-1210-4361 Insurance 300.00 0.00 95.50 15.17 254.50 101-4-1210-4909 Equip Repair/Maint Services 23,550.00 1,084.40 2,635.99 11.19 20,914.01 101-4-1210-4433 Dues & Subscriptions 1,800.00 250.00 250.00 13.89 1,550.00 TOTAL Other Services & Charges 45,050.00 2,007.93 9,724.33 21.59 35,325.67 Capital Outlay TOTAL Administrative Services 482,950.00 35,484.01 62,981.09 13.04 419,968.91 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ' l0i-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ 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 101-4-1220-4560 Equipment TOTAL Capital Outlay 69,200.00 5,323.62 7,985.43 11.59 61,214.57 49,300.00 4,504.01 6,756.02 13.70 42,543.98 8,600.00 712.50 1,417.97 16.49 7,182.03 7,350.00 581.30 1,156.58 15.74 6,193.42 1,700.00 135.94 270.47 15.91 1,429.53 10,750.00 1,164.00 2,328.00 21.66 8,422.00 700.00 164.50 164.50 23.50 535.50 147,600.00 12,585.87 20,078.97 13.60 127,521.03 4,300.00 49.45 1,987.27 46.22 2,312.73 4,300.00 49.45 1,987.27 46.22 2,312.73 3,000.00 0.00 0.00 0.00 3,000.00 550.00 0.00 0.00 0.00 550.00 2,350.00 82.62 82.62 3.52 2,267.38 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 65.00 132.60 13.26 867.40 7,900.00 147.62 215.22 2.72 7,684.78 4,700.00 0.00 0.00 0.00 4,700.00 4,700.00 0.00 0.00 0.00 4,700.00 I TOTAL Human Resources Elections Personal Services 101-4-1230-4103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1230-4322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4404 Equip Repair/Maint Services 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges 164,500.00 12,782.94 22,281.46 13.54 142,218.54 30,000.00 0.00 0.00 0.00 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 4,650.00 0.00 0.00 0.00 4,650.00 4,650.00 0.00 0.00 0.00 9,650.00 600.00 0.00 0.00 0.00 600.00 700.00 0.00 0.00 0.00 700.00 1,000.00 0.00 0.00 0.00 1,000.00 100.00 0.00 0.00 0.00 100.00 1,000.00 0.00 0.00 0.00 1,000.00 3,400.00 0.00 0.00 0.00 3,400.00 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Elections Finance Personal Services 101-4-1310-4101 Regular Pay i01-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-9201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-4-1310-4933 Dues & Subscriptions 101-4-1310-4438 Credit Card Fees TOTAL Other Services & Charges Capital Outlay 38,050.00 0.00 0.00 0.00 38,050.00 293,600.00 22,581.94 33,872.91 11.54 259,727.09 21,300.00 1,637.16 3,258.29 15.30 18,041.71 18,200.00 1,334.16 2,654.61 14.59 15,545.39 4,250.00 312.04 620.86 14.61 3,629.14 26,650.00 2,187.01 4,374.02 16.41 22,275.98 1,800.00 407.75 407.75 22.65 1,392.25 365,800.00 28,460.06 95,188.44 12.35 320,611.56 5,350.00 150.60 547.24 10.23 4,802.76 5,350.00 150.60 547.24 10.23 9,802.76 18,300.00 1,800.00 1,800.00 9.89 16,500.00 50,000.00 0.00 0.00 0.00 50,000.00 400.00 1.88 4.42 l.ll 395.58 2,600.00 0.00 0.00 0.00 2,600.00 2,350.00 100.00 394.00 16.77 1,956.00 950.00 0.00 0.00 0.00 950.00 12,200.00 0.00 10,861.45 89.03 1,338.55 1,500.00 330.00 450.00 30.00 1,050.00 5,000.00 0.00 0.00 0.00 5,000.00 93,300.00 2,231.88 13,509.87 14.48 79,790.13 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 464,450.00 30,842.54 59,245.55 12.76 405,204.45 130,950.00 10,235.93 5,000.00 0.00 9,500.00 742.10 8,450.00 589.14 2,000.00 136.61 20,450.00 1,706.00 800.00 189.00 177,150.00 13,593.78 15,353.89 11.73 115,596.11 0.00 0.00 5,000.00 1,471.14 15.49 8,028.86 1,147.30 13.58 7,302.70 268.32 13.42 1,731.68 3,412.00 16.68 17,038.00 189.00 23.63 611.00 21,841.65 12.33 155,308.35 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1350-4219 Operating Supplies 15,600.00 TOTAL Supplies 15,600.00 Other Services & Charges 101-4-1350-9319 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 20,900.00 TOTAL Other Services & Charges 38,350.00 Capital Outla 737.62 737.62 4.73 14,862.38 737.62 737.62 4.73 14,862.38 0.00 0.00 0.00 8,000.00 364.82 372.46 25.69 1,077.54 0.00 0.00 0.00 8,000.00 664.37 664.37 3.18 20,235.63 1,029.19 1,036.83 2.70 37,313.17 i01-4-1350-4560 Equipment 10,900.00 10,900.00 10,900.00 100.00 TOTAL Capital Outlay 10,900.00 10,900.00 10,900.00 100.00 TOTAL Information Technology Legal Supplies Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 0.00 0.00 242,000.00 26,260.59 34,516.10 19.26 207,483.90 228,000.00 17,885.00 17,885.00 7.84 210,115.00 228,000.00 17,885.00 17,885.00 7.84 210,115.00 TOTAL Legal Community Development Personal Services 101-4-1500-9101 Regular Pay 101-4-1500-9104 PERA 101-4-1500-4105 FICA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services 228,000.00 17,885.00 17,885.00 7.84 210,115.00 53,750.00 4,134.40 6,201.60 11.54 47,548.40 3,900.00 299.74 596.52 15.30 3,303.48 3,350.00 243.24 483.95 14.95 2,866.05 800.00 56.88 113.17 14.15 686.83 6,000.00 521.00 1,042.00 17.37 4,958.00 900.00 74.75 74.75 8.31 825.25 68,700.00 5,330.01 8,511.99 12.39 60,188.01 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1500-4201 Office Supplies 150.00 17.57 TOTAL Supplies 150.00 17.57 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 400.00 0.00 TOTAL Other Services & Charges 400.00 0.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-9107 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 101-4-1510-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1510-4321 Telephone 101-4-1510-9322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4440 Miscellaneous 101-4-1510-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 17.57 11.71 132.43 17.57 11.71 132.43 0.00 0.00 400.00 0.00 0.00 400.00 69,250.00 5,347.58 8,529.56 12.32 60,720.49 216,150.00 16,626.79 24,940.11 11.54 191,209.89 15,700.00 1,205.44 2,399.10 15.28 13,300.90 13,400.00 950.12 1,890.16 14.11 11,509.89 3,150.00 222.20 442.04 14.03 2,707.96 29,150.00 2,442.00 4,884.00 16.75 24,266.00 1,300.00 229.25 229.25 17.63 1,070.75 278,850.00 21,675.75 34,784.66 12.47 249,065.34 4,250.00 153.89 344.07 8.10 3,905.93 1,600.00 0.00 0.00 0.00 1,600.00 200.00 396.74 396.74 198.37 ( 196.74) 6,050.00 550.63 740.81 12.24 5,309.19 800.00 68.22 68.54 8.57 731.46 3,200.00 0.00 0.00 0.00 3,200.00 1,650.00 16.00 490.00 29.70 1,160.00 8,000.00 232.50 232.50 2.91 7,767.50 450.00 0.00 74.50 16.56 375.50 3,600.00 1,898.52 1,848.52 51.35 1,751.48 1,050.00 0.00 80.00 7.62 970.00 250.00 0.00 0.00 0.00 250.00 800.00 66.66 133.32 16.67 666.68 19,800.00 2,231.90 2,927.38 14.78 16,872.62 TOTAL Planning 304,700.00 24,458.28 38,452.85 12.62 266,247.15 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay 101-4-1600-4103 Part-time Pay i01-4-1600-4104 PERA 101-4-1600-4105 FICA 101-4-1600-4107 Medicare 101-9-1600-4108 Insurance 101-4-1600-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone 101-4-1600-4331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4901 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services 101-4-1600-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 108,500.00 8,200.02 12,371.38 11.40 96,128.62 2,500.00 78.09 195.23 7.81 2,304.77 20,800.00 1,317.87 2,017.48 9.70 18,782.52 9,550.00 695.68 1,394.76 14.60 8,155.24 8,200.00 601.11 1,208.72 14.74 6,991.28 1,900.00 140.59 282.67 14.88 1,617.33 17,700.00 1,264.12 2,560.84 14.47 15,139.16 5,550.00 1,276.50 1,276.50 23.00 4,273.50 174,700.00 13,573.98 21,307.58 12.20 153,392.42 4,650.00 0.00 0.00 0.00 4,650.00 1,700.00 417.35 417.35 24.55 1,282.65 29,400.00 1,636.63 4,533.76 15.42 24,866.24 35,750.00 2,053.98 4,951.11 13.85 30,798.89 13,950.00 970.74 1,695.51 12.15 12,254.49 1,500.00 255.00 255.00 17.00 1,245.00 5,100.00 0.00 1,047.25 20.53 4,052.75 36,700.00 2,952.01 3,109.91 8.47 33,590.09 31,150.00 5,446.58 5,869.95 18.84 25,280.05 2,500.00 0.00 0.00 0.00 2,500.00 2,800.00 233.33 466.66 16.67 2,333.34 93,700.00 9,857.66 12,444.28 13.28 81,255.72 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Contingency 304,150.00 25,485.62 38,702.97 12.72 265,447.03 241,550.00 0.00 241,550.00 0.00 0.00 0.00 241,550.00 0.00 0.00 241,550.00 241,550.00 0.00 0.00 0.00 241,550.00 TOTAL General Government 2,798,450.00 194,372.15 319,801.35 11.43 2,478,648.65 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL cUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE L Police Administration Personal Services 101-4-2110-9101 Regular Pay 101-4-2110-4104 PERA i01-4-2110-4107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-9-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-4319 Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-9322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-4361 Insurance 101-4-2110-4409 Equip Repair/Maint Services 101-4-2110-4933 Dues & Subscriptions 101-4-2110-4937 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 280,900.00 21,606.08 32,409.12 11.54 248,990.88 40,450.00 3,111.30 6,192.09 15.31 34,257.91 2,550.00 194.26 386.59 15.16 2,163.41 23,700.00 1,900.00 3,800.00 16.03 19,900.00 69,850.00 14,593.50 14,593.50 22.50 50,256.50 412,450.00 41,405.14 57,381.30 13.91 355,068.70 14,000.00 602.51 602.51 4.30 13,397.49 2,300.00 0.00 2,095.00 91.09 205.00 4,600.00 1,090.30 1,090.30 23.70 3,509.70 20,900.00 1,692.81 3,787.81 18.12 17,112.19 3,400.00 93.36 93.36 2.75 3,306.64 29,300.00 1,694.05 1,797.31 6.13 27,502.69 2,600.00 0.00 0.00 0.00 2,600.00 3,350.00 1,230.00 1,230.00 36.72 2,120.00 500.00 0.00 0.00 0.00 500.00 7,550.00 0.00 2,153.00 28.52 5,397.00 80,400.00 1,183.82 35,006.52 93.54 45,393.48 4,250.00 564.00 764.00 17.98 3,486.00 800.00 0.00 140.25 17.53 659.75 132,150.00 4,765.23 41,184.44 31.16 90,965.56 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PERA 101-4-2120-4107 Medicare 101-4-2120-9108 Insurance TOTAL Personal Services 565,500.00 47,863.18 102,353.55 18.10 463,146.45 1,479,700.00 104,261.61 157,296.58 10.63 1,322,403.42 90,000.00 4,715.71 5,587.92 6.21 84,412.08 226,050.00 15,653.45 31,315.88 13.85 194,734.12 20,400.00 1,290.28 2,582.93 12.66 17,817.07 179,350.00 14,080.00 28,403.59 15.84 150,946.46 1,995,500.00 140,001.05 225,186.85 11.28 1,770,313.15 3-13-2012 09:40 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND Public Safety CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL PAGE: 13 16.670 OF YEAR COMP. s OF BUDGET BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges i01-4-2120-4331 Travel, Conferences & Schools 101-4-2120-4404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-9219 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 143,000.00 260.30 341.92 0.24 142,658.08 22,850.00 ( 77.50) 13,222.50 57.87 9,627.50 63,750.00 6,467.76 6,533.37 10.25 57,216.63 28,000.00 856.23 856.23 3.06 27,143.77 257,600.00 7,506.79 20,954.02 8.13 236,645.98 25,150.00 3,820.00 3,820.00 15.19 21,330.00 26,700.00 1,001.50 1,178.35 4.41 25,521.65 550.00 0.00 40.00 7.27 510.00 44,550.00 3,712.50 7,425.00 16.67 37,125.00 96,950.00 8,534.00 12,463.35 12.86 89,486.65 2,350,050.00 156,041.84 258,604.22 11.00 2,091,495.78 514,100.00 37,731.22 56,596.85 11.01 457,503.15 45,000.00 830.03 1,013.12 2.25 43,986.88 80,500.00 5,487.20 10,816.96 13.44 69,683.04 6,900.00 410.93 819.89 11.88 6,080.11 69,100.00 5,721.57 11,255.60 16.29 57,844.90 715,600.00 50,180.95 80,502.42 11.25 635,097.58 5,350.00 765.00 3,225.00 60.28 2,125.00 12,900.00 0.00 0.00 0.00 12,900.00 18,250.00 765.00 3,225.00 17.67 15,025.00 5,450.00 172.62 172.62 3.17 5,277.38 13,250.00 595.00 995.00 7.51 12,255.00 600.00 0.00 0.00 0.00 600.00 11,600.00 966.67 1,933.34 16.67 9,666.66 30,900.00 1,739.29 3,100.96 10.04 27,799.04 TOTAL Investigations 764,750.00 52,680.24 86,828.38 11.35 677,921.62 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA i01-4-2150-4107 Medicare "O1-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-9201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-4-2150-4409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Police Support Services Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA 101-4-2160-4107 Medicare TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies 342,350.00 25,196.81 37,795.22 11.04 309,559.78 3,500.00 324.28 393.31 11.24 3,106.69 25,100.00 1,850.27 3,644.43 14.52 21,455.57 21,450.00 1,532.40 3,017.52 14.07 18,432.48 5,000.00 358.36 705.68 14.11 4,294.32 59,300.00 4,159.01 8,221.71 13.86 51,078.29 456,700.00 33,421.13 53,777.87 11.78 402,922.13 1,000.00 129.61 124.61 12.46 875.39 3,000.00 101.63 101.63 3.39 2,898.37 19,900.00 1,229.25 1,191.16 7.99 13,708.84 18,900.00 1,955.49 1,417.40 7.50 17,482.60 3,350.00 99.93 99.93 2.98 3,250.07 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 1,149.77 1,149.77 7.19 14,850.23 500.00 165.00 250.00 50.00 250.00 6,200.00 516.67 1,033.34 16.67 5,166.66 27,900.00 1,931.37 2,533.09 9.08 25,366.96 503,500.00 36,807.99 57,728.31 11.47 445,771.69 5,500.00 0.00 0.00 0.00 5,500.00 350.00 0.00 0.00 0.00 350.00 100.00 0.00 0.00 0.00 100.00 5,950.00 0.00 0.00 0.00 5,950.00 3,500.00 952.10 952.10 27.20 2,547.90 5,000.00 40.00 40.00 0.80 4,960.00 8,500.00 992.10 992.10 11.67 7,507.90 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Cther Services & Charges 101-4-2160-4319 Other Professional Services 1,500.00 1,125.00 1,125.00 75.00 375.00 101-4-2160-4321 Telephone 100.00 0.00 0.00 0.00 100.00 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0.00 1,700.00 101-4-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 '_01-4-2160-4433 Dues ~ Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 4,450.00 1,125.00 1,125.00 25.28 3,325.00 Capital Outlay TOTAL Police Reserves 18,900.00 2,117.10 2,117.10 11.20 16,782.90 Public safety building Personal Services 101-4-2190-4101 Regular Pay 104,700.00 7,567.28 11,416.55 10.90 93,283.45 101-4-2190-4104 PERA 7,600.00 548.62 1,108.73 14.59 6,491.27 101-4-2190-4105 FICA 6,500.00 459.85 933.55 14.36 5,566.45 101-4-2190-9107 Medicare 1,500.00 107.55 218.34 14.56 1,281.66 101-4-2190-4108 Insurance 13,700.00 1,144.57 2,367.17 17.28 11,332.83 101-4-2190-4109 Workers Comp 4,550.00 1,044.25 1,044.25 22.95 3,505.75 TOTAL Personal Services 138,550.00 10,872.12 17,088.59 12.33 121,461.41 Supplies 101-4-2190-4219 Operating Supplies 15,000.00 1,729.26 3,825.47 25.50 11,179.53 TOTAL Supplies 15,000.00 1,729.26 3,825.47 25.50 11,174.53 Other Services & Charges 101-4-2190-4361 Insurance 5,550.00 0.00 1,191.50 21.47 4,358.50 101-4-2190-4389 Utilities 19,450.00 1,671.68 1,829.58 9.41 17,620.42 101-4-2190-4401 Bldg Repair/Maint Services 31,600.00 659.94 1,469.30 4.65 30,130.70 TOTAL Other Services & Charges 56,600.00 2,331.62 4,490.38 7.93 52,109.62 Capital Outlay TOTAL Public safety building Fire Administration 210,150.00 14,933.00 25,404.49 12.09 184,745.56 Personal Services 101-4-2310-4101 Regular Pay 91,000.00 7,184.12 10,801.68 11.87 80,198.32 101-4-2310-9103 Part-time Pay 182,250.00 8,995.44 12,509.29 6.86 169,740.71 101-4-2310-4104 PERA 13,750.00 1,032.91 2,079.81 15.13 11,670.19 101-4-2310-4105 FICA 12,250.00 571.77 1,213.30 9.90 11,036.70 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND Public Safety 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2310-4107 Medicare 3,950.00 216.11 447.68 11.33 3,502.32 101-4-2310-9108 Insurance 6,100.00 791.97 1,568.09 25.71 4,531.91 101-4-2310-4109 Workers Comp 23,650.00 7,635.75 7,635.75 32.29 16,014.25 TOTAL Personal Services 362,950.00 26,378.07 36,255.60 9.99 326,694.40 Supplies 101-4-2310-4201 Office Supplies 4,250.00 312.96 312.96 7.36 3,937.04 i01-4-2310-4212 Fuels & Lubs 6,950.00 14.84 14.84 0.21 6,935.16 101-4-2310-4217 Uniform Allowance 7,450.00 0.00 0.00 0.00 7,450.00 101-4-2310-4219 Operating Supplies 32,100.00 1,395.02 2,741.47 8.54 29,358.53 101-4-2310-4221 Equipment Parts 7,000.00 441.29 941.29 6.30 6,558.71 TOTAL Supplies 57,750.00 2,164.11 3,510.56 6.08 54,239.44 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,400.00 0.00 0.00 0.00 5,900.00 101-4-2310-4321 Telephone 3,150.00 213.90 323.52 10.27 2,826.48 101-4-2310-4322 Postage 500.00 0.00 0.00 0.00 500.00 101-4-2310-4331 Travel, Conferences & Schools 17,450.00 5,010.00 5,190.00 29.46 12,310.00 101-9-2310-4359 Publishing 300.00 0.00 0.00 0.00 300.00 101-4-2310-4361 Insurance 16,100.00 0.00 3,386.75 21.04 12,713.25 101-4-2310-4389 Utilities 11,700.00 1,187.46 1,187.46 10.15 10,512.54 101-4-2310-4401 Bldg Repair/Maint Services 5,450.00 160.32 160.32 2.99 5,289.68 101-9-2310-4404 Equip Repair/Maint Services 90,550.00 632.40 1,575.72 3.89 38,974.28 101-4-2310-4433 Dues & Subscriptions 1,400.00 675.00 1,142.00 81.57 258.00 101-4-2310-4460 Equip Replacement Charge 32,800.00 2,733.33 5,466.66 16.67 27,333.34 TOTAL Other Services & Charges 134,800.00 10,612.41 18,382.43 13.64 116,417.57 Capital Outlay TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-9109 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies 555,500.00 39,154.59 58,148.59 10.47 497,351.91 132,350.00 10,168.22 15,252.33 11.52 117,097.67 15,200.00 1,168.60 2,325.73 15.30 12,874.27 3,350.00 267.04 524.17 15.65 2,825.83 1,900.00 146.68 290.42 15.29 1,609.58 15,300.00 1,240.11 2,480.22 16.21 12,819.78 168,100.00 12,990.65 20,872.87 12.42 147,227.13 2,250.00 0.00 0.00 0.00 2,250.00 2,600.00 0.00 0.00 0.00 2,600.00 1,400.00 0.00 0.00 0.00 1,400.00 5,150.00 175.25 175.25 3.40 4,974.75 11,400.00 175.25 175.25 1.54 11,224.75 3-13-2012 04:40 PM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE PAGE: 17 Other Services & Charges 101-4-2320-4321 Telephone 3,350.00 211.49 262.70 7.84 3,087.30 101-4-2320-4331 Travel, Conferences & Schools 2,250.00 0.00 0.00 0.00 2,250.00 101-4-2320-4404 Equip Repair/Maint Services 1,550.00 0.00 484.06 31.23 1,065.94 101-4-2320-4433 Dues & Subscriptions 1,350.00 855.00 855.00 63.33 495.00 TOTAL Other Services & Charges 8,500.00 1,066.99 1,601.76 18.84 6,898.24 TOTAL Fire Inspections 188,000.00 14,232.39 22,649.88 12.05 165,350.12 Emergency Management Personal Services 101-4-2330-4101 Regular Pay 9,400.00 710.20 1,065.30 11.33 8,334.70 101-4-2330-4104 PERA 1,350.00 102.28 203.55 15.08 1,196.45 101-4-2330-4107 Medicare 150.00 10.30 20.50 13.67 129.50 101-4-2330-4108 Insurance 600.00 39.13 78.26 13.04 521.74 TOTAL Personal Services 11,500.00 861.91 1,367.61 11.89 10,132.39 Supplies 101-4-2330-4201 Office Supplies 500.00 0.00 0.00 0.00 500.00 101-4-2330-4219 Operating Supplies 9,150.00 0.00 0.00 0.00 9,150.00 TOTAL Supplies 9,650.00 0.00 0.00 0.00 9,650.00 Other Services & Charges 101-4-2330-4321 Telephone 1,650.00 39.99 39.99 2.42 1,610.01 101-4-2330-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2330-4331 Travel, Conferences & Schools 3,700.00 0.00 0.00 0.00 3,700.00 101-4-2330-4389 Utilities 1,500.00 74.40 74.40 4.96 1,925.60 101-4-2330-4404 Equip Repair/Maint Services 5,800.00 96.19 96.19 1.66 5,703.81 101-4-2330-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 13,750.00 210.58 210.58 1.53 13,539.42 Capital Outlay 101-4-2330-4560 Equipment 69,000.00 0.00 0.00 0.00 69,000.00 TOTAL Capital Outlay 69,000.00 0.00 0.00 0.00 69,000.00 TOTAL Emergency Management Building Safety 103,900.00 1,072.49 1,578.19 1.52 102,321.81 3-13-2012 04:90 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 I 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 16.670 OF YEAR COMP. ~ OF BUDGET BUDGET BALANCE Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4103 Part-time Pay 101-4-2910-4104 PERA 101-4-2410-4105 FICA 101-4-2410-4107 Medicare i01-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2910-4201 Office Supplies 101-4-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2410-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Building Safety Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2940-4109 Workers Comp TOTAL Personal Services 325,750.00 25,058.24 37,587.36 11.54 288,162.64 26,450.00 2,164.67 3,142.66 11.88 23,307.34 25,550.00 1,973.67 3,914.49 15.32 21,635.51 21,850.00 1,596.43 3,164.75 14.48 18,685.25 5,100.00 373.35 740.13 14.51 4,359.87 41,900.00 3,213.01 6,426.02 15.52 34,973.98 1,650.00 382.25 382.25 23.17 1,267.75 447,750.00 34,761.62 55,357.66 12.36 392,392.34 4,300.00 52.98 243.16 5.65 4,056.89 3,200.00 9.54 20.14 0.63 3,179.86 900.00 0.00 0.00 0.00 900.00 1,550.00 93.63 93.63 6.04 1,956.37 9,950.00 156.15 356.93 3.59 9,593.07 1,250.00 95.44 103.41 8.27 1,146.59 400.00 0.00 0.00 0.00 400.00 1,550.00 150.00 185.00 11.94 1,365.00 650.00 0.00 147.50 22.69 502.50 7,700.00 1,731.99 1,921.78 24.96 5,778.22 800.00 215.00 235.00 29.38 565.00 3,300.00 275.00 550.00 16.67 2,750.00 15,650.00 2,467.43 3,142.69 20.08 12,507.31 473,350.00 37,385.20 58,857.28 12.43 414,492.72 31,600.00 2,432.08 3,648.12 11.54 2,300.00 176.34 373.36 16.23 1,950.00 134.56 285.46 14.64 450.00 31.98 66.77 14.84 5,300.00 968.09 978.99 18.47 600.00 140.75 140.75 23.46 42,200.00 3,383.30 5,493.95 13.02 27,951.88 1,926.64 1,664.54 383.23 4,321.01 3-13-2012 04:40 PM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 6.67°s ~ OF BUDGET PAGE: 19 F YEAR COMP. BUDGET BALANCE Supplies 101-4-2440-4201 Office Supplies 500.00 18.94 82.33 16.47 417.67 101-4-2440-4212 Fuels & Lubs 150.00 0.00 12.72 8.48 137.28 TOTAL Supplies 650.00 18.94 95.05 14.62 554.95 Other Services & Charges 101-4-2440-9321 Telephone 550.00 4.65 6.20 1.13 543.80 101-4-2440-4322 Postage 800.00 0.00 0.00 0.00 800.00 101-4-2440-4331 Travel, Conferences & Schools 500.00 0.00 155.00 31.00 345.00 101-4-2440-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2490-4409 Contractual Services 3,000.00 0.00 0.00 0.00 3,000.00 101-4-2940-4433 Dues & Subscriptions 1,050.00 0.00 40.00 3.81 1,010.00 TOTAL Other Services & Charges 6,000.00 4.65 201.20 3.35 5,798.80 TOTAL Environmental 48,850.00 3,406.89 5,789.70 11.85 43,060.30 TOTAL Public Safety Street Maintenance 5,782,450.00 405,694.91 680,059.64 11.76 5,102,390.36 Personal Services 101-4-3120-4101 Regular Pay 386,700.00 25,226.09 40,041.05 10.35 346,658.95 101-4-3120-4102 Overtime Pay 0.00 0.00 116.28 0.'00 ( 116.28) 101-4-3120-4103 Part-time Pay 116,600.00 3,841.69 6,274.69 5.38 110,325.31 101-4-3120-4104 PERA 32,200.00 2,000.18 4,589.88 14.25 27,610.12 101-4-3120-4105 FICA 31,200.00 1,668.47 3,958.44 12.69 27,241.56 101-4-3120-4107 Medicare 7,300.00 390.23 925.80 12.68 6,374.20 101-4-3120-4108 Insurance 64,700.00 3,370.39 9,067.78 14.02 55,632.22 101-4-3120-4109 Workers Comp 27,600.00 6,191:25 6,191.25 22.43 21,408.75 TOTAL Personal Services 666,300.00 42,688.30 71,165.17 10.68 595,134.83 Supplies 101-4-3120-4201 Office Supplies 4,200.00 123.51 136.19 3.24 4,063.81 101-4-3120-4212 Fuels & Lubs 87,250.00 1,246.26 1,141.32 1.31 86,108.68 101-9-3120-4219 Operating Supplies 110,750.00 29,395.77 29,545.07 26.68 81,204.93 101-4-3120-4226 Street Signs 35,850.00 253.36 253.36 0.71 35,596.64 TOTAL Supplies 238,050.00 31,018.90 31,075.94 13.05 206,974.06 Other Services & Charges 101-4-3120-4319 Other Professional Services 250.00 0.00 0.00 0.00 250.00 101-4-3120-9321 Telephone 7,450.00 495.87 618.08 8.30 6,831.92 101-4-3120-4322 Postage 200.00 12.58 12.58 6.29 187.42 101-4-3120-4331 Travel, Conferences & Schools 2,500.00 225.00 225.00 9.00 2,275.00 101-4-3120-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-3120-4361 Insurance 18,750.00 0.00 3,844.00 20.50 14,906.00 101-4-3120-4389 Utilities 36,000.00 3,480.36 3,480.36 9.67 32,519.64 3-13-2012 04:90 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 I 101-GENERAL FUND Public Works ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 16.67$ OF YEAR COMP. °s OF BUDGET BUDGES BALANCE i01-4-3120-4401 Bldg Repair/Maint Services 4,500.00 0.00 0.00 0.00 4,500.00 i01-4-3120-4404 Equip Repair/Maint Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-3120-4409 Contractual Services 419,000.00 0.00 0.00 0.00 419,000.00 101-4-3120-4415 Equipment Rental 5,500.00 96.19 96.19 1.75 5,403.81 101-4-3120-4917 Uniform Rental 4,700.00 152.10 178.44 3.80 4,521.56 101-4-3120-4433 Dues & Subscriptions 350.00 100.00 286.25 81.79 63.75 101-4-3120-4437 Taxes & Licenses 500.00 416.00 416.00 83.20 84.00 101-4-3120-4460 Equip Replacement Charge 95,750.00 7,979.17 15,958.34 16.67 79,791.66 TOTAL Other Services & Charges 600,950.00 12,957.27 25,115.24 4.18 575,834.76 Capital Outlay I TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-9-3130-4103 Part-time Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-9107 Medicare 101-4-3130-4108 Insurance 101-4-3130-9109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 20,000.00 0.00 0.00 0.00 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Snow Removal Equipment Services 1,505,300.00 86,664.47 127,356.35 8.46 1,377,943.65 100,300.00 15,561.20 19,755.13 19.70 80,544.87 20,000.00 406.98 3,683.70 18.42 16,316.30 9,100.00 0.00 0.00 0.00 9,100.00 8,350.00 1,075.63 1,859.24 22.27 6,490.76 8,000.00 896.03 1,601.39 20.02 6,398.61 1,900.00 209.54 374.52 19.71 1,525.48 17,100.00 3,878.92 4,677.70 27.35 12,422.30 7,650.00 1,529.75 1,529.75 20.00 6,120.25 172,400.00 23,558.05 33,481.43 19.42 138,918.57 96,000.00 31,927.64 31,927.64 33.26 64,072.36 96,000.00 31,927.64 31,927.64 33.26 64,072.36 285,400.00 55,485.69 65,909.07 22.68 222,990.93 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 1161-GENERAL FUND Public Works ~ DEPARTMENTAL EXPENDITURES Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 166,050.00 11,557.85 17,944.25 10.81 148,105.75 12,050.00 837.94 1,754.79 14.56 10,295.21 10,300.00 679.96 1,423.15 13.82 8,876.85 2,400.00 159.02 332.83 13.87 2,067.17 23,400.00 1,375.45 3,153.45 13.48 20,246.55 4,500.00 1,027.25 1,027.25 22.83 3,472.75 218,700.00 15,637.47 25,635.72 11.72 193,064.28 20,200.00 6,000.00 26,200.00 3,000.00 3,000.00 893.34 1,101.47 5.45 19,098.53 0.00 0.00 0.00 6,000.00 893.34 1,101.47 4.20 25,098.53 262.15 319.58 10.49 2,685.42 262.15 314.58 10.99 2,685.42 TOTAL Equipment Services Engineering 247,900.00 16,792.96 27,051.77 10.91 220,848.23 Personal Services 101-4-3300-4101 Regular Pay 79,250.00 7,034.62 10,551.93 13.31 68,698.07 101-4-3300-4104 PERA 5,750.00 510.00 1,015.00 17.65 9,735.00 101-4-3300-4105 FICA 4,900.00 421.34 838.40 17.11 4,061.60 101-4-3300-4107 Medicare 1,150.00 98.54 196.08 17.05 953.92 101-4-3300-4108 Insurance 14,050.00 521.00 1,042.00 7.42 13,008.00 101-4-3300-4109 Workers Comp 550.00 194.25 144.25 26.23 405.75 TOTAL Personal Services 105,650.00 8,729.75 13,787.66 13.05 91,862.34 Supplies 101-4-3300-4201 Office Supplies 500.00 0.00 0.00 0.00 500.00 101-4-3300-4212 Fuels & Lubs 600.00 0.00 0.00 0.00 600.00 101-4-3300-4219 Operating Supplies 1,000.00 16.00 16.00 1.60 984.00 TOTAL Supplies 2,100.00 16.00 16.00 0.76 2,084.00 Other Services & Charges 101-4-3300-4319 Other Professional Services 13,500.00 48.00 48.00 0.36 13,452.00 101-4-3300-4321 Telephone 700.00 1.57 6.57 0.94 693.43 101-4-3300-4322 Postage 150.00 0.00 0.00 0.00 150.00 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 0.00 0.00 0.00 2,700.00 101-4-3300-4361 Insurance 200.00 0.00 45.50 22.75 154.50 101-4-3300-4404 Equip Repair/Maint Services 7,800.00 187.03 374.06 4.80 7,425.94 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 125.00 16.67 625.00 TOTAL Other Services & Charges 25,800.00 299.10 599.13 2.32 25,200.87 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ' 101-GENERAL FUND Public Works ' DEPARTMENTAL EXPENDITURES 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' Capital Outlay ' TOTAL Engineering 133,550.00 9,044.85 14,402.79 10.78 119,197.21 TOTAL Public Works Parks Department Personal Services 101-4-5110-4101 Regular Pay i01-4-5110-4102 Overtime 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-5110-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4401 Bldg Repair/Maint Services 101-4-5110-4404 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4960 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,175,150.00 167,987.97 234,219.98 10.77 1,940,930.02 394,300.00 26,899.66 40,349.48 11.72 303,950.52 6,600.00 0.00 310.08 4.70 6,289.92 58,250.00 0.00 0.00 0.00 58,250.00 26,900.00 1,950.20 3,903.64 14.51 22,996.36 25,500.00 1,549.47 3,161.23 12.40 22,338.77 6,000.00 362.36 739.30 12.32 5,260.70 46,200.00 3,878.36 7,756.72 16.79 38,443.28 10,850.00 2,582.00 2,582.00 23.80 8,268.00 524,600.00 37,222.05 58,802.45 11.21 465,797.55 39,100.00 105.85 105.85 0.27 38,994.15 3,200.00 820.70 820.70 25.65 2,379.30 78,250.00 5,251.38 5,336.86 6.82 72,913.14 13,000.00 1,618.09 1,845.71 14.20 11,154.29 133,550.00 7,796.02 8,109.12 6.07 125,440.88 3,800.00 209.07 243.89 6.42 3,556.11 50.00 0.00 0.00 0.00 50.00 3,150.00 954.96 1,549.96 49.21 1,600.04 27,600.00 0.00 6,010.25 21.78 21,589.75 24,700.00 266.64 266.69 1.08 24,433.36 4,000.00 0.00 0.00 0.00 4,000.00 13,100.00 216.66 216.66 1.65 12,883.34 7,300.00 0.00 0.00 0.00 7,300.00 20,500.00 602.26 978.46 4.77 19,521.54 51,450.00 9,287.50 8,575.00 16.67 42,875.00 155,650.00 6,537.09 17,840.86 11.46 137,809.14 TOTAL Parks Department 813,800.00 51,555.16 84,752.43 10.41 729,047.57 3-13-2012 04:40 PM I 101-GENERAL FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' Parks-&-Rec-Admin Personal Services 101-9-5210-4101 Regular Pay 101-9-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-4105 FICA 101-4-5210-4107 Medicare 101-4-5210-9108 Insurance 101-4-5210-9109 Workers Comp TOTAL Personal Services 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-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-4401 Bldq Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Parks & Rec Admin ' Recreation-Programs Personal Services 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare TOTAL Personal Services CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 352,350.00 26,755.17 40,168.43 11.40 312,181.57 21,300.00 3,352.21 9,817.51 22.62 16,482.49 27,200.00 2,182.77 4,312.06 15.85 22,887.94 23,300.00 1,738.26 3,457.39 14.84 19,842.61 5,450.00 406.52 808.56 14.89 4,641.44 52,700.00 3,974.73 7,758.80 14.72 44,941.20 4,450.00 1,026.00 1,026.00 23.06 3,424.00 486,750.00 39,435.66 62,348.75 12.81 424,401.25 10,200.00 2,106.65 2,170.04 21.27 8,029.96 10,200.00 2,106.65 2,170.04 21.27 8,029.96 4,800.00 370.71 6,000.00 0.00 6,850.00 1,203.82 32,400.00 0.00 650.00 0.00 7,400.00 533.47 13,300.00 1,582.02 9,350.00 633.15 1,550.00 0.00 82,300.00 9,323.17 498.95 10.39 4,301.05 0.00 0.00 6,000.00 1,337.82 19.53 5,512.18 1,581.00 4.88 30,819.00 147.50 22.69 502.50 533.47 7.21 6,866.53 2,513.01 18.89 10,786.99 899.39 9.62 8,450.61 0.00 0.00 1,550.00 7,511.14 9.13 74,788.86 579,250.00 45,865.48 72,029.93 12.44 507,220.07 82,000.00 2,371.16 3,617.79 4.41 78,382.21 2,400.00 29.95 49.87 2.08 2,350.13 4,350.00 131.74 232.81 5.35 4,117.19 1,200.00 30.82 54.44 4.54 1,145.56 89,950.00 2,563.67 3,954.91 4.40 85,995.09 3-13-2012 04:40 PM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 PAGE: 24 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5220-4219 Operating Supplies 37,000.00 3,171.53 3,171.53 8.57 33,828.47 TOTAL Supplies 37,000.00 3,171.53 3,171.53 8.57 33,828.47 Other Services & Charges 101-4-5220-4409 Contractual Services 69,050.00 1,500.00 1,500.00 2.34 62,550.00 101-4-5220-4412 Building Rent 1,500.00 0.00 0.00 0.00 1,500.00 101-4-5220-4438 Credit Card Fees 4,500.00 321.92 321.92 7.15 4,178.08 TOTAL Other Services & Charges 70,050.00 1,821.92 1,821.92 2.60 68,228.08 TOTAL Recreation Programs 197,000.00 7,557.12 8,948.36 4.54 188,051.64 Concessions Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 420.00 420.00 11.51 3,230.00 101-4-5230-4109 PERA 150.00 30.44 38.42 25.61 111.58 101-4-5230-4105 FICA 250.00 26.03 32.85 13.14 217.15 101-4-5230-4107 Medicare 50.00 6.09 7.68 15.36 42.32 TOTAL Personal Services 4,100.00 482.56 498.95 12.17 3,601.05 Supplies 101-4-5230-4219 Operating Supplies 2,900.00 0.00 0.00 0.00 2,900.00 101-4-5230-4259 Other Merchandise For Resale 7,000.00 0.00 0.00 0.00 7,000.00 TOTAL Supplies 9,900.00 0.00 0.00 0.00 9,900.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs ------------------ ----------------- Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4103 Part-time Pay 101-4-5510-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 14,100.00 982.56 498.95 3.59 13,601.05 58,550.00 4,504.01 6,756.02 11.54 51,793.98 62,350.00 4,878.01 7,357.93 11.80 54,992.07 8,750.00 680.20 1,359.53 15.54 7,390.47 7,500.00 548.18 1,095.61 14.61 6,404.39 1,750.00 128.19 256.22 14.64 1,493.78 14,100.00 1,154.51 2,309.02 16.38 11,790.98 650.00 145.25 145.25 22.35 504.75 153,650.00 12,038.35 19,279.58 12.55 134,370.42 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 25 ' REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ' 101-GENERAL FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES 16.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 301-4-5510-4322 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-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-5510-4560 Equipment TOTAL Capital Outlay ~ TOTAL Sr Citizen Programs ' TOTAL Culture & Recreation Economic Development Personal Services 101-4-6210-4101 Regular Pay ',101-4-6210-9103 Part-time Pay '101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare '101-4-6210-4108 Insurance .101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-4331 Travel, Conferences & Schools '101-4-6210-4361 Insurance ',101-4-6210-4440 Miscellaneous '~, TOTAL Other Services & Charges TOTAL Economic Development 13,350.00 1,692.23 1,038.05 7.78 12,311.95 13,350.00 1,692.23 1,038.05 7.78 12,311.95 2,600.00 158.72 316.36 12.17 2,283.64 2,500.00 502.24 502.24 20.09 1,997.76 1,900.00 0.00 0.00 0.00 1,900.00 1,600.00 0.00 354.25 22.14 1,245.75 9,300.00 863.69 863.69 9.29 8,436.31 13,750.00 889.04 1,459.64 10.62 12,290.36 1,950.00 181.50 325.78 16.71 1,624.22 7,450.00 ( 74.00)( 163.00) 2.19- 7,613.00 950.00 87.80 299.16 31.49 650.84 92,000.00 2,608.99 3,958.12 9.42 38,041.88 17,500.00 0.00 0.00 0.00 17,500.00 17,500.00 0.00 0.00 0.00 17,500.00 226,500.00 16,339.57 24,275.75 10.72 202,224.25 1,830,650.00 121,799.89 190,505.42 10.41 1,640,144.58 0.00 9,524.68 18,996.79 0.00 ( 18,996.79) 0.00 1,050.33 2,100.66 0.00 ( 2,100.66) 0.00 705.96 1,408.11 0.00 ( 1,408.11) 0.00 598.77 1,194.28 0.00 ( 1,194.28) 0.00 142.22 283.68 0.00 ( 283.68) 0.00 1,991.00 2,982.00 0.00 ( 2,982.00) 0.00 139.25 134.25 0.00 ( 134.25) 0.00 13,647.21 27,099.77 0.00 ( 27,099.77) 0.00 ( 154.00) 0.00 0.00 0.00 0.00 ( 1,965.75) 0.00 0.00 0.00 0.00 ( 6.29) 84.14 0.00 ( 84.14) 0.00 ( 2,126.04) 84.14 0.00 ( 84.14) 0.00 11,521.17 27,183.91 0.00 ( 27,183.91) 3-13-2012 04:40 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 101-GENERAL FUND PAGE: 26 Economic Development 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Energy City Personal Services 101-4-6220-4101 Regular Pay 29,300.00 2,252.48 101-4-6220-4104 PERA 2,100.00 163.32 101-4-6220-4105 FICA 1,800.00 127.82 101-4-6220-4107 Medicare 900.00 29.90 101-4-6220-4108 Insurance 3,250.00 253.36 TOTAL Person al Services 36,850.00 2,826.88 Supplies Other Services & Charges 101-4-6220-4319 Other Professional Services 5,000.00 0.00 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 0.00 101-4-6220-4359 Publishing 1,500.00 0.00 TOTAL Other Services & Charges 14,000.00 0.00 ',TOTAL Energy City TOTAL Economic Development Transfers Out Transfers Out 101-4-7000-4724 Transfer - Pinewood TOTAL Transfers Out 3,378.72 11.53 25,921.28 325.04 15.48 1,774.96 254.27 14.13 1,545.73 59.48 14.87 340.52 506.72 15.59 2,743.28 9,524.23 12.28 32,325.77 0.00 0.00 5,000.00 0.00 0.00 7,500.00 0.00 0.00 1,500.00 0.00 0.00 19,000.00 50,850.00 2,826.88 4,524.23 8.90 46,325.77 50,850.00 14,348.05 31,708.14 62.36 19,141.86 40,500.00 0.00 0.00 0.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers Out ,TOTAL General 40,500.00 0.00 0.00 0.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,678,050.00 904,202.97 1,456,294.53 11.49 11,221,755.47 ( 366,150.00)( 852,193.11)( 1,092,730.28) 726,580.28 3-13-2012 04:90 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 221-ICE ARENA FINANCIAL SUMMARY REVENUE SUMMARY Ice Arena Hockey I Skating Concessions TOTAL REVENUES I EXPENDITURE SUMMARY 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 569,600.00 60,566.46 112,068.81 19.68 457,531.19 30,000.00 23,510.00 26,195.00 87.32 3,805.00 65,800.00 10,182.00 13,751.00 20.90 52,049.00 69,000.00 18,189.30 30,820.05 __44.67 38,179.95 739,400.00 112,942.76 182,834.86 24.90 551,565.14 Culture & Recreation Ice Arena 543,550.00 56,902.85 74,652.78 13.73 468,897.22 Hockey 25,000.00 142.70 142.70 0.57 24,857.30 Skating 28,750.00 1,775.02 2,085.79 7.25 26,669.21 Arena Concessions 47,150.00 6,859.73 9,688.85 20.55 37,461.15 TOTAL Culture & Recreation 644,450.00 65,680.30 86,570.12 13.43 557,879.88 TOTAL EXPENDITURES 644,450.00 65,680.30 86,570.12 13.43 557,879.88 REVENUES OVER/(UNDER) EXPENDITURES 89,950.00 46,762.46 96,264.79 ( 6,314.74) 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ~ 221-ICE ARENA I REVENUES 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s 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-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221-3-0000-3791 ATM Revenue TOTAL Sales TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services 488,000.00 43,041.55 85,311.94 17.48 402,688.06 22,900.00 9,510.50 15,381.50 67.17 7,518.50 17,400.00 153.55 606.55 3.49 16,793.45 4,300.00 976.00 1,695.00 39.42 2,605.00 2,600.00 0.00 0.00 0.00 2,600.00 17,500.00 116.67 116.67 0.67 17,383.33 552,700.00 53,798.27 103,111.66 18.66 449,588.34 14,000.00 2,317.09 0.00 3,997.00 2,800.00 413.15 16,800.00 6,727.24 100.00 40.95 100.00 40.95 4,071.70 29.08 9,928.30 3,997.00 0.00 ( 3,997.00) 815.65 29.13 1,984.35 8,884.35 52.88 7,915.65 72.80 72.80 27.20 72.80 72.80 27.20 569,600.00 60,566.46 112,068.81 19.68 457,531.19 30,000.00 23,510.00 26,195.00 87.32 3,805.00 30,000.00 23,510.00 26,195.00 87.32 3,805.00 30,000.00 23,510.00 26,195.00 87.32 3,805.00 62,000.00 10,182.00 13,751.00 22.18 48,249.00 3,800.00 0.00 0.00 0.00 3,800.00 65,800.00 10,182.00 13,751.00 20.90 52,049.00 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 221-ICE ARENA 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 0*_her Revenue TOTAL Skating 65,800.00 10,182.00 13,751.00 20.90 52,049.00 Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services 69,000.00 69,000.00 18,184.30 18,184.30 30,820.05 30,820.05 94.67 44.67 38,179.95 38,179.95 TOTAL Concessions 69,000.00 18,184.30 30,820.05 44.67 38,179.95 TOTAL REVENUE 734,400.00 112,442.76 182,834.86 24.90 551,565.14 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ~ 221-ICE ARENA ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67°s OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE I Ice-Arena Personal Services 221-4-5400- 4101 Regular Pay 167,600.00 12,739.70 19,109.55 11.40 148,490.95 221-4-5900- 4103 Part-time Pay 59,300.00 7,915.23 11,623.81 19.60 47,676.19 221-4-5400- 4104 PERA 15,700.00 1,184.36 2,319.52 14.77 13,380.48 221-4-5400- 4105 FICA 14,100.00 1,234.49 2,395.33 16.99 11,704.67 221-4-5400 -4107 Medicare 3,350.00 288.70 560.20 16.72 2,789.80 221-4-5400 -4108 Insurance 26,400.00 1,881.00 3,762.00 14.25 22,638.00 221-4-5400 -4109 Workers Comp 8,000.00 1,789.75 1,789.75 22.37 6,210.25 TOTAL Personal Services 294,450.00 27,033.23 41,560.16 14.11 252,889.84 Supplies 221 -4-5400- 4212 Fuels & Lubs 50.00 221 -4-5400- 4217 Uniform Allowance 1,300.00 221 -4-5400- 4219 Operating Supplies 34,250.00 221 -4-5400- 4255 Soft Drinks/Misc 8,000.00 221 -4-5400- 4259 Other Merchandise For Resale 600.00 TOTAL Su pplies 44,200.00 Other Services & Charges 0.00 0.00 0.00 50.00 0.00 0.00 0.00 1,300.00 3,393.32 4,491.44 13.11 29,758.56 2,307.36 2,307.36 28.84 5,692.69 0.00 0.00 0.00 600.00 5,700.68 6,798.80 15.38 37,401.20 221-4-5400- 4321 Telephone 3,500.00 139.50 221-4-5400- 9322 Postage 400.00 0.00 221-4-5400- 9331 Travel, Conferences & Schools 1,000.00 0.00 221-4-5400- 4359 Publishing 2,000.00 0.00 221-4-5400- 4361 Insurance 7,800.00 0.00 221-4-5400- 4389 Utilities 142,450.00 15,244.85 221-4-5900- 4401 Bldg Repair/Maint Services 22,750.00 587.51 221-4-5400- 4409 Contractual Services 1,200.00 0.00 221-4-5400 -4415 Equipment Rental 2,800.00 0.00 221-4-5400 -4433 Dues & Subscriptions 500.00 85.00 TOTAL Other Services & Charges 184,400.00 16,056.86 Capital Outla 197.26 5.64 0.00 0.00 0.00 0.00 0.00 0.00 1,706.50 21.88 15,244.85 10.70 803.13 3.53 0.00 0.00 0.00 0.00 230.00 46.00 18,181.74 9.86 166,218.26 221-4-5400-4560 Equipment 20,500.00 8,112.08 8,112.08 39.57 12,387.92 TOTAL Capital Outlay 20,500.00 8,112.08 8,112.08 39.57 12,387.92 Transfers Out 3,302.74 400.00 1,000.00 2,000.00 6,093.50 127,205.15 21,946.87 1,200.00 2,800.00 270.00 TOTAL Ice Arena 543,550.00 56,902.85 74,652.78 13.73 468,897.22 3-13-2012 09:40 PM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE PAGE: 5 Hockey Personal Services 221-4-5410-9103 Part-time Pay 3,600.00 0.00 0.00 0.00 3,600.00 221-4-5410-4105 FICA 200.00 0.00 0.00 0.00 200.00 221-4-5410-4107 Medicare 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 3,850.00 0.00 0.00 0.00 3,850.00 Supplies 221-9-5410-4219 Operating Supplies 12,550.00 0.00 0.00 0.00 12,550.00 TOTAL Supplies 12,550.00 0.00 0.00 0.00 12,550.00 Other Services & Charges 221-4-5410-4409 Contractual Services 6,400.00 0.00 0.00 0.00 6,400.00 221-4-5410-4438 Credit Card Fees 2,200.00 142.70 142.70 6.49 2,057.30 TOTAL Other Services & Charges 8,600.00 142.70 142.70 1.66 8,457.30 TOTAL Hockey 25,000.00 192.70 142.70 0.57 24,857.30 Skating Personal Services 221-4-5420-4103 Part-time Pay 15,000.00 574.00 837.00 5.58 14,163.00 221-4-5420-4104 PERA 1,000.00 16.10 28.17 2.82 971.83 221-4-5420-4105 FICA 950.00 35.59 64.52 6.79 885.48 221-4-5920-4107 Medicare 200.00 8.33 15.10 7.55 184.90 TOTAL Personal Services 17,150.00 634.02 944.79 5.51 16,205.21 Supplies 221-4-5420-4219 Operating Supplies 5,300.00 965.50 965.50 18.22 4,334.50 TOTAL Supplies 5,300.00 965.50 965.50 18.22 4,334.50 Other Services & Charges 221-4-5420-4359 Publishing 650.00 0.00 0.00 0.00 650.00 221-4-5420-4409 Contractual Services 2,850.00 0.00 0.00 0.00 2,850.00 221-9-5420-4438 Credit Card Fees 2,800.00 175.50 175.50 6.27 2,624.50 TOTAL Other Services & Charges 6,300.00 175.50 175.50 2.79 6,124.50 I TOTAL Skating 28,750.00 1,775.02 2,085.79 7.25 26,664.21 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 221-ICE ARENA Culture & Recreation 16.670 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 2,099.70 3,228.07 15.45 17,671.93 221-4-5430-4104 PERA 200.00 38.94 66.63 33.32 133.37 221-4-5430-4105 FICA 1,300.00 130.17 249.95 19.23 1,050.05 221-4-5430-9107 Medicare 300.00 30.93 58.43 19.98 291.57 TOTAL Personal Services 22,700.00 2,299.24 3,603.08 15.87 19,096.92 Supplies 221-4-5430-4219 Operating Supplies 2,950.00 16.22 89.82 3.04 2,860.18 221-4-5430-4259 Other Merchandise For Resale 21,500.00 4,544.27 5,995.95 27.89 15,504.05 TOTAL Supplies 24,450.00 4,560.49 6,085.77 24.89 18,369.23 TOTAL Arena Concessions 47,150.00 6,859.73 9,688.85 20.55 37,461.15 TOTAL Culture & Recreation 644,450.00 65,680.30 86,570.12 13.43 557,879.88 TOTAL EXPENDITURES 644,450.00 65,680.30 86,570.12 13.43 557,879.88 REVENUES OVER/(UNDER) EXPENDITURES 89,950.00 46,762.46 96,264.74 ( 6,314.74) 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 236,500.00 1,010.00 1,454.00 0.61 235,046.00 TOTAL REVENUES 236,500.00 1,010.00 1,454.00 0.61 235,046.00 ' EXPENDITURE SUMMARY I Culture & Recreation Golf Course 236,500.00 6,975.17 14,985.92 6.34 221,514.08 TOTAL Culture & Recreation 236,500.00 6,975.17 14,985.92 6.34 221,514.08 TOTAL EXPENDITURES 236,500.00 6,975.17 14,985.92 6.34 221,514.08 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 5,965.17)( 13,531.92) 13,531.92 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 222-PINEWOOD GOLF COURSE 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments 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 16,500.00 1,010.00 1,454.00 8.81 15,046.00 16,000.00 0.00 0.00 0.00 16,000.00 3,500.00 0.00 0.00 0.00 3,500.00 120,000.00 0.00 0.00 0.00 120,000.00 16,500.00 0.00 0.00 0.00 16,500.00 18,500.00 0.00 0.00 0.00 18,500.00 5,000.00 0.00 0.00 0.00 5,000.00 196,000.00 1,010.00 1,454.00 0.74 194,546.00 40,500.00 40,500.00 0.00 0.00 0.00 0.00 0.00 0.00 40,500.00 40,500.00 236,500.00 1,010.00 1,454.00 0.61 235,046.00 ~ TOTAL REVENUE 236,500.00 1,010.00 1,454.00 0.61 235,046.00 3-13-2012 04:40 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2012 ~ 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 87,100.00 222-4-5300-4103 Part-time Pay 29,900.00 222-9-5300-4104 PERA 8,500.00 222-4-5300-4105 FICA 7,250.00 222-4-5300-4107 Medicare 1,700.00 222-4-5300-4108 Insurance 6,100.00 222-4-5300-4109 Workers Comp 1,850.00 TOTAL Personal Services 142,400.00 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 222-4-5300-4217 Uniform Allowance 500.00 222-4-5300-4219 Operating Supplies 29,700.00 222-4-5300-4259 Other Merchandise For Resale 12,000.00 TOTAL Supplies 96,700.00 Other Services & Charges 4,808.16 7,212.24 8.28 79,887.76 0.00 0.00 0.00 29,900.00 348.60 693.78 8.16 7,806.22 293.36 587.55 8.10 6,662.45 68.60 137.40 8.08 1,562.60 465.00 930.00 15.25 5,170.00 398.50 398.50 21.54 1,451.50 6,382.22 9,959.47 6.99 132,440.53 0.00 0.00 167.04 167.09 222-4 -5300-4321 Telephone 2,400.00 166.40 222-4 -5300-4331 Travel, Conferences & Schools 450.00 0.00 222-4 -5300-4349 Advertising/Marketing 5,000.00 0.00 222-4 -5300-4361 Insurance 12,100.00 0.00 222-4 -5300-4389 Utilities 6,550.00 181.67 222-4 -5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 222-4 -5300-4404 Equip Repair/Maint Services 4,600.00 0.00 222-4 -5300-4415 Equipment Rental 1,350.00 0.00 222-4 -5300-4437 Taxes & Licenses 1,000.00 5.40 222-4 -5300-4938 Credit Card Fees 5,000.00 52.40 TOTAL Other Services & Charges 47,400.00 925.91 Capital Outlay 0.00 0.00 4,500.00 0.00 0.00 500.00 167.04 0.56 29,532.96 0.00 0.00 12,000.00 167.04 0.36 46,532.96 166.40 6.93 2,233.60 0.00 0.00 450.00 295.00 5.90 4,705.00 2,750.50 22.73 9,349.50 181.67 2.77 6,368.33 20.04 0.22 8,929.96 990.00 21.52 3,610.00 0.00 0.00 1,350.00 403.40 40.34 596.60 52.40 1.05 4,947.60 9,859.41 10.25 42,540.59 TOTAL Golf Course 236,500.00 6,975.17 14,985.92 6.39 221,514.08 TOTAL Culture & Recreation 236,500.00 6,975.17 14,985.92 6.34 221,514.08 ~ TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 236,500.00 6,975.17 14,985.92 6.34 221,514.08 0.00 ( 5,965.17)( 13,531.92) 13,531.92 3-13-2012 04:43 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: FEBRUARY 29TH, 2012 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE ACTIVITY CURRENT BALANCE CLAIM ON CASH 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 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 308-1010 Cash - 1999A GO Bonds 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Cash - 2010A GO Cap Imp Bonds 344-1010 Cash - 2006C Cap Imp Bonds Lby 350-1010 Cash - State-Aid Road Bonds 375-1010 Cash - TIF #19 East Elk River 403-1010 Cash - Street Improvement 404-1010 Cash - Surface Water Managemnt 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 440-1010 Cash - Park Improvement 456-1010 Cash - TIF #16 King/Main 459-1010 Cash - TIF #19 Highway 169 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 23,357.90 2,197.57 25,555.47 5,749,020.90 ( 739,111.49) 5,009,909.41 439,039.86 ( 4,677.46) 434,362.40 2,583.76 43,424.36 46,008.12 ( 3,026.57) ( 7,820.05) ( 10,846.62) 11,747.01 ( 534.50) 11,212.51 867,520.73 8,720.67 876,241.40 695,672.22 0.00 695,672.22 1,284,083.83 1,617.74 1,285,701.57 335,413.80 4,828.04 390,241.84 452,518.69 ( 3,763.00) 448,755.64 1,391,234.48 ( 2,106.82) 1,389,127.66 185,941.23 146,470.23 332,411.46 5,569,542.37 ( 48,632.74) 5,520,909.63 13,756.21 ( 112.64) 13,643.57 144,776.43 0.00 144,776.43 1,033,136.95 150,261.75 1,183,398.70 0.00 25,000.00 25,000.00 112,717.55 ( 94,440.00) 18,277.55 230,203.11 ( 119,725.00) 115,478.11 441,852.19 ( 353,200.00) 88,652.19 655,902.09 ( 503,637.50) 152,264.59 ( 2,000.00) ( 179,622.50) ( 181,622.50) 6,496.01 ( 6,496.01) 0.00 0.00 ( 77,862.50) ( 77,862.50) 4,934,267.57 ( 89,180.00) 4,845,087.57 279,726.91 ( 2,223.53) 277,503.38 4,188,011.01 15,000.00 4,203,011.01 1,132,807.57 10,763.08 1,143,570.65 1,109,714.71 0.00 1,109,714.71 84,534.29 ( 859.34) 83,674.95 0.00 4,968.78 4,968.78 543,583.14 ( 1,462.50) 542,120.64 5,070,332.10 ( 134,334.78) 4,935,997.32 1,615,212.55 3,481.98 1,618,694.53 554,550.31 7,648.29 562,198.60 0.00 54,892.19 54,892.19 58,866.40 1,954.00 .60,820.40 39,213,097.26 ( 1,883,573.68) 37,329,523.58 IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH 31,791,858.86 ( 1,115,726.12) 30,676,132.74 (20,960,951.16) ( 767,847.56) (21,728,798.72) 28,382,189.56 0.00 28,382,189.56 39,213,097.26 ( 1,883,573.68) 37,329,523.58