Loading...
INFORMATION 12-17-2012 INFORMATION City of El River MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: December 17, 2012 SUBJECT: November 2012 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Pinewood Golf and Ice Arena Special Revenue Funds. These funds are the primary concern in analyzing the city's financial health. For the month of November, actual revenues (except for property taxes and state aids) and expenditures should run slightly under 92% 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: • Excluding transfers in,revenue collections are about 58% of budget. The second- half General Fund property taxes of$4.3 million were collected on December 3. • License and permit collections slightly exceed budget estimates at 93%. Building related permit collections match budget projections. • Intergovernmental revenues collections exceed 96%of budget. The second half PERA Aid will be received in December. • Charges for services are slightly under budget estimates at 88%. • Other than the transfer in for capital outlay purchases,all other transfers in have been made. Expenditures: • Excluding transfers out, the total departmental expenditures are about 81%of budget estimates and most 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. 2012 Monthly Expenditures us $10,000 a $6,000 yr , $4,000 , i Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov i Dec rNwwwrActual $552 1$1,455 $2,6006 $3,551 $6,122$5,266 4 8 _._.,4 6,122 $7,415 $8,498 $9, 20 $10,298 -Budget $1,057 $2,113 $3,170' $4,226 'a$5,283`$6,339 $7,396 E$8,452 $9,509 $10,565$11,622$12,678, Ice Arena As of the end of November,revenues exceed expenditures by$36,835. Revenue collections of$561,709 are over 76% of budget and expenditures of$524,874 are 81% of budget. Ice rental revenues are over 76% of budget estimates. Pinewood Golf For the month ended November, expenditures exceed revenues by$25,979. Excluding transfers in,golf revenues collected through November of$186,393 account for 95% of budget estimates and expenditures of$212,372 are about 90%of budget. Green fees came in under budget estimates at about 86%. Attachments: • General Fund Revenue&Expense Report • Enterprise Funds—Budget to Actual • Cash Report—All Funds 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) INFORMATION AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,311,900.00 73,948.93 7,556,354.71 61.37 4,755,545.29 TOTAL REVENUES 12,311,900.00 73,948.93 7,556,354.71 61.37 4,755,545.29 EXPENDITURE SUMMARY General Government Mayor & Council 172,250.00 31,656.37 138,913.93 80.65 33,336.07 Cable TV 86,600.00 6,321.94 72,150.31 83.31 14,449.69 Administrative Services 482,950.00 34,519.01 409,839.78 84.86 73,110.22 Human Resources 164,500.00 11,374.92 141,177.07 85.82 23,322.93 Elections 38,050.00 14,702.64 29,491.54 77.51 8,558.46 Finance 464,450.00 28,108.65 413,127.39 88.95 51,322.61 Information Technology 242,000.00 22,535.24 199,367.77 82.38 42,632.23 Legal 228,000.00 20,421.25 185,007.12 81.14 42,992.88 Community Development 69,250.00 5,255.26 60,854.56 87.88 8,395.44 Planning 304,700.00 24,201.46 268,471.49 88.11 36,228.51 City Hall Maintenance 304,150.00 21,076.20 242,738.87 79.81 61,411.13 Contingency 217,550.00 2,641.80 17,306.80 7.96 200,243.20 TOTAL General Government 2,774,450.00 222,814.74 2,178,446.63 78.52 596,003.37 Public Safety Police Administration 565,500.00 38,101.62 478,915.90 84.69 86,584.10 Patrol 2,350,050.00 165,957.89 1,861,533.90 79.21 488,516.10 Investigations 764,750.00 46,934.77 623,394.02 81.52 141,355.98 Police Support Services 503,500.00 34,102.02 407,578.79 80.95 95,921.21 Police Reserves 18,900.00 0.00 7,042.49 37.26 11,857.51 Public safety building 210,150.00 15,766.03 168,942.01 80.39 41,207.99 Fire Administration 555,500.00 36,622.87 429,925.53 77.39 125,574.47 Fire Inspections 188,000.00 13,666.53 160,540.83 85.39 27,459.17 Emergency Management 103,900.00 12,927.22 69,930.36 67.31 33,969.64 Building Safety 473,350.00 35,839.42 413,534.06 87.36 59,815.94 Environmental 48,850.00 4,336.79 42,761.15 87.54 6,088.85 TOTAL Public Safety 5,782,450.00 404,255.16 4,664,099.04 80.66 1,118,350.96 Public Works Street Maintenance 1,505,300.00 78,058.23 1,352,465.45 89.85 152,834.55 Snow Removal 288,400.00 2,337.62 122,340.46 42.42 166,059.54 Equipment Services 247,900.00 19,827.42 202,269.25 81.59 45,630.75 Engineering 133,550.00 14,959.41 127,606.75 95.55 5,943.25 TOTAL Public Works 2,175,150.00 115,182.68 1,804,681.91 82.97 370,468.09 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 813,800.00 74,055.77 730,014.65 89.70 83,785.35 Parks & Rec Admin 603,250.00 42,729.25 519,782.38 86.16 83,467.62 Recreation Programs 197,000.00 6,312.14 170,656.39 86.63 26,343.61 Concessions 14,100.00 0.00 0.00 0.00 14,100.00 Sr Citizen Programs 226,500.00 13,533.52 169,948.92 75.03 56,551.08 TOTAL Culture & Recreation 1,854,650.00 136,630.68 1,590,402.34 85.75 264,247.66 Economic Development Economic Development 0.00 ( 3,658.04) 28,599.31 0.00 ( 28,599.31) Energy City 50,850.00 2,668.88 31,306.03 61.57 19,543.97 TOTAL Economic Development 50,850.00 ( 989.16) 59,905.34 117.81 ( 9,055.34) General 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 877,894.10 10,297,535.26 81.22 2,380,514.74 REVENUES OVER/(UNDER) EXPENDITURES ( 366,150.00) ( 803,945.17) ( 2,741,180.55) 2,375,030.55 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND 91.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,142,200.00 0.00 4,631,405.41 50.66 4,510,794.59 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 116,556.53 0.00 ( 116,556.53) 101-3-0000-3121 Gravel Tax 70,000.00 0.00 104,662.40 149.52 ( 34,662.40) 101-3-0000-3131 Penalties/Interest 0.00 0.00 13,288.88 0.00 ( 13,288.88) TOTAL Taxes 9,212,200.00 0.00 4,865,913.22 52.82 4,346,286.78 Licenses & Permits 101-3-0000-3211 Liquor License 53,000.00 0.00 61,972.50 116.93 ( 8,972.50) 101-3-0000-3212 Amusement License 1,000.00 840.00 1,185.00 118.50 ( 185.00) 101-3-0000-3213 Cigarette License 3,000:00 2,250.00 2,662.50 88.75 337.50 101-3-0000-3214 Apartment License 17,000.00 375.00 23,910.00 140.65 ( 6,910.00) 101-3-0000-3216 Mining License 20,000.00 0.00 20,842.95 104.21 ( 842.95) 101-3-0000-3217 Garbage Hauler License 2,100.00 330.00 900.00 42.86 1,200.00 101-3-0000-3218 Other Business License/Permit 17,000.00 3,405.00 13,165.00 77.44 3,835.00 101-3-0000-3229 NPDES Permit 2,500.00 875.00 5,075.00 203.00 ( 2,575.00) 101-3-0000-3231 Building Permit 153,000.00 15,456.40 167,480.90 109.46 ( 14,480.90) 101-3-0000-3232 Plumbing/Heating Permit 129,150.00 2,315.09 72,551.81 56.18 56,598.19 101-3-0000-3233 Permit Surcharge 400.00 ( 384.35) 1,245.65 311.41 ( 845.65) 101-3-0000-3235 Animal License 3,500.00 870.00 5,414.50 154.70 ( 1,914.50) 101-3-0000-3236 Parking Permit 3,000.00 0.00 276.01 9.20 2,723.99 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 515.00 7,945.00 99.31 55.00 TOTAL Licenses & Permits 412,650.00 26,847.14 384,626.82 93.21 28,023.18 Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3322 MV Credit 0.00 0.00 1,910.05 0.00 ( 1,910.05) 101-3-0000-3324 PERA Aid 14,000.00 0.00 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 205,000.00 0.00 194,176.00 94.72 10,824.00 101-3-0000-3326 Police Training Reimb 12,000.00 0.00 9,962.69 83.02 2,037.31 101-3-0000-3327 State-Aid Street Maint 275,450.00 0.00 281,982.04 102.37 ( 6,532.04) 101-3-0000-3329 State Crime Prevention Grant 30,000.00 7,364.83 28,130.68 93.77 1,869.32 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 7,364.83 523,153.46 96.44 19,296.54 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 100.00 10,650.00 71.00 4,350.00 101-3-0000-3413 Plan Check Fee 41,000.00 6,752.87 72,256.26 176.23 ( 31,256.26) 101-3-0000-3415 Special Assessment Search 1,000.00 80.00 1,000.00 100.00 0.00 101-3-0000-3417 Copies 2,500.00 303.65 2,329.92 93.20 170.08 101-3-0000-3418 Other General Govt Services 4,000.00 258.00 2,719.00 67.98 1,281.00 101-3-0000-3430 Lockout Fees 7,500.00 820.00 6,980.00 93.07 520.00 101-3-0000-3431 Police Services 2,000.00 400.00 5,027.75 251.39 ( 3,027.75) 101-3-0000-3432 School Liaison 75,000.00 0.00 75,000.00 100.00 0.00 101-3-0000-3434 Animal Impound Fee 3,000.00 150.00 2,885.00 96.17 115.00 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3436 Fire Contracts 199,600.00 0.00 195,954.04 98.17 3,645.96 101-3-0000-3437 Fire Calls 4,000.00 1,553.83 4,053.83 101.35 ( 53.83) 101-3-0000-3451 Street Services 35,000.00 40.00 4,040.00 11.54 30,960.00 101-3-0000-3452 Engineering Services Reimb 89,150.00 13,798.09 42,939.88 48.17 46,210.12 101-3-0000-3461 Recreation Fees 129,000.00 1,682.00 120,447.66 93.37 8,552.34 101-3-0000-3467 Concessions 14,100.00 0.00 0.00 0.00 14,100.00 101-3-0000-3472 Park Use Fee 17,000.00 ( 357.49) 18,044.44 106.14 ( 1,044.44) 101-3-0000-3474 Facility Use Fee 5,700.00 ( 83.92) 2,242.02 39.33 3,457.98 101-3-0000-3475 Building Rent 2,400.00 200.00 2,200.00 91.67 200.00 101-3-0000-3483 Sewer Inspection Fee 3,000.00 230.00 4,400.00 146.67 ( 1,400.00) 101-3-0000-3484 Contractor License Check 400.00 160.00 580.00 145.00 ( 180.00) TOTAL Charges for Services 650,350.00 26,087.03 573,749.80 88.22 76,600.20 Fines & Forfeits 101-3-0000-3510 Court Fines 120,000.00 10,088.22 92,853.62 77.38 27,146.38 101-3-0000-3511 Parking Fines 12,000.00 300.00 9,952.25 82.94 2,047.75 101-3-0000-3512 Ordinance Violations 500.00 0.00 200.00 40.00 300.00 TOTAL Fines & Forfeits 132,500.00 10,388.22 103,005.87 77.74 29,494.13 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 39,730.65 39.73 60,269.35 101-3-0000-3625 Refunds & Reimbursements 66,500.00 248.40 1,152.23 1.73 65,347.77 101-3-0000-3626 Contributions 25,650.00 2,763.00 20,627.25 80.42 5,022.75 101-3-0000-3629 Miscellaneous Revenue 8,000.00 250.31 4,895.41 61.19 3,104.59 TOTAL Other Revenue 200,150.00 3,261.71 66,405.54 33.18 133,744.46 Transfers In 101-3-0000-3921 Transfers 122,100.00 0.00 0.00 0.00 122,100.00 101-3-0000-3925 Transfer-Landfill 35,000.00 0.00 35,000.00 100.00 0.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 39,500.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 100,000.00 0.00 100,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 300,000.00 0.00 300,000.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 25,000.00 0.00 25,000.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 500,000.00 0.00 500,000.00 100.00 0.00 101-3-0000-3948 Transfer-EDA 25,000.00 0.00 25,000.00 100.00 0.00 101-3-0000-3949 Transfer-HRA 15,000.00 0.00 15,000.00 100.00 0.00 TOTAL Transfers In 1,161,600.00 0.00 1,039,500.00 89.49 122,100.00 TOTAL General Fund 12,311,900.00 73,948.93 7,556,354.71 61.37 4,755,545.29 TOTAL REVENUE 12,311,900.00 73,948.93 7,556,354.71 61.37 4,755,545.29 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND 91.67% OF YEAR COMP. 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,199.92 35,247.54 91.55 3,252.46 101-4-1110-4104 PERA 1,900.00 101.67 1,118.37 58.86 781.63 101-4-1110-4105 FICA 2,400.00 110.56 1,219.16 50.80 1,180.84 101-4-1110-4107 Medicare 550.00 46.40 511.06 92.92 38.94 101-4-1110-4109 Workers Comp 50.00 0.00 67.25 134.50 ( 17.25) TOTAL Personal Services 43,400.00 3,458.55 38,163.38 87.93 5,236.62 Supplies 101-4-1110-4201 Office Supplies 3,200.00 3.67 195.44 6.11 3,004.56 TOTAL Supplies 3,200.00 3.67 195.44 6.11 3,004.56 Other Services & Charges 101-4-1110-4319 Other Professional Services 11,050.00 1.06 7,712.09 69.79 3,337.91 101-4-1110-4322 Postage 400.00 0.00 125.43 31.36 274.57 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 ( 797.82) 654.57 25.18 1,945.43 101-4-1110-4359 Publishing 17,700.00 0.00 12,852.72 72.61 4,847.28 101-4-1110-4361 Insurance 69,450.00 28,747.00 54,148.50 77.97 15,301.50 101-4-1110-4433 Dues & Subscriptions 16,000.00 0.00 16,462.00 102.89 ( 462.00) 101-4-1110-4440 Miscellaneous 8,450.00 243.91 8,599.80 101.77 ( 149.80) TOTAL Other Services & Charges 125,650.00 28,194.15 100,555.11 80.03 25,094.89 Capital Outlay TOTAL Mayor & Council 172,250.00 31,656.37 138,913.93 80.65 33,336.07 Cable TV Personal Services 101-4-1120-4101 Regular Pay 57,450.00 4,504.00 50,693.61 88.24 6,756.39 101-4-1120-4103 Part-time Pay 6,500.00 219.94 3,534.97 54.38 2,965.03 101-4-1120-4104 PERA 4,150.00 326.54 3,829.31 92.27 320.69 101-4-1120-4105 FICA 3,950.00 254.39 3,186.01 80.66 763.99 101-4-1120-4107 Medicare 950.00 59.49 745.10 78.43 204.90 101-4-1120-4108 Insurance 8,700.00 914.00 8,416.00 96.74 284.00 101-4-1120-4109 Workers Comp 250.00 0.00 265.75 106.30 ( 15.75) TOTAL Personal Services 81,950.00 6,278.36 70,670.75 86.24 11,279.25 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1120-4201 Office Supplies 1,700.00 1.86 1,281.74 75.40 418.26 TOTAL Supplies 1,700.00 1.86 1,281.74 75.40 418.26 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 156.10 12.49 1,093.90 101-4-1120-4404 Equip Repair/Maint Services 1,650.00 41.72 41.72 2.53 1,608.28 TOTAL Other Services & Charges 2,950.00 41.72 197.82 6.71 2,752.18 Capital Outlay TOTAL Cable TV 86,600.00 6,321.94 72,150.31 83.31 14,449.69 Administrative Services Personal Services 101-4-1210-4101 Regular Pay 306,650.00 23,491.66 270,154.09 88.10 36,495.91 101-4-1210-4103 Part-time Pay 41,200.00 3,156.29 34,232.85 83.09 6,967.15 101-4-1210-4104 PERA 25,200.00 1,931.95 23,062.39 91.52 2,137.61 101-4-1210-4105 FICA 21,550.00 1,134.47 19,264.68 89.40 2,285.32 101-4-1210-4107 Medicare 5,050.00 388.29 4,628.32 91.65 421.68 101-4-1210-4108 Insurance 26,650.00 2,028.01 23,819.62 89.38 2,830.38 101-4-1210-4109 Workers Comp 2,100.00 0.00 1,941.25 92.44 158.75 TOTAL Personal Services 428,400.00 32,130.67 377,103.20 88.03 51,296.80 Supplies 101-4-1210-4201 Office Supplies 9,500.00 316.58 4,221.63 44.44 5,278.37 TOTAL Supplies 9,500.00 316.58 4,221.63 44.44 5,278.37 Other Services & Charges 101-4-1210-4319 Other Professional Services 5,500.00 0.00 5,508.00 100.15 ( 8.00) 101-4-1210-4321 Telephone 800.00 131.38 580.99 72.62 219.01 101-4-1210-4322 Postage 1,000.00 0.00 355.10 35.51 644.90 101-4-1210-4331 Travel, Conferences & Schools 7,300.00 80.22 3,104.07 42.52 4,195.93 101-4-1210-4334 Car Allowance 4,800.00 369.24 4,430.88 92.31 369.12 101-4-1210-4361 Insurance 300.00 131.00 222.00 74.00 78.00 101-4-1210-4404 Equip Repair/Maint Services 23,550.00 1,202.96 12,594.15 53.48 10,955.85 101-4-1210-4433 Dues & Subscriptions 1,800.00 156.96 1,719.76 95.54 80.24 TOTAL Other Services & Charges 45,050.00 2,071.76 28,514.95 63.30 16,535.05 Capital Outlay TOTAL Administrative Services 482,950.00 34,519.01 409,839.78 84.86 73,110.22 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE 8 OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Human Resources Personal Services 101-4-1220-4101 Regular Pay 69,200.00 5,323.62 61,221.63 88.47 7,978.37 101-4-1220-4103 Part-time Pay 49,300.00 3,603.20 43,308.86 87.85 5,991.14 101-4-1220-4104 PERA 8,600.00 647.20 7,927.71 92.18 672.29 101-4-1220-4105 FICA 7,350.00 541.80 6,618.52 90.05 731.48 101-4-1220-4107 Medicare 1,700.00 126.70 1,547.77 91.05 152.23 101-4-1220-4108 Insurance 10,750.00 949.00 10,869.00 101.11 ( 119.00) 101-4-1220-4109 Workers Comp 700.00 0.00 677.00 96.71 23.00 TOTAL Personal Services 147,600.00 11,191.52 132,170.49 89.55 15,429.51 Supplies 101-4-1220-4201 Office Supplies 4,300.00 68.15 2,519.10 58.58 1,780.90 TOTAL Supplies 4,300.00 68.15 2,519.10 58.58 1,780.90 Other Services & Charges 101-4-1220-4319 Other Professional Services 3,000.00 39.95 434.50 14.48 2,565.50 101-4-1220-4322 Postage 550.00 0.00 642.45 116.81 ( 92.45) 101-4-1220-4331 Travel, Conferences & Schools 2,350.00 0.00 141.42 6.02 2,208.58 101-4-1220-4433 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1220-4440 Miscellaneous 1,000.00 75.30 877.55 87.76 122.45 TOTAL Other Services & Charges 7,900.00 115.25 2,095.92 26.53 5,804.08 Capital Outlay 101-4-1220-4560 Equipment 4,700.00 0.00 4,391.56 93.44 308.44 TOTAL Capital Outlay 4,700.00 0.00 4,391.56 93.44 308.44 TOTAL Human Resources 164,500.00 11,374.92 141,177.07 85.82 23,322.93 Elections Personal Services 101-4-1230-4103 Part-time Pay 30,000.00 13,684.02 26,278.21 87.59 3,721.79 TOTAL Personal Services 30,000.00 13,684.02 26,278.21 87.59 3,721.79 Supplies 101-4-1230-4219 Operating Supplies 4,650.00 709.00 1,563.95 33.63 3,086.05 TOTAL Supplies 4,650.00 709.00 1,563.95 33.63 3,086.05 Other Services & Charges 101-4-1230-4322 Postage 600.00 0.00 331.04 55.17 268.96 101-4-1230-4331 Travel, Conferences & Schools 700.00 24.62 64.06 9.15 635.94 101-4-1230-4359 Publishing 1,000.00 285.00 1,245.00 124.50 ( 245.00) 101-4-1230-4404 Equip Repair/Maint Services 100.00 0.00 9.28 9.28 90.72 101-4-1230-4415 Equipment Rental 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 3,400.00 309.62 1,649.38 48.51 1,750.62 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Elections 38,050.00 14,702.64 29,491.54 77.51 8,558.46 Finance Personal Services 101-4-1310-4101 Regular Pay 293,600.00 22,131.65 259,016.92 88.22 34,583.08 101-4-1310-4104 PERA 21,300.00 1,604.52 19,580.93 91.93 1,719.07 101-4-1310-4105 FICA 18,200.00 1,300.05 16,038.86 88.13 2,161.14 101-4-1310-4107 Medicare 4,250.00 304.06 3,751.19 88.26 498.81 101-4-1310-4108 Insurance 26,650.00 2,402.01 24,487.11 91.88 2,162.89 101-4-1310-4109 Workers Comp 1,800.00 0.00 1,677.75 93.21 122.25 TOTAL Personal Services 365,800.00 27,742.29 324,552.76 88.72 41,247.24 Supplies 101-4-1310-4201 Office Supplies 5,350.00 44.15 3,077.51 57.52 2,272.49 TOTAL Supplies 5,350.00 44.15 3,077.51 57.52 2,272.49 Other Services & Charges 101-4-1310-4301 Audit Fees 18,300.00 0.00 17,921.40 97.93 378.60 101-4-1310-4319 Other Professional Services 50,000.00 0.00 48,730.50 97.46 1,269.50 101-4-1310-4321 Telephone 400.00 31.39 260.37 65.09 139.63 101-4-1310-4322 Postage 2,600.00 0.00 1,643.01 63.19 956.99 101-4-1310-4331 Travel, Conferences & Schools 2,350.00 125.00 1,611.38 68.57 738.62 101-4-1310-4359 Publishing 950.00 0.00 562.50 59.21 387.50 101-4-1310-4404 Equip Repair/Maint Services 12,200.00 42.95 12,002.38 98.38 197.62 101-4-1310-4433 Dues & Subscriptions 1,500.00 0.00 1,400.00 93.33 100.00 101-4-1310-4438 Credit Card Fees 5,000.00 122.87 1,365.58 27.31 3,634.42 TOTAL Other Services & Charges 93,300.00 322.21 85,497.12 91.64 7,802.88 Capital Outlay TOTAL Finance 464,450.00 28,108.65 413,127.39 88.95 51,322.61 Information Technology Personal Services 101-4-1350-4101 Regular Pay 130,950.00 10,442.32 118,745.13 90.68 12,204.87 101-4-1350-4102 Overtime Pay 0.00 0.00 174.42 0.00 ( 174.42) 101-4-1350-4103 Part-time Pay 5,000.00 0.00 0.00 0.00 5,000.00 101-4-1350-4104 PERA 9,500.00 757.06 8,979.59 94.52 520.41 101-4-1350-4105 FICA 8,450.00 594.46 7,154.91 84.67 1,295.09 101-4-1350-4107 Medicare 2,000.00 139.03 1,673.32 83.67 326.68 101-4-1350-4108 Insurance 20,450.00 1,706.00 18,766.00 91.77 1,684.00 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1350-4109 Workers Comp 800.00 0.00 797.75 99.72 2.25 TOTAL Personal Services 177,150.00 13,638.87 156,291.12 88.23 20,858.88 Supplies 101-4-1350-4219 Operating Supplies 15,600.00 873.30 7,824.98 50.16 7,775.02 TOTAL Supplies 15,600.00 873.30 7,824.98 50.16 7,775.02 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 743.75 9.30 7,256.25 101-4-1350-4321 Telephone 1,450.00 130.45 1,618.35 111.61 ( 168.35) 101-4-1350-4331 Travel, Conferences & Schools 8,000.00 2,760.00 2,978.96 37.24 5,021.04 101-4-1350-4404 Equip Repair/Maint Services 20,900.00 5,132.62 19,010.61 90.96 1,889.39 TOTAL Other Services & Charges 38,350.00 8,023.07 24,351.67 63.50 13,998.33 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 22,535.24 199,367.77 82.38 42,632.23 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 228,000.00 20,421.25 185,007.12 81.14 42,992.88 TOTAL Other Services & Charges 228,000.00 20,421.25 185,007.12 81.14 42,992.88 TOTAL Legal 228,000.00 20,421.25 185,007.12 81.14 42,992.88 Community Development Personal Services 101-4-1500-4101 Regular Pay 53,750.00 4,134.40 47,390.56 88.17 6,359.44 101-4-1500-4104 PERA 3,900.00 299.74 3,582.68 91.86 317.32 101-4-1500-4105 FICA 3,350.00 243.24 2,920.08 87.17 429.92 101-4-1500-4107 Medicare 800.00 56.88 682.84 85.36 117.16 101-4-1500-4108 Insurance 6,000.00 521.00 5,716.33 95.27 283.67 101-4-1500-4109 Workers Comp 900.00 0.00 544.50 60.50 355.50 TOTAL Personal Services 68,700.00 5,255.26 60,836.99 88.55 7,863.01 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 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 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 69,250.00 5,255.26 60,854.56 87.88 8,395.44 Planning . Personal Services 101-4-1510-4101 Regular Pay 216,150.00 16,578.35 191,159.12 88.44 24,990.88 101-4-1510-4104 PERA 15,700.00 1,201.93 14,449.99 92.04 1,250.01 101-4-1510-4105 FICA 13,400.00 947.12 11,479.32 85.67 1,920.68 101-4-1510-4107 Medicare 3,150.00 221.50 2,684.62 85.23 465.38 101-4-1510-4108 Insurance 29,150.00 2,442.00 26,862.00 92.15 2,288.00 101-4-1510-4109 Workers Comp 1,300.00 0.00 961.00 73.92 339.00 TOTAL Personal Services 278,850.00 21,390.90 247,596.05 88.79 31,253.95 Supplies 101-4-1510-4201 Office Supplies 4,250.00 67.84 1,076.80 25.34 3,173.20 101-4-1510-4212 Fuels & Lubs 1,600.00 262.61 1,598.79 99.92 1.21 101-4-1510-4219 Operating Supplies 200.00 1,179.76 1,957.15 978.58 ( 1,757.15) TOTAL Supplies 6,050.00 1,510.21 4,632.74 76.57 1,417.26 Other Services & Charges 101-4-1510-4321 Telephone 800.00 115.66 1,325.26 165.66 ( 525.26) 101-4-1510-4322 Postage 3,200.00 0.00 1,820.37 56.89 1,379.63 101-4-1510-4331 Travel, Conferences & Schools 1,650.00 38.00 1,432.28 86.80 217.72 101-4-1510-4359 Publishing 8,000.00 495.00 4,590.00 57.38 3,410.00 101-4-1510-4361 Insurance 450.00 195.50 344.50 76.56 105.50 101-4-1510-4404 Equip Repair/Maint Services 3,600.00 389.53 5,370.03 149.17 ( 1,770.03) 101-4-1510-4433 Dues & Subscriptions 1,050.00 0.00 535.00 50.95 515.00 101-4-1510-4440 Miscellaneous 250.00 0.00 92.00 36.80 158.00 101-4-1510-4460 Equip Replacement Charge 800.00 66.66 733.26 91.66 66.74 TOTAL Other Services & Charges 19,800.00 1,300.35 16,242.70 82.03 3,557.30 Capital Outlay TOTAL Planning 304,700.00 24,201.46 268,471.49 88.11 36,228.51 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 108,500.00 8,417.37 95,924.53 88.41 12,575.47 101-4-1600-4102 Overtime Pay 2,500.00 40.64 2,043.12 81.72 456.88 101-4-1600-4103 Part-time Pay 20,800.00 1,406.40 19,685.29 94.64 1,114.71 101-4-1600-4104 PERA 9,550.00 715.16 8,568.91 89.73 981.09 101-4-1600-4105 FICA 8,200.00 605.76 7,626.27 93.00 573.73 101-4-1600-4107 Medicare 1,900.00 141.67 1,783.63 93.88 116.37 101-4-1600-4108 Insurance 17,700.00 1,307.42 14,326.01 80.94 3,373.99 101-4-1600-4109 Workers Comp 5,550.00 0.00 5,375.75 96.86 174.25 TOTAL Personal Services 174,700.00 12,634.42 155,333.51 88.91 19,366.49 Supplies 101-4-1600-4212 Fuels & Lubs 4,650.00 311.06 2,312.07 49.72 2,337.93 101-4-1600-4217 Uniform Allowance 1,700.00 402.65 1,199.31 70.55 500.69 101-4-1600-4219 Operating Supplies 29,400.00 1,621.49 25,508.19 86.76 3,891.81 TOTAL Supplies 35,750.00 2,335.20 29,019.57 81.17 6,730.43 Other Services & Charges 101-4-1600-4321 Telephone 13,950.00 966.14 10,373.75 74.36 3,576.25 101-4-1600-4331 Travel, Conferences & Schools 1,500.00 0.00 436.16 29.08 1,063.84 101-4-1600-4361 Insurance 5,100.00 2,451.00 4,545.50 89.13 554.50 101-4-1600-4389 Utilities 36,700.00 1,692.23 20,936.48 57.05 15,763.52 101-4-1600-4401 Bldg Repair/Maint Services 31,150.00 763.88 18,168.45 58.33 12,981.55 101-4-1600-4404 Equip Repair/Maint Services 2,500.00 0.00 1,358.82 54.35 1,141.18 101-4-1600-4460 Equip Replacement Charge 2,800.00 233.33 2,566.63 91.67 233.37 TOTAL Other Services & Charges 93,700.00 6,106.58 58,385.79 62.31 35,314.21 Capital Outlay TOTAL City Hall Maintenance 304,150.00 21,076.20 242,738.87 79.81 61,411.13 Contingency Personal Services Other Services & Charges 101-4-1900-4440 Miscellaneous 217,550.00 2,641.80 17,306.80 7.96 200,243.20 TOTAL Other Services & Charges 217,550.00 2,641.80 17,306.80 7.96 200,243.20 TOTAL Contingency 217,550.00 2,641.80 17,306.80 7.96 200,243.20 TOTAL General Government 2,774,450.00 222,814.74 2,178,446.63 78.52 596,003.37 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration Personal Services 101-4-2110-4101 Regular Pay 280,900.00 21,606.08 248,469.92 88.45 32,430.08 101-4-2110-4104 PERA 40,450.00 3,111.30 37,305.09 92.23 3,144.91 101-4-2110-4107 Medicare 2,550.00 194.26 2,332.13 91.46 217.87 101-4-2110-4108 Insurance 23,700.00 1,900.00 20,900.00 88.19 2,800.00 101-4-2110-4109 Workers Comp 64,850.00 0.00 60,150.00 92.75 4,700.00 TOTAL Personal Services 412,450.00 26,811.64 369,157.14 89.50 43,292.86 Supplies 101-4-2110-4201 Office Supplies 14,000.00 1,172.98 6,856.03 48.97 7,143.97 101-4-2110-4217 Uniform Allowance 2,300.00 0.00 2,195.00 95.43 105.00 101-4-2110-4219 Operating Supplies 4,600.00 41.29 2,440.09 53.05 2,159.91 , TOTAL Supplies 20,900.00 1,214.27 11,491.12 54.98 9,408.88 Other Services & Charges 101-4-2110-4319 Other Professional Services 3,400.00 37.73 2,143.79 63.05 1,256.21 101-4-2110-4321 Telephone 29,300.00 1,625.55 16,165.81 55.17 13,134.19 101-4-2110-4322 Postage 2,600.00 0.00 1,942.01 74.69 657.99 101-4-2110-4331 Travel, Conferences & Schools 3,350.00 10.00 2,642.25 78.87 707.75 101-4-2110-4359 Publishing 500.00 180.00 180.00 36.00 32D.00 101-4-2110-4361 Insurance 7,550.00 4,650.00 8,956.00 118.62 ( 1,406.00) 101-4-2110-4404 Equip Repair/Maint Services 80,400.00 3,557.23 63,136.25 78.53 17,263.75 101-4-2110-4433 Dues & Subscriptions 4,250.00 15.20 2,961.28 69.68 1,288.72 101-4-2110-4437 Taxes & Licenses 800.00 0.00 140.25 17.53 659.75 TOTAL Other Services & Charges 132,150.00 10,075.71 98,267.64 74.36 33,882.36 Capital Outlay TOTAL Police Administration 565,500.00 38,101.62 478,915.90 84.69 86,584.10 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,479,700.00 108,575.87 1,221,628.99 82.56 258,071.01 101-4-2120-4102 Overtime Pay 90,000.00 4,370.67 57,485.62 63.87 32,514.38 101-4-2120-4104 PERA 226,050.00 16,264.32 192,112.15 84.99 33,937.85 101-4-2120-4107 Medicare 20,400.00 1,349.80 16,022.55 78.54 4,377.45 101-4-2120-4108 Insurance 179,350.00 14,423.01 158,044.57 88.12 21,305.43 TOTAL Personal Services 1,995,500.00 144,983.67 1,645,293.88 82.45 350,206.12 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubs 143,000.00 11,140.16 80,087.26 56.01 62,912.74 101-4-2120-4217 Uniform Allowance 22,850.00 290.49 14,398.91 63.01 8,451.09 101-4-2120-4219 Operating Supplies 63,750.00 2,736.57 32,039.54 50.26 31,710.46 101-4-2120-4221 Equipment Parts 28,000.00 3,154.50 15,171.28 54.18 12,828.72 TOTAL Supplies 257,600.00 17,321.72 141,696.99 55.01 115,903.01 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 25,150.00 0.00 17,619.18 70.06 7,530.82 101-4-2120-4404 Equip Repair/Maint Services 26,700.00 ( 60.00) 16,046.35 60.10 10,653.65 101-4-2120-4433 Dues & Subscriptions 550.00 0.00 40.00 7.27 510.00 101-4-2120-4460 Equip Replacement Charge 44,550.00 3,712.50 40,837.50 91.67 3,712.50 TOTAL Other Services & Charges 96,950.00 3,652.50 74,543.03 76.89 22,406.97 Capital Outlay TOTAL Patrol 2,350,050.00 165,957.89 1,861,533.90 79.21 488,516.10 Investigations Personal Services 101-4-2130-4101 Regular Pay 514,100.00 37,275.24 432,163.71 84.06 81,936.29 101-4-2130-4102 Overtime Pay 45,000.00 2,213.42 30,415.05 67.59 14,584.95 101-4-2130-4104 PERA 80,500.00 5,686.40 69,231.27 86.00 11,268.73 101-4-2130-4107 Medicare 6,900.00 430.98 5,313.02 77.00 1,586.98 101-4-2130-4108 Insurance 69,100.00 600.15 57,394.51 83.06 11,705.49 TOTAL Personal Services 715,600.00 46,206.19 594,517.56 83.08 121,082.44 Supplies 101-4-2130-4217 Uniform Allowance 5,350.00 ( 540.88) 4,223.99 78.95 1,126.01 101-4-2130-4219 Operating Supplies 12,900.00 151.29 7,835.22 60.74 5,064.78 TOTAL Supplies 18,250.00 ( 389.59) 12,059.21 66.08 6,190.79 Other Services & Charges 101-4-2130-4319 Other Professional Services 5,450.00 0.00 1,130.31 20.74 4,319.69 101-4-2130-4331 Travel, Conferences & Schools 13,250.00 101.50 5,003.57 37.76 8,246.43 101-4-2130-4433 Dues & Subscriptions 600.00 50.00 50.00 8.33 550.00 101-4-2130-4460 Equip Replacement Charge 11,600.00 966.67 10,633.37 91.67 966.63 TOTAL Other Services & Charges 30,900.00 1,118.17 16,817.25 54.42 14,082.75 Capital Outlay TOTAL Investigations 764,750.00 46,934.77 623,394.02 81.52 141,355.98 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services Personal Services 101-4-2150-4101 Regular Pay 342,350.00 23,472.01 283,391.05 82.78 58,958.95 101-4-2150-4102 Overtime Pay 3,500.00 229.75 2,826.35 80.75 673.65 101-4-2150-4104 PERA 25,100.00 1,718.37 21,420.81 85.34 3,679.19 101-4-2150-4105 FICA 21,450.00 1,414.31 17,900.17 83.45 3,549.83 101-4-2150-4107 Medicare 5,000.00 330.76 4,186.20 83.72 813.80 101-4-2150-4108 Insurance 59,300.00 3,928.01 44,965.80 75.83 14,334.20 TOTAL Personal Services 456,700.00 31,093.21 374,690.38 82.04 82,009.62 Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 222.89 22.29 777.11 101-4-2150-4217 Uniform Allowance 3,000.00 0.00 1,787.54 59.58 1,212.46 101-4-2150-4219 Operating Supplies 14,900.00 20.18 9,918.98 66.57 4,981.02 TOTAL Supplies 18,900.00 20.18 11,929.41 63.12 6,970.59 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,350.00 365.00 1,602.07 47.82 1,747.93 101-4-2150-4404 Equip Repair/Maint Services 1,850.00 0.00 1,813.47 98.03 36.53 101-4-2150-4409 Contractual Services 16,000.00 2,071.96 11,575.09 72.34 4,424.91 101-4-2150-4433 Dues & Subscriptions 500.00 35.00 285.00 57.00 215.00 101-4-2150-4460 Equip Replacement Charge 6,200.00 516.67 5,683.37 91.67 516.63 TOTAL Other Services & Charges 27,900.00 2,988.63 20,959.00 75.12 6,941.00 Capital Outlay TOTAL Police Support Services 503,500.00 34,102.02 407,578.79 80.95 95,921.21 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 806.04 14.66 4,693.96 101-4-2160-4105 FICA 350.00 0.00 49.98 14.28 300.02 101-4-2160-4107 Medicare 100.00 0.00 11.68 11.68 88.32 TOTAL Personal Services 5,950.00 0.00 867.70 14.58 5,082.30 Supplies 101-4-2160-4217 Uniform Allowance 3,500.00 0.00 4,301.98 122.91 ( 801.98) 101-4-2160-4219 Operating Supplies 5,000.00 0.00 162.81 3.26 4,837.19 TOTAL Supplies 8,500.00 0.00 4,464.79 52.53 4,035.21 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2160-4319 Other Professional Services 1,500.00 0.00 1,125.00 75.00 375.00 101-4-2160-4321 Telephone 100.00 0.00 0.00 0.00 100.00 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0.00 1,700.00 101-4-2160-4359 Publishing 150.00 0.00 0.00 0.00 150.00 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 585.00 58.50 415.00 TOTAL Other Services & Charges 4,450.00 0.00 1,710.00 38.43 2,740.00 Capital Outlay TOTAL Police Reserves 18,900.00 0.00 7,042.49 37.26 11,857.51 Public safety building Personal Services 101-4-2190-4101 Regular Pay 104,700.00 7,785.64 88,676.82 84.70 16,023.18 101-4-2190-4102 Overtime Pay 0.00 65.93 65.93 0.00 ( 65.93) 101-4-2190-4104 PERA 7,600.00 569.23 6,714.86 88.35 885.14 101-4-2190-4105 FICA 6,500.00 463.71 5,612.90 86.35 887.10 101-4-2190-4107 Medicare 1,500.00 108.45 1,312.75 87.52 187.25 101-4-2190-4108 Insurance 13,700.00 1,195.73 13,204.72 96.38 495.28 101-4-2190-4109 Workers Comp 4,550.00 0.00 4,252.75 93.47 297.25 TOTAL Personal Services 138,550.00 10,188.69 119,840.73 86.50 18,709.27 Supplies 101-4-2190-4219 Operating Supplies 15,000.00 1,364.19 14,069.09 93.79 930.91 TOTAL Supplies 15,000.00 1,364.19 14,069.09 93.79 930.91 Other Services & Charges 101-4-2190-4361 Insurance 5,550.00 2,436.00 4,819.00 86.83 731.00 101-4-2190-4389 Utilities 19,450.00 614.23 11,754.76 60.44 7,695.24 101-4-2190-4401 Bldg Repair/Maint Services 31,600.00 1,162.92 18,458.43 58.41 13,141.57 TOTAL Other Services & Charges 56,600.00 4,213.15 35,032.19 61.89 21,567.81 Capital Outlay TOTAL Public safety building 210,150.00 15,766.03 168,942.01 80.39 41,207.99 Fire Administration 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2310-4101 Regular Pay 91,000.00 7,473.76 84,011.00 92.32 6,989.00 101-4-2310-4103 Part-time Pay 182,250.00 8,291.64 117,066.55 64.23 65,183.45 101-4-2310-4104 PERA 13,750.00 1,112.82 12,893.08 93.77 856.92 101-4-2310-4105 FICA 12,250.00 571.33 7,885.51 64.37 4,364.49 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 30,000.00 100.00 0.00 101-4-2310-4107 Medicare 3,950.00 219.30 2,848.55 72.12 1,101.45 101-4-2310-4108 Insurance 6,100.00 799.83 8,644.59 141.71 ( 2,544.59) 101-4-2310-4109 Workers Comp 23,650.00 0.00 31,375.50 132.67 ( 7,725.50) TOTAL Personal Services 362,950.00 18,468.68 294,724.78 81.20 68,225.22 Supplies 101-4-2310-4201 Office Supplies 4,250.00 324.97 2,473.05 58.19 1,776.95 101-4-2310-4212 Fuels & Lubs 6,950.00 947.99 7,620.05 109.64 ( 670.05) 101-4-2310-4217 Uniform Allowance 7,450.00 356.47 3,157.83 42.39 4,292.17 101-4-2310-4219 Operating Supplies 32,100.00 1,551.32 23,691.23 73.80 8,408.77 101-4-2310-4221 Equipment Parts 7,000.00 ( 1.51) 2,921.92 41.74 4,078.08 TOTAL Supplies 57,750.00 3,179.24 39,864.08 69.03 17,885.92 Other Services & Charges 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 459.17 2,262.97 71.84 887.03 101-4-2310-4322 Postage 500.00 0.00 541.73 108.35 ( 41.73) 101-4-2310-4331 Travel, Conferences & Schools 17,450.00 2,497.86 , 11,257.99 64.52 6,192.01 101-4-2310-4359 Publishing 300.00 0.00 0.00 0.00 300.00 101-4-2310-4361 Insurance 16,100.00 7,144.00 14,248.50 88.50 1,851.50 101-4-2310-4389 Utilities 11,700.00 158.46 5,405.04 46.20 6,294.96 101-4-2310-4401 Bldg Repair/Maint Services 5,450.00 402.45 3,102.34 56.92 2,347.66 101-4-2310-4404 Equip Repair/Maint Services 40,550.00 1,375.68 25,034.45 61.74 15,515.55 101-4-2310-4433 Dues & Subscriptions 1,400.00 204.00 1,546.00 110.43 ( 146.00) 101-4-2310-4460 Equip Replacement Charge 32,800.00 2,733.33 30,066.63 91.67 2,733.37 TOTAL Other Services & Charges 134,800.00 14,974.95 95,336.67 70.72 39,463.33 Capital Outlay TOTAL Fire Administration 555,500.00 36,622.87 429,925.53 77.39 125,574.47 Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 132,350.00 10,197.00 117,078.43 88.46 15,271.57 101-4-2320-4104 PERA 15,200.00 1,172.76 14,032.53 92.32 1,167.47 101-4-2320-4105 FICA 3,350.00 256.72 3,246.32 96.91 •103.68 101-4-2320-4107 Medicare 1,900.00 144.68 1,774.65 93.40 125.35 101-4-2320-4108 Insurance 15,300.00 1,240.11 13,641.21 89.16 1,658.79 TOTAL Personal Services 168,100.00 13,011.27 149,773.14 89.10 18,326.86 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2320-4201 Office Supplies 2,250.00 0.00 428.48 19.04 1,821.52 101-4-2320-4212 Fuels & Lubs 2,600.00 291.67 1,813.71 69.76 786.29 101-4-2320-4217 Uniform Allowance 1,400.00 0.00 ( 109.32) 7.81- 1,509.32 101-4-2320-4219 Operating Supplies 5,150.00 0.00 4,915.01 95.44 234.99 TOTAL Supplies 11,400.00 291.67 7,047.88 61.82 4,352.12 Other Services & Charges 101-4-2320-4321 Telephone 3,350.00 210.31 1,923.98 57.43 1,426.02 101-4-2320-4331 Travel, Conferences & Schools 2,250.00 0.00 198.49 8.82 2,051.51 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 153.28 1,113.28 82.47 236.72 TOTAL Other Services & Charges 8,500.00 363.59 3,719.81 43.76 4,780.19 TOTAL Fire Inspections 188,000.00 13,666.53 160,540.83 85.39 27,459.17 Emergency Management Personal Services 101-4-2330-4101 Regular Pay 9,400.00 738.98 8,311.20 88.42 1,088.80 101-4-2330-4104 PERA 1,350.00 106.40 1,246.95 92.37 103.05 101-4-2330-4107 Medicare 150.00 10.72 125.60 83.73 24.40 101-4-2330-4108 Insurance 600.00 39.13 430.43 71.74 169.57 TOTAL Personal Services 11,500.00 895.23 10,114.18 87.95 1,385.82 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 7.70 3,636.36 39.74 5,513.64 TOTAL Supplies 9,650.00 7.70 3,780.10 39.17 5,869.90 Other Services & Charges 101-4-2330-4321 Telephone 1,650.00 26.00 260.00 15.76 1,390.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 45.84 706.84 47.12 793.16 101-4-2330-4404 Equip Repair/Maint Services 5,800.00 96.19 1,457.40 25.13 4,342.60 101-4-2330-4433 Dues & Subscriptions 100.00 0.00 100.00 100.00 0.00 TOTAL Other Services & Charges 13,750.00 168.03 2,524.24 18.36 11,225.76 Capital Outlay 101-4-2330-4560 Equipment 69,000.00 11,856.26 53,511.84 77.55 15,488.16 TOTAL Capital Outlay 69,000.00 11,856.26 53,511.84 77.55 15,488.16 TOTAL Emergency Management 103,900.00 12,927.22 69,930.36 67.31 33,969.64 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Building Safety Personal Services 101-4-2410-4101 Regular Pay 325,750.00 24,305.28 285,573.27 87.67 40,176.73 101-4-2410-4103 Part-time Pay 26,450.00 2,579.14 25,953.85 98.12 496.15 101-4-2410-4104 PERA 25,550.00 1,949.15 23,547.47 92.16 2,002.53 101-4-2410-4105 FICA 21,850.00 1,569.66 19,155.28 87.67 2,694.72 101-4-2410-4107 Medicare 5,100.00 367.09 4,479.79 87.84 620.21 101-4-2410-4108 Insurance 41,400.00 3,120.01 34,989.99 84.52 6,410.01 101-4-2410-4109 Workers Comp 1,650.00 0.00 1,574.25 95.41 75.75 TOTAL Personal Services 447,750.00 33,890.33 395,273.90 88.28 52,476.10 Supplies 101-4-2410-4201 Office Supplies 4,300.00 67.84 1,501.57 34.92 2,798.43 101-4-2410-4212 Fuels & Lubs 3,200.00 621.25 3,856.08 120.50 ( 656.08) 101-4-2410-4217 Uniform Allowance 900.00 0.00 952.10 105.79 ( 52.10) 101-4-2410-4219 Operating Supplies 1,550.00 122.02 797.58 51.46 752.42 TOTAL Supplies 9,950.00 811.11 7,107.33 71.43 2,842.67 Other Services & Charges 101-4-2410-4321 Telephone 1,250.00 163.68 1,005.78 80.46 244.22 101-4-2410-4322 Postage 400.00 0.00 359.55 89.89 40.45 101-4-2410-4331 Travel, Conferences & Schools 1,550.00 43.47 1,368.62 88.30 181.38 101-4-2410-4361 Insurance 650.00 429.50 724.50 111.46 ( 74.50) 101-4-2410-4404 Equip Repair/Maint Services 7,700.00 226.33 3,932.58 51.07 3,767.42 101-4-2410-4433 Dues & Subscriptions 800.00 0.00 736.80 92.10 63.20 101-4-2410-4460 Equip Replacement Charge 3,300.00 275.00 3,025.00 91.67 275.00 TOTAL Other Services & Charges 15,650.00 1,137.98 11,152.83 71.26 4,497.17 Capital Outlay TOTAL Building Safety 473,350.00 35,839.42 413,534.06 87.36 59,815.94 Environmental Personal Services 101-4-2440-4101 Regular Pay 31,600.00 3,730.78 33,909.30 107.31 ( 2,309.30) 101-4-2440-4104 PERA 2,300.00 45.74 1,187.30 51.62 1,112.70 101-4-2440-4105 FICA 1,950.00 228.60 2,110.25 108.22 ( 160.25) 101-4-2440-4107 Medicare 450.00 53.47 493.60 109.69 ( 43.60) 101-4-2440-4108 Insurance 5,300.00 46.49 2,240.60 42.28 3,059.40 101-4-2440-4109 Workers Comp 600.00 0.00 571.50 95.25 28.50 TOTAL Personal Services 42,200.00 4,105.08 40,512.55 96.00 1,687.45 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2440-4201 Office Supplies 500.00 17.29 390.41 78.08 109.59 101-4-2440-4212 Fuels & Lubs 150.00 36.26 198.30 132.20 ( 48.30) 101-4-2440-4219 Operating Supplies 0.00 89.74 90.03 0.00 ( 90.03) TOTAL Supplies 650.00 143.29 678.74 104.42 ( 28.74) Other Services & Charges 101-4-2440-4321 Telephone 550.00 4.42 51.39 9.34 498.61 101-4-2440-4322 Postage 800.00 0.00 244.42 30.55 555.58 101-4-2440-4331 Travel, Conferences & Schools 500.00 0.00 688.05 137.61 ( 188.05) 101-4-2440-4359 Publishing 100.00 0.00 0.00 0.00 100.00 101-4-2440-4409 Contractual Services 3,000.00 84.00 546.00 18.20 2,454.00 101-4-2440-4433 Dues & Subscriptions 1,050.00 0.00 40.00 3.81 1,010.00 TOTAL Other Services & Charges 6,000.00 88.42 1,569.86 26.16 4,430.14 TOTAL Environmental 48,850.00 4,336.79 42,761.15 87.54 6,088.85 TOTAL Public Safety 5,782,450.00 404,255.16 4,664,099.04 80.66 1,118,350.96 Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 386,700.00 37,049.87 390,142.77 100.89 ( 3,442.77) 101-4-3120-4102 Overtime Pay 0.00 348.84 811.72 0.00 ( 811.72) 101-4-3120-4103 Part-time Pay 116,600.00 7,999.84 105,764.96 90.71 10,835.04 101-4-3120-4104 PERA 32,200.00 2,982.75 33,146.36 102.94 ( 946.36) 101-4-3120-4105 FICA 31,200.00 2,594.51 30,024.97 96.23 1,175.03 101-4-3120-4107 Medicare 7,300.00 606.77 7,021.90 96.19 278.10 101-4-3120-4108 Insurance 64,700.00 6,497.36 65,617.56 101.42 ( 917.56) 101-4-3120-4109 Workers Comp 27,600.00 0.00 25,180.75 91.23 2,419.25 TOTAL Personal Services 666,300.00 58,079.94 657,710.99 98.71 8,589.01 Supplies 101-4-3120-4201 Office Supplies 4,200.00 234.11 1,815.91 43.24 2,384.09 101-4-3120-4212 Fuels & Lubs 87,250.00 6,280.24 58,449.98 66.99 28,800.02 101-4-3120-4219 Operating Supplies 110,750.00 6,350.23 109,259.93 98.65 1,490.07 101-4-3120-4226 Street Signs 35,850.00 3,083.32 20,396.08 56.89 15,453.92 TOTAL Supplies 238,050.00 15,947.90 189,921.90 79.78 48,128.10 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 600.14 5,522.53 74.13 1,927.47 101-4-3120-4322 Postage 200.00 0.00 86.57 43.29 113.43 101-4-3120-4331 Travel, Conferences & Schools 2,500.00 570.00 2,582.27 103.29 ( 82.27) 101-4-3120-4359 Publishing 500.00 0.00 54.00 10.80 446.00 101-4-3120-4361 Insurance 18,750.00 9,625.50 17,313.50 92.34 1,436.50 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-3120-4389 Utilities 36,000.00 3,210.72 31,784.10 88.29 4,215.90 101-4-3120-4401 Bldg Repair/Maint Services 4,500.00 0.00 1,774.97 39.44 2,725.03 101-4-3120-4404 Equip Repair/Maint Services 5,000.00 5,432.19 6,553.29 131.07 ( 1,553.29) 101-4-3120-4409 Contractual Services 419,000.00 ( 24,327.91) 346,571.45 82.71 72,428.55 101-4-3120-4415 Equipment Rental 5,500.00 96.19 1,348.84 24.52 4,151.16 101-4-3120-4417 Uniform Rental 4,700.00 844.39 2,500.59 53.20 2,199.41 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 286.25 81.79 63.75 101-4-3120-4437 Taxes & Licenses 500.00 0.00 471.00 94.20 29.00 101-4-3120-4460 Equip Replacement Charge 95,750.00 7,979.17 87,770.87 91.67 7,979.13 TOTAL Other Services & Charges 600,950.00 4,030.39 504,832.56 84.01 96,117.44 Capital Outlay TOTAL Street Maintenance 1,505,300.00 78,058.23 1,352,465.45 89.85 152,834.55 Snow Removal Personal Services 101-4-3130-4101 Regular Pay 100,300.00 0.00 36,949.19 36.84 63,350.81 101-4-3130-4102 Overtime Pay 20,000.00 0.00 6,537.25 32.69 13,462.75 101-4-3130-4103 Part-time Pay 9,100.00 0.00 4,821.54 52.98 4,278.46 101-4-3130-4104 PERA 8,350.00 0.00 3,498.17 41.89 4,851.83 101-4-3130-4105 FICA 8,000.00 0.00 3,035.71 37.95 4,964.29 101-4-3130-4107 Medicare 1,900.00 0.00 709.93 37.36 1,190.07 101-4-3130-4108 Insurance 17,100.00 0.00 6,210.18 36.32 10,889.82 101-4-3130-4109 Workers Comp 7,650.00 0.00 6,305.25 82.42 1,344.75 TOTAL Personal Services 172,400.00 0.00 68,067.22 39.48 104,332.78 Supplies 101-4-3130-4219 Operating Supplies 96,000.00 2,337.62 35,650.54 37.14 60,349.46 TOTAL Supplies 96,000.00 2,337.62 35,650.54 37.14 60,349.46 Other Services & Charges Capital Outlay 101-4-3130-4560 Equipment 20,000.00 0.00 18,622.70 93.11 1,377.30 TOTAL Capital Outlay 20,000.00 0.00 18,622.70 93.11 1,377.30 TOTAL Snow Removal 288,400.00 2,337.62 122,340.46 42.42 166,059.54 Equipment Services 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-3150-4101 Regular Pay 166,050.00 12,772.80 143,454.68 86.39 22,595.32 101-4-3150-4102 Overtime Pay 0.00 0.00 348.84 0.00 ( 348.84) 101-4-3150-4104 PERA 12,050.00 926.02 10,879.51 90.29 1,170.49 101-4-3150-4105 FICA 10,300.00 747.56 8,839.03 85.82 1,460.97 101-4-3150-4107 Medicare 2,400.00 174.84 2,067.22 86.13 332.78 101-4-3150-4108 Insurance 23,400.00 1,778.00 18,921.61 80.86 4,478.39 101-4-3150-4109 Workers Comp 4,500.00 0.00 4,235.75 94.13 264.25 TOTAL Personal Services 218,700.00 16,399.22 188,746.64 86.30 29,953.36 Supplies 101-4-3150-4219 Operating Supplies 20,200.00 433.13 6,513.93 32.25 13,686.07 101-4-3150-4221 Equipment Parts 6,000.00 2,700.00 4,394.36 73.24 1,605.64 TOTAL Supplies 26,200.00 3,133.13 10,908.29 41.63 15,291.71 Other Services & Charges 101-4-3150-4417 Uniform Rental 3,000.00 295.07 2,614.32 87.14 385.68 TOTAL Other Services & Charges 3,000.00 295.07 2,614.32 87.14 385.68 Capital Outlay TOTAL Equipment Services 247,900.00 19,827.42 202,269.25 81.59 45,630.75 Engineering Personal Services 101-4-3300-4101 Regular Pay 79,250.00 11,305.50 95,058.29 119.95 ( 15,808.29) 101-4-3300-4104 PERA 5,750.00 819.64 7,141.64 124.20 ( 1,391.64) 101-4-3300-4105 FICA 4,900.00 686.14 5,944.56 121.32 ( 1,044.56) 101-4-3300-4107 Medicare 1,150.00 160.48 1,390.31 120.90 ( 240.31) 101-4-3300-4108 Insurance 14,050.00 1,042.00 7,294.00 51.91 6,756.00 101-4-3300-4109 Workers Comp 550.00 0.00 597.00 108.55 ( 47.00) TOTAL Personal Services 105,650.00 14,013.76 117,425.80 111.15 ( 11,775.80) Supplies 101-4-3300-4201 Office Supplies 500.00 5.33 150.06 30.01 349.94 101-4-3300-4212 Fuels & Lubs 600.00 108.07 358.27 59.71 241.73 101-4-3300-4219 Operating Supplies 1,000.00 41.72 1,565.99 156.60 ( 565.99) TOTAL Supplies 2,100.00 155.12 2,074.32 98.78 25.68 Other Services & Charges 101-4-3300-4319 Other Professional Services 13,500.00 0.00 3,488.34 25.84 10,011.66 101-4-3300-4321 Telephone 700.00 355.55 618.80 88.40 81.20 101-4-3300-4322 Postage 150.00 0.00 50.31 33.54 99.69 101-4-3300-4331 Travel, Conferences & Schools 2,700.00 75.48 572.60 21.21 2,127.40 101-4-3300-4361 Insurance 200.00 101.00 192.00 96.00 8.00 101-4-3300-4404 Equip Repair/Maint Services 7,800.00 196.00 2,497.08 32.01 5,302.92 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) ' AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. 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 687.50 91.67 62.50 TOTAL Other Services & Charges 25,800.00 790.53 8,106.63 31.42 17,693.37 Capital Outlay TOTAL Engineering 133,550.00 14,959.41 127,606.75 95.55 5,943.25 TOTAL Public Works 2,175,150.00 115,182.68 1,804,681.91 82.97 370,468.09 Parks Department Personal Services 101-4-5110-4101 Regular Pay 344,300.00 26,072.47 294,452.61 85.52 49,847.39 101-4-5110-4102 Overtime Pay 6,600.00 42.23 1,486.82 22.53 5,113.18 101-4-5110-4103 Part-time Pay 58,250.00 2,403.31 66,113.20 113.50 ( 7,863.20) 101-4-5110-4104 PERA 26,900.00 1,980.41 23,298.43 86.61 3,601.57 101-4-5110-4105 FICA 25,500.00 1,642.24 22,211.20 87.10 3,288.80 101-4-5110-4107 Medicare 6,000.00 384.07 5,194.43 86.57 805.57 101-4-5110-4108 Insurance 46,200.00 4,093.36 41,313.96 89.42 4,886.04 101-4-5110-4109 Workers Comp 10,850.00 0.00 10,555.25 97.28 294.75 101-4-5110-4110 Re-employment Compensation 0.00 0.00 1,458.22 0.00 ( 1,458.22) TOTAL Personal Services 524,600.00 36,618.09 466,084.12 88.85 58,515.88 Supplies 101-4-5110-4212 Fuels & Lubs 39,100.00 2,318.92 33,185.55 84.87 5,914.45 101-4-5110-4217 Uniform Allowance 3,200.00 56.00 1,967.20 61.48 1,232.80 101-4-5110-4219 Operating Supplies 78,250.00 5,725.76 73,666.14 94.14 4,583.86 101-4-5110-4221 Equipment Parts 13,000.00 2,807.05 19,439.10 149.53 ( 6,439.10) TOTAL Supplies 133,550.00 10,907.73 128,257.99 96.04 5,292.01 Other Services & Charges 101-4-5110-4321 Telephone 3,800.00 326.63 3,194.64 84.07 605.36 101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-5110-4331 Travel, Conferences & Schools 3,150.00 37.06 3,329.37 105.69 ( 179.37) 101-4-5110-4361 Insurance 27,600.00 12,787.50 24,808.00 89.88 2,792.00 101-4-5110-4389 Utilities 24,700.00 4,803.36 26,632.74 107.82 ( 1,932.74) 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 25.65 0.64 3,974.35 101-4-5110-4404 Equip Repair/Maint Services 13,100.00 3,222.51 10,754.99 82.10 2,345.01 101-4-5110-4409 Contractual Services 7,300.00 202.42 7,679.41 105.20 ( 379.41) 101-4-5110-4415 Equipment Rental 20,500.00 862.97 12,085.24 58.95 8,414.76 101-4-5110-4460 Equip Replacement Charge 51,450.00 4,287.50 47,162.50 91.67 4,287.50 TOTAL Other Services & Charges 155,650.00 26,529.95 135,672.54 87.17 19,977.46 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE 8 OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Parks Department 813,800.00 74,055.77 730,014.65 89.70 83,785.35 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 352,350.00 25,240.69 303,884.27 86.25 48,465.73 101-4-5210-4102 Overtime Pay 0.00 0.00 1,246.71 0.00 ( 1,246.71) 101-4-5210-4103 Part-time Pay 45,300.00 3,376.63 39,952.30 88.19 5,347.70 101-4-5210-4104 PERA 27,200.00 2,074.75 26,054.98 95.79 1,145.02 101-4-5210-4105 FICA 23,300.00 1,639.86 20,907.23 89.73 2,392.77 101-4-5210-4107 Medicare 5,450.00 383.51 4,889.44 89.71 560.56 101-4-5210-4108 Insurance 52,700.00 4,000.34 43,741.37 83.00 8,958.63 101-4-5210-4109 Workers Comp 4,450.00 0.00 4,222.25 94.88 227.75 TOTAL Personal Services 510,750.00 36,715.78 444,898.55 87.11 65,851.45 Supplies 101-4-5210-4219 Operating Supplies 10,200.00 520.06 9,213.90 90.33 986.10 TOTAL Supplies 10,200.00 520.06 9,213.90 90.33 986.10 Other Services & Charges 101-4-5210-4321 Telephone 4,800.00 656.25 5,255.77 109.50 ( 455.77) 101-4-5210-4322 Postage 6,000.00 0.00 3,619.96 60.33 2,380.04 101-4-5210-4331 Travel, Conferences & Schools 6,850.00 1,288.97 7,835.34 114.38 ( 985.34) 101-4-5210-4349 Advertising/Marketing 32,400.00 726.14 22,541.44 69.57 9,858.56 101-4-5210-4361 Insurance 650.00 368.00 663.00 102.00 ( 13.00) 101-4-5210-4389 Utilities 7,400.00 169.05 3,349.01 45.26 4,050.99 101-4-5210-4401 Bldg Repair/Maint Services 13,300.00 1,076.46 11,798.05 88.71 1,501.95 101-4-5210-4404 Equip Repair/Maint Services 9,350.00 1,184.54 9,200.36 98.40 149.64 101-4-5210-4433 Dues & Subscriptions 1,550.00 24.00 1,407.00 90.77 143.00 TOTAL Other Services & Charges 82,300.00 5,493.41 65,669.93 79.79 16,630.07 Capital Outlay TOTAL Parks & Rec Admin 603,250.00 42,729.25 519,782.38 86.16 83,467.62 Recreation Programs Personal Services 101-4-5220-4102 Overtime Pay 0.00 0.00 645.66 0.00 ( 645.66) 101-4-5220-4103 Part-time Pay 82,000.00 1,550.72 74,779.15 91.19 7,220.85 101-4-5220-4104 PERA 2,400.00 37.86 1,610.31 67.10 789.69 101-4-5220-4105 FICA 4,350.00 96.15 4,750.13 109.20 ( 400.13) 101-4-5220-4107 Medicare 1,200.00 22.49 1,110.91 92.58 89.09 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5220-4110 Re-employment Compensation 0.00 0.00 405.40 0.00 ( 405.40) TOTAL Personal Services 89,950.00 1,707.22 83,301.56 92.61 6,648.44 Supplies 101-4-5220-4219 Operating Supplies 37,000.00 2,150.20 26,523.77 71.69 10,476.23 TOTAL Supplies 37,000.00 2,150.20 26,523.77 71.69 10,476.23 Other Services & Charges 101-4-5220-4409 Contractual Services 64,050.00 2,230.26 55,244.84 86.25 8,805.16 101-4-5220-4412 Building Rent 1,500.00 0.00 1,607.94 107.20 ( 107.94) 101-4-5220-4438 Credit Card Fees 4,500.00 224.46 3,978.28 88.41 521.72 TOTAL Other Services & Charges 70,050.00 2,454.72 60,831.06 86.84 9,218.94 TOTAL Recreation Programs 197,000.00 6,312.14 170,656.39 86.63 26,343.61 Concessions Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 0.00 0.00 0.00 3,650.00 101-4-5230-4104 PERA 150.00 0.00 0.00 0.00 150.00 101-4-5230-4105 FICA 250.00 0.00 0.00 0.00 250.00 101-4-5230-4107 Medicare 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 4,100.00 0.00 0.00 0.00 4,100.00 Supplies 101-4-5230-4219 Operating Supplies 2,900.00 0.00 0.00 0.00 2,900.00 101-4-5230-4259 Other Merchandise For Resale 7,000.00 0.00 0.00 0.00 7,000.00 TOTAL Supplies 9,900.00 0.00 0.00 0.00 9,900.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 100.00 TOTAL Concessions 14,100.00 0.00 0.00 0.00 14,100.00 Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 58,550.00 7,134.41 50,304.98 85.92 8,245.02 101-4-5510-4103 Part-time Pay 62,350.00 0.00 59,488.77 95.41 2,861.23 101-4-5510-4104 PERA 8,750.00 517.26 7,133.26 81.52 1,616.74 101-4-5510-4105 FICA 7,500.00 440.07 6,877.73 91.70 622.27 101-4-5510-4107 Medicare 1,750.00 102.93 1,608.42 91.91 141.58 101-4-5510-4108 Insurance 14,100.00 883.51 9,484.61 67.27 4,615.39 101-4-5510-4109 Workers Comp 650.00 0.00 590.00 90.77 60.00 TOTAL Personal Services 153,650.00 9,078.18 135,487.77 88.18 18,162.23 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5510-4219 Operating Supplies 13,350.00 156.94 6,077.04 45.52 7,272.96 TOTAL Supplies 13,350.00 156.94 6,077.04 45.52 7,272.96 Other Services & Charges 101-4-5510-4321 Telephone 2,600.00 159.71 1,732.17 66.62 867.83 101-4-5510-4322 Postage 2,500.00 0.00 2,055.59 82.22 444.41 101-4-5510-4331 Travel, Conferences & Schools 1,900.00 103.37 424.84 22.36 1,475.16 101-4-5510-4361 Insurance 1,600.00 1,026.50 1,735.00 108.44 ( 135.00) 101-4-5510-4389 Utilities 9,300.00 1,017.63 7,115.55 76.51 2,184.45 101-4-5510-4401 Bldg Repair/Maint Services 13,750.00 1,487.53 11,670.14 84.87 2,079.86 101-4-5510-4404 Equip Repair/Maint Services 1,950.00 227.36 2,207.55 113.21 ( 257.55) 101-4-5510-4409 Contractual Services 7,450.00 167.00 553.50 7.43 6,896.50 101-4-5510-4433 Dues & Subscriptions 950.00 109.30 889.77 93.66 60.23 TOTAL Other Services & Charges 42,000.00 4,298.40 28,384.11 67.58 13,615.89 Capital Outlay 101-4-5510-4560 Equipment 17,500.00 0.00 0.00 0.00 17,500.00 TOTAL Capital Outlay 17,500.00 0.00 0.00 0.00 17,500.00 TOTAL Sr Citizen Programs 226,500.00 13,533.52 169,948.92 75.03 56,551.08 TOTAL Culture & Recreation 1,854,650.00 136,630.68 1,590,402.34 85.75 264,247.66 Economic Development Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 3,938.27) 20,063.52 0.00 ( 20,063.52) 101-4-6210-4103 Part-time Pay 0.00 1,058.40 2,116.80 0.00 ( 2,116.80) 101-4-6210-4104 PERA 0.00 ( 270.11) 1,485.44 0.00 ( 1,485.44) 101-4-6210-4105 FICA 0.00 ( 172.96) 1,261.42 0.00 ( 1,261.42) 101-4-6210-4107 Medicare 0.00 ( 40.66) 299.38 0.00 ( 299.38) 101-4-6210-4108 Insurance 0.00 ( 300.16) 2,982.00 0.00 ( 2,982.00) 101-4-6210-4109 Workers Comp 0.00 ( 251.00) 0.00 0.00 0.00 TOTAL Personal Services 0.00 ( 3,914.76) 28,208.56 0.00 ( 28,208.56) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 256.72 390.75 0.00 ( 390.75) TOTAL Other Services & Charges 0.00 256.72 390.75 0.00 ( 390.75) TOTAL Economic Development 0.00 ( 3,658.04) 28,599.31 0.00 ( 28,599.31) 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 101-GENERAL FUND Economic Development 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Energy City Personal Services 101-4-6220-4101 Regular Pay 29,300.00 1,576.98 21,493.57 73.36 7,806.43 101-4-6220-4104 PERA 2,100.00 114.34 1,602.15 76.29 497.85 101-4-6220-4105 FICA 1,800.00 91.00 1,306.31 72.57 493.69 101-4-6220-4107 Medicare 400.00 21.28 305.52 76.38 94.48 101-4-6220-4108 Insurance 3,250.00 116.25 1,827.19 56.22 1,422.81 TOTAL Personal Services 36,850.00 1,919.85 26,534.74 72.01 10,315.26 Supplies 101-4-6220-4219 Operating Supplies 0.00 21.53 34.38 0.00 ( 34.38) TOTAL Supplies 0.00 21.53 34.38 0.00 ( 34.38) Other Services & Charges 101-4-6220-4319 Other Professional Services 5,000.00 0.00 926.17 18.52 4,073.83 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 727.50 2,750.74 36.68 4,749.26 101-4-6220-4359 Publishing _ 1,500.00 0.00 1,060.00 70.67 440.00 TOTAL Other Services & Charges 14,000.00 727.50 4,736.91 33.84 9,263.09 TOTAL Energy City 50,850.00 2,668.88 31,306.03 61.57 19,543.97 TOTAL Economic Development 50,850.00 ( 989.16) 59,905.34 117.81 ( 9,055.34) 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 877,894.10 10,297,535.26 81.22 2,380,514.74 REVENUES OVER/(UNDER) EXPENDITURES ( 366,150.00) ( 803,945.17) ( 2,741,180.55) 2,375,030.55 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 569,600.00 78,731.13 437,394.31 76.79 132,205.69 Hockey 30,000.00 ( 14,106.90) 30,844.90 102.82 ( 844.90) Skating 65,800.00 4,468.00 30,832.87 46.86 34,967.13 Concessions 69,000.00 15,997.86 62,637.21 90.78 6,362.79 TOTAL REVENUES 734,400.00 85,090.09 561,709.29 76.49 172,690.71 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 543,550.00 46,974.34 455,760.17 83.85 87,789.83 Hockey 25,000.00 1,721.00 17,840.04 71.36 7,159.96 Skating 28,750.00 942.54 13,341.46 46.41 15,408.54 Arena Concessions 47,150.00 6,850.93 37,932.69 80.45 9,217.31 TOTAL Culture & Recreation 644,450.00 56,488.81 524,874.36 81.45 119,575.64 TOTAL EXPENDITURES 644,450.00 56,488.81 524,874.36 81.45 119,575.64 REVENUES OVER/(UNDER) EXPENDITURES 89,950.00 28,601.28 36,834.93 53,115.07 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA 91.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 488,000.00 68,413.70 373,268.74 76.49 114,731.26 221-3-0000-3465 Admissions 22,900.00 4,626.00 19,264.50 84.12 3,635.50 221-3-0000-3466 Dry Floor Events 17,400.00 ( 5.00) 17,462.93 100.36 ( 62.93) 221-3-0000-3468 Skate Sharpening 4,300.00 751.00 3,553.00 82.63 747.00 221-3-0000-3475 Building Rent 2,600.00 2,600.00 2,600.00 100.00 0.00 221-3-0000-3482 Advertising fee 17,500.00 • 416.67 2,626.70 15.01 14,873.30 TOTAL Charges for Services 552,700.00 76,802.37 418,775.87 75.77 133,924.13 Other Revenue 221-3-0000-3621 Interest Income 0.00 0.00 247.30 0.00 ( 247.30) 221-3-0000-3622 Vending Machines 14,000.00 1,352.42 11,810.62 84.36 2,189.38 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 554.29 2,344.07 83.72 455.93 TOTAL Other Revenue 16,800.00 1,906.71 18,398.99 109.52 ( 1,598.99) Sales 221-3-0000-3791 ATM Revenue 100.00 22.05 219.45 219.45 ( 119.45) TOTAL Sales 100.00 22.05 219.45 219.45 ( 119.45) Transfers In _ TOTAL Ice Arena 569,600.00 78,731.13 437,394.31 76.79 132,205.69 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 30,000.00 ( 14,106.90) 30,844.90 102.82 ( 844.90) TOTAL Charges for Services 30,000.00 ( 14,106.90) 30,844.90 102.82 ( 844.90) Other Revenue TOTAL Hockey 30,000.00 ( 14,106.90) 30,844.90 102.82 ( 844.90) Skating 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA 91.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 62,000.00 4,468.00 27,500.00 44.35 34,500.00 221-3-5420-3465 Admissions 3,800.00 0.00 3,332.87 87.71 467.13 TOTAL Charges for Services 65,800.00 4,468.00 30,832.87 46.86 34,967.13 Other Revenue _ TOTAL Skating 65,800.00 4,468.00 30,832.87 46.86 34,967.13 Concessions Charges for Services 221-3-5430-3467 Concessions 69,000.00 15,997.86 62,637.21 90.78 6,362.79 TOTAL Charges for Services 69,000.00 15,997.86 62,637.21 90.78 6,362.79 TOTAL Concessions 69,000.00 15,997.86 62,637.21 90.78 6,362.79 TOTAL REVENUE 734,400.00 85,090.09 561,709.29 76.49 172,690.71 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 167,600.00 12,178.10 142,554.62 85.06 25,045.38 221-4-5400-4103 Part-time Pay 59,300.00 6,188.78 56,126.54 94.65 3,173.46 221-4-5400-4104 PERA 15,700.00 1,091.45 12,872.02 81.99 2,827.98 221-4-5400-4105 FICA 14,100.00 1,097.89 12,385.26 87.84 1,714.74 221-4-5400-4107 Medicare 3,350.00 256.75 2,896.63 86.47 453.37 221-4-5400-4108 Insurance 26,400.00 1,881.00 20,226.00 76.61 6,174.00 221-4-5400-4109 Workers Comp 8,000.00 0.00 7,297.75 91.22 702.25 TOTAL Personal Services 294,450.00 22,693.97 254,358.82 86.38 40,091.18 Supplies 221-4-5400-4212 Fuels & Lubs 50.00 0.00 14.57 29.14 35.43 221-4-5400-4217 Uniform Allowance 1,300.00 0.00 610.80 46.98 689.20 221-4-5400-4219 Operating Supplies 34,250.00 5,151.93 28,626.78 83.58 5,623.22 221-4-5400-4255 Soft Drinks/Misc 8,000.00 1,196.24 5,721.53 71.52 2,278.47 221-4-5400-4259 Other Merchandise For Resale 600.00 846.38 846.38 141.06 ( 246.38) TOTAL Supplies 44,200.00 '7,194.55 35,820.06 81.04 8,379.94 Other Services & Charges 221-4-5400-4321 Telephone 3,500.00 157.97 1,532.02 43.77 1,967.98 221-4-5400-4322 Postage 400.00 0.00 153.11 38.28 246.89 221-4-5400-4331 Travel, Conferences & Schools 1,000.00 285.21 1,496.98 149.70 ( 496.98) 221-4-5400-4359 Publishing 2,000.00 ( 19.60) 4,298.13 214.91 ( 2,298.13) 221-4-5400-4361 Insurance 7,800.00 4,059.00 7,472.00 95.79 328.00 221-4-5400-4389 Utilities 142,450.00 11,356.72 120,565.05 84.64 21,884.95 221-4-5400-4401 Bldg Repair/Maint Services 22,750.00 1,237.57 8,038.63 35.33 14,711.37 221-4-5400-4409 Contractual Services 1,200.00 0.00 2,340.89 195.07 ( 1,140.89) 221-4-5400-4415 Equipment Rental 2,800.00 8.95 1,518.13 54.22 1,281.87 221-4-5400-4433 Dues & Subscriptions 500.00 0.00 380.00 76.00 120.00 TOTAL Other Services & Charges 184,400.00 17,085.82 147,794.94 80.15 36,605.06 Capital Outlay 221-4-5400-4560 Equipment 20,500.00 0.00 17,786.35 86.76 2,713.65 TOTAL Capital Outlay 20,500.00 0.00 17,786.35 86.76 2,713.65 Transfers Out TOTAL Ice Arena 543,550.00 46,974.34 455,760.17 83.85 87,789.83 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey 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 221-4-5410-4219 Operating Supplies 12,550.00 0.00 10,977.33 87.47 1,572.67 TOTAL Supplies 12,550.00 0.00 10,977.33 87.47 1,572.67 Other Services & Charges 221-4-5410-4409 Contractual Services 6,400.00 1,721.00 3,637.80 56.84 2,762.20 221-4-5410-4438 Credit Card Fees 2,200.00 0.00 3,224.91 146.59 ( 1,024.91) TOTAL Other Services & Charges 8,600.00 1,721.00 6,862.71 79.80 1,737.29 TOTAL Hockey 25,000.00 1,721.00 17,840.04 71.36 7,159.96 Skating Personal Services 221-4-5420-4103 Part-time Pay 15,000.00 815.38 8,783.17 58.55 6,216.83 221-4-5420-4104 PERA 1,000.00 10.94 339.56 33.96 660.44 221-4-5420-4105 FICA 950.00 50.55 557.21 58.65 392.79 221-4-5420-4107 Medicare 200.00 11.81 130.34 65.17 69.66 TOTAL Personal Services 17,150.00 888.68 9,810.28 57.20 7,339.72 Supplies 221-4-5420-4219 Operating Supplies 5,300.00 0.00 1,640.81 30.96 3,659.19 TOTAL Supplies 5,300.00 0.00 1,640.81 30.96 3,659.19 Other Services & Charges 221-4-5420-4359 Publishing 650.00 0.00 411.47 63.30 238.53 221-4-5420-4409 Contractual Services 2,850.00 0.00 622.00 21.82 2,228.00 221-4-5420-4438 Credit Card Fees 2,800.00 53.86 856.90 30.60 1,943.10 TOTAL Other Services & Charges 6,300.00 53.86 1,890.37 30.01 4,409.63 TOTAL Skating 28,750.00 942.54 13,341.46 46.41 15,408.54 • 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 221-ICE ARENA Culture & Recreation 91.67% 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 1,963.81 11,495.90 55.00 9,404.10 221-4-5430-4104 PERA 200.00 37.81 220.78 110.39 ( 20.78) 221-4-5430-4105 FICA 1,300.00 121.75 769.36 59.18 530.64 221-4-5430-4107 Medicare 300.00 28.47 179.92 59.97 120.08 TOTAL Personal Services 22,700.00 2,151.84 12,665.96 55.80 10,034.04 Supplies 221-4-5430-4219 Operating Supplies 2,950.00 392.75 3,453.41 117.06 ( 503.41) 221-4-5430-4259 Other Merchandise For Resale 21,500.00 4,306.34 21,813.32 101.46 ( 313.32) TOTAL Supplies 24,450.00 4,699.09 25,266.73 103.34 ( 816.73) TOTAL Arena Concessions 47,150.00 6,850.93 37,932.69 80.45 9,217.31 TOTAL Culture & Recreation 644,450.00 56,488.81 524,874.36 81.45 119,575.64 TOTAL EXPENDITURES 644,450.00 56,488.81 524,874.36 81.45 119,575.64 REVENUES OVER/(UNDER) EXPENDITURES 89,950.00 28,601.28 36,834.93 53,115.07 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course 236,500.00 1,686.48 186,393.20 78.81 50,106.80 TOTAL REVENUES 236,500.00 1,686.48 186,393.20 78.81 50,106.80 EXPENDITURE SUMMARY Culture & Recreation Golf Course 236,500.00 17,006.75 212,372.23 89.80 24,127.77 TOTAL Culture & Recreation 236,500.00 17,006.75 212,372.23 89.80 24,127.77 TOTAL EXPENDITURES 236,500.00 17,006.75 212,372.23 89.80 24,127.77 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 15,320.27) ( 25,979.03) 25,979.03 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 222-PINEWOOD GOLF COURSE 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 16,500.00 0.00 16,019.00 97.08 481.00 222-3-0000-3467 Concessions 16,000.00 102.94 16,888.32 105.55 ( 888.32) 222-3-0000-3469 Other Sales 3,500.00 28.25 5,499.13 157.12 ( 1,999.13) 222-3-0000-3476 Green Fees 120,000.00 1,269.25 102,755.33 85.63 17,244.67 222-3-0000-3477 Membership Fees 16,500.00 0.00 17,085.00 103.55 ( 585.00) 222-3-0000-3478 Golf Cart Rental 18,500.00 285.50 23,792.00 128.61 ( 5,292.00) 222-3-0000-3479 Tournaments 5,000.00 0.00 4,101.29 82.03 898.71 TOTAL Charges for Services 196,000.00 1,685.94 186,140.07 94.97 9,859.93 Other Revenue 222-3-0000-3629 Miscellaneous Revenue 0.00 0.00 220.00 0.00 ( 220.00) TOTAL Other Revenue 0.00 0.00 220.00 0.00 ( 220.00) Sales 222-3-0000-3792 Cash Over 0.00 0.54 33.13 0.00 ( 33.13) TOTAL Sales 0.00 0.54 33.13 0.00 ( 33.13) Other Financing Sources Transfers In 222-3-0000-3922 Transfer-General Fund 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Transfers In 40,500.00 0.00 0.00 0.00 40,500.00 TOTAL Pinewood Golf Course 236,500.00 1,686.48 186,393.20 78.81 50,106.80 TOTAL REVENUE 236,500.00 1,686.48 186,393.20 78.81 50,106.80 12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 222-PINEWOOD GOLF COURSE 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 87,100.00 6,000.46 76,544.09 87.88 10,555.91 222-4-5300-4103 Part-time Pay 29,900.00 169.83 28,137.72 94.11 1,762.28 222-4-5300-4104 PERA 8,500.00 435.04 6,831.75 80.37 1,668.25 222-4-5300-4105 FICA 7,250.00 377.82 6,607.41 91.14 642.59 222-4-5300-4107 Medicare 1,700.00 88.35 1,545.19 90.89 154.81 222-4-5300-4108 Insurance 6,100.00 465.00 5,115.00 83.85 985.00 222-4-5300-4109 Workers Comp 1,850.00 0.00 1,641.75 88.74 208.25 222-4-5300-4110 Re-employment Compensation 0.00 587.85 4,417.55 0.00 ( 4,417.55) TOTAL Personal Services 142,400.00 8,124.35 130,840.46 91.88 11,559.54 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 48.23 4,896.83 108.82 ( 396.83) 222-4-5300-4217 Uniform Allowance 500.00 0.00 388.87 77.77 111.13 222-4-5300-4219 Operating Supplies 29,700.00 783.05 29,310.97 98.69 389.03 222-4-5300-4259 Other Merchandise For Resale 12,000.00 0.00 11,440.87 95.34 559.13 TOTAL Supplies 46,700.00 831.28 46,037.54 98.58 662.46 Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 185.38 1,718.12 71.59 681.88 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 0.00 5,012.65 100.25 ( 12.65) 222-4-5300-4361 Insurance 12,100.00 6,112.50 11,257.00 93.03 843.00 222-4-5300-4389 Utilities 6,550.00 699.85 5,577.10 85.15 972.90 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 521.44 5.83 8,428.56 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 375.68 4,392.58 95.49 207.42 222-4-5300-4415 Equipment Rental 1,350.00 248.29 914.26 67.72 435.74 222-4-5300-4437 Taxes & Licenses 1,000.00 204.17 776.16 77.62 223.84 222-4-5300-4438 Credit Card Fees 5,000.00 205.21 5,307.23 106.14 ( 307.23) TOTAL Other Services & Charges 47,400.00 8,051.12 35,494.23 74.88 11,905.77 Capital Outlay Debt Service TOTAL Golf Course 236,500.00 17,006.75 212,372.23 89.80 24,127.77 TOTAL Culture & Recreation 236,500.00 17,006.75 212,372.23 89.80 24,127.77 TOTAL EXPENDITURES 236,500.00 17,006.75 212,372.23 89.80 24,127.77 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 15,320.27) ) 25,979.03) 25,979.03 CITY OF ELK RIVER ENTERPRISE FUNDS- BUDGET TO ACTUAL MONTH ENDED NOVEMBER 30,2012 H is f Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Sales and cost of sales: Sales $ 6,250,000 $ 5,793,481 $ 456,519 92.70% Cost of sales (4,517,250) (4,002,546) (514,704) 88.61% Gross profit 1,732,750 1,790,935 (58,185) 103.36% Operating revenues: User charges - - - 0.00% $ 1,554,450 $ 1,273,387 $ 281,063 81.92% $ 1,299,000 $ 1,073,218 $ 225,782 82.62% Delinquency collections - - - 0.00% 2,500 (8,858) 11,358 -354.32% 7,000 (7,552) 14,552 -107.89% Other 5,000 6,786 (1,786) 135.72% 287,500 3,263 284,237 1.13% 28,600 17,030 11,570 59.55% Total operating revenues 5,000 6,786 (1,786) 135.72% 1,844,450 1,267,792 576,658 68.74% 1,334,600 1,082,696 251,904 81.13% Operating expenses: Personal services 583,400 522,260 61,140 89.52% 480,550 423,214 57,336 88.07% 52,900 38,490 14,410 72.76% Supplies 26,600 14,867 11,733 55.89% 174,900 93,730 81,170 53.59% 10,600 3,892 6,708 36.72% Other service charges 226,450 125,112 101,338 55.25% 461,950 412,427 49,523 89.28% 1,260,000 1,019,657 240,343 80.93% Depreciation* 123,150 - 123,150 0.00% 993,600 - 993,600 0.00% - - - 0.00% Total operating expenses 959,600 662,239 297,361 69.01% 2,111,000 929,371 1,181,629 44.03% 1,323,500 1,062,039 261,461 80.24% Operating income(loss) 778,150 1,135,482 (357,332) 145.92% (266,550) 338,421 (604,971) -126.96% 11,100 20,657 (9,557) 186.10% Nonoperating revenues(expenses): Interest income 25,250 11,588 13,662 45.89% 48,550 41,055 7,495 84,56% 5,000 4,643 357 92.86% Miscellaneous revenue - - - 0.00% - - - 0.00% - 17,902 (17,902) 0.00% Interest expense (29,250) (13,425) (15,825) 45.90% (31,050) (17,268) (13,782) 55.61% - - - 0.00% Total nonoperating revenues(expenses) (4,000) (1,837) (2,163) 45.93% 17,500 23,787 (6,287) 135.93% 5,000 22,545 (17,545) 450.90% Income(loss)before contributions and transfers 774,150 1,133,645 (359,495) 146.44% (249,050) 362,208 (611,258) -145.44% 16,100 43,202 (27,102) 268.34% Contributions-connection fees - - - 0.00% 111,400 255,379 (143,979) 229.25% - - - 0.00% Transfers in - - - 0.00% - - - 0.00% 37,000 - 37,000 0.00% Transfers out (394,350) (408,510) 14,160 103.59% (115,000) (115,000) - 100.00% (25,000) (25,000) - 100.00% NET INCOME(LOSS) 379,800 725,135 34( 5,335) 190.93% (252,650) 502,587 (755,237) -198.93% 28,100 18,202 9,898 64.78% Items reclassified to balance sheet at year end: Capital Outlay (55,000) (43,875) (11,125) 79.77% (1,041,500) (133,374) (908,126) 12.81% Bond Payment (730,000) (730,000) - 100.00% (170,000) (170,000) - 100.00% Revenues over/(under)expenditures (405,200) (48,740) (356,460) (1,464,150) 199,213 (1,663,363) 28,100 18,202 9,898 *Recorded at year end 12-12-2012 01:11 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2012 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 40,666.36 29.57 40,695.93 101-1010 Cash - General Fund 4,210,689.91 ( 791,384.03) 3,419,305.88 211-1010 Cash - Library 432,638.00 ( 3,826.04) 428,811.96 221-1010 Cash - Ice Arena 2,885.22 ( , 16,668.51) ( 13,783.29) 222-1010 Cash - Pinewood Golf Course ( 7,286.06) ( 15,346.72) ( 22,632.78) 223-1010 Cash - Sr Citizen Account 13,121.61 ( 456.97) 12,664.64 225-1010 Cash - Park Dedication 5,229.40 0.00 5,229.40 228-1010 Cash - Landfill 799,673.38 ( 15,371.92) 784,301.46 231-1010 Cash - Landfill Const Debris 702,023.74 0.00 702,023.74 240-1010 Cash - Micro Loan Fund 1,332,969.37 ( 8,697.11) 1,324,272.26 241-1010 Cash - DTED Loan 705,283.57 0.00 705,283.57 245-1010 Cash - Development Fund 623,448.92 0.00 623,448.92 290-1010 Cash - Capital Outlay Reserve 1,365,955.74 ( 21,265.44) 1,344,690.30 291-1010 Cash - Insurance Reserve 316,128.40 ( 81,409.77) 234,718.63 292-1010 Cash - Govt Bldgs Reserve 6,587,687.52 ( 673,591.18) 5,914,096.34 294-1010 Cash - Drug Forfeiture 21,462.44 1,887.25 23,349.69 295-1010 Cash - Severance Pay Reserve 146,098.25 0.00 146,098.25 296-1010 Cash - GRE Reserve 1,489,423.78 ( 99,668.89) 1,389,754.89 311-1010 Cash - 2003A GO Bonds 43,243.08 1,000.00 44,243.08 312-1010 Cash - 2005A GO Bonds 170,009.78 0.00 170,009.78 313-1010 Cash - 2007C GO Bonds 237,139.11 0.00 237,139.11 333-1010 Cash - 2010A GO Cap Imp Bonds 509,958.24 ( 8,000.00) 501,958.24 345-1010 Cash - 2012A CIP Bonds-PW 128,887.94 0.00 128,887.94 403-1010 Cash - Street Improvement 4,381,460.79 ( 103,260.05) 4,278,200.74 404-1010 Cash - Surface Water Managemnt 169,197.98 ( 4,830.19) 164,367.79 406-1010 Cash - City Wide Trunk Util 4,329,597.28 16,546.66 4,346,143.94 410-1010 Cash - Equipment Replacement 740,946.17 76,254.39 817,200.56 426-1010 Cash - YMCA 869,070.28 0.00 869,070.28 440-1010 Cash - Park Improvement 129,620.58 ( 5,850.55) 123,770.03 456-1010 Cash - TIF #16 King/Main 4,976.28 0.00 4,976.28 459-1010 Cash - TIF #19 Highway 169 100,192.22 0.00 100,192.22 602-1010 Cash - Wastewater Treatment 5,215,508.19 69,783.90 5,285,292.09 603-1010 Cash - Liquor 1,307,958.93 48,987.91 1,356,946.84 605-1010 Cash - Garbage 585,247.59 545.19 585,792.78 801-1010 Cash - Interest 0.00 16,128.87 16,128.87 821-1010 Cash - Developer Escrow 67,987.40 ( 15,151.00) 52,836.40 TOTAL CLAIM ON CASH 37,779,101.39 ( 1,633,614.63) 36,145,486.76 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 38,220,709.61 ( 843,201.91) 37,377,507.70 999-1001 PY BANK ACCOUNT (28,823,797.78) ( 790,412.72) (29,614,210.50) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 37,779,101.39 ( 1,633,614.63) 36,145,486.76