Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 09-15-2008
9-11-2008 08:32 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: AUGUST 31ST, 2008 1~w '~~A ~M~"r'~~N BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 Cash - Library 221-1010 Cash - Ice Arena 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedication 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 - NSP/RDF Reserve 307-1010 Cash - 1998A GO Bonds 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 330-1010 Cash - 1997 City Hall Bonds 331-1010 Cash - 1994C Storm Sewer Bonds 333-1010 Cash - 2002A Pub Safety Bonds 340-1010 Cash - Equipment Certificates 344-1010 Cash - 2006C Cap Imp Bonds Lby 375-1010 Cash - TIF #19 East Elk River 401-1010 Cash - Capital Projects 403-1010 Cash - Street Improvement Resr 404-1010 Cash - Surface Water Managemnt 405-1010 Cash - NE Area Trunk Utilities 406-1010 Cash - City Wide Trunk Util 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash - Park Improvement 459-1010 Cash - TIF #19 Highway 169 462-1010 Cash - TIF #22 Downtown Redev 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 28,566.04 ( 799.20) 27,766.84 5,149,620.56 ( 809,089.86) 4,340,530.70 393,079.91 ( 4,897.14) 388,182.77 10,762.15 ( 1,017.82) 9,744.33 ( 49,581.32) 3,506.83 ( 46,074.49) 12,572.50 712.48 13,284.98 37,966.57 31,954.74 69,921.31 1,403,395.84 ( 655.95) 1,402,739.89 647,700.04 0.00 647,700.04 971,190.57 ( 165,230.85) 805,959.72 136,890.51 0.00 136,890.51 121,370.72 21,288.50 142,659.22 2,253,932.08 19,461.01 2,273,393.09 570,193.09 9,151.54 579,344.63 1,833,834.34 39,138.21 1,872,972.55 723.70 140.41 864.11 134,793.01 0.00 134,793.01 517,481.86 0.00 517,481.86 90,117.37 ( 1,612.50) 88,504.87 191,153.52 6,744.26 197,897.78 173,000.80 ( 14,607.50) 158,393.30 265,076.14 ( 44,250.00) 220,826.14 48,196.25 0.00 48,196.25 122,070.04 0.00 122,070.04 326,313.14 0.00 326,313.14 176,117.13 0.00 176,117.13 ( 431.25) 431.25 0.00 12,731.25 ( 12,731.25) 0.00 1,773,577.00 7,500.00 1,781,077.00 3,231,016.14 ( 203,054.28) 3,027,961.86 187,532.33 13,406.40 200,938.73 259,889.39 0.00 259,889.39 3,056,073.54 2,773.92 3,058,847.46 1,160,539.14 0.00 1,160,539.14 ( 713,150.77) 182,603.39 ( 530,547.38) 108,289.24 922.53 109,211.77 1,639,153.37 0.00 1,639,153.37 ( 685.57) ( 323.75) ( 1,009.32) 5,360,689.62 ( 422,426.43) 4,938,263.19 3,031,130.03 71,198.63 3,102,328.66 270,490.09 6,723.30 277,213.39 0.00 51,055.65 51,055.65 187,249.53 27,663.50 214,913.03 35,130,629.64 ( 1,184,319.98) 33,946,309.66 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 10i-GENERAL FUND FINANCIAL SUMMARY 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,993,450.00 91,329.88 6,313,136.10 50.53 6,180,313.90 TOTAL REVENUES 12,493,950.00 91,329.88 6,313,136.10 50.53 6,180,313.90 EXPENDITURE SUMMARY General Government Mayor & Council 221,100.00 6,041.72 89,349.39 40.41 131,750.61 Cable TV 99,250.00 4,693.16 45,271.67 45.61 53,978.33 Administrative Services 457,750.00 33,615.23 283,111.85 61.85 179,638.15 Human Resources 156,900.00 11,535.98 87,571.60 55.81 69,328.40 Elections 40,850.00 177.55 3,747.77 9.17 37,102.23 Finance 434,450.00 28,756.54 294,976.47 67.90 139,473.53 Information Technology 256,250.00 15,637.77 118,929.71 46.41 137,320.29 Legal 234,700.00 17,739.45 122,090.80 52.02 112,609.20 Community Development 158,550.00 12,780.25 63,524.42 40.07 95,025.58 Planning 328,950.00 15,998.30 170,047.97 51.77 158,402.03 City Hall Maintenance 300,000.00 26,420.55 208,501.97 69.50 91,498.03 Contingency 60,000.00 0.00 0.00 0.00 60,000.00 TOTAL General Government 2,748,250.00 172,846.50 1,487,123.62 54.11 1,261,126.38 Public Safety Police Administration 639,850.00 38,235.45 430,401.62 67.27 209,448.38 Patrol 2,200,800.00 177,149.27 1,224,071.57 55.62 976,728.43 Investigations 674,650.00 51,613.77 400,063.52 59.30 274,586.98 Police Support Services 963,800.00 37,104.56 289,915.00 61.43 178,885.00 Police Reserves 25,900.00 3,213.05 14,693.12 56.73 11,206.88 Public safety building 187,050.00 11,809.78 111,235.47 59.47 75,819.53 Fire Administration 446,500.00 38,540.57 321,549.34 72.02 124,950.66 Fire Inspections 192,750.00 13,503.54 122,684.43 63.65 70,065.57 Emergency Management 52,300.00 2,747.22 36,996.68 70.79 15,303.32 Building Safety 807,750.00 51,268.56 449,513.46 55.65 358,236.54 Environmental 87,150.00 5,979.89 51,420.75 59.00 35,729.25 TOTAL Public Safety 5,778,500.00 431,165.61 3,947,544.96 59.66 2,330,955.04 Public Works Street Maintenance 1,196,450.00 97,343.27 778,921.12 65.10 417,528.88 Snow Removal 301,600.00 0.00 126,869.60 42.07 174,730.40 Equipment Services 280,800.00 16,892.42 163,210.01 58.12 117,589.99 Engineering 174,550.00 3,100.76 61,752.46 35.38 112,797.54 TOTAL Public Works 1,953,400.00 117,336.45 1,130,753.19 57.89 822,646.81 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND FINANCIAL SUMMARY 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Developement Energy City TOTAL Economic Development General TRANSFERS OUT TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 668,350.00 81,197.43 454,208.36 67.96 214,141.64 571,250.00 38,737.00 332,828.78 58.26 238,421.22 191,750.00 30,983.58 130,874.35 68.25 60,875.65 18,850.00 1,311.32 8,137.60 43.17 10,712.90 201,300.00 12,789.38 119,837.61 59.53 81,962.39 1,651,500.00 164,968.71 1,045,886.70 63.33 605,613.30 0.00 13,681.76 28,388.20 0.00 ( 28,388.20) 93,350.00 2,349.07 35,669.00 38.21 57,681.00 93,350.00 16,025.83 64,057.20 68.62 29,292.80 268,450.00 0.00 66,600.00 24.81 201,850.00 268,450.00 0.00 66,600.00 24.81 201,850.00 12,493,450.00 902,343.10 7,241,965.67 57.97 5,251,984.33 0.00 ( 811,013.22)( 928,829.57) 928,829.57 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND 66.67$ OF YEAR COMP. REVENUES CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE General Fund Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,139,350.00 0.00 4,332,410.71 47.40 4,806,939.29 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 89,399.90 0.00 ( 84,399.90) 101-3-0000-3121 Gravel Tax 50,000.00 8,059.45 11,413.07 22.83 38,586.93 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,708.11 0.00 ( 2,708.11) TOTAL Property Taxes, 9,189,350.00 8,054.95 4,430,931.79 48.22 4,758,418.21 Linceses & 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-3234 Electric Permit 101-3-0000-3235 Animal License 101-3-0000-3236 Parking Permit 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Linceses & Permits Intergovernmental Rev 101-3-0000-3321 Local Government Aid 101-3-0000-3329 PERA Aid 101-3-0000-3325 Police 2$ Aid 101-3-0000-3326 Police Training Reimb 101-3-0000-3327 State-Aid Street Maint 101-3-0000-3329 State Crime Prevention Grant 101-3-0000-3330 Other State Grants TOTAL Intergovernmental Rev Charges for Services 101-3-0000-3412 Planning & Zoning Fees 101-3-0000-3413 Plan Check Fee 101-3-0000-3915 Special Assessment Search 101-3-0000-3417 Copies 101-3-0000-3418 Other General Govt Services 101-3-0000-3430 Lockout Fees 101-3-0000-3931 Police Services 101-3-0000-3432 School Liaison 101-3-0000-3433 Mobile Connection Fees 50,250.00 130.00 51,202.50 101.90 ( 952.50) 1,000.00 0.00 0.00 0.00 1,000.00 3,500.00 0.00 175.00 5.00 3,325.00 15,850.00 180.00 13,695.00 86.40 2,155.00 9,000.00 0.00 8,954.90 99.50 45.10 1,800.00 0.00 3,215.00 178.61 ( 1,415.00) 13,000.00 25.00 7,010.00 53.92 5,990.00 12,400.00 350.00 3,850.00 31.05 8,550.00 410,250.00 17,544.90 162,941.89 39.72 247,308.11 140,000.00 9,632.21 49,485.85 31.78 95,514.15 1,900.00 716.66 2,486.05 177.58 ( 1,086.05) 200.00 0.00 0.00 0.00 200.00 2,000.00 167.00 2,543.50 127.18 ( 543.50) 5,600.00 120.00 1,398.32 24.97 9,201.68 10,000.00 290.00 6,339.64 63.40 3,660.36 676,250.00 29,155.77 308,297.65 95.59 367,952.35 686,800.00 0.00 343,910.00 50.00 343,390.00 14,000.00 0.00 6,992.00 99.94 7,008.00 210,000.00 0.00 0.00 0.00 210,000.00 10,000.00 12,016.09 12,016.09 120.16 ( 2,016.09) 36,500.00 0.00 39,690.00 108.74 ( 3,190.00) 17,000.00 0.00 8,638.96 50.82 8,361.09 2,600.00 0.00 0.00 0.00 2,600.00 976,900.00 12,016.09 910,747.05 42.05 566,152.95 25,000.00 920.00 15,170.00 60.68 9,830.00 260,000.00 7,257.68 78,757.72 30.29 181,242.28 1,000.00 20.00 200.00 20.00 800.00 1,500.00 130.60 1,738.46 115.90 ( 238.96) 3,500.00 396.25 2,772.30 79.21 727.70 8,500.00 600.00 5,145.00 60.53 3,355.00 2,500.00 131.50 936.50 37.96 1,563.50 75,000.00 0.00 75,000.00 100.00 0.00 3,000.00 0.00 0.00 0.00 3,000.00 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND 66.67$ OF YEAR COMP. REVENUES CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3439 Animal Impound Fee 101-3-0000-3435 Vehicle Impound 101-3-0000-3936 Fire Contracts 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3461 Recreation Fees 101-3-0000-3967 Concessions 101-3-0000-3472 Park Use Fee 101-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services Fines, Fees, & Forfeit 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines, Fees, & Forfeit Other Revenue lUl-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-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-wWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 2,330.00 84.73 420.00 98.25 0.00 ( 98.25) 196,895.00 109.36 ( 16,845.00) 0.00 0.00 2,500.00 12,591.71 44.97 15,408.29 98,661.25 75.89 31,338.75 8,493.22 93.55 11,006.78 15,118.30 191.37 ( 7,218.30) 3,006.98 0.00 ( 3,006.98) 1,625.00 0.00 ( 1,625.00) 1,805.00 18.05 8,195.00 365.00 24.33 1,135.00 520,659.69 68.31 241,490.31 155,000.00 10,548.69 74,566.51 48.11 80,433.49 5,000.00 840.00 7,415.00 148.30 ( 2,415.00) 160,000.00 11,388.69 81,981.51 51.24 78,018.49 200,000.00 0.00 117,330.76 58.67 82,669.24 95,000.00 89.65 294.70 0.65 44,705.30 7,800.00 60.50 1,312.00 16.82 6,988.00 3,000.00 1,016.13 3,580.95 119.37 ( 580.95) 255,800.00 1,166.28 122,518.41 47.90 133,281.59 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 39,500.00 100.00 0.00 91,000.00 0.00 41,000.00 100.00 0.00 226,000.00 0.00 226,000.00 100.00 0.00 105,000.00 0.00 105,000.00 100.00 0.00 17,000.00 0.00 17,000.00 100.00 0.00 9,500.00 0.00 9,500.00 100.00 0.00 973,000.00 0.00 438,000.00 92.60 35,000.00 12,493,450.00 91,329.88 6,313,136.10 50.53 6,180,313.90 2,750.00 500.00 0.00 0.00 180,000.00 0.00 2,500.00 0.00 28,000.00 369.00 130,000.00 16,675.00 19,500.00 501.27 7,900.00 777.13 0.00 605.17 0.00 200.00 10,000.00 435.00 1,500.00 30.00 762,150.00 29,548.60 SOTAL REVENUE 12,493,450.00 91,329.88 6,313,136.10 50.53 6,180,313.90 9-11-2008 01:32 PM 101-GENERAL FUND General Government Mayor & Council DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. ', CURRENT CURRENT YEAR TO DATE $ OF BUDGET ', BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-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-9-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-9-1110-4490 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,455.31 25,666.86 66.67 12,833.14 1,950.00 159.81 1,137.56 58.39 812.44 2,900.00 214.23 1,554.13 64.76 845.87 550.00 50.12 363.69 66.13 186.31 50.00 0.00 27.25 54.50 22.75 43,450.00 3,879.47 28,799.49 66.17 14,700.51 3,200.00 97.73 253.19 7.91 2,946.86 3,200.00 97.73 253.19 7.91 2,946.86 28,250.00 1,379.37 9,600.15 33.98 18,649.85 800.00 120.41 227.33 28.42 572.67 8,500.00 153.99 1,105.05 13.00 7,394.95 28,000.00 118.80 9,636.28 34.42 18,363.72 81,300.00 0.00 29,804.00 36.66 51,496.00 19,100.00 0.00 4,517.00 23.65 14,583.00 8,500.00 292.00 5,456.95 64.20 3,043.05 174,450.00 2,069.52 60,346.76 34.59 114,103.29 I TOTAL Mayor & Council 221,100.00 6,041.72 89,349.39 40.41 131,750.61 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Cable TV DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4102 Overtime Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-9-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1120-4319 Other Professional Services 101-4-1120-4322 Postage 101-4-1120-4331 Travel, Conferences & Schools 101-4-1120-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 56,550.00 3,697.61 2,000.00 0.00 18,800.00 0.00 5,050.00 240.34 9,800.00 229.24 1,100.00 53.62 7,300.00 417.01 150.00 0.00 95,750.00 4,637.82 29,000.29 51.28 27,549.76 10.20 0.51 1,989.80 7,041.95 37.46 11,758.05 2,381.43 47.16 2,668.57 2,229.66 46.95 2,570.34 521.50 47.41 578.50 3,687.03 50.51 3,612.97 120.75 80.50 29.25 44,992.76 46.99 50,757.24 2,100.00 19.79 80.07 3.81 2,019.93 2,100.00 19.79 80.07 3.81 2,019.93 500.00 0.00 0.00 0.00 500.00 0.00 1.11 16.96 0.00 ( 16.96) 800.00 34.44 181.88 22.74 618.12 100.00 0.00 0.00 0.00 loo.oo 1,400.00 35.55. 198.84 14.20 1,201.16 TOTAL Cable TV 99,250.00 4,693.16 45,271.67 45.61 53,978.33 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Administrative Services DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1210-4101 Regular Pay 101-4-1210-4102 Overtime Pay 101-4-1210-4103 Part-time Pay 101-9-1210-4104 PERA 101-4-1210-4105 FICA 101-4-1210-4106 Other Retirement Contributions 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-4361 Insurance 101-4-1210-4404 Equip Repair/Maint Services 101-4-1210-4433 Dues & Subscriptions TOTAL Other Services & Charges 283,500.00 22,061.12 177,238.00 62.52 106,262.00 2,000.00 0.00 86.33 4.32 1,913.67 44,250.00 3,477.76 28,296.32 63.95 15,953.68 21,300.00 1,660.03 13,833.85 64.95 7,466.15 20,300.00 1,560.49 13,043.64 64.25 7,256.36 4,800.00 400.00 3,200.00 66.67 1,600.00 4,750.00 364.97 3,050.58 64.22 1,699.42 24,900.00 1,862.54 15,106.04 60.67 9,793.96 1,200.00 0.00 900.50 75.09 299.50 407,000.00 31,386.91 254,755.26 62.59 152,244.74 13,400.00 178.35 7,959.13 55.63 5,995.87 13,400.00 178.35 7,454.13 55.63 5,945.87 900.00 0.00 687.50 76.39 212.50 350.00 74.51 465.28 132.94 ( 115.28) 1,700.00 248.62 692.41 40.73 1,007.59 6,850.00 39.44 2,168.09 31.65 4,681.91 200.00 0.00 91.00 95.50 109.00 24,800.00 1,692.40 15,978.18 64.43 8,821.82 2,550.00 0.00 820.00 32.16 1,730.00 37,350.00 2,049.97 20,902.46 55.96 16,447.54 TOTAL Administrative Services 457,750.00 33,615.23 283,111.85 61.85 174,638.15 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Human Resources DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-9108 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-9-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges 118,550.00 5,142.08 41,148.43 34.71 77,401.57 0.00 3,537.34 27,704.37 0.00 ( 27,704.37) 7,700.00 564.17 4,561.90 59.25 3,138.10 7,350.00 532.48 9,313.77 58.69 3,036.23 1,700.00 124.53 1,008.83 59.34 691.17 10,300.00 439.95 3,636.08 35.30 6,663.92 450.00 0.00 326.25 72.50 123.75 146,050.00 10,390.55 82,699.63 56.62 63,350.37 4,350.00 13.97 2,455.83 56.46 1,894.17 4,350.00 13.97 2,955.83 56.46 1,894.17 3,000.00 0.00 250.00 8.33 350.00 106.12 185.85 53.10 2,550.00 1,009.44 1,176.04 46.12 600.00 0.00 250.00 41.67 0.00 65.90 554.25 0.00 6,500.00 1,181.46 2,416.14 37.17 4,083.86 2,750.00 164.15 1,373.96 350.00 TOTAL Human Resources 156,900.00 11,535.98 87,571.60 55.81 69,328.90 9-11-2008 01:32 PM 101-GENERAL FUND General Government Elections DEPARTMENTAL EXPENDITURES PAGE: 9 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1230-4103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1230-9322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges 30,000.00 0.00 0.00 0.00 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 7,000.00 24.43 3,454.85 49.36 3,545.15 7,000.00 24.43 3,454.85 49.36 3,545.15 350.00 153.12 153.12 43.75 196.88 700.00 0.00 35.85 5.12 664.15 2,000.00 0.00 103.95 5.20 1,896.05 800.00 0.00 0.00 0.00 800.00 3,850.00 153.12 292.92 7.61 3,557.08 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 TOTAL Elections 90,850.00 177.55 3,747.77 9.17 37,102.23 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Finance DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1310-4101 Regular Pay 101-4-1310-4103 Part-time Pay 101-4-1310-4104 PERA 101-9-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-9319 Other Professional Services 101-9-1310-4321 Telephone 101-4-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4409 Equip Repair/Maint Services 101-4-1310-4933 Dues & Subscriptions 101-4-1310-4440 Miscellaneous TOTAL Other Services & Charges 270,200.00 21,011.66 169,350.60 62.68 100,849.40 5,000.00. 185.00 2,125.00 42.50 2,875.00 17,900.00 1,365.78 11,439.38 63.91 6,460.62 17,050.00 1,225.05 10,377.83 60.87 6,672.17 4,000.00 286.50 2,427.14 60.68 1,572.86 25,450.00 1,860.04 16,110.29 63.30 9,339.71 1,000.00 0.00 756.75 75.68 243.25 340,600.00 25,934.03 212,586.99 62.92 128,013.01 5,800.00 255.78 3;214.18 55.42 2,585.82 5,800.00 255.78 3,214.18 55.42 2,585.82 20,500.00 0.00 17,800.00 86.83 51,700.00 0.00 46,687.00 90.30 0.00 66.45 436.73 0.00 2,500.00 1,050.15 2,336.25 93.45 4,000.00 1,100.13 2,859.26 71.48 1,000.00 0.00 1,269.68 126.97 6,500.00 350.00 6,904.38 98.53 1,050.00 0.00 1,290.00 122.86 800.00 0.00 92.00 11.50 88,050.00 2,566.73 79,175.30 89.92 8,874.70 2,700.00 5,013.00 436.73) 163.75 1,140.74 269.68) 95.62 240.00) 708.00 TOTAL Finance 434,450.00 28,756.59 294,976.97 67.90 139,973.53 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Information Technology DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1350-4101 Regular Pay 101-9-1350-4102 Overtime 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 Supplies 101-4-1350-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1350-4319 Other Professional Services 101-4-1350-4321 Telephone 101-4-1350-4331 Travel, Conferences & Schools 101-9-1350-4404 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 101-9-1350-4560 Equipment TOTAL Capital Outlay 121,950.00 9,580.84 75,955.87 62.28 45,994.13 0.00 75.00 90.50 0.00 ( 90.50) 12,500.00 1,515.00 9,725.00 37.80 7,775.00 8,750.00 622.76 5,100.65 58.29 3,699.35 8,350.00 654.65 4,888.81 58.55 3,961.19 1,950.00 153.12 1,143.39 58.64 806.61 15,200.00 1,179.93 9,969.15 65.55 5,235.85 500.00 0.00 369.75 73.95 130.25 169,200.00 13,781.30 102,238.12 60.42 66,961.88 27,500.00 973.20 10,574.90 38.45 16,925.10 27,500.00 973.20 10,574.90 38.95 16,925.10 5,000.00 490.00 ( 596.00) 11.92- 5,596.00 800.00 68.27 357.60 44.70 442.90 4,000.00 0.00 596.16 14.90 3,403.84 19,750.00 375.00 5,758.93 29.16 13,991.07 29,550.00 883.27 6,116.69 20.70 23,433.31 30,000.00 0.00 0.00 0.00 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Information Technology 256,250.00 15,637.77 118,929.71 46.91 137,320.29 9-11-2008 01:32 PM 101-GENERAL FUND General Government Legal DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Char es 101-4-1400-4304 Legal Fees 101-9-1400-4361 Insurance TOTAL Other Services & Charges 234,000.00 17,739.45 122,090.80 52.18 111,909.20 700.00 0.00 0.00 0.00 700.00 234,700.00 17,739.45 122,090.80 52.02 112,609.20 TOTAL Legal 234,700.00 17,739.45 122,090.80 52.02 112,609.20 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Community Development DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1500-4101 Regular Pay 101-4-1500-4102 Overtime Pay 101-4-1500-4104 PERA 101-4-1500-4105 FICA 101-9-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1500-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 101-4-1500-9433 Dues & Subscriptions TOTAL Other Services & Charqes 122,050.00 10,297.22 49,371.78 40.45 72,678.22 500.00 0.00 109.35 21.87 390.65 7,950.00 669.32 3,284.41 91.31 4,665.59 7,600.00 609.10 2,995.69 39.42 9,604.31 1,800.00 142.46 700.57 38.92 1,099.43 14,900.00 1,046.85 4,891.86 32.83 10,008.14 500.00 0.00 393.75 78.75 106.25 155,300.00 12,764.95 61,797.41 39.76 93,552.59 250.00 15.30 1,658.90 663.56 ( 1,408.90) 250.00 15.30 1,658.90 663.56 ( 1,908.90) 2,750.00 250.00 0.00 0.00 3,000.00 0.00 118.11 4.29 2,631.89 0.00 0.00 250.00 118.11 3.94 2,881.89 TOTAL Community Development 158,550.00 12,780.25 63,524.42 40.07 95,025.58 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND General Government Planning DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67% OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4109 PERA 101-4-1510-9105 FICA 101-4-1510-4107 Medicare 101-9-1510-4108 Insurance 101-4-1510-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101-4-1510-4319 Other Professional Services 101-4-1510-4321 Telephone 101-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-9-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4940 Miscellaneous TOTAL Other Services & Charges 205,300.00 10,777.92 116,756.33 56.87 88,543.67 13,350.00 700.56 7,823.91 58.61 5,526.09 12,750.00 616.98 7,107.92 55.75 5,642.08 3,000.00 144.18 1,662.29 55.91 1,337.71 25,050.00 1,459.27 14,850.19 59.28 10,199.81 450.00 0.00 350.25 77.83 99.75 259,900.00 13,698.41 148,550.89 57.16 111,349.11 7,300.00 179.57 250.00 170.45 7,550.00 345.02 5,401.14 73.99 1,898.86 303.43 121.37 ( 53.43) 5,704.57 75.56 1,845.43 30,000.00 0.00 0.00 0.00 30,000.00 600.00 34.69 303.93 50.66 296.07 2,500.00 763.73 1,292.66 99.71 1,257.34 7,500.00 88.34 2,466.64 32.89 5,033.36 10,000.00 400.96 3,702.73 37.03 6,297.27 800.00 0.00 131.50 16.44 668.50 7,000.00 117.15 7,320.05 104.57 ( 320.05) 2,100.00 0.00 625.00 29.76 1,475.00 500.00 0.00 0.00 0.00 500.00 61,000.00 1,404.87 15,792.51 25.89 45,207.49 TOTAL Planning 328,450.00 15,948.30 170,047.97 51.77 158,902.03 9-11-2008 01:32 PM 101-GENERAL FUND General Government City Hall Maintenance DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay 101-4-1600-4103 Part-time Pay 101-4-1600-4104 PERA 101-4-1600-9105 FICA 101-4-1600-4107 Medicare 101-4-1600-4108 Insurance 101-4-1600-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone 101-9-1600-4331 Travel, Conferences & Schools 101-4-1600-9361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4401 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 101-4-1600-4560 Equipment TOTAL Capital Outlay 89,900.00 7,622.05 59,928.59 66.66 350.00 1,641.16 9,370.75 1,248.79 10,650.00 1,069.16 3,928.55 36.89 6,550.00 622.14 4,470.72 68.26 6,250.00 622.35 9,404.12 70.47 1,450.00 160.06 1,044.56 72.09 12,700.00 1,449.17 10,346.04 81.46 2,400.00 0.00 1,813.50 75.56 130,250.00 13,181.09 90,306.83 69.33 39,943.17 4,000.00 495.61 2,844.57 71.11 1,155.43 1,700.00 0.00 677.05 39.83 1,022.95 30,500.00 1,030.96 20,821.89 68.27 9,678.11 36,200.00 1,526.57 24,343.51 67.25 11,856.49 17,550.00 1,391.54 10,186.30 58.04 7,363.70 2,000.00 0.00 362.64 18.13 1,637.36 5,900.00 0.00 2,631.00 44.59 3,269.00 45,400.00 2,679.62 28,582.42 62.96 16,817.58 30,700.00 1,248.44 20,008.81 65.18 10,691.19 0.00 0.00 186.50 0.00 ( 186.50) 101,550.00 5,319.60 61,957.67 61.01 39,592.33 32,000.00 6,393.29 31,893.96 99.67 106.04 32,000.00 6,393.29 31,893.96 99.67 106.04 CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 29,971.41 4,020.75) 6,721.95 2,079.28 1,845.88 405.44 2,353.96 586.50 TOTAL City Hall Maintenance 300,000.00 26,420.55 208,501.97 69.50 91,498.03 9-11-2008 01:32 PM 101-GENERAL FUND General Government Contingency DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1900-4490 Miscellaneous TOTAL Other Services & Charges 60,000.00 0.00 0.00 0.00 60,000.00 60,000.00 0.00 0.00 0.00 60,000.00 TOTAL Contingency 60,000.00 0.00 0.00 0.00 60,000.00 TOTAL General Government 2,748,250.00 172,846.50 1,987,123.62 54.11 1,261,126.38 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Police Administration DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-9102 Overtime Pay 101-9-2110-4109 PERA 101-4-2110-4105 FICA 101-4-2110-4107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-9319 Other Professional Services 101-9-2110-4321 Telephone 101-4-2110-4322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-9359 Publishing 101-4-2110-4361 Insurance 101-4-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-9437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-2110-4560 Equipment TOTAL Capital Outlay 323,200.00 24,901.90 204,191.46 63.18 119,008.54 0.00 1,236.83 1,236.83 0.00 ( 1,236.83) 38,400.00 3,380.84 25,390.03 66.12 13,009.97 3,200.00 236.06 2,012.38 62.89 1,187.62 3,250.00 286.70 2,214.27 68.13 1,035.73 30,550.00 2,184.26 20,174.57 66.04 10,375.43 45,600.00 0.00 39,215.50 75.03 11,384.50 449,200.00 32,226.09 289,435.04 65.16 154,764.96 15,200.00 1,254.31 10,252.69 67.45 4,947.36 2,450.00 86.77 1,848.03 75.43 601.97 4,650.00 995.42 4,284.12 92.13 365.88 22,300.00 1,836.50 16,384.79 73.47 5,915.21 6,100.00 0.00 1,329.49 21.79 4,770.51 26,700.00 2,738.25 14,414.35 53.99 12,285.65 2,600.00 567.37 1,243.36 97.82 1,356.64 4,800.00 41.00 4,296.07 89.50 503.93 500.00 0.00 0.00 0.00 500.00 13,500.00 0.00 5,010.50 37.11 8,989.50 54,000.00 826.24 38,279.77 70.89 15,720.23 7,050.00 0.00 2,172.00 30.81 4,878.00 500.00 0.00 237.25 47.45 262.75 115,750.00 4,172.86 66,982.79 57.87 48,767.21 57,600.00 0.00 57,599.00 100.00 1.00 57,600.00 0.00 57,599.00 100.00 1.00 TOTAL Police Administration 639,850.00 38,235.45 430,401.62 67.27 209,448.38 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Patrol DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PERA 101-4-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-9404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2120-4560 Equipment TOTAL Capital Outlay 1,393,950.00 101,757.10 804,874.26 57.74 589,075.74 90,000.00 20,661.88 45,353.35 50.39 44,646.65 191,700.00 15,524.97 112,958.38 58.92 78,741.62 19,350.00 1,450.07 10,570.65 54.63 8,779.35 155,600.00 13,456.75 96,061.72 61.79 59,538.28 1,850,600.00 152,850.77 1,069,818.36 57.81 780,781.64 100,000.00 14,751.18 79,702.73 74.70 25,297.27 16,800.00 558.69 6,032.68 35.91 10,767.32 63,000.00 3,781.53 43,701.31 69.37 19,298.69 22,000.00 2,262.62 16,111.33 73.23 5,888.67 201,600.00 21,354.02 140,548.05 69.65 61,251.95 18,650.00 2,765.60 6,197.28 33.23 12,452.72 27,200.00 118.88 7,297.88 26.83 19,902.12 550.00 0.00 150.00 27.27 400.00 46,400.00 2,889.48 13,645.16 29.41 32,754.84 102,000.00 60.00 60.00 0.06 101,940.00 102,000.00 60.00 60.00 0.06 101,940.00 TOTAL Patrol 2,200,800.00 177,149.27 1,224,071.57 55.62 976,728.43 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Investigations DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-9-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance SOTAI, Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-9-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4-2130-9331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions TOTAL Other Services & Charges 479,950.00 36,277.68 293,823.63 61.22 186,126.37 40,000.00 4,285.65 10,033.07 25.08 29,966.93 67,100.00 5,232.67 40,395.98 60.20 26,704.02 5,500.00 367.59 2,911.39 52.93 2,588.61 56,950.00 4,948.22 38,807.04 68.14 18,142.96 649,500.00 51,111.81 385,971.11 59.43 263,528.89 4,750.00 180.60 1,681.62 35.90 3,068.38 6,100.00 101.36 3,231.65 52.98 2,868.35 10,850.00 281.96 4,913.27 45.28 5,936.73 8,650.00 220.00 5,500.00 0.00 150.00 0.00 14,300.00 220.00 5,938.93 62.88 3,211.07 3,740.21 68.00 1,759.79 0.00 0.00 150.00 9,179.14 64.19 5,120.86 TOTAL Investigations 674,650.00 51,613.77 900,063.52 59.30 279,586.48 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Police Support Services DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-9331 Travel, Conferences & Schools 101-4-2150-4409 Equip Repair/Maint Services 101-4-2150-4409 Contractual Services 101-4-2150-4433 Dues & Subscriptions TOTAL Other Services & Charges 338,000.00 25,757.69 207,761.54 61.47 130,238.46 1,000.00 1,664.41 2,223.17 222.32 ( 1,223.17) 22,050.00 1,782.44 14,060.72 63.77 7,989.28 21,000.00 1,674.11 13,277.29 63.22 7,722.76 5,000.00 391.53 3,105.07 62.10 1,894.93 40,600.00 3,357.80 26,787.49 65.98 13,812.51 427,650.00 34,627.93 267,215.23 62.48 160,434.77 1,000.00 0.00 0.00 0.00 1,000.00 3,000.00 ( 150.47) 1,995.85 66.53 1,004.15 10,200.00 1,215.15 4,294.89 42.11 5,905.11 14,200.00 1,064.68 6,290.74 44.30 7,909.26 4,050.00 95.00 346.01 8.54 3,703.99 3,400.00 0.00 3,500.85 102.97 ( 100.85) 14,000.00 1,316.95 7,309.67 52.21 6,690.33 500.00 0.00 252.50 50.50 247.50 21,950.00 1,411.95 11,409.03 51.98 10,540.97 TOTAL Police Support Services 463,800.00 37,104.56 284,915.00 61.43 178,885.00 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Police Reserves DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA 101-4-2160-4107 Medicare 101-4-2160-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-2160-9217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies Other Services & Char es 101-4-2160-4319 Other Professional Services 101-4-2160-9321 Telephone 101-4-2160-4331 Travel, Conferences & Schools 101-4-2160-4433 Dues & Subscriptions TOTAL Other Services & Charges 5,500.00 2,057.99 4,467.74 81.23 1,032.26 350.00 127.59 276.99 79.19 73.01 100.00 29.85 64.81 64.81 35.19 0.00 6.06 80.85 0.00 ( 80.85) 5,950.00 2,221.49 4,890.39 82.19 1,059.61 5,000.00 0.00 3,107.09 62.14 1,892.91 7,500.00 832.83 4,819.94 69.26 2,680.56 12,500.00 832.83 7,926.53 63.91 4,573.97 1,500.00 0.00 350.00 23.33 1,150.00 2,400.00 158.73 599.20 22.88 1,850.80 2,300.00 0.00 365.00 15.87 1,935.00 1,250.00 0.00 612.00 48.96 638.00 7,950.00 158.73 1,876.20 25.18 5,573.80 TOTAL Police Reserves 25,900.00 3,213.05 14,693.12 56.73 11,206.88 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Public safety building DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-9-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4103 Part-time Pay 101-4-2190-9104 PERA 101-4-2190-4105 FICA 101-9-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 91,600.00 7,208.78 53,771.86 58.70 37,828.14 950.00 158.85 282.85 62.86 167.15 0.00 0.00 154.74 0.00 ( 154.74) 6,000.00 965.00 3,488.74 58.15 2,511.26 5,700.00 450.38 3,320.17 58.25 2,379.83 1,350.00 105.34 776.52 57.52 573.48 14,550.00 999.30 7,372.59 50.67 7,177.41 2,200.00 0.00 1,651.50 75.07 548.50 121,850.00 9,337.65 70,818.97 58.12 51,031.03 14,000.00 582.93 9,502.88 67.88 4,497.12 14,000.00 582.93 9,502.88 67.88 4,497.12 6,900.00 0.00 3,190.50 46.24 3,709.50 15,600.00 551.72 13,849.60 88.78 1,750.40 28,700.00 1,337.48 13,873.52 48.34 14,826.48 51,200.00 1,889.20 30,913.62 60.38 20,286.38 TOTAL Public safety building 187,050.00 11,809.78 111,235.47 59.47 75,814.53 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Fire Administration DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4102 Overtime Pay 101-4-2310-9103 Part-time Pay 101-9-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions 101-9-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-9-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-9-2310-9331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-9-2310-4389 Utilities 101-9-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Fire Administration 86,750.00 7,518.35 58,394.00 67.31 28,356.00 0.00 17.65 62.74 0.00 ( 62.74) 140,750.00 12,332.58 105,659.17 75.07 35,090.83 11,650.00 1,086.59 8,157.10 70.02 3,492.90 9,900.00 822.14 7,416.15 78.90 1,983.85 30,000.00 0.00 30,000.00 100.00 0.00 3,300.00 269.78 2,413.39 73.13 886.61 11,200.00 1,004.98 8,385.89 74.87 2,814.11 14,400.00 0.00 10,819.50 75.14 3,580.50 307,450.00 23,051.57 231,307.94 75.23 76,192.06 1,200.00 124.56 667.44 55.62 532.56 8,000.00 912.68 6,125.83 76.57 1,874.17 1,100.00 0.00 47.05 4.28 1,052.95 32,600.00 2,338.52 20,484.15 62.83 12,115.85 42,900.00 3,375.76 27,324.47 63.69 15,575.53 9,900.00 0.00 3,958.92 80.79 941.08 2,900.00 '401.45 1,954.40 67.39 945.60 350.00 110.84 530.31 151.52 ( 180.31) 23,550.00 6,875.20 18,588.29 78.93 4,961.71 500.00 0.00 240.00 48.00 260.00 23,550.00 0.00 9,686.00 41.98 13,669.00 13,650.00 183.47 11,958.21 83.94 2,191.79 4,000.00 1,052.33 3,986.41 99.66 13.59 20,750.00 3,489.95 10,511.89 50.66 10,238.11 2,000.00 0.00 1,802.50 90.13 197.50 96,150.00 12,113.24 62,916.93 65.44 33,233.07 446,500.00 38,540.57 321,599.34 72.02 129,950.66 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Fire Inspections DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-4103 Part-time 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 Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-9433 Dues & Subscriptions TOTAL Other Services & Charges 128,300.00 9,877.28 81,222.99 63.31 47,077.01 0.00 0.00 486.72 0.00 ( 486.72) 13,850.00 0.00 6,753.92 48.76 7,096.08 8,950.00 970.73 8,753.39 97.80 196.61 8,200.00 397.86 4,955.89 60.49 3,294.11 2,050.00 132.79 1,274.18 62.16 775.82 13,300.00 1,051.75 8,222.20 61.82 5,077.80 174,650.00 12,430.41 111,669.29 63.94 62,980.71 3,100.00 510.35 2,306.32 79.40 793.68 3,000.00 286.93 2,157.13 71.90 842.87 800.00 0.00 879.89 109.99 ( 79.89) 4,150.00 158.85 2,907.05 70.05 1,292.95 11,050.00 956.13 8,250.39 74.66 2,799.61 1,350.00 117.00 834.19 61.79 515.81 150.00 0.00 0.00 0.00 150.00 3,200.00 0.00 399.30 12.48 2,800.70 200.00 0.00 43.13 21.57 156.87 1,650.00 0.00 1,418.13 85.95 231.87 500.00 0.00 70.00 14.00 430.00 7,050.00 117.00 2,764.75 39.22 9,285.25 TOTAL Fire Inspections 192,750.00 13,503.54 122,684.93 63.65 70,065.57 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Emergency Management DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-4104 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-9-2330-4331 Travel, Conferences & Schools 101-4-2330-4359 Publishing 101-4-2330-4389 Utilities 101-4-2330-4404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 9,550.00 741.60 5,985.93 62.68 3,564.07 1,250.00 47.89 747.30 59.78 502.70 150.00 5.11 80.98 53.65 69.52 1,000.00 60.90 488.07 48.81 511.93 11,950.00 855.45 7,301.78 61.10 4,648.22 5,100.00 0.00 1,831.77 35.92 3,268.23 8,200.00 589.10 5,632.87 68.69 2,567.13 13,300.00 589.10 7,464.64 56.13 5,835.36 3,500.00 88.20 640.50 18.30 2,859.50 100.00 0.00 0.00 0.00 100.00 1,750.00 1,079.97 1,204.97 68.86 545.03 500.00 0.00 0.00 0.00 500.00 1,500.00 98.73 829.00 55.27 671.00 4,600.00 35.77 4,687.12 101.89 ( 87.12) 400.00 0.00 200.00 50.00 200.00 12,350.00 1,302.67 7,561.59 61.23 4,788.41 19,700.00 0.00 14,668.67 99.79 31.33 14,700.00 0.00 19,668.67 99.79 31.33 TOTAL Emergency Management 52,300.00 2,747.22 36,996.68 70.74 15,303.32 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Safety Building Safety DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4102 Overtime Pay 101-4-2410-4103 Part-time Pay 101-4-2910-4104 PERA 101-9-2410-4105 FICA 101-4-2410-9107 Medicare 101-4-2410-9108 Insurance 101-4-2910-4109 Workers Comp TOTAL Personal Services Supplies 101-9-2910-4201 Office Supplies 101-9-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2410-4319 Other Professional Services 101-4-2910-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-9359 Publishing 101-4-2910-4361 Insurance 101-9-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-9440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 101-4-2410-4560 Equipment TOTAL Capital Outlay TOTAL Building Safety 484,700.00 36,920.00 302,656.09 62.49 182,043.91 500.00 0.00 371.99 74.40 128.01 41,250.00 1,869.12 16,465.76 39.92 24,784.24 34,200.00 2,521.32 21,442.80 62.70 12,757.20 32,600.00 2,219.07 18,829.93 57.76 13,770.07 7,600.00 518.98 4,403.74 57.94 3,196.26 66,700.00 4,819.49 41,784.84 62.65 24,915.16 1,300.00 0.00 970.50 74.65 329.50 668,850.00 48,867.98 406,925.65 60.89 261,924.35 6,600.00 58.71 1,059.81 15.98 5,545.19 11,600.00 1,001.97 5,020.10 93.28 6,579.90 2,400.00 0.00 129.99 5.42 2,270.01 16,650.00 12.03 6,475.95 38.89 10,174.05 37,250.00 1,072.71 12,680.85 34.04 24,569.15 25,000.00 0.00 106.64 0.43 24,893.36 7,000.00 717.61 3,781.71 54.02 3,218.29 1,500.00 247.03 422.01 28.13 1,077.99 12,300.00 59.70 3,505.84 28.50 8,799.16 350.00 0.00 0.00 0.00 350.00 29,000.00 0.00 11,715.00 40.40 17,285.00 12,600.00 303.53 4,803.53 38.12 7,796.47 1,900.00 0.00 525.00 37.50 875.00 2,500.00 0.00 0.00 0.00 2,500.00 91,650.00 1,327.87 24,859.73 27.12 66,790.27 10,000.00 0.00 5,047.23 50.47 9,952.77 10,000.00 0.00 5,047.23 50.47 4,952.77 807,750.00 51,268.56 499,513.46 55.65 358,236.54 9-11-2008 01:32 PM 101-GENERAL FUND Public Safety Environmental DEPARTMENTAL EXPENDITURES PAGE: 27 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4104 PERA 101-9-2440-4105 FICA 101-4-2490-4107 Medicare 101-4-2440-4108 Insurance 101-4-2940-4109 Workers Comp TOTAL Personal Services Supplies 101-9-2490-4201 Office Supplies 101-4-2490-4212 Fuels & Lubs 101-4-2940-4217 Uniform Allowance TOTAL Supplies Other Services & Charges 101-4-2440-9321 Telephone 101-4-2440-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools 101-9-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2490-4904 Equip Repair/Maint Services 101-9-2440-4433 Dues & Subscriptions TOTAL Other Services & Charges 61,700.00. 4,371.44 35,197.62 56.97 26,552.38 4,000.00 284.14 2,495.95 62.40 1,504.05 3,850.00 176.29 1,762.71 45.78 2,087.29 900.00 41.21 412.21 45.80 987.79 9,350.00 686.28 9,733.49 104.10 ( 383.49) 350.00 0.00 249.00 71.14 101.00 80,150.00 5,559.31 49,800.98 62.13 30,349.02 1,200.00 13.97 151.62 12.64 1,048.38 1,000.00 39.44 34.44 3.49 965.56 200.00 0.00 0.00 0.00 200.00 2,400.00 48.41 186.06. 7.75 2,213.99 1,350.00 136.89 500.00 223.78 800.00 11.95 1,000.00 0.00 600.00 0.00 50.00 0.00 300.00 0.00 4,600.00 372.12 479.30 35.50 870.70 380.29 76.06 119.71 942.62 55.33 357.38 0.00 0.00 1,000.00 131.50 21.92 468.50 0.00 0.00 50.00 0.00 0.00 300.00. 1,433.71 31.17 3,166.29 SOTAL Environmental 87,150.00 5,979.89 51,420.75 59.00 35,729.25 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 TOTAL Public Safety 5,778,500.00 431,165.61 3,447,549.96 59.66 2,330,955.09 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 28 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Works Street Maintenance DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 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-9107 Medicare 101-4-3120-4108 Insurance 101-9-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 & Char es 101-9-3120-4319. Other Professional Services 101-9-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-9-3120-4361 Insurance 101-4-3120-9389 Utilities 101-4-3120-9401 Bldg Repair/Maint Services 101-9-3120-4409 Equip Repair/Maint Services 101-4-3120-4409 Contractual Services 101-4-3120-4415 Equipment Rental 101-4-3120-9417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-9-3120-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay TOTAL Street Maintenance 425,350.00 43,790.88 302,629.69 71.15 122,725.31 3,000.00 0.00 7,036.77 234.56 ( 4,036.77) 67,500.00 9,265.59 42,999.13 63.70 24,500.87 32,000.00 3,091.02 22,409.95 70.03 9,590.05 30,750.00 3,106.86 21,121.13 68.69 9,628.87 7,200.00 726.60 4,939.54 68.60 2,260.46 55,950.00 6,328.09 41,397.77 73.99 14,552.23 18,800.00 0.00 14,291.00 76.02 4,509.00 690,550.00 66,308.94 456,819.98 71.32 183,730.02 5,000.00 0.00 3,941.35 78.83 1,058.65 75,250.00 ( 1,846.23) 60,958.03 81.01 14,291.97 147,500.00 9,576.14 90,761.24 61.53 56,738.76 14,000.00 6,353.21 23,410.95 167.22 ( 9,410.95) 241,750.00 14,083.12 179,071.57 74.07 62,678.43 950.00 156.00 394.50 36.26 605.50 6,550.00 433.80 3,133.14 97.83 3,416.86 200.00 296.35 308.75 154.38 ( 108.75) 4,000.00 0.00 3,870.87 96.77 129.13 500.00 0.00 0.00 0.00 500.00 17,500.00 0.00 8,408.50 48.05 9,091.50 33,000.00 2,084.12 24,688.66 79.81 8,311.34 13,900.00 195.00 13,390.14 96.33 509.86 0.00 990.85 2,489.89 0.00 ( 2,489.84) 193,000.00 12,534.19 53,839.56 27.90 139,160.94 3,500.00 211.35 1,653.11 47.23 1,846.89 4,850.00 49.55 2,242.76 46.24 2,607.29 700.00 0.00 236.25 33.75 463.75 500.00 0.00 495.50 99.10 4.50 279,150.00 16,951.21 115,101.58 41.23 164,048.42 35,000.00 0.00 27,927.99 79.79 7,072.01 35,000.00 0.00 27,927.99 79.79 7,072.01 1,196,450.00 97,343.27 778,921.12 65.10 417,528.88 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 29 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Works Snow Removal DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67°s OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-9107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-9-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3130-4409 Contractual Services TOTAL Other Services & Charges 164,050.00 0.00 51,031.71 31.11 113,018.29 17,000.00 0.00 6,751.63 39.72 10,248.37 11,750.00 0.00 4,567.03 38.87 7,182.97 11,350.00 0.00 9,088.52 36.02 7,261.48 2,650.00 0.00 956.17 36.08 1,693.83 21,650.00 0.00 7,423.69 34.29 14,226.31 6,150.00 0.00 4,480.00 72.85 1,670.00 234,600.00 0.00 79,298.75 33.80 155,301.25 62,000.00 0.00 47,570.85 76.73 14,429.15 62,000.00 0.00 47,570.85 76.73 14,429.15 5,000.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Snow Removal 301,600.00 0.00 126,869.60 42.07 174,730.40 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 30 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Works Equipment Services DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-9102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-9-3150-4107 Medicare 101-4-3150-9108 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-4404 Equip Repair/Maint Services 101-9-3150-4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay 101-9-3150-4560 Equipment TOTAL Capital Outlay 159,750.00 12,337.60 109,962.26 68.83 49,787.74 2,500.00 0.00 1,034.45 41.38 1,465.55 10,550.00 801.94 7,982.57 70.92 3,067.43 10,050.00 688.08 6,495.01 64.63 3,554.99 2,350.00 160.92 1,519.06 64.64 830.99 22,800.00 1,827.01 17,411.61 76.37 5,388.39 4,900.00 0.00 3,693.00 75.37 1,207.00 212,900.00 15,815.55 147,597.96 69.33 65,302.04 22,550.00 809.33 13,490.66 59.83 9,059.34 12,000.00 0.00 288.17 2.90 11,711.83 34,550.00 804.33 13,778.83 39.88 20,771.17 2,000.00 0.00 65.55 3.28 1,934.45 1,350.00 272.54 1,767.67 130.94 ( 417.67) 3,350.00 272.54 1,833.22 54.72 1,516.78 30,000.00 0.00 0.00 0.00 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Equipment Services 280,800.00 16,892.42 163,210.01 58.12 117,589.99 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 31 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Public Works Engineering DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4102 Overtime Pay 101-9-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-9-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3300-4303 Engineering Fees 101-4-3300-4319 Other Professional Services 101-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-4-3300-9331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 34,450.00 0.00 12,894.55 37.43 21,555.45 0.00 0.00 83.98 0.00 ( 83.48) 2,250.00 0.00 852.44 37.89 1,397.56 2,150.00 0.00 850.56 39.56 1,299.94 500.00 0.00 198.89 39.78 301.11 5,200.00 0.00 2,381.25 45.79 2,818.75 100.00 0.00 22.00 22.00 78.00 44,650.00 0.00 17,283.17 38.71 27,366.83 750.00 13.97 284.02 37.87 965.98 500.00 52.17 259.52 51.90 240.98 3,000.00 0.00 2,450.61 81.69 549.39 4,250.00 66.14 2,994.15 70.45 1,255.85 84,000.00 2,618.00 35,057.04 41.73 48,942.96 35,000.00 0.00 0.00 0.00 35,000.00 750.00 87.19 511.67 68.22 238.33 100.00 329.43 329.93 329.93 ( 229.43) 5,000.00 0.00 3,575.00 71.50 1,425.00 300.00 0.00 0.00 0.00 300.00 500.00 0.00 2,002.00 900.40 ( 1,502.00) 125,650.00 3,034.62 41,475.14 33.01 84,174.86 TOTAL Engineering 174,550.00 3,100.76 61,752.46 35.38 112,797.54 TOTAL Public works 1,953,400.00 117,336.45 1,130,753.19 57.89 822,696.81 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 32 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Culture & Recreation Parks Department DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-4103 Part-time Pay 101-9-5110-4104 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-9109 Workers Comp 101-9-5110-4110 Re-employment compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5110-4319 Other Professional Services 101-4-5110-4321 Telephone 101-4-5110-4322 Postage 101-4-5110-9331 Travel, Conferences & Schools 101-4-5110-4359 Publishing 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-9401 Bldg Repair/Maint Services 101-4-5110-9404 Equip Repair/Maint Services 101-9-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4417 Uniform Rental TOTAL Other Services & Charges TOTAL Parks Department 301,150.00 27,785.18 207,765.15 68.99 93,384.85 7,650.00 24.55 687.79 8.99 6,962.21 55,100.00 11,150.90 41,597.75 75.50 13,502.25 23,550.00 1,871.04 13,960.64 59.28 9,589.36 22,450.00 2,306.26 14,709.25 65.52 7,740.75 5,250.00 539.39 3,440.10 65.53 1,809.90 43,300.00 3,661.07 28,001.67 64.67 15,298.33 6,100.00 0.00 4,571.00 74.93 1,529.00 0.00 5,285.00 5,285.00 0.00.( 5,285.00) 469,550.00 52,622.89 320,018.35 68.89 144,531.65 24,000.00 3,399.65 21,900.39 91.25 2,099.61 0.00 58.56 2,672.52 0.00 ( 2,672.52) 82,000.00 15,271.29 59,969.15 72.52 22,530.85 106,000.00 18,729.50 84,042.06 79.28 21,957.94 15,000.00 39.00 1,679.88 11.20 13,320.12 4,200.00 378.33 2,459.98 58.57 1,740.02 100.00 0.00 24.87 24.87 75.13 2,300.00 170.00 1,053.17 45.79 1,246.83 200.00 0.00 0.00 0.00 200.00 21,300.00 0.00 12,156.50 57.07 9,193.50 16,150.00 1,643.62 7,244.69 94.86 8,905.31 6,000.00 0.00 642.11 10.70 5,357.89 0.00 148.54 1,419.42 0.00 ( 1,919.92) 0.00 3,639.34 13,655.80 0.00 ( 13,655.80) 28,500.00 3,776.21 9,811.53 34.93 18,688.47 4,050.00 0.00 0.00 0.00 4,050.00 97,800.00 9,795.04 50,147.95 51.28 47,652.05 668,350.00 81,147.43 459,208.36 67.96 214,141.64 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 33 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Culture & Recreation Parks & Rec Admin DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-4102 Overtime Pay 101-9-5210-4103 Part-time Pay 101-4-5210-4104 PERA ld1-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-9-5210-4321 Telephone 101-9-5210-4322 Postage 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-4349 Advertising/Marketing 101-4-5210-9361 Insurance 101-4'-5210-4389 Utilities 101-4-5210-4401 Bldg Repair/Maint Services 101-4-5210-4909 Equip Repair/Maint Services 101-4-5210-4933 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Parks & Rec Admin 317,700.00 24,207.88 182,307.22 57.38 135,392.78 700.00 52.95 2,319.11 331.30 ( 1,619.11) 64,150.00 3,197.54 28,508.30 44.44 35,641.70 24,850.00 1,878.18 14,423.35 58.04 10,426.65 23,700.00 1,609.89 12,972.84 54.79 10,727.16 5,550.00 376.99 3,033.83 59.66 2,516.17 32,450.00 3,196.65 24,442.85 75.32 8,007.15 4,650.00 0.00 3,493.00 75.12 1,157.00 473,750.00 34,519.58 271,500.50 57.31 202,249.50 16,100.00 836.41 14,675.43 91.15 1,424.57 16,100.00 836.41 14,675.43 91.15 1,429.57 3,800.00 490.99 2,902.75 76.39 897.25 5,500.00 488.32 3,679.76 66.90 1,820.24 11,900.00 228.91 2,965.24 24.92 8,934.76 29,550.00 307.28 14,427.19 48.82 15,122.81 1,600.00 0.00 691.50 43.22 908.50 10,600.00 339.50 8,779.77 82.83 1,820.23 7,500.00 989.38 6,038.28 80.51 1,461.72 9,250.00 536.63 5,173.36 55.93 4,076.64 1,700.00 50.00 1,995.00 117.35 ( 295.00) 81,900.00 3,381.01 96,652.85 57.31 34,747.15 571,250.00 38,737.00 332,828.78 58.26 238,421.22 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 34 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Culture & Recreation Recreation Programs DEPARTMENTAL EXPENDITURES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5220-4101 Regular Pay 101-4-5220-4102 Overtime Pay 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare 101-4-5220-4108 Insurance TOTAL Personal Services Supplies 101-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5220-4404 Equip Repair/Maint Services 101-4-5220-4909 Contractual Services 101-4-5220-4912 Building Rent 101-4-5220-4438 Credit Card Fees 101-4-5220-4490 Miscellaneous TOTAL Other Services & Charges 0.00 0.00 3,266.10 0.00 ( 3,266.10) 0.00 0.00 24.30 0.00 ( 24.30) 88,500.00 12,563.86 52,643.08 59.98 35,856.92 1,050.00 80.64 1,347.53 128.34 ( 297.53) 5,500.00 783.17 3,567.39 64.86 1,932.61 1,300.00 183.17 834.37 64.18 465.63 0.00 0.00 483.13 0.00 ( 483.13) 96,350.00 13,610.84 62,165.90 64.52 34,184.10 27,000.00 7,763.81 27,859.79 103.18 ( 859.74) 27,000.00 7,763.81 27,859.74 103.18 ( 859.74) 400.00 0.00 357.00 89.25 43.00 51,500.00 7,062.80 23,273.65 45.19 28,226.35 4,000.00 2,460.00 4,968.25 124.21 ( 968.25) 2,500.00 86.13 2,247.81 89.91 252.19 10,000.00 0.00 10,002.00 100.02 ( 2.00) 68,400.00 9,608.93 90,848.71 59.72 27,551.29 TOTAL Recreation Programs 191,750.00 30,983.58 130,874.35 68.25 60,875.65 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 35 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Culture & Recreation 66.67$ OF YEAR COMP. Concessions CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 628.50 3,207.00 67.52 1,543.00 101-4-5230-4104 PERA 0.00 0.00 89.53 0.00 ( 89.53) 101-9-5230-4105 FICA 300.00 20.58 180.43 60.14 119.57 101-9-5230-4107 Medicare 100.00 4.81 92.19 42.19 57.81 TOTAL Personal Services 5,150.00 653.89 3,514.15 68.24 1,635.85 Supplies 101-4-5230-4219 Operating Supplies 600.00 209.05 346.74 57.79 253.26 101-9-5230-4259 Other Merchandise For Resale 13,000.00 948.38 4,276.71 32.90 8,723.29 TOTAL Supplies 13,600.00 657.43 4,623.45 34.00 8,976.55 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 18,850.00 1,311.32 8,137.60 43.17 10,712.90 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 36 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Culture & Recreation Sr Citizen Programs DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE I Personal Services 101-9-5510-4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-4103 Part-time Pay 101-4-5510-4104 PERA 101-9-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-9-5510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5510-9219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-9-5510-4331 Travel, Conferences & Schools 101-4-5510-4359 Publishing 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 68,400.00 4,024.00 31,936.08 46.69 36,463.92 500.00 0.00 0.00 0.00 500.00 55,100.00 4,236.96 33,089.25 60.05 22,010.75 8,050.00 536.96 4,310.47 53.55 3,739.53 7,700.00 489.90 3,938.10 51.14 3,761.90 1,800.00 113.42 921.09 51.17 878.91 12,250.00 996.81 8,274.98 67.55 3,975.52 650.00 0.00 500.25 76.96 149.75 154,950.00 10,393.05 82,969.72 53.72 71,480.28 13,600.00 770.12 .11,712.69 86.12 1,887.31 13,600.00 770.12 11,712.69 86.12 1,887.31 1,550.00 203.68 1,662.20 107.24 ( 112.20) 3,700.00 73.74 2,264.35 61.20 1,435.65 900.00 181.30 586.07 65.12 313.93 800.00 0.00 169.34 21.17 630.66 2,000.00 0.00 421.00 21.05 1,579.00 10,900.00 292.87 8,317.16 76.30 2,582.84 3,400.00 954.10 7,419.25 218.21 ( 4,019.25) 9,050.00 ( 79.48) 3,946.33 43.61 5,103.67 950.00 0.00 369.50 38.89 580.50 33,250.00 1,626.21 25,155.20 75.65 8,094.80 TOTAL Sr Citizen Programs 201,300.00 12,789.38 119,837.61 59.53 81,962.39 TOTAL Culture & Recreation 1,651,500.00 164,968.71 1,045,886.70 63.33 605,613.30 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 37 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Economic Development Economic Developement DEPARTMENTAL EXPENDITURES Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4102 Overtime Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare 101-4-6210-4108 Insurance TOTAL Personal Services Other Services & Charges 101-4-6210-4322 Postage 101-4-6210-4399 Advertising/Marketing 101-4-6210-9490 Miscellaneous SOTAL Other Services & Charges CURRENT CURRENT BUDGET PERIOD 66.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 0.00 9,939.00 20,585.52 0.00 ( 20,585.52) 0.00 0.00 ( 2,911.52) 0.00 2,411.52 0.00 1,142.24 4,522.98 0.00 ( 4,522.98) 0.00 659.88 1,379.59 0.00 ( 1,379.59) 0.00 634.31 1,301.75 0.00 ( 1,301.75) 0.00 148.32 304.36 0.00 ( 304.36) 0.00 1,261.01 2,522.02 0.00 ( 2,522.02) 0.00 13,784.76 28,204.70 0.00 ( 28,204.70) 0.00 143.75 143.75 0.00 ( 143.75) 0.00 41.28 0.00 0.00 0.00 0.00 ( 288.03) 39.75 0.00 ( 39.75) 0.00 ( 103.00) 183.50 0.00 ( 183.50) TOTAL Economic Developement 0.00 13,681.76 28,388.20 0.00 ( 28,388.20) 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 38 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 101-GENERAL FUND Economic Development Energy City DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6220-4101 Regular Pay 101-4-6220-4102 Overtime Pay 101-4-6220-4103 Part-time Pay 101-4-6220-4104 PERA 101-4-6220-4105 FICA 101-4-6220-4107 Medicare 101-4-6220-4108 Insurance TOTAL Personal Services Other Services & Charges 101-9-6220-4319 Other Professional Services 101-4-6220-4331 Travel, Conferences & Schools 101-4-6220-4359 Publishing TOTAL Other Services & Charges 25,750.00 1,783.36 12,683.91 99.26 13,066.59 0.00 0.00 1,063.30 0.00 ( 1,063.30) 26,300.00 0.00 1,258.56 4.79 25,041.94 3,400.00 115.92 682.35 20.07 2,717.65 3,200.00 97.92 559.01 17.47 2,640.99 750.00 22.90 130.70 17.43 619.30 3,950.00 261.25 1,272.11 36.87 2,177.89 62,850.00 2,281.35 17,649.44 28.08 95,200.56 2,000.00 30.00 9,250.16 462.51 ( 7,250.16) 23,000.00 32.72 3,215.65 13.98 19,784.35 5,500.00 0.00 5,553.75 100.98 ( 53.75) 30,500.00 62.72 18,019.56 59.08 12,480.44 TOTAL Energy City 93,350.00 2,394.07 35,669.00 38.21 57,681.00 TOTAL Economic Development 93,350.00 16,025.83 64,057.20 68.62 29,292.80 9-11-2008 01:32 PM 101-GENERAL FUND General TRANSFERS OUT DEPARTMENTAL EXPENDITURES Transfers Out 101-4-7000-4723 Transfer-Ice Arena 101-4-7000-4724 Transfer - Pinewood 101-4-7000-4730 Transfer-Debt Service TOTAL Transfers Out TOTAL TRANSFERS OUT CITY OF ELK RIVER PAGE: 39 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 134,650.00 0.00 0.00 0.00 134,650.00 67,200.00 0.00 0.00 0.00 67,200.00 66,600.00 0.00 66,600.00 100.00 0.00 268,450.00 0.00 66,600.00 24.81 201,850.00 268,450.00 0.00 66,600.00 24.81 201,850.00 TOTAL General 268,450.00 0.00 66,600.00 24.81 201,850.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,493,950.00 902,393.10 7,241,965.67 57.97 5,251,484.33 0.00 ( 811,013.22)( 928,829.57) 928,829.57 9-11-2008 01:32 PM 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library Library Project TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Library Library Project TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER PAGE: 90 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 86,350.00 118.25 46,841.38 59.25 39,508.62 0.00 0.00 222,749.51 0.00 ( 222,749.51) 86,350.00 118.25 269,590.89 312.21 ( 183,240.89) 86,350.00 3,292.05 143,576.93 166.27 ( 57,226.93) 0.00 1,723.34 7,840.30 0.00 ( 7,890.30) 86,350.00 5,015.39 151,417.23 175.35 ( 65,067.23) 86,350.00 5,015.39 151,417.23 175.35 ( 65,067.23) 0.00 ( 9,897.14) 118,173.66 ( 118,173.66) 9-11-2008 01:32 PM 211-LIBRARY I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 41 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Library Property Taxes 211-3-0000-3111 Current Ad Valorem Taxes 78,350.00 0.00 36,958.13 47.17 41,391.87 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 1,477.66 0.00 ( 1,477.66) TOTAL Property Taxes 78,350.00 0.00 38,435.79 49.06 39,914.21 Charges for Services 211-3-0000-3475 Building Rent 0.00 118.25 472.79 0.00 ( 972.74) TOTAL Charges for Services 0.00 118.25 472.74 0.00 ( 972.74) Other Revenue 211-3-0000-3621 Interest Income 8,000.00 0.00 7,932.85 99.16 67.15 TOTAL Other Revenue 8,000.00 0.00 7,932.85 99.16 67.15 TOTAL Library 86,350.00 118.25 46,841.38 59.25 39,508.62 Library Project Transfers In 211-3-5610-3927 Transfer-Govt Buildings Reserv 0.00 0.00 222,749.51 0.00 ( 222,749.51) TOTAL Transfers In 0.00 0.00 222,799.51 0.00 ( 222,749.51) TOTAL Library Project 0.00 0.00 222,749.51 0.00 ( 222,749.51) I TOTAL REVENUE 86,350.00 118.25 269,590.89 312.21 ( 183,240.89) 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 42 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services 211-4-5600-4101 Regular Pay 211-4-5600-4109 PERA 211-4-5600-4105 FICA 211-4-5600-4107 Medicare 211-4-5600-4108 Insurance 211-4-5600-4109 Workers Comp TOTAL Personal Services Supplies 211-4-5600-4201 Office Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 211-9-5600-4304 Legal Fees 211-4-5600-4321 Telephone 211-4-5600-4322 Postage 211-4-5600-4331 Travel, Conferences & Schools 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-9-5600-4401 Bldg Repair/Maint Services 211-9-5600-4404 Equip Repair/Maint Services 211-4-5600-4909 Contractual Services 211-4-5600-4933 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay Transfers Out 211-4-5600-4730 Transfer-Debt Service TOTAL Transfers Out CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 24,450.00 630.12 10,374.85 42.43 14,075.15 1,600.00 40.01 726.88 45.43 873.12 1,500.00 37.44 644.00 42.93 856.00 350.00 8.75 150.57 43.02 199.43 7,150.00 198.08 1,737.49 24.30 5,412.51 250.00 0.00 441.00 176.90 ( 191.00) 35,300.00 914.90 14,074.79 39.87 21,225.21 500.00 0.00 121.23 24.25 378.77 6,750.00 238.36 3,743.16 55.45 3,006.84 7,250.00 238.36 3,864.39 53.30 3,385.61 0.00 0.00 270.00 0.00 ( 270.00) 0.00 130.57 1,052.21 0.00 ( 1,052.21) 50.00 0.00 0.00 0.00 50.00 1,500.00 0.00 0.00 0.00 1,500.00 1,000.00 0.00 0.00 0.00 1,000.00 2,000.00 0.00 1,454.50 72.73 545..50 12,100.00 156.87 5,677.85 46.92 6,422.15 8,100.00 1,154.85 4,625.51 57.11 3,474.49 2,200.00 0.00 629.07 28.59 1,570.93 11,000.00 595.00 4,871.73 49.29 6,128.27 450.00 102.00 177.00 39.33 273.00 38,400.00 2,139.29 18,757.87 48.85 19,692.13 5,900.00 5,400.00 0.00 0.00 0.00 0.00 0.00 0.00 5,400.00 0.00 0.00 5,400.00 0.00 106,879.88 0.00 ( 106,879.88) 0.00 106,879.88 0.00 ( 106,879.88) TOTAL Library 86,350.00 3,292.05 143,576.93 166.27 ( 57,226.93) 9-1i-2008 01:32 PM 211-LIBRARY Culture & Recreation Library Project DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 93 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 211-4-5610-4303 Engineering Fees 0.00 795.54 5,344.01 0.00 ( 5,344.01) 211-4-5610-4319 Other Professional Services 0.00 927.80 2,284.29 0.00 ( 2,284.29) TOTAL Other Services & Charges 0.00 1,723.34 7,628.30 0.00 ( 7,628.30) Capital Outlay 211-4-5610-9520 Buildings & Structures 0.00 0.00 212.00 0.00 ( 212.00) TOTAL Capital Outlay 0.00 0.00 212.00 0.00 ( 212.00) TOTAL Library Project 0.00 1,723.34 7,840.30 0.00 ( 7,840.30) TOTAL Culture & Recreation 86,350.00 5,015.39 151,417.23 175.35 ( 65,067.23) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 86,350.D0 5,015.39 151,417.23 175.35 ( 65,067.23) 0.00 ( 4,897.14) 118,173.66 ( 118,173.66) 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 44 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 I 221-ICE ARENA FINANCIAL SUMMARY REVENUE SUMMARY Ice Arena Hockey Skating Concessions TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Ice Arena Hockey Skating Arena Concessions TOTAL Culture & Recreation TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 759,250.00 12,282.58 252,429.43 33.25 506,820.57 70,000.00 7,730.00 99,783.50 71.12 20,216.50 69,000.00 11,612.00 54,810.00 79.43 14,190.00 78,000.00 ( 8.12) 35,276.46 45.23 42,723.54 976,250.00 ------------- - 31,616.46 ------------ - 392,299.39 ------------ 40.18 ------- 583,950.61 ------------- 863,950.00 31,851.61 343,084.77 39.73 520,365.23 27,050.00 4,332.59 16,912.38 62.52 10,137.62 32,500.00 828.99 22,260.42 68.49 10,239.58 53,250.00 276.27 27,627.73 51.88 25,622.27 976,250.00 37,289.46 409,885.30 41.99 566,364.70 976,250.00 ------------- - ------------- - 37,289.46 ------------ - ------------ - 409,885.30 ------------ ------------ 41.99 ------- - ------- - 566,369.70 ------------ ------------ 0.00 ( 5,673.00)( 17,585.91) 17,585.91 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 45 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 ~ 221-ICE ARENA I REVENUES 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3469 Ice Rental 221-3-0000-3965 Admissions 221-3-0000-3966 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 Transfers In 221-3-0000-3921 Transfers 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In I TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3961 Recreation Fees TOTAL Charges for Services TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees 221-3-5420-3465 Admissions TOTAL Charges for Services 420,000.00 9,749.78 210,369.28 50.09 209,630.72 32,500.00 0.00 15,417.09 97.44 17,082..91 14,000.00 857.00 5,559.05 39.71 8,990.95 4,000.00 280.00 2,603.50 65.09 1,396.50 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 0.00 2,600.00 14.05 15,900.00 491,600.00 10,886.78 236,598.92 48.12 255,051.08 30,000.00 1,323.20 10,591.60 35.31 19,408.40 0.00 0.00 9,277.00 0.00 ( 9,277.00) 3,000.00 72.60 1,011.91 33.73 1,988.09 33,000.00 1,395.80 15,880.51 48.12 17,119.49 100,000.00 0.00 0.00 0.00 100,000.00 134,650.00 0.00 0.00 0.00 134,650.00 234,650.00 0.00 0.00 0.00 234,650.00 759,250.00 12,282.58 252,429.43 33.25 506,820.57 70,000.00 7,730.00 99,783.50 71.12 20,216.50 70,000.00 7,730.00 99,783.50 71.12 20,216.50 70,000.00 7,730.00 49,783.50 71.12 20,216.50 69,000.00 11,612.00 54,476.00 78.95 14,524.00 0.00 0.00 16.00 0.00 ( 16.00) 69,000.00 11,612.00 54,492.00 78.97 14,508.00 9-11-2008 01:32 PM 221-ICE ARENA I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 46 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue TOTAL Other Revenue TOTAL Skating Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services TOTAL Concessions 0.00 0.00 0.00 0.00 318.00 0.00 ( 318.00) 318.00 0.00 ( 318.00) 69,000.00 11,612.00 59,810.00 79.43 14,190.00 78,000.00 ( 8.12) 35,276.96 45.23 42,723.59 78,000.00 ( 8.12) 35,276.46 95.23 42,723.54 78,000.00 ( 8.12) 35,276.96 45.23 42,723.54 I TOTAL REVENUE 976,250.00 31,616.46 392,299.39 90.18 583,950.61 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 47 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 221-ICE ARENA Culture & Recreation Ice Arena DEPARTMENTAL EXPENDITURES 66.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 221-4-5400-4101 Regular Pay 221-4-5400-4102 Overtime Pay 221-4-5400-4103 Part-time Pay 221-4-5400-9104 PERA 221-4-5900-4105 FICA 221-4-5900-4107 Medicare 221-4-5400-4108 Insurance 221-4-5400-4109 Workers Comp TOTAL Personal Services Supplies 221-4-5400-4212 Fuels & Lubs 221-4-5400-4217 Uniform Allowance 221-4-5900-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-9319 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-9-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5900-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 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out 154,950.00 9,361.40 90,010.72 58.09 64,939.28 200.00 0.00 0.00 0.00 200.00 76,450.00 3,600.74 32,252.20 42.19 94,197.80 11,150.00 820.32 7,900.37 70.86 3,249.63 14,350.00 779.61 7,683.96 53.55 6,666.04 3,350.00 182.34 1,797.06 53.69 1,552.94 15,500.00 1,012.89 9,922.76 64.02 5,577.24 3,200.00 0.00 3,069.25 95.91 130.75 279,150.00 15,757.30 152,636.32 59.68 126,513.68 200.00 0.00 1,284.28 642.14 ( 1,084.28) 1,100.00 0.00 0.00 0.00 1,100.00 56,550.00 1,017.19 21,067.90 37.26 35,982.10 15,500.00 382.50 4,002.10 25.82 11,497.90 1,200.00 0.00 288.90 24.03 911.60 74,550.00 1,399.69 26,642.68 35.74 47,907.32 0.00 0.00 26.66 0.00 ( 26.66) 3,200.00 249.43 1,964.10 61.38 1,235.90 700.00 72.89 150.49 21.50 549.51 1,050.00 0.00 230.00 21.90 820.00 3,500.00 677.52 2,966.97 84.77 533.03 9,750.00 0.00 4,184.50 42.92 5,565.50 157,050.00 9,852.39 107,123.90 68.21 49,926.10 25,350.00 2,327.35 14,968.00 59.05 10,382.00 1,850.00 1,470.80 1,587.40 85.81 262.60 5,250.00 44.24 2,058.75 39.21 3,191.25 350.00 0.00 187.50 53.57 162.50 208,050.00 14,694.62 135,448.27 65.10 72,601.73 100,000.00 0.00 0.00 0.00 100,000.00 100,000.00 0.00 0.00 0.00 100,000.00 201,700.00 0.00 28,357.50 14.06 173,392.50 201,700.00 0.00 28,357.50 14.06 173,342.50 TOTAL Ice Arena 863,450.00 31,851.61 393,084.77 39.73 520,365.23 9-11-2008 01:32 PM 221-ICE ARENA Culture & Recreation Hockey DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 48 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-9-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-4322 Postage 221-4-5410-9359 Publishing 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges 3,600.00 2,799.00 2,799.00 77.75 801.00 200.00 173.54 173.59 86.77 26.46 50.00 40.59 40.59 81.18 9.41 3,850.00 3,013.13 3,013.13 78.26 836.87 12,000.00 0.00 8,196.71 68.31 3,803.29 12,000.00 0.00 8,196.71 68.31 3,803.29 500.00 0.00 85.85 17.17 414.15 1,800.00 281.26 706.20 39.23 1,093.80 7,800.00 532.80 2,984.60 38.26 4,815.90 1,100.00 505.40 1,925.89 175.08 ( 825.89) 11,200.00 1,319.46 5,702.54 50.92 5,497.46 I TOTAL Hockey 27,050.00 4,332.59 16,912.38 62.52 10,137.62 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 49 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 221-ICE ARENA Culture & Recreation Skating DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 66.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 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-4322 Postage 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges 20,000.00 360.50 12,865.63 64.33 7,134.37 500.00 23.44 619.20 123.84 ( 119.20) 1,250.00 22.35 797.67 63.81 452.33 300.00 5.22 186.57 62.19 113.43 22,050.00 411.51 19,469.07 65.62 7,580.93 6,200.00 0.00 5,952.35 87.99 747.65 6,200.00 0.00 5,452.35 87.99 747.65 200.00 0.00 0.00 0.00 200.00 1,200.00 0.00 388.73 32.39 811.27 1,100.00 203.20 711.20 64.65 388.80 1,750.00 214.28 1,239.07 70.80 510.93 4,250.00 417.48 2,339.00 55.09 1,911.00 TOTAL Skating 32,500.00 828.99 22,260.42 68.49 10,239.58 9-11-2008 01:32 PM 221-ICE ARENA Culture & Recreation Arena Concessions DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 50 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 268.00 12,675.74 60.65 221-4-5430-4105 FICA 1,300.00 6.70 857.72 65.98 221-4-5430-4107 Medicare 300.00 1.57 200.61 66.87 TOTAL Personal Services 22,500.00 276.27 13,734.07 61.04 Supplies 221-4-5430-4219 Operating Supplies 10,750.00 221-4-5430-4259 Other Merchandise For Resale 20,000.00 TOTAL Supplies 30,750.00 ~ TOTAL Arena Concessions ' TOTAL Culture & Recreation 8,765.93 0.00 26.20 0.24 10,723.80 0.00 13,867.46 69.34 6,132.54 0.00 13,893.66 45.18 16,856.39 53,250.00 276.27 27,627.73 51.88 25,622.27 976,250.00 37,289.46 409,885.30 41.99 566,364.70 I TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 976,250.00 37,289.46 409,885.30 41.99 566,369.70 0.00 ( 5,673.00)( 17,585.91) 17,585.91 8,224.26 442.28 99.39 9-11-2008 01:32 PM I 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 51 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY I Pinewood Golf Course TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 280,900.00 33,542.30 169,382.31 60.41 111,017.69 280,400.00 33,542.30 169,382.31 60.91 111,017.69 280,400.00 29,787.67 216,163.30 77.09 64,236..70 280,400.00 29,787.67 216,163.30 77.09 64,236.70 280,400.00 29,787.67 216,163.30 77.09 64,236.70 0.00 3,754.63 ( 46,780.99) 46,780.99 9-11-2008 01:32 PM ~ 222-PINEWOOD GOLF COURSE I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 52 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3967 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-3482 Advertising fee TOTAL Charges for Services Other Revenue 222-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 222-3-0000-3792 Cash Over TOTAL Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course 15,000.00 325.00 20,337.00 135.58 ( 5,337.00) 24,900.00 4,240.04 17,274.18 69.37 7,625.82 2,000.00 799.25 9,123.82 206.19 ( 2,123.82) 128,750.00 22,482.35 99,814.23 73.69 33,935.77 18,000.00 0.00 11,952.93 66.41 6,097.07 22,550.00 4,199.24 15,529.24 68.87 7,020.76 2,000.00 0.00 0.00 0.00 2,000.00 213,200.00 32,045.88 164,031.40 76.94 49,168.60 0.00 1,486.67 5,306.21 0.00 ( 5,306.21) 0.00 1,986.67 5,306.21 0.00 ( 5,306.21) 0.00 9.75 49.70 0.00 ( 94.70) 0.00 9.75 49.70 0.00 ( 44.70) 67,200.00 0.00 0.00 0.00 67,200.00 67,200.00 0.00 0.00 0.00 67,200.00 280,400.00 33,542.30 169,382.31 60.41 111,017.69 ~ TOTAL REVENUE 280,900.00 33,542.30 169,382.31 60.41 111,017.69 9-11-2008 01:32 PM 222-PINEWOOD GOLF COURSE Culture & Recreation Golf Course DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 53 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 222-4-5300-4101 Regular Pay 83,500.00 7,248.70 52,868.25 63.32 30,631.75 222-4-5300-4102 Overtime Pay 0.00 0.00 149.99 0.00 ( 149.99) 222-4-5300-4103 Part-time Pay 41,050.00 8,337.68 32,408.82 78.95 8,641.16 222-4-5300-4104 PERA 8,100.00 728.12 9,723.47 58.31 3,376.53 222-4-5300-4105 FICA 7,700.00 965.42 5,474.79 71.10 2,225.21 222-4-5300-4107 Medicare 1,600.00 225.78 1,280.35 71.13 519.65 222-4-5300-4108 Insurance 12,100.00 834.02 6,196.65 51.21 5,903.35 222-4-5300-4109 Workers Comp 900.00 0.00 761.25 84.58 138.75 222-4-5300-4110 Re-employment Compensation 0.00 105.73 690.81 0.00 ( 640.81) TOTAL Personal Services 155,150.00 18,495.45 104,504.38 67.36 50,645.62 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 35.13 3,499.21 77.76 1,000.79 222-9-5300-4217 Uniform Allowance 500.00 0.00 438.93 87.79 61.07 222-4-5300-4219 Operating Supplies 24,000.00 4,983.53 23,555.74 98.15 444.26 222-4-5300-4259 Other Merchandise For Resale 13,000.00 2,614.44 10,812.11 83.17 2,187.89 TOTAL Supplies 42,000.00 7,633.10 38,305.99 91.20 3,694.01 Other Services & Charges 222-4-5300-4321 Telephone 2,400.00 252.14 1,766.19 73.59 633.81 222-4-5300-9331 Travel, Conferences & Schools 900.00 3.63 173.86 19.32 726.14 222-4-5300-4399 Advertising/Marketing 1,500.00 0.00 1,035.60 69.04 464.40 222-4-5300-4361 Insurance 11,700.00 0.00 5,302.50 45.32 6,397.50 222-9-5300-4389 Utilities 6,200.00 828.31 3,334.00 53.77 2,866.00 222-4-5300-4901 Bldg Repair/Maint Services 2,500.00 19.97 506.83 20.27 1,993.17 222-4-5300-4404 Equip Repair/Maint Services 2,500.00 309.40 2,009.12 80.36 490.88 222-4-5300-4415 Equipment Rental 36,050.00 181.52 1,358.22 3.77 39,691.78 222-4-5300-4437 Taxes & Licenses 1,000.00 0.00 2,760.00 276.00 ( 1,760.00) 222-9-5300-4438 Credit Card Fees 2,500.00 698.15 2,957.02 118.28 ( 457.02) TOTAL Other S ervices & Charges 67,250.00 2,293.12 21,203.34 31.53 46,096.66 Capital Outlay 222-4-5300-4560 Equipment 16,000.00 0.00 17,516.11 109.48 ( 1,516.11) TOTAL Capital Outlay 16,000.00 0.00 17,516.11 109.48 ( 1,516.11) Debt Service 222-4-5300-9601 Principal 0.00 1,416.00 34,633.98 0.00 ( 34,633.48) TOTAL Debt Se rvice 0.00 1,416.00 39,633.98 0.00 ( 34,633.48) TOTAL Golf Course 280,400.00 29,787.67 216,163.30 77..09 64,236.70 TOTAL Culture & Recreation ^ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 280,400.00 29,787.67 216,163.30 77.09 64,236.70 280,400.00 29,787.67 216,163.30 77.09 64,236.70 0.00 3,754.63 ( 46,780.99) 96,780.99 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 54 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 223-SENIOR CITIZEN ACCOUNT FINANCIAL SUMMARY 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE.SUMMARY Sr Citizen Acct Sr Citizen Programs TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Sr Citizens Programs Ceramics Bingo TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 0.00 1,444.48 11,850.01 0.00 ( 11,850.01) 0.00 0.00 89.78 0.00 ( 89.78) 0.00 1,494.48 11,939.79 0.00 ( 11,939.79) 0.00 732.00 13,029.62 0.00 ( 13,029.62) 0.00 0.00 522.85 0.00 ( 522.85) 0.00 0.00 172.67 0.00 ( 172.67) 0.00 732.00 13,725.14 0.00 ( 13,725.14) 0.00 732.00 13,725.14 0.00 ( 13,725.14) 0.00 712.48 ( 1,785.35) 1,785.35 9-11-2008 01:32 PM 223-SENIOR CITIZEN ACCOUNT I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 55 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Sr Citizen Acct --------------- Charges for Services 223-3-0000-3462 Ceramics 223-3-0000-3463 Bingo TOTAL Charges for Services Other Revenue 223-3-0000-3621 Interest Income 223-3-0000-3626 Contributions 223-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue TOTAL Sr Citizen Acct Sr Citizen Programs Other Revenue 223-3-5510-3626 Contributions TOTAL Other Revenue TOTAL Sr Citizen Programs 0.00 29.00 66.00 0.00 ( 66.00) 0.00 113.00 415.50 0.00 ( 415.50) 0.00 142.00 481.50 0.00 ( 481.50) 0.00 0.00 410.03 0.00 ( 410.03) 0.00 329.48 5,099.48 0.00 ( 5,049.48) 0.00 973.00 5,909.00 0.00 ( 5,909.00) 0.00 1,302.48 11,368.51 0.00 ( 11,368.51) 0.00 1,444.48 11,850.01 0.00 ( 11,850.01) 0.00 0.00 89.78 0.00 ( 89.78) 0.00 0.00 89.78 0.00 ( 89.78) 0.00 0.00 89.78 0.00 ( 89.78) TOTAL REVENUE 0.00 1,944.48 11,939.79 0.00 ( 11,939.79) 9-11-2008 01:32 PM 223-SENIOR CITIZEN ACCOUNT Culture & Recreation Sr Citizens Programs DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008. PAGE: 56 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 223-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 223-4-5510-9409 Contractual Services TOTAL Other Services & Charges 0.00 102.00 10,474.50 0.00 ( 10,474.50) 0.00 102.00 10,474.50 0.00 ( 10,474.50) 0.00 630.00 2,555.12 0.00 ( 2,555.12) 0.00 630.00 2,555.12 0.00 ( 2,555.12) TOTAL Sr Citizens Programs 0.00 732.00 13,029.62 0.00 ( 13,029.62) 9-11-2008 01:32 PM 223-SENIOR CITIZEN ACCOUNT Culture & Recreation Ceramics DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 57 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 223-4-5520-4219 Operating Supplies TOTAL Supplies 0.00 0.00 0.00 522.85 0.00 ( 522.85) 0.00 522.85 0.00 ( 522.85) I TOTAL Ceramics 0.00 0.00 522.85 0.00 ( 522.85) 9-11-2008 01:32 PM 223-SENIOR CITIZEN ACCOUNT Culture & Recreation Bingo DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 58 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 223-4-5530-4219 Operating Supplies 0.00 0.00 172.67 0.00 ( 172.67) TOTAL Supplies 0.00 0.00 172.67 0.00 ( 172.67) TOTAL Bingo 0.00 0.00 172.67 0.00 ( 172.67) TOTAL Culture & Recreation 0.00 732.00 13,725.14 0.00 ( 13,725.14) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 0.00 732.00 13,725.19 0.00 ( 13,725.14) 0.00 712.48 ( 1,785.35) 1,785.35 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 59 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 I 225-PARK DEDICATION FUND FINANCIAL SUMMARY 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Park Dedication TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Parks Department TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 0.00 31,959.74 142,252.08 0.00 ( 142,252.08) 0.00 31,954.74 142,252.08 0.00 ( 142,252.08) 0.00 0.00 213,197.88 0.00 ( 213,197.88) 0.00 0.00 213,197.88 0.00 ( 213,197.88) 0.00 0.00 213,197.88 0.00 ( 213,197.88) 0.00 31,954.74 ( 70,945.80) 70,945.80 9-11-2008 01:32 PM CITY OF ELK RIVER PAGE: 60 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 ~ 225-PARK DEDICATION FUND ' REVENUES 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ^ Park Dedication Charges for Services 225-3-0000-3470 Park Dedication Fee 225-3-0000-3472 Park Use Fee TOTAL Charges for Services Other Revenue 225-3-0000-3621 Interest Income 225-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 225-3-0000-3921 Transfers TOTAL Transfers In TOTAL Park Dedication 0.00 32,070.60 90,977.60 0.00 ( 90,977.60) 0.00 ( 115.86) 3,560.94 0.00 ( 3,560.94) 0.00 31,954.74 94,538.59 0.00 ( 99,538.54) 0.00 0.00 2,647.54 0.00 ( 2,647.54) 0.00 0.00 66.00 0.00 ( 66.00) 0.00 0.00 2,713.54 0.00 ( 2,713.54) 0.00 0.00 45,000.00 0.00 ( 95,000.00) 0.00 0.00 45,000.00 0.00 ( 45,000.00) 0.00 31,954.74 142,252.08 0.00 ( 142,252.08) TOTAL REVENUE 0.00 31,954.74 142,252.08 0.00 ( 142,252.08) 9-11-2008 01:32 PM 225-PARK DEDICATION FUND Culture & Recreation Parks Department DEPARTMENTAL EXPENDITURES PAGE: 61 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 225-4-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 225-4-5110-4303 Engineering Fees 225-9-5110-4319 Other Professional Services 225-4-5110-4409 Contractual Services TOTAL Other Services & Charges Capital Outlay 225-4-5110-4510 Land 225-9-5110-4560 Equipment TOTAL Capital Outlay Debt Service 225-4-5110-4601 Principal 225-4-5110-4611 Interest TOTAL Debt Service TOTAL Parks Department 0.00 0.00 6,396.32 0.00 ( 6,396.32) 0.00 0.00 6,396.32 0.00 ( 6,396.32) 0.00 0.00 1,420.00 0.00 ( 1,420.00) 0.00 0.00 4,022.25 0.00 ( 4,022.25) 0.00 0.00 2,091.85 0.00 ( 2,041.85) 0.00 0.00 7,484.10 0.00 ( 7,484.10) 0.00 0.00 43,986.25 0.00 ( 43,486.25) 0.00 0.00 37,906.00 0.00 ( 37,406.00) 0.00 0.00 80,892.25 0.00 ( 80,892.25) 0.00 0.00 90,000.00 0.00 ( 90,000.00) 0.00 0.00 28,425.21 0.00 ( 28,925.21) 0.00 0.00 118,925.21 0.00 ( 118,425.21) 0.00 0.00 213,197.88 0.00 ( 213,197.88) TOTAL Culture & Recreation 0.00 0.00 213,197.88 0.00 ( 213,197.88) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 0.00 ---- - 0.00 ------------ 213,197.88 0.00 ( ------------- ------- 213,197.88) ------------- 0.00 31,959.74 ( 70,945.80) 70,945.80 9-11-2008 01:32 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 228-LANDFILL FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD PAGE: 62 66.67°s OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE REVENUE SUMMARY Landfill TOTAL REVENUES EXPENDITURE SUMMARY General Section 125 TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 80,000.00 0.00 37,190.10 46.49 42,809.90 80,000.00 0.00 37,190.10 46.49 42,809.90 264,500.00 3,100.20 73,293.97 27.71 191,206.53 264,500.00 3,100.20 73,293.47 27.71 191,206.53 264,500.00 ------------- -- ------------- -- 3,100.20 ----------- -- ----------- -- 73,293.47 27.71 ----------- ------- - ----------- ------- - 191,206.53 ------------ ------------ ( 184,500.00)( 3,100.20)( 36,103.37) ( 148,396.63) 9-11-2008 01:32 PM 228-LANDFILL I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 PAGE: 63 66.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Landfill Intergovernmental Rev Other Revenue 228-3-0000-3621 Interest Income TOTAL Other Revenue TOTAL Landfill 80,000.00 0.00 37,190.10 46.49 42,809.90 80,000.00 0.00 37,190.10 46.49 42,809.90 80,000.00 0.00 37,190.10 46.49 42,809.90 I TOTAL REVENUE 80,000.00 0.00 37,190.10 46.49 42,809.90 9-11-2008 01:32 PM 228-LANDFILL General Section 125 DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 64 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2008 66.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 228-4-7000-4101 Regular Pay 228-4-7000-4104 PERA 228-4-7000-4105 FICA 228-4-7000-4107 Medicare 228-4-7000-4108 Insurance TOTAL Personal Services Supplies 228-4-7000-4219 Operating Supplies TOTAL Supplies Other Services & Charges 228-4-7000-4309 Legal Fees 228-4-7000-4319 Other Professional Services 228-4-7000-4389 Utilities 228-4-7000-4409 Contractual Services 228-4-7000-4440 Miscellaneous TOTAL Other Services & Charges Transfers Out 228-4-7000-4720 Transfers 228-4-7000-4721 Transfer-General Fund TOTAL Transfers Out 18,100.00 1,179.84 6,893.52 38.09 11,206.48 1,200.00 76.69 999.60 83.30 200.40 1,150.00 65.16 742.37 64.55 407.63 250.00 15.25 173.64 69.46 76.36 2,300.00 138.40 2,416.29 105.05 ( 116.24) 23,000.00 1,475.34 11,225.37 48.81 11,774.63 45,000.00 953.04 28,613.80 63.59 16,386.20 45,000.00 953.04 28,613.80 63.59 16,386.20 20,000.00 0.00 0.00 0.00 20,000.00 50,000.00 0.00 1,764.88 3.53 98,235.12 1,500.00 617.76 3,397.68 226.51 ( 1,897.68) 60,000.00 0.00 1,060.00 1.77 58,940.00 0.00 54.06 151.74 0.00 ( 151.79) 131,500.00 671.82 6,374.30 4.85 125,125.70 30,000.00 0.00 27,080.00 90.27 2,920.00 35,000.00 0.00 0.00 0.00 35,000.00 65,000.00 0.00 27,080.00 41.66 37,920.00 TOTAL Section 125 269,500.00 3,100.20 73,293.47 27.71 191,206.53 TOTAL General 264,500.00 3,100.20 73,293.47 27.71 191,206.53 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 264,500.00 3,100.20 73,293.47 27.71 191,206.53 ( 184,500.00)( 3,100.20)( 36,103.37) ( 148,396.63)