Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #6 04-20-2009
..s~~~. a -,~~. v ~~~ fiver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: April 20, 2009 SUBJECT: March 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 March, actual revenues (except for property taxes and state aids) and expenditures should generally run about 25% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget axe highlighted below accompanied with a general discussion for the variance. General Fund Aevenue.r: • Revenue collections are at 2.7% of budget; however, property taxes, our largest revenue source, will be received in July and December. • Total licenses and permits axe right in line with the budgeted revenues, while recreation-related charges for services are exceeding budget estimates as of the end of March. • 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. E.xpenditure.r: • Excluding transfers, the total departmental expenditures axe at about 19.7% and most departments axe well within or below budget. • The Mayor & Council budget is at 30% of budget due to the payment of liability insurance premiums paid through June 30, which is also the case in the Building Safety department. • The transfers out to the Ice Arena and Pinewood Golf Course are made at the end of the year. • Council approved budget amendments are reflected in this month's report Ice Arena For the period ending March 31, revenues exceed expenditures by about $140,000. Excluding transfers, revenues axe at 37% of budget due to hockey season revenues and registrations for hockey and skating programs while expenditures are about 18% of budget. Pinewood Golf Golf revenues will start to increase in April as the Course is fully open. Expenditures are about 12.8% of budget due mainly to personal services and insurance. 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) ~ ~ ~~~~~~~ AS OF: MARCH 31ST, 2009 ~,p 101-GENERAL FUND FINANCIAL SUMMARY 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 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 12,636,100.00 149,375.32 341,989.65 2.71 12,294,110.35 12,636,100.00 149,375.32 341,989.65 2.71 12,294,110.35 168,100.00 43,170.88 51,147.29 30.93 116,952.71 81,800.00 5,098.74 13,645.23 16.68 68,154.77 471,650.00 35,412.56 96,107.30 20.38 375,542.70 197,950.00 10,452.02 30,203.73 20.41 117,746.27 447,300.00 28,840.04 86,476.47 19.33 360,823.53 278,050.00 22,343.33 43,563.21 15.67 234,486.79 234,000.00 17,846.00 32,377.00 13.84 201,623.00 126,950.00 12,628.62 35,112.19 27.66 91,837.81 321,200.00 23,372.75 63,024.58 19.62 258,175.42 286,350.00 24,053.67 62,037.61 21.66 224,312.39 70,050.00 0.00 0.00 0.00 70,050.00 2,633,900.00 223,218.61 513,694.61 19.51 2,119,705.39 597,700.00 44,084.70 199,864.07 33.44 397,835.93 2,182,800.00 145,532.95 386,574.96 17.71 1,796,225.04 714,150.00 47,891.76 126,612.48 17.73 587,537.52 492,050.00 34,323.44 97,945.73 19.91 394,104.27 22,750.00 12.27 681.79 3.00 22,068.21 202,700.00 16,126.87 37,931.83 18.97 165,268.17 972,200.00 35,340.32 91,045.60 19.28 381,154.40 188,850.00 13,006.24 35,077.75 18.57 153,772.25 49,150.00 1,460.83 9,077.66 8.30 45,072.34 588,600.00 87,502.72 169,190.53 28.74 419,409.47 75,350.00 5,556.11 19,690.95 19.43 60,709.55 5,586,300.00 430,838.21 1,163,192.85 20.82 4,423,157.15 1,300,650.00 73,705.82 154,513.20 11.88 1,196,136.80 308,750.00 44,381.79 119,337.85 38.65 189,412.15 250,450.00 16,946.26 44,907.88 17.93 205,542.12 191,150.00 6,233.15 15,245.35 7.98 175,904.65 2,051,000.00 141,267.02 334,004.28 16.28 1,716,995.72 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND FINANCIAL SUMMARY 25.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Developement Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 733,150.00 52,933.59 118,250.45 16.13 614,899.55 541,450.00 41,009.82 114,370.29 21.12 427,079.71 164,300.00 10,792.08 29,724.64 18.09 134,575.36 19,500.00 38.37 482.07 2.47 19,017.93 193,350.00 15,462.67 38,478.23 19.90 159,871.77 1,651,750.00 120,236.53 301,305.68 18.24 1,350,444.32 0.00 15,417.76 55,800.00 2,210.71 55,800.00 17,628.47 43,281.70 0.00 ( 43,281.70) 967.91) 1.73- 56,767.91 42,313.79 75.83 13,486.21 229,300.00 66,600.00 66,600.00 29.04 162,700.00 229,300.00 66,600.00 66,600.00 29.04 162,700.00 12,207,550.00 999,788.84 2,421,061.21 19.83 9,786,488.79 428,550.00 ( 850,413.52)( 2,079,071.56) 2,507,621.56 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND REVENUES CURRENT CURRENT BUDGET PERIOD 25.OOo OF YEAR COMP. YEAR TO DATE $ OF BUDGET ACTUAL BUDGET BALANCE General Fund Property Taxes 101-3-0000-3111 Current Ad Valorem Taxes 101-3-0000-3121 Gravel Tax 101-3-0000-3132 Tax Forfeited Land Sale TOTAL Property Taxes Linceses & Permits 101-3-0000-3211 Liquor License 101-3-0000-3212 Amusement License '_O1-3-0000-3213 Cigarette License i01-3-0000-3214 Apartment License 101-3-0000-3216 Mining License 101-3-0000-3217 Garbage Hauler License 101-3-0000-3218 Other Business License/Permit 101-3-0000-3229 NPDES Permit 101-3-0000-3231 Building Permit 101-3-0000-3232 Plumbing/Heating Permit 101-3-0000-3233 Permit Surcharge 101-3-0000-3234 Electric Permit 101-3-0000-3235 Animal License 101-3-0000-3236 Parking Permit 101-3-0000-3237 Other Non-Business Lic/Permit TOTAL Linceses & Permits Intergovernmental Rev 101-3-0000-3321 Local Government Aid 101-3-0000-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-3341 County Reimb/Grant TOTAL Intergovernmental Rev 9,547,550.00 0.00 0.00 0.00 9,547,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 51,000.00 0.00 90.00 1,000.00 0.00 0.00 3,000.00 0.00 0.00 15,850.00 3,135.00 3,195.00 9,000.00 13,121.70 16,118.40 3,000.00 0.00 3,095.00 13,000.00 1,860.00 11,665.00 5,000.00 525.00 525.00 188,300.00 11,501.00 29,631.42 47,600.00 8,076.43 19,244.40 200.00 337.00 712.93 100.00 0.00 0.00 3,000.00 330.00 825.00 1,500.00 0.00 1,140.00 12,000.00 580.00 2,380.00 353,550.00 39,466.13 88,572.15 0.08 0.00 0.00 20.16 179.09 103.17 89.73 10.50 15.74 40.43 356.47 0.00 27.50 76.00 25.05 50,960.00 1,000.00 3,000.00 12,655.00 7,118.40) 95.00) 1,335.00 4,475.00 158,668.58 28,355.60 512.93) 100.00 2,175.00 360.00 9,620.00 264,977.85 686,800.00 0.00 0.00 0.00 686,800.00 15,000.00 0.00 0.00 0.00 15,000.00 215,000.00 0.00 0.00 0.00 215,000.00 10,000.00 0.00 0.00 0.00 10,000.00 36,800.00 0.00 19,487.34 52.95 17,312.66 12,500.00 0.00 0.00 0.00 12,500.00 7,500.00 0.00 0.00 0.00 7,500.00 983,600.00 0.00 19,487.34 1.98 964,112.66 Char ges for Services 101- 3-0000-3412 Planning & Zoning Fees 25,000.00 110.00 3,120.00 12.48 21,880.00 101- 3-0000-3413 Plan Check Fee 75,300.00 4,326.76 10,968.01 14.57 69,331.99 101- 3-0000-3415 Special Assessment Search 500.00 40.00 160.00 32.00 390.00 101- 3-0000-3417 Copies 1,500.00 10.17 582.35 38.82 917.65 101- 3-0000-3918 Other General Govt Services 5,000.00 630.00 1,009.88 20.20 3,990.12 101- 3-0000-3430 Lockout Fees 8,500.00 620.00 2,325.00 27.35 6,175.00 101- 3-0000-3431 Police Services 2,000.00 230.25 389.75 19.49 1,610.25 101- 3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00 101- 3-0000-3439 Animal Impound Fee 3,000.00 375.00 635.00 21.17 2,365.00 101- 3-0000-3436 Fire Contracts 208,000.00 0.00 0.00 0.00 208,000.00 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 ^ 101-GENERAL FUND ' REVENUES CURRENT CURRENT BUDGET PERIOD 25.00$ OF YEAR COMP. YEAR TO DATE g OF BUDGET ACTUAL BUDGET BALANCE 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-3475 Building Rent 101-3-0000-3483 Sewer Inspection Fee 101-3-0000-3484 Contractor License Check TOTAL Charges for Services Fines, Fees, & Forfeit 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines TOTAL Fines, Fees, & Forfeit 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-WWTS 101-3-0000-3993 Transfer-Liquor 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL General Fund 1,000.00 0.00 0.00 0.00 1,000.00 25,000.00 157.00 884.00 3.54 24,116.00 121,500.00 29,366.26 49,687.19 40.89 71,812.81 20,100.00 ( 22.75) 1,494.93 7.44 18,605.07 2,600.00 7,100.92 7,293.10 280.50 ( 4,693.10) 3,100.00 406.64 1,838.85 59.32 1,261.15 2,900.00 1,100.00 1,500.00 62.50 900.00 5,000.00 130.00 130.00 2.60 9,870.00 500.00 40.00 75.00 15.00 425.00 585,000.00 44,619.75 119,593.06 20.49 465,406.94 150,000.00 10,353.04 17,732.61 11.82 132,267.39 7,000.00 2,720.00 7,695.75 109.94 ( 695.75) 157,000.00 13,073.04 25,428.36 16.20 131,571.64 180,000.00 0.00 ( 30,116.22) 16.73- 210,116.22 59,000.00 0.00 0.00 0.00 59,000.00 22,800.00 306.00 15,676.00 68.75 7,124.00 3,000.00 910.90 1,323.41 44.11 1,676.59 259,800.00 1,216.40 ( 13,116.81) 5.05- 272,916.81 35,000.00 0.00 0.00 0.00 35,000.00 39,500.00 0.00 0.00 0.00 39,500.00 50,000.00 0.00 0.00 0.00 50,000.00 298,600.00 0.00 0.00 0.00 298,600.00 200,000.00 51,000.00 102,000.00 51.00 98,000.00 17,000.00 0.00 0.00 0.00 17,000.00 9,500.00 0.00 0.00 0.00 9,500.00 599,600.00 51,000.00 102,000.00 17.01 497,600.00 12,636,100.00 149,375.32 391,989.65 2.71 12,294,110.35 ^ TOTAL REVENUE 12,636,100.00 149,375.32 341,989.65 2.71 12,294,110.35 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 ~ i01-GENERAL FUND ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00$ OF YEAR COMP. YEAR TO DATE $ OF BUDGET 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-4322 Postage 101-4-1110-4331 Travel, Conferences & Schools 101-4-1110-4359 Publishing 101-9-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-9-1110-4440 Miscellaneous TOTAL Other Services & Charges 38,500.00 3,208.00 9,624.00 25.00 28,876.00 1,950.00 102.07 306.21 15.70 1,693.79 2,400.00 198.90 596.70 24.86 1,803.30 550.00 46.52 139.56 25.37 410.44 50.00 9.75 19.50 39.00 30.50 43,450.00 3,565.24 10,685.97 24.59 32,764.03 3,200.00 659.09 659.09 20.60 2,540.91 3,200.00 659.09 659.09 20.60 2,540.91 6,750.00 2,645.16 3,581.16 53.05 3,168.84 800.00 0.00 0.00 0.00 800.00 6,500.00 45.04 45.04 0.69 6,454.96 18,200.00 2,898.78 2,964.78 16.29 15,235.22 64,800.00 31,312.00 31,312.00 48.32 33,488.00 15,000.00 0.00 0.00 0.00 15,000.00 9,400.00 2,045.57 1,899.25 20.20 7,500.75 121,450.00 38,946.55 39,802.23 32.77 81,647.77 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-9108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 168,100.00 43,170.88 51,147.29 30.43 116,952.71 50,600.00 3,752.00 9,755.21 19.28 40,844.79 11,800.00 256.25 693.75 5.88 11,106.25 3,550.00 253.26 753.68 21.23 2,796.32 4,000.00 245.95 731.85 18.30 3,268.15 950.00 57.52 171.15 18.02 778.85 5,250.00 438.01 1,314.03 25.03 3,935.97 200.00 93.25 86.50 43.25 113.50 76,350.00 5,046.24 13,506.17 17.69 62,843.83 3,350.00 47.50 111.35 3.32 3,238.65 3,350.00 47.50 111.35 3.32 3,238.65 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 I 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-9-1120-4319 Other Professional Services 101-4-1120-4322 Postage 101-4-1120-4331 Travel, Conferences & Schools 101-4-1120-4404 Equip Repair/Maint Services TOTAL Other Services & Charges 500.00 100.00 1,400.00 100.00 2,100.00 0.00 0.00 0.00 0.00 0.00 0.00 5.00 27.71 1.98 0.00 0.00 0.00 5.00 27.71 1.32 500.00 100.00 1.372.29 2,072.29 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-4109 PERA 101-4-1210-4105 FICA 101-4-1210-4106 Other Retirement Contributions 101-4-1210-4107 Medicare 101-4-1210-4108 Insurance 101-4-1210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1210-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1210-4319 Other Professional Services 101-4-1210-4321 Telephone 101-4-1210-4322 Postage 101-4-1210-4331 Travel, Conferences & Schools 101-4-1210-4361 Insurance 101-4-1210-4404 Equip Repair/Maint Services 101-9-1210-4433 Dues & Subscriptions 101-4-1210-9460 Equip Replacement Charge TOTAL Other Services & Charges 81,800.00 5,098.74 13,645.23 16.68 68,154.77 296,750.00 22,390.66 58,215.72 19.62 238,534.28 2,000.00 0.00 0.00 0.00 2,000.00 45,600.00 3,328.31 8,691.70 19.06 36,908.30 23,250.00 1,736.03 5,166.92 22.22 18,083.08 21,350.00 1,552.29 9,648.16 21.77 16,701.84 4,800.00 400.00 1,200.00 25.00 3,600.00 5,000.00 363.04 1,087.08 21.74 3,912.92 23,450.00 1,954.03 5,862.09 25.00 17,587.91 1,300.00 350.50 701.00 53.92 599.00 423,500.00 32,074.86 85,572.67 20.21 337,927.33 9,900.00 600.61 1,186.26 11.98 8,713.74 9,900.00 600.61 1,186.26 11.98 8,713.74 4,500.00 0.00 600.00 80.53 1,500.00 0.00 5,600.00 977.78 200.00 112.00 22,600.00 2,066.78 2,600.00 0.00 650.00 0.00 38,250.00 2,737.09 4,860.00 108.00 ( 360.00) 140.16 23.36 459.84 0.00 0.00 1,500.00 699.25 11.59 4,950.75 112.00 56.00 88.00 3,436.96 15.21 19,163.04 150.00 5.77 2,450.00 0.00 0.00 650.00 9,348.37 24.44 28,901.63 TOTAL Administrative Services Human Resources 471,650.00 35,912.56 96,107.30 20.38 375,542.70 9-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 I 101-GENERAL FUND General Government ' DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4109 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-9-1220-'4108 Insurance 101-4-1220-9109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage i01-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges 68,850.00 5,219.29 13,570.02 19.71 55,279.98 95,200.00 3,352.32 9,928.43 20.86 35,771.57 7,700.00 578.58 1,790.28 23.25 5,909.72 7,100.00 525.88 1,638.43 23.08 5,461.57 1,650.00 122.98 383.16 23.22 1,266.84 5,250.00 938.00 1,314.00 25.03 3,936.00 450.00 116.25 232.50 51.67 217.50 136,200.00 10,353.25 28,356.82 20.82 107,843.18 3,000.00 35.82 1,693.31 54.78 1,356.69 3,000.00 35.82 1,643.31 54.78 1,356.69 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 17.95 0.48 3,732.05 650.00 0.00 0.00 0.00 650.00 1,000.00 62.95 185.65 18.57 814.35 8,750.00 62.95 203.60 2.33 8,546.40 TOTAL Human Resources 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-4-1310-4107 Medicare 101-9-1310-4108 Insurance 101-4-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1310-4301 Audit Fees 101-4-1310-4319 Other Professional Services 101-4-1310-4321 Telephone 101-4-1310-4322 Postage 101-4-1310-4331 Travel, Conferences & Schools 101-9-1310-4359 Publishing 147,950.00 10,452.02 30,203.73 20.41 117,746.27 284,350.00 21,325.17 55,445.42 19.50 228,904.58 5,150.00 330.00 615.00 11.99 4,535.00 19,550.00 1,439.44 4,283.52 21.91 15,266.48 17,950.00 1,245.22 3,704.63 20.64 14,245.37 4,200.00 291.21 866.38 20.63 3,333.62 23,450.00 1,954.03 5,862.09 25.00 17,587.91 1,100.00 295.25 590.50 53.68 509.50 355,750.00 26,880.32 71,367.54 20.06 289,382.46 3,850.00 290.81 651.00 16.91 3,199.00 3,850.00 290.81 651.00 16.91 3,199.00 17,300.00 0.00 2,400.00 13.87 14,900.00 48,150.00 0.00 0.00 0.00 48,150.00 850.00 67.66 127.29 14.98 722.71 3,600.00 0.00 0.00 0.00 3,600.00 4,150.00 1,601.25 2,018.32 48.63 2,131.68 2,000.00 0.00 0.00 O.OD 2,000.00 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES 25.OOo OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1310-4404 Equip Repair/Maint Services 10,100.00 0.00 9,375.32 92.82 724.68 101-4-1310-4433 Dues & Subscriptions 1,550.00 0.00 445.00 28.71 1,105.00 101-4-1310-4440 Miscellaneous 0.00 0.00 92.00 0.00 ( 92.00) TOTAL Other Services & Charges 87,700.00 1,668.91 14,457.93 16.49 73,292.07 TOTAL Finance Information Technology 447,300.00 28,840.04 86,476.47 19.33 360,823.53 Personal Services 101-4-1350-4101 Regular Pay 129,300.00 9,769.30 25,240.89 19.52 104,059.16 101-4-1350-4103 Part-time Pay 12,850.00 0.00 0.00 0.00 12,850.00 101-4-1350-4104 PERA 9,600.00 659.43 1,950.43 20.32 7,649.57 101-4-1350-4105 FICA 8,800.00 570.34 1,711.53 19.45 7,088.97 101-4-1350-4107 Medicare 2,050.00 133.39 400.28 19.53 1,649.72 101-4-1350-9108 Insurance 15,350.00 1,280.02 3,890.06 25.02 11,509.99 101-4-1350-4109 Workers Comp 550.00 145.00 290.00 52.73 260.00 TOTAL Personal Services 178,500.00 12,557.48 33,433.14 18.73 145,066.86 Supplies 101-4-1350-4219 Operating Supplies 23,300.00 303.11 567.02 2.43 22,732.98 TOTAL Supplies 23,300.00 303.11 567.02 2.43 22,732.98 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 330.00 330.00 4.13 7,670.00 101-4-1350-4321 Telephone 800.00 71.37 117.13 14.64 682.87 101-4-1350-4331 Travel, Conferences & Schools 4,500.00 73.48 108.03 2.40 4,391.97 101-4-1350-4904 Equip Repair/Maint Services 19,950.00 4,515.20 9,515.20 22.63 15,439.80 TOTAL Other Services & Charges 33,250.00 4,990.05 5,070.36 15.25 28,179.64 Capital Outlay 101-9-1350-4560 Equipment 43,000.00 4,492.69 4,492.69 10.45 38,507.31 TOTAL Capital Outlay 43,000.00 4,992.69 4,492.69 10.45 38,507.31 TOTAL Information Technology Legal Other Services & Charges 101-4-1900-4304 Legal Fees TOTAL Other Services & Charges 278,050.00 22,343.33 43,563.21 15.67 234,486.79 234,000.00 17,846.00 32,377.00 13.84 201,623.00 234,000.00 17,846.00 32,377.00 13.84 201,623.00 I TOTAL Legal 234,000.00 17,846.00 32,377.00 13.84 201,623.00 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 I 101-GENERAL FUND General Government I DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ~ Community Development Personal Services 101-4-1500-4101 Regular Pay 84,550.00 101-4-1500-4109 PERA 5,700.00 101-4-1500-4105 FICA 5,300.00 101-4-1500-4107 Medicare 1,250.00 101-4-1500-4108 Insurance 8,700.00 101-4-1500-4109 Workers Comp 550.00 i01-4-1500-4110 Re-employment Compensation 18,100.00 TOTAL Person al Services 129,150.00 Supplies 101-9-1500-4201 Office Supplies 250.00 TOTAL Suppli es 250.00 Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 TOTAL Other Services & Charges 2,550.00 10,237.72 26,959.27 31.89 57,590.73 316.75 1,710.57 30.01 3,989.43 610.30 1,822.16 34.38 3,477.84 192.74 426.16 34.09 823.84 1,073.51 3,229.53 37.12 5,470.97 142.50 285.00 51.82 265.00 0.00 0.00 0.00 18,100.00 12,523.52 39,432.69 27.73 89,717.31 0.00 32.71 13.08 217.29 0.00 32.71 13.08 217.29 105.10 646.79 25.36 1,903.21 105.10 646.79 25.36 1,903.21 TOTAL Community Development Planning Personal Services 101-4-1510-4101 Regular Pay 101-4-1510-4104 PERA 101-4-1510-4105 FICA 101-4-1510-4107 Medicare 101-4-1510-4108 Insurance 101-4-1510-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1510-9201 Office Supplies i01-4-1510-9212 Fuels & Lubs TOTAL Supplies Other Services & Charges 101-4-1510-4319 Other Professional Services 101-4-1510-4321 Telephone 101-4-1510-4322 Postage 101-4-1510-4331 Travel, Conferences & Schools 101-4-1510-4359 Publishing 101-4-1510-4361 Insurance 101-4-1510-4409 Equip Repair/Maint Services 126,950.00 12,628.62 35,112.19 27.66 91,837.81 210,300.00 15,828.22 40,664.52 19.34 169,635.48 14,200.00 1,068.40 3,022.33 21.28 11,177.67 13,050.00 883.92 2,510.80 19.24 10,539.20 3,050.00 206.74 587.25 19.25 2,462.75 28,300.00 2,140.02 5,780.05 20.42 22,519.95 500.00 155.50 311.00 62.20 189.00 269,400.00 20,282.80 52,875.95 19.63 216,524.05 4,850.00 827.43 989.16 20.29 3,865.84 850.00 120.61 259.87 29.98 595.13 5,700.00 948.04 1,239.03 21.74 4,460.97 20,000.00 1,424.34 6,914.39 34.57 13,085.66 800.00 44.64 67.52 8.49 732.48 2,000.00 0.00 0.00 0.00 2,000.00 6,350.00 58.00 363.66 5.73 5,986.34 10,000.00 417.00 1,203.00 12.03 8,797.00 700.00 0.00 0.00 0.00 700.00 5,000.00 197.93 315.08 6.30 9,684.92 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 ' 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 101-4-1510-4433 Dues & Subscriptions 101-4-1510-9440 Miscellaneous TOTAL Other Services & Charges CURRENT BUDGET 1,000.00 250.00 46,100.00 25.00 OF YEAR COMP. CURRENT YEAR TO DATE o OF BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 0.00 0.00 1,000.00 0.00 46.00 16.40 204.00 2,141.91 8,909.60 19.33 37,190.40 TOTAL Planning City Hall Maintenance 321,200.00 23,372.75 63,024.58 19.62 258,175.42 Personal Services 101-4-1600-4101 Regular Pay 83,750.00 7,226.63 19,659.64 23.47 64,090.36 101-4-1600-4102 Overtime Pay 9,100.00 0.00 0.00 0.00 9,100.00 101-4-1600-4103 Part-time Pay 18,450.00 951.20 2,485.01 13.47 15,964.99 101-4-1600-4104 PERA 7,800.00 551.98 1,705.65 21.87 6,094.35 101-4-1600-4105 FICA 7,150.00 498.48 1,597.71 21.65 5,602.29 101-4-1600-4107 Medicare 1,700.00 116.57 361.96 21.29 1,338.04 101-4-1600-4108 Insurance 11,900.00 1,213.25 3,720.48 31.26 8,179.52 101-4-1600-4109 Workers Comp 2,550.00 1,068.75 2,137.50 83.82 412.50 TOTAL Personal Services 142,400.00 11,626.86 31,617.95 22.20 110,782.05 Supplies 101-4-1600-4212 Fuels & Lubs 3,750.00 217.09 459.81 12.26 3,290.19 i01-4-1600-9217 Uniform Allowance 1,700.00 0.00 282.85 16.64 1,417.15 101-4-1600-4219 Operating Supplies 30,000.00 317.22 6,820.75 22.74 23,179.25 TOTAL Supplies 35,950.00 534.31 7,563.41 21.34 27,886.59 Other Services & Charges 101-4-1600-4321 Telephone 15,450.00 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 101-4-1600-4361 Insurance 5,700.00 101-4-1600-4389 Utilities 51,800.00 101-4-1600-4401 Bldg Repair/Maint Services 32,300.00 101-4-1600-4404 Equip Repair/Maint Services 1,250.00 TOTAL Other Services & Charges 108,500.00 910.76 0.00 2,320.00 5,037.90 3,623.84 0.00 11,892.50 2,670.54 17.29 12,779.46 1,240.00 62.00 760.00 2,320.00 40.70 3,380.00 11,004.44 21.24 40,795.56 5,621.27 17.40 26,678.73 0.00 0.00 1,250.00 22,856.25 21.07 85,643.75 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4490 Miscellaneous TOTAL Other Services & Charges TOTAL Contingency 286,350.00 24,053.67 62,037.61 21.66 224,312.39 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 2,633,400.00 223,218.61 513,694.61 19.51 2,119,705.39 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration Personal Services 101-4-2110-4101 Regular Pay 101-9-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-9331 Travel, Conferences & Schools 101-4-2110-4359 Publishing 101-4-2110-4361 Insurance 101-4-2110-9404 Equip Repair/Maint Services 101-4-2110-9433 Dues & Subscriptions 101-4-2110-9437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-2110-4560 Equipment TOTAL Capital Outlay 279,400.00 21,182.44 55,074.35 19.71 224,325.65 39,400.00 2,986.74 8,921.78 22.69 30,478.22 0.00 0.00 1,116.38 0.00 ( 1,116.38) 2,550.00 201.70 864.96 33.92 1,685.04 23,250.00 1,938.01 5,814.03 25.01 17,435.97 48,500.00 12,970.25 25,940.50 53.49 22,559.50 393,100.00 39,279.14 97,732.00 24.86 295,368.00 16,000.00 467.58 1,732.24 10.83 14,267.76 2,500.00 479.38 967.20 38.69 1,532.80 3,150.00 157.55 120.09 3.81 3,029.91 21,650.00 1,104.51 2,819.53 13.02 18,830.47 5,500.00 232.37 232.37 4.22 5,267.63 25,000.00 1,835.57 4,481.73 17.93 20,518.27 2,100.00 40.13 42.06 2.00 2,057.94 4,200.00 250.00 723.69 17.23 3,476.31 500.00 0.00 0.00 0.00 500.00 12,450.00 4,576.50 4,576.50 36.76 7,873.50 69,250.00 ( 4,541.52) 29,439.19 42.51 39,810.81 5,850.00 1,308.00 2,173.00 37.15 3,677.00 500.00 0.00 45.00 9.00 455.00 125,350.00 3,701.05 41,713.54 33.28 83,636.46 57,600.00 0.00 57,599.00 100.00 57,600.00 0.00 57,599.00 100.00 1.00 1.00 TOTAL Police Administration Patrol 597,700.00 44,084.70 199,864.07 33.44 397,835.93 Personal Services 101-4-2120-4101 Regular Pay 1,435,250.00 101,094.98 267,432.06 18.63 1,167,817.99 101-4-2120-4102 Overtime Pay 90,000.00 2,541.59 5,346.79 5.94 84,653.21 101-4-2120-4104 PERA 215,050.00 14,612.71 43,865.25 20.40 171,184.75 101-4-2120-4107 Medicare 19,800.00 1,214.35 3,716.52 18.77 16,083.48 101-4-2120-4108 Insurance 150,400.00 12,978.07 38,934.21 25.89 111,465.79 TOTAL Personal Services 1,910,500.00 132,441.70 359,299.83 18.81 1,551,205.17 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.OOo OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 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-4404 Equip Repair/Maint Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges 95,000.00 7,702.89 15,680.58 16.51 79,319.42 17,200.00 85.00 417.88 2.43 16,782.12 49,000.00 1,431.30 4,345.91 8.87 49,654.09 25,000.00 1,127.28 2,872.78 11.49 22,127.22 186,200.00 10,346.47 23,317.15 12.52 162,882.85 14,650.00 2,100.00 27,200.00 954.78 550.00 190.00 43,700.00 0.00 86,100.00 2,744.78 2,114.89 14.44 12,535.11 1,658.09 6.10 25,541.91 190.00 34.55 360.00 0.00 0.00 43,700.00 3,962.98 4.60 82,137.02 TOTAL Patrol Investigations Personal Services 101-4-2130-4101 Regular Pay 101-4-2130-4102 Overtime Pay 101-4-2130-4104 PERA 101-4-2130-4107 Medicare 101-4-2130-4108 Insurance TOTAL Personal Services Supplies 101-4-2130-4217 Uniform Allowance 101-4-2130-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2130-9319 Other Professional Services 101-9-2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges 2,182,800.00 145,532.95 386,579.96 17.71 1,796,225.04 495,800.00 33,204.05 90,315.10 18.22 405,484.90 40,000.00 2,969.03 3,587.74 8.97 36,412.26 75,550.00 5,100.42 15,060.74 19.93 60,489.26 5,600.00 318.46 952.19 17.00 4,647.81 58,600.00 4,914.94 14,744.82 25.16 43,855.18 675,550.00 46,506.90 124,660.59 18.45 550,889.41 4,850.00 244.92 214.84 4.43 4,635.16 8,400.00 59.70 139.56 1.66 8,260.44 13,250.00 304.62 354.40 2.67 12,895.60 10,750.00 445.24 4,000.00 585.00 200.00 50.00 10,400.00 0.00 25,350.00 1,080.24 962.49 8.95 9,787.51 585.00 14.63 3,415.00 50.00 25.00 150.00 0.00 0.00 10,400.00 1,.597.49 6.30 23,752.51 TOTAL Investigations 714,150.00 47,891.76 126,612.48 17.73 587,537.52 Police Support Services 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00°s OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Personal Services 101-4-2150-4101 Regular Pay 346,900.00 26,120.81 67,957.56 19.59 278,942.44 101-4-2150-4102 Overtime Pay 6,500.00 0.00 0.00 0.00 6,500.00 101-9-2150-9104 PERA 23,850.00 1,763.16 5,246.14 22.00 18,603.86 101-4-2150-4105 FICA 21,900.00 1,577.30 4,721.85 21.56 17,178.15 101-4-2150-4107 Medicare 5,100.00 368.88 1,104.28 21.65 3,995.72 101-4-2150-9108 Insurance 42,050.00 3,509.02 10,512.06 25.00 31,537.94 TOTAL Person al Services 446,300.00 33,334.17 89,541.89 20.06 356,758.11 Supplies 101-9-2150-4201 Office Supplies 1,000.00 67.07 114.45 11.45 885.55 101-9-2150-4217 Uniform Allowance 3,250.00 36.56 36.56 1.12 3,213.44 101-4-2150-4219 Operating Supplies 8,050.00 520.35 3,251.87 40.40 4,798.13 TOTAL Suppli es 12,300.00 623.98 3,402.88 27.67 8,897.12 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,550.00 0.00 0.00 0.00 3,550.00 101-4-2150-4404 Equip Repair/Maint Services 5,500.00 0.00 3,675.00 66.82 1,825.00 101-4-2150-4409 Contractual Services 16,000.00 365.29 1,103.46 6.90 14,896.54 101-4-2150-4433 Dues & Subscriptions 500.00 0.00 222.50 44.50 277.50 101-4-2150-4460 Equip Replacement Charge 7,900.00 0.00 0.00 0.00 7,900.00 TOTAL Other Services & Charges 33,450.00 365.29 5,000.96 14.95 28,449.04 TOTAL Police S upport Services 492,050.00 34,323.44 97,945.73 19.91 394,104.27 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-9-2160-4321 Telephone 101-9-2160-4331 Travel, Conferences & Schools i01-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 loo.oo 5,950.00 0.00 0.00 0.00 5,950.00 5,000.00 0.00 6,000.00 0.00 11,000.00 0.00 1,500.00 0.00 1,600.00 12.27 1,700.00 0.00 0.00 0.00 1,000.00 0.00 5,800.00 12.27 255.00 5.10 4,745.00 0.00 0.00 6,000.00 255.00 2.32 10,745.00 0.00 0.00 1,500.00 314.59 19.66 1,285.41 0.00 0.00 1,700.00 112.20 0.00 ( 112.20) 0.00 0.00 1,000.00 926.79 7.36 5,373.21 TOTAL Police Reserves 22,750.00 12.27 681.79 3.00 22,068.21 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) - AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Public safety building Personal Services 101-4-2190-4101 Regular Pay 101-4-2190-4102 Overtime Pay 101-4-2190-4104 PERA 101-4-2190-4105 FICA 101-4-2190-4107 Medicare 101-9-2190-4108 Insurance 101-4-2190-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2190-4219 Operating Supplies TOTAL Supplies Other Services & Charges i01-4-2190-4361 Insurance 101-4-2190-4389 Utilities 101-4-2190-4401 Bldg Repair/Maint Services TOTAL Other Services & Charges TOTAL Public safety building ~ Fire Administration Personal Services 101-4-2310-9101 Regular Pay i01-4-2310-4103 Part-time Pay 101-4-2310-4104 PERA 101-4-2310-4105 FICA 101-4-2310-4106 Other Retirement Contributions 101-4-2310-4107 Medicare 101-4-2310-4108 Insurance 101-4-2310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2310-4201 Office Supplies 101-4-2310-4212 Fuels & Lubs 101-4-2310-4217 Uniform Allowance 101-4-2310-4219 Operating Supplies TOTAL Supplies 98,200.00 7,044.64 17,254.24 17.57 80,945.76 450.00 0.00 0.00 0.00 450.00 6,650.00 475.51 1,319.61 19.84 5,330.39 6,100.00 419.00 1,189.22 19.50 4,910.78 1,450.00 98.01 278.16 19.18 1,171.84 14,250.00 1,055.96 2,871.37 20.15 11,378.63 2,200.00 947.75 1,895.50 86.16 304.50 129,300.00 10,090.87 24,808.10 19.19 104,491.90 17,000.00 1,290.73 5,867.29 34.51 11,132.71 17,000.00 1,290.73 5,867.29 34.51 11,132.71 6,900.00 3,006.50 3,006.50 43.57 3,893.50 18,200.00 1,455.83 1,876.41 10.31 16,323.59 31,300.00 332.94 1,873.53 5.99 29,426.47 56,400.00 4,795.27 6,756.44 11.98 49,643.56 202,700.00 16,126.87 37,431.83 18.47 165,268.17 90,850.00 7,490.63 19,570.16 21.54 71,279.84 150,350.00 7,259.20 26,895.46 17.89 123,454.59 13,250.00 1,078.54 3,192.15 24.09 10,057.85 10,050.00 479.50 2,061.16 20.51 7,988.84 30,000.00 ( 2,000.00)( 2,000.00) 6.67- 32,000.00 3,500.00 194.11 727.45 20.76 2,772.55 9,150.00 850.38 2,522.11 27.56 6,627.89 15,350.00 3,929.00 7,858.00 51.19 7,492.00 322,500.00 19,281.36 60,826.49 18.86 261,673.51 1,200.00 70.42 199.24 16.60 1,000.76 7,950.00 353.45 730.86 9.19 7,219.14 1,100.00 a.oo o.oo o.o0 1,100.00 32,400.00 2,313.55 8,414.30 25.97 23,985.70 42,650.00 2,737.42 9,394.40 21.91 33,305.60 4-16-2009 12:21 PM 101-GENERAL FUND Public Safety ~ DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2310-4319 Other Professional Services 101-4-2310-4321 Telephone 101-4-2310-4322 Postage 101-4-2310-4331 Travel, Conferences & Schools 101-4-2310-4359 Publishing 101-4-2310-9361 Insurance 101-4-2310-4389 Utilities 101-4-2310-4401 Bldg Repair/Maint Services 101-4-2310-4409 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 i01-4-2320-9101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-4109 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-9-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-9359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Fire Inspections CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 4,950.00 97.50 2,400.00 48.48 2,550.00 2,700.00 237.60 672.96 24.92 2,027.04 500.00 0.00 0.00 0.00 500.00 19,850.00 0.00 787.77 3.97 19,062.23 500.00 0.00 0.00 0.00 500.00 21,300.00 8,728.00 8,728.00 40.98 12,572.00 15,150.00 2,703.04 5,324.66 35.15 9,825.34 4,000.00 0.00 159.75 3.99 3,840.25 20,850.00 1,555.40 1,649.07 7.91 19,200.93 2,000.00 0.00 1,152.50 57.63 847.50 15,250.00 0.00 0.00 0.00 15,250.00 107,050.00 13,321.54 20,874.71 19.50 86,175.29 472,200.00 35,340.32 91,045.60 19.28 381,154.90 132,250.00 10,024.76 26,064.37 19.71 106,185.63 2,000.00 0.00 0.00 0.00 2,000.00 14,700.00 1,115.62 3,299.87 22.45 11,400.13 7,600.00 252.61 792.51 10.43 6,807.49 1,900.00 137.98 421.55 22.19 1,478.95 13,700.00 1,142.00 3,426.00 25.01 10,274.00 172,150.00 12,672.97 34,004.30 19.75 138,195.70 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 217.09 459.81 15.33 2,540.19 800.00 0.00 0.00 0.00 800.00 4,150.00 0.00 133.40 3.21 4,016.60 9,900.00 217.09 593.21 5.99 9,306.79 1,350.00 116.18 266.89 19.77 1,083.11 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 143.35 7.75 1,706.65 500.00 0.00 70.00 14.00 430.00 6,800.00 116.18 980.24 7.06 6,319.76 188,850.00 13,006.24 35,077.75 18.57 153,772.25 9-16-2009 12:21 PM REVENUE 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 5.OOo ~ OF BUDGET PAGE: 16 F YEAR COMP. BUDGET BALANCE Emergency Management Personal Services 101-4-2330-4101 Regular Pay 9,950.00 752.72 1,957.07 19.67 7,992.93 101-4-2330-4104 PERA 1,400.00 106.12 313.27 22.38 1,086.73 101-4-2330-4107 Medicare 150.00 10.26 30.71 20.47 119.29 101-4-2330-4108 Insurance 800.00 64.01 192.03 24.00 607.97 TOTAL Personal Services 12,300.00 933.11 2,493.08 20.27 9,806.92 Supplies 101-4-2330-4201 Office Supplies 2,500.00 0.00 0.00 0.00 2,500.00 101-4-2330-4219 Operating Supplies 8,500.00 0.00 399.57 4.70 8,100.43 TOTAL Supplies 11,000.00 0.00 399.57 3.63 10,600.43 Other Services & Charges 101-4-2330-4321 Telephone 1,500.00 112.57 305.45 20.36 1,194.55 101-4-2330-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-2330-4331 Travel, Conferences & Schools 1,850.00 225.00 255.60 13.82 1,594.40 101-4-2330-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-9-2330-4389 Utilities 1,500.00 117.62 243.13 16.21 1,256.87 101-4-2330-9404 Equip Repair/Maint Services 5,100.00 72.53 180.83 3.55 9,919.17 101-9-2330-4433 Dues & Subscriptions 400.00 0.00 200.00 50.00 200.00 TOTAL Other Services & Charges 10,950.00 527.72 1,185.01 10.82 9,764.99 Capital Outlay 101-4-2330-4560 Equipment 14,900.00 0.00 0.00 0.00 19,900.00 TOTAL Capital Outlay 14,900.00 0.00 0.00 0.00 19,900.00 TOTAL Emergency Management 49,150.00 1,460.83 9,077.66 8.30 45,072.34 Building Safety Personal Services 101-4-2410-4101 Regular Pay 375,300.00 58,549.06 111,968.98 29.83 263,331.02 101-4-2410-4102 Overtime Pay 500.00 0.00 0.00 0.00 500.00 101-4-2410-4103 Part-time Pay 23,450.00 1,832.80 4,866.40 20.75 18,583.60 101-4-2410-4104 PERA 26,950.00 1,823.73 6,630.70 24.60 20,319.30 101-4-2410-4105 FICA 29,750.00 3,563.68 7,608.28 30.74 17,141.72 101-4-2410-4107 Medicare 5,800.00 833.93 1,779.31 30.68 4,020.69 101-4-2410-4108 Insurance 41,600.D0 4,326.26 13,630.29 32.77 27,969.71 101-4-2410-9109 Workers Comp 1,900.00 329.25 658.50 47.04 741.50 101-9-2410-4110 Re-employment Compensation 29,350.00 0.00 0.00 0.00 29,350.00 TOTAL Personal Services 529,100.00 71,258.21 147,142.96 27.81 381,957.54 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2910-4201 Office Supplies 101-4-2910-4212 Fuels & Lubs 101-4-2410-4217 Uniform Allowance 101-4-2410-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2410-9321 Telephone 101-4-2410-4322 Postage 101-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-9-2410-4433 Dues & Subscriptions 101-4-2410-4440 Miscellaneous 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges 3,000.00 64.76 5,950.00 325.63 700.00 0.00 2,650.00 41.71 12,300.00 432.10 162.86 5.43 2,837.14 706.53 11.87 5,243.47 0.00 0.00 700.00 603.79 22.78 2,046.21 1,473.18 11.98 10,826.82 4,400.00 321.98 1,500.00 0.00 9,400.00 307.90 16,500.00 14,513.50 9,400.00 579.53 1,200.00 90.00 2,500.00 0.00 2,300.00 0.00 47,200.00 15,812.41 676.71 15.38 3,723.29 0.00 0.00 1,500.00 2,110.75 22.45 7,289.25 14,513.50 87.96 1,986.50 2,898.93 30.84 6,501.07 375.00 31.25 825.00 0.00 0.00 2,500.00 0.00 0.00 2,300.00 20,574.89 43.59 26,625.11 TOTAL Building Safety Environmental Personal Services 101-4-2940-4101 Regular Pay 101-4-2940-4104 PERA 101-4-2440-4105 FICA 101-4-2440-4107 Medicare 101-4-2440-4108 Insurance 101-4-2440-4109 Workers Comp TOTAL Personal Services Supplies 101-4-2940-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs 101-4-2440-4217 Uniform Allowance 101-9-2440-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2440-4321 Telephone 101-4-2440-4322 Postage 101-4-2440-4331 Travel, Conferences & Schools i01-4-2940-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4404 Equip Repair/Maint Services 101-4-2440-9409 Contractual Services 101-4-2490-4433 Dues & Subscriptions 588,600.00 87,502.72 169,190.53 28.74 419,409.47 52,200.00 4,113.09 10,533.14 20.18 41,666.86 3,500.00 277.63 828.28 23.67 2,671.72 3,200.00 188.04 561.86 17.56 2,638.14 750.00 43.98 131.40 17.52 618.60 8,450.00 669.60 2,060.00 24.38 6,390.00 350.00 98.00 196.00 56.00 154.00 68,450.00 5,390.34 14,310.68 20.91 54,139.32 650.00 0.00 19.62 3.02 630.38 200.00 0.00 4.55 2.28 195.45 200.00 0.00 0.00 0.00 200.00 0.00 0.00 9.07 0.00 ( 9.07) 1,050.00 0.00 33.24 3.17 1,016.76 700.00 53.77 99.53 14.22 600.47 500.00 0.00 0.00 0.00 500.00 500.00 0.00 85.00 17.00 415.00 500.00 0.00 0.00 0.00 500.00 300.00 112.00 112.00 37.33 188.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 I 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Safety 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-9-2440-4460 Equip Replacement Charge 750.00 0.00 0.00 0.00 750.00 TOTAL Other Services & Charges 5,850.00 165.77 296.53 5.07 5,553.47 TOTAL Environmental 75,350.00 5,556.11 14,640.45 19.43 60,709.55 TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare i01-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services Supplies i01-4-3120-4201 Office Supplies 101-4-3120-4212 Fuels & Lubs 101-9-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-9321 Telephone 101-4-3120-4322 Postage 101-4-3120-4331 Travel, Conferences & Schools 101-4-3120-4359 Publishing 101-4-3120-9361 Insurance 101-4-3120-4389 Utilities 101-9-3120-4401 Bldg Repair/Maint Services 101-4-3120-4409 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-4460 Equip Replacement Charge TOTAL Other Services & Charges 5,586,300.00 430,838.21 1,163,142.85 20.82 4,423,157.15 391,850.00 27,589.74 71,839.17 18.33 320,010.83 10,400.00 0.00 0.00 0.00 10,400.00 78,950.00 3,449.91 9,231.37 11.69 69,718.63 31,050.00 2,094.83 5,985.61 19.28 25,064.39 28,750.00 1,774.79 5,177.38 18.01 23,572.62 6,700.00 915.07 1,210.79 18.07 5,989.21 50,400.00 4,163.59 12,317.43 24.94 38,082.57 20,000.00 4,922.75 9,845.50 49.23 10,154.50 618,100.00 44,405.63 115,607.25 18.70 502,492.75 4,800.00 70.61 157.17 3.27 4,642.83 82,950.00 8,978.64 7,238.05 8.73 75,711.95 160,000.00 1,242.09 5,639.80 3.52 159,360.20 17,500.00 9,814.64 4,814.64 27.51 12,685.36 265,250.00 15,105.98 17,849.66 6.73 247,400.34 950.00 0.00 113.00 11.89 837.00 9,450.00 423.56 950.03 10.05 8,499.97 200.00 0.00 0.00 0.00 200.00 3,000.00 550.00 550.00 18.33 2,450.00 500.00 0.00 0.00 0.00 500.00 18,250.00 7,963.50 7,963.50 43.64 10,286.50 33,000.00 4,296.39 8,563.39 25.95 24,936.66 6,500.00 424.94 424.94 6.54 6,075.06 0.00 0.00 1,399.24 0.00 ( 1,394.24) 199,000.00 0.00 0.00 0.00 199,000.00 3,500.00 95.85 191.70 5.48 3,308.30 4,850.00 439.97 669.29 13.70 4,185.71 700.00 0.00 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 410,600.00 14;194.21 21,056.29 5.13 389,543.71 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 I 101-GENERAL FUND Public Works I DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay 101-4-3120-4560 Equipment TOTAL Capital Outlay 6,700.00 0.00 0.00 0.00 6,700.00 6,700.00 0.00 0.00 0.00 6,700.00 I TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-9103 Part-time Pay 101-9-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-9107 Medicare 101-4-3130-4108 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Capital Outlay 101-4-3130-9560 Equipment TOTAL Capital Outlay 1,300,650.00 73,705.82 154,513.20 11.88 1,146,136.80 159,150.00 16,391.41 42,208.50 26.52 116,941.50 12,450.00 0.00 401.74 3.23 12,048.26 0.00 829.56 829.56 0.00 ( 829.56) 11,800.00 1,162.42 9,298.07 36.42 7,501.93 10,950.00 975.54 3,745.93 34.21 7,204.07 2,550.00 228.16 876.08 34.36 1,673.92 21,300.00 2,509.44 7,943.37 37.29 13,356.63 6,550.00 1,723.50 3,447.00 52.63 3,103.00 224,750.00 23,820.03 63,750.25 28.36 160,999.75 79,000.00 20,561.76 55,587.60 70.36 23,412.40 79,000.00 20,561.76 55,587.60 70.36 23,912.40 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-4-3150-4105 FICA 101-4-3150-4107 Medicare 101-4-3150-4108 Insurance 101-9-3150-4109 Workers Comp TOTAL Personal Services 308,750.00 44,381.79 119,337.85 38.65 189,412.15 165,200.00 11,178.90 29,951.66 18.13 135,248.34 2,500.00 0.00 0.00 0.00 2,500.00 11,300.00 754.57 2,250.19 19.91 9,099.81 10,400.00 608.15 1,828.75 17.58 8,571.25 2,450.00 142.24 427.70 17.46 2,022.30 23,000.00 1,704.03 4,827.67 20.99 18,172.33 5,250.00 1,422.00 2,844.00 54.17 2,406.00 220,100.00 15,809.89 42,129.97 19.14 177,970.03 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES 25.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3150-4219 Operating Supplies 101-4-3150-4221 Equipment Parts TOTAL Supplies Other Services & Charges 101-4-3150-4404 Equip Repair/Maint Services 101-4-3150-4417 Uniform Rental TOTAL Other Services & Charges 16,350.00 852.21 2,271.23 13.89 14,078.77 9,200.00 0.00 0.00 0.00 9,200.00 25,550.00 852.21 2,271.23 8.89 23,278.77 2,000.00 0.00 2,800.00 289.16 4,800.00 284.16 TOTAL Equipment Services Engineering Personal Services 101-4-3300-4101 Regular Pay 101-4-3300-4104 PERA TO1-9-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-9-3300-4361 Insurance 101-4-3300-4404 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges I TOTAL Engineering 250,450.00 16,946.26 44,907.88 17.93 205,542.12 49,500.00 0.00 3,350.00 0.00 3,050.00 0.00 700.00 0.00 7,700.00 0.00 100.00 42.25 64,400.00 42.25 850.00 350.00 9,850.00 11,050.00 0.00 0.00 2,000.00 506.68 18.10 2,293.32 506.68 10.56 4,293.32 0.00 0.00 49,500.00 0.00 0.00 3,350.00 0.00 0.00 3,050.00 0.00 0.00 700.00 0.00 0.00 7,700.00 84.50 84.50 15.50 84.50 0.13 64,315.50 0.00 32.71 3.85 817.29 24.12 48.39 13.83 301.61 0.00 1,750.00 17.77 8,100.00 24.12 1,831.10 16.57 9,218.90 88,000.00 6,052.13 20,000.00 0.00 750.00 2.65 200.00 0.00 5,200.00 0.00 300.00 112.00 500.00 0.00 750.00 0.00 115,700.00 6,166.78 13,175.10 14.97 74,824.90 0.00 0.00 20,000.00 2.65 0.35 797.35 0.00 0.00 200.00 40.00 0.77 5,160.00 112.00 37.33 188.00 0.00 0.00 500.00 0.00 0.00 750.00 13,329.75 11.52 102,370.25 191,150.00 6,233.15 15,245.35 7.98 175,904.65 I TOTAL Public Works 2,051,000.00 141,267.02 334,009.28 16.28 1,716,995.72 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 25.00 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Parks Department Personal Services 101-9-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-9107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp i TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance i01-4-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-9-5110-4321 Telephone 101-9-5110-4331 Travel, Conferences & Schools 101-4-5110-4361 Insurance 101-4-5110-4389 Utilities 101-4-5110-4401 Bldg Repair/Maint Services 101-4-5110-4404 Equip Repair/Maint Services 101-4-5110-4909 Contractual Services 101-4-5110-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-4102 Overtime Pay 101-4-5210-4103 Part-time Pay 101-4-5210-4104 PERA 101-4-5210-9105 FICA 101-4-5210-4107 Medicare 101-4-5210-4108 Insurance 101-4-5210-4109 Workers Comp TOTAL Personal Services 338,150.00 22,978.15 61,941.11 18.32 276,208.89 1,000.00 0.00 0.00 0.00 1,000.00 43,350.00 0.00 0.00 0.00 43,350.00 23,850.00 1,551.03 4,823.67 20.23 19,026.33 24,150.00 1,262.06 3,937.33 16.30 20,212.67 5,650.00 295.16 920.83 16.30 4,729.17 51,200.00 3,052.01 9,788.50 19.12 41,411.50 6,500.00 1,926.00 3,852.00 59.26 2,648.00 493,850.00 31,064.41 85,263.44 17.27 408,586.56 31,350.00 1,916.77 3,077.26 9.82 28,272.74 3,200.00 966.37 674.79 21.09 2,525.21 68,550.00 3,558.38 11,618.02 16.95 56,931.98 103,100.00 5,941.52 15,370.07 14.91 87,729.93 3,900.00 350.13 766.36 19.65 3,133.64 2,550.00 235.00 410.00 16.08 2,140.00 27,000.00 11,810.00 11,810.00 43.74 15,190.00 15,050.00 2,842.37 3,096.88 20.58 11,953.12 5,500.00 0.00 0.00 0.00 5,500.00 13,500.00 161.56 161.56 1.20 13,338.44 6,100.00 0.00 0.00 0.00 6,100.00 24,500.00 528.60 1,372.14 5.60 23,127.86 38,100.00 0.00 0.00 0.00 38,100.00 136,200.00 15,927.66 17,616.94 12.93 118,583.06 733,150.00 52,933.59 118,250.45 16.13 614,899.55 335,550.00 24,743.84 64,936.18 700.00 0.00 0.00 21,150.00 1,799.48 6,148.46 24,150.00 1,791.67 5,420.71 22,200.00 1,528.90 4,675.85 5,200.00 357.42 1,093.50 39,850.00 3,221.97 10,100.47 4,950.00 792.75 1,585.50 453,750.00 34,235.53 93,960.67 19.20 271,113.82 0.00 700.00 29.07 15,001.54 22.95 18,729.29 21.06 17,524.15 21.03 4,106.50 25.35 29,749.53 32.03 3,364.50 20.60 360,289.33 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5210-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5210-4321 Telephone 101-4-5210-4322 Postage 101-4-5210-4331 Travel, Conferences & Schools 101-4-5210-4349 Advertising/Marketing 101-4-5210-4361 Insurance 101-4-5210-4389 Utilities 101-4-5210-9401 Bldg Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges 12,900.00 142.93 3,500.31 27.13 9,399.69 12,900.00 142.93 3,500.31 27.13 9,399.69 4,100.00 318.04 811.14 19.78 3,288.86 6,000.00 0.00 712.92 11.88 5,287.08 5,650.00 578.41 1,030.41 18.24 4,619.59 26,400.00 0.00 3,971.07 15.04 22,428.93 1,500.00 714.00 714.00 47.60 786.00 7,800.00 2,065.03 9,149.90 53.20 3,650.10 19,950.00 1,351.59 3,215.95 21.51 11,734.05 6,750.00 349.29 1,543.92 22.87 5,206.08 1,650.00 1,260.00 1,260.00 76.36 390.00 74,800.00 6,631.36 17,409.31 23.27 57,390.69 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-4-5220-4219 Operating Supplies TOTAL Supplies Other Services & Charges i01-4-5220-9404 Equip Repair/Maint Services 101-4-5220-4409 Contractual Services 101-4-5220-4412 Building Rent 101-4-5220-4438 Credit Card Fees TOTAL Other Services & Charges 541,450.00 41,009.82 114,370.29 21.12 427,079.71 0.00 939.43 1,618.61 0.00 ( 1,618.61) 80,000.00 4,879.26 17,332.00 21.67 62,668.00 1,600.00 137.67 479.42 29.96 1,120.58 4,500.00 329.20 1,309.38 29.10 3,190.62 1,300.00 76.99 306.27 23.56 993.73 0.00 52.01 290.00 0.00 ( 290.00) 87,900.00 5,914.56 21,335.68 24.41 66,064.32 24,000.00 1,748.00 1,754.94 7.31 22,245.06 24,000.00 1,748.00 1,754.94 7.31 22,245.06 400.00 0.00 0.00 0.00 400.00 47,000.00 2,547.20 6,024.86 12.82 40,975.14 2,500.00 0.00 0.00 0.00 2,500.00 3,000.00 582.32 609.16 20.31 2,390.84 52,900.00 3,129.52 6,634.02 12.54 46,265.98 TOTAL Recreation Programs 169,300.00 10,792.08 29,724.64 18.09 139,575.36 9-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES Concessions Personal Services 101-4-5230-4103 Part-time Pay 4,750.00 33.54 i01-4-5230-4104 PERA 250.00 2.26 101-4-5230-4105 FICA 300.00 2.08 101-4-5230-4107 Medicare 100.00 0.99 TOTAL Personal Services 5,400.00 38.37 Supplies i01-4-5230-4219 Operating Supplies 600.00 0.00 101-4-5230-4259 Other Merchandise For Resale 13,400.00 0.00 TOTAL Supplies 14,000.00 0.00 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00 TOTAL Other Services & Charges 100.00 0.00 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 33.54 0.71 4,716.46 2.26 0.90 297.74 2.08 0.69 297.92 0.49 0.49 99.51 38.37 0.71 5,361.63 0.00 0.00 600.00 443.70 3.31 12,956.30 943.70 3.17 13,556.30 0.00 0.00 100.00 0.00 0.00 100.00 TOTAL Concessions Sr Citizen Programs ------------------- ------------------ 19,500.00 38.37 482.07 2.47 19,017.93 Personal Services 101-4-5510-4101 Regular Pay 59,950.00 4,083.20 10,616.33 19.32 94,333.67 101-4-5510-4102 Overtime Pay 500.00 0.00 0.00 0.00 500.00 101-4-5510-4103 Part-time Pay 58,700.00 4,459.35 11,533.58 19.65 47,166.42 101-4-5510-4104 PERA 7,700.00 582.12 1,709.82 22.21 5,990.18 101-4-5510-4105 FICA 7,100.00 996.17 1,964.44 20.63 5,635.56 101-4-5510-4107 Medicare 1,650.00 116.05 342.51 20.76 1,307.49 101-4-5510-4108 Insurance 12,400.00 1,034.22 3,102.66 25.02 9,297.34 101-4-5510-9109 Workers Comp 700.00 93.00 186.00 26.57 514.00 TOTAL Personal Services 143,700.00 10,864.11 28,955.34 20.15 114,744.66 Supplies '_O1-4-5510-4219 Operating Supplies 10,950.00 692.95 2,475.86 22.61 8,474.14 TOTAL Supplies 10,950.00 692.95 2,475.86 22.61 8,979.14 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 206.37 618.31 25.76 1,781.69 101-9-5510-4322 Postage 4,000.00 15.96 615.96 15.90 3,384.04 101-4-5510-4331 Travel, Conferences & Schools 2,400.00 286.27 286.27 11.93 2,113.73 101-4-5510-4361 Insurance 900.00 775.50 775.50 86.17 124.50 101-4-5510-4389 Utilities 8,150.00 1,177.90 2,498.69 30.66 5,651.31 101-4-5510-4401 Bldg Repair/Maint Services 11,800.00 1,973.69 2,653.17 22.48 9,146.83 101-4-5510-4409 Contractual Services 8,100.00 ( 50.00)( 463.34) 5.72- 8,563.34 101-4-5510-4433 Dues ~ Subscriptions 950.00 19.97 62.47 6.58 887.53 TOTAL Other Services & Charges 38,700.00 3,905.61 7,047.03 18.21 31,652.97 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND Culture & Recreation 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Sr Citizen Programs 193,350.00 15,462.67 38,478.23 19.90 154,871.77 TOTAL Culture & Recreation 1,651,750.00 120,236.53 301,305.68 18.24 1,350,494.32 Economic Developement Personal Services 101-4-6210-4101 Regular Pay 101-4-6210-4103 Part-time Pay 101-4-6210-4104 PERA 101-4-6210-4105 FICA 101-4-6210-4107 Medicare 101-4-6210-4108 Insurance 101-4-6210-4109 Workers Comp TOTAL Personal Services Other Services & Charges 101-4-6210-4331 Travel, Conferences & Schools 101-4-6210-4361 Insurance 101-4-6210-4940 Miscellaneous TOTAL Other Services & Charges 0.00 10,087.32 30,202.63 0.00 ( 30,202.63) 0.00 1,050.32 3,150.96 0.00 ( 3,150.96) 0.00 703.42 2,093.79 0.00 ( 2,093.79) 0.00 617.99 1,850.30 0.00 ( 1,850.30) 0.00 144.54 432.76 0.00 ( 432.76) 0.00 1,298.00 3,899.00 0.00 ( 3,899.00) 0.00 144.50 144.50 0.00 ( 144.50) 0.00 14,046.09 41,768.94 0.00 ( 41,768.94) 0.00 ( 6.83) 99.00 0.00 ( 99.00) 0.00 689.25 689.25 0.00 ( 689.25) 0.00 689.25 724.51 0.00 ( 724.51) 0.00 1,371.67 1,512.76 0.00 ( 1,512.76) TOTAL Economic Developement Energy City 0.00 15,417.76 43,281.70 0.00 ( 43,281.70) Personal Services 101-4-6220-4101 Regular Pay 27,250.00 2,202.38 5,550.92 20.37 21,699.08 101-4-6220-4104 PERA 1,550.00 148.67 423.00 27.29 1,127.00 101-4-6220-4105 FICA 1,500.00 105.09 297.70 19.85 1,202.30 101-4-6220-4107 Medicare 900.00 24.57 69.61 17.40 330.39 101-4-6220-4108 Insurance 3,600.00 300.01 874.42 24.29 2,725.58 TOTAL Person al Services 34,300.00 2,780.72 7,215.65 21.04 27,064.35 Other Services & Charges 101-4-6220-4319 Other Professional Services 2,000.00 0.00 0.00 0.00 2,000.00 101-4-6220-9331 Travel, Conferences & Schools 17,000.00 ( 2,375.00)( 10,035.00) 59.03- 27,035.00 101-4-6220-9359 Publishing 2,500.00 1,804.99 1,851.44 74.06 648.56 TOTAL Other Services & Charges 21,500.00 ( 570.01)( 8,183.56) 38.06- 29,683.56 TOTAL Energy City 55,800.00 2,210.71 ( 967.91) 1.73- 56,767.91 TOTAL Economic Development 55,800.00 17,628.47 42,313.79 75.83 13,486.21 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 101-GENERAL FUND General 25.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Transfers Out Transfers Out 101-4-7000-4723 Transfer-Ice Arena 100,400.00 0.00 0.00 0.00 100,400.00 101-4-7000-4724 Transfer - Pinewood 62,300.00 0.00 0.00 0.00 62,300.00 101-4-7000-4730 Transfer-Debt Service 66,600.00 66,600.00 66,600.00 100.00 0.00 TOTAL Transfers Out 229,300.00 66,600.00 66,600.00 29.04 162,700.00 TOTAL Transfers Out 229,300.00 66,600.00 66,600.00 29.04 162,700.00 TOTAL General 229,300.00 66,600.00 66,600.00 29.04 162,700.00 TOTAL EXPENDITURES 12,207,550.00 999,788.84 2,421,061.21 19.83 9,786,488.79 REVENUES OVER/(UNDER) EXPENDITURES 428,550.00 ( 850,413.52)( 2,079,071.56) 2,507,621.56 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 221-ICE ARENA FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD 25.OOs OF YEAR COMP. YEAR TO DATE o 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 735,000.00 51,057.60 181,155.59 24.65 553,844.41 70,000.00 9,570.00 44,130.00 63.04 25,870.00 84,700.00 2,199.00 25,575.00 30.19 59,125.00 73,000.00 4,650.15 28,747.16 39.38 44,252.84 962,700.00 67,426.75 279,607.75 29.04 683,092.25 847,900.00 49,757.66 116,074.61 13.69 731,825.39 30,150.00 1,234.35 1,489.10 4.94 28,660.90 34,450.00 3,200.14 5,714.71 16.59 28,735.29 50,200.00 7,832.44 16,233.82 32.34 33,966.18 962,700.00 62,024.59 139,512.24 14.49 823,187.76 962,700.00 62,024.59 139,512.24 14.99 823,187.76 0.00 5,402.16 140,095.51 ( 140,095.51) 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 221-ICE ARENA REVENUES 25.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3964 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 TOTAL Ice Arena Hockey Charges for Services 221-3-5410-3461 Recreation Fees TOTAL Charges for Services 432,000.00 52,939.22 154,072.28 35.66 277,927.72 33,000.00 ( 5,954.00) 12,399.00 37.56 20,606.00 15,000.00 2,472.00 3,234.00 21.56 11,766.00 4,500.00 400.00 2,144.00 47.64 2,356.00 2,600.00 0.00 0.00 0.00 2,600.00 18,500.00 0.00 790.00 4.27 17,710.00 505,600.00 49,857.22 172,639.28 34.14 332,965.72 22,000.00 1,038.34 4,279.18 19.45 17,720.82 0.00 0.00 3,443.00 0.00 ( 3,443.00) 2,000.00 162.09 799.13 39.96 1,200.87 24,000.00 1,200.38 8,521.31 35.51 15,478.69 100,000.00 0.00 0.00 0.00 100,000.00 105,900.00 0.00 0.00 0.00 105,400.00 205,400.00 0.00 0.00 0.00 205,400.00 735,000.00 51,057.60 181,155.59 24.65 553,844.41 70,000.00 9,570.00 44,130.00 63.04 25,870.00 70,000.00 9,570.00 44,130.00 63.04 25,870.00 TOTAL Hockey 70,000.00 9,570.00 94,130.00 63.04 25,870.00 Skating Charges for Services 221-3-5420-3461 Recreation Fees 84,700.00 2,149.00 25,575.00 30.19 59,125.00 TOTAL Charges for Services 84,700.00 2,149.00 25,575.00 30.19 59,125.00 TOTAL Skating 84,700.00 2,149.00 25,575.00 30.19 59,125.00 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 221-ICE ARENA REVENUES 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Concessions Charges for Services 221-3-5430-3467 Concessions TOTAL Charges for Services TOTAL Concessions 73,000.00 4,650.15 28,747.16 39.38 44,252.84 73,000.00 4,650.15 28,797.16 39.38 94,252.84 73,000.00 4,650.15 28,747.16 39.38 49,252.84 TOTAL REVENUE 962,700.00 67,426.75 279,607.75 29.04 683,092.25 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 i 221-ICE ARENA DEPARTMENTAL EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE I ice Arena Personal Services 221-4-5400-4101 Regular Pay 150,300.00 13,129.37 35,797.00 23.82 114,503.00 221-4-5400-4103 Part-time Pay 72,850.00 6,074.29 17,795.98 24.43 55,054.02 221-4-5400-4104 PERA 11,350.00 1,207.19 3,690.67 32.52 7,659.33 221-9-5400-4105 FICA 14,150.00 1,170.25 3,747.43 26.48 10,402.57 221-4-5400-4107 Medicare 3,300.00 273.71 876.45 26.56 2,423.55 221-4-5400-4108 Insurance 16,600.00 1,562.57 4,886.95 29.94 11,713.05 221-9-5400-4109 Workers Comp 4,350.00 1,116.50 2,233.00 51.33 2,117.00 TOTAL Personal Services 272,900.00 24,533.88 69,027.48 25.29 203,872.52 Supplies 221-4-5400-4212 Fuels & Lubs 300.00 0.00 ( 208.47) 69.49- 508.47 221-4-5400-4217 Uniform Allowance 1,500.00 0.00 87.50 5.83 1,412.50 221-4-5400-9219 Operating Supplies 41,100.00 936.85 3,664.83 8.92 37,435.17 221-4-5400-4255 Soft Drinks/Misc 13,500.00 1,040.18 1,040.18 7.71 12,959.82 221-4-5400-4259 Other Merchandise For Resale 1,200.00 0.00 221.85 18.49 978.15 TOTAL Supplies 57,600.00 1,977.03 4,805.89 8.34 52,794.11 Other Services & Charges 221-4-5400-4321 Telephone 2,900.00 221.02 539.37 18.60 2,360.63 221-4-5400-4322 Postage 500.00 8.94 8.94 1.79 491.06 221-4-5400-4331 Travel, Conferences & Schools 1,050.00 0.00 0.00 0.00 1,050.00 221-9-5400-4359 Publishing 2,000.00 0.00 79.00 3.95 1,921.00 221-4-5400-4361 Insurance 9,000.00 4,047.50 9,097.50 44.97 4,952.50 221-4-5400-4389 Utilities 175,850.00 16,425.82 34,125.95 19.41 141,724.05 221-4-5400-4401 Bldg Repair/Maint Services 19,750.00 2,533.87 2,902.60 14.70 16,847.40 221-4-5400-4409 Contractual Services 2,000.00 9.60 9.60 0.48 1,990.40 221-4-5400-4415 Equipment Rental 5,400.00 0.00 340.78 6.31 5,059.22 221-4-5400-4433 Dues & Subscriptions 450.00 0.00 187.50 41.67 262.50 TOTAL Other Services & Charges 218,900.00 23,246.75 42,241.24 19.30 176,658.76 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-5900-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 847,900.00 49,757.66 116,074.61 13.69 731,825.39 4-16-2009 12:21 PM 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 PAGE: 5 25.00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE °s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5910-4103 Part-time Pay 3,600.00 0.00 154.00 4.28 3,446.00 221-4-5910-4105 FICA 200.00 0.00 9.55 4.78 190.45 221-4-5410-4107 Medicare 50.00 0.00 2.23 4.46 47.77 TOTAL Personal Services 3,850.00 0.00 165.78 4.31 3,684.22 Supplies 221-4-5410-4219 Operating Supplies 14,850.00 0.00 0.00 0.00 14,850.00 TOTAL Supplies 19,850.00 0.00 0.00 0.00 14,850.00 Other Services & Charges 221-4-5410-4322 Postage 500.00 0.00 0.00 0.00 500.00 221-4-5410-4359 Publishing 1,700.00 0.00 0.00 0.00 1,700.00 221-4-5410-4409 Contractual Services 7,050.00 25.60 25.60 0.36 7,029.40 221-4-5410-4438 Credit Card Fees 2,200.00 1,208.75 1,297.72 58.99 902.28 TOTAL Other Services & Charges 11,450.00 1,234.35 1,323.32 11.56 10,126.68 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-4322 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 1,234.35 1,489.10 4.94 28,660.90 20,000.00 1,915.88 3,873.56 19.37 16,126.44 500.00 75.63 179.58 35.92 320.42 1,250.00 118.79 257.23 20.58 992.77 300.00 27.78 60.16 20.05 239.84 22,050.00 2,138.08 4,370.53 19.82 17,679.47 6,000.00 555.49 555.49 9.26 5,944.51 6,000.00 555.49 555.49 9.26 5,944.51 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 80.00 80.00 3.27 2,370.00 2,450.00 426.57 708.69 28.93 1,741.31 6,400.00 506.57 788.69 12.32 5,611.31 ' TOTAL Skating 34,450.00 3,200.14 5,714.71 16.59 28,735.29 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 I 221-ICE ARENA Culture & Recreation I DEPARTMENTAL EXPENDITURES 25.00 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,908.98 5,380.32 25.74 15,519.68 221-4-5430-4104 PERA 0.00 45.15 142.31 0.00 ( 192.31) 221-4-5430-4105 FICA 1,300.00 118.36 353.94 27.23 996.06 221-4-5430-4107 Medicare 300.00 27.68 82.76 27.59 217.24 TOTAL Personal Services 22,500.00 2,100.17 5,959.33 26.49 16,540.67 Supplies 221-4-5430-4219 Operating Supplies 6,700.00 294.41 578.53 8.63 6,121.47 221-4-5430-4259 Other Merchandise For Resale 21,000.00 5,437.86 9,695.96 46.17 11,304.04 TOTAL Supplies 27,700.00 5,732.27 10,274.49 37.09 17,425.51 I TOTAL Arena Concessions 50,200.00 7,832.44 16,233.82 32.34 33,966.18 I TOTAL Culture & Recreation 962,700.00 62,024.59 139,512.29 14.49 823,187.76 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 962,700.00 62,024.59 139,512.24 14.49 823,187.76 0.00 5,402.16 140,095.51 ( 140,095.51) 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY REVENUE SUMMARY Pinewood Golf Course TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 254,800.00 396.00 396.00 0.16 254,404.00 254,800.00 396.00 396.00 0.16 254,404.00 259,800.00 14,989.58 32,623.61 12.80 222,176.39 254,800.00 14,989.58 32,623.61 12.80 222,176.39 254,800.00 14,989.58 32,623.61 12.80 222,176.39 0.00 ( 14,593.58)( 32,227.61) 32,227.61 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 ~ 222-PINEWOOD GOLF COURSE 1 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 Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In I TOTAL Pinewood Golf Course 25.00°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 20,000.00 16.00 16.00 0.08 19,984.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 380.00 380.00 0.34 111,620.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 396.00 396.00 0.21 192,109.00 62,300.00 0.00 0.00 0.00 62,300.00 62,300.00 0.00 0.00 0.00 62,300.00 254,800.00 396.00 396.00 0.16 254,404.00 ~ TOTAL REVENUE 259,800.00 396.00 396.00 0.16 259,404.00 4-16-2009 12:21 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2009 ~ 222-PINEWOOD GOLF COURSE ^ DEPARTMENTAL EXPENDITURES ^ Golf Course 25.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 222-4-5300-4101 Regular Pay 89,300.00 7,051.92 17,892.71 20.04 71,407.29 222-4-5300-4102 Overtime Pay 100.00 169.38 169.38 169.38 ( 69.38) 222-4-5300-4103 Part-time Pay 28,650.00 0.00 0.00 0.00 28,650.00 222-4-5300-4104 PERA 8,100.00 487.45 1,403.44 17.33 6,696.56 222-4-5300-4105 FICA 7,450.00 432.65 1,293.32 17.36 6,156.68 222-4-5300-4107 Medicare 1,750.00 101.19 302.49 17.29 1,447.51 222-4-5300-4108 Insurance 9,200.00 823.99 2,338.00 25.41 6,862.00 222-4-5300-4109 Workers Comp 1,050.00 294.00 588.00 56.00 462.00 TOTAL Person al Services 145,600.00 9,360.58 23,987.34 16.97 121,612.66 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 25,100.00 34.00 1,155.59 9.60 23,944.41 222-4-5300-4259 Other Merchandise For Resale 10,800.00 74.19 74.19 0.69 10,725.81 TOTAL Suppli es 41,400.00 108.19 1,229.78 2.97 40,170.22 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 88.92 178.24 7.13 2,321.76 222-4-5300-4331 Travel, Conferences & Schools 400.00 22.22 255.21 63.80 149.79 222-4-5300-4349 Advertising/Marketing 1,500.00 0.00 0.00 0.00 1,500.00 222-9-5300-4361 Insurance 11,550.00 5,146.50 5,146.50 44.56 6,903.50 222-9-5300-4389 Utilities 6,800.00 263.43 639.31 9.40 6,160.69 222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 19.97 39.94 2.00 1,960.06 222-4-5300-4404 Equip Repair/Maint Services 2,500.00 0.00 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 ( 24.70) 310.30 31.03 669.70 222-4-5300-4438 Credit Card Fees 3,500.00 4.47 8.99 0.26 3,491.06 TOTAL Other Services & Charges 67,800.00 5,520.81 7,406.49 10.92 60,393.51 TOTAL Golf Course 254,800.00 14,989.58 32,623.61 12.80 222,176.39 TOTAL Culture & Recreation 259,800.00 14,989.58 32,623.61 12.80 222,176.39 ^ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 254,800.00 14,989.58 32,623.61 12.80 222,176.39 0.00 ( 14,593.58)( 32,227.61) 32,227.61 "'b t !ice ~ x .. .,.~ ...; t V ~ ~.,~_ a CITY OF ELK RIVER POOLED CASH REPORT AS OF: MARCH 31ST, 2009 BEGINNING CURRENT CURRENT FUND # ACCOUNT NAME BALANCE ACTIVITY BALANCE 002-1010 101-1010 211-1010 221-1010 222-1010 223-1010 225-1010 228-1010 231-1010 240-1010 241-1010 245-1010 290-1010 291-1010 292-1010 294-1010 295-1010 296-1010 308-1010 311-1010 312-1010 313-1010 330-1010 331-1010 333-1010 340-1010 344-1010 375-1010 401-1010 403-1010 404-1010 405-1010 406-1010 410-1010 426-1010 427-1010 440-1010 459-1010 462-1010 602-1010 603-1010 605-1010 801-1010 821-1010 Cash -Section 125 Cash -General Fund Cash -Library Cash -Ice Arena Cash -Pinewood Golf Course Cash - Sr Citizen Account Cash -Park Dedication Cash -Landfill Cash -Landfill Const Debris Cash -Micro Loan Fund Cash - DTED Loan Cash -Development Fund Cash -Capital Outlay Reserve Cash -Insurance Reserve Cash -Govt Bldgs Reserve Cash -Drug Forfeiture Cash -Severance Pay Reserve Cash - NSP/RDF Reserve Cash - 1999A GO Bonds Cash - 2003A GO Bonds Cash - 2005A GO Bonds Cash - 2007C GO Bonds Cash - 1997 City Hall Bonds Cash - 1994C Storm Sewer Bonds Cash - 2002A Pub Safety Bonds Cash -Equipment Certificates Cash - 2006C Cap Imp Bonds Lby Cash -TIF #19 East Elk River Cash -Capital Projects Cash -Street Improvement Resr Cash - SurFace Water Managemnt Cash - NE Area Trunk Utilities Cash -City Wide Trunk Util Cash -Equipment Replacement Cash -YMCA Cash - 193rd Avenue Cash -Park Improvement Cash -TIF #19 Highway 169 Cash -TIF #22 Downtown Redev Cash -Wastewater Treatment Cash -Liquor Cash -Garbage Cash -Interest Cash -Developer Escrow 25,491.64 3,944,553.55 399,773.87 54,959.73 (14,846.53) 10,110.20 0.00 1,348,722.70 661,869.12 766,758.11 149,971.73 74,746.87 1,423,886.91 517,545.73 2,133,305.73 10,397.27 137,741.79 832,039.83 20,000.00 133,222.98 111,641.65 164,471.86 (227,157.94) 76,571.65 184,479.08 10,642.67 (171,177.50) (77,731.25) 1,990,152.77 2,805,263.43 184,759.25 265,574.73 3,389,711.29 996,734.89 1,786,635.14 (5,419.60) 20,645.44 732,990.06 0.00 3,655,221.33 3,401,942.97 320,600.83 0.00 110,032.75 2,534.74 (846,949.08) (5,773.05) 41,328.62 (14,593.58) 311.60 (16,828.75) (4,880.23) 0.00 12,206.02 0.00 0.00 (10,042.94) 13,767.12 5,241.14 205.48 0.00 (122,591.00) 0.00 0.00 (402.50) 4,768.75 227,491.00 0.00 (1,150.00) 0.00 (431.25) 0.00 (2,794.67) (3,107.17) 0.00 0.00 588.18 (328.53) 0.00 (9,025.24) (8,690.83) 0.00 (997.50) 71,215.93 (44,210.14) 8,878.55 64,681.67 4,270.33 28,026.38 3,097,604.47 394,000.82 96,288.35 (29,440.11) 10,421.80 (16,828.75) 1,343,842.47 661,869.12 778,964.13 149,971.73 74,746.87 1,413,843.97 531,312.85 2,138,546.87 10,602.75 137,741.79 709,448.83 20,000.00 133,222.98 111,239.15 169,240.61 333.06 76,571.65 183,329.08 10,642.67 (171,608.75) (77,731.25) 1,987,358.10 2,802,156.26 184,759.25 265,574.73 3,390,299.47 996,406.36 1,786,635.14 (14,444.84) 11,954.61 732,990.06 (997.50) 3,726,437.26 3,357,732.83 329,479.38 64,681.67 114,303.08 TOTAL CASH 32,356,836.73 (635,307.33) 31,721,529.40