Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #2 02-17-2009
ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: February 17, 2009 SUBJECT: January 2009 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 January, actual revenues (except for property taxes and state aids) and expenditures should generally run about 8% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Revenues: • Property taxes, our largest revenue source, will be received in July and December. • The negative interest income is related to the reversal of the prior year's interest receivable which was done this month. • The transfers in will be recorded mid-year. Eacpenditurer• • Excluding transfers, the total depamnental expenditures are at about 5% and most departments are well within or below budget. • The Police Administration budget is at 10% due to the annual software maintenance contract that was paid lump sum in January. • The Snow Removal budget reflects the seasonal expenditures for salt. • The transfers out to the Ice Arena and Pinewood Golf are made at the end of the year. Ice Arena For January, revenues exceeded expenditures by about $49,500. Excluding transfers in, revenues axe at 9% of budget due to ice rental, concessions and admissions related to the hockey season while expenditure axe about 2% of budget attributable mainly to personal services. Pinewood Golf Golf revenues will not be generated until spring while expenditures are about 2% of the budget and are attributable to personal services 2-11-2009 11:11 AM - CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD PAGE: 1 08.33 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE ' REVENUE SUMMARY I General Fund TOTAL REVENUES . EXPENDITURE SUMMARY General Government Mayor & Council Cable TV Administrative Services Human Resources Finance Information Technology Legal Community Development "Planning City Hall Maintenance Contingency TOTAL General Government Public Safety Police Administration Patrol Investigations Police Support Services Police Reserves Public safety building Fire Administration Fire Inspections Emergency Management Building Safety Environmental TOTAL Public Safety Public Works Street Maintenance Snow Removal Equipment Services Engineering TOTAL Public Works 12,636,100.00 23,937.81 23,937.81 0.19 12,612,162.19 12,636,100.00 23,937.81 23,937.81 0.19 12,612,162.19 168,100.00 4,101.24 4,101.24 2.44 163,998.76 81,800.00 3,409.85 3,409.85 4.17 78,390.15 471,650.00 28,167.73 28,167.73 5.97 443,482.27 147,950.00 8,972.42 8,972.42 6.06 138,977.58 450,300.00 28,194.78 28,149.78 6:25 422,155.22 278,050.00 8,600.55 8,600.55 3.09 269,449.95 234,000.00 0.00 0.00 0.00 234,000.00 178,900.00 9,168.96 9,168.96 5.13 169,731.04 321,550.00 12,917.88 12,917.88 4.02 308,632.12 .286,350.00 11,070.00 11,070.00 3.87 275,280.00 70,050.00 0.00 0.00 0.00 70,050.00 2,688,700.00 114,553.91 114,553.41 4.26 2,574,146.59 669,150.00 67,040.36 67,040.36 10.09 597,109.64 2,192,800.00 93,163.37 93,163.37 4.25 2,099,636.63 714,150.00 31,838.42 31,838.42 4.96 682,311.58 492,050.00 26,727.51 26,727.51 5.43 .965,322.49 22,750.00 151.29 151.29 0.67 22,598.71 202,700.00 6,136.34 6,136.34 3.03 196,563.66 472,200.00. 21,543.38 21,543.38 9.56 450,656.62 188,850.00 8,671.16 8,671.16 4.59 180,178.84 49,150.00 888.98 888.98 1.81 48,261.02 653,950.00 36,057.69 36,057.69 5.51 617,892.31 76,000.00 3,773.64 3,773.64 4.97 72,226.36 5,728,750.00 295,992.14 295,992.14 5.17 5,432,757.86 1,373,000.00 30,795.83 30,795.83 2.24 1,342,204.17 308,750.00 51,333.33 51,333.33 16.63 257,416.67 255,450.00 10,459.74 10,454.74 4.09 244,995.26 191,150.00 114.96 114.96 0.06 191,035.09 2,128,350.00 92,698.86 92,698.86 4.36 2,035,651.14 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: -2- REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department. Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Developement Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 786,150.00 23,469.03 23,469.03 2.99 762,680.97 584,000.00 27,479.42 27,479.42 4.71 556,520.58 181,100.00 9,735.45 9,735.45 5.38 171,364.55 19,500.00 0.00 0.00 0.00 19,500.00 195,050.00 8,512.99 8,512.99 4.36 186,537.01 1,765,800.00 69,196.89 69,196.89 3.92 1,696,603.11 0.00 13,428.48 13,928.48 0.00 ( 13,428.48) 55,800.00 1,149.21 1,199.21 2.06 54,650.79 55,800.D0 14,577.69 19,577.69 26.12 41,222.31 268,700.00 0.00 0.00 0.00 268,700.00 268,700.00 0.00 0.00 0.00 268,700.00 12,636,100.00 587,018.99 587,018.99 4.65. 12,049,081.01 0.00 ( 563,081.18)( 563,081.18) 563,081.18 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,547,550.00 0.00 0.00 0.00 9,597,550.00 101-3-0000-3121 Gravel Tax 150,000.00 0.00 0.00 0.00 150,000.00 101-3-0000-3132 Tax Forfeited Land Sale 0.00 25.55 25.55 0.00 ( 25.55) TOTAL Property Taxes 9,697,550.00 25.55 25.55 0.00 9,697,529.95 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 51,000.00 0.00 0.00 1,000.00 0.00 0.00 3,000.00 0.00 0.00 15,850.00 0.00 0.00 9,000.00 0.00 0.00 3,000.00 3,020.00 3,020.00 13,000.00 8,285.00 8,285.00 5,000.00 0.00 0.00 188,300.00 9,672.40 9,672.40 47,600.00 9,371.93 9,371.93 200.00 656.04 656.04 100.00 0.00 0.00 3,000.00 325.00 325.00 1,500.00 1,100.00 1,100.00 12,000.00 1,500.00 1,500.00 353,550.00 33,930.37 33,930.37 686,800.00 O.OD 0.00 15,000.00 0.00 0.00 215,000.00 0.00 0.00 10,000.00 0.00 0.00 36,800.00 0.00 .0.00 12,500.00 0.00 0.00 7,500.00 0.00 0.00 983,600.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.67 63.73 0.00 5.14 19.69 328.02 0.00 10.83 73.33 9.60 51,000.00 1,000.00 3,000.00 15,850.00 9,000.00 20.00) 9,715.00 5,000.00 178,627.60 38,228.07 456.04) 100.00 2,675.00 400.00 10,500.00 Intergovernmental Rev 101-3-0000-3321 Local Government Aid 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-3391 County Reimb/Grant TOTAL Intergovernmental Rev 319,619.63 0.00 686,800.00 0.00 15,000.00 0.00 215,000.0.0 0.00 10,000.00 0.00 36,800.00 0.00 12,500.00 0.00 7,500.00 0.00 983,600.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 2,900.00 2,900.00 11.60 22,100.00 101-3-0000-3413 Plan Check Fee 75,300.00 3,931.57 3,931.57 5.22 71,368.43 101-3-0000-3415 Special Assessment Search 500.00 60.00 60.00 12.00 440.00 101-3-0000-3417 Copies 1,500.00 464.00 464.00 30.93 1,036.00 101-3-0000-3418 Other General Govt Services 5,000.00 0.00 0.00 0.00. 5,000.00 101-3-0000-3430 Lockout Fees 8,500.00 1,000.00 1,000.00 11.76 7,500.00 101-3-0000-3431 Police Services 2,000.00 61.00 61.00 3.05 1,939.00 101-3-0000-3432 School Liaison 75,000.00 37,500.00 37,500.00 50.00 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 120.00 120.00 9.00 2,880.00 101-3-0000-3436 Fire Contracts 208,000.00 0.00 0.00 0.00 208,000.00 2-11-2009 11:11 AM 101-GENERAL FUND REVENUES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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-3972 Park Use Fee 101-3-0000-3474 Facility Use Fee 101-3-0000-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3489 Contractor License Check TOTAL Charges for Services Fines, Fees, & Forfeit 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines, Fees, & Forfeit 1,000.00 0.00 25,000.00 0.00 121,500.00 2,473.00 20,100.00 1,114.61 2,600.00 120.00 3,100.00 332.50 2,400.00, 200.00 5,000.00 0.00 500.00 30.00 585,000.00 50,306.68 0.00 0.00 1,000.00 0.00 0.00 25,000.00 2,473.00 2.09 119,027.00 1,114.61 5.55 18,985.39 120.00 4.62 2,480.00 332.50 10.73 2,767.50 200.00 8.33 2,200.00 0.00 0.00 5,000.00 30.00 6.00 470.00 50,306.68 8.60 534,693.32 150,000.00 0.00 0.00 0.00 150,000.00 7,000.00 2,980.00 2,480.00 35.43 4,520.00 157,000.00 2,480.00 2,980.00 1.58 154,520.00 Other Revenue 101-3-0000-3621 Interest Income 180,000.00 ( 66,790.99)( 66,790.99) 37.11- 246,790.99 101-3-0000-3625 Refunds & Reimbursements 59,000.00 0.00 0.00 0.00 54,000.00 101-3-0000-3626 Contributions 22,800.00 1,008.00 1,008.00 4.42 21,792.00 101-3-0000-3629 Miscellaneous Revenue 3,000.00 2,978.20 2,978.20 99.27 21.80 TOTAL Other Revenue 259,800.00 ( 62,804.79)( 62,804.79) 24.17- 322,604.79 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-ARA TOTAL Transfers In 35,000.00 0.00 39,500.00 0.00 50,000.00 0.00 248,600.00 0.00 200,000.00 0.00 17,000.00 0.00 9,500.00 0.00 599,600.00 0.00 0.00 0.00 35,000.00 0.00 0.00 39,500.00 0.00 0.00 50,000.00 0.00 0.00 248,600.00 0.00 0.00 200,000.00 0.00 0.00 17,000.00 0.00 0.00 9,500.00 0.00 0.00 599,600.00 TOTAL General Fund 12,636,100.00 23,937.81 23,937.81 0.19 12,612,162.19 TOTAL REVENUE 12,636,100.00 23,937.81 23,937.81 0.19 12,612,162.19 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND ' DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TODATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-4104 PERA 101-4-1110-4105 FICA 101-4-1110-4107 Medicare 101-4-1110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1110-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-9322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4940 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,208.00 1,950.00 102.07 2,900.00 198.90 550.00 96.52 50.00 9.75 43,450.00 3,565.24 3,200.00 0.00 3,200.00 0.00 3,208.00 8.33 35,292.00 102.07 5.23 1,897.93 198.90 8.29 2,201.10 46.52 8.46 503.48 9.75 19.50 40.25 3,565.24 8.21 39,884.76 0.00 0.00 3,200.00 0.00 0.00 3,200.00 6,750.00. 536.00 536.00 7.94 6,214.00 800.00 0.00 0.00 0.00 800.00 6,500.00 0.00 0.00 0.00 6,500.00 18,200.00 0.00 0.00 0.00 18,200.00 64,800.00 0.00 0.00 0.00 64,800.00 15,000.00 0.00 0.00 0.00 15,000.00 9,400.00 0.00 0.00 0.00 9,900.00 121,450.00 536.00 536.00 0.49 120,914.00 TOTAL Mayor & Council Cable TV Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 168,100.00 4,101.24 9,101.29 2.44 163,998.76 50,600.00 2,251.21 11,800.00 137.50 3,550.00 247.16 4,000.00 .237.24 950_00 55.48 5,250.00 438.01 200.00 43.25 76,350.00 3,409.85 3,350.00 0.00 3,350.00 0.00 2,251.21 4.45 48,348.79 137.50 1.17 11,662.50 297.16 6.96 3,302.84 237.24 5.93 3,762.76 55.48 5.84 894.52 438.01 8.39 9,811.99 43.25 21.63 156.75 3,409.85 4.47 72,940.15 0.00 0.00 3,350.00 0.00 0.00 3,350.00 2-11-2009 11:11 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES PAGE: 6 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGES PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-1120-4319 Other Professional Services 101-4-1120-4322 Postage 101-9-1120-4331 Travel, Conferences & Schools 101-9-1120-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 500.00 0.00 100.00 0.00 1,900.00 0.00 100.00 0.00 2,100.00 0.00 0.00 0.00 500.00 0.00 0.00 100.00 0.00 0.00 1,900.00 0_00 0.00 100.00 0.00 0.00 2,100.00 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-9321 Telephone 101-4-1210-9322 Postage 101-4-1210-4331 Travel, Conferences & Schools 101-4-1210-4361 Insurance 101-4-1210-4404 Equip Repair/Maint Services 101-4-1210-4433 Dues & Subscriptions 101-4-1210-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Administrative Services Human Resources 81,800.00 3,409.85 3,409.85 4.17 78,390.15 296,750.00 13,434.40 13,434.40 4.53 283,315.60 2,000.00 0.00 0.00 0.00 2,000.00 .45,600.00 1,924.80 1,924.80 4.22 43,675.20 23,250.00 1,687.42 1,687.92 7.26 21,562.58 21,350.00 1,536.73 1,536.73 7.20 19,813.27 4,800.00 400.00 400.00 8.33 4,900.00 5,000.00 359.90 359.40 7.19 4,640.60 23,450.00 1,954.03 1,954.03 8.33 21,495.97 1,300.00 350.50 350.50 26.96. 999.50 423,500.00 21,647.28 21,647.28 5.11 401,852.7.2 9,900.00 143.90 193.90 1.45 9,756.10 9,900.00 143.90 193.90 1.45 9,756.10 4,500.00 4,860.00 4,860.00 108.00 ( 360.00) 600.00 0.00 0.00 0.00 600". 00 1,500.00 0.00 0.00 0.00 1,500.00 5,600.00 0.00 0.00 0.00 5,600.00 200.00 0.00 0.00 0.00 200.00 22,600.00 1,366.55 1,366.55 6.05 21,233.45 2,600.00 150.00 150.00 5.77 2,450.00 650.00 0.00 0.00 0.00 650.00 38,250.00 6,376.55 6,376.55 16.67 31,873.45 471,650.00 28,167.73 28,167.73 5.97 443,482.27 2-11-2009 11:11 AM _ CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 Workers Comp TOTAL Personal Services. Supplies 101-4-1220-9201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-9433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges TOTAL Human Resources Elections Personal Services Supplies Other Services & Charges CURRENT CURRENT BUDGET PERIOD 68,850.00 3,131.54 3,131.54 4.55 65,718.46 45,200.00 2,317.83 2,317.83 5.13 92,882.17 7,700.00 605.71 605.71 7..87 7,094.29 7,100.00 561.49 561.49 7.91 6,538.51 1,650.00 131.31 131.31 7.96 1,518.69 5,250.00 438.00 438.00 8.34 4,812.00 450.00 116.25 116..25 25.83 333.75 136,200.00 7,302.13 7,302.13 5.36 128,897.87 3,000.00 1,607.49 1,607.49 53.58 1,392.51 3,000.00 1,607.49 1,607.49 53.58 1,392.51 3,000.00 0.00 0.00 0.00 3,000.00 350.00 0.00 0.00 0.00 350.00 3,750.00 0.00 0.00 0.00 3,750.00 650.00 0.00 0.00 0.00 650.00 1,000.00 62.80 62.80 6.28 937.20 8,750.00 62.80 62.80 0.72 8,687.20 147,950.00 8,972.42 8,972.4.2 6.06 138,977.58 08.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Finance Personal Services 101-4-1310-9101 Regular Pay 101-4-1310-4103 Part-time Pay 101-4-1310-4104 PERA 101-4-1310-4105 FICA 101-4-1310-4107 Medicare 101-4-1310-4108 Insurance 101-4-1310-4109 Workers Comp TOTAL Personal Services 284,350.00 12,795.09 5,150.00 130.00 19,550.00 1,404.64 17,950.00 1,225.04 4,200.00 286.50 23,450.00 1,954.03 1,100.00 295.25 355,750.00 18,090.55 12,795.09 4.50 271,554.91 130.00 2.52 5,020.00 1,404.64 7.18 .18,145.36 1,225.09 6.82 16,724.96 286.50 6.82 3,913.50 1,954.03 8.33 21,495.97 295.25 26.84 804.75 18,090.55 .5.09 337,659.95 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-9321 Telephone 101-9-1310-9322 Postage 101-9-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-9404 Equip Repair/Maint Services 101-4-1310-9433 Dues & Subscriptions 101-4-1310-9490 Miscellaneous TOTAL Other Services & Charges TOTAL Finance 450,300.00 Information Technology Personal Services 101-9-1350-4101 Regular Pay 129,300.00 101-4-1350-9103 Part-time Pay 12,850.00 101-4-1350-9104 PERA 9,600.00 101-4-1350-9105 FICA 8,800.00 101-9-1350-4107 Medicare 2,050.00 101-9-1350--4108 Insurance 15,350.00 101-4-1350-9109 Workers Comp 550.00 TOTAL Personal Services 178,500.00 Supplies 101-4-1350-9219 Operating Supplies 23,300.00 TOTAL Supplies 23,300.00 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 101-4-1350-4321 Telephone 800.00 101-4-1350-4331 . Travel, Conferences & Schools 4,500.00 101-4-1350-4404 Equip Repair/Maint Services 19,.950.00 TOTAL Other Services & Charges 33,250.00 Capital Outlay 101-4-1350-4560 Equipment 43,000.00 TOTAL Capita l Outlay 43,000.00 4,850.00 65.41 4,850.00 65.41 65.41 1.35 9,789.59 65.41 1.35 4,784.59 17,300.00 0.00 0.00 0.00 .17,300.00 48,150.00 0.00 0.00 0.00 48,150.00 850.00 0.00 0.00 0.00 850.00 3,600.00 0.00 0.00 0.00 3,600.00 4,150.00 341.50 391.50 8.23 3,808.50 2,000.00 0.00 0.00 0.00 2,000.00 12,100.00 9,375.32 9,375.32 77.48 2,729.68 1,550.00 180.00 180.00 11.61 1,370.00 0.00 92.00 92.00 0.00 ( 92.00) 89,700.00 9,988.82 9,988.82 11.14 79,711.18 28,194.78 28,194.78 6.25 422,155.22 5,835.02 -0.00 640.53 567.31 132.67 1,280.02 195.00 8,600.55 5,835.02 4.51 123,969.98 0.00 0.00 12,850.00 690.53 6.67 8,959.47 567.31 6.45 8,232.69 132.67 6.47 1,917.33 1,280.02 8.34 14,069.98 145.00 26.36 905.00 8,600.55 4.82 169,899.45 0.00 0.00 0.00 23,300.00 0.00 0.00 0.00 23,300.00 0.00 0.00 0.00 8,000.00 0.00 0.00 0.00 800.00 0.00 0.00 0.00 4,500.00 0.00 0.00 0.00 19,950.00 0.00 0.00 0.00 33,250.00 0.00 0.00 0.00 43,000.00 0.00 0.00 0.00 .43,000.00 TOTAL Information Technology 278,050.00 8,600.55 8,600.55 3.09 269,449.45 ^ 2-11-2009 11:11 AM ' 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 PAGE: 9 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Legal Other Services & Charges 101-4-1400-4309 Legal Fees TOTAL Other Services & Charges 239,000.00 0.00 0.00 0.00 239,000.00 234,000.00 0.00 0.00 0.00 234,000.00 TOTAL Legal 239,000.00 Community Development Personal Services 101-4-1500-4101 Regular Pay 139,750.00 101-4-1500-4104 PERA 9,450.00 101-4-1500-4105 FICA 8,700.00 101-4-1500-4107 Medicare 2,050.00 101-4-1500-4108 Insurance 15.,600.00 101-4-1500-4109 Workers Comp 550.00 TOTAL Personal Services 176,100.00 Supplies . 101-4-1500-4201 Office Supplies 250.00 TOTAL Supplies 250.00 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 TOTAL Other Services & Charges 2,550.00 0.00 0.00 0.00 234,000.00 6,270.58 6,270.58 4.49 133,479.42 688.38 688.38 7.28 8,761.62 604.02 604.02 6.94 8,095.98 141.26 141.26 6.89 1,908.74 1,0.78.01 1,078.01 6.91 14,521.99 142.50 142.50 25.91 407.50 8,924.75 8,924.75 5.07 167,175.25 32.71 32.71 13.08 217.29 32.71 32.71 13.08 217.29 211.50 211.50 8.29 2,338.50 211.50 211.50 8.29 2,338.50 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-9108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services 178,900.00 9,168.96 9,168.96. 5.13 169,731.09 210,300.00 9,091.41 9,091.41 4.32 201,208.59 14,200.00 885.53 885.53 6.24 13,314.47 13,-050.00 742.96 742.96 5.69. 12,307.04 3,050.00 173.77 173.77 5.70 2,876.23 28,300.00 1,500.01 1,500.01 5.30 26,799.99 500.00 155.50 155.50 31.10 349.50 269,400.00 12,549.18 12,549.18 4.66 256,850.82 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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-9-1510-4322 Postage 101-4-1510-4331 Travel,. Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-9361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4933 Dues & Subscriptions 101-4-1510-4940 Miscellaneous TOTAL Other Services & Charges TOTAL Planning City Hall Maintenance Personal Services. 101-4-1600-4101 Regular Pay 101-4-1600-4102 Overtime Pay 101-4-1600-4103 Part-time Pay 101-4-1600-9104 PERA 101-4-1600-4105 FICA 101-4-1600-4107 Medicare 101-4-1600-4108 Insurance 101-4-1600-4109 Workers Comp TOTAL Personal Services , Supplies 101-9-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone 101-4-1600-4331 Travel, Conferences & Schools 101-4-160.0-4361 Insurance 101-4-1600-4389 Utilities 101-9-1600-4401 Bldg Repair/Maint Services 101-4-1600-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 5,200.00 111.20 111.20 2.14 5,088.80 850.00 0.00 0.00 0.00 850.00 6,050.00 111.20 111.20 1.84 5,938.80 2-0,000.00 0.00 0.00 0.00 20,000.00 800.00 0.00 0.00 0.00 800.00 2,000.00 0.00 0.00 0.00 2,00.0.00 6,350.00 211.50 211.50 3.33 6,138:50 10,000.00 0.00 0.00 0.00 10,000.00 700.00 0.00 0.00 0.00 700.00 5,000.00 0.00 0.00 0.00 5,000.00 1,000.00 0.00 0.00 0.00 1,000.00 250.00 46.00 46.00 18.40 204.00 46,100.00 257.50 257.50 0.56 45,842.50 321,550.00 12,917.88 12,917.88 9.02 308,632.12 83,750.00 5,505.07 5,505.07 6.57 78,244.93 9,100.00 0.00 0.00 0:00 9,100.00 18,450.00 570.72 570.72 3.09 17,879.28 7,800.00 621.04 621.04 7.96 7,178.96 7,150.00 562.26 562.26 7.86 6,587.79 1,700.0-0 131.50 131.50 7.74 1,568.50 11,900.00 1,343.02 1,343.02 11.29 10,556.98 2,550.00 1,068.75 1,068.75 91.91 1,481.25 142,400.00 9,802.36 9,802.36 6.88 132,597.64 3,750.00 0.00 0.00 0.00 3,750.00 1,700.00 0.00 0.00 0.00 1,700.00 30,000.00 0.00 0.00 0.00 30;000.00 35,450.00 0.00 0.00 0.00 35,450.00 15,950:00 855.61 855.61 5.54 19,594.39 2,000.00 40.00 90.00 2.00 1,960.00 5,700.00 0.00 0.00 0.00 5,700.00 51,800.00 0.00 0.00 0.00 51,800.00 .32,300.00 372.03 372.03 1.15 31,927.97 1,250.00 0.00 0.00 0.00 1,250.00 108,500.00 1,267.64 1,267.69 1.17 107,232.36 I 2-11-2009 11:11 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES PAGE: 11 08.33°s OF YEAR COMP. CURRENT CURRENT YEP,R TO DATE $ OF BUDGET BUDGET PERIOD .ACTUAL BUDGET BALANCE ' Capital Outlay TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges ' TOTAL Contingency 286,350.00 11,070.00 11,070.00 3.87 275,280.00 70,050.00 0.00 0.00 0.00 70,050.00 70,050.00 0.00 0.00 0.00 70,050.00 70,050.00 0.00 0.00 0.00 70,050.00 TOTAL General Government Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-4-2110-4104 PERA 101-4-2110-4105 FICA 101-4-2110-9107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-4319"Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-9322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-4361 Insurance 101-9-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges, 2,688,700.00 114,553.41 114,553.41 4.26 2,574,146.59 332,900.00 12,660.21 12,660.21 3.80 320,239.79 93,000.00 2,941.36 2,991.36 6.84 40,058.64 3,300.00 1,116.38 1,116.38 33.83 2,183.62 3,350.00 960.84 460.84 13.76 2,889.16 28,500.00 1,938.01 1,938.01 6.80 26,561.99 48,500.00 12,970.25 12,970.25 26.74 35,529.75 959,550.00 32,087.05 32,087.05 6.98 427,462.95 16,000.00 0.00 0.00 0.00 16,000.00 2,500.00 0.00 0.00 0.00 2,500.00 3,150.00 0.00 0.00 0.00 3,150.00 21,650.00 0.00 0.00 0.00 21,650.00 5.,500.00 0.00 0.00 0.00 25,000.00 869.6.1 869.61 3.48 2,100.00 0.00 0.00 0.00 9,200.00 953.95 953.95 10.81 500.00 0.00 0.00 0.00 12,450.00 0.00 0.00 0.00 69,250.00 33,179.75 33,174.75 47.91 5,850.00 910.00 410.00 7.01 500.00 95.00 45.00 9.00 125,350.00 34,953.31 34,953.31 27.88 5,500.00 24,130.39 2,100.00 3,746.05 500.00 12,450.00 36,075.25 5,440.00 90,396.69 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES 08.33 a-OF YEAR COMP. CURRENT .CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-2.110-4560 Equipment TOTAL Capital Outlay 57,600.00 0.00 0.00 0.00 57,600.00 57,600.00 0.00 0.00 .0.00 57,600.00 TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-9104 PERA 101-9-2120-4107 Medicare 101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-4219 Operating Supplies 101-4-2120-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 101-4-2120-9404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay TOTAL Patrol Investigations Personal Services 101-9-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-9104 PERA '~ 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services 664,150.00 67,090.36 67,040.36 10.09 597,109.64 1,435,250.00 63,590.67 63,590.67 9.93 1,371,659.33 90,000.00 696.99 696.99 0.77 89,303.01 215,050.00 14,468.10 14,468.10 6.73 200,581.90 19,800.00 1,266.57 1,266.57 6.40 18,533.43 150,900.00 12,978.07 12,978.07 8.63 137,421.93 1,910,500.00 93,000.40 93,000.40 4.87 1,817,499.60 105,000.00 199.95 199.95 0.19 104,800.05 17,200.00 ( 36.98)( 36.98) 0.22- 17,236.98 49,000.00 0.00 0.00 0.00 49,000.00 25,000.00 0.00 0.00 0.00 25,000.00 196,200.00 162.97 162.97 0.08 196,037.03 14,650.00 0.00 0.00 0.00 14,650.00 27,200.00 0.00 0.00 0.00 27,200.00 550.00 0.00 0.00 0.00 550.00 43,700.00 0.00 0.00 0.00 43,700.00 86,100.00 0.00 0.00 0.00 86,100.00 2,192,800.00 93,163.37 .93,163.37 9.25 2,099,636.63 495,800.00 21,416.64 21,916.64 4.32 974,383.36 40,000.00 140.09 190.09 0:35 39,859.91 75,550.00 4,859.88 4,859.88 6.43 70,690.12 5,600.00 316.95 316.95 5.66 5,283.05 58,600.00 4,914.94 .4,914.94 8.39 53,685.06 675,550.00 31,648.50- 31,648.50 4.68 643,901.50 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT-(UNAUDITED) AS OF: JANUARY 31ST, 2009 I 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-4319 Other Professional Services 101-4--2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 9,850.00 ( 30.08)( 30.08) 0.62- 4,880.08 8,400.00 0.00 0.00 -0.00 8,900.00 13,250.00 ( 30.08)( 30.08) 0.23- 13,280.08 10,750.00 220.00 220.00 2.05 10,530.00 9,000.00 0.00 0.00 0.00 4,000.00 200.00 -0.00 0.00 0.00 200.00 10,400.00 0.00 0.00 0.00 10,400.00 25,350.00 220.00 220.00 0.87 25,130.00 TOTAL Investigations Police Support Services Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-9108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-4-2150-4409 Contractual Services 101-4-2150-9433 Dues & Subscriptions 101-4-2150-4960 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Police Support Services 714,150.00 31,838.42 31,838.42 4..46 682,311.58 346,900.00 15,753.53 15,753.53 9.54 331,146.47 6,500.00 0.00 0.00 0.00 6,500.00 23,.850.00 1,722.36 1,722.36 7.22 22,127.64 21,900.00 1,569.58 1,569.58 7.17 20,330.42 5,100.00 367.07 367.07 7.20 9,732.93 42,050.00 3,504.02 3,509.02 8.33 38,545.98 446,300.00. 22,916.56 22,916.56 5.13 423,383.44 1,000.00 0.00 0.00 0.00 1,000.00 3,250.00 0.00 0.00 0.00 3,250.00 8,050.00 0.00 0.00 0.00 8,050.00 12,300.00 0.00 0.00 0.00 12,300.00 3,550.00 0.00 0.00 0.00 3,550.00 5,500.00 3,675.00 3,675.00 66.82 1,825.00 16,000.00 90.95 90.95 0.57 15,909.05 500.00 45.00 .45.00 9.00 455.00 7,900.00 0.00 0.00 0.00 7,900.00 33,450.00 3,$10.95 3,810.95 11.39 29,639.05 492,050.00 26,727.51- 26,727.51 5.43 465,322.49 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPOR T (UNAUDITED) AS OF: JANUARY 31ST, 2009 _ 101-GENERAL FUND Public Safety 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 0.00 0.00 5,500.00 101-4-2160-4105 FICA 350.00 0.00 0.00 0.00 350.00 101-4-2160-9107 Medicare 100.00 0.00 0.00 0.00 100.00 TOTAL Personal Services 5,950.00 0.00 0.00 0.00 5,950.00 Supplies 101-4-2160-4217 Uniform Allowance 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2160-4219 Operating Supplies 6,000.00 0.00 0.00 0.00 6,000.00 TOTAL Supplies 11,000.00 0.00 0.00 0.00 11,000.00 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2160-9321 Telephone 1,600.00 151.29 151.29 9.46 1,448.71 101-4-2160-9331 Travel, Conferences & Schools 1,700.00 0.00 0.00 0.00 1,700.00 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 5,800.00 151.29 151.29 2.61 5,648.71 TOTA1, Police Reserves 22,750.00 151.29 151.29 0.67 22,598.71 Public safety building Personal Services 101-4-2190-4101 Regular Pay 98,200.00 2,952.67 2,952.67 3.01 95,247.33 101-4-2190-4102 Overtime Pay 450.00 0.00 0.00 0.00 450.00 101-4-2190-4104 PERA 6,650.00 354.25 354.25 5.33 6,295.75 101-4-2190-4105 FICA 6,100.00 333.42 333.42 5.97 5,766.58 101-4-2190-4107 Medicare 1,450.00 77.99 77.99 5.38 1,372.01 101-4-2190-9108 Insurance 14,250.00 763.94 763.44 5.36 13,986.56 101-4-2190-4109 Workers Comp 2,200.00 947.75 947.75 93.08 1,252.25 TOTAL Personal Services 129,300.00 .5,429.52 5,429.52 4.20 123,870.48 Supplies 101-4-2190-9219 Operating Supplies 17,000.00 0.00 0.00 0.00 17,000.00 TOTAL Supplies 17,000.00 0.00 0.00 0.00 17,000.00 Other Services & Charges 101-4-2190-4361 Insurance 6,900.00 0.00 0.00 0.00 6,900.00 101-4-2190-4389 Utilities 18,200.00 0.00 0.00 0.00 18,200.00 101-4-2190-4401 Bldg Repair/Maint Services 31,300.00 706.82 706.82 2.26 30,593.18 TOTAL Other Services & Charges 5.6,400.00 706.82 706.82 1.25 55,693.18 TOTAL Public safety building 202,700.00 6,136.34 6,136.39 3.03 196,563.66 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Fire Administration ------------------- ------------------- Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4109 PERA 101-4-2310-4105 FICA 101-9-2310-9106 Other Retirement Contributions 101-4-2310-9107 Medicare 101-4-2310-4108 Insurance 101-9-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 Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-9359 Publishing 101-4-2310-4361 Insurance 101-4-2310-4389 Utilities 101-9-2310-4401 Bldg Repair/Maint Services 101-4-2310-4404 Equip Repair/Maint Services 101-4-2310-4433 Dues & Subscriptions 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Fire Administration Fire Inspections ---------------- Personal Services 101-4-2320-9101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services 90,.850.00 9,525.98 4,525.98 4.98 86,324.02 150,350.00.. 8,259.34 8,259.39 5.49 142,090.66 13,250.00 1,030.81 1,030.81 7.78 12,219..19 10,050.00 917.66 917.86 9.13 9,132.14 30,000.00 0.00 0.00 0.00 30,000.00 3,500.00 296.12 296.12 8.46 3,203.88 9,150.00 814.40 814.40 8.90. 8,335.60 15,350.00 3,929.00 3,929.00 25.60 11,421.00 322,500.00 .19,773.51 19,773.51 6.13 302,726.49 1,200.00 0.00 0.00 0.00 1,200.00 7,950.00 0.00 0.00 0.00 7,950.00 1,100.00 0.00 0.00 0.00 1,100..00 32,900.00 12.14 12.14 0.04 32,387.86 42,650.00 12.14 12.14 0.03 42,637.86 4,950.-00 0.00 0.00 0.00 4,950.00 2,700.00 182.73 182.73 6.77 2,517.27 500.00 0.00 0.00 0.00 500.00 19,850.00 450.00 950.00 2.27 19,400.00 500.00 0.00 0.00 0.00. 500.00 21,300.00 0.00 0.00 0.00 21,300.00 15,150.00 0.00 0.00 0.00 15,150.00 4,000.00 0.00 0.00 0.00 9,000.00 20,850.00 0.00 0.00 0.00 2.0,850.00 2,000.00 1,125.00 1,:125.00 56.25 875.00 15,250.00 0.00 0.00 0.00 15,250.00 107,050.00 1,757.73 1,757.73 .1.64 105,292.27 472,200.00 21,543.38 21,543.38 4.56 450,656.62 132,250.00 6,014.85 6,014.85 4.55 126,235.15 2,000.00 0.00 0.00 0.00 2,000.00 14,700.00 1,068.63 1,068.63 7.27 13,631.37 7,600.00 270.00 270.00 3.55 7,330.00 1,900.00 141.55 141.55 7.45 1,758.45 13,700.00 1,142.00 1,142.00 8.34 12,558.00 17,2,150.00 8,637.03 8,637.03 5.02 163,512.97 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4933 Dues & Subscriptions TOTAL Other Services & Charges CURRENT CURRENT BUDGET PERIOD 08.33 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 0.00 0.00 '0.00 3,000..00 800.00 0.00 0.00 0.00 800.00 4,150.00 0.00 0.00 0.00 4,150.00 9,900.00 0.00 0.00 0.00 9,900.00 1,350.00 34.13 34.13 2.53 1,315.87 150.00 0.00 0.00 0.00 150.00 2,750.00 0.00 0.00 0.00 2,750.00 200.00 0.00 0.00 0.00 200.00 1,850.00 0.00 0.00 0.00 1,850.00 500.00 0.00 0.00 0.00 500.00 6,800.00 34.13 34.13 0.50 6,765.87 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-4104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 101-4-2330-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2330-4321 Telephone 101-4-2330-4322 Postage 101-4-2330-4331 Travel, Conferences & Schools 101-4-2330-4359 Publishing 101-4-2330-4389 Utilities 101-9-2330-4404 Equip Repair/Maint Services 101-4-2330-4433 Dues & Subscriptions TOTAL Other Services & Charges 188,850.00 8,671.16 8,671.16 4.59 180,178.89 9,950.00 451.63 951.63 4.54 9,498.37 1,400..00 101.03 101.03 7.22 1,298.97 150.00 10.19 10.19 6.79 139.81 800.00 64.01 69.01 8.00 735.99 12,300.00 626.86 626.86 5.10 11,673.14 2,500.00 0.00 0.00 0.00. 2,500.00 8,500.00 0.00 0.00 0.00 8,500.00 11,000.00 0.00 0.00 0.00. 11,000.00 1,500.00 62.12 62.12 4.14 1,437.88 100.00 0.00 0.00 0.00 100.00 1,850.00 0.00 0.00 0.00 1,850.00 500.00 0.00 0.00 0.00. 500.00 1,500.00. 0.00 0.00 0.00 1,500.00 5,100.00 0.00 0.00 0.00 5,100.00 400.00 200.00 200.00 50.00 200.00 10,950.00 262.12 262.12 2.39 10,687.88 2-11-2009 11:11 AM ' 101-GENERAL FUND Public Safety ' DEPARTMENTAL EXPENDITURES PAGE: 17 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 14,900.00 0.00 0.00 0.00 14,900.00 14,900.00 0.00 0.00 0.00 19,900.00 TOTAL Emergency Management Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4102 Overtime Pay 101-9-2410-4103 Part-time Pay 101-9-2410-4104 PERA 101-4-2410-4105 FICA 101-4-2410-4107 Medicare 101-4-2410-4108 Insurance 101-4-2410-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2410-4201 Office Supplies 101-4-2410-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-2410-4321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-9361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4440 Miscellaneous 101-4-2410-4960 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay .CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 49,150.00 888.98 888.98 1.81 48,261.02 438,300.00 20,341.38 20,391.38 4.64 917,958.62 500.00 0.00 0.00 0.00 500.00 23,950.00 1,200.80 1,200.80 5.12 22,249.20 31,200.00 2,450.46 2,450.96 7.85 28,749.54 28,650.00 2,080.58 2,080.58 7.26 26,569.42 6,700.00 486.58 486.58 7.26 6,213.42 52,000.00 4,972.02 9,972.02 9.56 47,027.98 1,400.00 329.25 329.25 23.52 1,070.75 582,200.00 31,861.07 31,861.07 5.47 550,338.93 3,000.00 98.10 98.10 3.27 2,901.90 10,950.00 10.75 10.75 0.10 10,939.25 2,150.00 0.00 0.00 0.00 2,150.00 2,650.00 0.00 0.00 0.00 2,650.00 18,750.00 108.85 108.85 0.58 18,641.15 7,100.00 68.55 68.55 0.97 7,031.45 1,500.00 0.00 0.00 0.00 1,500.00 11,500.00 1,803.35 1,.803.35 15.68 9,696.65 16,500..00 0.00 0.00 0.00 16,500.00 10,400.00 2,015.87 2,015.87 19.38 8,384.13 1,200.00 200.00 200.00 16.67 1,000.00 2,500.00 0.00 0.00 0.00 2,500.00 2,300.00 0.00 0.00 0.00 2,300.00 53,000.00 4,087.77 .4,087.77 7.71 48,912.23 TOTAL Building Safety 653,950.00 36,057.69 36,057.69 5.51 617,892.31 2-11-2009 11:11 AM 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-4109 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-9109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs 101-4-2940-4217 Uniform Allowance TOTAL Supplies CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT -(UNAUDITED) AS OF: JANUARY 31ST, 2009 Other Services & Charges 101-4-2440-4321 Telephone 101-4-2440-9322 Postage 101-4-2940-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4404 Equip Repair/Maint Services 101-4-2440-4409 Contractual Services 101-4-2440-9433 Dues & Subscriptions I01-4-2440-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Environmental TOTAL Public Safety Street Maintenance ------------------ ------------------ Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-9102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4109 PERA 101-4-3120-4105 FICA 101-4-3120-9107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services 08.33$ OF YEAR COMP CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 52,200.00 2,417.12 2,417.12 4.63 49,782.88 3,500.00 280.45 280.45 8.01 3,219.55 3,200.00 192.61 192.61 6.02 3,007.39 750.00 45.04 45.04 6.01 704.96 8,450.00 720.80 720.80 8.53 7,729.20 350.00 98.00 98.00 28.00 252.00 68,450.00 3,754.02 3,754.02 5.48 64,695.98 650.00 19.62 19.62 3.02 630.38 200.00 0.00 0.00 0.00 200.00 200.00 0.00 0.00 0.00 200.00 1,050.00 19.62 19.62 1.87 1,030.38 '1,350.00 0.00 0.00 0:00 1,350.00 500.00 0.00 0.00 0..00 500.00 500.00 0.00 0.00 0.-00 500.00 500.00 0.00 0.00 0.00 500.00 300.00 0.00 0.00 0.00 300.00 50.00 0.00 0.00 0.00 50.00 1,500.00. 0.00 0.00 0.00 1,500.00 1,050.00 0:00 0.00 0.00 1,050.00 750.00 0.00 0.00 0.00 750.00 6,500.00 0.00 0.00 0.00 6,500.00 76,000.00 3,773.64 3,773.64 .4.97 72,226.36 5,728,750.00 295,992.14 295,992.19 5.17 5,432,757.86 445,350.00 15,677.94 15,677.94 3.52 429,672.06 10,400.00 ( 63.54)( 63.54) 0.61- 10,963.54 68,950.00 2,178.29 2,178.29 3.16 66,771.71 34,650.00 1,718.68 1,718.68 4.96 32,931.32 32,050.00 1,563.62 1,563.62 4.88 30,486.38 7,500.00 365.66 365.66 4.88 7,139.34 58,050.00 4,375.38 4,375.38 7.54 53,674.62. 20,000.00 4,922.75 9,922.75 24.61 15,077.25 676,950.00 30,738.78 30,738.78 9.59 696,211.22 2-11-2-009 11:11 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 I 101-GENERAL FUND Public Works I DEPARTMENTAL EXPENDITURES Supplies 101-4-3120-4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-4-3120-921.9 Operating Supplies 101-4-3120-9226 Street Signs TOTAL Supplies Other Services & Charges 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-9401 Bldg Repair/Maint Services 101-4-3120-4409 Contractual Services 101-4-3120-4415 Equipment Rental. 101-4-3120-4417 Uniform Rental 101-4-3120-4433 Dues & Subscriptions 101-4-3120-4437 Taxes & Licenses 101-4-3120-9460 Equip Replacement Charge TOTAL Other Services & Charges Capital -0utlay 101-4-3120-.4560 Equipment TOTAL Capital Outlay TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services CURRENT CURRENT BUDGET PERIOD 08.330 OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 4,800.00 0.00 0.00 .0.00 4,800.00 96,450.00 ( 249.40)( 249.40) 0.26- 96,699.40 160,000.00 0.00 0.00 0.00 160,000.00 17,500.00 0.00 0.00 0.00 17,500.00 278,750.00 ( 249.90)( 249.40) 0.09- 278,999.40 950.0.0 0.00 0.00 0.00 950.00 9,450.00 103.15 103.15 1.09 9,346.85 200.00 0.00 0.00 0.00 200.00 3,000.00 0.00 0.00 0.00 3,000.00 500.00 0.00 0.00 0.00 500.00 18,250.00 0.00 0.00 0.00 18,250.00 33,000.00 0..00 0.00 0.00 33,000.00 6,500.00 0.00 0.00 0.00 6,500.00 199,000.00 0.00 0.00 0.00 199,000.00 3,500.00 0.00 0.00 0.00 3,500.00 4,850.00 ( 37.95)( 37.95) 0.78- 4,887.95 700.00 241.25 241.25 34.46 458.75 500.00 0.00 0.00 0.00 500.00 130,200.00 0.00 0.00 0.00 130,200.00 910,600.00 306.45 306.45 0.07 410,293.55 6,700.00 0.00 0.00 0.00 6,700.00 6,700.00 0.00 0.00 0.00 6,700.00 1,373,000.00 30,795.83 30,795.83 2.24 1,342,204.17 159,150.00 13,671.79 13,671.79 8.59 145,478.21 12,950.00 370.28 370.28 2.97 12,079.72 11,800.00 2,315.83 2,315.83 19.63 9,489.17 10,950.00 2,082.66 2,082.66 19.02 8,867.34 2,550.00 487.09 487.09 19.10 2,062.91. 21,300.00 3,989.35 3,489.35 16.38. 17,810.65 6,550.00 .1,723.50 1,723.50 26.31 4,826.50 224,750.00 24,140.50 29,140.50 10.74 200,609.50 ^ 2-11-2009 11:11 AM I 101-GENERAL FUND Public Works ^ DEPARTMENTAL EXPENDITURES Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other. Services & Charges Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 79,000.00 27,192.83 27,192.83 34.42 51,807.17 79,000.00 27,192.83 27,192.83 34.42 51,807.17 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-9102 Overtime Pay 101-4-3150-4104 PERA 101-9-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services. Supplies 101-9-3150-4219 Operating Supplies 101-9-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-9-3150-4409 Equip Repair/Maint Services 101-4-3150-4417 Uniform Rental TOTAL Other Services,& Charges Capital -0utlay TOTAL Equipment Services Engineering CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE RE PORT(UNAUDITED) AS OF: JANUARY 31ST, 2009 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET -- BUDGET PERIOD ACTUAL BUDGET BALANCE 308,750.00 51,333.33 51,333.33 16.63 257,416.67 165,200.00 6,.328.75 6,328.75 3.83 158,871.25 2,500.00 95.00 95.00 3.80 2,405.00 11,300.00 655.65 655.65 5.80 10,649.35 10,900.00 543.88 543.88 5.23 9,856.12 2,450.00 127.19 127.19 5.19 2,322.81 23,000.00 1,227.61 .1,227.61 5.34 21,772.39 5,250.00 1,922.00 1,422.00 27.09 3,828.00 220,1.00.00 10,400.08 10,900.08 9.73 209,69.9.92.. 16,350.00 0.00 0.00 0.00 16,350.00 14,200.00 0.00 0.00 0.00 14,200.00 30,550.00 0.00 0.00 0.00 30,550.00 2,000.00 0.00 0.00 0.00 2,000.00 2,800.00 54.66 54.66 1.95 2,745.39 4,800.00 59.66 59.66 1.14 4,745.34 255,450.00 10,454.74 10,454.74 4.09 244,995.26 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: '21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES Personal Services 101-4-3300-9101 Regular Pay 101-9-3300-4109 PERA 101-4-3300-9105 FICA 101-9-3300-9107 Medicare 101-4-3300-4108 Insurance 101-9-3300-4109 Workers Comp SOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies. 101-9-3300-4212 Fuels & Lubs 101-4-3300-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-3300-4303 Engineering Fees 101-9-3300-9319 Other Frofessional Services 1D1-4-3300-4321 Telephone 101-4-3300-4322 Postage 101-4-3300-4331 Travel, Conferences & Schools 101-4-3300-9361 Insurance 101-9-3300-4404 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 49,500.00 0.00 0.00 0.00 49,500.00 3,350.00 0.00 0.00 0.00 3,350.00 3,050.00 0.00 0.00 0.00 3,050.00 700.00 0.00 0.00 0.00 700.00 7,700.00 0.00 0.00 0.00 7,700.00 100.00 42.25 42.25 42.25 57.75 64,400.00 42.25 42.25 0.07 64,357.75 850.00 32.71 32.71 3.85 817.29 350.00 0.00 0.00 0.00 350.00 9,850.00 0.00 0.00 0.00 9,850.00 11,050_00 32.71 32.71 0.30 11,017.29 88,000.00 0.00 0.00 0.00 88,000.00 20,000.00 0.00 0.00 0.00 20,000.00 750.00 0.00 0.00 0.00 750.00 200.00 0.00 0.00 0.00 200.00 5,200.00 90.00 90.00 0.77 5,160.00 300.00. 0.00 0.00 0.00 300.00 500.-00 0.00 0.00 0.00 500..00 750.00 0.00 0.00 0.00 750.00 115,700.00 40.00 90.00 0.03. 115,660.00 TOTAL Engineering TOTAL Public Works Parks Department Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-4103 Part-time Pay 101-4-.5110-4104 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp TOTAL Personal Services 191,150.00 114.96 114.96 0.06 191,035.09 2,128,350.00 92,698.86 92,698.86 4.36 2,035,651.14 338,150.00 14,453.59 19,453.59 4.27 323,696.41 7,650.00 0.00 0.00 0.00 7,650.00 63,150.00 0.00 0.00 0.00 63,150.00 25,200.00 1,557.67 1,557.67 6.18 23,692.33 25,350.00 1,292.81 1,292.81 5.10 24,057.19 5,950.00 302.35 302.35 5.08 5,697.65 51,200.00 3,266.40 3,266.40 6.38 47,933.60 6,500.00 1.,926.00 1,926.00 29.63 4,574.00 523,150.00 22,798.82 22,798.82 4.36 500,351.18 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 08.338 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 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-4321 Telephone 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-4401 Bldg Repair/Maint Services 101-4-5110-9409 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Parks Department Parks & Rec Admin ----------------- ----------------- Personal Services 101-4-5210-4101 Regular Pay 101-4-5210-9102 Overtime Pay 101-9-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-4105 FICA 101-4-5210-4107 Medicare 101-9-5210-4108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies 42,850.00 15.05 15.05 0.04 42,834.95 3,200.00 19.10 19.10 0.60 3,180.90 76,550.00 22.27 22.27 0.03 76,527.73 122,600.00 56.42 56.42 0.05 122,543.58 3,900.00 63.90 63.90 1.64 3,836.10 2,550.00 175.00 175.00 6.86 2,375.00 200.00 0.00 0.00 0.00 200.00 27,000.00 0.00 0.00 0.00 27,000.00 15,050.00 0.00 0.00 0.00 15,050.00 6,000.00 0.00 0.00 0.00 6,000.00 13,500.00 0.00 0.00 0.00 13,500.00 7,100.00 0.00 0.00 0.00 7,100.00 27,000.00 374.89 374.89 1.39 26,625.11 38,100.00 0.00 0.00 0.00 38,100.00 140,400.00 613.79 613.79 0.44 139,786.21 786,150.00 23,469.03 23,469.03 2.99 762,680.97 335,550.00 14,831.80 14,831.80 4.42 320,718.20 700.00 0.00 0.00 0.00 700.00 42,600.00 2,261.16 2,261.16 5.31 40,338.84 25,600.00 1,810.04 1,810.04 7.07 23,789.96 23,500.00 1,592.52 1,592.52 6.78 21,907.48 5,500.00 372.45 372.95. 6.77 5,127.55 39,850.00 3,621.40 3,621.90 9.09 36,228.60- 9,950.00 792.75 792.75 16.02 4,157.25 978,250.00 25,282.12 25,282.12 5.29 452,967.88 16,900.00 0.00 0.00 0.00 16,900.00 16,900.00 0.00 0.00 0.00 16,900.00 Other Services & Charges 101-4-5210-4321 Telephone 4,100.00 175.61 175.61 4.28 3,924.39 101-4-5210-4322 Postage 6,000.00 0.00 0.00 0.00- 6,000.00 101-4-5210-4331 Travel, Conferences & Schools 9,150.00 200.00 200.00 2.19 8,950.00 101-9-5210-4399 Advertising/Marketing 30,950.00 0.00 0.00 0.00 30,950.00 101-4-5210-4361 Insurance 1,500.00 0.00 0.00 0.00 1,500.00 101-4-5210-4389 Utilities 12,900.00 0.00 0.00 0.00 12,900.00 101-4-5210-9401 Bldg Repair/Maint Services 15,850.00 861.69 861.69 5.44 14,988.31 101-9-5210-4404 Equip Repair/Maint Services 6,750.00 960.00 960.00 14.22 5,790.00 2-11-2009 11:11 AM ' 101-GENERAL FUND Culture & Recreation ' DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST., 2009 CURRENT CURRENT BUDGET PERIOD PAGE: 23 08.33$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 101-9-5210-4433 Dues & Subscriptions 1,650.00 0.00 0.00 0.00 1,650.00 TOTAL Other Services & Charges 88,850.00 2,197.30 2,197.30 2.47 86,652.70 TOTAL Parks & Rec Admin Recreation Programs ------------------- ------------------- Personal Services 101-4-5220-9101 Regular Pay 101-4-5220-9103 Part-time Pay 101-9-5220-4104 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare 101-4-5220-9108 Insurance TOTAL Personal Services Supplies 101-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5220-4404 Equip Repair/Maint Services 101-4-5220-4909 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 584,000.00 0.00 88,500.00 1,600.00 4,500.00 1,300.00 0.00 95,900.00 28,300.00 28,300.00 27,979.42 27,979.42 4.71 556,520.58 545.78 545.78 0.00 ( 545.78) 9,944.68 4,994.68 5.59 83,555.32 169.61 169.61 10.60 1,430.39 514.81 514.81 11.94 3,985.19 120.41 120.41 9.26 1,179.59 139.44 139.44 0.00 ( 139.44) 6,434.73 6,434.73 6.71 89,465.27 0.00 0.00 0.00 28,300.00 0.00 0.00 0.00 28,300.00 400.00 0.00 0.00 0.00 900.00 51,000..00 3,438.40 3,438.40. 6.74 47,561.60 2,500.00 0.00 0.00 0.00 2,500.00 3,000.00 ( 137.68)( 137.68) 4.59- 3,137.68 56,900.00 3,300.72 3,300.72 5.80 53,599.28 TOTAL Recreation Programs. 181,100.00 9,735.45 9,735.95 5.38 171,364.55 Concessions Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 0.00 0.00 0.00 4,750.00 101-4-5230-4104 PERA 250.00 0.00 0.00 0.00 250.00 101-4-5230-4105 FICA 300.00 0.00 0.00 0.00 300.00 101-4-5230-4107 Medicare .100.00 0.00 0.00 0.00 100.00 TOTAL Personal Services 5,400.00 0.00 0.00 0.00 5,400.00 Supplies 101-4-5230-4219 Operating Supplies 600.00 0.00 0.00 0.00 600.00 101-4-5230-4259 Other Merchandise For Resale 13,900.00 0.00 0.00 0.00 13,400.00 TOTAL Supplies 14,000.00 0.00 0.00 0.00 14,000.00 2-11-2009 11:11 AM 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-4103 Part-time Pay 101-4-5510-9104 PERA 101-4-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5510-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5510-4321 Telephone 101-4-5510-4322 Postage 101-4-5510-4331 Travel, Conferences & Schools 101-4-5510-4361 Insurance 101-9-5510-9389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-9409 Contractual Services 101-4-5510-9433 Dues & Subscriptions TOTAL Other Services & Charges 100.00 100.00 0.00 0.00 19,500.00 0.00 0.00 0.00 100.00 0.00 0.00 100.00 0.00 0.00 19,500.00 54,950.00 2,449.93 2,499.93 4.46 52,500..07 500.00 0.00 0.00 0.00 500.00 58,700.00 2,587.84 2,587.89 4.41 56,112.16 7,700.00 554.75 554.75 7.20 7,145.25 7,100.00 .480.52 480.52 6.77 6,619.48 1,650.00 112.38 112.38 6.81 1,537.62 12,900.00 1,034.22 1,034.22 8.39 11,365.78 700.00 93.00 93.00 13.29 607.00 143,700.00 7,312.64 7,312.64 5.09 136,387.36 10,950.00 ( 207.23)( 207.23) 1.89- 11,157.23 10,950.00 ( 207.23)( 207.23) 1.89- 11,157.23 2,400.00 206.63 206.63 8.61 2,193.37 9,000.00 600.00 600.00 15.00 3,900.00 2,400.00 0.00 0.00 0.00 2,900.00 900.00 0.00 0.00 0.00 900.00 8,150.00 0.00 0.00 0.00 8,150.00 13,500.00 528.14 528.14 3.91 12,971.86 8,100.00 57.81 57.81 0.71 8,042.19 950.00 15.00 15.00 1.58 935.00 40,900.00 1,407.58 1,407.58 3.48 38,992.42 TOTAL Sr Citizen Programs 195,050.00 8,512.99 8,512.99 4.36 186,537.01 TOTAL Culture & Recreation 1,765,800.00 69,196.89 69,196.89 3.92 1,696,603.11 Economic Developement CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 2-11-2009 11:11 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 101-GENERAL FUND Economic Development ' DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-9-6210-4101 Regular Pay 0.00 10,027.99 10,027.99 0.00 ( 10,027.99) 101-4-6210-4103 Part-time Pay 0.00 1,050.32 1,050.32 0.00 ( 1,050.32) 101-9-6210'-4109 PERA 0.00 325.85 325.85 0.00 ( 325.85) 101-4-6210-4105 FICA 0.00 276.04 276.04 0.00 ( 276.09) 101-4-6210-4107 Medicare 0.00 64.57 64.57 0.00 ( 64.57) 101-4-6210-4108 Insurance 0.00 1,298.00 1,298.00 0.00 ( 1,298.00) TOTAL Personal Services 0.00 13,042.77 13,042.77 0.00 ( 13,042.77) Other Services & Charges 101-9-6210-4331 Travel, Conferences & Schools 0.00 353.00 101-4-6210-4440 Miscellaneous 0.00 32..71 TOTAL Other Services & Charges 0.00 385.71 353.00 0.00 ( 353.00) 32.71 0.00 ( 32.71) 385.71 0.00 ( 385.71) TOTAL Economic Developement Energy City Personal Services 101-4-6220-4101 Regular 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-9319 Other Professional Services 101-4-6220-4331 Travel, Conferences & Schools 101-4-6220-4359 Publishing TOTAL Other Services & Charges TOTAL Energy City TOTAL Economic Development Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 101-4-7000-9724 Transfer - Pinewood .101-4-7000-4730 Transfer-Debt Service TOTAL Transfers Out 0.00 13,428.48 13,428.48 0.00 ( 13,428.48) 27,250.00 1,237.95 1,237.95 4.54 26,012.05 1,550.00 131.85 131.85 8.51 1,418.15 1,500.00 93..21 93.21 6.21 1,406.79 400.00 21.80 21.80 5.45 378.20 3,600.00 274.40 279.40 7.62 3,325.60 34,300.00 1,759.21 1,759.21 5.13 32,540.79 2,000.00 0.00 0.00 0.00 2,000.00 17,000.00 ( 610.00)( 610.00) 3.59- 17,610.00 2,500.00 0.00 0.00 0.00 2,500.00 21,500.00 ( 610.00)( 610.00) 2.84- 22,110.00 55,800.00 1,149.21 1,149.21 2.06 54,650.79 55,800.00 14,577.69 14,577.69 26.12 91,222.31 121,600.00 0.00 0.00 0.00 121,600.00 80,500.00 0.00 0.00 0.00 80,500.00. 66,600.00 0.00 0.00 0.00 66,600.00 268,700.00 0.00 0.00 0.00 268,700.00 TOTAL Transfers Out 268,700.00 0.00 0.00 0.00 268,700.00 2-11-2009 11:11 AM 101-GENERAL FUND General ' DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL General 268,700.00 0.00 0.00 0.00 268,700.00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,636,100.00 587,018.99 587,018.99 4.65 12,049,081.01 0.00 ( 563,081.18)( 563,081.18) 563,081.18 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 211-LIBRARY ` FINANCIAL SUMMARY 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF ~ - BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 89,800.00 ( 4,319.00)( 4,319.00) 4.81- 94,119.00 69,800.00 ( 4,319.00)( 4,319.00) 4.81- 99,119.00 89,800.00 2,422.26 2,422.26 2.70 87,377.74 89,800.00 2,422.26 2,422.26 2.70 87,377.74 $9,800.00 ------------- -- 2,422.26 ----------- -- 2,422.26 2.70 ----------- ------- - 87,377.74 ------------ 0.00 ( 6,741.26)( 6,741.26) 6,741.26 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ^ 211-LIBRARY ' REVENUES 08.33$ 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 TOTAL Property Taxes Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income 211-3-0000-3626 Contributions TOTAL Other Revenue TOTAL Library Library Project Transfers In 70,900.00 0.00 0.00 0.00 70,900.00 70,900.00 0.00 0.00 0.00 70,900.00 3,000.00 ( 4,319.00)( 4,319.00) 143.97- 7,319.00 15,900.00 0.00 0.00 0.00 15,900.00 18,900.00.( 4,319.00)( 4,319.00) 22.85- 23,219.00 89,800.00 ( 4,319.00)( 4,319.00) 9.81- 94,119.00 I TOTAL REVENUE ----89=800.00 (-----4=319.00)(-----4=319.00) ---9.81- ----94=119.00 2-11-2009 11:15 AM 211-LIBRARY ' DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE- $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Library Personal Services 211-4-5600-4104 PERA 211-4-5600-4105 FICA 211-4-5600-4107 Medicare 211-4-5600-4108 Insurance TOTAL Personal Services Supplies 211-4-5600-4201 Office Supplies 211-4-5600-9219 Operating Supplies TOTAL Supplies Other Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4322 Postage 211-4-5600-4331 Travel, Conferences & Schools 211-4-5600-4359 Publishing 211-4-5600-9361 Insurance 211-4-5600-4389 Utilities 211-4-5600-9401 Bldg Repair/Maint Services 211-4-5600-9404 Equip Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services 211-4-5600-9433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay Transfers Out 0.00 2.19 2.19 0.00 ( 2.19) 0.00 1.47 1.47 0.00 ( 1.47) 0.00 0.34 0.39 0.00 ( 0.34) 0.00 16.08 16.08 0.00 ( 16.08) 0.00 20.08 20.08 0.00 ( 20.08) 500.00 0.00 0.00 .0.00 500.00 16.,700.00 0.00 0.00 0.00 16,700.00 17,200.00 0.00 0.00. 0.00 17,200.00 0.00 119.80 119.80 0.00 ( 119.80) 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 3,350.00 0.00 0.00 0.00 3,350.00 21,900.00 0.00 0.00 0.00 21,900.00 15,300.00 0.00 0.00 0.00 15,300.00 2,200.00 0.00 0..00 0.00 2,200.00 16,050.00 1,677.38 1,677.38 10.45 14,372.62 11,000.00 605.00 605.00 5.50 10,395.00 250.00 0.00 0.00 0.00 250.00 72,600.00 2,402.18 2,402.18 3.31 70,197.82 TOTAL Library Library Project Supplies Other Services & Charges CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 _. 89,800.00 2,422.26 2,422.26 2.70 87,377.74 2-11-2009 11:15 AM 211-LIBRARY Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009. PAGE: 4 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE g OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Culture & Recreation 89,800.00 2,422.26 2,422.26 2.70 87,377.74 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 89,800.00 ------------- 2,422..26 ---- 2,922.26 2.70 87,377.74 0.00 ( 6,791.26)( 6,741.26) 6,741.26 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 221-ICE ARENA FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD 08.33$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE 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 756,200.00 44,199.78 44,199.78 5.89 712,000.22 70,000.00 2,340.00 2,340.00 3.34 67,660.00 84,700.00 7,872.00 7,872.00 9.29 76,828.00 73,000.00 15,855.20 15,855.20 21.72 57,144.80 983,900.00 70,266.98 70,266.98 7.14 913,633.02 .869,.100.00 18,650.68 18,650.68 2.15 850,949.32 30,150.00 0.00 0.00 0.00 30,150.00 34,450.00 693.79 693.79 2.01 33,756.21 50,200.00 1,377.39 1,377.39 2.74 48,822.61 983,900.00 20,721.86 20,721.86 2.11 963,178.14 983,900.00 20,721.86 20,721.86 2.11 963,178.14 0.00 49,545.12 49,545.12 ( 49,545.12) 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ~ 221-ICE ARENA ' REVENUES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR-TO DATE $ OF BUDGET BUDGET ~ PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3969 Ice Rental 221-3-0000-3465 Admissions 221-3-0000-3466 Dry Floor Events 221-3-0000-3468 Skate Sharpening 221-3-0000-3475 Building Rent 221-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-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 xockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation .Fees TOTAL Charges for Services 432,000.00 32,744.75 32,744.75 7.58 399,255.25 33,000.00 7,386.00 7,386.00 22.38 25,619.00 15,000.00 393.00 393.00 2.62 14,607.00 4,500.00 1,436.00 1,436.00 31.91 3,064.00 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 0.00 0.00 0.00 18,500.00 505,600.00 41,959.75 41,959.75 8.30 463,640.25 22,000.00 1,826.53 1,826.53 8.30 20,173.47 2,000.00 413.5.0 413.50 20.68 1,586.50 24,000.00 2,240.03 2,240.03 9.33 21;759.97 100,000.00 0.00 0.00 0.00 100,000.00 126,600.00 0.00 0.00 0.00 126,600.00 226,600.00 0.00 0.00 0.00 226,600.00 756,200.00 44,199.78 44,199.78 5.84 712,000.22 70,000.00 2,340.00 2,340.00 3.34 67,660.00 70,000.00 2,340.00 2,340.00 3.34 67,660_.00 70,000.00 2,340.00 2,340.00 3.34 67,660.00 89,700.00 7,872.00 7,872.00 9.29 76,828.00 89,700.00 7,872.00 7,872.00 9.29 76,828.00 TOTAL Skating 84,700.00 7,872.00 7,872.00 9.29 76,828.00 2-11-2009 11:15 AM 221-ICE ARENA ' REVENUES CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) ASOF: JANUARY 31ST, 2009 08.33°a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services TOTAL Concessions TOTAL REVENUE 73,000.00 15,855.20 15,855.20 21.72 57,144.80 73,000.00 15,855.20 15,855.20 21.72 57,144.80 73,000.00 15,855.20 15,855.20 21.72 57,144.80 983,900.00 70,266.98 70,266.98 7.14 913,633.02 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 221-ICE ARENA DEPARTMENTAL EXPENDITURES 08.33$ OF YEAR COMP. CURRENT - CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 150,300.00 8,443.75 8,493.75 5.62 141,856.25 221-4-5400-9103 Part-time Pay 77,850.00 4,550.96 4,550.96 5.85 73,299.04 221-4-5900-4104 PERA 11,350.00 1,182.08 1,182.08 10.41 10,167.92 221-4-5400-4105 FICA 14,150.00 1,271.35 1,271.35 8.98 12,878.65 221-4-5400-9107 Medicare 3,300.00 297.35 297.35 9.01 3,002.65 221-4-5400-4108 Insurance 16,600.00 1,545.54 1,545.54 9.31 15,054.46 221-4-5400-4109 Workers Comp 4,350.00 1.,116.50 1,116.50 25.67 3,233.50 TOTAL Personal Services 277,900.00 18,407.53 18,407.53 6.62 259,492.47. Supplies 221-4-5400-4212 Fuels & Lubs 300.00 0.00 0.00 0.00 300.00 221-4-5400-4217 Uniform Allowance. 1,500.00 0.00 0.00 0.00 1,500.00 221-4-5400-4219 Operating Supplies 48,500.00 0.00 0.00 0.00 48,500.00 221-4-5400-4255 Soft Drinks/Misc 13,500.00 0.00 0.00 0.00 .13,500.00 221-4-5400-4259 Other Merchandise For Resale. 1,200.00 0.00 0.00 0.00 1,200.00 TOTAL Supplies 65,000.00 0.00 0.00 0.00 65,000.00 Other Services & Charges 221-9-5400-4321 Telephone 2,900.00 103.15 103.15 3.56 2,796.85 221-4-5400-4322 Postage 500.00 0.00 0.0.0 0.-00 500.00 221-4-5400-4331 Travel, Conferences & Schools 1,050.00 0.00 0.00 0.00 1,050.00 221-9-5400-9359 Publishing 3,800.00 0.00 0.00 0.00 3,800.00 221-4-5400-9361 Insurance 9,000.00 0.00 0.00 0.00 9,000.00 221-4-5900-4389 Utilities 175,850.00 0.00 0.00 0.00 175,850.00 221-4-5900-4401 Bldg Repair/Maint Services 26,750.00 0.00 0.00 0.00 26,750.00 221-4-5400-9409 Contractual Services 2,000.00 0.00 0.00 0.00 2,000.00 221-4-5400-9415 Equipment Rental 5,400.00 0.00 0.00 0.00 5,4-00.00 221-4-5400-4433 Dues & Subscriptions 450.00 140.00 140.00 31.11 310.00 TOTAL Other Services & Charges 227,700.00 243.15 243.15 0.11 227,956.85 Capital Outlay 221-4-5400-4520 Buildings & Structures 100,000.00 0.00 0.00 0.00 100,000.00 TOTAL Capita l Outlay 100,000.00 0.00 0.00 0.00 100,000.00 Transfers Out 221-4-5400-4730 Transfer-Debt Service 198,500.00 0.00 0.00 0.00 198,500.00 TOTAL Transfers Out 198,500.00 0.00. 0.00 0.00 198,500.00 TOTAL Ice Arena 869,100.00 18,650.68 18,650.68 2.15 850,449.32 2-11-2009 11:15 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES Hockey Personal Services 221-4-5410-4103 Part-time Pay 221-4-5410-9105 FICA 221-4-5410-9107 Medicare TOTAL Personal Services Supplies 221-4-5410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5410-4322 Postage 221-4-5410-4359 Publishing 221-9-5410-4909 Contractual Services 221-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-9104 PERA 221-4-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5420-4322 Postage 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4938 Credit Card Fees TOTAI, Other Services & Charges - CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL. BUDGET BALANCE 3,600.00 0.00 0.00 0.00 3,600.00 200.00 0.00 0.00 0.00 200.00 50.00 0.00 0.00 0.00 50.00 3,850.00 0.00 0.00 0.00 3,850.00 19,850.00 0.00 0.00 0.00 14,850.00 14,850.00 0.00 0.00 0.00 14,850.00 500.00 0.00 0.00 0.00 500.00 1,700.00 0.00 0.00 0.00 .1,700.00 7,050.00 0.00 0.00 0.00 7,050.00 2,200.00 0.00 0.00 0.00 2,200.00 11,450.00 0.00 0.00 0.00 11,450.00 30,150.00 0.00 0.00 0.00 30,1.50.00 20,000.00 672.90 672.90 3.36 19,327.10 500.00 41.71 41.71 8.34 458.29 1,250.00 58.78 58.78 4.70 1,191.22 300.00 13.74 13.74 4.58 286.26 22,050.00 787.13 787.13 3.57 21,262.87 6,000.00 0.00 0.00 0.00 6,-000.00 6,000.00 0.00 0.00 0.00 6,000.00 200.00 0.00 0.00 0.00 200.00 1,300.00 0.00 0.00 0.00 1,300.00 2,450.00 0.00 0.00 0.00 2,450.00 2,450.00 ( 93.34)( 93.34) 3.81- 2,543.34 6,400.00 ( 93.34)( 93.34) 1.46- 6,493.34 ' TOTAL Skating 34,450.00 693.79 693.79 2.01 33,756.21 2-11-2009 11:15 AM CITY OF ELK RIVER PAGE: 6 REVENUE &EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 221-ICE ARENA Culture & Recreation I DEPARTMENTAL EXPENDITURES 08.33 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 1,217.19 221-4-5430-4104 PERA 0.00 41.96 221-4-5430-4105 FICA 1,300.00 95.83 221-4-5430-4107 Medicare 300.00 22.41 TOTAL Personal Services 22,500.00 1,377.39 Supplies 221-4-5430-9219 Operating Supplies 6,700.00 0.00 221-4-5430-4259 Other Merchandise For Resale 21,000.00 0.00 TOTAL Supplies 27,700.00 0.00 TOTAL Arena Concessions 1,217.19 5.82 19,682.81 41.96 0.00 ( 91.96) 95.83 7.37 1,204.17 22.41 7.47 277.59 1,377.39 6.12 21,122.61 0.00 0.00 6,700.00 0.00 0.00 21,000.00 0.00 0.00 27,700.00 50,200.00 1,377.39 1,377.39 2.74 48,822.61 TOTAL Culture & Recreation ^ TOTAL EXPENDITURES ^ REVENUES OVER/(UNDER) EXPENDITURES 983,900.00 20,721.86 20,721.86 2.11 9.63,178.14 983,900.00 20,721.86 20,721.86 2.11 963,178.14 0.00 49,545.12 49,545.12 _ ( 49,545.12) 2-11-2009 11:16 AM .CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 ' 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ' REVENUE SUMMARY I Pinewood Golf Course TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 273,000.00 0.00 0.00 0.00 273,000.00 273,000.00 0.00 0.00 0.00 273,000.00 273,000.00 6,633.35 6,633.35 2.43 266,366.65 273,000.00 6,633.35 6,633.3.5 2.43 266,366.65 273,000.00 6,633.35 6,633.35 2.43 266,366.65 0.00 ( 6,633.35)( 6,633.35) 6,633.35 2-11-2009 11:16 AM ^ 222-PINEWOOD GOLF COURSE ^ REVENUES ^ Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3967 Concessions 222-3-0000-3969 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3978 Golf Cart Rental 222-3-0000-3482 Advertising fee TOTAL Charges for Services Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course ^ TOTAL REVENUE CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF:. JANUARY 31ST, 2009 08.33$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 20,000.00 0.00 19,000.00 0.00 4,000.00 0.00 112,000.00 0.00 18,000.00 0.00 19,000.00 0.00 500.00 0.00 192,500.00 0.00 0.00 0.00 20,000.00 0.00 0.00 19,000.00 0.00 0.00 4,000.00 0.00 0.00 112,000.00 0.00 0.00 18,000.00 0.00 0.00 19,000.00 0_00 0.00 500.00 0.00 0.00 192,500.00 80,500.00 0.00 0.00 0.00 80,500.00 80,500.00 0.00 0.00 0.00 80,500.00 273,000.00 0.00 0.00 0.00 273,000.00 273,000.00 0.00 0.00 0.00 273,000.00 2-11-2009 11:16 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2009 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES 08.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 99,700.00 3,953.55 3,953.55 3.97 95,746.45 222-4-5300-4102 Overtime Pay 100.00 0.00 0.00 0.00 100.00 222-4-5300-4103 Part-time Pay 30,650.00 329.00 324.00 1.06 30,326.00 222-4-5300-4104 PERA 8,800.00 951.09 451.09 5.13 8,348.91 222-4-5300-4105 FICA 8,100.00 429.97 929.97 5.31 7,670.03 222-4-5300-4107 Medicare 1,900.00 100.57 100.57 5.29 1,799.43 222-4-5300-4108 Insurance 10,500.00 736.56 736.56 7.01 9,763.44 222-4-5300-4109 Workers Comp 1,050.00 299.00 294.00 28.00 756.00 TOTAL Personal Services 160,800.00 6,289.74 6,289.74 3.91 154,510.26 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 222-4-5300-4217 Uniform Allowance 500.00 222-4-5300-4219 Operating Supplies 28,100.00 222-4-5300-4259 Other Merchandise For Resale. 10,800.00 TOTAL Supplies 94,400.00 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 222-9-5300-4331 Travel, Conferences & Schools 400.00- 222-9-5300-4349 Advertising/Marketing 1,500.00 222-4-5300-4361 Insurance. 11,550.00 222-4-5300-4389 Utilities 6,800.00 222-4-5300-4901 Bldg Repair/Maint Services 2,000.00 222-4-5300-4904 Equip Repair/Maint Services 2,500.00 222-4-5300-4415 Equipment Rental 36,050.00 222-4-5300-4437 Taxes & Licenses 1,000.00 222-4-5300-9438 Credit Card Fees 3,500.00 TOTAL Other Services & Charges 67,800.00 Capital Outlay 0.00 0.00 0.00 5,000.00 0.00 0.00 0.00 500.00 13.08 13.08 0.05 28,086.92 0.00 0.00 0.00 10,800.00 13.08 13.08 0.03 44,386.92 0.00 0.00 0.00 2,500.00 0.00 0.00 0.00 40.0.00 0.00 0.00 0.00 1,500.00 0.00 0.00 0.00 11,550.00 0.00 0.00 0.00 6,800.00 0.00 0.00 0.00 2,000.00 0.00 0.00 0.00 2,500.00 0.00 0.00 0.00 36,050.00 335.00 335.00 33.50 665.00 4.47)( 9.47) 0.13- 3,509.47 330.53 330.53 0.49 67,469.47 TOTAL Golf Course 273,000.00 6,633.35 6,633.35 2.43 266,366.65 TOTAL Culture & Recreation 273,000.00 6,633.35 6,633.35 2.43 2.66,366.65 TOTAL EXPENDITURES 273,000.00 ------------- -- 6,633.35 ----------- -- 6,633.35 2.43 ----------- ------- - 266,366.65 ------------ REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 6,633.35)( 6,633.35) 6,633.35