The URL can be used to link to this page

INFORMATION 03-18-2013 )40,# INFORMATION City of Elk River MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: March 18, 2013 SUBJECT: February 2013 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Arena and Pinewood Golf Special Revenue Funds. These funds 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 about 16.7%of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Revenues: • Property taxes, our largest revenue source,will be received in July and December. • Intergovernmental revenue collections consist of the first half state-aid street maintenance payment. The second half will be received mid-year. • The first half Otsego fire contract was billed in February and is reflected in charges for services. • The negative interest income is related to the reversal of the prior year's interest receivable which was done as of January. • The transfer received in February from Elk River Utilities is for January electric billings. All other transfers will be recorded mid-year. Expenditures: • Excluding transfers,total departmental expenditures are 12% of budget and almost all departments are within or below budget. • The Snow Removal budget reflects the seasonal expenditures for personal services and road salt. • The Transfers Out to Pinewood Golf will be made at the end of the year. 2013 Monthly Expenditures $14,000 $12,000 o $10,000 z 1, $8,000 0 $6,000 $4,000 $2,000 _ = $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec mm Actual $617 $1,541 ...**Budget $1,070 $2,139 $3,209 $4,279 $5,349 $6,418 $7,488 $8,558 $9,628 $10,69 $11,76 $12,83 Ice Arena For February,revenues exceed expenditures by$23,718. Excluding transfers, revenues are 13% of budget and February collections consist mainly of hockey program registrations and concessions. Expenditures are well within budget estimates at about 8%. Pinewood Golf Golf program registrations for spring/summer are beginning to generate revenue for the golf course,but golf course fees will not be generated until early spring. Expenditures are slightly over 6% of the budget due mainly to personal services and insurance. Attachments: • General Fund Revenue&Expense Report • Enterprise Funds—Budget to Actual • Cash Report—All Funds 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UTAUDI01D) INFORMATION AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,636,950.00 333,416.00 403,216.93 3.19 12,233,733.07 TOTAL REVENUES 12,636,950.00 333,416.00 403,216.93 3.19 12,233,733.07 EXPENDITURE SUMMARY General Government Mayor & Council 151,500.00 6,572.85 24,457.98 16.14 127,042.02 Cable TV 87,550.00 6,332.05 10,221.18 11.67 77,328.82 Administrative Services 588,250.00 40,125.13 66,831.35 11.36 521,418.65 Human Resources 98,950.00 6,760.05 11,338.76 11.46 87,611.24 Finance 537,850.00 34,492.72 69,879.36 12.99 467,970.64 Information Technology 296,700.00 28,427.61 36,697.32 12.37 260,002.68 Legal 228,000.00 13,980.50 13,980.50 6.13 214,019.50 Community Development 213,800.00 14,335.64 21,463.58 10.04 192,336.42 Planning 236,700.00 16,148.11 27,519.00 11.63 209,181.00 City Hall Maintenance 517,350.00 40,135.83 62,746.95 12.13 454,603.05 Contingency 8,400.00 0.00 0.00 0.00 8,400.00 TOTAL General Government 2,965,050.00 207,310.49 345,135.98 11.64 2,619,914.02 Public Safety Police Administration 637,350.00 36,510.88 107,757.98 16.91 529,592.02 Patrol 2,362,450.00 173,621.47 257,769.01 10.91 2,104,680.99 Investigations 772,250.00 56,023.02 86,372.46 11.18 685,877.54 Police Support Services 500,650.00 35,588.53 55,629.11 11.11 445,020.89 Police Reserves 21,600.00 475.00 475.00 2.20 21,125.00 Public safety building 76,000.00 6,078.30 11,288.47 14.85 64,711.53 Fire Administration 276,100.00 20,227.96 40,939.13 14.83 235,160.87 Fire Operations 363,350.00 16,551.66 23,531.82 6.48 339,818.18 Emergency Management 28,800.00 159.74 159.74 0.55 28,640.26 Building Safety 663,600.00 49,866.87 79,742.25 12.02 583,857.75 Code Enforcement 85,050.00 6,823.86 9,735.13 11.45 75,314.87 Environmental 52,350.00 2,309.25 3,227.17 6.16 49,122.83 TOTAL Public Safety 5,839,550.00 404,236.54 676,627.27 11.59 5,162,922.73 Public Works Street Maintenance 1,530,200.00 95,184.70 178,654.92 11.68 1,351,545.08 Snow Removal 285,700.00 53,114.59 61,917.81 21.67 223,782.19 Equipment Services 252,750.00 15,883.38 27,534.92 10.89 225,215.08 Engineering _ 173,350.00 13,905.86 21,865.22 12.61 151,484.78 TOTAL Public Works 2,242,000.00 178,088.53 289,972.87 12.93 1,952,027.13 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 807,450.00 51,307.41 85,464.59 10.58 721,985.41 Parks & Rec Admin 522,100.00 36,958.96 66,811.69 12.80 455,288.31 Recreation Programs 196,500.00 5,126.35 12,339.64 6.28 184,160.36 Sr Citizen Programs 188,050.00 14,539.04 22,521.93 11.98 165,528.07 TOTAL Culture & Recreation 1,714,100.00 107,931.76 187,137.85 10.92 1,526,962.15 Economic Development Economic Development 0.00 7,866.08 39,503.90 0.00 ( 39,503.90) Energy City 31,450.00 1,589.82 2,255.75 7.17 29,194.25 TOTAL Economic Development 31,450.00 9,455.90 41,759.65 132.78 ( 10,309.65) General Transfers Out 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL General 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL EXPENDITURES 12,836,950.00 907,023.22 1,540,633.62 12.00 11,296,316.38 REVENUES OVER/(UNDER) EXPENDITURES ( 200,000.00) ( 573,607.22) ) 1,137,416.69) 937,416.69 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,203,100.00 0.00 0.00 0.00 9,203,100.00 101-3-0000-3121 Gravel Tax 84,000.00 0.00 0.00 0.00 84,000.00 TOTAL Taxes 9,287,100.00 0.00 0.00 0.00 9,287,100.00 Licenses & Permits 101-3-0000-3211 Liquor License 61,500.00 0.00 0.00 0.00 61,500.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 25,000.00 4,334.00 5,284.00 21.14 19,716.00 101-3-0000-3216 Mining License 21,000.00 0.00 0.00 0.00 21,000.00 101-3-0000-3217 Garbage Hauler License 1,900.00 0.00 210.00 11.05 1,690.00 101-3-0000-3218 Other Business License/Permit 17,000.00 250.00 1,110.00 6.53 15,890.00 101-3-0000-3229 NPDES Permit 2,500.00 875.00 1,750.00 70.00 750.00 101-3-0000-3231 Building Permit 220,000.00 11,990.35 23,856.55 10.84 196,143.45 101-3-0000-3232 Plumbing/Heating Permit 190,000.00 3,443.85 8,581.84 4.52 181,418.16 101-3-0000-3233 Permit Surcharge 500.00 ( 51.23) 873.98 174.80 ( 373.98) 101-3-0000-3235 Animal License 4,500.00 190.00 870.00 19.33 3,630.00 101-3-0000-3236 Parking Permit 2,000.00 97.43 137.43 6.87 1,862.57 101-3-0000-3237 Other Non-Business Lic/Permit 8,500.00 500.00 500.00 5.88 8,000.00 TOTAL Licenses & Permits 558,400.00 21,629.40 43,173.80 7.73 515,226.20 Intergovernmental Rev 101-3-0000-3311 Federal Grant 2,300.00 0.00 0.00 0.00 2,300.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 210,000.00 0.00 0.00 0.00 210,000.00 101-3-0000-3326 Police Training Reimb 11,100.00 0.00 0.00 0.00 11,100.00 101-3-0000-3327 State-Aid Street Maint 287,600.00 145,385.02 145,385.02 50.55 142,214.98 101-3-0000-3329 State Crime Prevention Grant 20,000.00 ( 15,652.68) 0.01 0.00 19,999.99 101-3-0000-3330 Other State Grants 600.00 0.00 0.00 0.00 600.00 TOTAL Intergovernmental Rev 545,600.00 129,732.34 145,385.03 26.65 400,214.97 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 825.00 1,315.00 8.77 13,685.00 101-3-0000-3413 Plan Check Fee 85,000.00 5,474.42 11,013.96 12.96 73,986.04 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 380.00 38.00 620.00 101-3-0000-3417 Copies 2,600.00 287.36 433.36 16.67 2,166.64 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 640.00 1,020.00 13.60 6,480.00 101-3-0000-3431 Police Services 2,000.00 80.00 100.00 5.00 1,900.00 101-3-0000-3432 School Liaison 75,000.00 0.00 0.00 0.00 75,000.00 101-3-0000-3434 Animal Impound Fee 3,500.00 225.00 425.00 12.14 3,075.00 101-3-0000-3436 Fire Contracts 201,000.00 90,510.72 90,510.72 45.03 110,489.28 101-3-0000-3437 Fire Calls 3,000.00 10.70 10.70 0.36 2,989.30 101-3-0000-3451 Street Services 30,000.00 80.00 80.00 0.27 29,920.00 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3452 Engineering Services Reimb 104,900.00 0.00 0.00 0.00 104,900.00 101-3-0000-3461 Recreation Fees 126,000.00 11,088.69 17,331.35 13.76 108,668.65 101-3-0000-3462 Sr Center Activities 0.00 4,140.00 6,537.00 0.00 ( 6,537.00) 101-3-0000-3472 Park Use Fee 15,000.00 1,237.82 2,087.82 13.92 12,912.18 101-3-0000-3474 Facility Use Fee 5,700.00 0.00 0.00 0.00 5,700.00 101-3-0000-3475 Building Rent 2,400.00 200.00 400.00 16.67 2,000.00 101-3-0000-3483 Sewer Inspection Fee 3,000.00 195.00 585.00 19.50 2,415.00 101-3-0000-3484 Contractor License Check 400.00 40.00 65.00 16.25 335.00 TOTAL Charges for Services 687,000.00 115,107.71 132,307.91 19.26 554,692.09 Fines & Forfeits 101-3-0000-3510 Court Fines 115,000.00 7,393.39 7,393.39 6.43 107,606.61 101-3-0000-3511 Parking Fines 12,000.00 2,680.00 4,590.00 38.25 7,410.00 101-3-0000-3512 Ordinance Violations 200.00 0.00 0.00 0.00 200.00 TOTAL Fines & Forfeits 127,200.00 10,073.39 11,983.39 9.42 115,216.61 Special Assessments 101-3-0000-3610 Special Assmts-County 0.00 ( 1,320.65) 0.00 0.00 0.00 TOTAL Special Assessments 0.00 ( 1,320.65) 0.00 0.00 0.00 Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 ( 1,974.42) 1.97- 101,974.42 101-3-0000-3625 Refunds & Reimbursements 66,500.00 98.75 98.75 0.15 66,401.25 101-3-0000-3626 Contributions 25,000.00 0.00 14,000.00 56.00 11,000.00 101-3-0000-3629 Miscellaneous Revenue 6,000.00 1,089.73 1,237.14 20.62 4,762.86 TOTAL Other Revenue 197,500.00 1,188.48 13,361.47 6.77 184,138.53 Transfers In 101-3-0000-3921 Transfers 112,900.00 0.00 0.00 0.00 112,900.00 101-3-0000-3925 Transfer-Landfill 35,000.00 0.00 0.00 0.00 35,000.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 0.00 0.00 39,500.00 101-3-0000-3930 Transfer-Development 48,600.00 0.00 0.00 0.00 48,600.00 101-3-0000-3942 Transfer-WWTS 100,000.00 0.00 0.00 0.00 100,000.00 101-3-0000-3943 Transfer-Liquor 330,000.00 0.00 0.00 0.00 330,000.00 101-3-0000-3944 Transfer-Garbage 25,000.00 0.00 0.00 0.00 25,000.00 101-3-0000-3945 Transfer-Utilities 500,000.00 57,005.33 57,005.33 11.40 442,994.67 101-3-0000-3948 Transfer-EDA 25,000.00 0.00 0.00 0.00 25,000.00 101-3-0000-3949 Transfer-HRA 18,150.00 0.00 0.00 0.00 18,150.00 TOTAL Transfers In 1,234,150.00 57,005.33 57,005.33 4.62 1,177,144.67 TOTAL General Fund 12,636,950.00 333,416.00 403,216.93 3.19 12,233,733.07 TOTAL REVENUE 12,636,950.00 333,416.00 403,216.93 3.19 12,233,733.07 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Mayor & Council CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 2,624.99 5,249.98 13.64 33,250.02 101-4-1110-4104 PERA 1,900.00 70.84 141.68 7.46 1,758.32 101-4-1110-4105 FICA 2,400.00 111.09 222.18 9.26 2,177.82 101-4-1110-4107 Medicare 550.00 38.06 76.12 13.84 473.88 101-4-1110-4109 Workers Comp 100.00 0.00 18.50 18.50 81.50 TOTAL Personal Services 43,450.00 2,844.98 5,708.46 13.14 37,741.54 Supplies 101-4-1110-4201 Office Supplies 3,000.00 608.94 708.01 23.60 2,291.99 TOTAL Supplies 3,000.00 608.94 708.01 23.60 2,291.99 Other Services & Charges 101-4-1110-4319 Other Professional Services 16,500.00 2,213.90 2,213.90 13.42 14,286.10 101-4-1110-4322 Postage 400.00 0.00 549.08 137.27 ( 149.08) 101-4-1110-4331 Travel, Conferences & Schools 4,100.00 0.00 0.00 0.00 4,100.00 101-4-1110-4359 Publishing 3,700.00 661.50 661.50 17.88 3,038.50 101-4-1110-4361 Insurance 53,000.00 0.00 14,373.50 27.12 38,626.50 101-4-1110-4433 Dues & Subscriptions 16,550.00 0.00 0.00 0.00 16,550.00 101-4-1110-4440 Miscellaneous 10,800.00 243.53 243.53 2.25 10,556.47 TOTAL Other Services & Charges 105,050.00 3,118.93 18,041.51 17.17 87,008.49 Capital Outlay TOTAL Mayor & Council 151,500.00 6,572.85 24,457.98 16.14 127,042.02 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Cable TV CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1120-4101 Regular Pay 59,700.00 4,593.60 6,660.72 11.16 53,039.28 101-4-1120-4103 Part-time Pay 6,750.00 156.00 312.00 4.62 6,438.00 101-4-1120-4104 PERA 4,350.00 333.04 662.50 15.23 3,687.50 101-4-1120-4105 FICA 4,100.00 253.19 506.50 12.35 3,593.50 101-4-1120-4107 Medicare 950.00 59.22 118.46 12.47 831.54 101-4-1120-4108 Insurance 9,150.00 951.00 1,902.00 20.79 7,248.00 101-4-1120-4109 Workers Comp 300.00 ( 14.00) 59.00 19.67 241.00 TOTAL Personal Services 85,300.00 6,332.05 10,221.18 11.98 75,078.82 Supplies 101-4-1120-4201 Office Supplies 800.00 0.00 0.00 0.00 800.00 TOTAL Supplies 800.00 0.00 0.00 0.00 800.00 Other Services & Charges 101-4-1120-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-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 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 1,450.00 0.00 0.00 0.00 1,450.00 Capital Outlay TOTAL Cable TV 87,550.00 6,332.05 10,221.18 11.67 77,328.82 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Administrative Services CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1210-4101 Regular Pay 361,450.00 27,802.54 40,313.71 11.15 321,136.29 101-4-1210-4103 Part-time Pay 43,350.00 3,071.74 4,436.17 10.23 38,913.83 101-4-1210-4104 PERA 29,350.00 2,230.78 4,314.14 14.70 25,035.86 101-4-1210-4105 FICA 25,100.00 1,891.97 3,663.30 14.59 21,436.70 101-4-1210-4107 Medicare 5,850.00 442.48 856.74 14.65 4,993.26 101-4-1210-4108 Insurance 31,550.00 2,542.04 4,376.07 13.87 27,173.93 101-4-1210-4109 Workers Comp 2,350.00 95.00 709.50 30.19 1,640.50 TOTAL Personal Services 499,000.00 38,076.55 58,669.63 11.76 440,330.37 Supplies 101-4-1210-4201 Office Supplies 11,500.00 762.15 974.83 8.48 10,525.17 TOTAL Supplies 11,500.00 762.15 974.83 8.48 10,525.17 Other Services & Charges 101-4-1210-4319 Other Professional Services 6,100.00 0.00 327.00 5.36 5,773.00 101-4-1210-4321 Telephone 350.00 50.12 54.69 15.63 295.31 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,600.00 457.66 696.16 9.16 6,903.84 101-4-1210-4334 Car Allowance 4,800.00 400.00 800.00 16.67 4,000.00 101-4-1210-4359 Publishing 14,000.00 0.00 3,011.00 21.51 10,989.00 101-4-1210-4361 Insurance 200.00 0.00 65.50 32.75 134.50 101-4-1210-4404 Equip Repair/Maint Services 24,000.00 370.69 1,954.58 8.14 22,045.42 101-4-1210-4433 Dues & Subscriptions 700.00 7.96 277.96 39.71 422.04 TOTAL Other Services & Charges 58,750.00 1,286.43 7,186.89 12.23 51,563.11 Capital Outlay 101-4-1210-4560 Equipment 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Capital Outlay 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Administrative Services 588,250.00 40,125.13 66,831.35 11.36 521,418.65 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Human Resources CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 70,600.00 5,430.08 7,873.64 11.15 62,726.36 101-4-1220-4104 PERA 5,100.00 393.68 936.18 18.36 4,163.82 101-4-1220-4105 FICA 4,400.00 326.84 778.30 17.69 3,621.70 101-4-1220-4107 Medicare 1,000.00 76.44 182.02 18.20 817.98 101-4-1220-4108 Insurance 6,250.00 525.01 1,453.62 23.26 4,796.38 101-4-1220-4109 Workers Comp 400.00 8.00 115.00 28.75 285.00 TOTAL Personal Services 87,750.00 6,760.05 11,338.76 12.92 76,411.24 Supplies 101-4-1220-4201 Office Supplies 4,500.00 0.00 0.00 0.00 4,500.00 TOTAL Supplies 4,500.00 0.00 0.00 0.00 4,500.00 Other Services & Charges 101-4-1220-4319 Other Professional Services 2,000.00 0.00 0.00 0.00 2,000.00 101-4-1220-4322 Postage 900.00 0.00 0.00 0.00 900.00 101-4-1220-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00 101-4-1220-4433 Dues & Subscriptions 800.00 0.00 0.00 0.00 800.00 TOTAL Other Services & Charges 6,700.00 0.00 0.00 0.00 6,700.00 Capital Outlay TOTAL Human Resources 98,950.00 6,760.05 11,338.76 11.46 87,611.24 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Elections CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies Other Services & Charges Capital Outlay 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Finance CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1310-4101 Regular Pay 299,450.00 23,033.46 33,554.50 11.21 265,895.50 101-4-1310-4103 Part-time Pay 50,300.00 4,593.61 6,660.73 13.24 . 43,639.27 101-4-1310-4104 PERA 25,350.00 1,986.88 3,821.30 15.07 21,528.70 101-4-1310-4105 FICA 21,700.00 1,659.36 3,163.50 14.58 18,536.50 101-4-1310-4107 Medicare 5,100.00 388.07 739.85 14.51 4,360.15 101-4-1310-4108 Insurance 30,500.00 2,518.02 4,632.44 15.19 25,867.56 101-4-1310-4109 Workers Comp 2,050.00 ( 8.00) 523.00 25.51 1,527.00 TOTAL Personal Services 434,450.00 34,171.40 53,095.32 12.22 381,354.68 Supplies 101-4-1310-4201 Office Supplies 6,900.00 0.00 209.57 3.04 6,690.43 TOTAL Supplies 6,900.00 0.00 209.57 3.04 6,690.43 Other Services & Charges 101-4-1310-4301 Audit Fees 18,300.00 0.00 2,640.00 14.43 15,660.00 101-4-1310-4319 Other Professional Services 53,500.00 0.00 0.00 0.00 53,500.00 101-4-1310-4321 Telephone 350.00 1.78 2.74 0.78 347.26 101-4-1310-4322 Postage 2,300.00 0.00 0.00 0.00 2,300.00 101-4-1310-4331 Travel, Conferences & Schools 2,450.00 0.00 238.50 9.73 2,211.50 101-4-1310-4359 Publishing 600.00 0.00 0.00 0.00 600.00 101-4-1310-4404 Equip Repair/Maint Services 12,500.00 1.36 13,254.25 106.03 ( 754.25) 101-4-1310-4433 Dues & Subscriptions 1,500.00 0.00 0.00 0.00 1,500.00 101-4-1310-4438 Credit Card Fees 4,000.00 241.98 241.98 6.05 3,758.02 101-4-1310-4440 Miscellaneous 1,000.00 76.20 197.00 19.70 803.00 TOTAL Other Services & Charges 96,500.00 321.32 16,574.47 17.18 79,925.53 Capital Outlay TOTAL Finance 537,850.00 34,492.72 69,879.36 12.99 467,970.64 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Information Technology CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1350-4101 Regular Pay 138,450.00 10,704.40 15,497.69 11.19 122,952.31 101-4-1350-4103 Part-time Pay 13,500.00 0.00 0.00 0.00 13,500.00 101-4-1350-4104 PERA 11,000.00 776.08 1,539.98 14.00 9,460.02 101-4-1350-4105 FICA 9,400.00 607.95 1,208.30 12.85 8,191.70 101-4-1350-4107 Medicare 2,200.00 142.18 282.58 12.84 1,917.42 101-4-1350-4108 Insurance 21,450.00 1,741.02 3,482.04 16.23 17,967.96 101-4-1350-4109 Workers Comp 800.00 ( 19.00) 211.75 26.47 588.25 TOTAL Personal Services 196,800.00 13,952.63 22,222.34 11.29 174,577.66 Supplies 101-4-1350-4219 Operating Supplies 20,800.00 2,015.70 2,015.70 9.69 18,784.30 TOTAL Supplies 20,800.00 2,015.70 2,015.70 9.69 18,784.30 Other Services & Charges 101-4-1350-4319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-1350-4321 Telephone 1,800.00 120.00 120.00 6.67 1,680.00 101-9-1350-4331 Travel, Conferences & Schools 6,200.00 91.53 91.53 1.48 6,108.47 101-4-1350-4404 Equip Repair/Maint Services 40,200.00 1,347.75 1,347.75 3.35 38,852.25 TOTAL Other Services & Charges 53,200.00 1,559.28 1,559.28 2.93 51,640.72 Capital Outlay 101-4-1350-4560 Equipment 25,900.00 10,900.00 10,900.00 42.08 15,000.00 TOTAL Capital Outlay 25,900.00 10,900.00 10,900.00 42.08 15,000.00 TOTAL Information Technology 296,700.00 28,427.61 36,697.32 12.37 260,002.68 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Legal CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 228,000.00 13,980.50 13,980.50 6.13 214,019.50 TOTAL Other Services & Charges 228,000.00 13,980.50 13,980.50 6.13 214,019.50 TOTAL Legal 228,000.00 13,980.50 13,980.50 6.13 214,019.50 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Community Development CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1500-4101 Regular Pay 164,200.00 11,771.14 16,690.48 10.16 147,509.52 101-4-1500-4104 PERA 11,900.00 853.42 1,374.93 11.55 10,525.07 101-4-1500-4105 FICA 10,200.00 720.54 1,151.53 11.29 9,048.47 101-4-1500-4107 Medicare 2,400.00 168.52 269.31 11.22 2,130.69 101-4-1500-4108 Insurance 23,500.00 825.02 1,350.03 5.74 22,149.97 101-4-1500-4109 Workers Comp 1,200.00 ( 3.00) 317.25 26.44 882.75 TOTAL Personal Services 213,400.00 14,335.64 21,153.53 9.91 192,246.47 Supplies 101-4-1500-4201 Office Supplies 0.00 0.00 71.55 0.00 ( 71.55) TOTAL Supplies 0.00 0.00 71.55 0.00 ( 71.55) Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 400.00 0.00 238.50 59.63 161.50 TOTAL Other Services & Charges 400.00 0.00 238.50 59.63 161.50 TOTAL Community Development 213,800.00 14,335.64 21,463.58 10.04 192,336.42 3-13-2013 08:37 AM CITY- OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Planning CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1510-4101 Regular Pay 154,250.00 11,864.16 17,203.09 11.15 137,046.91 101-4-1510-4103 Part-time Pay 14,550.00 0.00 0.00 0.00 14,550.00 101-4-1510-4104 PERA 12,250.00 860.16 1,892.11 15.45 10,357.89 101-4-1510-4105 FICA 10,450.00 674.46 1,504.37 14.40 8,945.63 101-4-1510-4107 Medicare 2,450.00 157.74 351.83 14.36 2,098.17 101-4-1510-4108 Insurance 21,450.00 1,741.02 3,659.12 17.06 17,790.88 101-4-1510-4109 Workers Comp 950.00 ( 4.00) 196.25 20.66 753.75 TOTAL Personal Services 216,350.00 15,293.54 24,806.77 11.47 191,543.23 Supplies 101-4-1510-4201 Office Supplies 4,450.00 0.00 0.00 0.00 4,450.00 101-4-1510-4212 Fuels & Lubs 0.00 296.86 296.86 0.00 ( 296.86) TOTAL Supplies 4,450.00 296.86 296.86 6.67 4,153.14 Other Services & Charges 101-4-1510-4321 Telephone 400.00 53.05 53.16 13.29 346.84 101-4-1510-4322 Postage 2,200.00 0.00 0.00 0.00 2,200.00 101-4-1510-4331 Travel, Conferences & Schools 1,650.00 0.00 276.50 16.76 1,373.50 101-4-1510-4359 Publishing 8,000.00 97.50 97.50 1.22 7,902.50 101-4-1510-4361 Insurance 0.00 0.00 65.50 0.00 ( 65.50) 101-4-1510-4404 Equip Repair/Maint Services 2,400.00 407.16 1,922.71 80.11 477.29 101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1510-4440 Miscellaneous 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 15,900.00 557.71 2,415.37 15.19 13,484.63 Capital Outlay TOTAL Planning 236,700.00 16,148.11 27,519.00 11.63 209,181.00 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. City Hall Maintenance CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1600-4101 Regular Pay 281,150.00 21,122.02 30,815.26 10.96 250,334.74 101-4-1600-4102 Overtime Pay 3,500.00 415.38 415.38 11.87 3,084.62 101-4-1600-4103 Part-time Pay 26,550.00 1,794.00 2,484.69 9.36 24,065.31 101-4-1600-4104 PERA 22,550.00 1,676.81 3,345.77 14.84 19,204.23 101-4-1600-4105 FICA 19,300.00 1,468.12 2,897.07 15.01 16,402.93 101-4-1600-4107 Medicare 4,500.00 343.34 677.54 15.06 3,822.46 101-4-1600-4108 Insurance 32,500.00 2,617.03 5,234.06 16.10 27,265.94 101-4-1600-4109 Workers Comp 10,300.00 ( 221.00) 2,445.25 23.74 7,854.75 TOTAL Personal Services 400,350.00 29,215.70 48,315.02 12.07 352,034.98 Supplies 101-4-1600-4212 Fuels & Lubs 4,000.00 185.43 200.27 5.01 3,799.73 101-4-1600-4217 Uniform Allowance 1,700.00 69.99 67.98 4.00 1,632.02 101-4-1600-4219 Operating Supplies 27,000.00 4,929.50 5,347.64 19.81 21,652.36 TOTAL Supplies 32,700.00 4,684.92 5,615.89 17.17 27,084.11 Other Services & Charges 101-4-1600-4321 Telephone 11,000.00 1,040.42 1,768.96 16.08 9,231.04 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,400.00 0.00 1,225.50 27.85 3,174.50 101-4-1600-4389 Utilities 34,200.00 3,680.34 3,785.34 11.07 30,414.66 101-4-1600-4401 Bldg Repair/Maint Services 23,950.00 1,114.39 1,548.68 6.47 22,401.32 101-4-1600-4404 Equip Repair/Maint Services 8,200.00 312.56 312.56 3.81 7,887.44 101-4-1600-4460 Equip Replacement Charge 1,050.00 87.50 175.00 16.67 875.00 TOTAL Other Services & Charges 84,300.00 6,235.21 8,816.04 10.46 75,483.96 Capital Outlay TOTAL City Hall Maintenance 517,350.00 40,135.83 62,746.95 12.13 454,603.05 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General Government 16.67% OF YEAR COMP. Contingency CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1900-4101 Regular Pay ( 41,600.00) 0.00 0.00 0.00 ( 41,600.00) TOTAL Personal Services ( 41,600.00) 0.00 0.00 0.00 ( 41,600.00) Other Services & Charges 101-4-1900-4440 Miscellaneous 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL Other Services & Charges 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL Contingency 8,400.00 0.00 0.00 0.00 8,400.00 TOTAL General Government 2,965,050.00 207,310.49 345,135.98 11.64 2,619,914.02 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Police Administration CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2110-4101 Regular Pay 331,700.00 22,038.16 31,955.32 9.63 299,744.68 101-4-2110-4104 PERA 44,550.00 3,158.39 6,312.79 14.17 38,237.21 101-4-2110-4105 FICA 2,800.00 0.00 0.00 0.00 2,800.00 101-4-2110-4107 Medicare 3,300.00 203.98 405.78 12.30 2,894.22 101-4-2110-4108 Insurance 37,150.00 1,776.02 3,552.04 9.56 33,597.96 101-4-2110-4109 Workers Comp 61,500.00 ( 262.00) 16,107.50 26.19 45,392.50 TOTAL Personal Services 481,000.00 26,914.55 58,333.43 12.13 422,666.57 Supplies 101-4-2110-4201 Office Supplies 14,000.00 899.91 899.91 6.43 13,100.09 101-4-2110-4217 Uniform Allowance 2,700.00 314.50 564.50 20.91 2,135.50 101-4-2110-4219 Operating Supplies 5,600.00 2,737.04 2,737.04 48.88 2,862.96 TOTAL Supplies 22,300.00 3,951.45 4,201.45 18.84 18,098.55 Other Services & Charges 101-4-2110-4319 Other Professional Services 4,900.00 512.93 512.93 10.47 4,387.07 101-4-2110-4321 Telephone 32,750.00 1,290.06 1,385.87 4.23 31,364.13 101-4-2110-4322 Postage 2,800.00 49.47 92.22 3.29 2,707.78 101-4-2110-4331 Travel, Conferences & Schools 5,050.00 0.00 975.00 19.31 4,075.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 9,000.00 0.00 2,325.00 25.83 6,675.00 101-4-2110-4404 Equip Repair/Maint Services 74,250.00 3,432.42 38,666.08 52.08 35,583.92 101-4-2110-4433 Dues & Subscriptions 4,500.00 360.00 1,110.00 24.67 3,390.00 101-4-2110-4437 Taxes & Licenses 300.00 0.00 156.00 52.00 144.00 TOTAL Other Services & Charges 134,050.00 5,644.88 45,223.10 33.74 88,826.90 Capital Outlay TOTAL Police Administration 637,350.00 36,510.88 107,757.98 16.91 529,592.02 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Patrol CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2120-4101 Regular Pay 1,515,850.00 114,284.30 162,552.35 10.72 1,353,297.65 101-4-2120-4102 Overtime Pay 90,000.00 1,124.37 1,311.30 1.46 88,688.70 101-4-2120-4104 PERA 231,250.00 16,537.71 33,202.48 14.36 198,047.52 101-4-2120-4107 Medicare 20,900.00 1,413.07 2,815.31 13.47 18,084.69 101-4-2120-4108 Insurance 171,850.00 12,363.70 25,318.28 14.73 146,531.72 TOTAL Personal Services 2,029,850.00 145,723.15 225,199.72 11.09 1,804,650.28 Supplies 101-4-2120-4212 Fuels & Lubs 131,650.00 12,565.35 12,663.06 9.62 118,986.94 101-4-2120-4217 Uniform Allowance 17,700.00 679.32 679.32 3.84 17,020.68 101-4-2120-4219 Operating Supplies 66,450.00 7,781.53 8,377.81 12.61 58,072.19 101-4-2120-4221 Equipment Parts 25,000.00 505.64 505.64 2.02 24,494.36 TOTAL Supplies 240,800.00 21,531.84 22,225.83 9.23 218,574.17 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 20,350.00 129.00 129.00 0.63 20,221.00 101-4-2120-4404 Equip Repair/Maint Services 25,700.00 2,320.81 2,481.12 9.65 23,218.88 101-4-2120-4433 Dues & Subscriptions 550.00 150.00 200.00 36.36 350.00 101-4-2120-4460 Equip Replacement Charge 45,200.00 3,766.67 7,533.34 16.67 37,666.66 TOTAL Other Services & Charges 91,800.00 6,366.48 10,343.46 11.27 81,456.54 Capital Outlay TOTAL Patrol 2,362,450.00 173,621.47 257,769.01 10.91 2,104,680.99 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Investigations CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2130-4101 Regular Pay 524,200.00 39,223.58 56,028.22 10.69 468,171.78 101-4-2130-4102 Overtime Pay 45,000.00 1,806.63 2,331.56 5.18 42,668.44 101-4-2130-4104 PERA 81,950.00 5,908.35 11,545.86 14.09 70,404.14 101-4-2130-4107 Medicare 7,050.00 446.30 869.70 12.34 6,180.30 101-4-2130-4108 Insurance 73,150.00 5,821.46 11,642.92 15.92 61,507.08 TOTAL Personal Services 731,350.00 53,206.32 82,418.26 11.27 648,931.74 Supplies 101-4-2130-4217 Uniform Allowance 5,500.00 0.00 0.00 0.00 5,500.00 101-4-2130-4219 Operating Supplies 8,500.00 989.20 989.20 11.64 7,510.80 TOTAL Supplies 14,000.00 989.20 989.20 7.07 13,010.80 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,250.00 0.00 0.00 0.00 6,250.00 101-4-2130-4331 Travel, Conferences & Schools 8,200.00 840.00 840.00 10.24 7,360.00 101-4-2130-4433 Dues & Subscriptions 600.00 0.00 150.00 25.00 450.00 101-4-2130-4460 Equip Replacement Charge _ 11,850.00 987.50 1,975.00 16.67 9,875.00 TOTAL Other Services & Charges 26,900.00 1,827.50 2,965.00 11.02 23,935.00 Capital Outlay TOTAL Investigations 772,250.00 56,023.02 86,372.46 11.18 685,877.54 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Police Support Services CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2150-4101 Regular Pay 313,950.00 23,940.82 34,949.26 11.13 279,000.74 101-4-2150-4102 Overtime Pay 10,000.00 64.60 115.45 1.15 9,884.55 101-4-2150-4103 Part-time Pay 35,400.00 1,364.52 2,021.86 5.71 33,378.14 101-4-2150-4104 PERA 26,050.00 1,832.44 3,696.43 14.19 22,353.57 101-4-2150-4105 FICA 22,300.00 1,511.49 3,038.20 13.62 19,261.80 101-4-2150-4107 Medicare 5,200.00 353.45 710.50 13.66 4,489.50 101-4-2150-4108 Insurance 39,250.00 3,650.05 7,300.10 18.60 31,949.90 TOTAL Personal Services 452,150.00 32,717.37 51,831.80 11.46 400,318.20 Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2150-4217 Uniform Allowance 3,400.00 0.00 76.98 2.26 3,323.02 101-4-2150-4219 Operating Supplies 13,000.00 1,917.25 1,917.25 14.75 11,082.75 TOTAL Supplies 17,400.00 1,917.25 1,994.23 11.46 15,405.77 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,450.00 0.00 175.00 5.07 3,275.00 101-4-2150-4404 Equip Repair/Maint Services 2,100.00 0.00 0.00 0.00 2,100.00 101-4-2150-4409 Contractual Services 17,500.00 134.74 134.74 0.77 17,365.26 101-4-2150-4433 Dues & Subscriptions 500.00 190.00 235.00 47.00 265.00 101-4-2150-4460 Equip Replacement Charge 7,550.00 629.17 1,258.34 16.67 6,291.66 TOTAL Other Services & Charges 31,100.00 953.91 1,803.08 5.80 29,296.92 Capital Outlay TOTAL Police Support Services 500,650.00 35,588.53 55,629.11 11.11 445,020.89 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Police Reserves CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 0.00 0.00 5,500.00 101-4-2160-4105 FICA 350.00 0.00 0.00 0.00 350.00 101-4-2160-4107 Medicare 100.00 0.00 0.00 0.00 100.00 TOTAL Personal Services 5,950.00 0.00 0.00 0.00 5,950.00 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2160-4219 Operating Supplies 6,100.00 0.00 0.00 0.00 6,100.00 TOTAL Supplies 11,100.00 0.00 0.00 0.00 11,100.00 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,600.00 475.00 475.00 29.69 1,125.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 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 4,550.00 475.00 475.00 10.44 4,075.00 Capital Outlay TOTAL Police Reserves 21,600.00 475.00 475.00 2.20 21,125.00 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Public safety building CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 101-4-2190-4219 Operating Supplies 18,200.00 1,376.90 4,432.91 24.36 13,767.09 TOTAL Supplies 18,200.00 1,376.90 4,432.91 24.36 13,767.09 Other Services & Charges 101-4-2190-4361 Insurance 5,000.00 0.00 1,218.00 24.36 3,782.00 101-4-2190-4389 Utilities 19,450.00 2,599.60 2,704.59 13.91 16,745.41 101-4-2190-4401 Bldg Repair/Maint Services 33,350.00 2,101.80 2,932.97 8.79 30,417.03 TOTAL Other Services & Charges 57,800.00 4,701.40 6,855.56 11.86 50,944.44 Capital Outlay TOTAL Public safety building 76,000.00 6,078.30 11,288.47 14.85 64,711.53 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Fire Administration CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2310-4101 Regular Pay 99,900.00 7,537.70 10,915.24 10.93 88,984.76 101-4-2310-4103 Part-time Pay 27,000.00 2,422.54 3,346.08 12.39 23,653.92 101-4-2310-4104 PERA 16,350.00 1,243.33 2,466.09 15.08 13,883.91 101-4-2310-4105 FICA 1,650.00 135.03 443.73 26.89 1,206.27 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101-4-2310-4107 Medicare 1,850.00 139.51 318.20 17.20 1,531.80 101-4-2310-4108 Insurance 6,250.00 621.01 1,242.02 19.87 5,007.98 101-4-2310-4109 Workers Comp 4,150.00 ( 605.00) 6,494.50 156.49 ( 2,344.50) TOTAL Personal Services 187,150.00 11,494.12 25,225.86 13.48 161,924.14 Supplies 101-4-2310-4201 Office Supplies 3,800.00 540.79 540.79 14.23 3,259.21 101-4-2310-4212 Fuels & Lubs 3,000.00 700.44 713.58 23.79 2,286.42 101-4-2310-4217 Uniform Allowance 950.00 0.00 0.00 0.00 950.00 101-4-2310-4219 Operating Supplies 20,900.00 64.68 64.68 0.31 20,835.32 101-4-2310-4221 Equipment Parts 0.00 285.51 285.51 0.00 ( 285.51) TOTAL Supplies 28,650.00 1,591.42 1,604.56 5.60 27,045.44 Other Services & Charges 101-4-2310-4321 Telephone 2,200.00 167.94 457.59 20.80 1,742.41 101-4-2310-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2310-4331 Travel, Conferences & Schools 1,800.00 0.00 0.00 0.00 1,800.00 101-4-2310-4361 Insurance 15,500.00 0.00 3,471.00 22.39 12,029.00 101-4-2310-4389 Utilities 0.00 1,441.95 1,441.95 0.00 ( 1,441.95) 101-4-2310-4401 Bldg Repair/Maint Services 0.00 1,428.34 1,428.34 0.00 ( 1,428.34) 101-4-2310-4404 Equip Repair/Maint Services 6,500.00 1,329.19 1,759.83 27.07 4,740.17 101-4-2310-4460 Equip Replacement Charge 33,300.00 2,775.00 5,550.00 16.67 27,750.00 TOTAL Other Services & Charges 60,300.00 7,142.42 14,108.71 23.40 46,191.29 Capital Outlay TOTAL Fire Administration 276,100.00 20,227.96 40,939.13 14.83 235,160.87 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Fire Operations CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2320-4103 Part-time Pay 157,700.00 10,474.02 14,953.76 9.48 142,746.24 101-4-2320-4104 PERA 0.00 0.00 533.17 0.00 ( 533.17) 101-4-2320-4105 FICA 9,800.00 581.33 962.24 9.82 8,837.76 101-4-2320-4107 Medicare 2,300.00 135.97 261.54 11.37 2,038.46 101-4-2320-4108 Insurance 0.00 0.00 1,416.02 0.00 ( 1,416.02) 101-4-2320-4109 Workers Comp 21,950.00 0.00 0.00 0.00 21,950.00 TOTAL Personal Services 191,750.00 11,191.32 18,126.73 9.45 173,623.27 Supplies 101-4-2320-4212 Fuels & Lubs 6,000.00 258.28 258.28 4.30 5,741.72 101-4-2320-4217 Uniform Allowance 6,500.00 0.00 0.00 0.00 6,500.00 101-4-2320-4219 Operating Supplies 52,800.00 4,253.38 4,253.38 8.06 48,546.62 101-4-2320-4221 Equipment Parts 6,800.00 1.92 1.92 0.03 6,798.08 TOTAL Supplies 72,100.00 4,513.58 4,513.58 6.26 67,586.42 Other Services & Charges 101-4-2320-4321 Telephone 2,100.00 44.76 89.51 4.26 2,010.49 101-4-2320-4331 Travel, Conferences & Schools 20,450.00 175.00 175.00 0.86 20,275.00 101-4-2320-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2320-4389 Utilities 12,000.00 0.00 0.00 0.00 12,000.00 101-4-2320-4401 Bldg Repair/Maint Services 5,500.00 0.00 0.00 0.00 5,500.00 101-4-2320-4404 Equip Repair/Maint Services 35,300.00 0.00 0.00 0.00 35,300.00 101-4-2320-4409 Contractual Services 6,450.00 0.00 0.00 0.00 6,450.00 101-4-2320-4433 Dues & Subscriptions 1,600.00 627.00 627.00 39.19 973.00 TOTAL Other Services & Charges 83,500.00 846.76 891.51 1.07 82,608.49 Capital Outlay 101-4-2320-4560 Equipment 16,000.00 0.00 0.00 0.00 16,000.00 TOTAL Capital Outlay 16,000.00 0.00 0.00 0.00 16,000.00 TOTAL Fire Operations 363,350.00 16,551.66 23,531.82 6.48 339,818.18 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Emergency Management CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 101-4-2330-4201 Office Supplies 300.00 0.00 0.00 0.00 300.00 101-4-2330-4219 Operating Supplies 7,100.00 0.00 0.00 0.00 7,100.00 TOTAL Supplies 7,400.00 0.00 0.00 0.00 7,400.00 Other Services & Charges 101-4-2330-4321 Telephone 650.00 26.00 26.00 4.00 624.00 101-4-2330-4331 Travel, Conferences & Schools 3,650.00 0.00 0.00 0.00 3,650.00 101-4-2330-4389 Utilities 1,200.00 37.55 37.55 3.13 1,162.45 101-4-2330-4404 Equip Repair/Maint Services 3,800.00 96.19 96.19 2.53 3,703.81 101-4-2330-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 9,400.00 159.74 159.74 1.70 9,240.26 Capital Outlay 101-4-2330-4560 Equipment 12,000.00 0.00 0.00 0.00 12,000.00 TOTAL Capital Outlay 12,000.00 0.00 0.00 0.00 12,000.00 TOTAL Emergency Management 28,800.00 159.74 159.74 0.55 28,640.26 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Building Safety CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2410-4101 Regular Pay 417,750.00 31,369.46 45,485.77 10.89 372,264.23 101-4-2410-4102 Overtime Pay 0.00 197.37 197.37 0.00 ( 197.37) 101-4-2410-4103 Part-time Pay 66,950.00 5,949.05 8,637.47 12.90 58,312.53 101-4-2410-4104 PERA 40,200.00 3,100.90 5,628.74 14.00 34,571.26 101-4-2410-4105 FICA 25,700.00 1,941.44 3,689.84 14.36 22,010.16 101-4-2410-4107 Medicare 7,050.00 528.56 974.66 13.82 6,075.34 101-4-2410-4108 Insurance 55,650.00 4,488.06 7,560.10 13.59 48,089.90 101-4-2410-4109 Workers Comp 6,700.00 ( 5.00) 1,791.25 26.74 4,908.75 TOTAL Personal Services 620,000.00 47,569.84 73,965.20 11.93 546,034.80 Supplies 101-4-2410-4201 Office Supplies 4,600.00 189.79 189.79 4.13 4,410.21 101-4-2410-4212 Fuels & Lubs 8,000.00 606.72 606.72 7.58 7,393.28 101-4-2410-4217 Uniform Allowance 1,900.00 0.00 0.00 0.00 1,900.00 101-4-2410-4219 Operating Supplies 6,900.00 116.43 256.67 3.72 6,643.33 TOTAL Supplies 21,400.00 912.94 1,053.18 4.92 20,346.82 Other Services & Charges 101-4-2410-4321 Telephone 4,200.00 175.50 189.18 4.50 4,010.82 101-4-2410-4331 Travel, Conferences & Schools 3,200.00 798.06 1,778.06 55.56 1,421.94 101-4-2410-4361 Insurance 650.00 0.00 315.75 48.58 334.25 101-4-2410-4404 Equip Repair/Maint Services 8,300.00 23.03 1,728.38 20.82 6,571.62 101-4-2410-4433 Dues & Subscriptions 1,950.00 62.50 62.50 3.21 1,887.50 101-4-2410-4460 Equip Replacement Charge 3,900.00 325.00 650.00 16.67 3,250.00 TOTAL Other Services & Charges 22,200.00 1,384.09 4,723.87 21.28 17,476.13 Capital Outlay TOTAL Building Safety 663,600.00 49,866.87 79,742.25 12.02 583,857.75 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 27 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Code Enforcement CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2420-4101 Regular Pay 66,250.00 5,096.01 7,389.21 11.15 58,860.79 101-4-2420-4102 Overtime Pay 0.00 167.21 167.21 0.00 ( 167.21) 101-4-2420-4104 PERA 4,800.00 379.33 565.94 11.79 4,234.06 101-4-2420-4105 FICA 4,100.00 338.80 500.42 12.21 3,599.58 101-4-2420-4107 Medicare 950.00 79.23 117.02 12.32 832.98 101-4-2420-4108 Insurance 3,600.00 241.38 305.68 8.49 3,294.32 101-4-2420-4109 Workers Comp 0.00 0.00 73.00 0.00 ( 73.00) TOTAL Personal Services 79,700.00 6,301.96 9,118.48 11.44 70,581.52 Supplies 101-4-2420-4212 Fuels & Lubs 2,250.00 0.00 0.00 0.00 2,250.00 101-4-2420-4219 Operating Supplies 250.00 0.00 0.00 0.00 250.00 TOTAL Supplies 2,500.00 0.00 0.00 0.00 2,500.00 Other Services & Charges 101-4-2420-4321 Telephone 750.00 26.90 26.90 3.59 723.10 101-4-2420-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2420-4331 Travel, Conferences & Schools 0.00 432.50 432.50 0.00 ( 432.50) 101-4-2420-4361 Insurance 350.00 0.00 32.25 9.21 317.75 101-4-2420-4460 Equip Replacement Charge 750.00 62.50 125.00 16.67 625.00 TOTAL Other Services & Charges 2,850.00 521.90 616.65 21.64 2,233.35 TOTAL Code Enforcement 85,050.00 6,823.86 9,735.13 11.45 75,314.87 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 28 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. Environmental CURRENT CURRENT YEAR TO DATE OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2440-4101 Regular Pay 36,450.00 1,286.80 1,613.59 4.43 34,836.41 101-4-2440-4104 PERA 2,650.00 93.30 278.39 10.51 2,371.61 101-4-2440-4105 FICA 2,250.00 76.60 231.70 10.30 2,018.30 101-4-2440-4107 Medicare 500.00 17.91 54.18 10.84 445.82 101-4-2440-4108 Insurance 5,300.00 60.01 120.02 2.26 5,179.98 101-4-2440-4109 Workers Comp 550.00 ( 42.00) 107.25 19.50 442.75 TOTAL Personal Services 47,700.00 1,492.62 2,405.13 5.04 45,294.87 Supplies 101-4-2440-4201 Office Supplies 500.00 0.00 0.00 0.00 500.00 101-4-2440-4212 Fuels & Lubs 150.00 34.75 34.75 23.17 115.25 101-4-2440-4219 Operating Supplies 1,800.00 746.88 746.88 41.49 1,053.12 TOTAL Supplies 2,450.00 781.63 781.63 31.90 1,668.37 Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 5.41 1.55 344.59 101-4-2440-4322 Postage 500.00 0.00 0.00 0.00 500.00 101-4-2440-4331 Travel, Conferences & Schools 1,200.00 0.00 0.00 0.00 1,200.00 101-4-2440-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2440-4409 Contractual Services 0.00 35.00 35.00 0.00 ( 35.00) 101-4-2440-4433 Dues & Subscriptions 50.00 0.00 0.00 0.00 50.00 TOTAL Other Services & Charges 2,200.00 35.00 40.41 1.84 2,159.59 TOTAL Environmental 52,350.00 2,309.25 3,227.17 6.16 49,122.83 TOTAL Public Safety 5,839,550.00 404,236.54 676,627.27 11.59 5,162,922.73 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 29 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. Street Maintenance CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services , 101-4-3120-4101 Regular Pay 404,300.00 27,727.21 42,784.64 10.58 361,515.36 101-4-3120-4102 Overtime Pay 4,000.00 131.80 210.88 5.27 3,789.12 101-4-3120-4103 Part-time Pay 82,050.00 4,142.49 36,911.01 44.99 45,138.99 101-4-3120-4104 PERA 33,850.00 2,320.10 4,923.44 14.54 28,926.56 101-4-3120-4105 FICA 30,400.00 1,866.05 5,976.57 19.66 24,423.43 101-4-3120-4107 Medicare 7,100.00 436.42 1,397.74 19.69 5,702.26 101-4-3120-4108 Insurance 62,500.00 5,574.17 10,256.72 16.41 52,243.28 101-4-3120-4109 Workers Comp 24,300.00 ( 721.00) 5,886.00 24.22 18,414.00 TOTAL Personal Services 648,500.00 41,477.24 108,347.00 16.71 540,153.00 Supplies 101-4-3120-4201 Office Supplies 5,900.00 0.00 0.00 0.00 5,900.00 101-4-3120-4212 Fuels & Lubs 80,250.00 26,781.11 26,826.51 33.43 53,423.49 101-4-3120-4219 Operating Supplies 127,750.00 8,301.70 12,305.90 9.63 115,444.10 101-4-3120-4226 Street Signs 35,850.00 99.43 ( 54.13) 0.15- 35,904.13 TOTAL Supplies 249,750.00 35,182.24 39,078.28 15.65 210,671.72 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 0.00 0.00 550.00 101-4-3120-4321 Telephone 6,100.00 414.50 542.53 8.89 5,557.47 101-4-3120-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-3120-4331 Travel, Conferences & Schools 3,500.00 659.99 659.99 18.86 2,840.01 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 16,000.00 0.00 4,812.75 30.08 11,187.25 101-4-3120-4389 Utilities 52,000.00 7,987.85 7,987.85 15.36 44,012.15 101-4-3120-4401 Bldg Repair/Maint Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-3120-4404 Equip Repair/Maint Services 5,000.00 115.45 115.45 2.31 4,884.55 101-4-3120-4409 Contractual Services 447,650.00 922.91 922.91 0.21 446,727.09 101-4-3120-4415 Equipment Rental 4,500.00 96.19 96.19 2.14 4,403.81 101-4-3120-4417 Uniform Rental 4,700.00 853.33 880.72 18.74 3,819.28 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 261.25 74.64 88.75 101-4-3120-4437 Taxes & Licenses 150.00 0.00 0.00 0.00 150.00 101-4-3120-4460 Equip Replacement Charge 89,700.00 7,475.00 14,950.00 16.67 74,750.00 TOTAL Other Services & Charges 631,950.00 18,525.22 31,229.64 4.94 600,720.36 Capital Outlay TOTAL Street Maintenance 1,530,200.00 95,184.70 178,654.92 11.68 1,351,545.08 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 30 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. Snow Removal CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3130-4101 Regular Pay 106,550.00 13,884.46 16,166.90 15.17 90,383.10 101-4-3130-4102 Overtime Pay 20,000.00 7,234.89 7,863.69 39.32 12,136.31 101-4-3130-4103 Part-time Pay 200.00 0.00 525.76 262.88 ( 325.76) 101-4-3130-4104 PERA 8,750.00 1,527.78 2,273.01 25.98 6,476.99 101-4-3130-4105 FICA 7,850.00 1,241.90 1,926.12 24.54 5,923.88 101-4-3130-4107 Medicare 1,850.00 290.45 450.46 24.35 1,399.54 101-4-3130-4108 Insurance 16,550.00 714.96 2,775.72 16.77 13,774.28 101-4-3130-4109 Workers Comp 7,950.00 0.00 1,716.00 21.58 6,234.00 TOTAL Personal Services 169,700.00 24,894.44 33,697.66 19.86 136,002.34 Supplies 101-4-3130-4219 Operating Supplies 96,000.00 28,220.15 28,220.15 29.40 67,779.85 TOTAL Supplies 96,000.00 28,220.15 28,220.15 29.40 67,779.85 Other Services & Charges Capital Outlay 101-4-3130-4560 Equipment 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Capital Outlay 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Snow Removal 285,700.00 53,114.59 61,917.81 21.67 223,782.19 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 31 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. Equipment Services CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3150-4101 Regular Pay 169,400.00 11,703.75 17,542.71 10.36 151,857.29 101-4-3150-4102 Overtime Pay 0.00 147.49 477.91 0.00 ( 477.91) 101-4-3150-4104 PERA 12,300.00 859.21 1,797.08 14.61 10,502.92 101-4-3150-4105 FICA 10,500.00 695.65 1,447.55 13.79 9,052.45 101-4-3150-4107 Medicare 2,450.00 162.69 338.55 13.82 2,111.45 101-4-3150-4108 Insurance 21,700.00 1,676.96 3,224.51 14.86 18,475.49 101-4-3150-4109 Workers Comp 4,400.00 ( 126.00) 1,028.00 23.36 3,372.00 TOTAL Personal Services 220,750.00 15,119.75 25,856.31 11.71 194,893.69 Supplies 101-4-3150-4219 Operating Supplies 22,500.00 490.28 1,350.59 6.00 21,149.41 101-4-3150-4221 Equipment Parts 6,000.00 0.00 0.00 0.00 6,000.00 TOTAL Supplies 28,500.00 490.28 1,350.59 4.74 27,149.41 Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 500.00 0.00 0.00 0.00 500.00 101-4-3150-4417 Uniform Rental 3,000.00 273.35 328.02 10.93 2,671.98 TOTAL Other Services & Charges 3,500.00 273.35 328.02 9.37 3,171.98 Capital Outlay TOTAL Equipment Services 252,750.00 15,883.38 27,534.92 10.89 225,215.08 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 32 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. Engineering CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 113,800.00 11,451.64 16,604.87 14.59 97,195.13 101-4-3300-4104 PERA 8,250.00 813.51 1,654.65 20.06 6,595.35 101-4-3300-4105 FICA 7,050.00 734.96 1,464.94 20.78 5,585.06 101-4-3300-4107 Medicare 1,650.00 171.88 342.60 20.76 1,307.40 101-4-3300-4108 Insurance 14,150.00 600.01 1,200.02 8.48 12,949.98 101-4-3300-4109 Workers Comp 600.00 ( 189.00) ( 24.75) 4.13- 624.75 TOTAL Personal Services 145,500.00 13,583.00 21,242.33 14.60 124,257.67 Supplies 101-4-3300-4201 Office Supplies 200.00 0.00 0.00 0.00 200.00 101-4-3300-4212 Fuels & Lubs 1,000.00 38.44 38.44 3.84 961.56 101-4-3300-4219 Operating Supplies 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Supplies 2,200.00 38.44 38.44 1.75 2,161.56 Other Services & Charges 101-4-3300-4319 Other Professional Services 15,000.00 0.00 0.00 0.00 15,000.00 101-4-3300-4321 Telephone 1,100.00 24.99 24.99 2.27 1,075.01 101-4-3300-4322 Postage 300.00 0.00 0.00 0.00 300.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 50.50 25.25 149.50 101-4-3300-4404 Equip Repair/Maint Services 5,600.00 196.93 383.96 6.86 5,216.04 101-4-3300-4460 Equip Replacement Charge 750.00 62.50 125.00 16.67 _ 625.00 TOTAL Other Services & Charges 25,650.00 284.42 584.45 2.28 25,065.55 Capital Outlay _ TOTAL Engineering 173,350.00 13,905.86 21,865.22 12.61 151,484.78 TOTAL Public Works 2,242,000.00 178,088.53 289,972.87 12.93 1,952,027.13 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 33 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. Parks Department CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5110-4101 Regular Pay 335,000.00 25,416.64 37,157.21 11.09 297,842.79 101-4-5110-4102 Overtime Pay 6,600.00 425.06 425.06 6.44 6,174.94 101-4-5110-4103 Part-time Pay 58,250.00 0.00 0.00 0.00 58,250.00 101-4-5110-4104 PERA 26,200.00 1,864.53 3,745.89 14.30 22,454.11 101-4-5110-4105 FICA 24,900.00 1,515.30 3,033.40 12.18 21,866.60 101-4-5110-4107 Medicare 5,850.00 354.40 709.46 12.13 5,140.54 101-4-5110-4108 Insurance 45,600.00 3,840.05 7,569.48 16.60 38,030.52 101-4-5110-4109 Workers Comp 10,500.00 ( 95.00) 2,714.25 25.85 7,785.75 TOTAL Personal Services 512,900.00 33,320.98 55,354.75 10.79 457,545.25 Supplies 101-4-5110-4212 Fuels & Lubs 40,200.00 5,114.43 5,143.34 12.79 35,056.66 101-4-5110-4217 Uniform Allowance 3,350.00 101.99 169.89 5.07 3,180.11 101-4-5110-4219 Operating Supplies 84,050.00 4,223.70 5,072.00 6.03 78,978.00 101-4-5110-4221 Equipment Parts 13,000.00 2,889.01 2,889.01 22.22 10,110.99 TOTAL Supplies 140,600.00 12,329.13 13,274.24 9.44 127,325.76 Other Services & Charges 101-4-5110-4321 Telephone 3,750.00 204.50 239.67 6.39 3,510.33 101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-5110-4331 Travel, Conferences & Schools 3,950.00 163.00 249.88 6.33 3,700.12 101-4-5110-4361 Insurance 25,000.00 0.00 6,393.75 25.58 18,606.25 101-4-5110-4389 Utilities 24,700.00 273.14 273.14 1.11 24,426.86 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 0.00 0.00 4,000.00 101-4-5110-4404 Equip Repair/Maint Services 12,900.00 185.00 185.00 1.43 12,715.00 101-4-5110-4409 Contractual Services 6,650.00 0.00 0.00 0.00 6,650.00 101-4-5110-4415 Equipment Rental 17,000.00 169.16 169.16 1.00 16,830.84 101-4-5110-4460 Equip Replacement Charge 55,950.00 4,662.50 9,325.00 16.67 46,625.00 TOTAL Other Services & Charges 153,950.00 5,657.30 16,835.60 10.94 137,114.40 Capital Outlay TOTAL Parks Department 807,450.00 51,307.41 85,464.59 10.58 721,985.41 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 34 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. Parks & Rec Admin CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5210-4101 Regular Pay 281,500.00 21,654.80 31,557.64 11.21 249,942.36 101-4-5210-4103 Part-time Pay 51,550.00 3,437.84 4,966.54 9.63 46,583.46 101-4-5210-4104 PERA 23,800.00 1,819.24 3,754.91 15.78 20,045.09 101-4-5210-4105 FICA 20,650.00 1,465.74 3,011.80 14.58 17,638.20 101-4-5210-4107 Medicare 4,850.00 342.78 704.36 14.52 4,145.64 101-4-5210-4108 Insurance 40,000.00 3,050.66 6,809.33 17.02 33,190.67 101-4-5210-4109 Workers Comp 2,000.00 ( 144.00) 924.50 46.23 1,075.50 TOTAL Personal Services 424,350.00 31,627.06 51,729.08 12.19 372,620.92 Supplies 101-4-5210-4219 Operating Supplies 13,200.00 2,685.41 4,074.84 30.87 9,125.16 TOTAL Supplies 13,200.00 2,685.41 4,074.84 30.87 9,125.16 Other Services & Charges 101-4-5210-4321 Telephone 5,350.00 155.17 288.96 5.40 5,061.04 101-4-5210-4322 Postage 4,500.00 0.00 0.00 0.00 4,500.00 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 15.00 15.00 0.15 9,835.00 101-4-5210-4349 Advertising/Marketing 32,400.00 90.17 230.17 0.71 32,169.83 101-4-5210-4361 Insurance 650.00 0.00 184.00 28.31 466.00 101-4-5210-4389 Utilities 4,700.00 695.08 695.08 14.79 4,004.92 101-4-5210-4401 Bldg Repair/Maint Services 14,100.00 947.02 1,878.01 13.32 12,221.99 101-4-5210-4404 Equip Repair/Maint Services 11,250.00 744.05 7,716.55 68.59 3,533.45 101-4-5210-4433 Dues & Subscriptions 1,750.00 0.00 0.00 0.00 1,750.00 TOTAL Other Services & Charges 84,550.00 2,646.49 11,007.77 13.02 73,542.23 Capital Outlay TOTAL Parks & Rec Admin 522,100.00 36,958.96 66,811.69 12.80 455,288.31 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 35 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. Recreation Programs CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 3,253.98 5,204.99 6.35 76,795.01 101-4-5220-4104 PERA 2,400.00 48.47 79.60 3.32 2,320.40 101-4-5220-4105 FICA 4,350.00 201.74 425.32 9.78 3,924.68 101-4-5220-4107 Medicare 1,200.00 47.18 99.43 8.29 1,100.57 TOTAL Personal Services 89,950.00 3,551.37 5,809.34 6.46 84,140.66 Supplies 101-4-5220-4219 Operating Supplies 38,000.00 1,240.88 1,246.20 3.28 36,753.80 TOTAL Supplies 38,000.00 1,240.88 1,246.20 3.28 36,753.80 Other Services & Charges 101-4-5220-4409 Contractual Services 62,350.00 179.56 5,129.56 8.23 57,220.44 101-4-5220-4412 Building Rent 1,600.00 0.00 0.00 0.00 1,600.00 101-4-5220-4438 Credit Card Fees 4,600.00 154.54 154.54 3.36 4,445.46 TOTAL Other Services & Charges 68,550.00 334.10 5,284.10 7.71 63,265.90 TOTAL Recreation Programs 196,500.00 5,126.35 12,339.64 6.28 184,160.36 • 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 36 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. Concessions CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies Other Services & Charges 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 37 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. Sr Citizen Programs CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5510-4101 Regular Pay 97,100.00 7,276.80 10,551.36 10.87 86,548.64 101-4-5510-4104 PERA 7,050.00 527.56 1,049.46 14.89 6,000.54 101-4-5510-4105 FICA 6,000.00 441.52 878.19 14.64 5,121.81 101-4-5510-4107 Medicare 1,400.00 103.26 205.39 14.67 1,194.61 101-4-5510-4108 Insurance 18,600.00 1,233.02 2,466.04 13.26 16,133.96 101-4-5510-4109 Workers Comp 600.00 ( 23.00) 131.25 21.88 468.75 TOTAL Personal Services 130,750.00 9,559.16 15,281.69 11.69 115,468.31 Supplies 101-4-5510-4219 Operating Supplies 14,900.00 2,250.64 2,283.14 15.32 12,616.86 TOTAL Supplies 14,900.00 2,250.64 2,283.14 15.32 12,616.86 Other Services & Charges 101-4-5510-4321 Telephone 2,600.00 160.51 320.24 12.32 2,279.76 101-4-5510-4322 Postage 2,550.00 0.00 600.00 23.53 1,950.00 101-4-5510-4331 Travel, Conferences & Schools 1,800.00 0.00 0.00 0.00 1,800.00 101-4-5510-4361 Insurance 1,500.00 0.00 513.25 34.22 986.75 101-4-5510-4389 Utilities 10,050.00 1,046.18 1,046.18 10.41 9,003.82 101-4-5510-4401 Bldg Repair/Maint Services 12,950.00 897.04 1,467.64 11.33 11,482.36 101-4-5510-4404 Equip Repair/Maint Services 2,300.00 225.51 369.79 16.08 1,930.21 101-4-5510-4409 Contractual Services 7,700.00 400.00 640.00 8.31 7,060.00 101-4-5510-4433 Dues & Subscriptions 950.00 0.00 0.00 0.00 950.00 TOTAL Other Services & Charges 42,400.00 2,729.24 4,957.10 11.69 37,442.90 Capital Outlay TOTAL Sr Citizen Programs 188,050.00 14,539.04 22,521.93 11.98 165,528.07 TOTAL Culture & Recreation 1,714,100.00 107,931.76 187,137.85 10.92 1,526,962.15 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 38 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Economic Development 16.67% OF YEAR COMP. Economic Development CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6210-4101 Regular Pay 0.00 5,300.72 27,675.77 0.00 ( 27,675.77) 101-4-6210-4103 Part-time Pay 0.00 900.00 2,858.40 0.00 ( 2,858.40) 101-4-6210-4104 PERA 0.00 335.36 2,198.47 0.00 ( 2,198.47) 101-4-6210-4105 FICA 0.00 339.63 2,082.01 0.00 ( 2,082.01) 101-4-6210-4107 Medicare 0.00 79.44 491.30 0.00 ( 491.30) 101-4-6210-4108 Insurance 0.00 992.01 4,000.03 0.00 ( 4,000.03) 101-4-6210-4109 Workers Comp 0.00 ( 13.00) 238.00 0.00 ( 238.00) TOTAL Personal Services 0.00 7,934.16 39,543.98 0.00 ( 39,543.98) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 68.08) ( 40.08) 0.00 40.08 TOTAL Other Services & Charges 0.00 ( 68.08) ( 40.08) 0.00 40.08 TOTAL Economic Development 0.00 7,866.08 39,503.90 0.00 ( 39,503.90) 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 39 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND Economic Development 16.67% OF YEAR COMP. Energy City CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6220-4.101 Regular Pay 16,700.00 965.12 1,446.73 8.66 15,253.27 101-4-6220-4104 PERA 1,200.00 69.98 139.20 11.60 1,060.80 101-4-6220-4105 FICA 1,050.00 57.44 114.25 10.88 935.75 101-4-6220-4107 Medicare 250.00 13.44 26.72 10.69 223.28 101-4-6220-4108 Insurance 2,750.00 45.01 90.02 3.27 2,659.98 TOTAL Personal Services 21,950.00 1,150.99 1,816.92 8.28 20,133.08 Supplies 101-4-6220-4219 Operating Supplies 5,000.00 418.85 418.85 8.38 4,581.15 TOTAL Supplies 5,000.00 418.85 418.85 8.38 4,581.15 Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 3,000.00 19.98 19.98 0.67 2,980.02 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Other Services & Charges 4,500.00 19.98 19.98 0.44 4,480.02 TOTAL Energy City 31,450.00 1,589.82 2,255.75 7.17 29,194.25 TOTAL Economic Development 31,450.00 9,455.90 41,759.65 132.78 ( 10,309.65) 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 40 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 101-GENERAL FUND General 16.67% OF YEAR COMP. Transfers Out CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Transfers Out 101-4-7000-4724 Transfer - Pinewood 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Transfers Out 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Transfers Out 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL General 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL EXPENDITURES 12,836,950.00 907,023.22 1,540,633.62 12.00 11,296,316.38 REVENUES OVER/(UNDER) EXPENDITURES ( 200,000.00) ) 573,607.22) ) 1,137,416.69) 937,416.69 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 722,550.00 8,243.57 27,613.06 3.82 694,936.94 Hockey 36,000.00 34,010.00 38,090.00 105.81 ( 2,090.00) Skating 64,500.00 7,487.00 9,207.00 14.27 55,293.00 Concessions 78,000.00 10,188.92 26,664.42 34.19 51,335.58 TOTAL REVENUES 901,050.00 59,929.49 101,574.48 11.27 799,475.52 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 888,150.00 46,762.47 65,158.44 7.34 822,991.56 Hockey 19,300.00 147.06 147.06 0.76 19,152.94 Skating 32,550.00 1,800.48 2,091.55 6.43 30,458.45 Arena Concessions 50,000.00 8,572.67 10,459.63 20.92 39,540.37 TOTAL Culture & Recreation 990,000.00 57,282.68 77,856.68 7.86 912,143.32 TOTAL EXPENDITURES 990,000.00 57,282.68 77,856.68 7.86 912,143.32 REVENUES OVER/(UNDER) EXPENDITURES ( 88,950.00) 2,646.81 23,717.80 ( 112,667.80) 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 493,000.00 3,538.87 6,618.87 1.34 486,381.13 221-3-0000-3465 Admissions 25,500.00 2,051.50 12,154.50 47.66 13,345.50 221-3-0000-3466 Dry Floor Events 19,500.00 1,188.00 3,103.00 15.91 16,397.00 221-3-0000-3468 Skate Sharpening 4,300.00 648.00 1,644.00 38.23 2,656.00 221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 18,000.00 116.67 913.34 5.07 17,086.66 TOTAL Charges for Services 562,900.00 7,543.04 24,433.71 4.34 538,466.29 Other Revenue 221-3-0000-3621 Interest Income 0.00 0.00 147.96 0.00 ( 147.96) 221-3-0000-3622 Vending Machines 11,800.00 511.24 2,386.60 20.23 9,413.40 221-3-0000-3626 Contributions 7,300.00 0.00 0.00 0.00 7,300.00 221-3-0000-3629 Miscellaneous Revenue 2,800.00 143.44 556.94 19.89 2,243.06 TOTAL Other Revenue 21,900.00 654.68 3,091.50 14.12 18,808.50 Sales 221-3-0000-3791 ATM Revenue 250.00 45.85 87.85 35.14 162.15 TOTAL Sales 250.00 45.85 87.85 35.14 162.15 Transfers In 221-3-0000-3921 Transfers 137,500.00 0.00 0.00 0.00 137,500.00 TOTAL Transfers In 137,500.00 0.00 0.00 0.00 137,500.00 TOTAL Ice Arena 722,550.00 8,243.57 27,613.06 3.82 694,936.94 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 36,000.00 34,010.00 38,090.00 105.81 ( 2,090.00) TOTAL Charges for Services 36,000.00 34,010.00 38,090.00 105.81 ( 2,090.00) Other Revenue TOTAL Hockey 36,000.00 34,010.00 38,090.00 105.81 ( 2,090.00) Skating 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Charges for Services 221-3-5420-3461 Recreation Fees 60,700.00 5,487.00 7,207.00 11.87 53,493.00 221-3-5420-3465 Admissions 3,800.00 0.00 0.00 0.00 3,800.00 TOTAL Charges for Services 64,500.00 5,487.00 7,207.00 11.17 57,293.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 2,000.00 2,000.00 0.00 ( 2,000.00) TOTAL Other Revenue 0.00 2,000.00 2,000.00 0.00 ( 2,000.00) TOTAL Skating 64,500.00 7,487.00 9,207.00 14.27 55,293.00 Concessions Charges for Services 221-3-5430-3467 Concessions 78,000.00 10,188.92 26,664.42 34.19 51,335.58 TOTAL Charges for Services 78,000.00 10,188.92 26,664.42 34.19 51,335.58 TOTAL Concessions 78,000.00 10,188.92 26,664.42 34.19 51,335.58 TOTAL REVENUE 901,050.00 59,929.49 101,574.48 11.27 799,475.52 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA Culture & Recreation 16.67% OF YEAR COMP. Ice Arena CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5400-4101 Regular Pay 162,700.00 12,420.76 18,163.73 11.16 144,536.27 221-4-5400-4103 Part-time Pay 60,550.00 7,174.08 10,818.75 17.87 49,731.25 221-4-5400-4104 PERA 15,450.00 1,129.53 2,224.16 14.40 13,225.84 221-4-5400-4105 FICA 13,900.00 1,163.89 2,324.16 16.72 11,575.84 221-4-5400-4107 Medicare 3,300.00 272.19 543.56 16.47 2,756.44 221-4-5400-4108 Insurance 24,550.00 1,941.03 3,882.06 15.81 20,667.94 221-4-5400-4109 Workers Comp 7,050.00 ( 4,311.00) ( 2,382.50) 33.79- 9,432.50 TOTAL Personal Services 287,500.00 19,790.48 35,573.92 12.37 251,926.08 Supplies 221-4-5400-4212 Fuels & Lubs 1,100.00 12.38 12.38 1.13 1,087.62 221-4-5400-4217 Uniform Allowance 900.00 0.00 22.25 2.47 877.75 221-4-5400-4219 Operating Supplies 39,050.00 1,316.49 1,316.49 3.37 37,733.51 221-4-5400-4255 Soft Drinks/Misc 7,000.00 736.08 947.16 13.53 6,052.84 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00 TOTAL Supplies 48,950.00 2,064.95 2,298.28 4.70 46,651.72 Other Services & Charges 221-4-5400-4321 Telephone 3,250.00 65.67 125.13 3.85 3,124.87 221-4-5400-4322 Postage 400.00 0.00 0.00 0.00 400.00 221-4-5400-4331 Travel, Conferences & Schools 1,500.00 162.16 162.16 10.81 1,337.84 221-4-5400-4359 Publishing 3,200.00 0.00 0.00 0.00 3,200.00 221-4-5400-4361 Insurance 7,100.00 0.00 2,029.50 28.58 5,070.50 221-4-5400-4389 Utilities 149,050.00 12,391.80 12,391.80 8.31 136,658.20 221-4-5400-4401 Bldg Repair/Maint Services 24,900.00 12,051.80 12,051.80 48.40 12,848.20 221-4-5400-4409 Contractual Services 1,800.00 6.32 6.32 0.35 1,793.68 221-4-5400-4415 Equipment Rental 2,700.00 144.29 289.53 10.72 2,410.47 221-4-5400-4433 Dues & Subscriptions 500.00 85.00 230.00 46.00 270.00 TOTAL Other Services & Charges 194,400.00 24,907.04 27,286.24 14.04 167,113.76 Capital Outlay 221-4-5400-4520 Buildings & Structures 113,300.00 0.00 0.00 0.00 113,300.00 221-4-5400-4560 Equipment 244,000.00 0.00 0.00 0.00 244,000.00 TOTAL Capital Outlay 357,300.00 0.00 0.00 0.00 357,300.00 Transfers Out TOTAL Ice Arena 888,150.00 46,762.47 65,158.44 7.34 822,991.56 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA Culture & Recreation 16.67% OF YEAR COMP. Hockey CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5410-4103 Part-time Pay 850.00 0.00 0.00 0.00 850.00 221-4-5410-4105 FICA 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 900.00 0.00 0.00 0.00 900.00 Supplies 221-4-5410-4219 Operating Supplies 9,100.00 0.00 0.00 0.00 9,100.00 TOTAL Supplies 9,100.00 0.00 0.00 0.00 9,100.00 Other Services & Charges 221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00 221-4-5410-4409 Contractual Services 6,000.00 0.00 0.00 0.00 6,000.00 221-4-5410-4438 Credit Card Fees 2,800.00 147.06 147.06 5.25 2,652.94 TOTAL Other Services & Charges 9,300.00 147.06 147.06 1.58 9,152.94 TOTAL Hockey 19,300.00 147.06 147.06 0.76 19,152.94 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA Culture & Recreation 16.67% OF YEAR COMP. Skating CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 1,517.14 1,736.74 9.76 16,063.26 221-4-5420-4104 PERA 1,000.00 13.68 19.16 1.92 980.84 221-4-5420-4105 FICA 1,100.00 94.07 147.55 13.41 952.45 221-4-5420-4107 Medicare 250.00 21.98 34.49 13.80 215.51 TOTAL Personal Services 20,150.00 1,646.87 1,937.94 9.62 18,212.06 Supplies 221-4-5420-4219 Operating Supplies 5,300.00 0.00 0.00 0.00 5,300.00 TOTAL Supplies 5,300.00 0.00 0.00 0.00 5,300.00 Other Services & Charges 221-4-5420-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 221-4-5420-4409 Contractual Services 3,300.00 0.00 0.00 0.00 3,300.00 221-4-5420-4438 Credit Card Fees 2,800.00 153.61 153.61 5.49 2,646.39 TOTAL Other Services & Charges 7,100.00 153.61 153.61 2.16 6,946.39 TOTAL Skating 32,550.00 1,800.48 2,091.55 6.43 30,458.45 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 221-ICE ARENA Culture & Recreation 16.67% OF YEAR COMP. Arena Concessions CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5430-4103 Part-time Pay 21,300.00 2,672.31 3,831.83 17.99 17,468.17 221-4-5430-4104 PERA 200.00 59.89 105.03 52.52 94.97 221-4-5430-4105 FICA 1,300.00 165.69 325.22 25.02 974.78 221-4-5430-4107 Medicare 300.00 38.78 76.07 25.36 223.93 TOTAL Personal Services 23,100.00 2,936.67 4,338,15 18.78 18,761.85 Supplies 221-4-5430-4219 Operating Supplies 2,150.00 149.79 149.79 6.97 2,000.21 221-4-5430-4259 Other Merchandise For Resale 24,750.00 5,486.21 5,971.69 24.13 18,778.31 TOTAL Supplies 26,900.00 5,636.00 6,121.48 22.76 20,778.52 TOTAL Arena Concessions 50,000.00 8,572.67 10,459.63 20.92 39,540.37 TOTAL Culture & Recreation 990,000.00 57,282.68 77,856.68 7.86 912,143.32 TOTAL EXPENDITURES 990,000.00 57,282.68 77,856.68 7.86 912,143.32 REVENUES OVER/(UNDER) EXPENDITURES ( 88,950.00) 2,646.81 23,717.80 ( 112,667.80) 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 233,300.00 810.00 960.00 0.41 232,340.00 TOTAL REVENUES 233,300.00 810.00 960.00 0.41 232,340.00 EXPENDITURE SUMMARY Culture & Recreation Golf Course 233,300.00 7,002.64 14,808.24 6.35 218,491.76 TOTAL Culture & Recreation 233,300.00 7,002.64 14,808.24 6.35 218,491.76 TOTAL EXPENDITURES 233,300.00 7,002.64 14,808.24 6.35 218,491.76 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 6,192.64) ( 13,848.24) 13,848.24 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 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 17,000.00 810.00 960.00 5.65 16,040.00 222-3-0000-3467 Concessions 16,000.00 0.00 0.00 0.00 16,000.00 222-3-0000-3469 Other Sales 3,500.00 0.00 0.00 0.00 3,500.00 222-3-0000-3476 Green Fees 110,000.00 0.00 0.00 0.00 110,000.00 222-3-0000-3477 Membership Fees 17,000.00 0.00 0.00 0.00 17,000.00 222-3-0000-3478 Golf Cart Rental 20,000.00 0.00 0.00 0.00 20,000.00 222-3-0000-3479 Tournaments 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Charges for Services 188,500.00 810.00 960.00 0.51 187,540.00 Other Revenue Sales Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Transfers In 44,800.00 0.00 0.00 0.00 44,800.00 TOTAL Pinewood Golf Course 233,300.00 810.00 960.00 0.41 232,340.00 TOTAL REVENUE 233,300.00 810.00 960.00 0.41 232,340.00 3-13-2013 08:37 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2013 222-PINEWOOD GOLF COURSE Culture & Recreation 16.67% OF YEAR COMP. Golf Course CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 222-4-5300-4101 Regular Pay 90,100.00 5,095.38 7,378.95 8.19 82,721.05 222-4-5300-4103 Part-time Pay 29,900.00 0.00 0.00 0.00 29,900.00 222-4-5300-4104 PERA 8,700.00 369.42 734.18 8.44 7,965.82 222-4-5300-4105 FICA 7,450.00 310.56 617.12 8.28 6,832.88 222-4-5300-4107 Medicare 1,750.00 72.62 144.32 8.25 1,605.68 222-4-5300-4108 Insurance 6,250.00 484.01 968.02 15.49 5,281.98 222-4-5300-4109 Workers Comp 1,700.00 ( 64.00) 382.25 22.49 1,317.75 TOTAL Personal Services 145,850.00 6,267.99 10,224.84 7.01 135,625.16 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4217 Uniform Allowance 600.00 21.38 21.38 3.56 578.62 222-4-5300-4219 Operating Supplies 28,150.00 331.96 331.96 1.18 27,818.04 222-4-5300-4259 Other Merchandise For Resale 9,500.00 0.00 0.00 0.00 9,500.00 TOTAL Supplies 43,250.00 353.34 353.34 0.82 42,896.66 Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 59.85 59.85 2.49 2,340.15 222-4-5300-4331 Travel, Conferences & Schools 250.00 51.00 51.00 20.40 199.00 222-4-5300-4349 Advertising/Marketing 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4361 Insurance 10,700.00 0.00 2,715.75 25.38 7,984.25 222-4-5300-4389 Utilities 6,600.00 216.22 216.22 3.28 6,383.78 222-4-5300-4401 Bldg Repair/Maint Services 8,000.00 20.04 20.04 0.25 7,979.96 222-4-5300-4404 Equip Repair/Maint Services 4,000.00 0.00 720.00 18.00 3,280.00 222-4-5300-4415 Equipment Rental 1,350.00 0.00 0.00 0.00 1,350.00 222-4-5300-4437 Taxes & Licenses 900.00 0.00 413.00 45.89 487.00 222-4-5300-4438 Credit Card Fees 5,000.00 34.20 34.20 0.68 4,965.80 TOTAL Other Services & Charges 44,200.00 381.31 4,230.06 9.57 39,969.94 Capital Outlay Debt Service TOTAL Golf Course 233,300.00 7,002.64 14,808.24 6.35 218,491.76 TOTAL Culture & Recreation 233,300.00 7,002.64 14,808.24 6.35 218,491.76 TOTAL EXPENDITURES 233,300.00 7,002.64 14,808.24 6.35 218,491.76 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 6,192.64) ( 13,848.24) 13,848.24 * g 11!: p Jflj"q g g C iflil g e rM o @ e m z e. ,2 -6.0 y 00 b 1 N m 502 y w e S 1 ° A ao wi 0Q io w 3 o. 0 of p, s o $ > .. < h C X N k m m P. ° ° 0 C g A a oa' _ ° C m °= y v w s< e 3 . a o A 4, --z: . o e ^J 00 0 D N O 00 O\ U 0 R - N 0N N N p . U O J W W W 0 J W N o � A A U 0 0 .•. N O in J O O v U U ' p C O O O O Vp O O O O $ 8p 0 0 0 , , N O J8 1 O O A A A 00 n ; O G 0 G p O N N r N . A. .w. d ✓ t/1 in N N o N t0 W O 0 A w W T . ,.. 6-' e. O O fN/1 . . fN/1 i . . T. T i i O\ b O\ O\ . i .� J slk d3 .\ y -1:: , t0 U W N 0a i a 1 U 0 w b U A J W N N O , w , J W W N U 00 0 A , .' W Opp W Up J J 00 A U W W U W O OW A z tt - , O 0)0 O , U A i A r U O W O N A A , , N — t'', z tol \ ,-, 4x, .W+ A r N N N a e z A 00 N N O O U tO W 0. p p J Poo p Op v O Op O O � p Qp m ? " �,: O O J 0 0 0 J A O O A a v O J b w T 's; O O pW J t°Q it, \ - `m rA D. e e e eee e eeee e e e e e e eeee eee z C 7,14 0 O y 5 4 m to AA b T N A ao N O R d N , r VU,1 U .W+ N J A N '0 n+ W J N b N V 1 N N a ' \ C W O to 00 O J to W 0 N 00 W at N W Ja J U N n °i ��,. tom.] C1J 0 0 0 0 0 p 0 to to U o 0 tO o to t„ to O p 'Z 'g r O 00 O O , O O 00 , 0 O 00000 0000 N W n t0 J N W W .•. N 0 A W O A .AP b d ° Y N U, W 00 J i.+ A W d r"n.p O00 In O 00 W A O U w A ' N . W ' N Ut \ .J.. v0.Ni a�i O.-.O i O v N r . b `-' ,v N - _, d H J O J O b a o - U w W N W tO c r l v W °•0a0 t0 J N O N V1 O O I. p� N O 00 J 00 ?. w U O 0 oo -4 00 tO 0) . O \•• W , av00 00 � O N N o y .—•' Ji N O 00 o U U O A \N O O W w O 0 4 oo 0t O O A AA O D U 1:-.) A O A o0 d e Sa\ .4+ O pp J A W W O Oa W A O 0 J 'o DAi O A o ~ A a A O U a O U O N e ee e eee e eeee e eeeee eeee yg W iv W W y °e .-+ N N - U t0 A W N "f 00 00 U 0 00 U U W C J O tO 6004 .0 .0. d A p 0o I=.1,01,.., -0-0'0'0 p O 0 0 � 0 0 „ o O O � 0 0 0 0000 '4 ›. 5' p_ A O W A ^ O a+ ° \�� 00 CO CO JO W o0 a J it to t0 N W pJp-O . w 0 Vv i v A A W�. .U. ONO A O a N N r••. ttot b A W N — y 0 0 U8 ppU 00 U U r N Ot i0 Ot ao r O to 0 A I. O O N .1.) . W�0 00 A \ . . — — r oo A .. N CO O J W W W T v '4 , t0 A N a\ O oo a0 p i U Ut O W t0 C e ' N 000 N - 00 .- J p O J i0 T J U t0 00 6 \ oe C O g 00 b C $ 6 p .J+ O J U . O S J \ O O W O W e eee e eeee e even e eeee 3-13-2013 08:38 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: FEBRUARY 28TH, 2013 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 24,828.73 120.97 24,949.70 101-1010 Cash - General Fund 5,822,535.73 ( 636,234.52) 5,186,301.21 211-1010 Cash - Library 452,164.85 ( 5,159.09) 447,005.76 221-1010 Cash - Ice Arena 169,546.65 15,443.55 184,990.20 222-1010 Cash - Pinewood Golf Course ( 2,972.35) ( 7,379.64) ( 10,351.99) 223-1010 Cash - Sr Citizen Account 11,270.24 0.00 11,270.24 225-1010 Cash - Park Dedication 5,239.98 15,068.00 20,307.98 228-1010 Cash - Landfill 753,901.38 9,277.38 763,178.76 231-1010 Cash - Landfill Const Debris 703,442.73 0.00 703,442.73 240-1010 Cash - Micro Loan Fund 912,867.59 2,466.97 915,334.56 241-1010 Cash - Federal DEED 706,709.15 0.00 706,709.15 242-1010 Cash - State DEED 402,115.27 0.00 402,115.27 245-1010 Cash - Development Fund 886,478.25 0.00 886,478.25 290-1010 Cash - Capital Outlay Reserve 1,237,248.28 75,055.75 1,312,304.03 291-1010 Cash - Insurance Reserve 363,158.39 ( 6,908.96) 356,249.43 292-1010 Cash - Govt Bldgs Reserve 4,989,852.91 ( 387,006.26) 4,602,846.65 294-1010 Cash - Drug Forfeiture 25,466.53 2,128.86 27,595.39 295-1010 Cash - Severance Pay Reserve 146,393.56 0.00 146,393.56 296-1010 Cash - GRE Reserve 1,575,686.27 0.00 1,575,686.27 311-1010 Cash - 2003A GO Bonds 52,735.05 ( 92,865.00) ( 40,129.95) 312-1010 Cash - 2005A GO Bonds 230,001.36 ( 117,992.50) 112,008.86 313-1010 Cash - 2007C GO Bonds 386,693.93 ( 346,999.98) 39,693.95 333-1010 Cash - 2010A GO Cap Imp Bonds 782,177.55 ( 604,512.50) 177,665.05 345-1010 Cash - 2012A CIP Bonds-PW 128,981.86 ( 127,738.60) 1,243.26 350-1010 Cash - State-Aid Road Bonds 3,270.95 ( 3,270.95) 0.00 403-1010 Cash - Street Improvement 4,644,502.03 ( 16,667.50) 4,627,834.53 404-1010 Cash - Surface Water Managemnt 186,879.43 4,143.10 191,022.53 406-1010 Cash - City Wide Trunk Util 4,367,866.84 143,250.00 4,511,116.84 410-1010 Cash - Equipment Replacement 966,743.57 18,805.71 985,549.28 426-1010 Cash - YMCA 870,826.89 0.00 870,826.89 440-1010 Cash - Park Improvement 123,049.31 ( 373.87) 122,675.44 459-1010 Cash - TIF #19 Highway 169 367,115.45 0.00 367,115.45 602-1010 Cash - Wastewater Treatment 5,245,273.95 ( 142,315.01) 5,102,958.94 603-1010 Cash - Liquor 1,626,571.45 ( 23,847.91) 1,602,723.54 605-1010 Cash - Garbage 606,547.85 2,497.63 609,045.48 801-1010 Cash - Interest 0.00 31,692.15 31,692.15 821-1010 Cash - Developer Escrow 53,803.90 2,408.00 56,211.90 TOTAL CLAIM ON CASH 39,828,975.51 ( 2,196,914.22) 37,632,061.29 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 42,886,746.76 ( 1,393,118.14) 41,493,628.62 999-1001 PY BANK ACCOUNT (31,439,960.81) ( 803,796.08) (32,243,756.89) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 39,828,975.51 ( 2,196,914.22) 37,632,061.29