Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 03-16-2009
~__ ,_~~.~d~ a .ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: March 16, 2009 SUBJECT: February 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 February, actual revenues (except for property taxes and state aids) and expenditures should generally run about 16.7% 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 axe highlighted below accompanied with a general discussion for the variance. General Fund Kevenue.r • Revenue collections are at 1.4% of budget; however, property taxes, our largest revenue source, will be received in July and December. • Recreation fees are right in line with the budgeted revenues. • Contribution revenues reflect the Bank of Elk River's sponsorship of the downtown concerts. • The negative interest income is related to the reversal of the prior year's interest receivable. • The transfers in will be recorded mid-year. Expenditures: • Excluding transfers, the total departmental expenditures are at about 11.5% and most departments are well within or below budget. • The Police Administration budget is at 23% of budget due to the annual software maintenance contract and repayment to the Capital Outlay Reserve fund for the financing of the police software purchase made in 2007. • The Snow Removal budget reflects the seasonal expenditures for salt and salaries. • The negative expenditure amount in Energy City is related to contributions for the energy expo in April. • The transfers out to the Ice Arena and Pinewood Golf axe made at the end of the year. • Council approved budget amendments will be reflected in the March report as we are closing out the 2008 fiscal year. Ice Arena For February, revenues exceeded expenditures by about $88,700. Excluding transfers in, revenues are at 28% of budget due to hockey season revenues and registrations for hockey and skating programs while expenditures are about 8% of budget. Pinewood Golf Golf revenues will not be generated until spring while expenditures attributable mainly to personal services axe about 7% of budget. 3-12-2009 10:50 AM I 101-GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH,.2009 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I REVENUE SUMMARY General Fund ~ TOTAL REVENUES I 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 132,173.92 178,805.55 1.42 12,457,299.45 12,636,100.00 132,173.92 178,605.55 1.42 12,457,299.45 1.68,100.00 3,p75.17 7,976.91 4.75 160,123.59 81,800.00 5,147.53 8,557.38 10.46 73,292.62 471,650.00 32,537.90 60,705.63 12.87 410,994.37 197,950.00 10,779.29 19,751.71 13.35 128,198.29 450,300.00 29,491.65 57,636.43 12.80 392,663.57 278,050.00 12,639.30 21,239.85 7.69 256,810.15 234,000.00, 14,531.00 14,531.00 6.21 219,469.00 178,900.00 13,319.61 22,483.57 12.57 156,416.43 321,550.00 26,828.18 39,662.72 12.33 281,887.28 286,350.00 26,812.27 37,882.27 13.23 248,467.73. 70,050.00 0.00 0.00 0.00 70,050.00 2,686,700.00 175,956.90 290,426.97 10.80 2,398,273.03 664,150.00 88,739.01 155,779.37 23.46 508,370.63 2,192,800.00 147,878.64 291,042.01 10.99 1,951,757.99 714,150.00 46,882.30 78,720.72 11.02 635,429..28 992,050.00 36,894.78 63,622.29 12.93 428,427.71 22,750.00 518.23 669.52 2.94 22,080.98 202,700.00 15,168.62 21,309.96 10.51 181,395.04 472,200.00 39,161.90 55,705.28 11.80 416,994.72 188,850.00 13,400.35 22,071.51 .11.69 166,778.99 49,150.00 1,727.85 2,616.83 5.32 96,533.17 653,950.00 45,659.17 81,716.86 12.50 572,233.14 76,000.00 5,330.68 9,109.32 11.98 66,895.68 5,728,750.00 936,361.53 732,353.67 12.78 4,996,396.33 1,373,000.00 49,948.01 80,743.84 5.88 1,292,256.16 308,750.00 23,591.27 74,924.60 29.27 233,825.40 255,450.00 17,601.88 26,056.62 10.98 227,393.38 191,150.00 8,897.24 9,012.20 9.71 182,137.80 2,128,350.00 100,038.40 192,737.26 9.06 1,935,612.79 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 2 REVENUE ~ EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND FINANCIAL SUMMARY 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR. TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 786,150.00 41,827.75 65,316.86 8.31 720,833.19 Parks & Rec Admin 589,000.00 45,881.05 73,360.47 12.56 510,639.53 Recreation Programs 181,100.00 8,397.43 18,320.56 10.12 162,779.49 Concessions 19,500.00 443.70 443.70 2.28 19,056.30 Sr Citizen Programs 195,050.00 14,502.57 23,015.56 11.80 172,034.44 TOTAL Culture & Recreation 1,765,800.00 111,002.50 180,457.15 10.22 1,585,342.85 Economic Development Economic Developement 0.00 13,512..01 27,863.94 0.00 ( 27,863.99) Energy City 55,800.00 ( 4,327.83)( 3,178.62) 5.70- 58,978.62 TOTAL Economic Development 55,800.00 9,184.18 24,685.32 99.29 31,114.68 General Transfers Out 268,700.00 0.00 0.00 0.00 268,700.00 TOTAL General 268,700.00 0.00 0.00 0.00 268,700.00 TOTAL EXPENDITURES 12,636,100.00 832,593.51 1,420,660.37 11.24 11,215,439.63 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 700,369.59)( 1,241,854.82) 1,241,854.82 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND REVENUES General Fund Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3132 Tax Forfeited Land Sale TOTAL Property Taxes 16.67$ OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 9,547,550.00 0.00 0.00 0.00 9,597,550.00 150,000.00 0.00 0.00 0.00 150,000.00 0.00 0.00. 25.55 0.00 ( 25.55) 9,697,550.00 0.00 25.55 0.00 9,697,524.45 Linceses & Permits 101-3-0000-3211 Liquor License 51,000.00 40.00 40.00 0.08 50,960.00 101-3-0000-3212 Amusement License 1,000.00 0.00 0..00 0.00 1,000.00 101-3-0000-3213 Cigarette License .3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3214 Apartment License 15,850.00 60.00 60.00 0.38 15,790.00 101-3-0000-3216 Mining License 9,000.00 2,996.70 2,996.70 33.30 6,003.30 101-3-0000-3217 Garbage Hauler License 3,000.00 75.00 3,095.00 103.17 ( .95.00) 101-3-0000-3218 Other Business License/Permit 13,000.00 1,520.00 9,805.00 75.42 3,195.00 101-3-0000-3229 NPDES Permit 5,000.00 0.00 0.00 0.00 5,000.00 101-3-0000-3231 Building Permit 188,300.00 8,458.02 18,130.42 9.63 170,169.58 101-3-0000-3232 Plumbing/Heating Permit 47,600.00 1,796.04. 11,167.97 23.96 36,432.03 101-3-0000-3233 Permit Surcharge 200.00 ( 280.11) 375.93 187.97 ( 175.93) 101-3-0000-3234 Electric Permit 100.00 0.00 0.00 0.00 100.00 101-3-0000-3235 Animal License 3,000.00 170.00 995.00 16.50 2,505.00 101-3-0000-3236 Parking Permit 1,500.00 40.00 1,140.00 76.00 360.00 101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 300.00 1,600.00 15.00 10,200.00 TOTAL Linceses 6 Permits 353,550.00 15,175.65 49,106.02. 13.89 304,443.98 Intergovernmental Rev 101-3-0000-3321 Local Government Aid 686,800.00 0.00 0.00 0.00 686,800.00 101-3-0000-3324 PERA Aid 15,000.00 0.00 0.00 0.00 15,000.00 101-3-0000-3325 Police 2$ Aid 215,000.00 0.00 0.00 0.00 215,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3327 State-Aid Street Maint 36,800.00 19,487.34 19,487.34 52.95. 17,312.66 101-3-0000-3329 State Crime Prevention Grant 12,500.00 0.00 0.00 0.00 12,500.00 101-3-0000-3341 County Reimb/Grant 7,500.00 0.00 0.00 0.00 7,500.00 TOTAL Intergovernmental Rev 983,600.00 19,487.34 19,487.34 1.98 964,112.66 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 110.00 3,010.00 12.04 21,990.00 101-3-0000-3413 Plan Check Fee 75,300.00 2,709.68 6,691.25 8.82 68,658.75 101-3-0000-3415 Special Assessment Search 500.00 60.00 120.00 _24.00 380.00 101-3-0000-3417 Copies 1,500.00 108.18 572.18 38.15 927.82 101-3-0000-3418 Other General Govt Services 5,000.00 379.88 379.88 7.60 4,620.12 101-3-0000-3430 Lockout Fees 8,500.00 705.00 1,705.00 20.06 6,795.00 101-3-0000-3431 Police Services 2,000.00 98.50 159.50 7.98 1,840.50 101-3-0000-3932 School Liaison 75,000.00 0.00 37,500.00 50.00_ 37,500.00 101-3-0000-3434 Animal Impound Fee 3,000.00 140.00 260.00 8.67 2,790.00 101-3-0000-3436 Fire Contracts 208,000.00 0.00 0.00 0.00 208,000.00 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 ~ 101-GENERAL FUND REVENUES CURRENT CURRENT BUDGET PERIOD 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3461 Recreation Fees 101-3-0000-3467 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-3484 Contractor License Check TOTAL Charges for Services Fines, Fees, & Forfeit 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines, Fees, & Forfeit Other Revenue 101-3-0000-3621 Interest Income 101-3-0000-3625 Refunds & Reimbursements 101-3-0000-3626 Contributions 101-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101-3-0000-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-W47TS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3945 Transfer-Utilities 101-3-0000-3998 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 1,000.00 0.00 0.00 0.00 1,000..00 25,000.00 727.00 727.00 2.91 24,273.00 121,500.00 17,988.93 20,320.93 16.73 101,179.07 .20,100.00 903.07 1,517.68 7.55 18,582.32 2,600.00 72.68 192.68 7.41 2,407.32 3,100.00 1,099.71 1,432.21 46.20 1,667.79 2,400.00 200.00 400.00 16.67 2,000.00 5,000.00 0.00 0.00 0.00 5,000.00 500.00 5.00 35.00 7.00 465.00 585,000.00 24,807.63 74,973.31 12.82 510,026.69 150,000.00 7,379.57 7,379.57 4.92 142,620.43 7,000.00 2,495.75 4,975.75 71.08 2,024.25 157,000.00 9,875.32 12,355.32 7.87 199,644..68 180,000.00 0.00 ( 93,925.00) 24.40- 223,925.00 54,000.00 9.00 0.00 0.00 54,000.00 22,800.00 14,362.00 15,370.00 67.41 7,430.00 3,000.00 ( 2,534.02) 413.01 13.77 2,586.99 259,800.00 11,827.98 ( 28,141.99) 10.83- 287,941.99 35,000.00 0.00 39,500.00 0.00 50,000.00 0.00 248,600.00 0.00 200,000.00 51,000.00 17,000.00 0.00 9,500.00 0.00 599,600.00 51,000.00 16.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 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 51,000.00 25.50 149,000.00 0.00 0.00 17,000.00 0.00 0.00 9,500.00 51,000.00 8.51 548,600.00 12,636,100.00 132,173..92 178,805.55 1.42 12,457,299.45 1 TOTAL REVENUE 12,636,100.00 132,173.92 178,805.55 1.42 12,457,294.95 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 ~ 101-GENERAL FUND I DEPARTMENTAL EXPENDITURES 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101-4-1110-4103 Part-time Pay 101-4-1110-4109 PERA 101-4-1110-4105 FICA 101-4-1110-4107 Medicare 101-4-1110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1110-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1110-4319 Other Professional Services 101-4-1110-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4940 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,208.00 6,416.00 16.66 32,084.00 1,950.00 102.07 209.14 10.97 1,745.86 2,400.00 198.90 397.80 16.58 2,002.20 550.00 46.52 93.04 16.92 956.96 50.00 0.00 9.75 19.50 40.25 43,450.00 3,555.49 7,120.73 16.39 36,329.27 3,200.00 0.00 0.00 0.00 3,200.00 3,200.00 0.00 0.00 0.00 3,200.00 6,750.00 400.00 936.00 13.87 5,814.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 66.00 66.00 0.36 18,134.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 ( 146.32)( 146.32) 1.56- 9,546.32 121,450.00 319.68 855.68 0.70 120,594.32 I 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-9-1120-4201 Office Supplies TOTAL Supplies 168,100.00 3,875.17 7,976.41 9.75 160,123.59 50,600.00 3,752.00 11,800.00 300.00 3,550.00 253.26 4,000.00 248.66 950.00 58.15 5,250.00 938.01 200.00 0.00 76,350.00 5,050.08 3,350.00 63.85 3,350.00 63.85 6,003.21 11.86 44,59E.79 437.50 3.71 11,362.50 500.42 14.10 3,099.58 485.90 12.15 3,514.10 113.63 11.96 836.37 876.02 16.69 4,373.98 93.25 21.63 156.75 8,459.93 11.08 67,890.07 63.85 1.91 3,286.15 63.85 1.91 3,286.15 3-12-2009 10:50 AM 101-GENERAL FUND General Government ~ DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 16.$7$ 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 500.00 0.00 101-4-1120-4322 Postage 100.00 0.00 101-4-1120-4331 Travel, Conferences & Schools 1,400.00 33.60 101-4-1120-4909 Equip Repair/Maint Services 100.00 0.00 TOTAL Other Services & Charges 2,100.00 33.60 0.00 0.00 500.00 0.00 0.00 100.00 33.60 2.40 1,366.40 o.oo o.oo loo.oo 33.60 1.60 2,066.40 TOTAL Cable TV Administrative Services Personal Services 101-4-1210-4101 Regular Pay 101-9-1210-4102 Overtime Pay 101-9-1210-4103 Part-time Pay 101-9-1210-4104 PERA 101-4-1210-4105 FICA 101-4-1210-9106 Other Retirement Contributions 101-4-1210-9107 Medicare 101-4-1210-4108 Insurance 101-4-1210-4109 Workers Comp TOTAL Personal Services Supplies 101-9-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-9-1210-4331 Travel, Conferences & Schools. 101-9-1210-9361 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 81,$00.00 5,147.53 .8,557.38 10.46 73,242.62 296,750.00- 22,390.66 35,825.06 12.07 260,929.94 2,000.00 0.00 0.00 0.00 2,000.00 45,600.00 3,438.59 5,363.39 11.76 90,236.61 23,250.00 1,743.47 3,430.89 14.76 19,819.11 21,350.00 .1,559.14 3,095.87 14.50 18,254.13 9,800.00 900.00 800.00 16.67 4,000.00 5,000.00 364.64 724.09 14.48 9,275.96 23y950.00 1,954.03 3,908.06 16.67 19,541.94 1,300.00 0.00 350.50 26.96 949.50 423,500.00 31,850.53 53,497.81 12.63 370,002.19 9,900.00 441.75 585.65 5.92 9,314.35 9,900.00 441.75 585.65 5.92 9,314.35 9,500.00 0..00 .4,860.00 108.00 ( 360.00) 600.00 59.63 59.63 9.94 540.37 1,500.00 0.00 0.00 0.00 1,500.00 5,600.00 182.36 182.36 3.26 5,417.64 200.00 0.00 0.00 0.00 200.00 22,600.00 3.63 1,370.18 6.06 21,229.82 2,600.00 .0.00 150.00 5.77 2,450.00 650.00 0.00 0.00 0.00 650.00 38,250.00 245.62 6,622.17 17.31 31,627.83 I TOTAL Administrative Services Human Resources 471,650.00 32,537.90 60,705.63 12.87 410,994.37 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND I` 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-9-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-4433 Dues & Subscriptions 101-4-1220-4490 Miscellaneous TOTAL Other Services ~ Charges I TOTAL Human Resources Elections Personal Services Supplies Other Services & Charges CURRENT CURRENT BUDGET PERIOD 68,850.00 5,219.24 8,350..78 12.13 60,499.22 45,200.00 3,758.28 6,076.11 13.44 39,123.89 7,700.00 605.99 1,211.70 15.74 6,488.30 7,100.00 551.06 1,112.55 15.67 5,987.45 1,650.00 128.87 260.18 15.77 1,389.82 5,250.00 438.00 876.00 16.69 9,374.00 450.00 0.00 116.25 25.83 333.75 136,200.00 10,701.44 18,003.57 13.22 118,196.93 3,000.00 0.00 1,607.49 53.58 1,392.51 3,000.00 0.00 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 17.95 17.95 0.48 3,732.05 650.00 0.00 0.00 0.00 650.00 1,000.00 59.90 122.70 12.27 877.30 8,750.00 77.85 140.65 1.61 8,609.35 147,950.00 10,779.29 19,751.71 13.35 128,198.29 16.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE ~ Finance Personal Services 101-4-1310-4101 Regular Pay 101-4-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 289,350.00 21,325.16 5,150.00 155.00 19,550.00 1,939.94 17,950.00 1,234.37 4,200.00 288.67 23,450.00 1,959.03 1,100.00 0.00 355,750.00 26,396.67 34,120.25 12.00 250,229.75 285.00 5.53 4,865.00 2,844.08 14.55 16,705.92 2,459.41 13.70 15,490.59 575.17 13.69 3,624.83 3,906.06 16.67 19,541.94 295.25 26.84 804.75 44,487.22 12.51 311,262.78 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 16.67$ OF YEAR COMP. ~ OF BUDGET 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-9-1310-4321 Telephone 101-9-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-4-1310-4359 Publishing 101-4-1310-4404 Equip Repair/Maint Services 101-4-1310-9433 Dues & Subscriptions 101-4-1310-4440 Miscellaneous TOTAL Other Services & Charges 4,850.00 294.78 360.19 7.43 4,489.81 4,850.00 294.78 360.19 7.'43 4,489.81 17,300.00 2,900.00 48,150.00 0.00 850.00 59.63 3,600.00 0.00 4,150.00 75.57 2,000.00 0.00 12,100.00 0.00 1,550.00- 265.00 0.00 0:00 89,700.00 2,800.20 2,900.00 13.87 14,900.00 0.00 0.00 48,150.00 59.63 7.02 790.37 0.00 0.00 3,600.00 417.07 10.05 3,732.93 0.00 0.00 2,000.00 9,375.32 77.48 2,724.68 445.00 28.71 1,105.00 92.00 0.00 ( 92.00) 12,789.02 14.26 76,910.98 TOTAL Finance Information Technology Personal Services 101-4-1350-4101 Regular Pay 101-9-1350-4103 Part-time Pay 101-4-1350-4104 PERA 101-4-1350-4105 FICA 101-4-1350-4107 Medicare 101-4-1350-4108 Insurance 101-4-1350-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1350-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-4404 Equip Repair/Maint Services TOTAL Other Services ~ Charges Capital Outlay 101-4-1350-4560 Equipment TOTAL Capital Outlay 450,300.00 29,491.65 57,636.93 12.80 392,663.57 129,300.00 9,636.52 15,471.54 11.97 113:,828.46 12,850.00 0.00 0.00 0.00 12,850.00 9,600.00 650.47 1,291.00 13.45 8,309.00 8,800.00 573.88 1,141.19 12.97 7,658.81 2,050.00 134.22 266.89 13.02 1,783.11 15,350.00 1,280.02 2,560.04 16.68 12,789.96 550.00 0.00 145.00 26.36 405.00 178,500.00 12,275.11 20,875.66 11.70 157,624.34 23,300.00 283.88 283.88 1.22 23,016.12 23,300.00 283.88 283.88 1.22 23,016.12 8,000.00 0.00 0.00 0.00 8,000.00 800.00 45.76 45.76 5.72 754.24 4,500.00 39.55 34.55 0.77 9,465.45 19,950.00 0.00 0.00 0.00 19,950.00 33,250.00 80.31 80.31 0.24 33,169.69 93,000.00 0.00 0.00 0.00 43,000.00 93,000.00 0.00 0.00 0.00 43,000.00 TOTAL Information Technology 278,050.00 12,639.30 21,239.85 7.64 256,810.15 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND General. Government DEPARTMENTAL EXPENDITURES 16.67$ OF YEAR COMP.. CURRENT CURRENT YEAR TODATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Legal Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 234,000.00 14,531.00 14,531.00 6.21 219,969.00 234,000.00 14,531.00 14,531.00 6.21 21.9,469.00 TOTAL Legal 234,000.00 14,531.00 Community Development Personal Services 14,531.00 6.21 219,469.00 101-4-1500-4101 Regular Pay 139,750.00 10,450.97 16,721.55 11.97 123,028.45 101-4-1500-4104 PERA 9,950.00 705.94 1,393.82 14.75 8,056.18 101-4-1500-4105 FICA 8,700.00 607.89 1,211.86 13.93 7,488.14 101-4-1500-4107 Medicare 2,050.00 142.16 283.92 13.83 1,766.58 101-4-1500-4108 Insurance 15,600.00 1,078.01 2,156.02 13.62 13,943.98 101-4-1500-4109 Workers Comp 550.00 0.00 142.50 25.91 407.50 TOTAL Personal Services 176,100.00 12,989.42 21,909.17 12.44 159,190.83 Supplies 101-4-1500-4201 Office Supplies 250.00 0.00 TOTAL Supplies 250.00 0.00 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 330.19 TOTAL Other Services & Charges 2,550.00 330.19 32.71 13.08 217.29 32.71 13.08 217.29 541.69 21.24 2.,008.31 541.69 21.24 2,008.31 TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-9104 PERA 101-4-1510-4105 FICA 101-9-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services 178,900.00 13,314.61 22,483.57 12.57 156,416.43 210,300.00 15,828.23 14,200.00 1,068.40 13,050.00 883.92 3,050.00 206.79 28,300.00 2,140.02 500.00 0.00 269,400.00 20,127.31 29,836.30 11.81 185,963.70 1,953.93 13.76 12,246.07 1,626.88 12.97 11,423.12 380.51 12.48 2,669.49 3,640.03 12.86 24,659.97 155.50 31.10 344.50 32,593.15 12.10 236,806.85 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 10 ' REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 16.67& 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-9-1510-4361 Insurance 101-4-1510-4404 Equip Repair/Maint Services 101-4-1510-4433 Dues & Subscriptions 101-4-1510-9490 Miscellaneous TOTAL Other Services & Charges 5,200.00 95.53 156.73 3.01 850.00 139.26 134.26 15.80 6,050.00 179.79 290.99 4.81 20,000.00 800.00 2,000.00 6,350.00 10,000.00 700.00 5,000.00 1,000.00 250.00 46,100.00 5,490.00 5,490.00 22.88 22.86 0.00 0.00 105.05 316.55 786.00 786.00 0.00 0.00 117.15 117.15 0.00 0.00 0.00 46.00 6,521.08 6,778.58 TOTAL Planning City Hall Maintenance Personal Services 101-4-1600-4101 Regular Pay 101-4-1600-9102 Overtime Pay 101-4-1600-4103 Part-time Pay 101-4-1600-4109 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-4-1600-4212 Fuels & Lubs 101-4-1600-4217 Uniform Allowance 101-4-1600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-1600-4321 Telephone 101-4-1600-4331 Travel, Conferences & Schools 101-4-1600-4361 Insurance 101-4-1600-4389 Utilities 101-4-1600-4401 Bldg Repair/Maint Services 101-4-1600-4904 Equip Repair/Maint Services TOTAL Other Services & Charges 321,.550.00 26,828.18 39,662.72 12.33 261,887.28 83,750.00 6,927.94 12,433.01 9,100.00 0.00 0.00 18,450.00 963.09 1,533.81 7,800.00 532.63 1,153.67 7,150.00 486.97 1,049.23 1,700.00 113.89 245.39 11,900.00 1,164.21 2,507.23 2,550.00 0.00 1,068.75 142,400.00 10,188.73 19,991.09 3,750.00 242.72 242.72 1,700.00 282.85 282.85 30,000.00 6,401.86 6,401.86 35,450.00 6,927.43 6,927.43 5,093.27 27.45 14,510.00 2.86 777.12 0.00 2,000.00 9.99 6,033.95 7.86 9,214.00 0.00 700.00 2.34 4,882.65 0.00 1,000.00 18.40 209.00 14.70 39,321.42 14.85 71,316.99 0.00 9,100.00 8.31 16,916.19 14.79 6,646.33 14.67 6,100.77 14.43 1,454.61 21.07 9,392.77 91.91 1,481.25 14.09 122,408.91 6.47 3,507.28 16.64 1,417.15 21.34 23,598.14 19.54 28,522.57 15,450.00 904.17 1,759.78 11.39 13,690.22 2,000.00 1,200.00 1,240.00 62.00 760.00 5,700.00 0.00 0.00 0.00 5,700.00 51,800.00 5,966.54 5,966.54 11.52 45,833.46 32,300.00 1,625.40 1,997.43 6.18 30,302.57 1,250.00 0.00 0.00 0.00 1,250.00 108,500.00 9,696.11 10,963.75 10.10 97,536.25 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67 OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Capital Outlay TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 266,350.00 26,812.27 37,882.27 13.23 298,467.73 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 Contingency 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-4107 Medicare 101-4-2110-4108 Insurance 101-4-2110-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2110-4201 Office Supplies 101-4-2110-4217 Uniform Allowance 101-4-2110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2110-4319 Other Professional Services 101-4-2110-4321 Telephone 101-4-2110-4322 Postage 101-4-2110-4331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-9361 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 2,688,700.00 175,956.90 290,426.97 10.80 2,398,273.03 332,900.00 21,231.70 33,891.91 10.18 299,008.09 43,000.00 2,993.68 5,935.04 13.80 37,064.96 3,300.00 0.00 1,116.38 33.83 2,183.62 3,350.00 202.42 663.26 19.80 2,686.79 28,500.00 1,938.01 3,876.02 13.60 24,623.98 48,500.00 0.00 12,970.25 26.74 35,529.75 459,550.00 26,365.81 58,952.86 12.72 901.,097.14 16,000.00 1,264.66 1,264.66 7.90 14,735.34 2,500.00 987.82 487.82 19.51 2,012.18 3,150.00 ( 37.46)( 37.46) 1.19- 3,187.46 21,650.00 1,715.02 1,715.02 7.92 .19,934.98 5,500.00 0.00 0.00 0.00 5,500.00 25,000.00 1,776.55 2,646.16 10.58 22,353.89 2,100.00 1.93 1.93 0.09 2,098.07 9,200.00 19.74 473.69 11.28 3,726.31 500.00 0.00 0.00 0.00 500.00 12,950.00 0.00 0.00 0.00 12,950.00 69,250.00 805.96 33,980.71 49.07 35,269.29 5,850.00 955.00 865.00 14.79 4,985.00 500.00 0.00 45.00 9.00 455.00 125,350.00 3,059.18 38,012.49 30.33 87,337..51 3-12-2009 10:50. AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES Capital Outlay 101-4-2110-4560 Equipment TOTAL Capital Outlay 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 57,600.00 57,599.00 57,599.00 100.00 1.00 57,600.00 57,599.00 57,599.00 100.00 1.00 I TOTAL Police Administration Patrol Personal Services 101-4-2120-4101 Regular Pay 101-4-2120-4102 Overtime Pay 101-4-2120-4104 PERA 101-4-2120-4107 Medicare .101-4-2120-4108 Insurance TOTAL Personal Services Supplies 101-4-2120-4212 Fuels & Lubs 101-4-2120-4217 Uniform Allowance 101-4-2120-9219 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-4960 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 664,150.00 88,739.01 155,779.37 23.46 508,370.63 1,435,250.00 102,746.41 166,337.08 11.59 1,268,912.92 90,000.00 2,108.21. 2,805.20 3.12 87,199..80 215,050.00 14,784.44 29,252..54 13.60 185,797.46 19,800.00 1,235.60 2,502.17 12.64 17,297.83 150,400.00 12,978.07 25,956.14 17.26 124,443.86 1,910,500.00 133,852.73 226,853.13 11.87 1,683,646.87- 105,000.00 7,.777.74 7,977.69 7.60 97,022.31 17,200.00 369.86 332.88 1.99 16,867.12 49,000.00 2,914.61 2,914.61 5.95 46,085.39 25,000.00 1,745.50 1,745.50 6.98 23,254.50 196,200.00 12,807.71 12,970.68 6.61 183,229.32 19,650.00 14.89 14.89 0.10 14,635.11 27,200.00 1,203.31 1,203.31 4.42 25,996.69 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 1,218.20 1,218.20 1.41 84,881.80 TOTAL Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services 2,192,800.00 147,878.64 241,042.01 10.99 1,951,757.99 495,800.00 35,694.41 57,111.05 11.52 438,688.95 40,000.00 478.62 618.71 1.55 39,381.29 75,550.00 5,100.44 9,960.32 13.18 65,589.68 5,600.00 316.76 633.73 11.32 4,966.27 58,600.00 4,914.94 9,829.88 16.77 98,770.12 675,550.00 46,505.19 78,153.69 11.57 597,396.31 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 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-4933 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Investigations Police .Support Services Personal Services 101-4-2150-9101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 101-4-2150-4404 Equip Repair/Maint Services 101-4-2150-9409 Contractual Services 101-4-2150-4433 Dues & Subscriptions 101-4-2150-4460 Equip Replacement Charge TOTAL Other Services & Charges 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 4,850.00 0.00 ( 30.08) 0.62- 4,880.08 8,400.00 79.86 79.86 0.95 8,320.14 13,250.00 79.86 49.78 0.38 13,200.22 10,750.00 297.25 517.25 9.81 10,232.75 4,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 297.25 517.25 2.04 24,832.75 714,150.00 46,882.30 78.,720.72 11.02 635,429.28 346,900.00 26,083.22 91,836.75 12.06 305,063.25 6,500.00 0.00 0.00 0.00 6,500.00. 23,850.00 1,760.62 3,982.98 19.60 .20,367.02 21,900.00 1,574.97 3,149.55 14.36 18,755.45 5,100.00 368.33 735.40 14.42 4,364.60 42,050.00 3,504.02 7,008.04 16.67 35,041.96 446,300.00 33,291.16 56,207.72 12.59 390,092.28 1,000.00 97.38 47.38 4.74 952.62 3,250.00 0.00 0.00 0.00 3,250.00 8,050.00 2,731.52 2,731.52 33.93 5,316.48 12,300.00 2,778.90 2,778.90 22.59 9,521.10 3,550.00 0.00 0.00 0.00 3,550.00 5,500.00 0.00 3,675.00 66.82 1,825.00 16,000.00 647.22 738.17 9.61 15,261.83 500.00 177.50 222.50 49.50 277.50 7,900.00 0.00 0.00 0.00 7,900.00 33,450.00 824.72 4,635.67 13.86 26,814.33 TOTAL Police Support Services 492,050.00 36,894.78 63,622.29 12.93 928,427.71 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH,. 2009 I 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Police Reserves Personal Services 101-4-2160-4103 Part-time Pay 101-4-2160-4105 FICA 101-4-2160-4107 Medicare TOTAL Personal Services Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2160-4319 Other Professional Services 101-4-2160-4321 Telephone 101-4-2160-43.31 Travel, Conferences & Schools 101-4-2160-4359 Publishing 101-4-2160-4433 Dues & Subscriptions TOTAL Other Services & Charges 5,500.00 0.00 0.00 0.00 5,500.00 350.00 0.00 0.00 0.00 350.00 100.00 0.00 0.00 0.00 100.00 5,950.00 0.00 0.00 0.00 5,950.00 5,000.00 255.00 255.00 5.10 4,745.00 6,000.00 0.00 0.00 0.00 6,000.00 11,000.00 255.00 255.00 2.32 10,745.00. 1,500.00 0.00 0.00 0.00 1,500.00 1,600.00 151.03 302.32 18.90 1,297.68 1,700.00 0.00 0.00 0.00 1,700.00 0.00 112.20 112.20 0.00 ( 112.20) 1,000.00 0.00 0.00 0.00 1,000.00 5,800.00 263.23 414.52 7.15 5,385.48 TOTAL Police Reserves Public safety building ---------------------- Personal Services 101-4-2190-9101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-9107 Medicare 101-4-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies - Other Services & Charges 101-4-2190-4361 Insurance 101-4-2190-4389 Utilities 101-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges 22,750.00 518.23 669.52 2.94 22,080.48 98,200.00 7,256.93 10,209.60 10.40 87,990.40 450.00 0.00 0.00 0.00. 450.00 6,650.00 489.85 844.10 12.69 5,605.90 6,100.00 436.80 770.22 12.63 5,329.78 1,450.00 102.16 180.15 12.42 1,269.85 14,250.00 1,051.97 1,815.41 12.74 12,434.59 2,200.00 0.00 947.75 93.08 1,252.25 129,300.00 9,337.71 14,767.23 11.42 114,532.77 17,000.00 4,576.56 4,576.56 26.92 12,423.44 17,000.00 4,576.56 4,576.56 26.92 12,423.44 6,900.00 0.00 0.00 0.00 6,900.00 18,200.00 420.58 420.58 2.31 17,779.92 31,300.00 833.77 1,590.59 4.92 29,759.41 56,400.00 1,254.35 1,961.17 3.48 54,438.83 TOTAL Public safety building 202,700.00 15,168.62 21,304.96 10.51 181,395.04 3-12-2009 10:50 AM CITY OF ELK RIVER ". PAGE: '15 REVENUE & EXPENSE REPORT (UNAUDITED) - AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Fire Administration Personal Services 101-4-2310-4101 Regular Pay 101-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-9105 FICA 101-4-2310-4106 Other Retirement Contributions 101-9-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-4109 Workers Comp TOTALPersonal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-4212 Fuels & Lubs 101-4-2310-9217 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-4359 Publishing 701-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 301-4-2310-9460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Fire Administration Fire Inspections ---------------- ---------------- PersonalServices 101-4-2320-4101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-9104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 90,850.00 7,553.55 12,079.53 13.30 78,770.47 150,350.00 11,376.92 19,636.26 13.06 130,713.74 13,250.00 1,082.60 2,113.61 15.95 11,136.39 10,050.00 663.80 1,581.66 15.74 8,968.39 30,000.00 0.00 0.00 0.00 30,000.00 3.,500.00 237.22 533.39 15.24 2,966.66 9,150.00 857.33 1,671.73 18.27 7,978.27 15,350.00 0.00 3,929.00 25.60 11,421.00 322,500.00 21,771.62 41,545.13 12.88 280,954.87 1,200.00 128.82 128.82 10.74 1,071.18 7,950.00 377.41 377.41 4.75 7,572.59 1,100.00 0.00 0.00 0.00 1,100.00 32,400.00 6,088.61 6,100.75 18.83 26,299.25 42,650.00 6,594.84 6,606.98 15.49 36,043.02 9,950.00 2,302.50 2,302.50 46.52 2,647.50 2,700.00 252.63 435.36 16.12 2,269.64 500.00 0.00 0.00 0.00 500.00 19,850.00 337.77 787.77 3.97 19,062.23 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 2,621.62 2,621.62 17.30 12,528.38 4,000.00 159.75 159.75 3.99 3,840.25 20,850.00 93.67 93.67 0.45 20,756.33 2,000.00 27.50 1,152.50 57.63 847.50 15,250.00 0.00 0.00 0.00 15,250.00 107,050.00 5,795.44 7,553.17 7.06 99,996.83 472,200.00 34,161.90 55,705.28 11.80 416,494.72 132,250.00 10,024.76 16,039.61 12.13 116,210.39 2,000.00 0.00 0.00 0.00 2,000.00 14,700.00 1,11.5.62 2,184.25 14.86 12,515.75 7,600.00 269.90 539.90 7.10 7,060.10 1,900.00 142.02 283.57 14.92 1,616.93 13,700.00 1,142.00 2,284.00 16.67 11,416.00 172,150.00 12,699.30 21,331.33 12.39 .150,818.67. 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 101-GENERAL FUND Public Safety I DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Supplies 101-4-2320-4201 Office Supplies 101-9-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-9219 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-4904 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 242.72 242.72 8.09 2,757.28 aoo.oo o.oo o.oo o.oo - 800.00 4,150.00 133.90 133.40 3.21 4,016.60 9,900.00 376.12 376.12 3.80 9,523.88 1,350.00 116.58 150.71 11.16 1,199.29 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 143.35 143.35 7.75 1,706.65 500.00 70.00 70.00 14.00 430.00 6,800.00 329.93 364.06 5.35 6,435.94 TOTAL Fire Inspections Emergency Management Personal Services 101-4-2330-4101 Regular Pay 101-4-2330-9104 PERA 101-4-2330-4107 Medicare 101-4-2330-4108 Insurance TOTAL Personal Services Supplies 101-4-2330-4201 Office Supplies 1.01-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-4-2330-4404 Equip Repair/Maint Services 101-4-2330-9433 Dues & Subscriptions TOTAL Other Services & Charges 188,850.00 13,400.35 22,071.51 11.69 166,778.49 9,950.00 752.72 1,204.35 12.10 8,745.65 1,400.00 106.12 207.15 14.80 1,192.85 150.00 10.26 20.45 13.63 129.55 800.00 69.01 128.02 16.00 671.98 12,300.00 933.11 1,559.97 12.68 10,740.03 2,500.00 0.00 0.00 0.00 2,500.00 8,500.00 399.57 399.57 4.70 8,100.43 11,000.00 399.57 399.57 3.63 10,600.43 1,500.00 100.00 1,850.00 500.00 1,500.00 5,100.00 400.00 10,950.00 130.76 192.88 12.86 1,307.12 0.00 0.00 0.00 100.00 30.60 30.60 1.65 1,819.40 0.00 0.00 0.00 500.00 125.51 125.51 8.37 1,374.49 108.30 108.30 2.12 4,991.70 0.00 200.00. 50.00 200.00 395.17 657.29 6.00 10,292.71 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 17 REVENUE &EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Capital Outlay 101-4-2330-4560 Equipment TOTAL Capital Outlay 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 14,900.00 0.00 0.00 0.00 14,900.00 19,900.00 0.00 0.00 0.00 14,900.00 TOTAL Emergency Management Building Safety Personal Services 101-4-2410-4101 Regular Pay 101-4-2410-4102 Overtime Pay 101-4-2410-4103 Part-time Pay 101-4-2410-4104 PERA 101-4-2410-4105 FICA 101-4-2410-9107 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-4-2410-4321-Telephone 101-4-2410-4322 Postage 101-9-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2910-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4440 Miscellaneous 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 99,150.00 1,727.85 2,616.83 5.32 46,533.17 438,300.00 33,078.54 53,419.92 12.19 384,680.08 500.00 0.00 0.00 0.00 500.00 23,450.00 1,832.80 3,033.60 12.94 20,416.40 31,200.00 2,356.51 4,806.97 15.41 26,393.03 28,650.00 1,964.02 4,044.60 14.12 24,605.40 6,700.00 459.30 945.88 14.12 5,754.12 52,000.00 4,332.01 9,304.03 17.89 42,695.97 1,400.00 0.00 329.25 23.52 1,070.75 582,200.00 44,023.18 75,889.25 13.03 506,315.75 3,000.00 0.00 98.10 3.27 2,901.90 10,950.00 370.15 380.90 3.48 10,569.10 2,150.00 0.00 0.00 0.00 2,150.00 2,650.00 591.13 591.13 22.31 2,058.87 18,750.00 961.28 1,070.13 5.71 17,679.87 7,100.00 286.18 354.73 5.00 6,745.27 1,500.00 0.00 0.00 0.00 1,500.00 11,500.00 0.00 1,603.35 15.68 9,696.65 16,500.00 .0.00 0.00 0.00 16,500.00 10,400.00 303.53 2,319.40 22.30 8,.080.60 1,200.00 85.00 285.00 23.75 915.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 674.71 4,762.48 8.99 98,237.52 I TOTAL Building Safety 653,950.00 45,659.17 81,716.86 12.50 572,233.19 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 18 ' REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Environmental Personal Services 101-9-2440-4101 Regular Pay 101-9-2440-4104 PERA 101-4-2440-4105 FICA 101-4-2440-9107 Medicare 101-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2440-9201 Office Supplies 101-9-2440-4212 Fuels & Lubs 101-4-2490-4217 Uniform Allowance 101-4-2440-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2490-4321 Telephone 101-4-2440-4322 Postage 101-4-2940-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-9-2490-4904 Equip Repair/Maint Services 101-4-2440-4409 Contractual Services 101-4-2440-4433 Dues & Subscriptions 101-4-2440-4460 Equip Replacement Charge TOTAL OtherServices & Charges 52,200.00 9,002.93 3,500.00 270.20 3,200.00 181.21 750.00 42.38 8,450.00 669.60 350.00 0.00 68,950.00 5,166.32 650.00 0.00 200.00 4.55 200.00 0.00 0.00 29.05 1,050.00 33.60 1,350.00 95.76 500..00 0.00 500.00 85.00 500.00 0.00 300.00 0.00 50.00. 0.00 1,500.00 0.00 1,050.00 0.00 750.00 0.00 6,500.00 130.76 6,420.05 12.30 45,779.95 550.65 15.73 2,999.35 373.82 11.68 2,826.18 87.42 11.66 662.58 1,390.90 16.45 7,059.60 98.00 28.00 252.00 8,920.34 13.03 59,529.66 19.62 3.02 630.38 4.55 2.28 195.45 0.00 0.00 200.00 29.05 0.00 ( 29.05) 53.22 5.07 996.78 45.76 3.39 1,304.24 0.00 0.00 500.00 85.00 17.00 415.00 0.00 0.00 500.00 0.00 0.00 300.00 0.00 0.00 50.00 0.00 0.00 1,500.00 0.00 0.00 1,050.00 0.00 0.00 750.00 130.76 2.01 6,369.29 TOTAL Environmental 76,000.00 5,330.68 9,104.32 11.98 66,895.68 TOTAL Public Safety Street Maintenance Personal Services 101-9-3120-4101 Regular Pay '101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-9-3120-4105 FICA 101-4-3120-4107 Medicare 101-4-3120-9108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services 5,728,750.00 436,361.53 732,353.67 12.78 4,996,396.33 445,350.00 28.,576.49 44,254.43 9.94 401,095.57 10,400.00 0.00 ( 63.59) 0.61- 10,463.59 68,950.00 3,603.17 5,781.46 8.39 63,168.54 34,,650.00 2,172.10 3,890.78 11.23 30,759.22 32,050.00 1,838.97 3,402.59 10.62 28,647.41 7,500.00 930.06 795.72 10.61 6,704.28 58,050.00 3,778.51 8,153.89 14.05 49,896.11 20,000.00 0.00 4,922.75 24.61 15,077.25 676,950.00 40,399.30 71,138.08 10.51 605,811.92 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES Supplies 101-4-3120-4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-4-3120-4219 Operating Supplies 101-4-3120-4226 Street Signs TOTAL Supplies Other Services & Charges 101-4-3120-4319 Other Professional Services 101-4-3120-4321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-9359 Publishing 101-4-3120-9361 Insurance 101-4-3120-4389 Utilities 101-4-3120-4401 Bldg Repair/Maint Services 101-4-3120-4404 Equip 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-4960 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 101-4-3120-4560 Equipment TOTFIL Capital Outlay TOTAL Street Maintenance CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 4,800.00 86.56 86.56 1.80 4,713.44 96,450.00 ( 1,491.19)( 1,740.59) 1.80- 98,190.59 160,000.00 4,397.71 4,397.71 2.75 155,602.29 17,500.00 0.00 0.00 0.00 17,500.00 278,750.00 2,993.08 2,743.68 0.98 276,006.32 950.00 113.00 1.13.00 11.89 837.00 9,450.00 423.32 526.47 5.57 8,923.53 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 4,266.95 4,266.95 12.93 28,733.05 6,500.00 0.00 0.00 0.00 6,500.00 0.00 1,394.24 1,399.24 0.00 ( 1,394.29) 199,000.00 0.00 0.00 0.00. 199,000.00 3,500.00 95.85 95.85 2.74 3,404.15 4,850.00 262.27 224.32 4.63 9,625.68 700..00 0.00 241.25 34.46 958.75 500.00 0.00 0.00 0.00 500.00 130,200.00 0.00 0.00 0.00 130,200.00 410,600.00 6,555.63 6,862.08 1.67 403,737.92 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 49,948.01 80,743.84 5.88 1,292,256.16 16.67 OF YEAR COMP. Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4109 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 159,150.00 12,145.30 25,817.09 12,450.00 0.00 370.28 11,800.00 819.82 3,135.65 10,950.00 687.73 2,770.39 2,550.00 160.83 647.92 21,300.00 1,944.58 5,433.93 6,550.00 0.00 1,723.50 224,750.00 15,758.26 39,898.76 16.22 133,332.91 2.97 12,079.72 26.57 8,664.35 25.30 8,179.61 25.41 1,902.08 25.51 15,866.07 26.31 9,826.50 17.75 184,851.24 3-12-2009 10:50 AM 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES PAGE: 20 16.67& OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay 101-9-3130-4560 Equipment TOTAL Capital Outlay TOTAL Snow Removal Equipment Services ------------------ ------------------ Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-4102 Overtime Pay 101-4-3150-4104 PERA 101-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-4-3150-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3150-9219 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 79,000.00 7,833.01 35,025.84 44.34 43,974.16 79,000.00 7,833.01 35,025.89 94.34 43,974.16 5,000.00 0.00 0.00 0.00 b,000.00 5,000.00 0.00 0.00 0.00 5,000.00 308,750.00 23,591.27 74,929.60 24.27 233,825.40 165,200.00 12,444.01 18,772.76 11.36 146,427.24 2,500.00 0.00 95.00 3.80 2,405.00 11,300.00 839.97- 1,495.62 13.24 9,804.38 10,400.00 676.72 1,220.60 11.79 9,179.40 2,450.00 158.27 285.46 11.65 2,164.54 23,000.00 1,896.03 3,123.64 13.58 19,876.36 5,250.00 0.00 1,422.00 27.09 3,828.00 220,100.00 16,015.00 26,415.08 12.00 193,684.92 16,350.00 1,919.02 1,419.02 8.68 14,930.98 14,200.00 0.00 0.00 0.00 19,200.00 30,550.00 1,419.02 1,419.02 4.64 29,130.98 2,000.00 0.00 0.00 0.00 2,000.00 2,800.00 167.86 222.52 7.95 2,577.48 4,800.00 167.86 222.52 4.64 4,577.48 TOTAL Equipment Services Engineering CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 255,450.00 17,601.88 28,056.62 10.98 227,393.38 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67 OF YEAR. COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA 101-4-3300-4105 FICA 101-4-3300-4107 Medicare 101-4-3300-4108 Insurance 101-4-3300-4109 workers Comp TOTAL Personal Services Supplies 101-4-3300-4201 Office Supplies 101-4-3300-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-4904 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Engineering 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 0.00 42.25 42.25 57.75 64,400.00 0.00 -42.25 0.07 64,357.75 850.00 0.00 32.71 3.85 817.29 350.00 24.27 24.27 6.93 325.73 9,850.00 1,750.00 1,750.00 17.77 8,100.00 11,050.00 1,774.27 1,806.98 16.35 9,243.02 88,000.00. 7,122.97 7,122.97 8.09 80,877.03 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 0.00_ 40.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 7,122.97 7,162.97 6.19 108,537.03 191,150.00 8,897.24 9,012.20 4.71 182,137.80 TOTAL Public Works Parks Department Personal Services 101-4-S11D-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 2,128,350.00 100,038.40 192,737.26 9.06 1,935,612.74 338,150.00 24,509.37 38,962.96 11.52 299,187.04 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,712.78 3,272.64 12.99 21,927.36 25,350.00 1,380.99 2,675.27 10.55 22,679.73 5,950.00 322.98 625.67 10.52 5,324.33 51,200.00 3,454.01 6,736.49 13.16 44,463.51 6,500.00 0.00 1,926.00 29.63 4,574.00 523,150.00 31,380.13 54,199.03 10.36 468,950.97 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 22 REVENUE& EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Culture & Recreation 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD 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-4404 Equip Repair/Maint Services 101-4-5110-4409 Contractual Services 101-4-5110-4915 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges 42,850.00 1,145.44 1,160.49 2.71 41,689.51 3,200.00 189.32 208.42 6.51 2,991.58 76,550.00 8,037.37 8,059.69 10.53 68,490.36 122,600.00 9,372.13 9,428.55 7.69 113,171.45 3,900.00 352.33 416.23 10.67 3,483.77 2,550.00 0.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 254.51 254.51 1.69 14,795.49 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 468.65 843.54 3.12 26,156.46 38,100.00 0.00 0.00 0.00 38,100.00 140,400.00 1,075.49 1,689.28 1.20 138,710.72 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 101-4-5210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies 786,150.00 41,827.75 65,316.86 8.31 720,833.14 335,550.00 24,860.54 39,692.34 11.83 295,857.66 700.00 0.00 0.00 0.00 700.00 42,600.00 2,087.82 4,398.98 10.21 38,251.02 25,600.00 1,819.00 3,629.04 14.18 21,970.96 23,500.00 1,554.93 3,147.45 13.39 20,352.55 5,500.00 363.63 736.08 13.38 4,763.92 39,850.00 3,257.10 6,878.50 17.26 32,971.50 4,950.00 0.00 792.75 16.02 4,157.25 478,250:00 33,943.02 59,225.14 12.38 419,024.86 16,900.00 3,357.38 3,357.38 19.87 13,542.62 16,900.00 3,357.38 3,357.36 19.87 13,542.62 Other Services & Charges 101-4-5210-9321 Telephone 9,100.00 317.49 493.10 12.03 3,606.90 101-4-5210-9322 Postage 6,000.00 712.92 712.92 11.88 5,287.08 101-4-5210-4331 Travel, Conferences & Schools 9,150.00 252.00 452.00 4.94 8,698.00 101-4-5210-4349 Advertising/Marketing 30,950.00 3,971.07 3,971.07 12.83 26,978.93 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 2,084.87 2,084.87 16.16 10,815.13 101-4-5210-9401 Bldg Repair/Maint Services 15,850.00 1,002.67 1,864.36 11.7.6 13,985.69 101-4-5210-440.4 Equip Repair/Maint Services 6,750.00 239.63 1,199.63 17.77 5,550.37 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH,2009 ' 101-GENERAL FUND Culture & Recreation DEPARTMENTALEXPENDITURES 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges 16.67$ OF YEAR COMP. CURRENT CURRENT BUDGET .PERIOD 1,650.00 0.00 88,850.00 8,580.65 YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 0.00 0.00 1.,650.00 10,777.95 12.13 78,072.05 TOTAL Parks & Rec Admin Recreation Programs Personal Services 101-4-5220-4101 Regular Pay 101-4-5220-4103 Part-time Pay 101-4-5220-4104 PERA 101-4-5220-4105 FICA 101-4-5220-4107 Medicare 101-4-5220-4108 Insurance TOTAL Personal Services Supplies 101-9-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-44.12 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges I TOTAL Recreation Programs Concessions .584,000.00 45,881.05 73,360.47 12.56 510,639.53 0.00 633.40 1,179.18 0.00 ( 1,179.18) 88,500.00 6,896.06 11,890.74 13.38 76,659.26 1,600.00 172.14 391.75 21.36 1,258.25 4,500.00 965.37 980.18 21.78 3,519.82 1,300.00 108.87 229.28 17.69 .1,070.72 0.00 98.55 237.99 0.00 ( 237.99) 95,900.00 8,374.39 14,809.12 15.44 81,090.88 28,300.00 6.94 6.94 0.02 28,293.06 28,300.00 6.94 6.94 0.02 28,293.06 900.00 0.00 0.00 0.00 400.00 51,000.00 ( 60.74) 3,477.66 6.82 47,522.34 2,500.00 0.00 0.00 0.00 2,500.00 3,000.00 26.89 26.84 0.89 2,973.16 56,900.00 ( 33.90) 3,509.50 6.16 53,395.50 181,100.00 8,347.43 18,320.56 10.12 162,779.44 Personal Services 101-9-5230-4103 Part-time Pay 4,750.00 0.00 0.00 0..00 4,750.00 101-9-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,900.00 0.00 0.00 0.00 5,900.00 Supplies 101-4-5230-4219 Operating Supplies 600.00 101-4-5230-4259 Other Merchandise For Resale 13,400.00 TOTAL Supplies 19,000.00 0.00 0.00 0.00 600.00 443.70 443.70 3.31 12,956.30 443.70 443..70 3.17 13,556.30 3-12-2009 10:50 AM - CITY OF ELK RIVER PAGE: 29 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 101-GENERAL FUND Culture & Recreation I DEPARTMENTAL EXPENDITURES 16.67 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 100.00 0.00 0.00 0.00 100.00 100.00 0.00 0.00 0.00 100.00 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 161-4-5510-4104 PERA 101-4-5510-4105 FICA 101-4-5510-4107 Medicare 101-4-5510-4108 Insurance 101-4-5510-4109 Workers Comp TOTAL Personal Services 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-9361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 19,500.00 443.70 443.70 2.28 19,056.30 54,950.00 4.,083.20 6,533.13 11.89 48,416.87 500.00 0.00 0.00 0.00 500.00 58,700.00 .,4,486.39 7,074.23 12.05 51,625.77 7,700.00 572.95 1,.127.70 14.65 6,572.30 7,100_00 487.75 968.27 13.64 6,131.73 1,650.00 114.08 226.46 13.72 1,423.54 12,400.00 1,039.22 2,068.44 16.68 10,331.56 700.00 0.00 93.00 13.29 607.00 143,700.00 10,778.59 18,091.23 12.59 1.25,608.77 10,950.00 .1,990.14 1,782.91 16.28 9,167.09 10,950.00 1,990.14 1,782.91 16.28 9,167.09 2,400.00 205.31 411.94 17.16 1,988.06 4,000.00 0.00 600.00 15.00 3,400.00 2,900.00 0.00 0.00 0.00 2,400.00 900.00 0.00 0.00 0.00 900.00 8,150.00 1,320.79 1,320.79 16.21 6,829.21 13,500.00 651.39 1,179.53 8.74 12,320.47 8,100.00 ( 471.15)( 413.34) 5.10- 8,513.34 950.00 27.50 42.50 4.97 907.50 90,400.00 1,733.84 3,141.42 7.78 37,258.58 TOTAL Sr Citizen Programs 195,050.00 14,502.57 23,015.56 11.80 172,034.44 TOTAL Culture & Recreation Economic Developement 1,765,600.00 111,002.50 180,457.15 10.22 1,585,342.85 3-12-2009 10:50 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 101-GENERAL FUND Economic Development DEPARTMENTAL EXPENDITURES Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-9105 FICA 101-4-6210-4107 Medicare 101-4-6210-4108 Insurance TOTAL Personal Services Other Services & Charqes 101-4-6210-4331 Travel, Conferences & Schools 101-4-6210-4490 Miscellaneous TOTAL Other Services & Charges 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 10,087.32 20,115.31 0.00 ( 20,115.31) 0.00 1,050.32 2,100.64 0.00 ( 2,100.64) 0.00 703.42 1,390.37 0.00 ( 1,390.37) 0.00 617.99 1,232.31 0.00 ( 1,232.31) 0.00 144.54 288.22 0.00 ( 288.22) 0.00 1,298.00 2,596.00 0.00 ( 2,596.00) 0.00 13,901.59 27,722.85 D.00 ( 27.,722.85) 0.00 ( 317.17) 105.83 0.00 ( 105.83) 0.00 ( 72.41) 35.26 0.00 ( 35.26) 0.00 ( 389.58) 141.09 0.00 ( 141.09) 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-9107 Medicare 101-4-6220-4108 Insurance TOTAL Personal Services Other Services & Charqes 101-4-6220-4319 Other Professional Services 101-4-6220-4331 Travel, Conferences & Schools 101-4-6220-4359 Publishing TOTAL Other Services & Charges 0.00 13,512.01 27,863.94 0.00 ( 27,863.94) 27,250.00 2,110.59 3,398.59 12.29 23,901.96 1,550.00 142.48 274.33 17.70 1,275.67 1,500.00 99.40 192.61 12.84 1,307.39 400.00 23.24 45.04 11.26 354.96 3,600.00 300.01 574.41 15.96 3,025.59 34,300.00 2,675.72 4,434.93 12.93 29,865.07 2,000.00 0.00 0.00 0.00 2,000.00 17,000.00 ( 7,050.00)( 7,660.00) 95.06- 24,660.00 2,500.00 46.45 96.45 1.86 2,453.55 21,500.00 ( 7,003.55)( 7,613.55) 35.41- 29,113.55 TOTAL Energy City 55,800.00 ( 4,327.83)( 3,178.62) 5.70- 58,978.62 TOTAL Economic Development Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 101-4-7000-4724 Transfer - Pinewood 101-4-7000-4730 Transfer-Debt Service TOTAL Transfers Out 55,800.00 9,184.18 24,685.32 44.24 31,114.68 121,600.00 0.00 80,500.00 0.00 66,600.00 0.00 268,700.00 0.00 0.00 0.00 121,600.00 0.00 0.00 80,500.00 0.00 0.00 66,600.00 0.00 0.00 268,700.00 0.00 0.00 268,700..00 TOTAL Transfers Out 268,700.00 0.00 3-12-2009 10:50 AM 101-GENERAL FUND General DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 16.67 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 632,543.51 1,420,660.37 11.24 11,215,939.63 0.00 ( 700,369.59)( 1,241,854.82) 1,241,854.82 3-12-2009 10:53 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 26TH, 2009 221-ICE ARENA FINANCIAL SUMMARY 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD 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 87,481.90 130,097.99 17.20 626,102.01 70.,000.00 32,190.00 34,530.00 49.33 35,470.00 84,700.00 15,544.00 23,416.00 27.65 61,284.00 73,000.00 10,147.56 24,097.01 33.01 48,902.99 983,900.00 145,362.96 212,141.00 21.56 771,759.00 869,100.00 97,666.27 66,316.95 7.63 802,783.05 30,150.00 254.75 254.75 0.89 29,895.25 34,450.00 1,727.44 2,514.57 7.30 .31,935.43 50,200.00 7,023.99 8,401.38 16.74 41,798.62 983,900.00 56,672.45 77,487.65 7.88 906,412.35 983,900.00 56,672.45 77,487.65 7.88 906,412.35 0.00 88,690.51 134,653.35 ( 134,653.35) 3-12-2009 10:53 AM CITY OF ELK RIVER - PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 ~ 221-ICE ARENA REVENUES 16.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-3482 Advertising fee TOTAL Charges for Services Other Revenue 221-3-0000-3622 Vending Machines 221-3-0000-3626 Contributions 221-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 221-3-0000-3921 Transfers 221-3-0000-3922 Transfer-General Fund TOTAL Transfers In I TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services TOTAL Hockey Skating Charges for Services 221-3-5420-3461 Recreation Fees TOTAL Charges for Services 70,000.00 32,190.00 34,530.00 49.33 35,470.00 84,700.00 15,544.00 23,416.00 27.65 61,284.00 84,700.00 15,594.00 23,416.00 27.65 61,284.00 432,000.00 68,957.31 101,133.06 23.41 330,866.94. 33,000.00 11,062..50 18,348.00 55.60 14,652.00 15,000.00 369.00 762.00 5.08 14,238.00 9,500.00 676.00 1,744.00 36.76 2,756.00 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 790.00 790.00 4.27 17,710.00 505,600.00 81,854.81 122,777.06 29.28 382,822.99 22,000.00 1,881.50 3,240.84 19.73 18,759.16 0.00 3,943.00 3,443.00 0.00 ( 3,443.00) 2,000.00 302.09 637.09 31.85 1,362.91 24,000.00 5,626.59 7,320.93 30.50 16,679.07 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 87,481.40 130,097.99 17.20 626,102.01 70,000.00 32,190.00 34,530.00 49.33 35,470.00 70,000.00 32,190.00 34,530.00 99.33 35,470.00 1 3-12-2009 10:53 AM 1 221-ICE ARENA 1 REVENUES Other Revenue I TOTAL Skating Concessions I Charges for Services 221-3-5430-3467 Concessions TOTAL Charges 'for Services I TOTAL Concessions CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 26TH, 2009 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE 8 OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 84,700.00 15,544.00 23,416.00 27.65 61,284.00 73,000.00 10,147.56 24,097.01 33.01 48,902.99 73,000.00 10,147.56 29,097.01 33.01 48,902.99 73,000.00 10,147.56 24,097.01 33.01 48,902.99 TOTAL REVENUE 983,900.00 145,362.96 212,141.00 21.56 771,759.00 3-12-2009 10:53 AM CITY OF ELK RIVER - PAGE: 4- REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 ~ 221-ICE ARENA DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 150,300.00 14,223.88 22,667.63 15.08 127,632.37 221-4-5400-4103 Part-time Pay 77,850.00 7,170.73. 11,721.69 15.06 66,128.31 221-4-5400-4104 PERA 11,350.00 1,301.40 2,483.48 21.88 8,866.52 221-9-5400-4105 FICA 14,150.00 1,305.83 2,577.18 16.21 11,572.82 221-9-5400-4107 Medicare 3,300.00 305.39 602.74 18.26 2,697.26 221-9-5400-4108 Insurance 16,600.00 1,778.84 3,324.38 20.03 13,275.62 221-4-5400-9109 Workers Comp 4,350.00 0.00 1,116.50 25.67 3,233.50 TOTAL Personal Services 277,900.00 26,086.07 44,493.60 16.01 233,406.40 Supplies 221-4-5900-4212 Fuels & Lubs 300.00 221-4-5400-4217 Uniform Allowance 1,500.00 221-4-5400-4219 Operating Supplies 48,500.00 221-9-5400-4255 Soft Drinks/Misc 13,500.00 221-9-5400-4259 Other Merchandise For Resale 1,200.00 SOTAL Supplies 65,000.00 Other Services & Charges 221-4-5400-4321 Telephone 2,900.00 221-4-5400-4322 Postage 500.00 221-4-5400-4331 Travel, Conferences & Schools 1,050.00 221-4-5400-4359 Publishing 3,800.00 221-4-5400-4361 Insurance 9,000.00 221-4-5400-4389 Utilities 175,850.00 221-4-5400-9401 Bldg Repair/Maint Services 26,750.00 221-4-5400-4409 Contractual Services 2,000.00 221-4-5900-4415 Equipment Rental 5,400.00 221-4-5900-4433 Dues & Subscriptions 450.00 TOTAL Other Services & Charges 227,700,00 Capital Outlay 221-4-5400-4520 Buildings & Structures 100,000.00 TOTAL Capita l Outlay 100,000.00 Transfers Out 221-4-5400-4730 Transfer-Debt Service 198,500.00 TOTAL Transf ers Out 198,500.00 208.47)( 208.47) 69.49- 508.97 87.50 87.50 5.83 1,412.50 2,727.98 2,727.98 5.62 95,772.02 0.00 0.00 0.00 13,500.00 221.85 221.85 18.99 978.15 2,828.86 2,828.86 4.35 62,171.14 215.20 318.35 10.98 2,581.65 0.00 0.00 0.00 500.00 0.00 0.00 0.00 1,050.00 79.00 79.00 2.06 3,721.00 0.00 0.00 0.00 9,000.00 17,700.13 17,700.13 10.07 158,149.87 368.73 368.73 1.38 26,381.27 0.00 0.00 0.00 2,000.00 340.78 340.78 6.31 5,059.22 97.50 187.50 41.67 262.50 18,751.34 18,999.49 8.34 208,705.51 0.00 0.00 0.00 100,000.00 0.00 0.00 0.00 100,000.00 0.00 0.00 0.00 198,500.00 0.00 0.00 0.00 198,500.00 TOTAL Ice Arena 869,100.00 47,666.27 66>316.95 7.63 802,783.05 3-12-2009 10:53 AM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 PAGE: 5 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 221-4-5410-4105 FICA 221-4-5410-4107 Medicare TOTAL Personal Services Supplies 221-4-5410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5410-4322 Postage 221-4-5410-4359 Publishing 221-4-5410-4409 Contractual Services 221-9-5410-4438 Credit Card Fees TOTAL Other Services & Charges 3,600.00 154.00 154.00 4.28 3,446.00 200.00 9.55 9.55 4.78 190.95 50.00 2.23 2.23 4.46 47.77 3,850.00 165.78 165.78 4.31 3,684.22 14,850.00 0.00 0.00 0.00 14,850.00 14,850.00 0.00 0.00 0.00 19,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 88.97 88.97 4.04 2,111.03 11,950.00 88.97 88.97 0.78 11,361.03 TOTAL Hockey Skating Personal Services 221-4-5420-4103 Part-time Pay 221-4-5420-4104 PERA 221-4-5420-4105 FICA 221-4-5420-4107 Medicare TOTAL Personal Services Supplies 221-4-5420-4219 Operating Supplies TOTAL Supplies Other Services & Charges 221-4-5920-9322 Postage 221-4-5920-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges 30,150.00 259.75 259.75 0.89 29,895.25 20,000.00 1,284.78 1,957.68 9.79 18,042.32 500.00 62.24 103.95 20.79 396.05 1,250.00 79.66 138.44 11.06 1,111.56 300.00 18.64 32.38 10.79 267.62 22,050.00 1,445.32 2,232.45 10.12 19,817.55 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 282.12 282.12 11.52 2,167.88 6,400.00 282.12 282.12 9.41 6,117.88 I TOTAL Skating 34,450.00 1,727.94 2,519.57 7.30 31,935.43 ~ 3-12-2009 10:53 AM I 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES ~ Arena Concessions CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, .2009 16.67 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF ~ BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-543-0-9103 Part-time Pay 20,900.00 2,254.15 3,471.34 16.61 17,428.66 221-4-5430-4104 PERA 0:00 55.20 97.16 0.00 ( 97..16) 221-4-5430-4105 FICA 1,300.00 139.75 235.58 16.12 1,064.42 221-4-5430-4107 Medicare 300.00 32.67 55.08 18.36 244.92 TOTAL Personal Services 22,500.00 2,481.77 3,859.16 17.15 18,640.84 Supplies 221-4-5930-4219 Operating Supplies 6,700.00 284.12 289.12 4.24 6,415.88 221-4-5430-4259 Other Merchandise For Resale 21,000.00 4,258.10 4,258.10 20.28 16,741.90 TOTAL Supplies 27,700.00 4,542.22 4,542.22 16.40 23,157.78 I TOTAL Arena Concessions 50,200.00 7,023.99 8,401.38 16.74 41,798.62 TOTAL Culture & Recreation 983,900.00 56,672.45 77,487.65 7.88 906,412.35 TOTAL EXPENDITURES ~ REVENUES OVER/(UNDER) EXPENDITURES 983,900.00 56,672.45 77,487.65 7.88 906,412.35 0.00 88,690.51 134,653.35 ( 139,653.35) 3-12-2009 10:54 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 I 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course TOTAL REVENUES I 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 11,608.21 18,246.03 6.68 254,753.97 273,000.00 11,608.21 18,296.03 6.68 254,753.97 273,000.00 11,608.21 18,246.03 6.68 254,753.97 0.00 ( 11,608.21)( 18,246.03) 18,296.03 3-12-2009 10:54 AM 222-PINEWOOD GOLF COURSE ~ REVENUES Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-3467 Concessions 222-3-0000-3469 Other Sales 222-3-0000-3476 Green Fees 222-3-0000-3477 Membership Fees 222-3-0000-3478 Golf Cart Rental 222-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2009 16.67$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 20,000.00 0.00 0.00 0.00 20,000.00 19,000.00 0.00 0.00 0.00 19,000.00 4,000.00 0.00 0.00 0.00 4,000.00 112,000.00 0.00 0.00 0.00 112,000.00 18,000.00 0.00 0.00 0.00 18,000.00 19,000.00 0.00 0.00 0.00 19,000.00 500.00 0.00 0.00 0.00 500.00 192,500.00 0.00 0.00 0.00 192,500.00 80,500.00 0.00 80,500.00 0.00 273,000.00 0.00 0.00 0.00 80,500.00 0.00 0.00 80,500.00 0.00 0.00 273,000.00 I TOTAL REVENUE 273,000.00 0.00 0.00. 0.00 273,000.00 3-12-2009 10:54 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED). AS OF: FEBRUARY 28TH, 2009 I 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 16.67 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL ~ BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 99,700.00 6,887.24 10,840.79 10.87 88,859.21 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 288.00 612.00 2.00 30,038.00 222-4-5300-4104 PERA 8,800.00 464.90 915.99 10.41 7,8.84.01 222-4-5300-4105 FICA 8,100.00 430.70 860.67 10.63 7,239.33 222-4-5300-4107 Medicare 1,900.00 100.73 201.30 10.59 1.,698.70 222-4-5300-4108 Insurance 10,500.00 777.45 1,514.01 14.42 8,985.99 222-4-5300-4109 Workers Comp 1,050.00 0.00 294.00 28.00 756.00 TOTAL Person al Services 160,800.00 8,949.02 15,238.76 9.48 145,561.24 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00 222-4-5300-4217 Uniform Allowance 500.00 0.00 0.00 0.00 500.00 222-4-5300-4219 Operating Supplies 28,100.00 1,108.51 1,121.59 3.99 26,978.41 222-4-5300-4259 Other Merchandise For Resale 10,800.00 0.00 0.00 0.00 10,800.00 TOTAL Suppli es 44,400.00 1,108.51 1,121.59 2.53 43,278.41 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 89.32 89.32 3.57 2,410.66 222-4-5300-4331 Travel, Conferences & Schools 900.00 232.99 232.99 58.25 167.01 222-4-5300-9349 Advertising/Marketing 1,500.00 0.00 0.00 0.00 1,500.00 222-4-5300-9361 Insurance 11,550..00 0.00 0.00 0.00 11,550.00 222-4-5300-4389 Utilities 6,800.00 375.88 375.88 5.53 6,424.12 222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 19.97 19.97 1.00 1,980.03 222-4-5300-4404 Equip Repair/Maint Services 2,500.00 828.05 828.05 33.12 1,671.95 222-4-5300-4415 Equipment Rental 36,050.00 0.00 0.00 0.00 36,050.00 222-4-5300-4437 Taxes & Licenses 1,000.00 0.00 335.00 33.50 665.00 222-4-5300-4438 Credit Card Fees 3,500.00 4.47 4.47 0.13 3,495.53 TOTAL Other Services & Charges 67,800.00 1,550.68 1,885.68 2.78 65,914.32 Capital Outlay Debt Service TOTAL Golf Course 273,000.00 11,608.21 18,246.03 6.68 254.,753.97 TOTAL Culture & Recreation 273,000.00 11,608.21 18,246.03 6.68 254,753.97 ~. TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 273,000.00 11,608.21 18,296.03 ------------- ------------- ------------- ------------- ------------- ------------- 0.00 ( 11,608.21)( 18,246.03) 6.68 254,753.97 18,246.03