Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 04-16-2012
INFORMATION V~~` MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: April 16, 2012 SUBJECT: March 2012 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Arena and Pinewood Golf special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of March, actual revenues (except fox property taxes and state aids) and expenditures should run 25% 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 fox the variance. General Fund revenues: • Property taxes, our largest revenue source, will be received in July and December. • The majority of building permit revenue collected this month is for the public works facility project. • Charges for services are 34% of budget estimate. March collections consist mainly of plan check fees related to the public works facility and spring/summer recreation fees. • Court fines received in March were for January and February fine collections. • The transfer in from Utilities is for January and February, the transfers in from other city departments will be recorded mid-year. E.>cj~enditures: • Excluding transfers, the total departmental expenditures are 20.5% and most departments axe well within or below budget. The second quarter insurance premiums fox liability and workers comp were paid in March, as reflected in many departments' expenditures. The transfer out to Pinewood Golf will be made at the end of the year when all revenues and expenditures are finalized. Ice Arena For the month of March, revenues exceeded expenditures by $121,209. Revenues are over 38% of budget due mainly to ice rental, hockey recreation fees and concessions while expenditures are slightly over 25% of budget. Pinewood Golf As a result of the unseasonably warm weather we have been experiencing, Pinewood opened for the golf season in mid-March. Year to date expenditures exceed revenues by $6,682. Excluding transfers in, total revenue collections are over 10% of budget and membership fees are 59% of estimates. Expenditures are about 12% of budget, which includes liability and workers comp insurance paid through June 30. 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) 1 N F O R MAT 1 O N AS OF: ILL'-'RCH 31ST, '_Ol^ ' _C1-GENEPc'-.L Fr?ND FINANCIAL SUI~ARY 25.00$ OF YF.TS.R COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY General Fund ~ TOTAL REVENUES ^ EXPENDITURE SUMM.T~RY ' General Government Mayor & Council Cable TV Administrative Services Human Resources Elections Finance Information Technology Legal Community Development Planning City Hall Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fire Administration Fire Inspections Emergency Management Building Safety Environmental TOTAL Public Safety Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works 12,311,900.00 248,933.77 621,105.95 5.G4 11,690,794.05 12,311,900.00 248,933.77 621,105.95 5.04 11,690,794.05 172,250.00 20,864.62 48,265.82 28.02 123,984.18 86,600.00 8,571.19 18,376.76 21.22 68,223.24 482,950.00 48,867.79 111,848.88 23.16 371,101.12 164,500.00 20,134.91 42,416.37 25.79 122,083.63 38,050.00 0.00 0.00 0.00 38,050.00 464,450.00 90,680.06 99,925.61 21.51 364,524.39 242,000.00 27,327.97 61,844.07 25.56 180,155.93 228,000.00 18,791.50 36,676.50 16.09 191,323.50 69,250.00 7,397.21 15,926.77 23.00 53,323.23 304,700.00 31,673.27 70,126.12 23.01 234,573.88 304,150.00 24,612.35 63,315.32 20.82 240,834.68 217,550.00 0.00 0.00 0.00 217,550.00 2,774,450.00 248,920.87 568,722.22 20.50 2,205,727.78 565,500.00 65,470.98 167,824.53 29.68 397,675.47 2,350,050.00 221,781.44 980,060.16 20.43 1,869,989.84 764,750.00 72,881.25 159,109.63 20.81 605,640.37 503,500.00 46,853.69 104,581.95 20.77 398,918.05 18,900.00 151.64 2,268.74 12.00 16,631.26 210,150.00 18,751.27 44,155.71 21.01 165,994.29 555,500.00 53,127.81 111,276.90 20.03 444,223.60 188,000.00 19,089.07 41,738.95 22.20 146,261.05 103,900.00 2,302.37 3,880.56 3.73 100,019.94 473,350.00 50,491.35 109,348.63 23.10 364,001.37 48,850.00 4,750.53 10,540.23 21.58 38,309.77 5,782,450.00 555,651.35 1,239,785.49 21.35 4,547,669.51 1,505,300.00 118,684.89 246,041.24 16.34 1,259,258.76 288,400.00 30,823.79 96,232.86 33.37 192,167.14 247,900.00 22,703.52 49,755.29 20.07 198,144.71 133,550.00 12,597.42 27,000.21 20.22 106,549.79 2,175,150.00 184,809.62 419,029.60 19.26 1,756,120.40 ~ 4-11-2012 08:59 AM I 101-GENERAL EUND FINANCIAL SU_Mi 1ARY CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, ^012 25.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OE 3UDGET BUDGET PERIOD ACTUAL 3UDGET BALANCE Culture 5 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 74,058.47 158,810.90 19.51 654,989.10 603,25C.00 60,384.74 132,414.67 21.95 470,835.33 197,000.00 5,093.56 14,041.92 7.13 182,958.08 14,100.00 ( 482.60) 16.35 0.12 14,083.65 226,500.00 20,050.28 44,326.03 19.57 182,173.97 1,854,650.00 159,104.45 349,609.87 18.85 1,505,040.13 0.00 ( 7,661.54) 19,522.37 0.00 ( 19,522.37) 50,850.00 4,109.30 8,633.53 16.98 42,216.47 50,850.00 ( 3,552.24) 28,155.90 55.37 22,694.10 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 1,144,934.05 2,600,303.08 20.51 10,077,746.92 ( 366,150.00)( 896,000.28)( 1,979,197.13) 1,613,047.13 4-11-2012 08:59.AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) P_S OF: N~RCH 31ST, 2012 101-GENERz1L FUND REVENUES 25.00°s OF yE,AR COND. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax TOTAL Taxes Licenses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 Amusement License. 101-3-0000-3213 Cigarette License 101-3-0000-3214 Apartment License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3235 Animal License 101-3-0000-3236 Parking Permit 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Licenses & Permits 9,142,200.00 569.36 569.36 0.01 9,141,630.64 70,000.00 0.00 0.00 0.00 70,000.00 9,212,200.00 569.36 569.36 0.01 9,211,630.64 53,000.00 40.00 2,205.00 4.16 50,795.00 1,000.00 0.00 0.00 0.00 1,000.00 3,000.00 112.50 112.50 3.75 2,887.50 17,000.00 6,135.00 12,375.00 72.79 4,625.00 20,000.00 0.00 0.00 0.00 20,000.00 2,100.00 0.00 555.00 26.43 1,545.00 17,000.00 420.00 5,305.00 31.21 11,695.00 2,500.00 175.00 1,050.00 42.00 1,450.00 153,000.00 33,027.65 47,944.60 31.34 105,055.40 129,150.00 3,915.15 9,858.41 7.63 119,291.59 400.00 1,320.54 2,076.72 519.18 ( 1,676.72) 3,500.00 372.00 1,260.50 36.01 2,239.50 3,000.00 18.57 221.49 7.38 2,778.51 8,000.00 1,370.00 1,690.00 21.13 6,310.00 912,650.00 96,906.91 84,654.22 20.51 327,995.78 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 20 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 18,589.73 18,589.73 61.97 11,410.27 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 18,589.73 159,580.75 29.42 382,869.25 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 15,000.00 950.00 2,750.00 18.33 12,250.00 101-3-0000-3413 Plan Check Fee 41,000.00 19,648.69 26,174.30 63.84 14,825.70 101-3-0000-3415 Special Assessment Search 1,000.00 20.00 100.00 10.00 900.00 101-3-0000-3417 Copies 2,500.00 368.99 682.78 27.31 1,817.22 101-3-0000-3418 Other General Govt Services 4,000.00 400.00 666.25 16.66 3,333.75 101-3-0000-3430 Lockout Fees 7,500.00 610.00 1,870.00 29.93 5,630.00 101-3-0000-3431 Police Services 2,000.00 100.00 100.00 5.00 1,900.00 101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 200.00 800.00 26.67 2,200.00 101-3-0000-3936 Fire Contracts 199,600.00 0.00 87,907.52 44.04 111,692.98 101-3-0000-3437 Fire Calls 4,000.00 ( 675.00)( 675.00) 16.88- 4,675.00 101-3-0000-3451 Street Services 35,000.00 1,140.00 1,240.00 3.54 33,760.00 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NiLG2CH 31ST, 001' ~ _~_-~.E?dE n. __ _UND F~~:JEIv l7ES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 25.00 OF YEAR COMP. °s OF BUDGET BUDGET BALANCE 101-3-0000-3452 Engineering Services Reimb 1C1-3-0000-3461 Recreation Fees 101-3-0000-3467 Concessions 1G1-3-000G-3472 Park Use Fee 1C1-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services Fines & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 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-3992 Transfer-WWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3944 Transfer-Garbage 101-3-0000-3945 Transfer-Utilities 101-3-0000-3998 Transfer-E DA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 12,311,900.00 248,933.77 621,105.95 5.04 11,690,794.05 ^ TOTAL REVENUE 89,150.00 0.00 0.00 0.00 89,'_50.00 129,000.00 24,815.86 55,604.38 43.1C 73,395.62- 14,100.00 0.00 0.00 0.00 14,100.00 17,000.00 0.00 374.27 2.20 16,625.73 5,700.00 1,905.73 5,999.77 105.26 ( 299.77) 2,400.00 200.00 600.00 25.OC 1,800.00 3,000.00 390.00 845.00 28.17 2,155.00 400.00 15.00 60.00 15.00 34C.00 650,350.00 50,089.22 222,599.27 34.23 427,750.73 120,000.00 17,704.72 17,704.72 14.75 102,295.28 12,000.00 1,380.00 7,762.25 64.69 4,237.75 500.00 0.00 0.00 0.00 500.00 132,500.00 19,084.72 25,466.97 19.22 107,033.03 100,000.00 0.00 ( 2,864.90) 2.86- 102,864.90 66,500.00 724.34 684.35 1.03 65,815.65 25,650.00 421.00 16,804.00 65.51 8,846.00 8,000.00 553.53 1,616.47 20.21 6,383.53 200,150.00 1,698.87 16,239.92 8.11 183,910.08 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 111,995.46 111,995.46 22.40 388,009.54 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 111,995.46 111,995.46 9.64 1,049,604.54 12,311,900.00 248,933.77 621,105.95 5.04 11,690,794.05 ^ 4-11-2012 08:59 AM ^ DE ~z',RT?/ENTAL EXPENDITURES ^ Mayor & Council CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: _T~iAC2CH 31ST, ^012 25.00% OF YEPR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ~CTUP-L BUDGET BALANCE Personal Services "~C1-4-1110-4103 Part-time Pay 101-4-1110-4104 PERA 101-4-1110-4105 FICA 101-4-1110-4107 Medicare 101-4-1110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1110-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,207.99 9,623.97 25.00 28,876.03 1,900.00 0.00 203.34 10.70 1,696.66 2,400.00 0.00 222.12 9.26 2,177.88 550.00 0.00 93.02 16.91 456.98 50.00 16.25 32.50 65.00 17.50 43,400.00 3,224.24 10,174.95 23.44 33,225.05 3,200.00 75.88 75.88 2.37 3,124.12 3,200.00 75.88 75.88 2.37 3,124.12 11,050.00 2,106.89 3,976.84 35.99 7,073.16 400.00 74.99 74.99 18.75 325.01 2,600.00 0.00 0.00 0.00 2,600.00 17,700.00 0.00 3,382.22 19.11 14,317.78 69,450.00 12,700.75 25,401.50 36.58 44,048.50 16,000.00 0.00 0.00 0.00 16,000.00 8,950.00 2,681.92 5,179.44 61.30 3,270.56 125,650.00 17,564.50 38,014.99 30.25 87,635.01 ' TOTAL Mayor & Council Cable TV Personal Services 101-9-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 172,250.00 20,864.62 48,265.82 28.02 123,984.18 57,450.00 6,501.60 13,003.20 22.63 49,946.80 6,500.00 586.51 1,039.14 15.99 5,960.86 4,150.00 314.24 939.65 22.64 3,210.35 3,950.00 267.36 789.87 20.00 3,160.13 950.00 62.53 184.73 19.45 765.27 8,700.00 680.00 2,040.00 23.45 6,660.00 250.00 64.25 128.50 51.40 121.50 81,950.00 8,476.49 18,125.09 22.12 63,824.91 1,700.00 94.70 251.67 14.80 1,448.33 1,700.00 94.70 251.67 14.80 1,448.33 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS O1': N'--RCN 31S'", 2012 ' Cl-GENEn~_L FUND General Government ' ~~EPFATN.BNTP.L EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEFS2 TO DP_TE $ OF 3IIDGET BIIDGET PERIOD ACTUAL BUDGET &T~LANCF Other Services & Charges 1C1-4-1120-4322 Postage 50.C0 101-4-1120-4331 Travel, Conferences & Schools 1,25G.00 101-4-1120-4404 Equia Repair/Maim Services 1,650.00 TOTAL Other Services & Charaes 2,950.00 Capital Outlay 0.00 0.00 0.00 50.00 0.00 0.00 0.0v 1,250.C0 0.00 0.00 0.00 1,650.00 0.00 0.00 G.00 2,950.00 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-9334 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 86,600.00 8,571.19 18,376.76 21.22 68,223.24 306,650.00 35,237.49 70,474.98 22.98 236,175.02 41,200.00 4,327.99 8,759.16 21.26 32,440.84 25,200.00 1,913.95 5,784.53 22.95 19,415.47 21,550.00 1,633.97 4,937.73 22.91 16,612.27 5,050.00 382.13 1,154.77 22.87 3,895.23 26,650.00 2,738.21 7,380.54 27.69 19,269.46 2,100.00 467.50 935.00 44.52 1,165.00 428,400.00 96,701.24 99,426.71 23.21 328,973.29 9,500.00 317.12 848.41 8.93 8,651.59 9,500.00 317.12 848.41 8.93 8,651.59 5,500.00 0.00 5,508.00 100.15 ( 8.00) 800.00 0.61 8.96 1.12 791.04 1,000.00 127.53 127.53 12.75 872.47 7,300.00 12.52 550.53 7.54 6,799.47 4,800.00 553.86 1,292.34 26.92 3,507.66 300.00 45.50 91.00 30.33 209.00 23,550.00 1,109.41 3,745.40 15.90 19,804.60 1,800.00 0.00 250.00 13.89 1,550.00 45,050.00 1,849.43 11,573.76 25.69 33,476.24 TOTAL Administrative Services 482,950.00 48,867.79 111,848.88 23.16 371,101.12 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OE: 1~!rRCH 31ST, 2012 I Zvi-CANE R:-_L EIIND General Government ' DEPFRTMENTAL EXPENDITURES 25.00° OF YEF32 COMP. CURRENT CURRENT YEAR TO DATE % OF 3UDCET BUDGET PERIOD ACTUAL BUDGET BALFNCE ^ Human Resources Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-9-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 101-4-1220-4560 Equipment TOTAL Capital Outlay 69,20C.00 7,985.43 15,970.86 23.08 53,229.14 49,300.00 5,784.84 12,540.86 25.44 36,759.14 8,600.00 665.56 2,C83.53 24.23 6,516.47 7,350.00 557.50 1,714.08 23.32 5,635.92 1,700.00 130.38 900.85 23.58 1,299.15 10,750.00 949.00 3,277.00 30.48 7,473.00 700.00 164.50 329.00 47.00 371.00 147,600.00 16,237.21 36,316.18 24.60 111,283.82 4,300.00 64.27 2,051.54 47.71 2,248.46 4,300.00 64.27 2,051.54 47.71 2,248.46 3,000.00 0.00 0.00 0.00 3,000.00 550.00 442.31 442.31 80.42 107.69 2,350.00 58.80 141.42 6.02 2,208.58 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 99.35 231.95 23.20 768.05 7,900.00 600.46 815.68 10.33 7,084.32 4,700.00 3,232.97 3,232.97 68.79 1,467.03 4,700.00 3,232.97 3,232.97 68.79 1,467.03 TOTAL Human Resources Elections Personal Services 101-4-1230-9103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1230-4322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4404 Equip Repair/Maint Services 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges 164,500.00 20,134.91 92,416.37 25.79 122,083.63 30,000.00 0.00 30,000.00 0.00 4,650.00 4,650.00 0.00 0.00 600.00 700.00 1,000.00 100.00 1,000.00 3,400.00 0.00 0.00 30,000.00 0.00 0.00 30,000.00 0.00 0.00 4,650.00 0.00 0.00 4,650.00 0.00 0.00 0.00 600.00 0.00 0.00 0.00 700.00 0.00 0.00 0.00 1,000.00 0.00 0.00 0.00 100.00 0.00 0.00 0.00 1,000.00 0.00 0.00 0.00 3,400.00 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: M~.RCH 31ST, 2012 Genera' Government ' DEPARTMENTAL EXPENDITURES ' Capital Cutlay CURRENT CURRENT BUDGET PERIOD 25.00=s OF Y~~R COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE I TOT''-`.L Elections Finance 38,050.00 0.00 0.00 0.00 38,050.00 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-9331 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 I 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 293,600.00 33,872.92 21,300.00 1,637.16 18,200.00 1,334.16 4,250.00 312.04 26,650.00 2,187.01 1,800.00 407.75 365,800.00 39,751.04 5,350.00 65.94 5,350.00 65.94 18,300.00 0.00 50,000.00 0.00 400.00 1.34 2,600.00 616.03 2,350.00 0.62 950.00 0.00 12,200.00 0.00 1,500.00 225.00 5,000.00 20.09 93,300.00 863.08 67,745.83 23.07 225,854.17 4,895.45 22.98 16,404.55 3,988.77 21.92 14,211.23 932.90 21.95 3,317.10 6,561.03 24.62 20,088.97 815.50 45.31 984.50 84,939.48 23.22 280,860.52 613.18 11.46 4,736.82 613.18 11.46 4,736.82 1,800.00 9.84 16,500.00 0.00 0.00 50,000.00 5.76 1.44 394.24 616.03 23.69 1,983.97 394.62 16.79 1,955.38 0.00 0.00 950.00 10,861.45 89.03 1,338.55 675.00 45.00 825.00 20.09 0.40 4,979.91 14,372.95 15.41 78,927.05 464,450.00 40,680.06 99,925.61 21.51 364,524.39 130,950.00 15,353.89 5,000.00 0.00 9,500.00 742.10 8,450.00 583.65 2,000.00 136.50 20,450.00 1,706.00 800.00 189.00 177,150.00 18,711.14 30,707.78 23.45 100,242.22 0.00 0.00 5,000.00 2,213.24 23.30 7,286.76 1,730.95 20.48 6,719.05 404.82 20.24 1,595.18 5,118.00 25.03 15,332.00 378.00 47.25 422.00 90,552.79 22.89 136,597.21 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS CF: MARC3 31ST, 20!2 I 101-GENEi~ L FUND General Government I DEPP.RTMENT?',L EXPENDITURES 25.OOo OF Y'ET-~2 COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Suapiies 1G1-4-1350-4219 Operating Supplies 15,600.00 1,904.98 2,642.60 16.94 12,957.40 TOTAL Suppli es 15,600.00 1,904.98 2,642.60 16.94 12,957.40 Cther Services & Charges 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 139.45 511.91 35.30 938.09 101-4-1350-4331 Travel, Conferences & Schools 8,000.00 0.00 0.00 0.00 8,000.00 101-4-1350-4904 Equip Repair/Maint Services 20,900.00 6,572.90 7,236.77 34.63 13,663.23 TOTAL Other Services & Charges 38,350.00 6,711.85 7,748.68 20.21 30,601.32 Capital Outlay 101-4-1350-4560 Equipment 10,900.00 0.00 10,900.00 100.00 0.00 TOTAL Capita l Outlay 10,900.00 0.00 10,900.00 100.00 0.00 TOTAL Information Technology Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 242,000.00 27,327.97 61,844.07 25.56 180,155.93 228,000.00 18,791.50 36,676.50 16.09 191,323.50 228,000.00 18,791.50 36,676.50 16.09 191,323.50 TOTAL Legal Community Development 228,000.00 18,791.50 36,676.50 16.09 191,323.50 Personal Services 101-4-1500-4101 Regular Pay 53,750.00 6,201.60 12,403.20 23.08 41,346.80 101-4-1500-4104 PERA 3,900.00 299.74 896.26 22.98 3,003.74 101-4-1500-4105 FICA 3,350.00 243.24 727.19 21.71 2,622.81 101-4-1500-9107 Medicare 800.00 56.88 170.05 21.26 629.95 101-4-1500-4108 Insurance 6,000.00 521.00 1,563.00 26.05 4,437.00 101-4-1500-4109 Workers Comp 900.00 74.75 149.50 16.61 750.50 TOTAL Personal Services 68,700.00 7,397.21 15,909.20 23.16 52,790.80 4-11-2012 08:59 AM 101-GEIQE_~_~ F?'ND Genera_ Ucvernmert ~~EPARTM.:,NTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NTLRCE 31ST, 201? PAGE: 10 25.OCo OF YEAR COD'P. CURRENT CURRENT TEAR TO DATE `s OF BUDGET BUDGET PERIOD ACTUAL B:7DGET BALFIQCE Supplies 101-4-1500-4201 Office Supplies 150.00 0.00 17.57 ll.71 132.43 TCTAL 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 7,397.21 15,926.77 23.00 53,323.23 Planning Personal Services 101-4-1510-4101 Regular Pay 216,150.00 24,940.11 49,880.22 23.08 166,269.78 101-4-1510-4104 PERA 15,700.00 1,205.44 3,604.54 22.96 12,095.46 101-4-1510-4105 FICA 13,400.00 950.12 2,840.28 21.20 10,559.72 101-4-1510-9107 Medicare 3,150.00 222.20 664.24 21.09 2,485.76 101-4-1510-4108 Insurance 29,150.00 2,442.00 7,326.00 25.13 21,824.00 101-4-1510-4109 Workers Comp 1,300.00 229.25 458.50 35.27 841.50 TOTAL Personal Services 278,850.00 29,989.12 64,773.78 23.23 214,076.22 Supplies 101-4-1510-4201 Office Supplies 4,250.00 96.40 440.47 10.36 3,809.53 101-4-1510-4212 Fuels & Lubs 1,600.00 274.12 274.12 17.13 1,325.88 101-4-1510-4219 Operating Supplies 200.00 ( 80.16) 316.58 158.29 ( 116.58) TOTAL Supplies 6,050.00 290.36 1,031.17 17.04 5,018.83 Other Services & Charges 101-4-1510-4321 Telephone 800.00 39.02 107.56 13.45 692.44 101-4-1510-4322 Postage 3,200.00 240.85 240.85 7.53 2,959.15 101-4-1510-4331 Travel, Conferences & Schools 1,650.00 118.00 608.00 36.85 1,042.00 101-4-1510-4359 Publishing 8,000.00 525.00 757.50 9.47 7,242.50 101-4-1510-4361 Insurance 450.00 74.50 149.00 33.11 301.00 101-4-1510-4404 Equip Repair/Maint Services 3,600.00 329.76 2,178.28 60.51 1,421.72 101-4-1510-4433 Dues & Subscriptions 1,050.00 0.00 80.00 7.62 970.00 101-4-1510-4940 Miscellaneous 250.00 0.00 0.00 0.00 250.00 101-4-1510-4460 Equip Replacement Charge 800.00 66.66 199.98 25.00 600.02 TOTAL Other Services & Charges 19,800.00 1,393.79 4,321.17 21.82 15,478.83 Capital Outlay ' TOTAL Planning 304,700.00 31,673.27 70,126.12 23.01 234,573.88 4-11-2012 08:59 AM 101-GENERAL FUND General Government ~ DEPARTMENTP,I, ENPENDITURES City Hall Maintenance CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: M^^>RCH 31ST, 201' 25.00% OF YF~r.R CO!"P. CURRENT CURRENT YEAR TO ~'~~_P a OF 3UDGET BUDGET PERIOD ACTIIPi~ 3UDGET 3ALANCE 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 1G1-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-4904 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 108,SOC.00 12,193.88 24,565.26 22.64 83,934.74 2,500.00 78.09 273.32 10.93 2,226.68 20,800.00 1,968.67 3,986.15 19.16 16,813.85 9,550.00 682.33 2,077.09 21.75 7,472.91 8,200.00 587.45 1,796.17 21.90 6,403.83 1,900.00 137.40 420.07 22.11 1,479.93 17,700.00 1,275.42 3,836.26 21.67 13,863.74 5,550.00 1,276.50 2,553.00 46.00 2,997.00 174,700.00 18,199.74 39,507.32 22.61 135,192.68 4,650.00 485.26 485.26 10.44 4,164.74 1,700.00 0.00 417.35 24.55 1,282.65 29,400.00 412.63 4,946.39 16.82 24,453.61 35,750.00 897.89 5,899.00 16.36 29,901.00 13,950.00 968.86 2,664.37 19.10 11,285.63 1,500.00 106.16 361.16 24.08 1,138.84 5,100.00 1,047.25 2,094.50 41.07 3,005.50 36,700.00 3,128.18 6,238.09 17.00 30,461.91 31,150.00 30.94 5,900.89 18.94 25,249.11 2,500.00 0.00 0.00 0.00 2,500.00 2,800.00 233.33 699.99 25.00 2,100.01 93,700.00 5,514.72 17,959.00 19.17 75,741.00 304,150.00 24,612.35 63,315.32 20.82 240,834.68 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 248,920.87 568,722.22 20.50 2,205,727.78 4-11-2012 08:59 AM REVENUE 101-GENE Fu=L FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, "012 CURRENT CURRENT BUDGET PERIOD "EAR TO DP_TE ACTUAL 5.00 °s PE BUDGET PAGE: 12 F YE~Ti COMP. BUDGET BAL'-,NCE Police Administration Personal Services 101-4-2110-4101 Regular Pay 280,900.00 32,4C9.12 64,818.24 23.08 216,081.76 101-4-2110-4104 PERA 40,450.00 3,111.30 9,303.39 23.00 31,146.61 101-4-2110-4107 Medicare 2,550.00 194.26 580.85 22.78 1,969.15 101-4-2110-4108 Insurance 23,700.00 1,900.00 5,700.00 24.05 18,000.00 101-4-2110-4109 Workers Comp 64,850.00 14,593.50 29,187.00 45.01 35,663.00 TOTAL Personal Services 412,450.00 52,208.18 109,589.48 26.57 302,860.52 Supplies 101-4-2110-4201 Office Supplies 14,000.00 261.46 863.97 6.17 13,136.03 101-4-2110-4217 Uniform Allowance 2,300.00 92.82 2,187.82 95.12 112.18 101-4-2110-4219 Operating Supplies 4,600.00 163.89 1,254.19 27.27 3,345.81 TOTAL Supplies 20,900.00 518.17 4,305.98 20.60 16,594.02 Other Services & Charges 101-4-2110-4319 Other Professional Services 3,400.00 568.06 661.42 19.45 2,738.58 101-4-2110-4321 Telephone 29,300.00 1,248.67 3,045.98 10.40 26,259.02 101-4-2110-4322 Postage 2,600.00 847.44 847.44 32.59 1,752.56 101-4-2110-4331 Travel, Conferences & Schools 3,350.00 0.00 1,230.00 36.72 2,120.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 7,550.00 2,153.00 4,306.00 57.03 3,249.00 101-4-2110-4404 Equip Repair/Maint Services 80,400.00 7,117.46 42,123.98 52.39 38,276.02 101-4-2110-4433 Dues & Subscriptions 4,250.00 810.00 1,574.00 37.04 2,676.00 101-4-2110-4937 Taxes & Licenses 800.00 0.00 140.25 17.53 659.75 TOTAL Other Services & Charges 132,150.00 12,744.63 53,929.07 40.81 78,220.93 Capital Outlay TOTAL Police Administration 565,500.00 65,470.98 167,824.53 29.68 397,675.47 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,479,700.00 156,280.70 313,251.78 21.17 1,166,448.22 101-4-2120-4102 Overtime Pay 90,000.00 9,518.19 15,106.11 16.78 74,893.89 101-4-2120-4104 PERA 226,050.00 15,809.00 47,124.88 20.85 178,925.12 101-4-2120-4107 Medicare 20,400.00 1,313.10 3,896.03 19.10 16,503.97 101-4-2120-4108 Insurance 179,350.00 14,080.00 42,483.54 23.69 136,866.46 TOTAL Personal Services 1,995,500.00 197,000.99 421,862.34 21.14 1,573,637.66 4-11-2012 08:59 AM ' _L',_-GENEi~L FrtPrr~ Public Sa-ety ^ CErAR~TMENTP.L EXPENDITURES CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) P.S OF: MARCH 31ST, 2012 25.OCa OP YEAR COMP. CliRRENT CURRENT YEAR TO DATE o OF BUDGET BIIDGET PERIOD ACTUAL BUDGET BALANCE Sunolies 101-4-2120-4212 Fuels & Lubs 101-4-212G-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TCT~I, Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-4404 Equip Repair/Maint Services iC1-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges ' Capital Outlay 143,000.00 12,246.07 12,587.99 8.80 130,412.01 22,850.00 0.00 13,222.50 57.87 9,627.50 63,750.00 397.32 6,930.69 10.87 56,819.31 28,000.00 207.60 1,063.83 3.80 26,936.17 257,600.00 12,850.99 33,805.01 13.12 223,794.99 25,150.00 735.00 4,555.00 18.11 20,595.00 26,700.00 7,481.96 8,660.31 32.44 18,039.69 550.00 0.00 40.00 7.27 510.00 44,550.00 3,712.50 11,137.50 25.00 33,412.50 96,950.00 11,929.46 24,392.81 25.16 72,557.19 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 Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4-2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,350,050.00 221,781.44 480,060.16 20.43 1,869,989.84 514,100.00 55,968.81 111,965.66 21.78 402,134.34 45,000.00 2,744.62 3,757.74 8.35 91,242.26 80,500.00 5,739.76 16,551.72 20.56 63,948.28 6,900.00 435.85 1,255.74 18.20 5,644.26 69,100.00 5,721.57 16,977.17 24.57 52,122.83 715,600.00 70,605.61 150,508.03 21.03 565,091.97 5,350.00 382.50 3,607.50 67.43 1,742.50 12,900.00 ( 9.52)( 9.52) 0.07- 12,909.52 18,250.00 372.98 3,597.98 19.71 14,652.02 5,950.00 335.99 508.61 9.33 4,941.39 13,250.00 600.00 1,595.00 12.04 11,655.00 600.00 0.00 0.00 0.00 600.00 11,600.00 966.67 2,900.01 25.00 8,699.99 30,900.00 1,902.66 5,003.62 16.19 25,896.38 TOTAL Investigations 764,750.00 72,881.25 159,109.63 20.81 605,640.37 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) As oF: rz~RCx 31sT, ^o1z 10"_-GENERAL FUND u~lic Satety ' DE°ART74ENTAL EXPENDITURES CURRENT CliRRENT YE_^-.R TO DATE BUDGET PERIOD ACTUFZ 25.00°s OF YET~R COMP. °s OF BUDGET BUDGET BALANCE Police Support Services Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-9104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTALPersonal 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-9409 Contractual Services 101-4-2150-9433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 342,350.00 37,795.23 75,590.45 22.08 266,759.55 3,500.00 49.86 443.17 12.66 3,056.83 25,100.00 1,830.37 5,474.80 21.81 19,625.20 21,450.00 1,515.38 4,532.90 21.13 16,917.10 5,000.00 354.38 1,060.06 21.20 3,939.94 59,300.00 4,159.01 12,380.72 20.88 46,919.28 456,700.00 45,704.23 99,482.10 21.78 357,217.90 1,000.00 52.35 176.96 17.70 823.04 3,000.00 0.00 101.63 3.39 2,898.37 14,900.00 407.65 1,598.81 10.73 13,301.19 18,900.00 460.00 1,877.40 9.93 17,022.60 3,350.00 50.00 149.93 9.48 3,200.07 1,850.00 0.00 0.00 0.00 1,850.00 16,000.00 122.74 1,272.51 7.95 14,727.49 500.00 0.00 250.00 50.00 250.00 6,200.00 516.67 1,550.01 25.00 9,649.99 27,900.00 689.41 3,222.45 11.55 24,677.55 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 503,500.00 46,853.69 104,581.95 20.77 398,918.05 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 122.03 1,074.13 30.69 2,425.87 5,000.00 29.61 69.61 1.39 4,930.39 8,500.00 151.64 1,143.74 13.46 7,356.26 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) pS OF: MF--RCH ?~ GT, "0''' LGl-GENE&AL FUND Public Safety ' DEP.~,RTNIENTAL EXPENDITURES 25.00° OF YEAR COMP. CURRENT CURRENT FEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BAI~~NCE Other Services & Charoes ~~C1-4-2160-4319 Other Professional Services 1G1-4-2160-4321 Telephone 101-4-216u^-4331 Travel, Conferences & Schools 101-4-2160-4359 Publishing 101-4-2160-4433 Dues & Subscriptions TOT.TiL 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 Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions ,,soo.co G.cG "_,1zs.oo 7s.G0 37s.Go 100.G0 O.OC C.00 0.00 100.00 1,700.00 O.OG 0.00 O.CO 1,700.00 i50.C0 0.00 0.00 0.00 150.00 1,000.00 0.00 0.00 0.00 1,000.00 4,450.00 0.00 1,125.00 25.28 3,325.00 18,900.00 151.64 2,268.74 12.00 16,631.26 104,700.00 11,200.68 22,617.23 21.60 82,082.77 7,600.00 532.41 1,641.14 21.59 5,958.86 6,500.00 443.44 1,376.99 21.18 5,123.01 1,500.00 103.72 322.06 21.47 1,177.94 13,700.00 1,184.98 3,552.15 25.93 10,147.85 4,550.00 1,094.25 2,088.50 45.90 2,461.50 138,550.00 14,509.48 31,598.07 22.81 106,951.93 15,000.00 161.85 3,987.35 26.58 11,012.65 15,000.00 161.88 3,987.35 26.58 11,012.65 5,550.00 1,191.50 2,383.00 42.94 3,167.00 19,450.00 2,263.16 4,092.74 21.09 15,357.26 31,600.00 625.25 2,099.55 6.63 29,505.45 56,600.00 4,079.91 8,570.29 15.14 48,029.71 210,150.00 18,751.27 44,155.71 21.01 165,994.29 91,000.00 10,790.73 21,592.41 23.73 69,407.59 182,250.00 15,445.84 27,955.13 15.34 154,294.87 13,750.00 1,055.44 3,135.25 22.80 10,614.75 12,250.00 207.05 1,420.35 11.59 10,829.65 30,000.00 ( 1,620.80)( 1,620.80) 5.40- 31,620.80 4-11-2012 08:59 AM ' 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DP_TE $ OF BliDGET BUDGET PERIOD ACTUAL BUDGET B_AI~~NCE 101-4-2310-4107 Medicare i01-4-2310-4108 Insurance iC1-4-2310-4109 Workers Comp TCTPT Personal Services 3,950.00 130.79 578.47 14.64 3,371.53 6,100.00 783.31 2,35E 40 38.55 3,748.60 23,650.00 7,635.75 15,271.50 69.57 8,378.50 362,950.00 34,428.11 70,683.71 19.47 292,266.29 Supplies 101-4-2310-4201 Office Supplies 4,250.00 363.37 676.33 15.91 3,573.67 101-4-2310-4212 Fuels & Lubs 6,950.00 1,064.93 1,079.77 15.54 5,870.23 101-4-2310-4217 Uniform Allowance 7,450.00 75.99 75.99 1.02 7,374.01 101-4-2310-4219 Operating Supplies 32,100.00 3,862.20 6,603.67 20.57 25,496.33 101-4-2310-4221 Equipment Parts 7,000.00 148.86 590.15 8.43 6,409.85 TOTAL Supplies 57,750.00 5,515.35 9,025.91 15.63 48,724.09 Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-9331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-4-2310-4389 Utilities 101-4-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges ' Capital Outlay 5,400.00 1,768.52 1,768.52 3,150.00 156.25 479.77 500.00 190.88 190.88 17,450.00 ( 3,255.93) 1,884.07 300.00 0.00 0.00 16,100.00 3,717.75 7,109.50 11,700.00 1,358.37 2,545.83 5,450.00 206.56 366.88 40,550.00 6,308.62 7,884.34 1,400.00 0.00 1,142.00 32,800.00 2,733.33 8,199.99 134,800.00 13,184.35 31,566.78 32.75 3,631.48 15.23 2,670.23 38.18 309.12 10.80 15,565.93 0.00 300.00 44.13 8,995.50 21.76 9,154.17 6.73 5,083.12 19.44 32,665.66 81.57 258.00 25.00 24,600.01 23.42 103,233.22 TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: N~RCN 31ST, 2012 555,500.00 53,127.81 111,276.40 20.03 444,223.60 132,350.00 15,252.33 30,509.66 23.05 101,845.34 15,200.00 1,168.60 3,494.33 22.99 11,705.67 3,350.00 274.32 798.49 23.84 2,551.51 1,900.00 148.38 938.80 23.09 1,461.20 15,300.00 1,240.11 3,720.33 24.32 11,579.67 168,100.00 18,083.74 38,956.61 23.17 129,143.39 2,250.00 0.00 0.00 0.00 2,250.00 2,600.00 190.18 190.18 7.31 2,409.82 1,400.00 0.00 0.00 0.00 1,400.00 5,150.00 452.27 627.52 12.18 4,522.48 11,400.00 692.45 817.70 7.17 10,582.30 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAJ2CH 31ST, 20 L? 101-GENERAL FUND Public Safety I DEPPRTMENTP_L EXPENDITURES 25.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s CF BUDGET BUDGET PERIOD ACTUAL BUDGET BP_LP.NCE Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4404 Equip Repair/Mainz Services 101-4-2320-4433 Dues & Subscriptions TOTP~ Other Services & Charges 3,350.00 157.88 420.58 12.55 2,929.42 2,250.00 100.00 100.00 4.44 2,150.00 1,550.00 0.00 484.06 31.23 1,065.94 1,350.00 105.00 960.00 71.11 390.00 8,500.00 362.88 1,964.64 23.11 6,535.36 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-9104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-4322 Postage 101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4389 Utilities 101-4-2330-9404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay TOTAL Emergency Management Building Safety 188,000.00 19,089.07 41,738.95 22.20 146,261.05 9,400.00 1,065.30 2,130.60 22.67 7,269.40 1,350.00 102.28 305.83 22.65 1,044.17 150.00 10.30 30.80 20.53 119.20 600.00 39.13 117.39 19.57 482.61 11,500.00 1,217.01 2,584.62 22.47 8,915.38 500.00 134.50 134.50 26.90 365.50 9,150.00 706.24 706.24 7.72 8,493.76 9,650.00 840.74 840.74 8.71 8,809.26 1,650.00 12.01 52.00 3.15 1,598.00 1,000.00 0.00 0.00 0.00 1,000.00 3,700.00 0.00 0.00 0.00 3,700.00 1,500.00 69.61 144.01 9.60 1,355.99 5,800.00 163.00 259.19 4.47 5,540.81 100.00 0.00 0.00 0.00 100.00 13,750.00 244.62 455.20 3.31 13,294.80 69,000.00 0.00 0.00 0.00 69,000.00 69,000.00 0.00 0.00 0.00 69,000.00 103,900.00 2,302.37 3,880.56 3.73 100,019.44 9-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: ~~zRCH 31ST, 20? =C1-GE!QE R'~L: FUND Public Safety ' DEP_ARTMENTP_L EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00$ OF YEAR COMP. YE.~R TO DATE % CF 3UDGET ACTUPZ BUDGET BALANCE ersonal Services 101-4-2410-4101 Regular Pay 101-4-2410-4103 Part-time Pty '_Oi-4-2410-4104 PER.a 101-4-2410-4105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 1G1-4-2410-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2410-4201 Office Supplies i01-4-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2410-4319 Other Professional Services 101-4-2410-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 325,750.00 37,587.36 75,174.72 23.08 250,575.28 26,450.C0 3,146.75 6,289.41 23.78 20,16C.59 25,550.00 1,958.84 5,873.33 22.99 19,676.67 21,850.00 1,583.75 4,748.50 21.73 17,101.50 5,100.00 370.38 1,110.51 21.77 3,989.49 41,400.00 3,213.01 9,639.03 23.28 31,760.97 1,650.00 382.25 764.50 46.33 885.50 497,750.00 48,242.34 103,600.00 23.14 344,150.00 4,300.00 375.04 618.20 14.38 3,681.80 3,200.00 538.44 558.58 17.46 2,641.42 900.00 353.62 353.62 39.29 546.38 1,550.00 7.03 100.66 6.49 1,449.34 9,950.00 1,274.13 1,631.06 16.39 8,318.94 0.00 88.47 88.47 0.00 ( 88.47) 1,250.00 94.20 197.61 15.81 1,052.39 400.00 72.71 72.71 18.18 327.29 1,550.00 70.51 255.51 16.48 1,294.49 650.00 147.50 295.00 45.38 355.00 7,700.00 226.49 2,148.27 27.90 5,551.73 800.00 0.00 235.00 29.38 565.00 3,300.00 275.00 825.00 25.00 2,475.00 15,650.00 974.88 4,117.57 26.31 11,532.43 TOTAL Building Safety Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-9109 Workers Comp TOTAL Personal Services 473,350.00 50,491.35 109,348.63 23.10 364,001.37 31,600.00 3,612.12 7,260.24 22.98 2,300.00 176.34 549.70 23.90 1,950.00 134.56 420.02 21.54 450.00 31.48 98.25 21.83 5,300.00 468.09 1,447.08 27.30 600.00 140.75 281.50 46.92 42,200.00 4,563.34 10,056.79 23.83 24,339.76 1,750.30 1,529.98 351.75 3,852.92 318.50 32,143.21 9-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) -S OF: I~LARCH 31ST, '_011 101-GSNERP.L FUND Public Safety ' DEPARTMENTP.L EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00% OF YEAR COMP. YEAR TO DATE °s Ot BUDGET ACT JF_L BUDGET BALANCE SuD~lieS 1G1-4-2440-4201 Office Supplies 1G1-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-9409 Contractual Services 101-4-2440-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Environmental 500.00 69.10 151.43 30.29 348.57 150.00 2.50 15.22 10.15 134.78 650.OC 71.60 166.65 25.64 483.35 550.00 2.13 8.33 1.51 541.67 800.00 113.46 113.46 14.18 686.54 500.00 0.00 155.00 31.00 345.00 100.00 0.00 0.00 0.00 100.00 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 115.59 316.79 5.28 5,683.21 48,850.00 4,750.53 10,540.23 21.58 38,309.77 I 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 Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-9-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-9361 Insurance 101-4-3120-4389 Utilities 5,782,450.00 555,651.35 1,234,785.49 21.35 4,547,664.51 386,700.00 41,323.80 81,364.85 21.04 305,335.15 0.00 ( 116.28) 0.00 0.00 0.00 116,600.00 5,949.24 12,223.93 10.48 104,376.07 32,200.00 1,915.89 6,505.77 20.20 25,694.23 31,200.00 1,608.90 5,567.34 17.84 25,632.66 7,300.00 376.29 1,302.09 17.84 5,997.91 64,700.00 5,229.31 14,297.09 22.10 50,902.91 27,600.00 6,191.25 12,382.50 44.86 15,217.50 666,300.00 62,478.40 133,643.57 20.06 532,656.43 4,200.00 731.11 867.30 20.65 3,332.70 87,250.00 3,482.50 4,623.82 5.30 82,626.18 110,750.00 3,136.56 32,681.63 29.51 78,068.37 35,850.00 243.96 497.32 1.39 35,352.68 238,050.00 7,599.13 38,670.07 16.24 199,379.93 250.00 212.33 212.33 84.93 37.67 7,450.00 498.23 1,116.31 14.98 6,333.69 200.00 36.63 49.21 24.61 150.79 2,500.00 75.00 300.00 12.00 2,200.00 500.00 0.00 0.00 0.00 500.00 18,750.00 3,844.00 7,688.00 41.00 11,062.00 36,000.00 3,770.34 7,250.70 20.14 28,749.30 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) Ac CF; n%rRCI' 31ST, 201'_ ' 101-GENERAL DUND Public Works ' DEPARTMENTPS. EY,PENDITURES CURRENT CURRENT -iE=R TO DATE BUDGET PERICD ACTIIAL 25.CC% CF Y"EAR COMP. OF BUDGET BUDGET BALANCE 101-4-3120-4401 Bldg Repair/Maim Services 4,SOC.00 1,413.43 1,413.43 31.41 3,086.57 101-4-3120-4404 Equip Repair/Maint Services S,OOC.00 437.00 437.00 8.74 4,563.00 101-4-3120-44C9 Contractual Services 419,000.00 30,141.53 30,141.53 7.19 388,858.47 101-4-3120-4415 Equipment Rental 5,500.00 96.19 192.38 3.50 5,307.62 101-4-3120-4417 Uniform Rental 4,700.00 108.51 286.95 6.11 4,413.05 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 416.00 83.20 84.00 101-4-3120-4460 Equip Replacement Charge 95,750.00 7,979.17 23,937.51 25.00 71,812.49 TOTAL Other Services & Charges 600,950.00 48,612.36 73,727.60 12.27 527,222.40 Capi*_al Outlay I 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 1,505,300.00 118,684.89 246,041.24 16.34 1,259,258.76 100,300.00 21,900.25 41,655.38 41.53 58,644.62 20,000.00 2,853.55 6,537.25 32.69 13,462.75 9,100.00 0.00 0.00 0.00 9,100.00 8,350.00 1,476.26 3,335.50 39.95 5,014.50 8,000.00 1,241.24 2,842.63 35.53 5,157.37 1,900.00 290.26 669.78 34.99 1,235.22 17,100.00 1,532.48 6,210.18 36.32 10,889.82 7,650.00 1,529.75 3,059.50 39.99 4,590.50 172,400.00 30,823.79 64,305.22 37.30 108,094.78 96,000.00 0.00 31,927.64 33.26 64,072.36 96,000.00 0.00 31,927.64 33.26 64,072.36 20,000.00 0.00 20,000.00 0.00 0.00 0.00 20,000.00 0.00 0.00 20,000.00 TOTAL Snow Removal 288,400.00 30,823.79 96,232.86 33.37 192,167.14 Equipment Services 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2012 I 'G -GENERAL FUND Public Works ' DEP_ARTMEN'iAI. EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00$ OF YEAR COMP. YE_=,R TO DATE $ OF :BUDGET ACTUAL BUDGET 3=GLANCE Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay 166,050.00 17,?64.87 35,409.12 21.32 130,640.88 12,050.00 803.19 2,557.98 21.23 9,492.02 10,300.00 653.48 2,076.63 20.16 8,223.37 2,400.00 152.83 485.66 20.24 1,914.34 23,900.00 1,643.17 4,796.62 20.50 18,603.38 4,500.00 1,027.25 2,054.50 45.66 2,445.50 218,700.00 21,744.79 47,380.51 21.66 171,319.49 20,200.00 742.29 1,843.76 9.13 18,356.24 6,000.00 0.00 0.00 0.00 6,000.00 26,200.00 792.29 1,843.76 7.04 24,356.24 3,000.00 216.44 531.02 17.70 2,468.98 3,000.00 216.44 531.02 17.70 2,468.98 TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies 101-4-3300-9212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3300-4319 Other Professional Services 101-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-4-3300-4331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services& Charges 247,900.00 22,703.52 49,755.29 20.07 198,144.71 79,250.00 10,551.93 21,103.86 26.63 58,146.19 5,750.00 510.00 1,525.00 26.52 4,225.00 9,900.00 421.34 1,259.74 25.71 3,640.26 1,150.00 98.54 294.62 25.62 855.38 14,050.00 521.00 1,563.00 11.12 12,487.00 550.00 144.25 288.50 52.45 261.50 105,650.00 12,247.06 26,034.72 24.64 79,615.28 500.00 12.85 12.85 2.57 487.15 600.00 0.00 0.00 0.00 600.00 1,000.00 0.00 16.00 1.60 984.00 2,100.00 12.85 28.85 1.37 2,071.15 13,500.00 17.69 65.69 0.49 13,434.31 700.00 10.09 16.66 2.38 683.34 150.00 14.70 14.70 9.80 135.30 2,700.00 0.00 0.00 0.00 2,700.00 200.00 45.50 91.00 45.50 109.00 7,800.00 187.03 561.09 7.19 7,238.91 750.00 62.50 187.50 25.00 562.50 25,800.00 337.51 936.64 3.63 24,863.36 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2012 ' 1C1-GaI~FR.'-. ?L'ND Public Works DEPARTMENTAL EXPENDITURES 25.OOo OF YE"R COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BP_LANCE Capital Outlay ' TOTA', Engineering 133,550.00 12,597.42 27,000.21 20.22 106,549.79 TO~=~L 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 TOTAL Personal Services Supplies 101-4-5110-9212 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-4319 Other Professional Services 101-4-5110-9321 Telephone 101-4-5110-9322 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-4909 Contractual Services 101-4-5110-4915 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 2,175,150.00 184,809.62 419,029.60 19.26 1,756,120.40 344,300.00 40,052.33 80,401.81 23.35 263,898.19 6,600.00 0.00 310.08 4.70 6,289.92 58,250.00 0.00 0.00 0.00 58,250.00 26,900.00 1,928.66 5,832.30 21.68 21,067.70 25,500.00 1,537.48 4,698.71 18.43 20,801.29 6,000.00 359.56 1,098.86 18.31 4,901.14 46,200.00 3,878.36 11,635.08 25.18 39,564.92 10,850.00 2,582.00 5,164.00 47.59 5,686.00 524,600.00 50,338.39 109,140.84 20.80 415,459.16 39,100.00 1,954.56 2,060.41 5.27 37,039.59 3,200.00 0.00 820.70 25.65 2,379.30 78,250.00 6,209.02 11,545.88 14.76 66,704.12 13,000.00 3,077.70 4,923.41 37.87 8,076.59 133,550.00 11,241.28 19,350.40 14.49 114,199.60 0.00 106.16 106.16 0.00 ( 106.16) 3,800.00 213.04 456.93 12.02 3,343.07 50.00 0.00 0.00 0.00 50.00 3,150.00 752.00 2,301.96 73.08 848.04 27,600.00 6,010.25 12,020.50 43.55 15,579.50 24,700.00 295.26 561.90 2.27 24,138.10 4,000.00 0.00 0.00 0.00 4,000.00 13,100.00 510.00 726.66 5.55 12,373.34 7,300.00 0.00 0.00 0.00 7,300.00 20,500.00 304.59 1,283.05 6.26 19,216.95 51,450.00 4,287.50 12,862.50 25.00 38,587.50 155,650.00 12,478.80 30,319.66 19.48 125,330.34 TOTAL Parks Department 813,800.00 74,058.47 158,810.90 19.51 654,989.10 4-11-2012 08:59 AM Culture & Recreation ' DEPARTMENTAL EXPENDITURES 25.00$ OF TEAR COMP. CURRENT CliRRENT Y"u.~A_R TO DATE %OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' ---ks-~-Rec-Admir, Personal Services 1C1-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 TOTAL Personal Services CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) p: OE: PLARCH 31ST, 2012 352,350.00 40,079.70 80,248.13 22.78 272,101.87 45,300.00 5,015.69 9,833.20 21.71 35,466.80 27,200.00 2,169.13 6,481.19 23.83 20,718.81 23,300.00 1,725.48 5,182.87 22.24 18,117.13 5,450.00 403.53 1,212.09 22.24 '4,237.91 52,700.00 3,988.42 11,747.22 22.29 40,952.78 4,450.00 1,026.00 2,052.00 46.11 2,398.00 510,750.00 54,407.95 116,756.70 22.86 393,993.30 10,200.00 1,756.65 3,926.69 38.50 6,273.31 10,200.00 1,756.65 3,926.69 38.50 6,273.31 4,800.00 371.89 870.84 18.14 3,929.16 6,000.00 171.19 171.19 2.85 5,828.81 6,850.00 199.44 1,537.26 22.44 5,312.74 32,900.00 ( 812.80) 768.20 2.37 31,631.80 650.00 197.50 295.00 45.38 355.00 7,400.00 571.46 1,104.93 14.93 6,295.07 13,300.00 1,422.62 3,935.63 29.59 9,364.37 9,350.00 819.89 1,714.23 18.33 7,635.77 1,550.00 1,334.00 1,334.00 86.06 216.00 82,300.00 4,220.14 11,731.28 14.25 70,568.72 603,250.00 60,384.74 132,414.67 21.95 470,835.33 82,000.00 2,649.65 6,267.44 7.64 75,732.56 2,400.00 81.79 131.66 5.99 2,268.34 4,350.00 132.80 365.61 8.90 3,984.39 1,200.00 31.06 85.50 7.13 1,114.50 89,950.00 2,895.30 6,850.21 7.62 83,099.79 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS vF: NLR~L ~l CTS 2O 1'' ' 1 Ji-GENE RP_L E''_'ND Culture & Recreation ' TEPARTMENTP.L EXPENDITURES 25.00s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OP BUDGET BUDGET PERIOD ACTUAL BUDGET BALFNCE 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 TOTAL Recreation Frograms Concessions 37,000.00 1,227.29 4,398.82 11.89 32,601.18 37,000.00 1,227.29 4,398.82 11.89 32,6G1.i8 64,050.00 464.78 1,964.78 3.07 62,085.22 1,500.00 0.00 0.00 0.00 1,500.00 4,500.00 506.19 828.11 18.40 3,671.89 70,050.00 970.97 2,792.89 3.99 67,257.11 197,000.00 5,093.56 14,041.92 7.13 182,958.08 Personal Services 101-4-5230-4103 Part-time Pay 3,650.00 ( 420.00) 101-4-5230-4104 PERA 150.00 ( 30.45) 101-4-5230-4105 FICA 250.00 ( 26.05) 101-4-5230-4107 Medicare 50.00 ( 6.10) TOTAL Personal Services 4,100.00 ( 482.60) Supplies 101-4-5230-4219 Operating Supplies 2,900.00 0.00 101-4-5230-4259 Other Merchandise For Resale 7,000.00 0.00 TOTAL Supplies 9,900.00 0.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 TOTAL Other Services & Charges 100.00 0.00 0.00 0.00 3,650.00 7.97 5.31 142.03 6.80 2.72 243.20 1.58 3.16 48.42 16.35 0.40 4,083.65 0.00 0.00 2,900.00 0.00 0.00 7,000.00 0.00 0.00 9,900.00 0.00 0.00 100.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4104 PERA 101-4-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services 14,100.00 ( 482.60) 16.35 0.12 14,083.65 58,550.00 6,756.01 13,512.03 23.08 45,037.97 62,350.00 7,281.22 14,639.15 23.48 47,710.85 8,750.00 680.58 2,040.11 23.32 6,709.89 7,500.00 548.50 1,644.11 21.92 5,855.89 1,750.00 128.26 384.48 21.97 1,365.52 14,100.00 1,154.51 3,463.53 24.56 10,636.47 650.00 145.25 290.50 44.69 359.50 153,650.00 16,694.33 35,973.91 23.41 117,676.09 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) P~ OF: MiARCB 31ST, 2012 101-GENERA? FUND Culture & Recreation ' DEPP.f2TMENTP.L EXPENDITURES 25.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BliDGET PERIOD ACTUAL BUDGET BALANCE Supplies i01-4-5510-4219 Operating Supplies TOTPZ 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 13,350.00 29.28 1,067.33 7.99 12,282.67 13,350.00 29.28 1,067.33 7.99 12,282.67 2,600.00 157.86 474.22 18.24 2,125.78 2,500.00 31.98 534.22 21.37 1,965.78 1,900.00 100.00 100.00 5.26 1,800.00 1,600.00 354.25 708.50 44.28 891.50 9,300.00 903.14 1,766.83 19.00 7,533.17 13,750.00 1,631.15 3,090.79 22.48 10,659.21 1,950.00 188.29 514.07 26.36 1,435.93 7,450.00 ( 40.00)( 203.00) 2.72- 7,653.00 950.00 0.00 299.16 31.49 650.84 42,000.00 3,326.67 7,284.79 17.34 34,715.21 17,500.00 0.00 0.00 0.00 17,500.00 17,soo.oo o.oo o.oo o.o0 17,soo.oo ' TOTAL Sr Citizen Programs 226,500.00 20,050.28 44,326.03 19.57 182,173.97 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-9105 FICA 101-4-6210-4107 Medicare 101-4-6210-9108 Insurance 101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-4322 Postage 101-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Economic Development 1,854,650.00 159,104.45 349,609.87 18.85 1,505,040.13 0.00 ( 4,622.37) 14,374.42 0.00 ( 19,374.42) 0.00 ( 1,050.33) 1,050.33 0.00 ( 1,050.33) 0.00 ( 714.26) 693.85 0.00 ( 693.85) 0.00 ( 648.50) 545.78 0.00 ( 545.78) 0.00 ( 156.04) 127.64 0.00 ( 127.64) 0.00 ( 1,491.00) 1,491.00 0.00 ( 1,491.00) 0.00 ( 56.00) 78.25 0.00 ( 78.25) 0.00 ( 8,738.50) 18,361.27 0.00 ( 18,361.27) 0.00 456.90 456.90 0.00 ( 456.90) 0.00 655.25 655.25 0.00 ( 655.25) 0.00 ( 35.19) 48.95 0.00 ( 48.95) 0.00 1,076.96 1,161.10 0.00 ( 1,161.10) 0.00 ( 7,661.54) 19,522.37 0.00 ( 19,522.37) 4-11-2012 08:59 AM i0i-GENERAL FUND Economic Development DE~ARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2012 PAGE: 26 25.COa OF YEP.E2 COMP. CURRENT CURRENT YEP.R TO DATE a CF BUDGET BUDGET PERIOD ACTUAL BUDGET BAANCE Energy City Personal Services 10i-4-6220-4101 Regular Pay 29,300.00 3,365.22 6,743.94 23.02 22,556.06 101-4-622C-4104 PERA 2,100.00 163.32 488.36 23.26 1,611.64 101-4-6220-4105 FICA 1,800.00 127.82 382.09 21.23 1,417.91 101-4-6220-4107 Medicare 400.00 29.90 89.38 22.35 310.62 101-4-6220-4108 Insurance 3,250.00 253.36 760.08 23.39 2,489.92 TOTAL Person al Services 36,850.00 3,939.62 8,463.85 22.97 28,386.15 Supplies 101-4-6220-4219 Operating Supplies 0.00 30.75 30.75 0.00 ( 30.75) TOTAL Suppli es 0.00 30.75 30.75 0.00 ( 30.75) Other Services & Charges 101-4-6220-4319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-6220-4331 Travel, Conferences & Schools 7,500.00 138.93 138.93 1.85 7,361.07 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Other Services & Charges 14,000.00 138.93 138.93 0.99 13,861.07 TOTAL Energy City 50,850.00 4,109.30 8,633.53 16.98 42,216.47 TOTAL Economic Development 50,850.00 ( 3,552.24) 28,155.90 55.37 22,694.10 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 90,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 1,149,934.05 2,600,303.08 20.51 10,077,746.92 REVENUES OVER/(UNDER) EXPENDITURES ( 366,150.00)( 896,000.28)( 1,979,197.13) 1,613,047.13 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) As oF: r~zcH 31ST, 2012 ' 321-ICE =uNEN_=_ FINANCLAL SUMNi~?2Y REVENUE SUM[~1?~RY 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 25.00$ OF Y"EAR COMP. CURRENT CURRENT' YEF',R TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 569,600.00 72,568.82 184,637.63 32.42 384,962.37 30,000.00 19,720.00 45,915.00 153.05 ( 15,915.00) 65,800.00 1,394.00 15,145.00 23.02 50,655.00 69,000.00 6,432.84 37,252.89 53.99 31,747.11 734,400.00 100,115.66 282,950.52 38.53 451,449.48 593,550.00 54,946.88 129,599.66 23.84 913,950.34 25,000.00 6,826.62 6,969.32 27.88 18,030.68 28,750.00 2,194.21 4,280.00 14.89 24,470.00 47,150.00 11,203.24 20,892.09 49.31 26,257.91 644,450.00 75,170.95 161,741.07 25.10 482,708.93 694,450.00 75,170.95 161,741.07 25.10 482,708.93 89,950.00 24,944.71 121,209.45 ( 31,259.45) 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS CF: 1~1~RCH 31ST, ^Oi 2.'1-ICE F~ENA ' REVENUES 25.00° OF YEAR COMP. CURRENT CURREAT'" YEAR "'0 DrTE °s CF BUDGET 3UDGET PERIOD ACTUAL BUDGET BALANCE Tce Arena Charges for Services 221-3-0000-3464 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221-3-0000-3791 ATM Revenue TOTAL Sales Transfers In TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating Charges for .Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services 488,000.00 73,112.51 158,424.45 32.46 329,575.55 22,900.C0 ( 2,843.00) 12,538.50 54.75 10,361.50 17,400.00 350.00 956.55 5.50 16,443.45 4,300.00 336.00 2,031.00 47.23 2,269.00 2,600.00 0.00 0.00 0.00 2,600.00 17,500.00 116.67 233.34 1.33 17,266.66 552,700.00 71,072.18 174,183.84 31.52 378,516.16 14,000.00 1,297.20 5,368.90 38.35 8,631.10 0.00 0.00 3,997.00 0.00 ( 3,997.00) 2,800.00 162.69 978.34 34.94 1,821.66 16,800.00 1,459.89 10,344.24 61.57 6,455.76 100.00 36.75 109.55 109.55 ( 9.55) 100.00 36.75 109.55 109.55 ( 9.55) 569,600.00 72,568.82 184,637.63 32.42 384,962.37 30,000.00 19,720.00 45,915.00 153.05 ( 15,915.00) 30,.000.00 19,720.00 45,915.00 153.05 ( 15,915.00) 30,000.00 19,720.00 45,915.00 153.05 ( 15,915.00) 62,000.00 1,394.00 15,145.00 24.93 46,855.00 3,800.00 0.00 0.00 0.00 3,800.00 65,800.00 1,394.00 15,145.00 23.02 50,655.00 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, ^012 221-TCE "-=~EL'_A I REVENUES 25.OOo OF YEAR CO??P. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BA_LPNCE Other Revenue TOTAL Skating Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services TOTAL Concessions 65,800.00 1,394.00 15,145.00 23.02 50,655.00 69,000.00 6,432.84 37,252.89 53.99 31,747.11 69,000.00 6,432.84 37,252.89 53.99 31,747.11 69,000.00 6,432.84 37,252.89 53.99 31,747.11 I TOTAL REVENUE 734,400.00 100,115.66 282,950.52 38.53 451,449.48 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2012 ^ 221-ICE FRENA ^ DEFARTMENTAL EXPENDITURES ^ Ice Arena Personal Services 221-4-5400-4101 Regular Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-5400-4107 Medicare 221-4-5400-4108 Insurance 221-4-5400-4109 Workers Comp TOTAL Personal Services Supplies 221-4-5900-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/Misc 221-4-5400-4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4319 Other Professional Services 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 CURRENT CURRENT BUDGET PERIOD 25.OOa OF Y"EAR COMP. Y"EFR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 167,600.00 16,006.71 35,116.26 20.95 132,483.74 59,300.00 10,042.65 21,666.46 36.54 37,633.54 15,700.00 1,100.26 3,419.78 21.78 12,280.22 14,100.00 1,036.54 3,431.87 24.34 10,668.13 3,350.00 242.42 802.62 23.96 2,547.38 26,400.00 1,881.00 5,643.00 21.38 20,757.00 8,000.00 1,789.75 3,579.50 44.74 4,420.50 294,450.00 32,099.33 73,659.49 25.02 220,790.51 50.00 0.00 0.00 0.00 50.00 1,300.00 0.00 0.00 0.00 1,300.00 34,250.00 3,466.82 7,958.26 23.24 26,291.74 8,000.00 571.68 2,879.04 35.99 5,120.96 600.00 0.00 0.00 0.00 600.00 44,200.00 4,038.50 10,837.30 24.52 33,362.70 0.00 53.08 53.08 0.00 ( 53.08) 3,500.00 142.19 339.45 9.70 3,160.55 400.00 8.27 8.27 2.07 391.73 1,000.00 20.37 20.37 2.04 979.63 2,000.00 155.00 155.00 7.75 1,845.00 7,800.00 1,706.50 3,413.00 43.76 4,387.00 192,450.00 13,984.28 29,229.13 20.52 113,220.87 22,750.00 2,314.02 3,117.15 13.70 19,632.85 1,200.00 326.60 326.60 27.22 873.90 2,800.00 98.74 98.74 3.53 2,701.26 500.00 0.00 230.00 46.00 270.00 184,400.00 18,809.05 36,990.79 20.06 147,409.21 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 54,946.88 129,599.66 23.84 413,950.34 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2012 ' =21-ICE ARENA Culture k Recreation ' DE~PF~RTMsNTAL EXPENDITURES 25.OC~ CF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ CF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Hockey personal Services 221-4-5410-4103 Part-time Pay 221-4-5410-4105 FICA 221-4-5410-4107 Medicare TOTAL Personal Services Supplies 221-4-5410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges 3,600.00 0.00 0.00 0.00 3,600.00 200.00 0.00 0.00 0.00 200.00 50.00 0.00 0.00 0.00 50.00 3,850.00 0.00 0.00 0.00 3,850.00 12,550.00 5,775.30 5,775.30 46.02 6,774.70 12,550.00 5,775.30 5,775.30 46.02 6,774.70 6,400.00 20.80 20.80 0.33 6,379.20 2,200.00 1,030.52 1,173.22 53.33 1,026.78 8,600.00 1,051.32 1,194.02 13.88 7,405.98 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-4-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges 25,000.00 6,826.62 6,969.32 27.88 18,030.68 15,000.00 1,605.55 2,442.55 16.28 12,557.45 1,000.00 41.99 70.16 7.02 929.84 950.00 67.92 132.44 13.94 817.56 200.00 15.90 31.00 15.50 169.00 17,150.00 1,731.36 2,676.15 15.60 14,473.85 5,300.00 66.38 1,031.88 19.47 4,268.12 5,300.00 66.38 1,031.88 19.47 4,268.12 650.00 0.00 0.00 0.00 650.00 2,850.00 46.40 46.40 1.63 2,803.60 2,800.00 350.07 525.57 18.77 2,279.93 6,300.00 396.47 571.97 9.08 5,728.03 ' TOTAL Skating 28,750.00 2,194.21 4,280.00 14.89 24,470.00 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) P.S OF: NiiLRCH 31ST, 3012 I 231-ICE _'-,REN~- Cu_ture & Recreation ' DEPARTMENTPI, EXPENDITURES 25.00% Or YEAR COMP. CURRENT CuRREIQT YEAR TO DP_TE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALF.NCE ^ Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 2,305.34 5,533.41 26.48 15,366.59 221-4-5430-4104 PER~1 200.00 19.87 86.50 43.25 113.50 221-4-5430-4105 FICA 1,300.00 99.49 349.44 26.88 950.56 221-4-5430-4107 Medicare 300.00 23.28 81.71 27.24 218.29 TOTAL Personal Services 22,700.00 2,447.98 6,051.06 26.66 16,698.99 Supplies 221-4-5430-4219 Operating Supplies 2,950.00 2,249.60 2,339.42 79.30 610.58 221-4-5430-4259 Other Merchandise For Resale 21,500.00 6,505.66 12,501.61 58.15 8,998.39 TOTAL Supplies 24,450.00 8,755.26 14,841.03 60.70 9,608.97 ' TOTAL Arena Concessions 47,150.00 11,203.24 20,892.09 44.31 26,257.91 ' TOTAL Culture & Recreation 644,450.00 75,170.95 161,791.07 25.10 482,708.93 ^ TOTAI~ EXPENDITURES ^ REVENUES OVER/(UNDER) EXPENDITURES 644,450.00 75,170.95 161,741.07 25.10 482,708.93 89,950.00 24,944.71 121,209.45 ( 31,259.45) 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 20 L? 222-PINEWOOD GCLF COURSE FINANCIAL SU?~iARY 25.OOa OF :'EAR COMP. CURRENT CURRENT YEFR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALFSiCE REVENUE SUMb1ARY Pinewood Golf Course TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 236,500.00 19,587.24 21,04E 24 8.9G 215,458.76 236,500.00 19,587.24 2i, 041.24 8.90 215,458.76 236,500.00 12,737.44 27,723.36 11.72 208,776.64 236,500.00 12,737.44 27,723.36 11.72 208,776.64 236,500.00 12,737.44 27,723.36 11.72 208,776.64 0.00 6,849.80 ( 6,682.12) 6,682.12 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) p.S OF: MARCH 31ST, 2012 ^ ~'22-PINEWOOD GOTF COURSE ' REVENUES 25.OOo OF TEFR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3479 Tournaments TOTAL Charges for Services 16,500.00 2,158.00 16,000.00 545.66 3,500.00 294.48 120,000.00 5,737.21 16,500.00 9,815.00 18,500.00 1,065.00 5,000.00 0.00 196,000.00 19,615.35 3,612.00 21.89 12,888.00 545.66 3.41 15,454.34 294.48 8.41 3,205.52 5,737.21 9.78 114,262.79 9,815.00 59.48 6,685.00 1,065.00 5.76 17,935.00 0.00 0.00 5,000.00 21,069.35 10.75 174,930.65 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 0.00 ( 28.11)( 28.11) 0.00 28.11 0.00 ( 28.11)( 28.11) 0.00 28.11 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 19,587.24 21,041.24 8.90 215,458.76 ^ TOTAL REVENUE 236,500.00 19,587.24 21,041.24 8.90 215,458.76 4-11-2012 08:59 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS CF: MARCH 31ST, 2012 ^ ___-PINEWOOD GOLF COURSE 'DEPARTMENTAL EXPENDITURES 25.00° OF YEAR COMP. CURRENT CURRENT YEAR TO DP_TE $ OF BUDGET BUDGET PERIOD ACTUAL EUDGET BALANCE Gclf Course Personal Services 222-4-5300-4101 Regular Pay 87,100.00 222-4-5300-4103 Part-time Pay 29,900.00 222-4-5300-4104 PERA 8,500.00 222-4-5300-4105 FICA 7,250.00 222-4-5300-4107 Medicare 1,700.00 222-4-5300-4108 Insurance 6,100.00 222-4-5300-4109 Workers Comp 1,850.00 TOTAL Personal Services 142,400.00 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 222-4-5300-4217 Uniform Allowance 500.00 222-4-5300-4219 Operating Supplies 29,700.00 222-4-5300-4259 Other Merchandise For Resale 12,000.00 TOTAL Supplies 46,700.00 Other Services & Charges 8,532.24 15,744.48 18.08 71,355.52 559.15 559.15 1.87 29,340.85 357.30 1,051.08 12.37 7,448.92 300.80 888.35 12.25 6,361.65 70.34 207.74 12.22 1,492.26 465.00 1,395.00 22.87 4,705.00 398.50 797.00 43.08 1,053.00 10,683.33 20,642.80 14.50 121,757.20 0.00 0.00 0.00 4,500.00 83.66 83.66 16.73 416.34 123.67 290.71 0.98 29,409.29 0.00 0.00 0.00 12,000.00 207.33 374.37 0.80 46,325.63 222-4-5300-4321 Telephone 2,400.00 169.05 222-4-5300-4331 Travel, Conferences & Schools 450.00 17.69 222-4-5300-4349 Advertising/Marketing 5,000.00 316.20 222-4-5300-4361 Insurance 12,100.00 2,394.00 222-4-5300-4389 Utilities 6,550.00 95.94 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 222-4-5300-9409 Equip Repair/Maint Services 4,600.00 7.20 222-4-5300-4415 Equipment Rental 1,350.00 0.00 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,216.98)( 222-4-5300-4438 Credit Card Fees 5,000.00 43.64 TOTAL Other Services & Charges 47,400.00 1,846.78 Capital Outlay 335.45 13.98 2,064.55 17.69 3.93 432.31 611.20 12.22 4,388.80 5,144.50 42.52 6,955.50 277.61 4.24 6,272.39 40.08 0.45 8,909.92 997.20 21.68 3,602.80 0.00 0.00 1,350.00 813.58) 81.36- 1,813.58 96.04 1.92 4,903.96 6,706.19 14.15 90,693.81 TOTAL Golf Course TOTAL Culture & Recreation ~ TOTAL EXPENDITURES 236,500.00 12,737.44 27,723.36 11.72 208,776.64 236,500.00 12,737.44 27,723.36 11.72 208,776.64 236,500.00 12,737.44 27,723.36 11.72 208,776.64 REVENUES OVER/(UNDER) EXPENDITURES 0.00 6,849.80 ( 6,682.12) 6,682.12 4-11-2012 09:01 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: MARCH 31ST, 2012 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT BALANCE ACTIVITY CURRENT BALANCE CLAIM ON CP.SH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 221-1010 Cash - Ice Arena 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 240-1010 Cash - Micro Loan Fund 241-1010 Cash - DTED Loan 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - GRE Reserve 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 333-1010 Cash - 2010A GO Cap Imp Bonds 344-1010 Cash - 2006C Cap Imp Bonds Lby 345-1010 Cash - 2012A CIP Bonds-PW 375-1010 Cash - TIF #19 East Elk River 403-1010 Cash - Street Improvement 404-1010 Cash - Surface Water Managemnt 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 940-1010 Cash - Park Improvement 456-1010 Cash - TIF #16 King/Main 459-1010 Cash - TIF #19 Highway 169 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 25,555.47 822.74 26,378.21 5,018,517.34 ( 756,644.56) 4,261,872.78 439,983.88 ( 2,916.06) 432,067.82 46,008.12 ( 24,902.66) 21,105.46 ( 10,846.62) 6,579.61 ( 4,267.01) 11,228.61 946.45 12,175.06 877,495.08 ( 3,965.49) 873,529.59 696,667.57 0.00 696,667.57 1,287,541.08 2,670.17 1,290,211.25 340,728.64 4,828.04 345,556.68 449,397.70 0.00 499,397.70 1,391,115.15 ( 2,408.32) 1,388,706.83 332,887.06 ( 59,645.27) 273,241.79 5,528,808.72 6,806,289.01 12,335,097.73 13,663.08 1,107.40 14,770.48 144,983.57 0.00 144,983.57 1,185,091.85 0.00 1,185,091.85 18,303.70 0.00 18,303.70 115,643.39 ( 402.50) 115,240.84 88,779.05 6,483.60 95,262.65 152,482.45 0.00 152,482.45 ( 181,622.50) ( 431.25) ( 182,053.75) 0.00 127,738.61 127,738.61 ( 77,862.50) ( 425.00) ( 78,287.50) 4,852,019.71 ( 1,664.29) 4,850,355.42 277,900.41 ( 1,942.10) 275,958.31 4,234,060.25 ( 28,990.67) 4,205,069.58 1,145,206.83 ( 115,825.09) 1,029,381.74 1,111,302.44 0.00 1,111,302.44 83,794.68 937.19 84,731.87 4,975.91 ( 4,968.78) 7.13 542,896.31 0.00 542,896.31 4,943,059.59 44,291.51 4,987,351.05 1,621,010.50 132,999.99 1,759,010.44 563,003.00 5,361.19 568,364.19 0.00 80,198.96 80,198.96 60,820.40 862.00 61,682.40 37,329,599.82 --------------- 6,216,984.38 -------------- 43,546,584.20 -------------- CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 999-1001 PY BANK ACCOUNT 999-1002 POOLED INVESTMENTS SUBTOTAL CASH IN BANK - POOLED CASH 30,676,208.98 7,199,196.58 37,875,405.56 (21,728,798.72) ( 982,212.20) (22,711,010.92) 28,382,189.56 0.00 28,382,189.56 37,329,599.82 6,216,984.38 43,546,584.20