Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #2 12-15-2008
~, ~.~~~.~IATi~ ~~~~ c ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: December 15, 2008 SUBJECT: November 2008 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Pinewood Golf and Ice Arena special revenue funds. These funds are the primary concern in analyzing the City's financial health. For the month of November, actual revenues (except for property taxes and state aids) and expenditures should generally run about 92% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Kevenue.r: • The second half tax settlement will not be received until December and our largest revenue source is just under 50% collected to date. • The second half local government aid will not be received until December. • License and permit revenues are at least $240,000 under budget due to the slowdown in construction activity. • Charges for services and fines axe lagging behind budget because of decreased building activity and lower than expected recreation fees and court fines. E.xpenditure.r: • Excluding transfers, the total departmental expenditures are at about 84% and most departments axe well within or below budget. • Fire personal services are over budget as a result of the Lion's Park apartment fire. • Personal services in Street Maintenance are 5% over budget and Equipment Services is slightly above the benchmark comparison due to the late arrival of the snow season this year. However, there is a corresponding reduction in personal services expenditures in the Snow Removal budget, so when looked at collectively it is about 89% of annual budget and within the 92% of budget. • Park Maintenance has expended more than 92% of their budget due mainly to the seasonal expenses of the department and higher fuel costs earlier in the year. • The transfers out to the Ice Arena and Pinewood Golf will be made at year end once amounts axe finalized. Ice Arena Revenues are at 64% of budget and slightly below last year's comparison of 70%. November ice rental has yet to be invoiced, so much of the ice rental and concession revenue from hockey games will be generated through the end of the year. The operating transfer in from the General Fund will be made at year end. Overall expenditures axe about 69% of the annual budget and are slightly above revenues generated. The transfer for Ice Arena debt service payment of $173,357.50 will be made in December. Pinewood Golf Golf revenues for the season are only at 86% of budgeted revenues, but are 10% over last years comparison. Recreation fees for youth leagues were higher than expected while green fees and memberships were below the projected budget. The operating transfer in from the General Fund will be made at year end. Expenditures are about 3% over the annual budget due mainly to the increased purchases of supplies and fertilizer. 12-09-2008 03:09 PM FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH CITY OF ELK RIVER POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2008 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 343-1010 Cash - 1996C Ice Arena Bonds 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 PAGE: 1 BEGINNING CURRENT CURRENT BALANCE ACTIVITY BALANCE 26,241. 54 ( 2,285. 95) 23,955. 59 2,799,001. 27 ( 847,999. 70) 1,951,001. 57 369,302. 95 ( 13,446. 32) 355,856. 63 ( 20,196. 87) 2,474. 88 ( 17,721. 99) ( 80,139. 22) ( 14,953. 74) ( 95,092. 96) 11,006. 35 ( 977. 77) 10,028. 58 ( 14,496. 16) ( 14. 97) ( 14,511. 13) 1,381,569. 93 4,638. 68 1,386,208. 61 653,104. 27 0. 00 653,104. 27 724,292. 70 3,179. 22 727,471. 92 140,549. 39 0. 00 140,549. 39 134,264. 64 ( 7,681. 24) 126,583. 40 2,194,504. 38 13,106. 98 2,207,611. 36 561,993. 72 ( 41,672. 99) 520,320. 73 1,965,938. 20 ( 24,410. 79) 1,991,527. 41 10,556. 07 4,615. 02 15,171. 09 135,917. 71 0. 00 135,917. 71 521,799. 55 0. 00 521,799. 55 13,245. 49 0. 00 13,245. 49 200,537. 43 0. 00 200,537. 43 161,408. 33 0. 00 161,408. 33 307,392. 90 11,700. 00 319,092. 90 48,598. 42 0. 00 48,598. 42 125,286. 28 0. 00 125,286. 28 339,772. 96 0. 00 339,772. 96 184,400. 47 0. 00 184,400. 47 0 .00 ( 144,225. 00) ( 144,225. 00) 1,706,486 .53 1,080 .00 1,707,566 .53 2,876,548 .15 56,751 .57 2,933,299 .72 156,161 .43 ( 15,580 .96) 140,580 .47 262,057 .80 0 .00 262,057 .80 3,088,553 .82 21,573 .18 3,110,127 .00 1,170,222 .41 0 .00 1,170,222 .41 ( 493,035 .62) ( 32,272 .90) ( 525,308 .52) 91,784 .11 ( .3,927 .08) 87,857 .03 1,652,830 .07 0 .00 1,652,830 .07 ( 1,749 .32) ( 138 .75) ( 1,888 .07) 4,235,237 .53 ( 399,310 .37) 3,835,927 .16 3,108,898 .18 45,900 .85 3,154,799 .03 295,648 .18 ( 698 .03) 294,950 .15 0 .00 133,059 .63 133,059 .63 135,844 .68 ( 34,255 .19) 101,589 .49 31,181,340 .65 ( 1,285,771.74) 29,895,568 .91 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND FINANCIAL SUMMARY 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE a OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,490,450.00 47,662.14 7,020,977.70 56.21 5,969,472.30 TOTAL REVENUES 12,490,450.00 47,662.14 .7,020,.977.70 56.21 5,469,472.30 EXPENDITURE SUMMARY General Government Mayor & Council 221,100.00 39,991.04 159,183.11 69.73 66,916.89 Cable TV 99,250.00 4,943.17 61,777.24. 62.29 37,972.76 Administrative Services 457,750.00 43,081.62 409,935.81 89.55 47,814.19 Human Resources 156,900.00 10,592.54 126,213.42 80.44 30,686.58 Elections 40,850.00 16,796.78 33,026.92 80.85 7,823.08 Finance 439,450.00 27,380.08 388,433.62 89.41 46,016.38 Information Technology 256,250.00 12,991.98 164,356.19 64.14 91,893.86 Legal 234,700.00 ( 21,997.04) 140,856.24 60.02 93,843.76 Community Development 158,550.00 12,807.50 108,131.45 68.20 50,418.55 Planning 328,950.00 15,835.39 223,255.07 67.97 105,199.93 City Hall Maintenance 300,000.00 19,889.19 271,278.16 90.43 28,721.84 Contingency 60,000.00 0.00 1,573.12 2.62 58,426.88 TOTAL General Government 2,748,250.00 182,312.25 2,083,020.30 75.79 665,229.70 Public Safety Police Administration 639,850.00 38,655.77 570,123.76 89.10 69,726.29 Patrol 2,200,800.00 147,073.38 1,858,782.03 84.96 342,017.97 Investigations 679,650.00 48,429.63 578,052.86 85.68 96,597.14 Police Support Services 463,800.00 34,229.95 409,695.00 88.33 54,105.00 Police Reserves 25,900.00 262.66 17,278.00 66.71 8,622.00 Public safety building 187,050.00 12,699.30 151,640.18 81.07 35,409.82 Fire Administration 446,500.00 30,652.53 434,204.21 97.25 12,295.79 Fire Inspections 192,750.00 13,246.41 166,549.25 86.41 26,200.75 Emergency Management 52,300.00 1,267.25 93,066.20 82.34 9,233.80 Building Safety 807,750.00 65,884.51 645,253.93 79.88 162,496.07 Environmental 87,150.00 6,269.68 72,863.99 83.61 14,286.01 TOTAL Public Safety 5,778,500.00 398,666.07 9,947,509.41 85.62 830,990.59 Public Works Street Maintenance 1,196,450.00 105,727.59 1,160,004.91 96.95 36,445.09 Snow Removal 301,600.00 20,331.96 149,037.56 49.42 152,562.49 Equipment Services 280,800.00 16,642.08 230,308.63 82.02 50,491.37 Engineering 179,550.00 5,494.92 82,291.11 47.14 92,258.89 TOTAL Public Works 1,953,900.00 148,146.05 1,621,642.21 83.02 331,757.79 12-09-2008 03:08PM ~ CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND FINANCIAL SUMMARY 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 668,350.00 59,670.14 649,842.66 97.23 18,507.34 Parks & Rec Admin 571,250.00 39,931.05 477,233.33 83.54 94,016.67 Recreation Programs 191,750.00 13,366.18 180,006.23 93.88 11,743.77 Concessions 18,850.00 298.18 12,962.20 68.76 5,887.80 Sr Citizen Programs 201,300.00 15,391.17 169,693.43 89.30 31,606.57 TOTAL Culture & Recreation 1,651,500.00 123,656.72 1,989,737.85 90.21 161,762.15 Economic Development Economic Developement 0.00 ( 11,537.32) 34,672.78 0.00 ( 39,672.78) Energy City 93,350.0'0 3,572.50 45,324.42 48.55 48,025.58 TOTAL Economic Development 93,350.00 ( 7,964.82) 79,997.20 85.70 13,352.80 General Transfers Out 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 12,493,450.00 849,816.27 10,288,506.97 82.35 2,204,943.03 REVENUES OVER/(UNDER) EXPENDITURES ( 3,000.00)( 797,154.13)( 3,267,529.27) 3,264,529.27 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND REVENUES CURRENT CURRENT BUDGET PERIOD 91.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE General Fund Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3112 Delinquent Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3131 Penalties/Interest TOTAL Property Taxes Linceses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 Amusement License 101-3-0000-3213 Cigarette License 101-3-0000-3219 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-3322 MV Credit 101-3-0000-3324 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 9,139,350.00 0.00 4,332,410.71 0.00 0.00 89,399.90 50,000.00 0.00 23,967.73 0.00 0.00 2,708.11 9,189,350.00 0.00 4,443,486.45 50,250.00 0.00 51,202.50 1,000.00 420.00 465.00 3,500.00 1,050.00 3,.050.00 15,850.00 0.00 15,165.00 9,000.00 0.00 20,385.70 1,800.00 315.00 3,530.00 13,000.00 3,425.00 10,685.00 12,400.00 0.00 4,375.00 410,250.00 19,333.95 247,295.94 140,000.00 2,401.43 63,359.39 1,400.00 ( 256.56) 2,693.65 200.00 0.00 0.00 2,000.00 190.00 3,000.50 5,600.00 0.00 1,458.32 10,000.00 ( 500.00) 7,839.64 676,250.00 26,328.32 434,505.64 97.40 4,806,939.29 0.00 ( 84,399.90) 97.94 26,032.27 0.00 ( 2,708.11) 98.35 4,745,863.55 101.90 46.50 87.14 95.68 226.51 196.11 82.19 35.28 60.28 95.26 192.40 0.00 150.03 26.04 952.50) 535.00 450.00 685.00 11,385.70) 1,730.00) 2,315.00 8,025.00 162,954.06 76,640.61 1,293.65) 200.00 1,000.50) 4,141.68 2,160.36 64.25 241,744.36 686,800.00 0.00 343,410.00 50.00 343,390.00 0.00 0.00 170,453.13 0.00 ( 170,453.13) 19,000.00 0.00 6,992.00 49.99. 7,008.00 210,000.00 0.00 200,903.00 95.43 9,597.00 10,000.00 0.00 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 11,611.53 68.30 5,388.97 2,600.00 0.00 0.00 0.00 2,600.00 976,900.00 0.00 784,575.75 80.31 192,324.25 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 100.00 18,418.50 73.67 6,581.50 101-3-0000-3413 Plan Check Fee 260,000.00 9,885.44 111,336.21 42.82 148,663.79 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 300.00 30.00 700.00 101-3-0000-3417 Copies 1,500.00 252.73 2,492.88 166.19 ( 992.88) 101-3-0000-3418 Other General Govt Services 3,500.00 105.00 3,257.30 93.07 242.70 101-3-0000-3430 Lockout Fees 8,500.00 590.00 7,115.00 83.71 1,385.00 101-3-0000-3431 Police Services 2,500.00 270.00 52,689.34 2,107.57 ( 50,189.34) 101-3-0000-3432 School Liaison 75,000.00 0.00 75,000.00 100.00 0.00 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERA, FUND REVENUES 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3434 Animal Impound Fee 101-3-0000-3935 Vehicle Impound 101-3-0000-3436 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-3975 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3984 Contractor License Check TOTAL Charges for Services 2,750.00 50.00 3,.090.00 0.00 0.00 98.25 180,000.00 0.00 196,895.00 2,500.00 0.00 3,375.00 28,000.00 283.00 26,869.29 130,000.00 749.00 111,569.25 19,500.00 ( 115.45) 13,304.19 7,900.00 487.51 17,290.27 0.00 759.95 4,501.53 0.00 200.00 2,200.00 10,000.00 100.00 2,610.00 1,500.00 5.00 440.00 759,150.00 13,782.18 652,802.01 112.36 ( 340.00) 0.00 ( 98.25) 109.36 ( 16,845.00) 135.00 ( 875.00) 95.96 1,130.71 85.82 18,430.75 68.23 6,195.81 218.86 ( 9,390.27) 0.00 ( 9.,501.53) 0.00 ( 2,200.00) 26.10 7,390.00 29.33 1,060.00 85.99 106,397.99 Fines, Fees, & Forfeit 101-3-0000-3510 Court Fines 155,000.00 11,745.29 105,036.81 67.77 49,963.19 101-3-0000-3511 Parking Fines 5,000.00 130.00 8,445.00 168.90 ( 3,945.00) TOTAL Fines, Fees, & Forfeit 160,000.00 11,875.24 113,481.81 70.93 46,518.19 Other Revenue 101-3-0000-3621 Interest Income 200,000.00 0.00 151,789.32 75.89 48,210.68 101-3-0000-3625 Refunds & Reimbursements 45,000.00 ( 5,631.07)( 2,997.88) 6.66- 47,9.97.88 101-3-0000-3626 Contributions 7,800.00 1,223.00 2,622.00 33.62 5,178.00 101-3-0000-3629 Miscellaneous Revenue 3,000.00 89.97 2,712.60 90.92 287.40 TOTAL Other Revenue 255,800.00 ( 4,323.60) 159,126.04 60.25 101,673.96 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 35,000.00 0.00 0.00 0.00 35,OOO.D0 39,500.00 0.00 39,500.00 100.00 0.00 41,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 473,000.00 0.00 438,000.00 92.60 35,000.00 TOTAL General Fund .12,490,450.00 47,662.14 7,020,977.70 56.21 5,469,472.30 TOTAL REVENUE 12,490,450.00 47,662.14 7,020,977.70 56.21 5,469,972.30 12-09-2008 03:08 PM REVENUE 101-GENERAL FUND DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 1.67$ $ OF BUDGET PAGE: 5 F YEAR COMP. BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,192.33 35,293.85 91.54 3,256.15 101-4-1110-4104 PERA 1,950.00 101.29 1,470.60 75.42 479.40 101-9-1110-4105 FICA 2,400.00 161.26 2,111.75 87.99 288.25 101-4-1110-4107 Medicare 550.00 37.84 499.13 89.84 55.87 101-4-1110-4109 Workers Comp 50.00 0.00 37.00 74.00 13.00 TOTAL Personal Services 43,450.00 3,493.22 39,357.33 90.58 4,092.67 Supplies 101-4-1110-4201 Office Supplies 3,200.00 0.00 253.19 7.91 2,946.86 TOTAL Supplies 3,200.00 0.00 253.14 7.91 2,946.86 Other Services & Charges 101-9-1110-4319 Other Professional Services 28,250.00 1,500.20 11,331.35 40.11 16,918.65 101-4-1110-4322 Postage 800.00 0.00 227.33 28.42 572.67 101-4-1110-4331 Travel., Conferences & Schools 8,500.00 48.00 1,503.05 17.68 6,996..95 101-4-1110-4359 Publishing 28,000.00 3,536.62 13,358.53 47.71 14,641.47 101-9-1110-4361 Insurance 81,300.00 31,312.00 61,741.00 75.94 19,559.00 101-4-1110-4433 Dues ~ Subscriptions 19,100.00 0.00 19,514.00 102.17 ( 419.00) 101-4-1110-4490 Miscellaneous 8,500.00 101.00 6,897.38 81.15 1,602.62 TOTAL Other Services & Charges 174,950.00 36,497.82 114,572.64 65.68 59,877.36 TOTAL Mayor & Council 221,100.00 39,991.04 154,183.11 69.73 66,916.89 Cable TV Personal Services 101-9-1120-4101 Regular Pay 56,550.00 3,697.60 41,941.86 74.17 14,608.14 101-4-1120-4102 Overtime Pay 2,000.00 0.00 10.20 0.51 1,989.80 101-4-1120-4103 Part-time Pay 18,800.00 153.13 7,195.08 38.27 11,604.92 101-4-1120-4104 PERA 5,050.00 240.34 3,222.62 63.81 1,827.38 101-4-1120-4105 FICA 9,800.00 238.73 3,045.84 63.96 1,754.16 101-4-1120-4107 Medicare 1,100.00 55.84 712.40 64.76 387.60 101-9-1120-4108 Insurance 7,300.00 417.01 4,938.06 67.64 2,361.94 101-9-1120-4109 Workers Comp 150.00 0.00 169.00 109.33 ( 19.00) TOTAL Personal Services 95,750.00 4,802.65 61,230.06 63.95 39,519.94 Supplies 101-4-1120-4201 Office Supplies 2,100.00 190.52 279.39 13.30 1,820.61 TOTAL Supplies 2,100.00 140.52 279.39 13.30 1,820.61 12-09-2008 03:08 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND General Government CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL PAGE: 6 91.67 OF YEAR COMP. ~ OF BUDGET BUDGET BALANCE Other Services & Charges 101-4-1120-9319 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 500.00 0.00 0.00 0.00 500.00 0.00 0.00 16.96 0.00 ( 16.96) 800.00 0.00 250.83 31.35 549.17 100.00 0.00 0.00 0.00 100.00 1,400.00 0.00 267.79 19.13 1,132.21 TOTAL Cable TV Administrative Services Personal Services 101-4-1210-4101 Regular Pay 101-4-1210-4102 Overtime Pay 101-4-1210-4103 Part-time Pay 101-4-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-9331 Travel, Conferences & Schools 101-4-1210-4361 Insurance 101-4-1210-4409 Equip Repair/Maint Services 101-4-1210-9433 Dues & Subscriptions TOTAL Other Services & Charges 99,250.00 4,943.17 61,777.24 62.24 37,972.76 283,500.00 22,061.12 254,451.92 89.75 29,048.08 2,000.00 0.00 179.93 9.00 1,820.07 44,250.00 3,586.44 40,755.00 92.10 3,495.00 21,300.00 1,667.08 19,668.64 92.34 1,631.36 20,300.00 1,370.16 18,343.32 90.36 1,956.68 4,800.00 400.00 4,400.00 91.67 400.00 4,750.00 366.54 4,336.16 91.29 413.84 24,900.00 1,860.04 20,686.16 83.08 4,213.89 1,200.00 0.00 1,251.00 104.25 ( 51.00) 407,000.00 31,311.38 364,072.13 89.45 92,927.87 13,400.00 728.97 8,596.60 63.78 9,853.40 13,400.00 728.97 8,546.60 63.78 4,853.40 900.00 3,454.38 6,166.88 685.21 ( 5,266.88) 350.00 65.24 685.93 195.98 ( 335.93) 1,700.00 0.00 693.41 40.79 1,006.59 6,850.00 56.25 2,224.34 32.47 9,625.66 200.00 112.00 203.00 101.50 ( 3.00) 24,800.00 7,353.90 26,523.52 106.95 ( 1,723.52) 2,550.00 0.00 820.00 32.16 1,730.00 37,350.00 11,041.27 37,317.08 99.91 32.92 TOTAL Administrative Services Human Resources 457,750.00 43,081.62 409,935.81 89.55 47,814.19 12-09-2008 03:08 PM ~ CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4102 Overtime Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charqes 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges CURRENT CURRENT BUDGET PERIOD 91.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 118,550.00 5,142.08 59,145.71 49.89 59,404.29 0.00 0.00 367.94 0.00 ( 367.94) 0.00 3,601.89 90,356.17 0.00 ( 40,356.17) 7,700.00 568.36 6,578.03 85.43 1,121.97 7,350.00 536.48 6,219.87 84.62 1,130.13 1,700.00 125.47 1,454.63 85.57 245.37 10,300.00 417.01 4,887.11 47.45 5,412.89 450.00 0.00 492.50 98.33 7.50 146,050.00 10,391.29 119,451.96 81.79 26,598.04 4,350.00 4,350.00 3,000.00 350.00 2,550.00 600.00 0.00 6,500.00 131.90 4,075.17 93.68 131.90 4,075.17 93.68 274.83 0.00 250.00 8.33 2,750.00 0.00 185.85 53.10 164.15 0.00 1,176.04 46.12 1,373.96 0.00 250.00 41.67 350.00 69.35 829.40 0.00 ( 824.40) 69.35 2,686.29 91.33 3,813.71 I TOTAL Human Resources Elections Personal Services 101-4-1230-4103 Part-time Pay TOTAL Personal Services Supplies 101-4-1230-4219 Operating Supplies TOTAL Supplies Other Services & Charqes 101-4-1230-4322 Postage 101-4-1230-4331 Travel, Conferences & Schools 101-4-1230-4359 Publishing 101-4-1230-4415 Equipment Rental TOTAL Other Services & Charges 156,900.00 10,592.54 126,213.42 80.44 30,686.58 30,000.00 15,568.30 26,971.84 89.91 3,028.16 30,000.00 15,568.30 26,971.84 89.91 3,028.16 7,000.00 873.15 5,120.55 73.15 1,879.45 7,000.00 873.15 5,120.55 73.15 1,879.45 350.00 0.00 159.84 45.67 190.16 700.00 28.08 98.46 19.07 601.54 2,000.00 327.25 676.23 33.81 1,323.77 800.00 0.00 0.00 0.00 800.00 3,850.00 355.33 934.53 24.27 2,915.47 274.83 TOTAL Elections 40,850.00 16,796.78 33,026.92 80.85 7,823.08 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Finance Personal Services 101-4-1310-4101 Regular Pay 101-9-1310-4103 Part-time Pay 101-4-1310-4104 PERA 101-4-1310-4105 FICA 101-9-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 & Char es 101-4-1310-4301 Audit Fees 101-4-1310-4319 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-9-1310-4904 Equip Repair/Maint Services 101-4-1310-4433 Dues & Subscriptions 101-4-1310-9440 Miscellaneous TOTAL Other Services & Charges 270,200.00 21,193.50 243,073.25 89.96 27,126.75 5,000.00 265.00 3,565.00 71.30 1,935.00 17,900.00 1,353.96 16,207.79 90.55 1,692.21 17,050.00 1,218.73 19,797.93 86.50 2,302.07 4,000.00 285.02 3,949.19 86.23 550.81 25,450.00 1,860.04 21,690.41 85.23 3,759.59 1,000.00 0.00 1,052.00 105.20 ( 52.00) 340.,600.00 26,176.25 303,785.57 89.19 36,819.43 5,800.00 490.29 3,862.89 66:60 1,937.11 5,800.00 490.29 3,862.89 66.60 1,937.11 20,500.00 0.00 17,800.00 86.83 2,700.00 51,700.00 0.00 46,687.00 90.30 5,013.00 0.00 67.19 636.26 0.00 ( 636.26) 2,500.00 0.00 2,336.25 93.45 163.75 9,000.00 600.40 3,850.89 96.27 149.11 1,000.00 0.00 1,596.38 159.64 ( 596.38) 6,500.00 0.00 6,404.38 98.53 95.62 1,050.00 0.00 1,290.00 122.86 ( 240.00) 800.00 46.00 189.00 23.00 616.00 88,050.00 713.54 80,785.16 91.75 7,264.84 TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101-4-1350-4102 Overtime Pay 101-4-1350-4103 Part-time Pay 101-9-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-9108 Insurance 101-4-1350-9109 Workers Comp TOTAL Personal Services 434,450.00 27,380.08 388,933.62 89.41 96,016.38 121,950.00 9,580.84 109,488.81 89.78 12,961.19 0.00 0.00 90.50 0.00 ( 90.50) 12,500.00 0.00 4,955.00 39.64 7,595.00 8,750.00 622.76 7,280.31 83.20 1,469.69 8,350.00 581.79 6,957.16 83.32 1,392.89 1,950.00 136.07 1,627.13 83.44 322.87 15,200.00 1,243.14 13,693.57 90.09 1,506.43 500.00 0.00 514.75 102.95 ( 14.75) 169,200.00 12,164.60 144,607.23 85.47 24,592.77 12-09-2008 03:08 PM 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES PAGE: 9 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 Supplies 101-9-1350-4219 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-4-1350-9409 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 101-4-1350-4560 Equipment TOTAL Capital Outlay 27,500.00 383.36 12,697.85 46.17 14,802.15 27,500.00 383.36 12,697.85 96.17 14,802.15 5,000.00 0.00 ( 401.00) 8.02- 5,901.00 800.00 95.30 515.88 64.49 289.12 4,000.00 93.72 872.25 21.81 3,127.75 19,750.00 305.00 6,063.93 30.70 13,686.07 29,550.00 444.02 7,051.06 23.86 22,498.94 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 Legal Other Services & Charges 101-4-1400-4304 Legal Fees 101-4-1900-4361 Insurance TOTAL Other Services & Charges 256,250.00 12,991.98 164,356.14 64.14 91,693.86 234,000.00 ( 21,997.04) 140,856.24 60.19 93,143.76 700.00 0.00 0.00 0.00 700.00 234,700.00 ( 21,997.09) .190,856.24 60.02 93,843.76 TOTAL Legal Community Development --------------------- --------------------- 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-4-1500-4107 Medicare 101-4-1500-9108 Insurance 101-4-1500-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1500-4201 Office Supplies TOTAL Supplies 239,700.00 ( 21,997.04) 140,856.29 60.02 93,843.76 122,050.00 10,297.22 85,412.05 69.98 36,637.95 500.00 0.00 109.35 21.87 390.65 7,950.00 669.32 5,627.03 70.78 2,322.97 7,600.00 609.10 5,142.20 67.66 2,457.80 1,800.00 142.46 1,202.60 66.81 597.90 14,900.00 1,046.85 8,032.41 53.91 6,867.59 500.00 0.00 536.25 107.25 ( 36.25) 155,300.00 12,764.95 106,061.89 68.29 49,238.11 1,400.00 24.55 1,683,.95 120.25 ( 283.45) 1,400.00 24.55 1,683.45 120.25 ( 283.45) 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: - 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET. PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 101-4-1500-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4104 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs 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-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-9404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Planning City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 101-4-1600-9102 Overtime Pay 101-4-1600-9103 Part-time Pay 101-4-1600-9104 PERA 101-4-1600-4105 FICA 1,600.00 18.00 136.11 8.51 1,463.89 250.00 0.00 250.00 100.00 0.00 1,850.00 18.00 386.11 20.87 1,463.89 158,550.00 12,807.50 108,131.45 68.20 50,418.55 205,300.00 10,777.92 154,479.05 75.25 50,820.95 13,350.00 700.56 10,275.87 76.97 3,079.13 12,750.00 616.48 9,291.47 72.87 3,458.53 3,000.00 149.18 2,172.97 72.43 827.03 25,050.00 1,428.01 19,184.14 76.58 5,865.86 450.00 0.00 505.75 112.39 ( 55.75) 259,900.00 13,667.15 195,909.25 75.38 63,990.75 7,300.00 713.76 6,828.95 93.55 471.05 250.00 126.60 699.04 279.62 ( 449.04) 7,550.00 840.36 7,527.99 99.71 22.01 30,000.00 0.00 0.00 0.00 30,000.00 600.00 139.16 535.81 89.30 .69.19 2,500.00 ( 5.80) 1,236.86 49.47 1,263.14 7,500.00 92.87 3,566.60 47.55 3,933.40 10,000.00 938.50 5,588.56 55.89 4,411.44 800.00 0.00 547.50 68.44 252.50 7,000.00 117.15 7,671.50 109.59 ( 671.50) 2,100.00 0.00 625.00 29.76 1,475.00 500.00 96.00 46.00 9.20 454.00 61,000.00 1,327.88 19,817.83. 32.49 41,182.17 328,450.00 15,835.39 223,255.07 67.97 105,194.93 89,900.00 7,506.85 85,050.69 94.61 4,849.31 350.00 26.21 4,600.72 1,314.49 ( 4,250.72) 10,650.00 618.28 4,867.86 95.71 5,782.14 6,550.00 529.81 6,158.75 94.03 391.25 6,250.00 500.44 6,061.62 96.99 188.38 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND General Government 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1600-4107 Medicare 1,450.00 117.05 1,432.22 98.77 17.78 101-4-1600-4108 Insurance 12,700.00 1,067.93 13,726.84 108.09 ( 1,026.84) 101-4-1600-4109 workers Comp 2,400.00 0.00 2,882.25 120.09 ( 482.25) TOTAL Personal Services 130,250.00 10,366.57 124,780.95 95.80 5,969.05 Supplies 101-4-1600-4212 Fuels & Lubs 4,000.00 208.87 3,488.20 87.21 511.80 101-4-1600-4217 Uniform Allowance 1,700.00 0.00 782.86 46.05 917.19 101-9-1600-4219 Operating Supplies 30,500.00 2,086.44 25,267.40 82.84 5,232.60 SOTAL Supplies 36,200.00 2,295.31 29,538.46 81.60 6,661.54 Other Services & Charqes 101-4-1600-4321 Telephone 17,550.00 1,311.89 14,149.69 80.63 3,400.31 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 362.64 18.13 1,637.36 101-4-1600-4361 Insurance 5,900.00 2,544.00 5,175.00 87.71 725.00 101-4-1600-4389 Utilities 45,400.00 2,045.01 37,843.55 83.36 7,556.45 101-4-1600-9401 Bldg Repair/Maint Services 30,700.00 1,326.41 25,561.27 83.26 5,138.73 101-4-1600-9404 Equip Repair/Maint Services 0.00 0.00 1,972.64 0.00 ( 1,972.64) TOTAL Other Services & Charges 101,550.00 7,227.31 85,064.79 83.77 16,485.21 Capital Outlay 101-4-1600-4560 Equipment 32,000.00 0.00 31,893.96 99.67 106.04 TOTAL Capital Outlay 32,000.00 0.00 31,893.96 99.67 106.04 TOTAL City Hall Maintenance Contingency Other Services & Charqes 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Contingency TOTAL General Government Police Administration 300,000.00 19,889.19 271,278.16 90.43 28,721.84 60,000.00 0.00 1,573.12 2.62 58,926.88 60,000.00 0.00 1,573.12 2.62 58,426.88 60,000.00 0.00 1,573.12 2.62 58,426.88 2,748,250.00 182,312.25 2,083,020.30 75..79 665,229.70 Personal Services 101-4-2110-4101 Regular Pay 323,200.00 24,901.40 291,360.80 90.15 31,839.20 101-4-2110-9102 Overtime Pay 0.00 0.00 1,236.83 0.00 ( 1,236.83) 101-4-2110-9104 PERA 38,400.00 .2,954.22 35,730.74 93.05 2,669.26 101-4-2110-4105 FICA 3,200.00 236.06 2,852.46 89.14 347.54 101-4-2110-4107 Medicare 3,250.00 256.62 3,118.73 95.96 131.27 101-4-2110-4108 Insurance 30,550.00 2,262.03 26,887.46 88.01 3,662.54 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-2110-4109 Workers Comp 45,600.00 0.00 97,185.75 103.98 ( 1,585.75) TOTAL Personal Services 944,200.00 30,610.33 908,372.77 91.93 35,827.23 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-4319 Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-4322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-9-2110-4359 Publishing 101-4-2110-4361 Insurance 101-4-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-2110-4560 Equipment TOTAL Capital Outlay TOTAL Police Administration Patrol Personal Services 15,200.00 132.25 11,792.60 77.58 3,407.40 2,450.00 47.93 2,008.27 81.97 441.73 4,650.00 186.54 6,128.75 131.80 ( 1,478.75) 22,300.00 366.72 19,929.62 89.37 2,370.38 6,100.00 0.00 1,792.51 29.39 4,307.49 26,700.00 1,795.39 19,976.28 74.82 6,723.72 2,600.OD 0.00 1,246.72 47.95 1,353.28 4,800.00 479.99 4,876.06 101.58 ( 76.06) 500.00 0.00 0.00 0.00 500.00 13,500.00 4,576.50 9,587.00 71.01 3,913.00 54,000.00 826.84 43,267.55 80.13 10,732.45 7,050.00 0.00 3,190.00 44.54 3,910.00 500.00 0.00 336.25 67.25 163.75 115,750.00 7,678.72 84,222.37 72.76 31,527.63 57,600.00 0.00 57,599.00 100.00 1.00 57,600.00 0.00 57,599.00 100.00 1.00 639,850..00 38,655.77 570,123.76 89.10 69,726.24 101-4-2120-4101 Regular Pay 1,393,950.00 98,567.25 1,157,415.41 83.03 236,534.59 101-4-2120-4102 Overtime Pay 90,000.00 5,567.11 98,819.67 109.80 ( 8,819.67) 101-4-2120-4104 PERA 191,700.00 13,933.30 165,333.25 86.25 26,366.75 101-4-2120-4107 Medicare 19,350.00. 1,238.84 15,537.52 80.30 3,812.48 101-4-2120-4108 Insurance 155,600.00 12,372.00 133,250.92 85.64 22,349.08 TOTAL Personal Services 1,850,600.00 131,178.50 1,570,356.77 84.86 280,243.23 Supplies 101-4-2120-4212 Fuels & Lubs 100,000.00 7,103.17 96,513.38 96.51 3,486.62 101-4-2120-4217 Uniform Allowance 16,800.00 1,133.84 9,835.32 58.54 6,964.68 101-4-2120-4219 Operating Supplies 63,000.00 3,658.88 55,226.99 87.66 7,773.01 101-9-2120-4221 Equipment Parts 22,000.00 1,204.76 20,679.72 94.00 1,320.28 TOTAL Supplies 201,800.00 13,100.65 182,255.41 90:31 19,544.59 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 18,650.00 1,760.40 10,378.68 55.65 8,271.32 101-4-2120-4904 Equip Repair/Maint Services 27,200.00 1,033.83 15,859.44 58.31 11,340.56 101-4-2120-4433 Dues & Subscriptions 550.00 0.00 150.00 27.27 900.00 TOTAL Other Services & Charges 46,400.00 2,794.23 26,388.12 56.87 20,011.88 Capital Outlay 101-4-2120-4560 Equipment 102,000.00 0.00 79,781.73 78.22 22,218.27 TOTAL, Capital Outlay 102,000.00 0.00 79,781.73 78.22 22,218.27 TOTAL Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-9-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2130-4319 Other Professional Services 101-4-2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions TOTAL Other Services & Charges 2,200,800.00 147,073.38 1,858,782.03 89.96 342,017.97 479,950.00 35,026.79 417,662.92 87.02 62,287.58 40,000.00 1,981.34 30,062.27 75.16 9,937.73 67,100.00 4,774.02 58,959.93 87.86 8,145.07 5,500.00 331.69 4,247.89 77.23 1,252.11 56,950.00 9,870.45 48,985.35 86.01 7,964.65 649,500.00 46,984.24 559,912.86 86.21 89,587.19 9,750.00 835.15 3,482.59 73.32 1,267.41 6,100.00 230.80 4,649.99 76.22 1,450.51 10,850.00 1,065.95 8,132.08 79.95 2,717.92 8,650.00 ( 14.56) 5,598.71 64.72 3,051.29 5,500.00 394.00 4,409.21 80.17 1,090.79 150.00 0.00 0.00 0.00 150.00 14,300.00 379.94 10,007.92 69.99 4,292.08 TOTAL Investigations Police Support Services 674,650.00 48,429.63 578,052.86 85.68 96,597.14 Personal Services 101-4 -2150-4101 Regular Pay 338,000.00 25,700.83 297,657.61 88.06 40,392.39 101-4 -2150-4102 Overtime Pay 1,000.00 59.28 5,608.05 560.81 ( 4,608.05) 101-4 -2150-4104 PERA 22,050.00 1,679.92 20,124.02 91.27 1,925.98 101-4 -2150-4105 FICA 21,000.00 1,536.95 18,969.20 90.33 2,030.80 101-4 -2150-4107 Medicare 5,000.00 359.49 4,436.27 88.73 563.73 101-9 -2150-4108 Insurance 40,600.00 3,336.10 36,795.79 90.63 3,809.21 TOTAL Personal Services 927,650.00 32,667.02 383,590.94 89.70 44,059.06 12-09-2008 03:08 PM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGES PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2150-9201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charqes 101-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4904 Equip Repair/Maint Services 101-4-2150-9409 Contractual Services 101-4-2150-4433 Dues & Subscriptions TOTAL Other Services & Charges 1,000.00 3,000.00 10,200.00 14,200.00 4,050.00 3,400.00 14,000.00 500.00 21,950.00 218.73 742.31 74.23 257.69 0.00 1,974.55 65.82 1,025.45 977.67 9,103.78 89.25 1,096.22 696.40 11,820.64 83.24 2,379.36 167.24 608.25 15.02 3,941.75 98.00 3,696.85 108.73 ( 296.85) 596.29 9,725.82 69.47 4,274.18 0.00 252.50 50.50 247.50 861.53 14,283.42 65.07 7,666.58 TOTAL Police Support Services 463,800.00 34,229.95 409,695.00 88.33 54,105.00 Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 6,266.02 113.93 ( 766.02) 101-4-2160-4105 FICA 350.00 0.00 388.48 110.99 ( 38.48) 101-4-2160-4107 Medicare 100.00 0.00 90.90 90.90 9.10 101-9-2160-4110 Re-employment Compensation 0.00 0.00 80.85 0.00 ( 80.85) TOTAL Personal Services 5,950.00 0.00 6,826.25 114.73 ( 876.25) Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 0.00 3,107.09 62.14 1,892.91 101-9-2160-4219 Operating Supplies 7,500.00 0.00 4,897.16 65.30 2,602.84 TOTAL Supplies 12,500.00 0.00 8,004.25 69.03 4,995.75 Other Services & Charqes 101-4-2160-4319 Other Professional Services 1,500.00 0.00 350.00 23.33 1,150.00 101-4-2160-4321 Telephone 2,400.00 150.46 1,008.30 42.01 1,391.70 101-4-2160-4331 Travel, Conferences & Schools 2,300.00 0.00 365.00 15.87 1,935.00 101-9-2160-4359 Publishing 0.00 112.20 112.20 0.00 ( 112.20) 101-9-2160-4433 Dues & Subscriptions 1,250.00 0.00 612.00 48.96 638.00 TOTAL Other Services & Charges 7,450.00 262.66 2,447.50 32.85 5,002.50 TOTAL Police Reserves 25,900.00 262.66 17,278.00 66.71 8,622.00 Public safety building CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 12-09-2008 03:08 PM .CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 91.67 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-9103 Part-time Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-4107 Medicare 101-4-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies 91,600.00 6,149.29 77,444.10 89.55 14,155.90 450.00 33.70 .529.79 117.73 ( 79.79) 0.00 562.35 717.09 0.00 ( 717.09) 6,000.00 438.45 5,080.03 84.67 919.97 5,700.00 410.24 4,858.21 85.23 841.79 1,350.00 95.99 1,136.25 84.17 213.75 14,550.00 1,057.99 10,403.27 71.50 4,146.73 2,200.00 0.00 2,599.25 118.15 ( 399.25) 121,850.00 8,747.96 102,767.99 89.34 19,082.01 14,000.00 497.10 11,425.95 81.61 2,574.05 14,000.00 497.10 11,425..95 81.61 2,574.05 Other Services & Charges 101-4-2190-4361 Insurance 6,900.00 3,006.50 6,197.00 89.81 703.00 101-4-2190-4389 Utilities 15,600.00 215.62 15,452.40 99.05 197.60 1.01-4-2190-9401 Bldg Repair/Maint Services 28,700.00 232.12 15,796.84 55.04 12,903.16 TOTAL Other Services & Charges 51,200.00 3,959.29 37,446.24 73.14 13,753.76 TOTAL Public safety building 187,050.00 12,699.30 151,640.18 81.07 35,909.82 Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4102 Overtime Pay 101-4-2310-4103 Part-time Pay 101-4-2310-9109 PERA 101-4-2310-9105 FICA 101-4-2310-4106 Other Retirement Contributions 101-4-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-4-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies TOTAL Supplies 86,750.00 7,310.16 84,548.02 97.96 2,201.98 0.00 3.74 258.76 0.00 ( 258.76) 140,750.00 10,820.03 149,493.49 106.21 ( 8,743.49) 11,650.00 984.57 11,662.00 100.10 ( 12.00) 9,400.00 684.18 10,165.42 108.14 ( 765.42) 30,000.00 0.00 30,000.00 100.00 0.00 3,300.00 241.80 3,345.37 101.37 ( 45.37) 11,200.00 852.02 10,950.42 97.77 249.58 14,400.00 0.00 14,748.50 102.42 ( 398.50) 307,450.00 20,896.50 315,171.98 102.51 ( 7,721.98) 1,200.00 37.25 826.10 68.84 373.90 8,000.00 619.50 8,969.24 112.12 ( 969.29) 1,100.00 0.00 413.55 37.60 686.45 32,600.00 1,390.17 30,008.18 92.05 2,591.82 42,900.00 1,996.92 40,217.07 .93.75 2,682.93 12-09-2008 03:08 PM CITY OF ELK RIVER - PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-9-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-4361 Insurance 101-4-2310-4389 Utilities 101-4-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Fire Administration Fire Inspections 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-9321 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-4433 Dues & Subscriptions TOTAL Other Services & Charges 4,900.00 0.00 3,958.92 80.79 941.08 2,900.00 269.93 2,790.48 96.22 109.52 350.00 0.00 530.31 151.52 ( 180.31) 23,550..00 ( 1,289.52) 18,593.93 78.96 4,956.07 500.00 0.00 240.00 48.00 260.00 23,550.00 8,380.00 18,266.00 77.56 5,284.00 13,650.00 134.75 12,183.83 89.26 1,966.17 9,000.00 239.63 5,347.24 133.68 ( 1,347.24) 20,750.00 24.32 15,101.95 72.78 5,698.05 2,000.00 0.00 1,802.50 90.13 197.50 96,150.00 7,759.11 78,815.16 81.97 17,334.84 446,500.00 30,652.53 934,204.21 97.25 12,295.79 128,300.00 9,927.20 115,955.69 90.38 12,344.31 0.00 0.00 486.72 0.00 ( 986.72) 13,850.00 0.00 6,753.92 48.76 7,096.08 8,950.00 1,021.81 12,328.90 137.75 ( 3,378.90) 8,200.00 260.12 3,805.23 46.41 4,394.77 2,050.00 140.34 1,774.93 86.58 275.07 13,300.00 1,189.28 11,585.30 87.11 1,714.70 174,650.00 12,538.75 152,690.69 87.43 21,959.31 3,100.00 298.64 2,604.96 84.03 495.04 3,000.00 222.79 2,806.87 93.56 193.13 800.00 0.00 879.89 109.99 ( 79.89) 4,150.00 71.05 4,448.41 107.19 ( 298.41) 11,050.00 592.48 10,740.13 97.20 309.87 1,350.00 115.18 1,187.87 87.99 162.13 150.00 0.00 0.00 0.00 150.00 3,200.00 0.00 399.30 12.98 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 115.18 3,118.43 44.23 3,931.57 TOTAL Fire Inspections 192,750.00 13,246.41 166,549.25 86.41 26,200.75 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 91.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Emergency Management Personal Services 101-9-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-9-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-9322 Postage 101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4359 Publishing 101-4-2330-4389 Utilities 101-4-2330-9409 Equip Repair/Maint Services 101-4-2330-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 9,550.00 741.60 8,581.53 89.86 968.47 1,250.00 95.68 1,082.18 86.57 167.82 150.00 10.22 116.59 77.73 33.41 1,000.00 60.90 670.77 67.08 329.23 11,950.00 908.40 10,451.07 87.96 1,498.93 5,100.00 19.45 1,851.22 36.30 3,248.78 8,200.00 6.89 6,013.30 73.33 2,186.70 13,300.00 26.34 7,864.52 59.13 5,435.48 3,500.00 128.39 1,037.91 29.65 2,962.09 100.00 0.00 0.00 0.00 100.00 1,750.00 0.00 1,382.41 78.99 367.59 500.00 0.00 0.00 0.00 500.00 1,500.00 95.82 1,210.32 80.69 289.68 4,600.00 108.30 6,251.30 135.90 ( 1,651.30) 400.00 0.00 200.00 so.oo zoo.oo 12,350.00 332.51 10,081.94 81.69 2,268.06 14,700.00 0.00 19,668.67 99.79 31.33 14,700.00 0.00 14,668.67 99.79 31.33 TOTAL Emergency Management Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-4-2910-4102 Overtime Pay 101-4-2410-4103 Part-time Pay 101-4-2410-9104 PERA 101-4-2410-9105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp TOTAL Personal Services 52,300.00 1,267.25 43,066.20 82.34 9,233.80 484,700.00 37,465.53 433,785.44 89.50 50,914.56 500.00 73.87 784.71 156.94 ( 284.71) 41,250.00 1,869.12 22,779.89 55.22 18,470.11 34,200.00 2,561.58 30,403.55 88.90 3,796.45 32,600.00 2,259.36 26,913.93 82.56 5,686.07 7,600.00 527.23 6,294.36 82.82 1,305.64 66,700.00 4,759.05 56,061.99 84.05 10,638.01 1,300.00 0.00 1,299.75 99.98 0.25 668,850.00 99,510.74 578,323.62 86.97 90,526.38 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGES BALANCE Supplies 101-4-2410-4201 Office Supplies 6,600.00 510.10 1,776.60 26.92 4,823.40 101-9-2410-4212 Fuels & Lubs 11,600.00 459.51 6,373.86 54.95 5,226.14 101-4-2410-4217 Uniform Allowance 2,400.00 190.24 1,766.73 73.61 633.27 101-4-2410-4219 Operating Supplies 16,650.00 84.83 7,235.43 43.96 9,414.57 TOTAL Supplies 37,250.00 1,199.68 17,152.62 46.05 20,097.38 Other Services & Charges 101-4-2410-4319 Other Professional Services 25,000.00 0.00 106.64 0.43 24,893.36 101-4-2410-4321 Telephone 7,000.00 325.21 4,862.00 69.46 2,138.00 101-4-2410-4322 Postage 1,500.00 0.00 422.01 28.13 1,077.99 101-4-2410-4331 Travel, Conferences & Schools 12,300.00 36.85 5,682.43 46.20 6,617.57 101-9-2410-4359 Publishing 350.00 0.00 0.00 0.00 350.00 101-4-2410-4361 Insurance 29,000.00 14,513.50 26,228.50 90.44 2,771.50 101-4-2410-4404 Equip Repair/Maint Services 12,600.00 303.53 6,763.88 53.68 5,836.12 101-4-2410-4433 Dues & Subscriptions 1,400.00 0.00 665.00 97.50 735.00 101-4-2410-4940 Miscellaneous 2,500.00 0.00 0.00 0.00 2,500.00 TOTAL Other Services & Charges 91,650.00 15,179.09 44,730.96 48.81 46,919.54 Capital Outlay 101-4-2410-4560 Equipment 10,000.00 0.00 5,047.23 50.47 4,952.77 TOTAL Capita l Outlay 10,000.00 0.00 5,047.23 50.47 4,952.77 TOTAL Building Safety 807,750.00 65,889.51 645,253.93 79.88 162,496.07 Environmental Personal Services 101-4-2440-4101 Regular Pay 61,700.00 4,682.17 50,859.68 82.43 10,840.32 101-4-2490-4104 PERA 4,000.00 304.34 3,517.23 87.93 482.77 101-4-2440-4105 FICA 3,850.00 227.28 2,597.81 66.18 1,302.19 101-4-2490-4107 Medicare 900.00 53.15 595.82 66.20 304.18 101-4-2440-4108 Insurance 9,350.00 686.28 11,792.34 126.12 ( 2,442.34) 101-4-2440-4109 Workers Comp 350.00 0.00 347.00 99.14 3.00 TOTAL Personal Services 80,150.00 5,953.22 69,659.88 86.91 10,490.12 Supplies 101-4-2440-4201 Office Supplies 1,200.00 26.81 233.00 19.42 967.00 101-4-2440-4212 Fuels & Lubs 1,000.00 3.16 37.60 3.76 962.40 101-4-2940-4217 Uniform Allowance 200.00 0.00 212.98 106.29 ( 12.48) TOTAL Supplies 2,400.00 29.97 483.08 20.13 1,916.92 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charqes 101-9-2940-4321 Telephone 101-9-2490-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2940-4361 Insurance 101-4-2440-4404 Equip Repair/Maint Services 101-4-2440-9433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Environmental TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services Supplies 101-9-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 & Charqes 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-4361 Insurance 101-4-3120-4389 Utilities 101-4-3120-4401 Bldg Repair/Maint Services 101-9-3120-4404 Equip Repair/Maint Services 101-4-3120-4409 Contractual Services 101-4-3120-9415 Equipment Rental 1,350.00 56.49 644.64 47.75 705.36 500.00 0.00 380.29 76.06 119.71 800..00 118.00 577.60 72.20 222.40 1,000.00 0.00 0.00 0.00 1,000.00 600.00 112.00 243.50 40.58 356.50 50.00 0.00 0.00 0.00 50.00 300.00 0.00 875.00 291.67 ( 575.00) 4,600.00 286.49 2,721.03 59.15 1,878.97 87,150.00 6,269.68 72,863.99 83.61 14,286.01 5,778,500.00 398,666.07 4,947,509.41 85.62 830,990.59 425,350.00 40,017.82 449,842.01 105.76 ( 24,492.01) 3,000.00 5,137.04 15,793.01 526.43 ( 12,793.01) 67.,500.00 3,575.09 58,031.82 85.97 9,468.18 32,000.00 3,167.42 33,369.01 109.28 ( 1,369.01) 30,750.00 2,841.07 31,289.53 101.75 ( 539.53) 7,200.00 669.43 7,317.61 101.63 ( 117.61) 55,950.00 6,325.49 60,371.90 107.90 ( 4,421.90) 18,800.00 0.00 19,213.75 102.20 ( 413.75) 640,550.00 61,728.26 675,228.64 105.41 ( 34,678.64) 5,000.00 117.66 4,326.06 86.52 673.94 75,250.00 ( 804.67) 64,088.21 85.17 11,161.79 147,500.00 7,496.81 120,414.34 81.69 27,085.66 14,000.00 1,809.97 26,954.26 192.53 ( 12,954.26) 241,750.00 8,569.77 215,782.87 89.26 25,967.13 950.00 39.00 383.50 40.37 566.50 6,550.00 423.75 4,462.78 68.13 2,087.22 200.00 0.00 308.75 154.38 ( 108.75) 4,000.00 115.80 5,142.33 128.56 ( 1,142.33) 500.00 0.00 0.00 0.00 500.00 17,500.00 7,963.50 16,372.00 93.55 1,128.00 33,000.00 2,119.56 31,116.76 99.29 1,883.24 13,900.00 0.00 14,964.77 107.66 ( 1,064.77) 0.00 0.00 2,758.44 0.00 ( 2,758.44) 193,000.00 22,566.69 158,111.43 81.92 34,888.57 3,500.00 1,999.99 3,491.67 99.76 8.33 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 I 101-GENERAL FUND Public Works I DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-3120-4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-3120-4937 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay 4,850.00 701.32 3,196.23 65.90 1,653.77 700.00 0.00 236.25 33.75 463.75 500.00 0.00 520.50 109.10 ( 20.50) 279,150.00 35,929.56 241,065.41 86.36 38,084.59 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 I TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-9101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-3130-4409 Contractual Services TOTAL Other Services & Charges 1,196,450.00 105,727.59 1,160,004.91 96.95 36,445.09 169,050.00 3,167.50 54,199.21 33.04 109,850.79 17,000.00 0.00 6,751.63 39.72 10,248.37 11,750.00 205.88 9,772.91 40.62 6,977.09 11,350.00 180.76 4,269.28 37.61 7,080.72 2,650.00 42.27 998.44 37.68 1,651.56 21,650.00 0.00 7,423.69 34.29 14,226.31 6,150.00 0.00 6,203.50 100.87 ( 53.50) 234,600.00 3,596.41 84,618.66 36.07 149,981.34 62,000.00 16,735.55 64,918.90 103.90 ( 2,418.90) 62,000.00 16,735.55 64,418.90 103.90 ( 2,418.90) 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 Equipment Services Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4102 Overtime Pay 101-4-3150-4109 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services 301,600.00 20,331.96 149,037.56 _49.42 152,562.44 159,750.00 12,337.60 153,143.86 95.86 6,606.19 2,500.00 0.00 1,034.45 91.38 1,465.55 10,550.00 801.94 10,289.36 97.53 260.64 10,050.00 688.08 8,941.71 88.97 1,108.29 2,350.00 160.92 2,091.26 88.99 258.79 22,800.00 1,827.01 22,892.64 100.41 ( 92.64) 4,900.00 0.00 5,115.00 104.39 ( 215.00) 212,900.00 15,815.55 203,508.28 95.59 9,391.72 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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-4-3150-4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay 101-4-3150-4560 Equipment TOTAL Capital Outlay 22,550..00 608.50 19,509.31 86.52 3,040.69 12,000.00 0.00 4,798.50 39.57 7,251.50 34,550.00 608.50 24,257.81 70.21 10,292.19 2,000.00 0.00 65.55 3.28 1,934.45 1,350.00 218.03 2,976.99 183.48 ( 1,126.99) 3,350.00 218.03 2,542.54 75.90 807.46 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 Engineering Personal Services 101-4-3300-9101 Regular Pay 101-4-3300-4102 Overtime Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies 101-4-3300-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-4331 Travel, Conferences & Schools 101-4-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 280,800.00 16,642.08 230,308.63 82.02 50,491.37 34,450.00 0.00 12,894.55 37.43 21,555.45 0.00 0.00 83.48 0.00 ( 83.98) 2,250.00 0.00 852.44 37.89 1,397.56 2,150.00 0.00 850.56 39.56 1,299.44 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 64.25 64.25 35.75 44,650.00 0.00 17,325.42 38.80 27,324.58 750.00 0.00 665.52 88.74 84.48 500.00 11.38 294.33 58.87 205.67 3,000.00 350.49 2,801.10 93.37 198.90 4,250.00 361.87 3,760.95 88.49 989.05 84,000.00 9,969.59 54,878.91 65.33 29,121.09 35,000.00 0.00 0.00 0.00 35,000.00 750.00 0.96 636.83 84.91 113.17 100.00 0.00 0.00 0.00 100.00 5,000.00 0.00 3,575.00 71.50 1,425.00 300.00 112.00 112.00 37.33 188.00 500.00 0.00 2,002.00 400.40 ( 1,502.00) 125,650.00 5,082.55 61,204.74 48.71 64,945.26 TOTAL Engineering 174,550.00 5,444.42 82,291.11 47.14 92,258.89 TOTAL Public works 1,953,900.00 148,196.05 1,621,642.21 83.02 331,757.79 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Parks Department ---------------- Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-9103 Part-time Pay 101-4-5110-4104 PERA 101-9-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-9109 Workers Comp 101-4-5110-4110 Re-employment compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies 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-4331 Travel, Conferences & Schools 101-4-5110-4359 Publishing 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4901 Bldg Repair/Maint Services 101-4-5110-4404 Equip Repair/Maint Services 101-4-5110-4909 Contractual Services 101-4-5110-4415 Equipment Rental TOTAL Other Services & Charges TOTAL Parks Department Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-4102 Overtime Pay 101-4-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-4105 FICA 101-4-5210-4107 Medicare 101-4-5210-4108 Insurance 301,150.00 21,418.52 298,310.47 99.06 2,839.53 7,650.00 0.00 844.54 11.04 6,805.46 55,100.00 1,628.00 53,403.53 96.92 1,696.47 23,550.00 1,998.00 19,951.84 84.72 3,598.16 22,450.00 1,343.04 20,816.85 92.73 1,633.1.5 5,250.00 314.12 4,868.53 92.73 381.47 43,300.00 4,144.61 39,598.94 91.45 3,.701.06 6,100.00 0.00 6,497.00 106.51 ( 397.00) 0.00 0.00 5,285.00 0.00 ( 5,285.00) 464,550.00 30,346.29 449,576.70 96.78 14,973.30 24,000.00 2,129.55 31,991.41 133.30 ( 7,991.41) 4,050.00 538.60 3,148.08 77.73 901.92 82,000.00 4,522.69 73,241.89 89.32 8,758.11 110,050.00 7,190.84 108,381.38 98.48 1,668.62 1.5,000.00 39.00 1,411.77 9.41 13,588.23 4,200.00 366.71 3,608.00 85.90 592.00 100.00 0.00 24.87 24.87 75.13 2,300.00 136.00 2,185.54 95.02 119.46 200.00 0.00 0.00 0.00 200.00 21,300.00 11,719.00 24,084.50 113.07 ( 2,784.50) 16,150.00 1,111.48 12,336.49 76.39 3,813.51 6,000.00 125.00 879.61 14.66 5,120.39 0.00 0.00 4,594.57 0.00 ( 9,594.57) 0.00 1,567.35 27,699.37 0.00 ( 27,699.37) 28,500.00 2,068.97 15,059.86 52.84 13,440.14 93,750.90 17,133.01 91,884.58 98.01 1,865.42 668,350.00 54,670.14 699,842.66 97.23 18,507.34 317,700.00 24,412.65 267,372.70 84.16 50,327.30 700.00 11.23 2,974.10 424.87 ( 2,274.10) 64,150.00 3,353.32 40,708.60 63.96 23,441.40 24,850.00 1,805.52 20,788.20 83.65 4,061.80 23,700.00 1,635.09 18,801.13 79.33 4,898.87 5,550.00 382.38 4,396.82 79.22 1,153.18 32,450.00 3,066.53 33,692.44 .103.83 ( 1,242.49) 12-09-2008 03:08 PM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Culture & Recreation CURRENT CURRENT YEAR TO DATE DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL PAGE: 23 91.67$ OF YEAR COMP. $ OF BUDGET BUDGET BALANCE 101-4-5210-4109 Workers Comp 4,650.00 0.00 4,285.75 92.17 364.25 TOTAL Person al Services 473,750.00 34,666.67 393,019.74 82.96 80,730.26 Supplies 101-4-5210-4219 Operating Supplies 16,100.00 393.90 16,811.84 104.42 ( 711.84) TOTAL Suppli es 16,100.00 343.90 16,811.84 104.42 ( 711.89) Other Services & Charges 101-4-5210-4321 Telephone 3,800.00 436.45 4,232.60 111.38 ( 432.60) 101-4-5210-4322 Postage 5,500.00 1,080.00 4,770.83 86.74 729.17 101-4-5210-4331 Travel, Conferences & Schools 11,900.00 669.55 8,350.49 70.17 3,549.51 101-4-5210-4349 Advertising/Marketing 29,550.00 427.67 21,370.62 72.32 8,179.38 101-9-5210-4361 Insurance 1,600.00 714.00 1,405.50 87..84 199.50 101-4-5210-4389 Utilities 10,600.00 298.71 9,719.61 91.65 885.39 101-4-5210-9401 Bldg Repair/Maint Services 7,500.00 877.67 9,050.25 120.67 ( 1,550.25) 101-4-5210-4404 Equip Repair/Maint Services 9,250.00 416.43 6,511.85 70.40 2,738.15 101-9-5210-4433 Dues & Subscriptions 1,700.00 0.00 1,995.00 117.35 ( 295.00) TOTAL Other Services & Charges 81,400.00 4,920.48 67,401.75 82.80 13,998.25 TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4101 Regular Pay 101-4-5220-4102 Overtime Pay 101-4-5220-9103 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-9409 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees 101-4-5220-4940 Miscellaneous TOTAL Other Services & Charges 571,250.00 39,931.05 477,233.33 83.54 99,016.67 0.00 231.75 4,011.13 0.00 ( 4,011.13) 0.00 299.52 749.63 0.00 ( 744.63) 88,500.00 .3,780.50 71,045.18 80.28 17,454.82 1,050.00 138.28 1,929.65 183.78 ( 879.65) 5,500.00 266.78 4,816.10 87.57 683.90 1,300.00 62.43 1,126.49 86.65 173.51 0.00 123.73 606.86 0.00 ( 606.86) 96,350.00 4,902.99 84,280.04 87.47 12,069.96 27,000.00 3,264.15 36,906.01 136.69 ( 9,906.01) 27,000.00 3,264.15 36,906.01 136.69 ( 9,906.01) 400.00 0.00 357.00 89.25 43.00 51,500.00 5,142.50 40,479.99 78.60 11,020.01 4,000.00 0.00 4,968.25 124.21 ( 968.25) 2,500.00 56.54 3,014.94 120.60 ( 519.94) 10,000.00 0.00 10,000.00 100.00 0.00 68,400.00 5,199.09 58,820.18 85.99 9,579.82 TOTAL Recreation Programs 191,750.00 13,366.18 180,006.23 93.88 11,743.77 12-09-2008 03:08 PM CITY OF ELK RIVER - PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Culture & Recreation 1 DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 91.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Concessions Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 17.00 4,681.00 98.55 69.00 101-4-5230-4104 PERA 0.00 l.ll 107.46 0.00 ( 107.46) 101-4-5230-4105 FICA 300.00 1.05 271.82 90.61 28.18 101-4-5230-4107 Medicare 100.00 0.25 63.56 63.56 36.44 TOTAL Personal Services 5,150.00 19.41 5,123.84 99.49 26.16 Supplies 101-4-5230-4219 Operating Supplies 600.00 0.00 366.72 61.12 233.28 101-4-5230-4259 Other Merchandise For Resale 13,000.00 278.77 7,471.64 57.97 5,528.36 TOTAL Supplies 13,600.00 278.77 7,838.36 57.64 5,761.69 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 Sr Citizen Programs ' Personal Services 101-4-5510-9101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-9103 Part-time Pay 101-4-5510-4104 PERA 101-9-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-4-5510-4331 Travel, Conferences & Schools 101-4-5510-4359 Publishing 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-9-5510-9401 Bldg Repair/Maint Services 101-9-5510-4409 Contractual Services 18,850.00 298.18 12,962.20 68.76 5,887.80 68,400.00 4,049.15 96,045.25 67.32 22,354.75 500.00 0.00 99.31 18.86 405.69 55,100.00 4,351.96 48,639.08 88.27 6,460.92 8,050.00 546.07 6,294.43 77.57 1,805.57 7,700.00 993.60 5,700.98 74.04 1,999.02 1,800.00 115.45 1,333.41 74.08 466.59 12,250.00 996.81 11,264.91 91.96 985.09 650.00 0.00 593.25 91.27 56.75 154,450.00 10,553.04 119,915.62 77.64 39,534.38 17,100.00 1,565.89 15,737.89 92.03 1,362.11 17,100.00 1,565.89 .15,737.89 92.03 1,362.11 2,050.00 207.81 2,242.15 109.37 ( 192.15) 3,700.00 2.10 2,818.55 76.18 881.45 900.00 0.00 847.57 99.17 52.43 800.00 0.00 169.34 21.17 630.66 2,000.00 775.50 1,196.50 59.83 803.50 10,900.00 91.10 9,953.16 91.31 946.84 3,400..00 2,002.29 12,373.71 363.93 ( 8,973.71) 5,050.00 193.49 9,069.44 80.58 980.56 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 9L 67~ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 950.00 0.00 369.50 38.89 580.50 29,750.00 3,272.24 34,039.92 119.42 ( 4,289.92) TOTAL Sr Citizen Programs TOTAL Culture &Recreation Economic Developement --------------------- Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare 101-9-6210-4108 Insurance 101-4-6210-9109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-4331 Travel, Conferences & Schools 101-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 201,300.00 15,391.17 169,693.43 84.30 31,606.57 1,651,500.00 123,656.72 1,489,737.85 90.21 161,762.15 0.00 ( 8,375.71) 24,847.50 0.00 ( 29,847.50) 0.00 ( 2,111.96) 2,091.98 0.00 ( 2,091.98) 0.00 ( 552.57) 1,659.70 0.00 ( 1,659.70) 0.00 ( 559.04) 1,555.57 0.00 ( 1,555.57) 0.00 ( 129.49) 363.78 0.00 ( 363.78) 0.00 ( 1,008.81) 2,522.02 0.00 ( 2,522.02) 0.00 0.00 144.50 0.00 ( 194.50) 0.00 ( 12,732.08) 33,185.05 0.00 ( 33,185.05) 0.00 ( 10.00) 60.00 0.00 1,169.50 1,378.50 0.00 35.26 49.23 0.00 1,194.76 1,487.73 0.00 ( 60.00) 0.00 ( 1,378.50) 0.00 ( 49.23) 0.00 ( 1,987.73) TOTAL Economic Developement Energy City 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-4-6220-4319 Other Professional Services 101-4-6220-4331 Travel, Conferences & Schools 101-4-6220-9359 Publishing TOTAL Other Services & Charges TOTAL Energy City 0.00 ( 11,537.32) 34,672.78 0.00 ( 39,672.78) 25,750.00 1,938.72 19,131.16 74.30 6,618.84 0.00 0.00 1,063.30 0.00 ( 1,063.30) 26,300.00 0.00 1,258.56 4.79 25,091.44 3,400.00 126.02 1,101.44 32.40 2,298.56 3,200.00 94.88 882.83 27.59 2,317.17 750.00 22.19 206.42 27.52 543.58 3,450.00 261.25 2,055.86 59.59 1,394.14 62,850.00 2,443.06 25,699.57 40.89 37,150.43 2,000.00 0.00 9,250.16 462.51 ( 7,250.16) 23,000.00 67.05 3,352.70 14.58 19,647.30 5,500.00 1,062.39 7,021.99 127.67 ( 1,521.99) 30,500.00 1,129.44 19,624.85 64.34 10,875.15 93,350.00 3,572.50 45,324.42 98.55 48,025.58 12-09-2008 03:08 PM I 101-GENERAL FUND Economic Development I DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 26 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL .BUDGET BALANCE TOTAL Economic Development 93,350.00 ( 7,969.82) 79,997.20 85.70 13,352.80 Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 139,650.00 0.00 0.00 0.00 134,650.00 101-4-7000-4724 Transfer - Pinewood 67,200.00 0.00 0.00 0.00 67,200.00 101-4-7000-4730 Transfer-Debt Service 66,600.00 0.00 66,600.00 100.00 0.00 TOTAL Transfers Out 268,450.00 0.00 66,600.00 29.81 201,850.00 TOTAL Transfers Out 268,450.00 0.00 66,600.00 24.81 201,850.00 TOTAL General 268,950.00 0.00 66,600.00 24.81 201,850.00 ^ TOTAL EXPENDITURES ^ REVENUES OVER/(UNDER) EXPENDITURES 12,493,450.00 844,816.27 10,288,506.97 82.35 2,204,943.03 ------------- ------------- ------------- ------- ------------- ( 3,000.00)( 797,154.13)( 3,267,529.27) 3,264,529.27 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 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 CURRENT CURRENT BUDGET PERIOD 91.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 86,350.00 1,925.01 68,242.49 79.03 18,107.51 0.00 0.00 222,749.51 0.00 ( 222,749.51) 86,350.00 ------------- -- 1,925.01 ----------- - 290,992.00 ------------ 336.99 ( ------- - 204,642.00) ------------ 86,350.00 5,659.33 174,751.54 202.38 ( 88,401.59) 0.00 9,712.00 30,392.94 0.00 ( 30,392.94) 86,350.00 15,371.33 205,149.48 237.57 ( 118,794.48) 86,350.00 ------------- - 15,371.33 ------------ - 205,194.48 ------------ 237.57 ( ------- - 118,794.48) ------------ 0.00 ( 13,446.32) 85,847.52 ( 85,897.52) 12-09-2008 03:08 PM ~ 211-LIBRARY I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 2 91.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 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 TOTAL Property Taxes 78,350.00 Intergovernmental Rev 0.00 36,958.13 47.17 41,391.87 0.00 1,477.66 0.00 ( 1,977.66) 0.00 38,435.79 99.06 39,914.21 211-3-0000-3322 MV Credit 0.00 0.00 1,465.00 0.00 ( 1,465.00) TOTAL Intergovernmental Rev 0.00 0.00 1,465.00 0.00 ( 1,465.00) Charges for Services 211-3-0000-3475 Building Rent 0.00 0.00 709.24 0.00 ( 709.24). TOTAL Charges for Services 0.00 0.00 709.24 0.00 ( 709.24) Other Revenue 211-3-0000-3621 Interest Income 8,000.00 0.00 11,031.63 137.90 ( 3,031.63) 211-3-0000-3626 Contributions 0.00 1,925.01 16,600.83 0.00 ( 16,600.83) TOTAL Other Revenue 8,000.00 1,925.01 27,632.46 345.41 ( 19,632.46) TOTAL Library Library Project Transfers In 211-3-5610-3927 Transfer-Govt Buildings Reserv TOTAL Transfers In TOTAL Library Project 0.00 0.00 222,749.51 0.00 ( 222,749.51) ^ TOTAL REVENUE 86,350.00 1,925.01 68,242.99 79.03 18,107.51 0.00 0.00 222,749.51 0.00 ( 222,749.51) 0.00 0.00 222,749.51 0.00 ( 222,749.51) 86,350.00 1,925.01 290,992.00 336.99 ( 204,642.00) 12-09-2008 03:08 PM CITY OF ELK RIVER - PAGE: 3 - REVENUE &.EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 211-LIBRARY DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Library Personal Services 211-4-5600-4101. Regular Pay 211-9-5600-4104 PERA 211-4-5600-4105 FICA 211-9-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-4-5600-4304 Legal Fees 211-4-5600-4321 Telephone 211-9-5600-4322 Postage 211-4-5600-9331 Travel, Conferences & Schools 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-9-5600-4909 Equip Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services 211-4-5600-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay 211-4-5600-4730 Transfer-Debt Service TOTAL Transfers Out 24,450.00 0.00 10,379,85 42.43 14,075.15 1,600.00 0.00 726.88 45.43 873.12 1,500.00 0.00 644.00 42.93 856.00 350.00 0.00 150.57 43.02 199.43 7,150.00 0.00 1,737.49 24.30 5,412.51 250.00 0.00 941.00 176.90 ( 191.00) 35,300.00 0.00 14,079.79 39.87 21,225.21 500.00 0.00 121.23 24.25 378.77 6,750.00 100.62 6,318.74 93.61 931.26 7,250.00 100.62 6,439.97 88.83 810.03 0.00 0.00 270.00 0.00 ( 270.00) 0.00 130.58 1,444.42 0.00 ( 1,494.42) 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 1,249.50 2,913.00 145.65 ( 913.00) 12,100.00 2,002.93 22,696.76 187.58 ( 10.,596.76) 8,100.00 218.32 7,862.78 97.07 237.22 2,200.00 0.00 629.07 28.59 1,570.93 0.00 1,677.38 5,032.14 0.00 ( 5,032.14) 11,000.00 280.00 6,331.73 57.56 4,668.27 450.00 0.00 177.00 39.33 273.00 38,400.00 5,558.71 97,356.90 123.33 ( 8,956.90) 5,900.00 0.00 0.00 0.00 5,400.00 5,400.00 0.00 0.00 0.00 5,400.00 0.00 0.00 106,879.88 0.00 ( 106,879.88) 0.00 0.00 106,879.88 0.00 ( 106,879.88) TOTAL Library 86,350.00 5,659.33 174,751.59 202.38 ( 88,401.54) 12-09-2008 03:08 PM ' 211-LIBRARY Culture & Recreation ^ DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Library Project Supplies 211-4-5610-4219 Operating Supplies 0.00 0.00 2,271.64 0.00 ( 2,271.64) TOTAL Supplies 0.00 0.00 2,271.64 0.00 ( 2,271.69) Other Services & Charges 211-4-5610-4303 Engineering Fees 0.00 211-4-5610-4319 Other Professional Services 0.00 TOTAL Other Services & Charges 0.00 Capital Outla 0.00 5,894.01 0.00 ( 5,894.01) 0.00 2,284.29 0.00 ( 2,284.29) 0.00 8,178.30 0.00 ( - 8,178.30) 211-4-5610-4520 Buildings & Structures 0:00 9,712.00 19,943.00 0.00 ( 19,943.00) I TOTAL Capital Outlay 0.00 9,712.00 19,943.00 0.00 ( 19,993.00) TOTAL Library Project 0.00 9,712.00 30,392.94 0.00 ( 30,392.94) TOTAL Culture & Recreation 86,350.00 15,371.33 205,144.48 237.57 ( 118,794.98) ^ TOTAL EXPENDITURES ^ REVENUES OVER/(UNDER) EXPENDITURES 86,350.00 15,371.33 205,144.48 237.57 ( 118,794.48) 0.00 ( 13,446.32) 85,847.52 ( 85,847.52) 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE.REPORT (UNAUDITED) AS OF: NOVEMBER30TH, 2008 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 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF ~ BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 759,250.00 55,541.68 946,436.98 b8.80 312,813.02 70,000.00 ( 2,748.00) 49,113.50 70.16 20,886.50 69,000.00 7,509.00 80,723.22 116.99 ( 11,723.22) 78,000.00 8,123.17 53,148.13 68.14 24,851.87 976,250.00 68,425.85 629,421.83 64.47 346,828.17 863,950.00 54,605.82 576,511.29 66.77 286,938.71 27,050.00 2,070.00 22,517.79 83.25 4,532.21 32,500.00 1,513.49 29,000.69 89.23 3,499.31 53,250.00 5,634.34 42,738.07 80.26 10,511.93 976,250.00 63,823.65 670,767.84 68.71 305,482.16 976,250.00 63,823.65 670,767.84 68.71 305,482.16 0.00 9,602.20 ( 41,346.01) 41,396.01 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 1 221-ICE ARENA I REVENUES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3982 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 TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services I TOTAL Hockey Skating Charges for Services 221-3-5420-3961 Recreation Fees 221-3-5420-3965 Admissions TOTAL Charges for Services 420,000.00 51,046.01 292,561.24 69.66 127,438.76 32,500.00 1,400.00 19,318.50 94.06 18,181.50 14,000.00 60.00 8,754.05 62.53 5,295.95 4,000.00 540.00 3,851.50 96.29 148.50 2,600.00 0.00 2,600.00 100.00 0.00 18,500.00 600.00 3,200.00 17.30 15,300.00 491,600.00 53,646.01 325,285.29 66.17 166,314.71 30,000.00 1,244.67 14,678.56 48.93 15,321.44 0.00 0.00 4,277.00 0.00 ( 4,277.00) 3,000.00 651.00 1,994.47 66.48 1,005.53 33,000.00 1,895.67 20,950.03 63.48 12,049.97 100,000.00 0.00 100,201.66 100.20 ( 201.66) 134,650.00 0.00 0.00 0.00 139,650.00 234,650.00 0.00 100,201.66 92.70 134,448.34 759,250.00 55,591.68 446,436.98 58.80 312,813.02 70,000.00 ( 2,748.00) 49,113.50 70.16 20,886.50 70,000.00 ( 2,798.00) 49,113.50 70.16 20,886.50 70,000.00 ( 2,798.00) 49,113.50 70.16 20,886..50 69,000.00 7,509.00 77,890.63 112.88 ( 8,890.63) 0.00 0.00 2,514.59 0.00 ( 2,514.59) 69,000.00 7,509.00 80,905.22 116.53 ( 11,405.22) 12-09-2008 03:08 PM 221-ICE ARENA I REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 3 91.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 318.00 0.00 ( 318.00) 0.00 0.00 318.00 0.00 ( 318.00) 69,000.00 7,5.09.00. 80,723.22 116.99 ( 11,723.22) 78,000.00 8,123.17 53,198.13 68.14 24,851.87 78,000.00 8,123.17 53,148.13 68.19 24,851.87 78,000.00 8,123.17 53,198.13 68.14 24,851.87 ' TOTAL REVENUE 976,250.00 68,425.85 629,421.83 64.47 346,828.17 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 221-ICE ARENA DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 221-4-5900-4102 Overtime Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5900-4105 FICA 221-4-5400-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-5400-4219 Operating Supplies 221-4-5400-4255 Soft Drinks/Misc 221-4-5400-9259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5400-9331 Travel, Conferences & Schools 221-4-5900-4359 Publishing 221-4-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-9401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5400-9415 Equipment Rental 221-4-5400-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-9-5400-4560 Equipment TOTAL Capital Outlay Transfers Out 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out 154,950.00 12,685.15 126,099.39 81.38 28,850.61 200.00 0.00 9.15 4.58 190.85 76,450.00 6,021.39 50,841.42 66.50 25,608.58 11,150.00 1,155.75 11,327.40 101.59 ( 177.40) 14,350.00 1,153.51 11,067.38 77.12 3,282.62 3,350.00 269.78 2,588.38 77.27 761.62 15,500.00 1,244.95 13,219.75 85.29 2,280.25 3,200.00 0.00 4,185.75 130.80 ( 985.75) 279,150.00 22,530.53 219,338.62 78.57 59,811.38 200.00 0.00 1,358.48 679.24 ( 1,158.98) 1,100.00 157.06 367.91 33.45 732.09 51,550.00 3,792.04 32,746.88 63.52 18,803.12 15,500.00 0.00 7,007.80 45.21 8,492..20 1,200.00 147.90 1,136.19 94.68 63.81 69,550.00 4,097.00 42,617.26 61.28 26,932.74 3,200.00 291.52 2,715.61 84.86 484.39 700.00 0.00 163.94 23.42 536.06 1,050.00 69.00 299.00 28.48 751.00 3,500.00 285.02 5,427.54 155.07 ( 1,927.54) 9,750.00 4,047.50 8,232.00 84.43 .1,518.00 157,050.00 11,747.93 138,338.69 88.09 18,711.31 30,350.00 9,308.60 25,026.64 82.46 5,323.36 1,850.00 792.22 2,931.35 131.42 ( 581.35) 5,250.00 370.91 3,173.98 60.46 2,076.02 350.00 0.00 187.50 53.57 162.50 213,050.00 21,862.70 185,996.25 87.30 27,053.75 100,000.00 6,115.59 100,201..66 100.20 ( 201.66) 100,000.00 6,115.59 100,201.66 100.20 ( 201.66) 201,700.00 0.00 28,357.50 14.06 173,342.50 201,700.00 0.00 28,357.50 14.06 173,342.50 TOTAL Ice Arena 863,450.00 54,605.82 576,511.29 66.77 286,938.71 12-09-2008 03:08 PM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 5 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE. Hockey Personal Services 221-4-5910-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 & Charqes 221-4-5910-9322 Postage 221-4-5410-4359 Publishing 221-4-5410-4409 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges 3,600.00 0.00 2,943.00 81.75 657.00 200.00 0.00 182.97 91.24 17.53 50..00 0.00 42.68 85.36 7.32 3,850.00 0.00 3,168.15 82.29 681.85 12,000.00 0.00 11,096.71 92.47 903.29 12,000.00 0.00 11,096.71 92.47 903.29 500.00 0.00 85.85 17.17 414.15 1,800.00 0.00 842.20 46.79 957.80 7,800.00 2,070.00 5,159.40 66.15 2,640.60 1,100.00 0.00 2,165.48 196.86 ( 1,065.48) 11,200.00 2,070.00 8,252.93 73.69 2,947.07 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-9-5420-4104 PERA 221-4-5420-4105 FICA 221-4-5920-9107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charqes 221-4-5920-4322 Postage 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Skating 27,050.00 2,070.00 22,517.79 83.25 4,532.21 20,000.00 1,153.51 16,588.28 82.94 3,411.72 500.00 47.38 747.01 149.40 ( 247.O1j 1,250.00 71.52 1,028.49 82.28 221.51 300.00 16..72 240.53 80.18 59.47 22,050.00 1,289.13 18,604.31 84.37 3,445.69 6,200.00 0.00 6,883.67 111.03 ( 683.67) 6,200.00 0.00 6,883.67 111.03 ( 683.67) 200.00 0.00 0.00 0.00 200.00 1,200.00 0.00 388.73 32.39 811.27 1,100.00 124.80 932.80 84.80 167.20 1,750.00 99.56 2,191.18 125.21 ( 441.18) 4,250.00 224.36 3,512.71 82.65 737.29 32,500.00 1,513.49 29,000.69 89.23 3,499.31 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 2,805.75 20,055.29 95.96 844.76 221-4-5430-4104 PERA 0.00 52.49 165.19 0.00 ( 165.19) 221-4-5430-4105 FICA 1,300.00 173.95 1,317.22 101.32 ( 17.22) 221-4-5430-4107 Medicare 300.00 40.70 308.10 102.70 ( 8.10) TOTAL Personal Services 22,500.00 3,072.89 21,845.75 97.09 654.25 Supplies 221-4-5430-4219 Operating Supplies 10,750.00 77.48 166.25 1.55 10,583.75 221-4-5430-9259 Other Merchandise For Resale 20,000.00 2,483.97 20,726.07 103.63 ( 726.07) TOTAL Supplies 30,750.00 2,561.45 20,892.32 67.99 9,857.68 TOTAL Arena Concessions 53,250.00 5,639.34 42,738.07 80.26 10,511.93 TOTAL Culture & Recreation 976,250.00 63,823.65 670,767.84 68.71 305,482.16 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 976,250.00 0.00 63,823.65 670,767.84 68.71 305,482.16 4,602.20 ( 41,346.01) 41,346.01 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMHER 30TH, 2008 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY REVENUE SUMMARY Pinewood Golf Course TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 280,900.00 815.72 192,541.32 68.67 87,858.68 280,400.00 815.72 192,541.32 68.67 .87,858.68 280,400.00 15,769.96 288,055.78 .102.73 ( 7,655.78) 280,400.00 15,769.46 288,055.78 102.73 ( 7,655.78) 280,400.00 15,769.46 288,055.78 102.73 ( 7,655.78) 0.00 ( 19,953.74)( 95,519.46) 95,514.46. 12-09-2008 03:08 PM 222-PINEWOOD GOLF COURSE REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 2 91.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course Charges for Services 222-3-0000-3961 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3976 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 0.00 20,537.00 136.91 ( 5,537.00) 24,900.00 71.57 19,594.75 78.69 5,305.25 2,000.00 66.78 5,179.69 258.98 ( 3,179.69) 128,750.00 588.19 107,966.56 83.86 20,783.44 18,000.00 0.00 11,952.93 66.41 6,047.07 22,550.00 122.99 18,466.28 81.89 4,083.72 2,000.00 0.00 0.00 0.00 2,000.00 213,200.00 899.53 183,697.21 86.16 29,502.79 0.00 ( 33.06) 8,792.99 0.00 ( 8,792.99) 0.00 ( 33.06) 8,792.99 0.00 ( 8,792.99) 0.00 ( 0.75) 51.12 0.00 ( 51.12) 0.00 ( 0.75) 51.12 0.00 ( 51.12) 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 815.72 192,541.32 68.67 87,858.68 TOTAL REVENUE 280,400.00 815.72 192,541.32 68.67 87,858.68 12-09-2008 03:08 PM CITY OF ELK RIVER - PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 222-PINEWOOD GOLF COURSE 91.67% OF YEAR COMP. DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE. Golf Course Personal Services 222-4-5300-4101 Regular Pay 222-4-5300-4102 Overtime Pay 222-4-5300-4103 Part-time Pay 222-4-5300-4109 PERA 222-4-5300-4105 FICA 222-9-5300-4107 Medicare 222-4-5300-4108 Insurance 222-9-5300-4109 Workers Comp 222-4-5300-4110 Re-employment Compensation TOTAL Personal Services 83,500.00 7,016.95 78,006.95 93.42 5,493.05 0.00 0.00 165.93 0.00 ( 165.93) 41,050.00 0.00 42,999.11 104.75 ( 1,949.11) 8,100.00 456.10 6,819.06 89.19 1,280.94 7,700.00 428.99 7,692.82 99.91 7.18 1,800.00 100.31 1,799.06 99.95 0.94 12,100.00 789.72 8,654.91 71.52 3,945.59 900.00 0.00 1,055.25 117.25 ( 155.25) 0.00 0.00 640.81 0.00 ( 640.81) 155,150.00 8,792.07 147,833.40 95.28 7,316.60 Supplies 222-4-5300-4212 Fuels & Lubs 4,500.00 0.00 4,837.90 107.51 ( 337.90) 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 124.52 31,847.77 132.70 ( 7,897.77) 222-4-5300-4259 Other Merchandise For Resale 13,000.00 ( 961.17) 13,186.30 101.43 ( 186.30) TOTAL Supplies 92,000.00 ( 336.65) 50,310.90 119.79 ( 8,310.90) Other Services & Charges 222-4-5300-4321 Telephone 222-9-5300-4331 Travel, Conferences & Schools 222-4-5300-4399 Advertising/Marketing 222-9-5300-4361 Insurance 222-4-5300-4389 Utilities 222-4-5300-4401 Bldg Repair/Maint Services 222-4-5300-4904 Equip Repair/Maint Services 222-4-5300-9415 Equipment Rental 222-9-5300-4437 Taxes & Licenses 222-4-5300-9438 Credit Card Fees TOTAL Other Services & Charges Capital Outlay 222-9-5300-4560 Equipment TOTAL Capital Outlay Debt Service 222-4-5300-4601 Principal TOTAL Debt Service 2,400.00 246.87 2,694.07 112.25 ( 294.07) 900.00 0.00 173.86 19.32 726.14 1,500.00 165.00 1,520.60 101.37 ( 20.60) 11,700.00 5,146.50 11,176.00 95.52 524.00 6,200.00 582.00 5,946.65 95.91 253.35 2,500.00 337.97 1,203.21 48.13 1,296.79 2,500.00 431.67 2,767.87 110.71 ( 267.87) 36,050.00 295.68 1,699.66 4.70 34,355.39 1,000.00 0.00 4,960.00 496.00 ( 3,960.00) 2,500.00 158.35 4,208.97 168.36 ( 1,708.97) 67,250.00 7,314.04 36,345.89 54.05 30,904.11 16,000.00 0.00 17,516.11 109.48 ( 1,516.11) 16,000.00 0.00 17,516.11 109.48 ( 1,516.11) 0.00 0.00 36,049.98 0.00 ( 36,049.48) 0.00 0.00 36,099.48 0.00 ( 36,049.48) TOTAL Golf Course 280,400.00 15,769.46 288,055.78 102.73 ( 7,655.78) TOTAL Culture & Recreation 280,400.00 15,769.46 288,055.78 102.73 ( 7,655.78) 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 222-PINEWOOD GOLF COURSE Culture & Recreation ' DEPARTMENTAL EXPENDITURES 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 280,400.00 15,769.46 288,055.78 102.73 ( 7,655.78) 0.00 ( 19,953.74)( 95,514.46) 95,514.46 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 223-SENIORCITIZEN ACCOUNT FINANCIAL SUMMARY 91.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,022.06 15,768.81 0.00 ( 15,768.81) 0.00 0.00 89.78 0.00 ( 89.78) 0.00 1,022.06 15,858.59 0.00 ( 15,858.59) 0.00 1,999.83 20,004.82 0.00 ( 20,004.82) 0.00 0.00 522.85 0.00 ( 522.85) 0.00 0.00 372.67 0.00 ( 372.67) 0.00 1,999.83 20,900.39 0.00 ( 20,900.39) 0.00 1,999.83 20,900.34 0.00 ( 20,900.34) 0.00 ( 977.77)(. 5,041.75) 5,041.75 12-09-2005 03:08 PM 223-SENIOR CITIZEN ACCOUNT ~ REVENUES Sr Citizen Acct Charges for Services 223-3-0000-3462 Ceramics 223-3-0000-3963 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 CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH,2008 PAGE: 2 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 0.00 66.00 0.00 ( 66.00) 0.00 47.00 578.00 0.00 ( 578.00) 0.00 47.00 694.00 0.00 ( 644.00) 0.00 0.00 503.46 0.00 ( 503.46) 0.00 300.00 5,449.48 0.00 ( 5,449.48) 0.00 675.06 9,171.87 0.00 ( 9,171.87) 0.00 975.06 15,124.81 0.00 ( 15,124.81) 0.00 1,022.06 15,768.81 0.00 ( 15,768.81) 0.00 0.00 0.00 0.00 89.78 89.78 0.00 ( .0.00 ( 89.78) 89.78) 0.00 0.00 89.78 0.00 ( 89.78) ' TOTAL REVENUE 0.00 1,022.06 15,858.59 0.00 ( 15,858.59) 12-09-2008 03:08 PM 223-SENIOR CITIZEN ACCOUNT DEPARTMENTAL EXPENDITURES PAGE: 3 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Sr Citizens Programs Supplies 223-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 223-4-5510-9409 Contractual Services TOTAL Other Services & Charges CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 0.00 1,051.83 15,907.70 0.00 ( 15,907.70) 0.00 1,051.83 15,907.70 0.00 ( 15,907.70) 0.00 948.00 4,097.12 0.00 ( 4,097.12) 0.00 948.00 4,097.12 0.00 ( 4,097.12) TOTAL Sr Citizens Programs 0.00 1,999.83 20,004.82 0.00 ( 20,004.82) Ceramics Supplies 223-4-5520-4219 Operating Supplies 0.00 0.00 522.85 0.00 ( 522.85) TOTAL Supplies 0.00 0.00 522.85 0.00 ( 522.85) TOTAL Ceramics 0.00 0.00 522.85 0.00 ( 522.85) Bingo Supplies 223-4-5530-9219 Operating Supplies 0.00 0.00 372.67 0.00 ( 372.67) TOTAL Supplies 0.00 0.00 372.67 0.00 ( 372.67) TOTAL Bingo 0.00 0.00 372.67 0.00 ( 372.67) TOTAL Culture & Recreation 0.00 1,999.83 20,900.34 0.00 ( 20,900.34) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 0.00 1,999.83 20,900.34 0.00 ( 20,900.34) 0.00 ( 977.77)( 5,041.75) 5,041.75 12-09-2008 03:08 PM 225-PARK DEDICATION FUND FINANCIAL SUMMARY REVENUE SUMMARY Park Dedication TOTAL REVENUES EXPENDITURE SUMMP,RY Culture & Recreation Parks Department TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 0.00 178,537.95 0.00 ( 178,537.95) 0.00 0.00 178,537.95 0.00 ( .178,537.95) 0.00 14.97 333,916.19 0.00 ( 333,916.19) O.b0 14.97 333,916.19 0.00 ( 333,916.19) 0.00 14.97 333,916.19 0.00 ( 333,916.19) 0.00 ( 14.97)( 155,378.24) 155,378.24 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 225-PARK DEDICATION FUND REVENUES 91.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 0.00 117,179.10 0.00 ( 117,179.10) 0.00 0.00 13,560.94 0.00 ( 13,560.94) 0.00 0.00 130,740.04 0.00 ( 130,740.04) 0.00 0.00 2,731.91 0.00 ( 2,731.91) 0.00 0.00 66.00 0.00 ( 66.00) 0.00 0.00 2,797.91 0.00 ( 2,797.91) 0.00 0.00 95,000.00 0.00 ( 45,000.00) 0.00 0.00 45,000.00 0.00 ( 45,000.00). 0.00 0.00 178,537.95 0.00 ( 178,537.95) TOTAL REVENUE 0.00 0.00 178,537.95 0.00 ( 178,537.95) 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 225-PARK DEDICATION FUND DEPARTMENTAL EXPENDITURES Parks Department Supplies 225-9-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 225-4-5110-4303 Engineering Fees 225-4-5110-4319 Other Professional Services 225-4-5110-9409 Contractual Services TOTAL Other Services & Charges Capital Outlay 225-4-5110-4510 Land 225-4-5110-9560 Equipment TOTAL Capital Outlay Debt Service 225-4-5110-4601 Principal 225-4-5110-4611 Interest TOTAL Debt Service 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET - PERIOD ACTUAL BUDGET BALANCE- 0.00 14.97 7,915.63 0.00 ( 7,915.63) 0.00 14.97 7,915.63 0.00 ( 7,915.63) 0.00 0.00 1,620.00 0.00 ( 1,620.00) 0.00 0.00 4,056.00 0.00 ( 4,056.00) 0.00' 0.00 2,041.85 0.00 ( 2,041.85) 0.00 D.00 7,717.85 0.00 ( 7,717.85) 0.00 0.00 43,486.25 0.00 ( 43,486.25) 0.00 0.00 37,406.00 0.00 ( 37,406.00) 0.00 0.00 80,892.25 0.00 ( 80,892.25) 0.00 0.00 190,250.00 0.00 ( 190,250.00) 0.00 0.00 47,140.46 0.00 ( 97,140.46) 0.00 0.00 237,390.96 0.00 ( 237,390.46) TOTAL Parks Department 0.00 14.97 333,916.19 0.00 ( 333,916.19) TOTAL Culture & Recreation 0.00 14.97 333,916.19 0.00 ( 333,916.19) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 0.00 14.97 333,916.19 0.00 ( 333,916.19) 0.00 ( 14.97)( 155,378.24) 155,378.24 12-09-2008 03:08 PM ' 228-LANDFILL FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 PAGE: 1 91.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' REVENUE SUMMARY I Landfill TOTAL REVENUES EXPENDITURE SUMMARY General Landfill TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 80,000.00 10,961.24 59,682.33 79.60 20,317.67 80,000.00 10,961.24 59,682.33 74.60 20,317.67 264,500.00 6,409.56 108,691.48 41.09 155,808.52 264,500.00 6,409.56 108,691.48 41.09 155,808.52 264,500.00 ------------- -- ------------- -- 6,409.56 ----------- - ----------- - 108,691.48 41.09 ------------ ------- - ------------ ------- - 155,808.52 ------------ ------------ ( 184,500.00) 4,551.68 ( 49,009.15) ( 135,490.85) 12-09-2008 03:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2008 228-LANDFILL REVENUES 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Landfill Intergovernmental Rev 228-3-0000-3341 County Reimb/Grant TOTAL Intergovernmental Rev Other Revenue 228-3-0000-3621 Interest Income TOTAL Other Revenue TOTAL Landfill 0.00 10,961.24 10,961.24 0.00 ( 10,961.24) 0.00 10,961.24 10,961.24 0.00 ( 10,961.24) 80,000.00 0.00 98,721.09 60.90 31,278.91 80,000.00 0.00 48,721.09 60.90_ 31,278.91 80,000.00 10,961.24 59,682.33 74.60 20,317.67 TOTAL REVENUE 80,000.00 10,961.24 59,682.33 74.60 20,317.67 12-09-2008 03:08 PM 228-LANDFILL ~ DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH,. 2008 PAGE: 3 91.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Landfill Personal Services 228-4-7000-9101 Regular Pay 228-4-7000-4104 PERA 228-9-7000-4105 FICA 226-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-4304 Legal Fees 228-4-7000-4319 Other Professional Services 228-4-7000-4389 Utilities 228-4-7000-4409 Contractual Services 228-4-7000-9440 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,335.20 11,228.95 62.04 6,871.05 1,200.00 86.80 1,281.42 106.79 ( 81.42) 1,150.00 66.78 963.18 83.75 186.82 250.00 15.63 225.31 90.12 24.69 2,300.00 138.40 2,831.49 123.11 ( 531.44) 23,000.00 1,642.81 16,530.30 71.87 6,469.70 45,000.00 0.00 50,179.76 111.51 ( 5,179.76) 45,000.00 0.00 50,179.76 111.51 ( 5,179.76) 20,000.00 412.20 412.20 2.06 19,587.80 50;000.00 0.00 1,764.88 3.53 98,235.12 1,500.00 308.88 4,942.08 329.47 ( 3,942.08). 60,000.00 0.00 1,060.00 1.77 58,940.00 0.00 9,045.67 6,722.26 0.00 ( 6,722.26) 131,500.00 4,766.75 14,901.42 11.33 116,598.58 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 Landfill 264,500.00 6,909.56 108,691.48 41.09 155,808.52 TOTAL General 264;500.00 6,409.56 108,691.48 41.09 155,808.52 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 264,500.00 6,409.56 108,691.48 41.09 155,808.52 ( 184,500.00) 9,551.68 ( 49,009.15) ( 135,490.85)