Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #4 07-16-2012
INFORMATION Elk -� River MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: July 16, 2012 SUBJECT: June 2012 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, Pinewood Golf Course, and Ice Arena special revenue funds. These funds are the primary concern in analyzing the city's financial health. For the month of June, actual revenues (except for property taxes and state aids) and expenditures should run 50% of the annual budget. It is natural for some 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 exceeded. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Revenues: • Excluding transfers, revenue collections are about 37% of budget. 70% of the first half property taxes were received in June and the remainder of the first half will be collected in July. • Licenses and permits are about 62% of budget estimate due to the annual renewal of business licenses and building permits for commercial build -outs. • Charges for services are above budget estimates at about 65 %, with the second -half Otsego fire contract and annual Big Lake Township fire contract billing in June. • Fines and forfeits are about 46% of budget, but lag a month in collections from the state. • The majority of transfers in will be recorded in July. Expenditures. • Excluding transfers, the total departmental expenditures are slightly under 42% and almost all departments are well within or below budget. • The transfer out to Pinewood Golf will be made at the end of the year when all revenues and expenditures are finalized. Ice Arena As of the end of June, revenues exceed expenditures by $41,265. Revenue collections of $334,580 are 46% of budget estimates and expenditures of $293,315 are at 46% of budget. Ice rental revenues are at 45% of budget estimates. Pinewood Golf For the month ended June, revenues exceed expenditures by $8,194. Excluding transfers in, total revenue collections of $106,102 are about 54% of budget and expenditures of $97,908 are about 41 % of budget. Green fee revenues exceed last year's revenues as of the end of June by over $13,600. Attachments: General Fund Revenue & Expense Report Enterprise Funds — Budget to Actual Cash Report — All Funds 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 1 REVENUE &ASXOF: JUNEP300TH`U 012ITED) INFORMATION 101 - GENERAL. FUND FINANCIAL SUMMARY REVENUE SUMMARY General Fund TOTAL REVENUES EXPENDITURE SUMMARY 50.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 12,311,900.00 3,475,943.16 4,430,327.84 35.98 7,881,572.16 12,311,900.00 3,475,943.16 4,430,327.84 35.98 7,881,572.16 General Government Mayor & Council 172,250.00 5,592.51 65,447.61 38.00 106,802.39 Cable TV 86,600.00 7,011.78 37,667.70 43.50 48,932.30 Administrative Services 482,950.00 35,932.84 219,620.78 45.47 263,329.22 Human Resources 164,500.00 11,476.79 78,478.83 47.71 86,021.17 Elections 38,050.00 9.28 1,201.91 3.16 36,848.09 Finance 464,450.00 29,036.57 249,358.56 53.69 215,091.44 Information Technology 242,000.00 14,851.80 110,016.23 45.46 131,983.77 Legal 228,000.00 15,656.50 99,183.19 43.50 128,816.81 Community Development 69,250.00 5,330.01 32,006.35 46.22 37,243.65 Planning 304,700.00 23,360.11 141,659.07 46.49 163,040.93 City Hall Maintenance 304,150.00 21,208.33 125,846.62 41.38 178,303.38 Contingency 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL General Government 2,774,450.00 169,466.52 1,160,486.85 41.83 1,613,963.15 Public Safety Police Administration 565,500.00 45,106.86 277,385.74 49.05 288,114.26 Patrol 2,350,050.00 159,925.11 964,695.23 41.05 1,385,354.77 Investigations 764,750.00 54,078.51 330,466.39 43.21 434,283.61 Police Support Services 503,500.00 34,905.41 215,836.68 42.87 287,663.32 Police Reserves 18,900.00 8.84 6,469.52 34.23 12,430.48 Public safety building 210,150.00 14,325.01 86,803.89 41.31 123,346.11 Fire Administration 555,500.00 67,273.32 240,419.46 43.28 315,080.54 Fire Inspections 188,000.00 14,711.82 84,437.40 44.91 103,562.60 Emergency Management 103,900.00 1,056.48 9,759.84 9.39 94,140.16 Building Safety 473,350.00 36,088.42 218,242.61 46.11 255,107.39 Environmental 48,850.00 1,508.12 18,524.04 37.92 30,325.96 TOTAL Public Safety 5,782,450.00 428,987.90 2,453,040.80 42.42 3,329,409.20 Public Works Street Maintenance 1,505,300.00 126,485.74 558,516.41 37.10 946,783.59 Snow Removal 288,400.00 1,529.75 98,191.50 34.05 190,208.50 Equipment Services 247,900.00 17,654.08 103,014.07 41.55 144,885.93 Engineering 133,550.00 9,285.89 55,157.87 41.30 78,392.13 TOTAL Public Works 2,175,150.00 154,955.46 814,879.85 37.46 1,360,270.15 7 -12 -2012 06:53 AM CITY OF ELK RIVER 354,541.14 PAGE: 2 459,258.86 REVENUE & EXPENSE REPORT (UNAUDITED) 47,272.32 274,104.02 45.44 AS OF: JUNE 30TH, 2012 197,000.00 33,241.06 --- _- ° --_-- =UND 32.40 133,165.97 14,100.00 FINANCIP -L SUMMARY 0.00 50.00% OF YEAR COMP. 226,500.00 CURRENT CURRENT YEAR TO DATE % OF BUDGET 129,567.94 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 75,880.75 354,541.14 43.57 459,258.86 603,250.00 47,272.32 274,104.02 45.44 329,145.98 197,000.00 33,241.06 63,834.03 32.40 133,165.97 14,100.00 0.00 0.00 0.00 14,100.00 226,500.00 21,637.49 96,932.06 42.80 129,567.94 1,854,650.00 178,031.62 789,411.25 42.56 1,065,238.75 0.00 14,710.52 28,541.10 0.00 ( 28,541.10) 50,850.00 2,438.95 19,050.25 37.46 31,799.75 50,850.00 17,149.47 47,591.35 93.59 3,258.65 40,500.00 0.00 0.00 0.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 12,678,050.00 948,590.97 5,265,410.10 41.53 7,412,639.90 ( 366,150.00) 2,527,352.19 ( 835,082.26) 468,932.26 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 REV__?, 7J= S General Fund Taxes 101 -3- 0000 -3111 Current Ad Valorem Taxes 101 -3- 0000 -3121 Gravel Tax TOTAL Taxes CURRENT CURRENT BUDGET PERIOD 50.00% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 9,142,200.00 3,217,895.42 3,218,464.78 35.20 5,923,735.22 70,000.00 0.00 6,562.70 9.38 63,437.30 9,212,200.00 3,217,895.42 3,225,027.48 35.01 5,987,172.52 Licenses & Permits 101 -3- 0000 -3211 Liquor License 53,000.00 15,640.00 61,920.00 116.83 ( 8,920.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 112.50 3.75 2,887.50 101 -3- 0000 -3214 Apartment License 17,000.00 4,350.00 21,330.00 125.47 ( 4,330.00) 101 -3- 0000 -3216 Mining License 20,000.00 0.00 4,328.50 21.64 15,671.50 101 -3- 0000 -3217 Garbage Hauler License 2,100.00 0.00 570.00 27.14 1,530.00 101 -3- 0000 -3218 Other Business License /Permit 17,000.00 635.00 8,145.00 47.91 8,855.00 101 -3- 0000 -3229 NPDES Permit 2,500.00 1,225.00 2,800.00 112.00 ( 300.00) 101 -3- 0000 -3231 Building Permit 153,000.00 24,328.85 94,959.15 62.06 58,040.85 101 -3- 0000 -3232 Plumbing /Heating Permit 129,150.00 3,135.30 52,738.43 40.84 76,411.57 101 -3- 0000 -3233 Permit Surcharge 400.00 294.07 1,790.65 447.66 ( 1,390.65) 101 -3- 0000 -3235 Animal License 3,500.00 210.00 3,610.50 103.16 ( 110.50) 101 -3- 0000 -3236 Parking Permit 3,000.00 20.00 258.59 8.62 2,741.41 101 -3- 0000 -3237 Other Non - Business Lic /Permit 8,000.00 700.00 3,210.00 40.13 4,790.00 TOTAL Licenses & Permits 412,650.00 50,538.22 255,773.32 61.98 156,876.68 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 4,875.03 10,188.82 33.96 19,811.18 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 4,875.03 151,179.84 27.87 391,270.16 Charges for Services 101 -3- 0000 -3412 Planning & Zoning Fees 15,000.00 700.00 6,975.00 46.50 8,025.00 101 -3- 0000 -3413 Plan Check Fee 41,000.00 11,596.35 43,062.77 105.03 ( 2,062.77) 101 -3- 0000 -3415 Special Assessment Search 1,000.00 340.00 720.00 72.00 280.00 101 -3- 0000 -3417 Copies 2,500.00 570.80 1,587.31 63.49 912.69 101 -3- 0000 -3418 Other General Govt Services 4,000.00 295.50 1,496.75 37.42 2,503.25 101 -3- 0000 -3430 Lockout Fees 7,500.00 640.00 3,910.00 52.13 3,590.00 101 -3- 0000 -3431 Police Services 2,000.00 100.50 1,757.75 87.89 242.25 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 225.00 1,700.00 56.67 1,300.00 101 -3- 0000 -3436 Fire Contracts 199,600.00 108,046.52 195,954.04 98.17 3,645.96 101 -3- 0000 -3437 Fire Calls 4,000.00 3,175.00 2,500.00 62.50 1,500.00 101 -3- 0000 -3451 Street Services 35,000.00 420.00 2,300.00 6.57 32,700.00 7 -12 -2012 06:53 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERA FUND CURRENT CURRENT YEAR TO DATE REVENUES BUDGET PERIOD ACTUAL 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 10.1 -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 Other Revenue 101 -3- 0000 -3621 Interest Income 101 -3- 0000 -3625 Refunds & Reimbursements 101 -3- 0000 -3626 Contributions 101 -3- 0000 -3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101 -3- 0000 -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 PAGE: 4 50.00% OF YEAR COMP. OF BUDGET BUDGET BALANCE 89,150.00 0.00 16,382.58 18.38 72,767.42 129,000.00 7,968.21 90,654.29 70.27 38,345.71 14,100.00 0.00 0.00 0.00 14,100.00 17,000.00 369.02 12,631.48 74.30 4,368.52 5,700.00 4.30 2,326.67 40.82 3,373.33 2,400.00 200.00 1,200.00 50.00 1,200.00 3,000.00 520.00 2,020.00 67.33 980.00 400.00 65.00 200.00 50.00 200.00 650,350.00 135,256.20 424,878.64 65.33 225,471.36 120,000.00 11,508.96 51,428.36 42.86 68,571.64 12,000.00 540.00 9,102.25 75.85 2,897.75 500.00 0.00 0.00 0.00 500.00 132,500.00 12,048.96 60,530.61 45.68 71,969.39 100,000.00 0.00 11,591.79 11.59 88,408.21 66,500.00 69.00 701.35 1.05 65,798.65 25,650.00 146.00 18,390.00 71.70 7,260.00 8,000.00 1,046.88 4,327.41 54.09 3,672.59 200,150.00 1,261.88 35,010.55 17.49 165,139.45 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 54,067.45 277,927.40 55.59 222,072.60 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 54,067.45 277,927.40 23.93 883,672.60 TOTAL General Fund 12,311,900.00 3,475,943.16 4,430,327.84 35.98 7,881,572.16 TOTAL REVENUE 12,311,900.00 3,475,943.16 4,430,327.84 35.98 7,881,572.16 7 -12 -2012 06:53 AM CITY OF ELK RIVER 38,500.00 PAGE: 5 19,247.94 REVENUE & EXPENSE REPORT (UNAUDITED) 19,252.06 101 -4 -1110 -4104 PERA AS OF: JUNE 30TH, 2012 101.67 610.02 101- GENER:s. FUND 1,289.98 101 -4- 1110 -4105 FICA 2,400.00 111.06 50.00% OF YEAR COMP. 1,733.64 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101 -4- 1110 -4103 Part -time Pay 38,500.00 3,207.99 19,247.94 49.99 19,252.06 101 -4 -1110 -4104 PERA 1,900.00 101.67 610.02 32.11 1,289.98 101 -4- 1110 -4105 FICA 2,400.00 111.06 666.36 27.77 1,733.64 101 -4- 1110 -4107 Medicare 550.00 46.51 279.06 50.74 270.94 101 -4- 1110 -4109 Workers Comp 50.00 16.25 48.75 97.50 1.25 TOTAL Personal Services 43,400.00 3,483.48 20,852.13 48.05 22,547.87 Supplies Insurance 8,700.00 680.00 4,080.00 46.90 4,620.00 101 -4- 1110 -4201 Office Supplies 3,200.00 0.00 131.20 4.10 3,068.80 TOTAL Supplies 3,200.00 0.00 131.20 4.10 3,068.80 Other Services & Charges 101 -4- 1110 -4319 Other Professional Services 11,050.00 1,480.16 5,458.52 49.40 5,591.48 101 -4- 1110 -4322 Postage 400.00 0.00 111.04 27.76 288.96 101 -4- 1110 -4331 Travel, Conferences & Schools 2,600.00 72.89 291.89 11.23 2,308.11 101 -4 -.1110 -4359 Publishing 17,700.00 97.50 6,710.72 37.91 10,989.28 101 -4 -1110 -4361 Insurance 69,450.00 0.00 25,401.50 36.58 44,048.50 101 -4 -1110 -4433 Dues & Subscriptions 16,000.00 0.00 500.00 3.13 15,500.00 101 -4- 1110 -4440 Miscellaneous 8,450.00 458.48 5,990.61 70.89 2,459.39 TOTAL Other Services & Charges 125,650.00 2,109.03 44,464.28 35.39 81,185.72 Capital Outlay TOTAL Mayor & Council 172,250.00 5,592.51 65,447.61 38.00 106,802.39 Cable TV Personal Services 101 -4- 1120 -4101 Regular Pay 57,450.00 4,334.40 26,006.40 45.27 31,443.60 101 -4 -1120 -4103 Part -time Pay 6,500.00 357.00 2,001.77 30.80 4,498.23 101 -4- 1120 -4104 PERA 4,150.00 314.24 2,039.49 49.14 2,110.51 101 -4- 1120 -4105 FICA 3,950.00 268.16 1,737.01 43.97 2,212.99 101 -4- 1120 -4107 Medicare 950.00 62.72 406.23 42.76 543.77 101 -4- 1120 -4108 Insurance 8,700.00 680.00 4,080.00 46.90 4,620.00 101 -4- 1120 -4109 Workers Comp 250.00 64.25 192.75 77.10 57.25 TOTAL Personal Services 81,950.00 6,080.77 36,463.65 44.49 45,486.35 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 1,197.95 70.47 101 -4 -1120 -4201 Office Supplies 1,700.00 TOTAL Supplies 502.05 .1.,700.00 Other Services & Charges 50.00 101 -4- 1120 -4322 Postage 50.00 101 -4- 1120 -4331 Travel, Conferences & Schools 1,250.00 101 -4- 1120 -4404 Equip Repair /Maint Services 1,650.00 TOTAL Other Services & Charges 2,950.00 Capital Outlay 26,650.00 2,028.01 TOTAL Cable TV Administrative Services Personal Services 101 -4- 1210 -4101 Regular Pay 101 -4- 1210 -4103 Part -time Pay 101 -4- 1210 -4104 PERA 101 -4- 1210 -4105 FICA 101 -4- 1210 -4107 Medicare 101 -4 -1210 -4108 Insurance 101 -4- 1210 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4 -1210 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1210 -4319 Other Professional Services 101 -4 -1210 -4321 Telephone 101 -4- 1210 -4322 Postage 101 -4- 1210 -4331 Travel, Conferences & Schools 101 -4- 1210 -4334 Car Allowance 101 -4- 1210 -4361 Insurance 101 -4- 1210 -4404 Equip Repair /Maint Services 101 -4- 1210 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 931.01 1,197.95 70.47 502.05 931.01 1,197.95 70.47 502.05 0.00 0.00 0.00 50.00 0.00 6.10 0.49 1,243.90 0.00 0.00 0.00 1,650.00 0.00 6.10 0.21 2,943.90 86,600.00 7,011.78 37,667.70 43.50 48,932.30 306,650.00 23,491.66 140,949.96 45.96 165,700.04 41,200.00 2,857.12 17,388.35 42.20 23,811.65 25,200.00 1,910.25 12,474.01 49.50 12,725.99 21,550.00 1,641.76 10,683.37 49.57 10,866.63 5,050.00 383.95 2,498.46 49.47 2,551.54 26,650.00 2,028.01 13,679.57 51.33 12,970.43 2,100.00 467.50 1,402.50 66.79 697.50 428,400.00 32,780.25 199,076.22 46.47 229,323.78 9,500.00 741.28 2,381.06 25.06 7,118.94 9,500.00 741.28 2,381.06 25.06 7,118.94 5,500.00 0.00 5,508.00 100.15 ( 8.00) 800.00 36.09 200.30 25.04 599.70 1,000.00 0.00 228.23 22.82 771.77 7,300.00 761.33 2,259.98 30.96 5,040.02 4,800.00 369.24 2,400.06 50.00 2,399.94 300.00 0.00 91.00 30.33 209.00 23,550.00 1,095.31 7,076.59 30.05 16,473.41 11800.00 149.34 399.34 22.19 1,400.66 45,050.00 2,411.31 18,163.50 40.32 26,886.50 TOTAL Administrative Services 482,950.00 35,932.84 219,620.78 45.47 263,329.22 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Human Resources Personal Services 101 -4- 1220 -4101 Regular Pay 101 -4- 1220 -4103 Part -time Pay 101 -4 -1220 -4104 PERA 101 -4 -1220 -4105 FICA 101 -4 -1220 -4107 Medicare 101 -4 -1220 -4108 Insurance 101 -4- 1220 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1220 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1220 -4319 Other Professional Services 101 -4- 1220 -4322 Postage 101 -4- 1220 -4331 Travel, Conferences & Schools 101 -4- 1220 -4433 Dues & Subscriptions 101 -4- 1220 -4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 101 -4- 1220 -4560 Equipment TOTAL Capital Outlay 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 CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 50.00% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 69,200.00 5,323.62 31,941.72 46.16 37,258.28 49,300.00 3,603.20 23,350.49 47.36 25,949.51 8,600.00 647.20 4,357.91 50.67 4,242.09 7,350.00 541.80 3,624.06 49.31 3,725.94 1,700.00 126.70 847.51 49.85 852.49 10,750.00 949.00 6,124.00 56.97 4,626.00 700.00 164.50 493.50 70.50 206.50 147,600.00 11,356.02 70,739.19 47.93 76,860.81 4,300.00 46.92 2,177.71 50.64 2,122.29 4,300.00 46.92 2,177.71 50.64 2,122.29 3,000.00 0.00 79.90 2.66 2,920.10 550.00 0.00 510.95 92.90 39.05 2,350.00 0.00 141.42 6.02 2,208.58 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 73.85 438.10 43.81 561.90 7,900.00 73.85 1,170.37 14.81 6,729.63 4,700.00 0.00 4,391.56 93.44 308.44 4,700.00 0.00 4,391.56 93.44 308.44 164,500.00 11,476.79 78,478.83 47.71 86,021.17 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 296.04 6.37 4,353.96 4,650.00 0.00 296.04 6.37 4,353.96 600.00 0.00 236.59 39.43 363.41 700.00 0.00 0.00 0.00 700.00 1,000.00 0.00 660.00 66.00 340.00 100.00 9.28 9.28 9.28 90.72 1,000.00 0.00 0.00 0.00 1,000.00 3,400.00 9.28 905.87 26.64 2,494.13 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101- GENERAZ FUND General Government DEPARTMENTAL EXPENDITURES Capital Outlay TOTAL Elections Finance Personal Services 101 -4- 1310 -4101 Regular Pay 101 -4- 1310 -4104 PERA 101 -4 -1310 -4105 FICA 101 -4- 1310 -4107 Medicare 101 -4 -1310 -4108 Insurance 101 -4- 1310 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1310 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1310 -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 -4433 Dues & Subscriptions 101 -4- 1310 -4438 Credit Card Fees TOTAL Other Services & Charges Capital Outlay TOTAL Finance Information Technology Personal Services 101 -4 -1350 -4101 Regular Pay 101 -4- 1350 -4103 Part -time Pay 101 -4- 1350 -4104 PERA 101 -4- 1350 -4105 FICA 101 -4- 1350 -4107 Medicare 101 -4- 1350 -4108 Insurance 101 -4- 1350 -4109 Workers Comp TOTAL Personal Services 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 38,050.00 9.28 1,201.91 3.16 36,848.09 293,600.00 22,581.95 135,491.67 46.15 158,108.33 21,300.00 1,637.16 10,625.51 49.89 10,674.49 18,200.00 1,334.16 8,691.29 47.75 9,508.71 4,250.00 312.04 2,032.73 47.83 2,217.27 26,650.00 2,187.01 13,122.06 49.24 13,527.94 1,800.00 407.75 1,223.25 67.96 576.75 365,800.00 28,460.07 171,186.51 46.80 194,613.49 5,350.00 56.58 1,320.19 24.68 4,029.81 5,350.00 56.58 1,320.19 24.68 4,029.81 18,300.00 0.00 13,440.00 73.44 4,860.00 50,000.00 0.00 48,730.50 97.46 1,269.50 400.00 33.23 99.17 24.79 300.83 2,600.00 0.00 1,034.98 39.81 1,565.02 2,350.00 142.47 626.93 26.68 1,723.07 950.00 0.00 0.00 0.00 950.00 12,200.00 1.11 11,586.36 94.97 613.64 1,500.00 505.00 1,180.00 78.67 320.00 51000.00 ( 161.89) 153.92 3.08 4,846.08 93,300.00 519.92 76,851.86 82.37 16,448.14 464,450.00 29,036.57 249,358.56 53.69 215,091.44 130,950.00 10,235.93 61,415.57 46.90 69,534.43 5,000.00 0.00 0.00 0.00 5,000.00 9,500.00 742.10 4,810.59 50.64 4,689.41 8,450.00 587.62 3,816.93 45.17 4,633.07 2,000.00 137.42 892.66 44.63 1,107.34 20,450.00 1,706.00 10,236.00 50.05 10,214.00 800.00 189.00 567.00 70.88 233.00 177,150.00 13,598.07 81,738.75 46.14 95,411.25 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101- GENERFS. FUND General Government DEPARTMENTAL EXPENDITURES 50.00% 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 7.74 4,131.42 26.48 11,468.58 TOTAL Supplies 15,600.00 7.74 4,131.42 26.48 11,468.58 Other Services & Charges 3,350.00 243.24 1,582.04 47.23 1,767.96 101 -4- 1350 -4319 Other Professional Services 8,000.00 0.00 0.00 0.00 8,000.00 101 -4- 1350 -4321 Telephone 1,450.00 131.10 961.58 66.32 488.42 101 -4- 1350 -4331 Travel, Conferences & Schools 8,000.00 54.56 111.84 1.40 7,888.16 101 -4- 1350 -4404 Equip Repair /Maint Services 20,900.00 1,060.33 12,172.64 58.24 8,727.36 TOTAL Other Services & Charges 38,350.00 1,245.99 13,246.06 34.54 25,103.94 Capital Outlay 101 -4 -1350 -4560 Equipment 10,900.00 0.00 10,900.00 100.00 0.00 TOTAL Capital Outlay 10,900.00 0.00 10,900.00 100.00 0.00 TOTAL Information Technology 242,000.00 14,851.80 110,016.23 45.46 131,983.77 Legal Personal Services Supplies Other Services & Charges 101 -4- 1400 -4304 Legal Fees 228,000.00 15,656.50 99,183.19 43.50 128,816.81 TOTAL Other Services & Charges 228,000.00 15,656.50 99,183.19 43.50 128,816.81 TOTAL Legal 228,000.00 15,656.50 99,183.19 43.50 128,816.81 Community Development Personal Services 101 -4- 1500 -4101 Regular Pay 53,750.00 4,134.40 24,754.72 46.06 28,995.28 101 -4- 1500 -4104 PERA 3,900.00 299.74 1,941.60 49.78 1,958.40 101 -4- 1500 -4105 FICA 3,350.00 243.24 1,582.04 47.23 1,767.96 101 -4 -1500 -4107 Medicare 800.00 56.88 369.95 46.24 430.05 101 -4- 1500 -4108 Insurance 6,000.00 521.00 3,116.22 51.94 2,883.78 101 -4- 1500 -4109 Workers Comp 900.00 74.75 224.25 24.92 675.75 TOTAL Personal Services 68,700.00 5,330.01 31,988.78 46.56 36,711.22 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 . 101- GF_.':E-RAi. FUND General Government DEPARTMENTAL EXPENDITURES 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 16,626.74 99,760.44 46.15 116,389.56 15,700.00 101 -4 -1500 -4201 Office Supplies 150.00 0.00 17.57 11.71 132.43 TOTAL Supplies 150.00 0.00 17.57 11.71 132.43 Other Services & Charges 1,698.61 29,150.00 2,442.00 14,652.00 50.26 101 -4- 1500 -4331 Travel, Conferences & Schools 400.00 0.00 0.00 0.00 400.00 TOTAL Other Services & Charges 400.00 0.00 0.00 0.00 400.00 TOTAL Community Development Planning Personal Services 101 -4- 1510 -4101 Regular Pay 101 -4- 1510 -4104 PERA 101 -4- 1510 -4105 FICA 101 -4- 1510 -4107 Medicare 101 -4- 1510 -4108 Insurance 101 -4- 1510 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1510 -4201 Office Supplies 101 -4- 1510 -4212 Fuels & Lubs 101 -4- 1510 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 1510 -4321 Telephone 101 -4- 1510 -4322 Postage 101 -4- 1510 -4331 Travel, Conferences & Schools 101 -4- 1510 -4359 Publishing 101 -4- 1510 -4361 Insurance 101 -4- 1510 -4404 Equip Repair /Maint Services 101 -4- 1510 -4433 Dues & Subscriptions 101 -4- 1510 -4440 Miscellaneous 101 -4- 1510 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Planning 69,250.00 5,330.01 32,006.35 46.22 37,243.65 216,150.00 16,626.74 99,760.44 46.15 116,389.56 15,700.00 1,205.44 7,823.58 49.83 7,876.42 13,400.00 950.12 6,206.07 46.31 7,193.93 3,150.00 222.20 1,451.39 46.08 1,698.61 29,150.00 2,442.00 14,652.00 50.26 14,498.00 1,300.00 229.25 687.75 52.90 612.25 278,850.00 21,675.75 130,581.23 46.83 148,268.77 4,250.00 70.37 672.66 15.83 3,577.34 1,600.00 296.59 627.13 39.20 972.87 200.00 0.00 451.38 225.69 ( 251.38) 6,050.00 366.96 1,751.17 28.94 4,298.83 800.00 124.67 524.95 65.62 275.05 3,200.00 0.00 965.56 30.17 2,234.44 1,650.00 0.00 646.00 39.15 1,004.00 8,000.00 720.00 2,610.00 32.63 5,390.00 450.00 0.00 149.00 33.11 301.00 3,600.00 406.07 3,396.20 94.34 203.80 1,050.00 0.00 635.00 60.48 415.00 250.00 0.00 0.00 0.00 250.00 800.00 66.66 399.96 50.00 400.04 19,800.00 1,317.40 9,326.67 47.10 10,473.33 304,700.00 23,360.11 141,659.07 46.49 163,040.93 7 -12 -2012 06:53 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101- GENERAL FUND General Government CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL City Hall Maintenance Personal Services 101 -4- 1600 -4101 Regular Pay 101 -4 -1600 -4102 Overtime Pay 101 -4- 1600 -4103 Part -time Pay 101 -4- 1600 -4104 PERA 101 -4- 1600 -4105 FICA 101 -4- 1600 -4107 Medicare 101 -4- 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 -4401 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 TOTAL City Hall Maintenance Contingency Other Services & Charges 101 -4- 1900 -4440 Miscellaneous TOTAL Other Services & Charges PAGE: 11 50.00% OF YEAR COMP. OF BUDGET BUDGET BALANCE 108,500.00 8,356.28 49,634.06 45.75 58,865.94 2,500.00 29.28 536.87 21.47 1,963.13 20,800.00 1,880.17 9,183.50 44.15 11,616.50 9,550.00 702.30 4,546.77 47.61 5,003.23 8,200.00 643.53 4,016.08 48.98 4,183.92 1,900.00 150.52 939.28 49.44 960.72 17,700.00 1,302.20 7,753.11 43.80 9,946.89 5,550.00 1,276.50 3,829.50 69.00 1,720.50 174,700.00 14,340.78 80,439.17 46.04 94,260.83 4,650.00 296.72 991.09 21.31 3,658.91 1,700.00 0.00 565.78 33.28 1,134.22 29,400.00 2,587.35 11,147.54 37.92 18,252.46 35,750.00 2,884.07 12,704.41 35.54 23,045.59 13,950.00 967.58 5,635.41 40.40 8,314.59 1,500.00 0.00 436.16 29.08 1,063.84 5,100.00 0.00 2,094.50 41.07 3,005.50 36,700.00 1,417.31 12,443.69 33.91 24,256.31 31,150.00 1,365.26 10,503.87 33.72 20,646.13 2,500.00 0.00 189.43 7.58 2,310.57 2,800.00 233.33 1,399.98 50.00 1,400.02 93,700.00 3,983.48 32,703.04 34.90 60,996.96 304,150.00 21,208.33 125,846.62 41.38 178,303.38 217,550.00 0.00 0.00 0.00 217,550.00 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL Contingency 217,550.00 0.00 0.00 0.00 217,550.00 TOTAL General Government 2,774,450.00 169,466.52 1,160,486.85 41.83 1,613,963.15 7 -12 -2012 06:53 AM CITY OF ELK RIVER 129,636.48 PAGE: 12 151,263.52 REVENUE & EXPENSE REPORT (UNAUDITED) 3,111.30 20,192.94 49.92 AS OF: JUNE 30TH, 2012 2,550.00 194.26 1,262.23 49.50 1,287.77 23,700.00 Public Safety 11,400.00 50.00% OF YEAR COMP. 64,850.00 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration Personal Services 101 -4- 2110 -4101 Regular Pay 101 -4- 2110 -4104 PERA 101 -4 -2110 -4107 Medicare 101 -4- 2110 -4108 Insurance 101 -4- 2110 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4 -2110 -4201 Office Supplies 101 -4- 2110 -4217 Uniform Allowance 101 -4- 2110 -4219 Operating Supplies TOTAL Supplies 280,900.00 21,606.08 129,636.48 46.15 151,263.52 40,450.00 3,111.30 20,192.94 49.92 20,257.06 2,550.00 194.26 1,262.23 49.50 1,287.77 23,700.00 1,900.00 11,400.00 48.10 12,300.00 64,850.00 14,593.50 43,780.50 67.51 21,069.50 412,450.00 41,405.14 206,272.15 50.01 206,177.85 14,000.00 210.00 2,109.36 15.07 11,890.64 2,300.00 0.00 2,195.00 95.43 105.00 4,600.00 0.00 1,256.37 27.31 3,343.63 20,900.00 210.00 5,560.73 26.61 15,339.27 Other Services & Charges 101 -4 -2120 -4101 101 -4- 2110 -4319 Other Professional Services 3,400.00 37.31 773.81 22.76 2,626.19 101 -4- 2110 -4321 Telephone 29,300.00 1,726.19 7,994.67 27.29 21,305.33 101 -4- 2110 -4322 Postage 2,600.00 0.00 1,282.48 49.33 1,317.52 101 -4- 2110 -4331 Travel, Conferences & Schools 3,350.00 1,027.25 2,257.25 67.38 1,092.75 101 -4- 2110 -4359 Publishing 500.00 0.00 0.00 0.00 500.00 101 -4 -2110 -4361 Insurance 7,550.00 0.00 4,306.00 57.03 3,244.00 101 -4- 2110 -4404 Equip Repair /Maint Services 80,400.00 700.97 47,094.40 58.58 33,305.60 101 -4- 2110 -4433 Dues & Subscriptions 4,250.00 0.00 1,704.00 40.09 2,546.00 101 -4- 2110 -4437 Taxes & Licenses 800.00 0.00 140.25 17.53 659.75 TOTAL Other Services & Charges 132,150.00 3,491.72 65,552.86 49.60 66,597.14 Capital Outlay TOTAL Police Administration 565,500.00 45,106.86 277,385.74 49.05 288,114.26 Patrol Personal Services 101 -4 -2120 -4101 Regular Pay 1,479,700.00 105,001.71 625,165.59 42.25 854,534.41 101 -4- 2120 -4102 Overtime Pay 90,000.00 3,277.30 27,692.33 30.77 62,307.67 101 -4- 2120 -4104 PERA 226,050.00 15,584.12 101,886.70 45.07 124,163.30 101 -4- 2120 -4107 Medicare 20,400.00 1,288.99 8,465.94 41.50 11,934.06 101 -4- 2120 -4108 Insurance 179,350.00 14,080.00 84,723.54 47.24 94,626.46 TOTAL Personal Services 1,995,500.00 139,232.12 847,934.10 42.49 1,147,565.90 7 -12 -2012 06:53 AM CITY OF ELK RIVER 34,466.06 PAGE: 13 108,533.94 REVENUE & EXPENSE REPORT (UNAUDITED) 304.37 13,794.00 60.37 AS OF: NNE 30TH, 2012 63,750.00 2,027.76 FUND 27.97 45,916.21 28,000.00 Dublic Safety 6,686.44 50.00°% OF YEAR COMP. 257,600.00 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL 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 & Charoes 101 -4- 2120 -4331 Travel, Conferences & Schools 101 -4- 2120 -4404 Equip Repair /Maint Services 101 -4- 2120 -4433 Dues & Subscriptions 101 -4- 2120 -4460 Equip Replacement Charge TOTAL Other Services & Charges 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 -4219 Operating Supplies TOTAL Supplies 143,000.00 11,916.83 34,466.06 24.10 108,533.94 22,850.00 304.37 13,794.00 60.37 9,056.00 63,750.00 2,027.76 17,833.79 27.97 45,916.21 28,000.00 2,287.63 6,686.44 23.88 21,313.56 257,600.00 16,536.59 72,780.29 28.25 184,819.71 25,150.00 0.00 10,830.18 43.06 14,319.82 26,700.00 443.90 10,835.66 40.58 15,864.34 550.00 0.00 40.00 7.27 510.00 44,550.00 3,712.50 22,275.00 50.00 22,275.00 96,950.00 4,156.40 43,980.84 45.36 52,969.16 2,350,050.00 159,925.11 964,695.23 41.05 1,385,354.77 514,100.00 37,331.23 223,959.31 43.56 290,140.69 45,000.00 2,490.08 12,100.06 26.89 32,899.94 80,500.00 5,726.22 36,567.96 45.43 43,932.04 6,900.00 435.00 2,792.01 40.46 4,107.99 69,100.00 5,721.57 34,141.88 49.41 34,958.12 715,600.00 51,704.10 309,561.22 43.26 406,038.78 5,350.00 0.00 3,990.00 74.58 1,360.00 12,900.00 105.74 6,005.63 46.56 6,894.37 18,250.00 105.74 9,995.63 54.77 8,254.37 Other Services & Charges 101 -4- 2130 -4319 Other Professional Services 5,450.00 0.48 845.11 15.51 4,604.89 101 -4- 2130 -4331 Travel, Conferences & Schools 13,250.00 1,301.52 4,264.41 32.18 8,985.59 101 -4- 2130 -4433 Dues & Subscriptions 600.00 0.00 0.00 0.00 600.00 101 -4- 2130 -4460 Equip Replacement Charge 11,600.00 966.67 5,800.02 50.00 5,799.98 TOTAL Other Services & Charges 30,900.00 2,268.67 10,909.54 35.31 19,990.46 Capital Outlay TOTAL Investigations 764,750.00 54,078.51 330,466.39 43.21 434,283.61 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 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 101 -4- 2150 -4107 Medicare 101 -4- 2150 -4108 Insurance TOTAL Personal Services Supplies 101 -4- 2150 -4201 Office Supplies 101 -4- 2150 -4217 Uniform Allowance 101 -4- 2150 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2150 -4331 Travel, Conferences & Schools 101 -4- 2150 -4404 Equip Repair /Maint Services 101 -4- 2150 -4409 Contractual Services 101 -4- 2150 -4433 Dues & Subscriptions 101 -4- 2150 -4460 Equip Replacement Charge TOTAL Other Services & Charges 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 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 342,350.00 25,196.84 151,180.93 44.16 191,169.07 3,500.00 0.00 529.46 15.13 2,970.54 25,100.00 1,826.76 11,874.72 47.31 13,225.28 21,450.00 1,502.23 9,836.80 45.86 11,613.20 5,000.00 351.31 2,300.42 46.01 2,699.58 59,300.00 4,393.01 25,325.75 42.71 33,974.25 456,700.00 33,270.15 201,048.08 44.02 255,651.92 1,000.00 0.00 222.89 22.29 777.11 3,000.00 293.52 1,317.39 43.91 1,682.61 14,900.00 612.03 5,851.64 39.27 9,048.36 18,900.00 905.55 7,391.92 39.11 11,508.08 3,350.00 213.04 887.97 26.51 2,462.03 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 0.00 3,158.69 19.74 12,841.31 500.00 0.00 250.00 50.00 250.00 6,200.00 516.67 3,100.02 50.00 3,099.98 27,900.00 729.71 7,396.68 26.51 20,503.32 503,500.00 34,905.41 215,836.68 42.87 287,663.32 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 8.84 4,610.26 131.72 ( 1,110.26) 5,000.00 0.00 149.26 2.99 4,850.74 8,500.00 8.84 4,759.52 55.99 3,740.48 7 -12 -2012 06:53 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 "_01- GENERz- FUND Public Safety CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL Other Services & Charges 101 -4- 2160 -4319 Other Professional Services 101 -4- 2160 -4321 Telephone 101 -4- 2160 -4331 Travel, Conferences & Schools 101 -4- 2160 -4359 Publishing 101 -4- 2160 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Police Reserves Public safety building Personal Services 101 -4- 2190 -4101 Regular Pay 101 -4- 2190 -4104 PERA 101 -4- 2190 -4105 FICA 101 -4- 2190 -4107 Medicare 101 -4- 2190 -4108 Insurance 101 -4- 2190 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2190 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2190 -4361 Insurance 101 -4- 2190 -4389 Utilities 101 -4- 2190 -4401 Bldg Repair /Maint Services TOTAL Other Services & Charges Capital Outlay TOTAL Public safety building Fire Administration PAGE: 15 50.00% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 1,500.00 0.00 1,125.00 75.00 375.00 100.00 0.00 0.00 0.00 100.00 1,700.00 0.00 0.00 0.00 1,700.00 150.00 0.00 0.00 0.00 150.00 1,000.00 0.00 585.00 58.50 415.00 4,450.00 0.00 1,710.00 38.43 2,740.00 18,900.00 8.84 6,469.52 34.23 12,430.48 104,700.00 7,749.57 45,848.36 43.79 58,851.64 7,600.00 561.84 3,605.05 47.43 3,994.95 6,500.00 472.20 3,039.43 46.76 3,460.57 1,500.00 110.44 710.86 47.39 789.14 13,700.00 1,220.47 7,198.33 52.54 6,501.67 4,550.00 1,044.25 3,132.75 68.85 1,417.25 138,550.00 11,158.77 63,534.78 45.86 75,015.22 15,000.00 1,400.79 7,828.84 52.19 7,171.16 15,000.00 1,400.79 7,828.84 52.19 7,171.16 5,550.00 0.00 2,383.00 42.94 3,167.00 19,450.00 757.29 8,298.43 42.67 11,151.57 31,600.00 1,008.16 4,758.84 15.06 26,841.16 56,600.00 1,765.45 15,440.27 27.28 41,159.73 210,150.00 14,325.01 86,803.89 41.31 123,346.11 Personal Services 101 -4- 2310 -4101 Regular Pay 91,000.00 7,201.46 43,214.38 47.49 47,785.62 101 -4- 2310 -4103 Part -time Pay 182,250.00 10,128.21 60,316.25 33.10 121,933.75 101 -4- 2310 -4104 PERA 13,750.00 1,057.96 6,840.53 49.75 6,909.47 101 -4- 2310 -4105 FICA 12,250.00 652.01 4,223.66 34.48 8,026.34 101 -4- 2310 -4106 Other Retirement Contributions 30,000.00 30,000.00 30,000.00 100.00 0.00 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND Public Safety 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALP.NCE 101 -4- 2310 -4107 Medicare 3,950.00 234.86 1,522.44 38.54 2,427.56 101 -4- 2310 -4108 Insurance 6,100.00 782.04 4,705.36 77.14 1,394.64 101 -4- 2310 -4109 Workers Comp 23,650.00 7,635.75 22,907.25 96.86 742.75 TOTAL Personal Services 362,950.00 57,692.29 173,729.87 47.87 189,220.13 Supplies 50.78 935.24 101 -4 -2320 -4108 Insurance 15,300.00 1,240.11 7,440.66 101 -4- 2310 -4201 Office Supplies 4,250.00 7.86 1,345.96 31.67 2,904.04 101 -4- 2310 -4212 Fuels & Lubs 6,950.00 1,401.98 3,419.30 49.20 3,530.70 101 -4- 2310 -4217 Uniform Allowance 7,450.00 667.90 1,925.21 25.84 5,524.79 101 -4- 2310 -4219 Operating Supplies 32,100.00 255.85 9,208.29 28.69 22,891.71 101 -4- 2310 -4221 Equipment Parts 7,000.00 41.45 783.41 11.19 6,216.59 TOTAL Supplies 57,750.00 2,375.04 16,682.17 28.89 41,067.83 Other Services & Charges 8,261.33 101 -4- 2310 -4319 Other Professional Services 5,400.00 0.00 1,871.02 34.65 3,528.98 101 -4- 2310 -4321 Telephone 3,150.00 192.53 1,054.17 33.47 2,095.83 101 -4 -2310 -4322 Postage 500.00 0.00 449.23 89.85 50.77 101 -4- 2310 -4331 Travel, Conferences & Schools 17,450.00 2,119.76 5,560.75 31.87 11,8.89.25 101 -4- 2310 -4359 Publishing 300.00 0.00 0.00 0.00 300.00 101 -4- 2310 -4361 Insurance 16,100.00 0.00 7,104.50 44.13 8,995.50 101 -4- 2310 -4389 Utilities 11,700.00 292.63 4,508.44 38.53 7,191.56 101 -4 -2310 -4401 Bldg Repair /Maint Services 5,450.00 739.82 1,511.11 27.73 3,938.89 101 -4- 2310 -4404 Equip Repair /Maint Services 40,550.00 1,127.92 10,206.22 25.17 30,343.78 101 -4- 2310 -4433 Dues & Subscriptions 1,400.00 0.00 1,342.00 95.86 58.00 101 -4- 2310 -4460 Equip Replacement Charge 32,800.00 2,733.33 16,399.98 50.00 16,400.02 TOTAL Other Services & Charges 134,800.00 7,205.99 50,007.42 37.10 84,792.58 Capital Outlay TOTAL Fire Administration 555,500.00 67,273.32 240,419.46 43.28 315,080.54 Fire Inspections Personal Services 101 -4- 2320 -4101 Regular Pay 132,350.00 10,168.22 61,009.32 46.10 71,340.68 101 -4 -2320 -4104 PERA 15,200.00 1,168.60 7,584.43 49.90 7,615.57 101 -4- 2320 -4105 FICA 3,350.00 260.65 1,779.97 53.13 1,570.03 101 -4- 2320 -4107 Medicare 1,900.00 145.18 964.76 50.78 935.24 101 -4 -2320 -4108 Insurance 15,300.00 1,240.11 7,440.66 48.63 7,859.34 TOTAL Personal Services 168,100.00 12,982.76 78,779.14 46.86 89,320.86 Supplies 101 -4 -2320 -4201 Office Supplies 2,250.00 0.00 392.74 17.46 1,857.26 101 -4- 2320 -4212 Fuels & Lubs 2,600.00 241.59 786.82 30.26 1,813.18 101 -4- 2320 -4217 Uniform Allowance 1,400.00 1,158.18 1,158.18 82.73 241.82 101 -4- 2320 -4219 Operating Supplies 5,150.00 149.04 800.93 15.55 4,349.07 TOTAL Supplies 11,400.00 1,548.81 3,138.67 27.53 8,261.33 7 -12 -2012 06:53 AM 101 - GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 PAGE: 17 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 188,000.00 14,711.82 84,437.40 44.91 103,562.60 101 -4- 2320 -4321 Telephone 3,350.00 180.25 975.53 29.12 2,374.47 101 -4- 2320 -4331 Travel, Conferences & Schools 2,250.00 0.00 100.00 4.44 2,150.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 0.00 960.00 71.11 390.00 TOTAL Other Services & Charges 8,500.00 180.25 2,519.59 29.64 5,980.41 TOTAL Fire Inspections 188,000.00 14,711.82 84,437.40 44.91 103,562.60 Emergency Management Personal Services 101 -4- 2330 -4101 Regular Pay 9,400.00 710.20 4,261.20 45.33 5,138.80 101 -4- 2330 -4104 PERA 1,350.00 102.28 663.81 49.17 686.19 101 -4- 2330 -4107 Medicare 150.00 10.30 66.85 44.57 83.15 101 -4- 2330 -4108 Insurance 600.00 39.13 234.78 39.13 365.22 TOTAL Personal Services 11,500.00 861.91 5,226.64 45.45 6,273.36 Supplies 101 -4 -2330 -4201 Office Supplies 500.00 0.00 143.74 28.75 356.26 101 -4- 2330 -4219 Operating Supplies 9,150.00 0.00 2,992.08 32.70 6,157.92 TOTAL Supplies 9,650.00 0.00 3,135.82 32.50 6,514.18 Other Services & Charges 101 -4- 2330 -4321 Telephone 1,650.00 26.00 130.00 7.88 1,520.00 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 72.38 361.93 24.13 1,138.07 101 -4 -2330 -4404 Equip Repair /Maint Services 5,800.00 96.19 805.45 13.89 4,994.55 101 -4- 2330 -4433 Dues & Subscriptions 100.00 0.00 100.00 100.00 0.00 TOTAL Other Services & Charges 13,750.00 194.57 1,397.38 10.16 12,352.62 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 103,900.00 1,056.48 9,759.84 9.39 94,140.16 Building Safety --------- - - - - -- --------------- 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 1.01 - GENERAL FUND Public Safety 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Safety 473,350.00 36,088.42 218,242.61 46.11 101 -4 -2410 -4101 Regular Pay 325,750.00 25,058.24 150,049.44 46.06 175,700.56 101 -4- 2410 -4103 Part -time Pay 26,450.00 1,990.76 12,392.63 46.85 14,057.37 101 -4- 2410 -4104 PERA 25,550.00 1,961.07 12,738.68 49.86 12,811.32 101 -4- 2410 -4105 FICA 21,850.00 1,585.64 10,368.17 47.45 11,481.83 101 -4 -2410 -4107 Medicare 5,100.00 370.83 2,424.77 47.54 2,675.23 101 -4 -2410 -4108 Insurance 41,400.00 3,213.01 19,203.94 46.39 22,196.06 101 -4- 2410 -4109 Workers Comp 1,650.00 382.25 1,146.75 69.50 503.25 TOTAL Personal Services 447,750.00 34,561.80 208,324.38 46.53 239,425.62 Supplies TOTAL Personal Services 42,200.00 1,425.40 17,623.93 41.76 24,576.07 101 -4- 2410 -4201 Office Supplies 4,300.00 169.20 906.28 21.08 3,393.72 101 -4 -2410 -4212 Fuels & Lubs 3,200.00 548.18 1,551.23 48.48 1,648.77 101 -4- 2410 -4217 Uniform Allowance 900.00 81.00 646.30 71.81 253.70 101 -4- 2410 -4219 Operating Supplies 1,550.00 11.47 144.13 9.30 1,405.87 TOTAL Supplies 9,950.00 809.85 3,247.94 32.64 6,702.06 Other Services & Charges 101 -4- 2410 -4321 Telephone 1,250.00 74.36 463.69 37.10 786.31 101 -4- 2410 -4322 Postage 400.00 0.00 171.62 42.91 228.38 101 -4 -2410 -4331 Travel, Conferences & Schools 1,550.00 20.00 633.34 40.86 916.66 101 -4- 2410 -4361 Insurance 650.00 0.00 295.00 45.38 355.00 101 -4- 2410 -4404 Equip Repair /Maint Services 7,700.00 222.41 2,816.64 36.58 4,883.36 101 -4- 2410 -4433 Dues & Subscriptions 800.00 125.00 640.00 80.00 160.00 101 -4- 2410 -4460 Equip Replacement Charge 3,300.00 275.00 1,650.00 50.00 1,650.00 TOTAL Other Services & Charges 15,650.00 716.77 6,670.29 42.62 8,979.71 Capital Outlay TOTAL Building Safety 473,350.00 36,088.42 218,242.61 46.11 255,107.39 Environmental Personal Services 101 -4- 2440 -4101 Regular Pay 31,600.00 1,110.78 13,220.01 41.84 18,379.99 101 -4- 2440 -4104 PERA 2,300.00 45.74 935.73 40.68 1,364.27 101 -4- 2440 -4105 FICA 1,950.00 66.16 841.05 43.13 1,108.95 101 -4- 2440 -4107 Medicare 450.00 15.48 196.74 43.72 253.26 101 -4- 2440 -4108 Insurance 5,300.00 46.49 2,008.15 37.89 3,291.85 101 -4- 2440 -4109 Workers Comp 600.00 140.75 422.25 70.38 177.75 TOTAL Personal Services 42,200.00 1,425.40 17,623.93 41.76 24,576.07 7 -12 -2012 06:53 AM CITY OF ELK RIVER 189.28 PAGE: 19 310.72 REVENUE & EXPENSE REPORT (UNAUDITED) 4.09 50.33 33.55 AS OF: JUNE 30TH, 2012 650.00 18.16 101- GENERAL FUND 36.86 410.39 550.00 Public Safety 38.21 50.00% OF YEAR COMP. 800.00 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101 -4- 2440 -4201 Office Supplies 101 -4- 2440 -4212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101 -4- 2440 -4321 Telephone 101 -4- 2440 -4322 Postage 101 -4- 2440 -4331 Travel, Conferences & Schools 101 -4- 2440 -4359 Publishing 101 -4- 2440 -4404 Equip Repair /Maint Services 101 -4- 2440 -4409 Contractual Services 101 -4- 2440 -4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Environmental TOTAL Public Safety Street Maintenance Personal Services 101 -4- 3120 -4101 Regular Pay 101 -4- 3120 -4102 Overtime Pay 101 -4 -3120 -4103 Part -time Pay 101 -4- 3120 -4104 PERA 101 -4- 3120 -4105 FICA 101 -4- 3120 -4107 Medicare 101 -4- 3120 -4108 Insurance 101 -4- 3120 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 3120 -4201 Office Supplies 101 -4- 3120 -4212 Fuels & Lubs 101 -4- 3120 -4219 Operating Supplies 101 -4- 3120 -4226 Street Signs TOTAL Supplies 500.00 14.07 189.28 37.86 310.72 150.00 4.09 50.33 33.55 99.67 650.00 18.16 239.61 36.86 410.39 550.00 10.90 38.21 6.95 511.79 800.00 0.00 184.11 23.01 615.89 500.00 53.28 396.99 79.40 103.01 100.00 0.00 0.00 0.00 100.00 0.00 0.38 1.19 0.00 ( 1.19) 3,000.00 0.00 0.00 0.00 3,000.00 1,050.00 0.00 40.00 3.81 1,010.00 6,000.00 64.56 660.50 11.01 5,339.50 48,850.00 1,508.12 18,524.04 37.92 30,325.96 5,782,450.00 428,987.90 2,453,040.80 42.42 3,329,409.20 386,700.00 37,049.86 186,368.47 48.19 200,331.53 0.00 0.00 311.84 0.00 ( 311.84) 116,600.00 12,885.97 47,407.91 40.66 69,192.09 32,200.00 2,997.91 16,774.54 52.09 15,425.46 31,200.00 2,875.83 14,815.99 47.49 16,384.01 7,300.00 672.57 3,465.06 47.47 3,834.94 64,700.00 6,497.36 33,130.70 51.21 31,569.30 27,600.00 6,191.25 18,573.75 67.30 9,026.25 666,300.00 69,170.75 320,848.26 48.15 345,451.74 4,200.00 85.70 1,007.53 23.99 3,192.47 87,250.00 19,933.56 39,903.37 45.73 47,346.63 110,750.00 14,385.14 62,521.30 56.45 48,228.70 35,850.00 7,343.43 13,778.64 38.43 22,071.36 238,050.00 41,747.83 117,210.84 49.24 120,839.16 Other Services & Charges 101 -4- 3120 -4319 Other Professional Services 250.00 0.00 212.33 84.93 37.67 101 -4- 3120 -4321 Telephone 7,450.00 494.18 2,612.38 35.07 4,837.62 101 -4 -3120 -4322 Postage 200.00 0.00 76.02 38.01 123.98 101 -4- 3120 -4331 Travel, Conferences & Schools 2,500.00 500.00 1,712.27 68.49 787.73 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 7,688.00 41.00 11,062.00 7 -12 -2012 06:53 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND Public Works CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL 101 -4 -3120 -4389 Utilities 101 -4- 3120 -4401 Bldc Repair /Maint Services 101 -4- 3120 -4404 Equip Repair /Maint Services 101 -4 -3120 -4409 Contractual Services 101 -4- 3120 -4415 Equipment Rental 101 -4- 3120 -4417 Uniform Rental 101 -4- 3120 -4433 Dues & Subscriptions 101 -4- 3120 -4437 Taxes & Licenses 101 -4- 3120 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Street Maintenance Snow Removal Personal Services 101 -4- 3130 -4101 Regular Pay 101 -4- 3130 -4102 Overtime Pay 101 -4- 3130 -4103 Part -time Pay 101 -4 -3130 -4104 PERA 101 -4 -3130 -4105 FICA 101 -4- 3130 -4107 Medicare 101 -4- 3130 -4108 Insurance 101 -4- 3130 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 3130 -4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 101 -4- 3130 -4560 Equipment TOTAL Capital Outlay TOTAL Snow Removal Equipment Services PAGE: 20 50.00% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 36,000.00 3,123.48 17,720.43 49.22 18,279.57 4,500.00 0.00 1,413.43 31.41 3,086.57 5,000.00 2.21 825.99 16.52 4,174.01 419,000.00 3,138.44 38,283.35 9.14 380,716.65 5,500.00 96.19 538.89 9.80 4,961.11 4,700.00 233.49 766.95 16.32 3,933.05 350.00 0.00 286.25 81.79 63.75 500.00 0.00 446.00 89.20 54.00 95,750.00 7,979.17 47,875.02 50.00 47,874.98 600,950.00 15,567.16 120,457.31 20.04 480,492.69 1,505,300.00 126,485.74 558,516.41 37.10 946,783.59 100,300.00 0.00 36,833.84 36.72 63,466.16 20,000.00 0.00 6,537.25 32.69 13,462.75 9,100.00 0.00 4,821.54 52.98 4,278.46 8,350.00 0.00 3,489.80 41.79 4,860.20 8,000.00 0.00 3,028.56 37.86 4,971.44 1,900.00 0.00 708.26 37.28 1,191.74 17,100.00 0.00 6,210.18 36.32 10,889.82 7,650.00 1,529.75 4,589.25 59.99 3,060.75 172,400.00 1,529.75 66,218.68 38.41 106,181.32 96,000.00 0.00 31,972.82 33.31 64,027.18 96,000.00 0.00 31,972.82 33.31 64,027.18 20,000.00 0.00 0.00 0.00 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 288,400.00 1,529.75 98,191.50 34.05 190,208.50 7 -12 -2012 06:53 AM 101 - GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES Personal Services 101 -4 -3150 -4101 Regular Pay 101 -4- 3150 -4102 Overtime Pay 101 -4- 3150 -4104 PERA 101 -4- 3150 -4105 FICA 101 -4- 3150 -4107 Medicare 101 -4- 3150 -4108 Insurance 101 -4- 3150 -4109 Workers Comp TOTAL Personal Services 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 TOTAL Equipment Services Engineering CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, . 2012 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 166,050.00 12,772.81 73,204.28 44.09 92,845.72 0.00 0.00 232.56 0.00 ( 232.56) 12,050.00 926.02 5,777.97 47.95 6,272.03 10,300.00 747.56 4,698.06 45.61 5,601.94 2,400.00 174.84 1,098.74 45.78 1,301.26 23,400.00 1,778.00 10,031.61 42.87 13,368.39 4,500.00 1,027.25 3,081.75 68.48 1,418.25 218,700.00 17,426.48 98,124.97 44.87 120,575.03 20,200.00 1 18.56) 3,561.94 17.63 16,638.06 6,000.00 0.00 0.00 0.00 6,000.00 26,200.00 ( 18.56) 3,561.94 13.60 22,638.06 3,000.00 246.16 1,327.16 44.24 1,672.84 3,000.00 246.16 1,327.16 44.24 1,672.84 247,900.00 17,654.08 103,014.07 41.55 144,885.93 Personal Services Office Supplies 500.00 9.38 38.08 7.62 101 -4- 3300 -4101 Regular Pay 79,250.00 7,034.62 42,207.72 53.26 37,042.28 101 -4- 3300 -4104 PERA 5,750.00 510.00 3,310.00 57.57 2,440.00 101 -4- 3300 -4105 FICA 4,900.00 421.34 2,741.83 55.96 2,158.17 101 -4- 3300 -4107 Medicare 1,150.00 98.54 641.24 55.76 508.76 101 -4- 3300 -4108 Insurance 14,050.00 521.00 3,126.00 22.25 10,924.00 101 -4- 3300 -4109 Workers Comp 550.00 144.25 432.75 78.68 117.25 TOTAL Personal Services 105,650.00 8,729.75 52,459.54 49.65 53,190.46 Supplies 101 -4- 3300 -4201 Office Supplies 500.00 9.38 38.08 7.62 461.92 101 -4- 3300 -4212 Fuels & Lubs 600.00 38.28 93.55 15.59 506.45 101 -4- 3300 -4219 Operating Supplies 1,000.00 0.00 16.00 1.60 984.00 TOTAL Supplies 2,100.00 47.66 147.63 7.03 1,952.37 Other Services & Charges 101 -4- 3300 -4319 Other Professional Services 13,500.00 220.00 285.69 2.12 13,214.31 101 -4- 3300 -4321 Telephone 700.00 33.23 109.95 15.71 590.05 101 -4- 3300 -4322 Postage 150.00 0.00 33.51 22.34 116.49 101 -4- 3300 -4331 Travel, Conferences & Schools 2,700.00 0.00 215.50 7.98 2,484.50 101 -4- 3300 -4361 Insurance 200.00 0.00 91.00 45.50 109.00 101 -4- 3300 -4404 Equip Repair /Maint Services 7,800.00 192.75 1,440.05 18.46 6,359.95 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101- GENERAL FUND 22,765.24 154,521.45 44.88 189,778.55 6,600.00 Public Works 352.40 5.34 6,247.60 50.00% OF YEAR COMP. 20,412.95 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101 -4- 3300 -4460 Equip Replacement Charge 750.00 62.50 375.00 50.00 375.00 TOTAL Other Services & Charges 25,800.00 508.48 2,550.70 9.89 23,249.30 Capital Outlay 7,746.00 71.39 3,104.00 0.00 0.00 TOTAL Engineering TOTAL Public Works Parks Department Personal Services 101 -4 -5110 -4101 Regular Pay 101 -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 101 -4 -5110 -4110 Re- employment Compensation 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 -4460 Equip Replacement Charge TOTAL Other Services & Charges 133,550.00 9,285.89 55,157.87 41.30 78,392.13 2,175,150.00 154,955.46 814,879.85 37.46 1,360,270.15 344,300.00 22,765.24 154,521.45 44.88 189,778.55 6,600.00 3.56 352.40 5.34 6,247.60 58,.250.00 12,275.99 20,412.95 35.04 37,837.05 26,900.00 1,810.81 12,240.16 45.50 14,659.84 25,500.00 2,059.05 11,128.31 43.64 14,371.69 6,000.00 481.52 2,602.51 43.38 3,397.49 46,200.00 3,357.36 22,228.16 48.11 23,971.84 10,850.00 2,582.00 7,746.00 71.39 3,104.00 0.00 0.00 1,350.87 0.00 ( 1,350.87) 524,600.00 45,335.53 232,582.81 44.34 292,017.19 39,100.00 6,982.41 11,913.51 30.47 27,186.49 3,200.00 382.74 1,285.48 40.17 1,914.52 78,250.00 12,992.89 43,723.81 55.88 34,526.19 13,000.00 711.56 10,869.64 83.61 2,130.36 133,550.00 21,069.60 67,792.44 50.76 65,757.56 3,800.00 322.34 1,224.40 32.22 2,575.60 50.00 0.00 0.00 0.00 50.00 3,150.00 0.00 2,206.91 70.06 943.09 27,600.00 0.00 12,020.50 43.55 15,579.50 24,700.00 1,532.44 2,866.60 11.61 21,833.40 4,000.00 0.00 25.65 0.64 3,974.35 13,100.00 1,580.00 4,438.48 33.88 8,661.52 7,300.00 503.47 1,549.47 21.23 5,750.53 20,500.00 1,249.87 4,108.88 20.04 16,391.12 51,450.00 4,287.50 25,725.00 50.00 25,725.00 155,650.00 9,475.62 54,165.89 34.80 101,484.11 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES Capital Outlay TOTAL Parks Department Parks & Rec Admin Personal Services 101 -4 -5210 -4101 Regular Pay 101 -4 -5210 -4103 Part -time Pay 101 -4- 5210 -4104 PERA 101 -4 -5210 -4105 FICA 101 -4 -5210 -4107 Medicare 101 -4 -5210 -4108 Insurance 101 -4 -5210 -4109 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 Bldg 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 101 -4- 5220 -4110 Re- employment Compensation TOTAL Personal Services CURRENT CURRENT BUDGET PERIOD 50.00% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 813,800.00 75,880.75 354,541.14 43.57 459,258.86 352,350.00 26,971.31 161,120.03 45.73 191,229.97 45,300.00 3,489.00 20,368.47 44.96 24,931.53 27,200.00 2,206.34 14,208.37 52.24 12,991.63 23,300.00 1,760.60 11,410.48 48.97 11,889.52 5,450.00 411.73 2,668.48 48.96 2,781.52 52,700.00 4,001.81 23,749.75 45.07 26,950.25 4,450.00 1,026.00 3,078.00 69.17 1,372.00 510,750.00 39,868.79 236,603.58 46.32 274,146.42 10,200.00 214.38 4,598.24 45.08 5,601.76 10,200.00 214.38 4,598.24 45.08 5,601.76 4,800.00 315.17 1,991.56 41.49 2,808.44 6,000.00 0.00 2,129.18 35.49 3,870.82 6,850.00 529.00 2,232.46 32.59 4,617.54 32,400.00 5,164.75 12,221.78 37.72 20,178.22 650.00 0.00 295.00 45.38 355.00 7,400.00 335.04 2,342.60 31.66 5,057.40 13,300.00 1,000.46 6,896.10 51.85 6,403.90 9,350.00 ( 155.27) 3,459.52 37.00 5,890.48 1,550.00 0.00 1,334.00 86.06 216.00 82,300.00 7,189.15 32,902.20 39.98 49,397.80 603,250.00 47,272.32 274,104.02 45.44 329,145.98 82,000.00 13,402.28 25,995.03 31.70 56,004.97 2,400.00 275.18 715.78 29.82 1,684.22 4,350.00 830.97 1,620.21 37.25 2,729.79 1,200.00 194.35 378.92 31.58 821.08 0.00 0.00 405.40 0.00 ( 405.40) 89,950.00 14,702.78 29,115.34 32.37 60,834.66 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101 - GENERAL FUND Culture & Recreation DEPARTMENTAL, EXPENDITURES Supplies 101 -4- 5220 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4 -5220 -4409 Contractual Services 101 -4 -5220 -4412 Building Rent 101 -4 -5220 -4438 Credit Card Fees TOTAL Other Services & Charges 50..00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL. BUDGET BALANCE 37,000.00 7,093.48 11,596.31 31.34 25,4.03.69 37,000.00 7,093.48 11,596.31 31.34 25,403.69 64,050.00 10,796.78 18,731.62 29.25 45,318.38 1,500.00 103.44 1,607.94 107.20 ( 107.94) 4,500.00 544.58 2,782.82 61.84 1,717.18 70,050.00 11,444.80 23,122.38 33.01 46,927.62 TOTAL Recreation Programs 197,000.00 Concessions Personal Services 0.00 101 -4 -5230 -4103 Part -time Pay 3,650.00 101 -4 -5230 -4104 PERA 150.00 101 -4 -5230 -4105 FICA 250.00 101 -4 -5230 -4107 Medicare 50.00 TOTAL Personal Services 4,100.00 Supplies 0.00 101 -4- 5230 -4219 Operating Supplies 2,900.00 101 -4 -5230 -4259 Other Merchandise For Resale 7,000.00 TOTAL Supplies 9,900.00 Other Services & Charges 0.00 101 -4- 5230 -4401 Bldg Repair /Maint Services 100.00 TOTAL Other Services & Charges 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 33,241.06 63,834.03 32.40 133,165.97 0.00 0.00 0.00 3,650.00 0.00 0.00 0.00 150.00 0.00 0.00 0.00 250.00 0.00 0.00 0.00 50.00 0.00 0.00 0.00 4,100.00 0.00 0.00 0.00 2,900.00 0.00 0.00 0.00 7,000.00 0.00 0.00 0.00 9,900.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 100.00 14,100.00 0.00 0.00 0.00 14,100.00 58,550.00 9,174.77 31,694.81 54.13 26,855.19 62,350.00 5,589.11 30,317.57 48.62 32,032.43 8,750.00 663.38 4,397.63 50.26 4,352.37 7,500.00 881.84 3,931.26 52.42 3,568.74 1,750.00 206.22 919.34 52.53 830.66 14,100.00 1,154.51 6,927.06 49.13 7,172.94 650.00 145.25 435.75 67.04 214.25 153,650.00 17,815.08 78,623.42 51.17 75,026.58 7 -12 -2012 06:53 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 101- GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES Supplies 101 -4 -5510 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4 -5510 -4321 Telephone 101 -4 -5510 -4322 Postage 101 -4- 5510 -4331 Travel, Conferences & Schools 101 -4 -5510 -4361 Insurance 101 -4 -5510 -4389 Utilities 101 -4- 5510 -4401 Bldg Repair /Maint Services 101 -4 -5510 -4404 Equip Repair /Maint Services 101 -4 -5510 -4409 Contractual Services 101 -4 -5510 -4433 Dues & Subscriptions 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 -4103 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 -4322 Postage 101 -4 -6210 -4331 Travel, Conferences & Schools 101 -4 -6210 -4440 Miscellaneous TOTAL Other Services & Charges 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 13,350.00 1,186.64 3,180.35 23.82 10,169.65 13,350.00 1,186.64 3,180.35 23.82 10,169.65 2,600.00 152.48 942.20 36.24 1,657.80 2,500.00 790.00 1,293.32 51.73 1,206.68 1,900.00 20.00 175.50 9.24 1,724.50 1,600.00 0.00 708.50 44.28 891.50 9,300.00 516.33 3,755.33 40.38 5,544.67 13,750.00 1,271.03 6,340.02 46.11 7,409.98 1,950.00 330.93 1,080.75 55.42 869.25 7,450.00 10.00 125.00 1.68 7,325.00 950.00 145.00 707.67 74.49 242.33 42,000.00 2,635.77 15,128.29 36.02 26,871.71 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 21,637.49 96,932.06 42.80 129,567.94 1,854,650.00 178,031.62 789,411.25 42.56 1,065,238.75 0.00 9,607.92 19,267.52 0.00 ( 19,267.52) 0.00 1,050.33 2,100.66 0.00 ( 2,100.66) 0.00 711.98 1,427.71 0.00 ( 1,427.71) 0.00 603.93 1,210.90 0.00 ( 1,210.90) 0.00 143.42 287.54 0.00 ( 287.54) 0.00 1,491.00 2,991.78 0.00 ( 2,991.78) 0.00 190.25 190.25 0.00 ( 190.25) 0.00 13,798.83 27,476.36 0.00 ( 27,476.36) 0.00 ( 34.93) 0.00 0.00 0.00 0.00 ( 8.00)( 8.00) 0.00 8.00 0.00 954.62 1,072.74 0.00 ( 1,072.74) 0.00 911.69 1,064.74 0.00 ( 1,064.74) TOTAL Economic Development 0.00 14,710.52 28,541.10 0.00 ( 28,541.10) 7 -12 -2012 06:53 AM 101- GENERP_L FUND Economic Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 PAGE: 26 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Energy City 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL General Personal Services 0.00 0.00 0.00 40,500.00 TOTAL EXPENDITURES 12,678,050.00 101 -4- 6220 -4101 Regular Pay 29,300.00 1,576.98 12,820.18 43.75 16,479.82 101 -4- 6220 -4104 PERA 2,100.00 114.34 973.28 46.35 1,126.72 101 -4- 6220 -4105 FICA 1,800.00 91.00 802.42 44.58 997.58 101 -4- 6220 -4107 Medicare 400.00 21.28 187.69 46.92 212.31 101 -4- 6220 -4108 Insurance 3,250.00 116.25 1,245.94 38.34 2,004.06 TOTAL Personal Services 36,850.00 1,919.85 16,029.51 43.50 20,820.49 Supplies 101 -4- 6220 -4219 Operating Supplies 0.00 2.17 6.83 0.00 ( 6.83) TOTAL Supplies 0.00 2.17 6.83 0.00 ( 6.83) Other Services & Charges 101 -4- 6220 -4319 Other Professional Services 5,000.00 6.00 227.17 4.54 4,772.83 101 -4- 6220 -4331 Travel, Conferences & Schools 7,500.00 28.43 1,814.24 24.19 5,685.76 101 -4- 6220 -4359 Publishing 1,500.00 482.50 972.50 64.83 527.50 TOTAL Other Services & Charges 14,000.00 516.93 3,013.91 21.53 10,986.09 TOTAL Energy City 50,850.00 2,438.95 19,050.25 37.46 31,799.75 TOTAL Economic Development 50,850.00 17,149.47 47,591.35 93.59 3,258.65 Transfers Out Transfers Out 101 -4- 7000 -4724 Transfer - Pinewood 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers Out 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers Out 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL General 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL EXPENDITURES 12,678,050.00 948,590.97 5,265,410.10 41.53 7,412,639.90 REVENUES OVER /(UNDER) EXPENDITURES ( 366,150.00) 2,527,352.19 ( 835,082.26) 468,932.26 7 -12 -2012 06:54 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 221 -ICE ARENA FINANCIAL SUMMARY REVENUE SUMMARY Ice Arena Hockey Skating Concessions TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER /(UNDER) EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 50.00% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 569,600.00 16,721.81 257,814.47 45.26 311,785.53 30,000.00 ( 29,620.20) 17,376.80 57.92 12,623.20 65,800.00 ( 77.13) 19,552.87 29.72 46,247.13 69,000.00 104.53 39,836.00 57.73 29,164.00 644,450.00 39,037.99 293,314.88 734,400.00 ( 12,870.99) 334,580.14 45.56 399,819.86 543,550.00 35,167,25 246,819.09 45.41 296,730.91 25,000.00 1,518.00 9,479.33 37.92 15,520.67 28,750.00 978.40 11,147.47 38.77 17,602.53 47,150.00 1,374.34 25,868.99 54.87 21,281.01 644,450.00 39,037.99 293,314.88 45.51 351,135.12 644,450.00 39,037.99 293,314.88 45.51 351,135.12 89,950.00 ( 51,908.98) 41,265,26 48,684.74 7 -12 -2012 06:54 AM 221 -ICE ARENA REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 CURRENT CURRENT BUDGET PERIOD TEAR TO DATE ACTUAL 50.00% % OF BUDGET PAGE: 2 OF YEAR COMP. 3UDGET BALANCE Ice Arena Charges for Services 221 -3- 0000 -3464 Ice Rental 488,000.00 15,450.75 218,928.71 44.86 269,071.29 221 -3 -0000 -3465 Admissions 22,900.00 0.00 12,538.50 54.75 10,361.50 221 -3- 0000 -3466 Dry Floor Events 17,400.00 968.39 9,953.74 57.21 7,446.26 221 -3- 0000 -3468 Skate Sharpening 4,300.00 60.00 2,379.00 55.33 1,921.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 17,500.00 116.67 853.35 4.88 16,646.65 TOTAL Charges for Services 552,700.00 16,595.81 244,653.30 44.27 308,046.70 Other Revenue 221 -3- 0000 -3621 Interest Income 0.00 0.00 98.12 0.00 ( 98.12) 221 -3- 0000 -3622 Vending Machines 14,000.00 96.50 7,472.36 53.37 6,527.64 221 -3- 0000 -3626 Contributions 0.00 0.00 3,997.00 0.00 ( 3,997.00) 221 -3- 0000 -3629 Miscellaneous Revenue 2,800.00 5.70 1,429.19 51.04 1,370.81 TOTAL Other Revenue 16,800.00 102.20 12,996.67 77.36 3,803.33 Sales 221 -3- 0000 -3791 ATM Revenue 100.00 23.80 164.50 164.50 ( 64.50) TOTAL Sales 100.00 23.80 164.50 164.50 ( 64.50) Transfers In TOTAL Ice Arena Hockey Charges for Services 221 -3 -5410 -3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating 569,600.00 16,721.81 257,814.47 45.26 311,785.53 30,000.00 ( 29,620.20) 17,376.80 57.92 12,623.20 30,000.00 ( 29,620.20) 17,376.80 57.92 12,623.20 30,000.00 ( 29,620.20) 17,376.80 57.92 12,623.20 7 -12 -2012 06:54 AM 221 -ICE ARENA REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 50.00% % OF BUDGET PAGE: 3 OF YEAR COMP. BUDGET BALANCE Charges for Services 221 -3 -5420 -3461 Recreation Fees 62,000.00 152.00 16,220.00 26.16 45,780.00 221 -3 -5420 -3465 Admissions 3,800.00 ( 229.13) 3,332.87 87.71 467.13 TOTAL Charges for Services 65,800.00 ( 77.13) 19,552.87 29.72 46,247.13 Other Revenue TOTAL Skating 65,800.00 ( 77.13) 19,552.87 29.72 46,247.13 Concessions Charges for Services 221 -3 -5430 -3467 Concessions 69,000.00 104.53 39,836.00 57.73 29,164.00 TOTAL Charges for Services 69,000.00 104.53 39,836.00 57.73 29,164.00 TOTAL Concessions 69,000.00 104.53 39,836.00 57.73 29,164.00 TOTAL REVENUE 734,400.00 ( 12,870.99) 334,580.14 45.56 399,819.86 7 -12 -2012 06:54 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 221 -ICE ='.REN.L 50..00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 143.28 768.12 21.95 2,731.88 400.00 221 -4- 5400 -4101 Regular Pay 167,600.00 8,958.90 71,390.27 42.60 96,209.73 221 -4 -5400 -4103 Part -time Pay 59,300.00 5,966.75 38,093.56 64.24 21,206.44 221 -4 -5400 -4104 PERA 15,700.00 1,034.77 7,073.62 45.05 8,626.38 221 -4- 5400 -4105 FICA 14,100.00 878.11 7,070.69 50.15 7,029.31 221 -4 -5400 -4107 Medicare 3,350.00 205.37 1,653.65 49.36 1,696.35 221 -4- 5400 -4108 Insurance 26,400.00 1,416.00 10,356.00 39.23 16,044.00 221 -4- 5400 -4109 Workers Comp 8,000.00 1,789.75 5,369,25 67.12 2,630.75 TOTAL Personal Services 294,450.00 20,249.65 141,007.04 47.89 153,442.96 Supplies 8,112.08 39.57 12,387.92 221 -4 -5400 -4212 Fuels & Lubs 50.00 0.00 0.00 0.00 50.00 221 -4 -5400 -4217 Uniform Allowance 1,300.00 0.00 0.00 0.00 1,300.00 221 -4- 5400 -4219 Operating Supplies 34,250.00 1,468.00 14,550.01 42.48 19,699.99 221 -4- 5400 -4255 Soft Drinks /Mist 8,000.00 195.51 3,074.55 38.43 4,925.45 221 -4- 5400 -4259 Other Merchandise For Resale 600.00 0.00 0.00 0.00 600.00 TOTAL Supplies 44,200.00 1,663.51 17,624.56 39.87 26,575.44 Other Services & Charges 221 -4- 5400 -4321 Telephone 221 -4- 5400 -4322 Postage 221 -4 -5400 -4331 Travel, Conferences & Schools 221 -4- 5400 -4359 Publishing 221 -4- 5400 -4361 Insurance 221 -4- 5400 -4389 Utilities 221 -4- 5400 -4401 Bldg Repair /Maint Services 221 -4 -5400 -4409 Contractual Services 221 -4 -5400 -4415 Equipment Rental 221 -4 -5400 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221 -4- 5400 -4560 Equipment TOTAL Capital Outlay Transfers Out 3,500.00 143.28 768.12 21.95 2,731.88 400.00 0.00 120.76 30.19 279.24 1,000.00 51.83 125.28 12.53 874.72 2,000.00 225.00 2,091.59 104.58 ( 91.59) 7,800.00 0.00 3,413.00 43.76 4,387.00 142,450.00 11,677.30 67,371.92 47.30 75,078.08 22,750.00 884.82 4,831.14 21.24 17,918.86 1,200.00 0.00 328.90 27.41 871.10 2,800.00 271.86 794.70 28.38 2,005.30 500.00 0.00 230.00 46.00 270.00 184,400.00 13,254.09 80,075.41 43.42 104,324.59 20,500.00 0.00 8,112.08 39.57 12,387.92 20,500.00 0.00 8,112.08 39.57 12,387.92 TOTAL Ice Arena 543,550.00 35,167.25 246,819.09 45.41 296,730.91 7 -12 -2012 06:54 AM 221 -Ice = WREN; Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 PAGE: 5 50..00.% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey 25,000.00 1,518.00 9,479.33 37.92 15,520.67 Personal Services 221 -4 -5410 -4103 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 200.00 0.00 106.42 53.21 93.58 221 -4 -5410 -4219 Operating Supplies 12,550.00 15.19 6,011.49 47.90 6,538.51 TOTAL Supplies 12,550.00 15.19 6,011.49 47.90 6,538.51 Other Services & Charges 5,300.00 76.93 1,640.81 30.96 3,659.19 221 -4 -5410 -4409 Contractual Services 6,400.00 1,492.00 1,512.80 23.64 4,887.20 221 -4 -5410 -4438 Credit Card Fees 2,200.00 10.81 1,955.04 88.87 244.96 TOTAL Other Services & Charges 8,600.00 1,502.81 3,467.84 40.32 5,132.16 TOTAL Hockey 25,000.00 1,518.00 9,479.33 37.92 15,520.67 Skating Personal Services 221 -4 -5420 -4103 Part -time Pay 15,000.00 0.00 7,133.38 47.56 7,866.62 221 -4 -5420 -4104 PERA 1,000.00 0.00 319.39 31.94 680.61 221 -4- 5420 -4105 FICA 950.00 0.00 454.91 47.89 495.09 221 -4- 5420 -4107 Medicare 200.00 0.00 106.42 53.21 93.58 TOTAL Personal Services 17,150.00 0.00 8,014.10 46.73 9,135.90 Supplies 221 -4 -5420 -4219 Operating Supplies 5,300.00 76.93 1,640.81 30.96 3,659.19 TOTAL Supplies 5,300.00 76.93 1,640.81 30.96 3,659.19 Other Services & Charges 221 -4- 5420 -4359 Publishing 650.00 411.47 411.47 63.30 238.53 221 -4- 5420 -4409 Contractual Services 2,850.00 490.00 536.40 18.82 2,313.60 221 -4- 5420 -4438 Credit Card Fees 2,800.00 0.00 544.69 19.45 2,255.31 TOTAL Other Services & Charges 6,300.00 901.47 1,492.56 23.69 4,807.44 TOTAL Skating 28,750.00 978.40 11,147.47 38.77 17,602.53 7 -12 -2012 06:54 AM CITY OF ELK RIVER 293,314.88 45.51 351,135.12 PAGE: 6 REVENUES OVER /(UNDER) EXPENDITURES REVENUE & EXPENSE REPORT (UNAUDITED) 51,908.98) 41,265.26 48,684.74 AS OF: JUNE 30TH, 2012 -'21 -ICE ARENA Culture & Recreation 50.00% 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 537.25 6,494.30 31.07 14,405.70 221 -4 -5430 -4104 PERA 200.00 0.00 111.68 55.84 88.32 221 -4 -5430 -4105 FICA 1,300.00 33.31 459.26 35.33 840.74 221 -4 -5430 -4107 Medicare 300.00 7.79 107.39 35.80 192.61 TOTAL Personal Services 22,700.00 578.35 7,172.63 31.60 15,527.37 Supplies 221 -4 -5430 -4219 Operating Supplies 2,950.00 0.00 2,437.41 82.62 512.59 221 -4 -5430 -4259 Other Merchandise For Resale 21,500.00 795.99 16,258.95 75.62 5,241.05 TOTAL Supplies 24,450.00 795.99 18,696.36 76.47 5,753.64 TOTAL Arena Concessions 47,150.00 1,374.34 25,868.99 54.87 21,281.01 TOTAL Culture & Recreation 644,450.00 39,037.99 293,314.68 45.51 351,135.12 TOTAL EXPENDITURES 644,450.00 39,037.99 293,314.88 45.51 351,135.12 REVENUES OVER /(UNDER) EXPENDITURES 89,950.00 ( 51,908.98) 41,265.26 48,684.74 7 -12 -2012 06:54 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 GOLF FINANCIAL SU -MMTi RY REVENUE SUNASARY Pinewood Golf Course TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER /(UNDER) EXPENDITURES 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 236,500.00 31,393.84 106,102.45 44.86 130,397.55 22,593.92 97,907.83 41.40 138,592.17 236,500.00 31,393.84 106,102.45 44.86 130,397.55 236,500.00 22,593.92 97,907.83 41.40 138,592.17 236,500.00 22,593.92 97,907.83 41.40 138,592.17 236,500.00 22,593.92 97,907.83 41.40 138,592.17 0.00 8,799.92 8,194.62 ( 8,194.62) 7 -12 -2012 06:54 AM 222- PINEWOOD GOLF COURSE REVENUES Pinewood Golf Course Charges for Services 222 -3- 0000 -3461 Recreation Fees 222 -3- 0000 -3467 Concessions 222 -3 -0000 -3469 Other Sales 222 -3- 0000 -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 222 -3- 0000 -3792 Cash Over TOTAL Sales Other Financing Sources Transfers In 222 -3- 0000 -3922 Transfer- General Fund TOTAL Transfers In TOTAL Pinewood Golf Course CITY OF ELK RIVER PAGE: 2 REVENUE 6 EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 16,500.00 3,479.00 15,969.00 96.78 531.00 16,000.00 3,313.18 7,378.97 46.12 8,621.03 3,500.00 1,076.32 2,699.46 77.13 800.54 120,000.00 18,694.25 52,057.40 43.38 67,942.60 16,500.00 400.00 17,085.00 103.55 ( 585.00) 18,500.00 4,412.00 10,491.50 56.71 8,008.50 5,000.00 0.00 448.00 8.96 4,552.00 196,000.00 31,374.75 106,129.33 54.15 89,870.67 0.00 19.09 ( 26.88) 0.00 26.88 0.00 19.09 ( 26.88) 0.00 26.88 40,500.00 0.00 0.00 0.00 40,500.00 40,500.00 0.00 0.00 0.00 40,500.00 236,500.00 31,393.84 106,102.45 44.86 130,397.55 TOTAL REVENUE 236,500.00 31,393.84 106,102.45 44.86 130,397.55 7 -12 -2012 06:54 AM CITY OF ELK RIVER 22,593.92 PAGE: 3 138,592.17 REVENUE & EXPENSE REPORT (UNAUDITED) 222 -4 -5300 -4101 Regular Pay 87,100.00 AS OF: JUNE 30TH, 2012 37,368.96 42.90 ?- PINEWOOD GOLF COURSE 222 -4 -5300 -4103 Part -time Pay 29,900.00 4,388.61 8,962.06 50.00% OF YEAR COMP. 222 -4- 5300 -4104 CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 236,500.00 22,593.92 97,907.83 41.40 138,592.17 TOTAL Culture & Recreation 222 -4 -5300 -4101 Regular Pay 87,100.00 7,208.16 37,368.96 42.90 49,731.04 222 -4 -5300 -4103 Part -time Pay 29,900.00 4,388.61 8,962.06 29.97 20,937.94 222 -4- 5300 -4104 PERA 8,500.00 682.97 3,260.21 38.36 5,239.79 222 -4 -5300 -4105 FICA 7,250.00 714.25 2,993.94 41.30 4,256.06 222 -4 -5300 -4107 Medicare 1,700.00 167.04 700.14 41.18 999.86 222 -4 -5300 -4108 Insurance 6,100.00 465.00 2,790.00 45.74 3,310.00 222 -4 -5300 -4109 Workers Comp 1,850.00 398.50 1,195.50 64.62 654.50 222 -4 -5300 -4110 Re- employment Compensation 0.00 0.00 2,693.81 0.00 ( 2,693.81) TOTAL Personal Services 142,400.00 14,024.53 59,964.62 42.11 82,435.38 Supplies 222-4 -5300 -4212 Fuels & Lubs 4,500.00 408.58 2,016.05 44.80 2,483.95 222 -4 -5300 -4217 Uniform Allowance 500.00 0.00 383.53 76.71 116.47 222 -4 -5300 -4219 Operating Supplies 29,700.00 3,603.2.1 15,618.37 52.59 14,081.63 222 - -4- 5300 -4259 Other Merchandise For Resale 12,000.00 1,887.82 6,065.64 50.55 5,934.36 TOTAL Supplies 46,700.00 5,899.61 24,083.59 51.57 22,616.41 Other Services & Charges 222 -4 -5300 -4321 Telephone 2,400.00 174.78 854.73 35.61 1,545.27 222 -4- 5300 -4331 Travel, Conferences & Schools 450.00 0.00 17.69 3.93 432.31 222 -4 -5300 -4349 Advertising /Marketing 5,000.00 1,215.73 3,423.93 68.48 1,576.07 222 -4 -5300 -4361 Insurance 12,100.00 0.00 5,144.50 42.52 6,955.50 222 -4 -5300 -4389 Utilities 6,550.00 465.30 1,211.64 18.50 5,338.36 222 -4- 5300 -4401 Bldg Repair /Maint Services 8,950.00 20.04 234.70 2.62 8,715.30 222 -4 -5300 -4404 Equip Repair /Maint Services 4,600.00 0.00 1,597.20 34.72 3,002.80 222 -4- 5300 -4415 Equipment Rental 1,350.00 48.29 142.81 10.58 1,207.19 222 -4 -5300 -4437 Taxes & Licenses 11000.00 ( 144.01)( 1,004.23) 100.42- 2,004.23 222 -4 -5300 -4438 Credit Card Fees 5,000.00 889.65 2,236.65 44.73 2,763.35 TOTAL Other Services & Charges 47,400.00 2,669.78 13,859.62 29.24 33,540.38 Capital Outlay Debt Service TOTAL Golf Course 236,500.00 22,593.92 97,907.83 41.40 138,592.17 TOTAL Culture & Recreation 236,500.00 22,593.92 97,907.83 41.40 138,592.17 TOTAL EXPENDITURES REVENUES OVER /(UNDER) EXPENDITURES 236,500.00 0.00 22,593.92 8,79.9.92 97,907.83 41.40 8,194.62 ( 138,592.17 8,194.62) J Q .7 F a� o° F N 7 W M C7 W aqz w W wv�q 0zw U w Z y�0 �i w F Z w Q 7 O � u era Q C U � 0000 7 a\ a0 0 0 0 O O O O O o6 N ds 00�0o N1 m N 1 1 0 0 0 0 0 O b Q` O O M Nt ° �°p e H N MI 'O h O o ti � o;� O M o O 1 O vt a ooa w N O O O O Ml O O M O r vi O O o 0 0 ^ O O O O O Vt b M N o O M N 0 O N INF t1 N 0 O N 0 0 0 0 0 0 0 0 0 a o n o a 0 0 0 0 o a a u r O V N M O .�" c °, �D O M O I 7 V C0 0 `J 0. ° •C •L = Q H OD � y O b0 d .� .+ a+ v D y y U •� � ° 0 o i ov `u °' ys�F a`, �cnU M0 On. v�0 0 0 a Z — °'-° UFF Z ;t�Um q M v N O Iq � L V r O Q r 0 V `O M era Q } O O O O O O O O O O O O O O O O O 0 0 O V1 O C o o V O In `D 00 ff, h O m 000 oaeo 00000 a o0o a ooa a o0 0C, 00 r —o 0 oo ^r oo^ 0000 o °a ooa vi v o 07 00 u C ci 4 ^ 07 r ri O M O 7 DD wt 00 N T 7 00 N'V ^ N O N V v Ga � L � O 1,40) 00 V1 r CT ' O 00 O C .-• V1 v� b �O �D O �O M ep N V o0 h r O O O a°+ O O 0�0 r b N 7 N M O •M" 00 v d O o o o 0 0 0 0 0 0 0 0 0 0 0 o 0 o 0 0 0 00 0 o �n �n o0 0 o�n ono � hho �n vi 7 m U b 7 ^ ORMATION e v T V y d C O y w 7 d 9 C c a u uJ p d .�" c e c to E d° v u d $ `J 0. ° •C •L = Q H OD � y O b0 d .� .+ a+ v D y y U •� � ° 0 o i ov `u °' ys�F a`, �cnU M0 On. v�0 0 0 a Z — °'-° UFF Z ;t�Um ORMATION 7 -12 -2012 06:55 AM C CITY OF ELK R RIVER P PAGE: 1 POOLED CASH REPORT ( (FUND 999) AS OF: JUNE 30TH, 2012 I INFORMATION CASH IN BANK - POOLED CASH 999 -1000 A/P BANK ACCOUNTS 37,225,154.23 2,545,289.25 39,770,443.48 999 -1001 PY BANK ACCOUNT (24,416,784.48) ( 801,05D.46) (25,217,834.94) 999 -1002 POOLED INVESTMENTS 28,382,189.56 D.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 41,190,559.31 1,744,238.79 42,934,798.10