Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #2 08-17-2009
INFORMATION ver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: August 17, 2009 SUBJECT: July 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 the Ice Arena and Pinewood Golf special revenue funds. These funds axe the primary concern in analyzing the City's financial health. For the month of July, actual revenues (except for property taxes and state aids) and expenditures should run about 58% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being significantly below for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund revenues: • Excluding transfers in, total revenue collections are at about 46% of budget. • The final installment of the first half property taxes was received in July and collections are about 47% of budget and with the collection of delinquent taxes is about 48% of budget. The second half payment fox property taxes will be received in December. • The City received $146,672 of its anticipated first half local government aid payment in July, with the remaining $196,738 being unallotted by the state. The second half payment is expected in December. • The tax category also includes $40,915 for cable franchise fees. • Interest income is typically lower due to the reversal of the prior year's interest receivable. • Revenue transfers in axe reflected in the July report. Expenditures: • Excluding transfers out, the total departmental expenditures are at about 50% and most departments are well within or below budget estimates. • Expenditures for recreation programs are currently exceeding budget estimates due to the extent of programs offered during the suirunex months. • The transfers out to the Ice Arena and Pinewood Golf Course are made at the end of the year based on actual results. Ice Arena For the month ended July, revenues exceed expenditures by $4,244. Excluding transfers in, revenue collections of $346,728 are at 46% of budget estimates, compared to 49% in 2008. Expenditures are at 36% of budget estimates for 2009 and were at 39% of budget in 2008. Pinewood Golf For the month ended July, expenditures exceed revenues by $10,004. Excluding transfers in, golf revenues of $143,446 are at about 75% of budget estimates, compared to 64% in 2008. Collections for youth recreation programs and league fees have exceeded budget estimates. Expenditures of $153,450 are about 60% of budget, compared to 67% in 2008. 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) ~~.~,,~ _ ~~~'® AS OF: JULY 31ST, 2009 rL~ 101-GENERAL FUND FINANCIAL SUMMARY 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 12,636,100.00 2,090,645.81 6,193,570.44 49.01 6,442,529.56 TOTAL REVENUES 12,636,100.00 2,090,645.81 6,193,570.44 49.01 6,442,529.56 EXPENDITURE SUMMARY General Government Mayor & Council 168,100.00 8,479.97 75,608.84 44.98 92,491.16 Cable TV 81,800.00 5,237.81 36,425.03 44.53 45,374.97 Administrative Services 471,650.00 33,687.67 245,116.36 51.97 226,533.64 Human Resources 147,950.00 11,032.27 77,852.34 52.62 70,097.66 00 300 447 941.07 32 273,847.76 61.22 173,452.24 Finance . , , Information Technology 278,050.00 16,292.35 109,204.09 39.27 168,845.91 Legal 234,000.00 27,741.91 105,830.66 45.23 128,169.34 Community Development 126,950.00 5,051.25 67,854.58 53.45 59,095.42 Planning 321,200.00 22,436.67 159,451.11 49.64 161,748.89 City Hall Maintenance 286,350.00 20,964.76 145,989.07 50.98 140,360.93 00 70 050 0.00 2,598.60 3.71 67,451.40 Contingency . , TOTAL General Government 2,633,400.00 183,865.73 1,299,778.44 49.36 1,333,621.56 Public Safety Police Administration 597,700.00 36,571.76 363,071.20 60.74 234,628.80 Patrol 2,182,800.00 168,666.77 1,065,339.26 48.81 1,117,460.72 Investigations 714,150.00 53,692.14 347,264.51 48.63 366,885.49 Police Support Services 492,050.00 34,193.44 251,418.25 51.10 240,631.75 Police Reserves 22,750.00 939.29 5,044.52 22.17 17,705.48 Public safety building 202,700.00 11,865.33 96,844.70 47.78 105,855.30 Fire Administration 472,200.00 63,371.69 269,046.82 56.98 203,153.18 Fire Inspections 188,850.00 17,186.96 101,814.78 53.91 87,035.22 Emergency Management 49,150.00 282.09 12,073.38 24.56 37,076.62 Building Safety 588,600.00 34,371.76 335,583.36 57.01 253,016.64 Environmental 75,350.00 5,626.46 38,529.64 51.13 36,820.36 TOTAL Public Safety 5,586,300.00 426,767.69 2,886,030.44 51.66 2,700,269.56 Public Works Street Maintenance 1,300,650.00 82,169.53 570,656.33 43.87 729,993.67 Snow Removal 308,750.00 0.00 148,625.90 48.14 160,124.10 Equipment Services 250,450.00 18,225.37 123,777.47 49.42 126,672.53 Engineering 191,150.00 9,440.10 49,893.32 26.10 141,256.68 TOTAL Public Works 2,051,000.00 109,655.00 892,953.02 43.54 1,158,046.98 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Concessions Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General Transfers Out TOTAL General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 733,150.00 68,225.36 373,157.45 50.90 359,992.55 541,450.00 35,614.39 287,697.23 53.13 253,752, 77 164,300.00 42,459.48 119,564.33 72.77 44,735. 67 19,500.00 1,199.36 7,309.44 37.48 12,190. 56 193,350.00 18,782.66 103,775.40 53.67 89,574. 60 1,651,750.00 166,281.27 891,503.85 53.97 760,246. 15 0.00 ( 30,347.89) 17,327.98 0.00 ( 17,327. 98) 55,800.00 5,236.32 20,697.85 37.09 35,102 .15 55,800.00 ( 25,111.57) 38,025.83 68.15 17,774 .17 229,300.00 0.00 66,600.00 29.04 162,700 .00 229,300.00 0.00 66,600.00 29.04 162,700 .00 12,207,550.00 861,658.12 6,074,891.58 49.76 6,132,658 .42 428,550.00 1,228,987.69 118,678.86 309,871 .14 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND REVENUES General Fund CURRENT CURRENT BUDGET PERIOD 58.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,547,550.00 1,356,083.09 4,500,716.25 47.14 5,046,833. 75 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 70,113.75 70,113.75 0.00 ( 70,113. 75) 101-3-0000-3121 Gravel Tax 150,000.00 26,701.52 30,699.04 20.47 119,300. 96 101-3-0000-3123 Franchise Tax 0.00 0.00 40,914.54 0.00 ( 40,914. 54) 101-3-0000-3131 Penalties/Interest 0.00 3,169.37 3,169.37 0.00 ( 3,169. 37) 101-3-0000-3132 Tax Forfeited Land Sale 0.00 0.00 25.55 0.00 ( 25. 55) TOTAL Taxes 9,697,550.00 1,456,067.73 4,645,638.50 47.91 5,051,911. 50 Licenses & Permits 101-3-0000-3211 Liquor License 51,000.00 55.00 49,085.00 96.25 1,915. 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 100.00 3.33 2,900. 00 101-3-0000-3214 Apartment License 15,850.00 0.00 13,650.00 86.12 2,200. 00 101-3-0000-3216 Mining License 9,000.00 0.00 20,562.45 228.47 ( 11,562. 45) 101-3-0000-3217 Garbage Hauler License 3,000.00 0.00 3,095.00 103.17 ( 95 .00) 101-3-0000-3218 Other Business License/Permit 13,000.00 1,170.00 16,960.00 130.46 ( 3,960 .00) 101-3-0000-3229 NPDES Permit 5,000.00 175.00 875.00 17.50 4,125 .00 101-3-0000-3231 Building Permit 188,300.00 18,751.15 86,722.72 46.06 101,577 .28 101-3-0000-3232 Plumbing/Heating Permit 47,600.00 2,598.09 34,128.00 71.70 13,472 .00 101-3-0000-3233 Permit Surcharge 200.00 627.31 1,221.83 610.92 ( 1,021 .83) 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 110.00 3,094.00 103.13 ( 94 .00) 101-3-0000-3236 Parking Permit 1,500.00 60.00 1,240.00 82.67 260 .00 101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 ( 60.00) 5,485.00 45.71 6,515 .00 TOTAL Licenses & Permits 353,550.00 23,486.55 236,219.00 66.81 117,331 .00 Intergovernmental Rev 101-3-0000-3321 Local Government Aid 686,800.00 146,672.00 146,672.00 21.36 540,128 .00 101-3-0000-3324 PERA Aid 15,000.00 6,992.00 6,992.00 46.61 8,008 .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 17,234.30 36,721.64 99.79 78 .36 101-3-0000-3329 State Crime Prevention Grant 12,500.00 0.00 4,745.59 37.96 7,754 .41 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 170,698.30 195,131.23 19.84 788,468 .77 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 660.00 9,200.00 36.80 15,800 .00 101-3-0000-3413 Plan Check Fee 75,300.00 7,381.89 30,157.05 40.05 45,142 .95 101-3-0000-3415 Special Assessment Search 500.00 20.00 340.00 68.00 160 .00 101-3-0000-3417 Copies 1,500.00 273.25 1,297.42 86.49 202 .58 101-3-0000-3418 Other General Govt Services 5,000.00 331.25 2,066.13 41.32 2,933 .87 101-3-0000-3430 Lockout Fees 8,500.00 590.00 4,714.58 55.47 3,785 .42 101-3-0000-3431 Police Services 2,000.00 714.94 1,735.69 86.78 264.31 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND REVENUES 58.335 OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 101-3-0000-3432 School Liaison 101-3-0000-3434 Animal Impound Fee 101-3-0000-3436 Fire Contracts 101-3-0000-3437 Fire Calls 101-3-0000-3451 Street Services 101-3-0000-3461 Recreation Fees 101-3-0000-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 & Forfeits 101-3-0000-3510 Court Fines 101-3-0000-3511 Parking Fines 101-3-0000-3512 Ordinanace Violations TOTAL Fines & Forfeits 75,000.00 0.00 75,000.00 100. 00 0.00 3,000.00 150.00 2,470.00 82. 33 530.00 208,000.00 4,950.00 158,192.00 76. 05 49,808.00 1,000.00 0.00 0.00 0. 00 1,000.00 25,000.00 1,855.00 13,770.99 55. 08 11,229.01 121,500.00 13,281.00 90,260.64 74. 29 31,239.36 20,100.00 2,070.80 7,078.82 35. 22 13,021.18 2,600.00 ( 950.00) 10,576.44 406. 79 ( 7,976.44) 3,100.00 ( 315.00) 3,764.01 121. 42 ( 664.01) 2,400.00 200.00 3,650.00 152. 08 ( 1,250.00) 5,000.00 130.00 1,050.00 21. 00 3,950.00 500.00 45.00 265.00 53. 00 235.00 585,000.00 31,388.13 415,588.77 71. 04 169,411.23 150,000.00 8,520. 67 55,404.47 36. 94 94,595.53 7,000.00 390. 00 10,665.75 152 .37 ( 3,665.75) 0.00 0. 00 100.00 0 .00 ( 100.00) 157,000.00 8,910. 67 66,170.22 42 .15 90,829.78 Other Revenue 101-3-0000-3621 Interest Income 180,000.00 0. 00 11,196.49 6.22 168,803. 51 101-3-0000-3625 Refunds & Reimbursements 54,000.00 99 .54 2,083.57 3.66 51,916 .43 101-3-0000-3626 Contributions 22,800.00 24 .00 18,490.00 81.10 4,310 .00 101-3-0000-3629 Miscellaneous Revenue 3,000.00 170 .89 3,452.66 115.09 ( 452 .66) TOTAL Other Revenue 259,800.00 294 .43 35,222.72 13.56 224,577 .28 Transfers In 101-3-0000-3925 Transfer-Landfill 101-3-0000-3929 Transfer-NSP/RDF Reserve 101-3-0000-3942 Transfer-WWTS 101-3-0000-3943 Transfer-Liquor 101-3-0000-3945 Transfer-Utilities 101-3-0000-3948 Transfer-EDA 101-3-0000-3949 Transfer-HRA TOTAL Transfers In 35,000.00 35,000.00 35,000.00 100.00 0.00 39,500.00 39,500.00 39,500.00 100.00 0.00 50,000.00 50,000.00 50,000.00 100.00 0.00 248,600.00 248,600.00 248,600.00 100.00 0.00 200,000.00 0.00 200,000.00 100.00 0.00 17,000.00 17,000.00 17,000.00 100.00 0.00 9,500.00 9,500.00 9,500.00 100.00 0.00 599,600.00 399,600.00 599,600.00 100.00 0.00 TOTAL General Fund 12,636,100.00 2,090,645.81 6,193,570.44 49.01 6,442,529.56 TOTAL REVENUE 12,636,100.00 2,090,645.81 6,193,570.44 49.01 6,442,529.56 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND DEPARTMENTAL EXPENDITURES 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-4-1110-4361 Insurance 101-4-1110-4433 Dues & Subscriptions 101-4-1110-4440 Miscellaneous TOTAL Other Services & Charges 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 38,500.00 3,208.00 22,456.00 58.33 16,044.00 1,950.00 102.07 714.49 36. 64 1,235.51 2,400.00 198.90 1,392.30 58. 01 1,007.70 550.00 46.52 325.64 59. 21 224.36 50.00 0.00 29.25 58. 50 20.75 43,450.00 3,555.49 24,917.68 57. 35 18,532.32 3,200.00 84.11 856.33 26. 76 2,343.67 3,200.00 84.11 856.33 26 .76 2,343.67 6,750.00 1,599.85 5,643.01 83.60 1,106.99 800.00 36.39 106.34 13.29 693.66 6,500.00 200.93 643.62 9.90 5,856.38 18,200.00 2,916.20 9,259.98 50.88 8,940.02 64,800.00 0.00 31,312.00 48.32 33,488.00 15,000.00 0.00 500.00 3.33 14,500.00 9,400.00 87.00 2,369.88 25.21 7,030.12 121,450.00 4,840.37 49,834.83 41.03 71,615.17 TOTAL Mayor & Council Cable TV ________ Personal Services 101-4-1120-4101 Regular Pay 101-4-1120-4103 Part-time Pay 101-4-1120-4104 PERA 101-4-1120-4105 FICA 101-4-1120-4107 Medicare 101-4-1120-4108 Insurance 101-4-1120-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1120-4201 Office Supplies TOTAL Supplies 168,100,00 8,479.97 75,608.84 44.98 92,491.16 50,600.00 3,860.16 26,747.37 52.86 23,852.63 11,800.00 309.38 2,012.51 17. 06 9,767.49 3,550.00 260.56 1,900.65 53. 54 1,649.35 4,000.00 255.95 1,856.87 46. 42 2,143.13 950.00 59.86 434.25 45. 71 515.75 5,250.00 438.01 3,066.07 58. 40 2,183.93 200.00 0.00 129.75 64. 86 70.25 76,350.00 5,183.92 36,147.47 47 .34 40,202.53 3,350.00 47.87 232.85 6 .95 3,117.15 3,350.00 47.87 232.85 6 .95 3,117.15 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 58.33°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE other Services & Charges 101-4-1120-4319 Other Professional Services 500. 00 101-4-1120-4322 Postage 100. 00 101-4-1120-4331 Travel, Conferences & Schools 1,400. 00 101-4-1120-4404 Equip Repair/Maint Services 100. 00 TOTAL Other Services & Charges 2,100. 00 0.00 0.00 0.00 500.00 6.02 6.62 6.62 93.38 0.00 38.09 2.72 1,361.91 0.00 0.00 0.00 100.00 6.02 44.71 2.13 2,055.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-4104 PERA 101-4-1210-4105 FICA 101-4-1210-4106 Other Retirement Contributions 101-4-1210-4107 Medicare 101-4-1210-4108 Insurance 101-4-1210-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1210-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1210-4319 Other Professional Services 101-4-1210-4321 Telephone 101-4-1210-4322 Postage 101-4-1210-4331 Travel, Conferences & SChOOls 101-4-1210-4361 Insurance 101-4-1210-4404 Equip Repair/Maint Services 101-4-1210-4433 Dues '& Subscriptions 101-4-1210-4460 Equip Replacement Charge TOTAL Other Services & Charges 81,800.00 5,237.81 36,425.03 44.53 45,374.97 296,750.00 22,525.76 159,108.85 53.62 137,641. 15 2,000.00 0. 00 0.00 0.00 2,000. 00 45,600.00 3,388. 46 23,628.98 51.82 21,971. 02 23,250.00 1,749. 20 12,985.47 55.65 10,264. 53 21,350.00 1,564. 40 11,660.48 54.62 9,689. 52 4,800.00 400. 00 2,800.00 58.33 2,000. 00 5,000.00 365. 87 2,727.08 54.54 2,272. 92 23,450.00 1,954. 03 13,678.21 58.33 9,771. 79 1,300.00 0.00 1,051.50 80.88 248. 50 423,500.00 31,947 .72 227,640.57 53.75 195,859. 43 9,900.00 325 .69 2,770.14 27.98 7,129 .86 9,900.00 325 .69 2,770.14 27.98 7,129 .86 4,500.00 0.00 600.00 68.93 1,500.00 185.39 5,600.00 235.37 200.00 0.00 22,600.00 892.24 2,600.00 0.00 650.00 32.33 38,250.00 1,414.26 4,860.00 108.00 ( 360 .00) 419.97 70.00 180 .03 256.34 17.09 1,243 .66 1,172.48 20.94 4,427 .52 112.00 56.00 88 .00 7,438.55 32.91 15,161 .45 220.00 8.46 2,380 .00 226.31 34.82 423 .69 14,705.65 38.45 23,544 .35 TOTAL Administrative Services 471,650.00 33,687.67 245,116.36 51.97 226,533.64 Human Resources 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND General Government 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE is OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-1220-4101 Regular Pay 101-4-1220-4103 Part-time Pay 101-4-1220-4104 PERA 101-4-1220-4105 FICA 101-4-1220-4107 Medicare 101-4-1220-4108 Insurance 101-4-1220-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1220-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1220-4319 Other Professional Services 101-4-1220-4322 Postage 101-4-1220-4331 Travel, Conferences & Schools 101-4-1220-4433 Dues & Subscriptions 101-4-1220-4440 Miscellaneous TOTAL Other Services & Charges 68,850.00 5,219. 24 37,056.60 53.82 31,793. 40 45,200.00 3,737. 62 25,003.94 55.32 20,196. 06 7,700.00 604. 59 4,426.97 57.49 3,273. 03 7,100.00 549. 77 4,038.06 56.87 3,061. 94 1,650.00 128. 58 944.34 57.23 705. 66 5,250.00 438. 00 3,066.00 58.40 2,184. 00 450.00 0. 00 348.75 77.50 101.25 136,200.00 10,677 .80 74,884.66 54.98 61,315. 34 3,000.00 152 .68 2,065.63 66.85 934. 37 3,000.00 152 .88 2,065.63 68.85 934 .37 3,000.00 0.00 350.00 97.90 3,750.00 42.49 650.00 -0.00 1,000.00 61.20 8,750.00 201.59 0. 00 0.00 3,000.00 200. 61 57.32 149.39 251. 54 6.71 3,498.46 0. 00 0.00 650.00 449.90 44.99 550.10 902 .05 10.31 7,847.95 I 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-4-1310-4108 InSUrariCe 101-4-1310-4109 Workers Comp TOTAL Personal Services Supplies 101-4-1310-4201 Office Supplies TOTAL Supplies 147,950.00 11,032.27 77,852.34 52.62 70,097.66 284,350.00 21,624.06 151,707.55 53.35 132,642.45 5,150.00 135.00 1,485. 00 28 .83 3,665.00 19,550.00 1,459.63 10,781. 19 55 .15 8,768.81 17,950.00 1,251.66 9,337. 22 52 .02 8,612.78 4,200.00 292.72 2,183. 64 51 .99 2,016.36 23,450.00 1,954.03 13,678. 21 58 .33 9,771.79 1,100.00 0.00 885. 75 80 .52 214.25 355,750.00 26,717.10 190,058. 56 53 .42 165,691.44 3,850.00 164.14 1,402. 66 36 .43 2,447.34 3,850.00 164.14 1,402. 66 36 .43 2,447.34 Other Services & Charges 101-4-1310-4301 Audit Fees 17,300.00 4,320.00 17,280.00 99. 88 20.00 101-4-1310-4319 Other Professional Services 48,150.00 0.00 48,788.00 101. 33 ( 636.00) 101-4-1310-4321 Telephone 850.00 61.56 379.32 44. 63 470.68 101-4-1310-4322 Postage 3,600.00 517.27 932.74 25. 91 2,667.26 101-4-1310-4331 Travel, Conferences & Schools 4,150.00 0.00 2,188.28 52. 73 1,961.72 101-4-1310-4359 Publishing 2,000.00 961.00 961.00 48 ,05 1,039.00 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1310-4404 Equip Repair/Maint Services 10,100.00 0.00 10,344.20 102.42 ( 244.20) 101-4-1310-4433 Dues & Subscriptions 1,550.00 200.00 1,375.00 88.71 175.00 101-4-1310-4440 Miscellaneous 0.00 0.00 138.00 0.00 ( 138.00) TOTAL Other Services & Charges 87,700.00 6,059.83 82,386.54 93.94 5,313.46 TOTAL Finance 447,300.00 32,941.07 273,847.76 61.22 173,452.24 Information Technology Personal Services 101-4-1350-4101 Regular Pay 129,300.00 9,822.80 69,101.28 53.44 60,198.72 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 663.04 4,911.01 51.16 4,688.99 101-4-1350-4105 FICA 8,800.00 582.78 4,359.34 49.54 4,440.66 101-4-1350-4107 Medicare 2,050.00 136.30 1,019.53 49.73 1,030.47 101-4-1350-4108 Insurance 15,350.00 1,280.02 8,556.12 55.74 6,793.88 101-4-1350-4109 Workers. Comp 550.00 0.00 435.00 79.09 115.00 TOTAL Personal Services 178,500.00 12,484.94 88,382.28 49.51 90,117.72 Supplies 101-4-1350-4219 Operating Supplies 23,300.00 544.88 4,446.49 19.08 18,853.51 TOTAL Supplies 23,300.00 544.88 4,446.49 19.08 18,853.51 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 330.00 4.13 7,670.00 101-4-1350-4321 Telephone 800.00 49.05 331.20 41.40 468.80 101-4-1350-4331 Travel, Conferences & Schools 4,500.00 3,213.48 3,411.47 75.81 1,088.53 101-4-1350-4404 Equip Repair/Maint Services 19,950.00 0.00 7,693.20 38.56 12,256.80 TOTAL Other Services & Charges 33,250.00 3,262.53 11,765.87 35.39 21,484.13 Capital Outlay 101-4-1350-4560 Equipment 43,000.00 0.00 4,609.45 10.72 38,390.55 TOTAL Capital Outlay 43,000.00 0.00 4,609.45 10.72 38,390.55 TOTAL Information Technology Legal Other Services & Charges 101-4-1400-4304 Legal Fees TOTAL Other Services & Charges 278,050.00 16,292.35 109,204.09 39.27 168,845.91 234,000.00 27,741.91 105,830.66 45.23 126,169.34 234,000.00 27,741.91 105,830.66 45.23 128,169.34 TOTAL Legal 234,000.00 27,741.91 105,830.66 45.23 128,169.34 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Community Development Personal Services 101-4-1500-4101 Regular Pay 101-4-1500-4104 PERA 101-4-1500-4105 FZCA 101-4-1500-4107 Medicare 101-4-1500-4108 Insurance 101-4-1500-4109 Workers Comp 101-4-1500-4110 Re-employment Compensation TOTAL Personal Services Suoplies 101-4-1500-4201 Office Supplies TOTAL Supplies Other Services & Charges 101-4-1500-4331 Travel, Conferences & Schools 2,550.00 0.00 646.79 25.36 1,903.21 TOTAL Other Services & Charges 2,550.00 0.00 646.79 25.36 1,903.21 CURRENT CURRENT BUDGET PERIOD 58.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE 84,550.00 4,052.81 54,050.97 63.93 30,499.03 5,700.00 273.56 2,920.22 51.23 2,779.78 5,300.00 232.50 3,422.55 64.58 1,877.45 1,250.00 54.38 800.46 64.04 449.54 8,700.00 438.00 5,553.38 63.83 3,146.62 550.00 0.00 427.50 77.73 122.50 18,100.00 0.00 0.00 0.00 18,100.00 124,150.00 5,051.25 67,175.08 54.11 56,974.92 250.00 0.00 32.71 13.08 217.29 250.00 0.00 32.71 13.08 217.29 TOTAL Commuriity Development 126,950.00 5,051.25 67,854.58 53.45 59,095.42 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 210,300.00 15,985.93 112,049.24 53. 28 14,200.00 1,079.05 7,840.78 55. 22 13,050.00 893.69 6,546.93 50. 17 3,050.00 209.01 1,531.23 50. 20 28,300.00 2,140.02 14,340.13 50. 67 500.00 0.00 466.50 93. 30 269,400.00 20,307.70 142,774.81 53 .00 98,250.76 6,359.22 6,503.07 1,518.77 13,959.87 33.50 Supplies 101-4-1510-4201 Office Supplies 101-4-1510-4212 Fuels & Lubs TOTAL Supplies 126,625.19 4,850.00 544.97 2,355.88 46.57 2,494.12 850.00 147.53 750.15 88.25 99.85 5,700.00 692.50 3,106.03 54.49 2,593.97 Other Services & Charges 101-4-1510-4319 Other Professional Services 20,000 .00 38.00 6,952.34 34.76 13,047.66 101-4-1510-4321 Telephone 800 .00 36.02 218.47 27.31 581.53 101-4-1510-4322 Postage 2,000 .00 792.30 1,105.06 55.25 894.94 101-4-1510-4331 Travel, Conferences & Schools 6,350 .00 0.00 880.83 13.87 5,469.17 101-4-1510-4359 Publishing 10,000 .00 453.00 3,091.45 30.91 6,908.55 101-4-1510-4361 Insurance 700 .00 0.00 0.00 0.00 700.00 101-4-1510-4404 Equip Repair/Maint Services 5,000 .00 117.15 810.12 16.20 4,189.88 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND General Government DEPARTMENTAL EXPENDITURES 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 445.00 44,50 555.00 101-4-1510-4440 Miscellaneous 250.00 0.00 67.00 26.80 183.00 TOTAL Other Services & Charges 46,100.00 1,436.47 13,570.27 29.44 32,529.73 TOTAL Planning 321,200.00 22,436.67 City Hall Maintenance Personal Services 159,451.11 49.64 161,748.89 101-4-1600-4101 Regular Pay .83,750 .00 7,904. 10 52,409.87 62.58 101-4-1600-4102 Overtime Pay 9,100 .00 0. 00 0.00 0.00 101-4-1600-4103 Part-time Pay 18,450 .00 2,374. 24 10,927.07 59.23 101-4-1600-4104 PERA 7,800 .00 636. 76 4,341.46 55.66 101-4-1600-4105 FICA 7,150 .00 625 .77 4,083.25 57.11 101-4-1600-4107 Medicare 1,700 .00 146 .36 954.99 56.18 101-4-1600-4108 Insurance 11,900 .00 1,338 .57 8,525.30 71.64 101-4-1600-4109 Workers Comp 2,550 .00 0 .00 3,206.25 125.74 TOTAL Personal Services 142,400 .00 13,025 .80 84,448.19 59.30 Supplies 31,340.13 9,100.00 7,522.93 3,458.54 3,066.75 745.01 3,374.70 656.25) 57,951.81 101-4-1600-4212 Fuels & Lubs 3,750.00 221.66 1,284.39 34. 25 2,465.61 101-4-1600-4217 Uniform Allowance 1,700.00 249.21 820.67 48. 27 879.33 101-4-1600-4219 Operating Supplies 30,000.00 732.45 13,963.21 46. 54 16,036.79 TOTAL Supplies 35,450.00 1,203.32 16,068.27 45. 33 19,381.73 Other Services & Charges 101-4-1600-4321 Telephone 15,450.00 906. 52 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0. 00 101-4-1600-4361 Insurance 5,700.00 0. 00 101-4-1600-4389 Utilities 51,800.00 3,307. 18 101-4-1600-4401 Bldg Repair/Maint Services 32,300.00 2,221. 74 101-4-1600-4404 Equip Repair/Maint Services 1,250.00 300. 20 TOTAL Other Services & Charges 108,500.00 6,735. 64 6,501.90 42. 08 8,948.10 1,240.00 62 .00 760.00 2,320.00 40 .70 3,380.00 22,692.03 43 .81 29,107.97 12,367.82 38 .29 19,932.18 350.86 28 .07 899.14 45,472.61 41 .91 63,027.39 TOTAL City Hall Maintenance Contingency Other Services & Charges 101-4-1900-4440 Miscellaneous TOTAL Other Services & Charges 286,350.00 20,964.76 145,969.07 50.98 140,360.93 70,050.00 0.00 2,598.60 3.71 67,451.40 70,050.00 0.00 2,598.60 3.71 67,451.40 TOTAL Contingency 70,050.00 0.00 2,598.60 3.71 67,451.40 TOTAL General Government 2,633,400.00 183,865.73 1,299,778.44 49.36 1,333,621.56 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NLY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 58.33% OF YEAR COMP. CURRENT CURRENT BUDGET PERIOD YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 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-4361 Insurance 101-4-2110-4404 Equip Repair/Maint Services 101-4-2110-4433 Dues & Subscriptions 101-4-2110-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 101-4-2110-4560 Equipment TOTAL Capital Outlay TOTAL Police Administration Patrol Personal Services 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 279,400.00 21,182.44 150,395.33 53.83 129,004.67 39,400.00 2,986.74 22,362.11 56.76 17,037.89 0.00 0.00 1,116.38 0.00 ( 1,116.38) 2,550.00 201.70 1,776.99 69.69 773.01 23,250.00 1,938.01 13,566.07 58.35 9,683.93 48,500.00 0.00 38,910.75 80.23 9,589.25 393,100.00 26,308.89 228,127.63 58.03 164,972.37 16,000.00 521.43 5,027.15 31.42 10,972.85 2,500.00 41.50 1,543.67 61.75 956.33 3,150.00 130.00 454.06 14.41 2,695.94 21,650.00 692.93 7,024.88 32.45 14,625.12 5,500.00 181.76 853.95 15.53 4,646.05 25,000.00 2,500.60 12,435.91 49.74 12,564.09 2,100.00 4.78 436.81 20.80 1,663.19 4,200.00 0.00 723.69 17.23 3,476.31 500.00 0.00 112.20 22.44 387.80 12,450.00 0.00 4,576.50 36.76 7,873.50 69,250.00 6,791.55 47,837.88 69.08 21,412.12 5,850.00 0.00 3,098.00 52.96 2,752.00 500.00 91.25 244.75 48.95 255.25 125,350.00 9,569.94 70,319.69 56.10 55,030.31 57,600.00 0.00 57,599.00 100.00 1.00 57,600.00 0.00 57,599.00 100.00 1.00 597,700.00 36,571.76 363,071.20 60.74 234,628.80 1,435,250.00 112,738 .19 726,827.06 50.64 708,422.94 90,000.00 5,663 .93 27,277.66 30.31 62,722.34 215,050.00 16,694 .70 111,732.07 51.96 103,317.93 19,800.00 1,405 .11 9,418.63 47.57 10,381.37 150,400.00 12,978 .07 90,846.49 60.40 59,553.51 1,910,500.00 149,480 .00 966,101.91 50.57 944,398.09 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Safety 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD 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/Maim Services 101-4-2120-4433 Dues & Subscriptions 101-4-2120-4460 Equip Replacement Charge TOTAL Other Services & Charges 95,000.00 6,522.27 41,798.46 44.00 53,201.54 17,200.00 74. 51 812.05 4.72 16,387.95 49,000.00 4,271. 41 17,330.86 35.37 31,669.12 25,000.00 2,314. 13 10,820.06 43.28 14,179.94 186,200.00 13,182. 32 70,761.45 38.00 115,438.55 14,650.00 3,223.00 5,822. 89 39.75 8,827.11 27,200.00 552.04 6,817. 16 25.06 20,382.84 550.00 0.00 230. 00 41.82 320.00 43,700.00 2,229.41 15,605. 87 35.71 28,094.13 86,100.00 6,004.45 28,475 .92 33.07 57,624.08 ~ 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-4319 Other Professional Services 101-4-2130-4331 Travel, Conferences & Schools 101-4-2130-4433 Dues & Subscriptions 101-4-2130-4460 Equip Replacement Charge TOTAL Other Services & Charges 2,182,800.00 168,666.77 1,065,339.28 48.81 1,117,460.72 495,800.00 40,589.66 255,979.25 51. 63 239,820.75 40,000.00 734.70 7,143.61 17. 86 32,856.39 75,550.00 5,826.74 38,920.85 51. 52 36,629.15 5,600.00 377.51 2,475.09 44. 20 3,124.91 58,600.00 4,914.94 34,404.58 58. 71 24,195.42 675,550.00 52,443.55 338,923.38 50. 17 336,626.62 4,850.00 0.00 214.84 4 .43 4,635.16 8,400.00 610.08 1,803.11 21 .47 6,596.89 13,250.00 610.08 2,017.95 15 .23 11,232.05 10,750.00 116. 80 1,346.21 12.52 9,403. 79 4,000.00 0. 00 1,275.00 31.88 2,725. 00 200.00 0. 00 50.00 25.00 150. 00 10,400.00 521 .71 3,651.97 35.12 6,748. 03 25,350.00 638 .51 6,323.18 24.94 19,026 .82 TOTAL Investigations 714,150.00 53,692.14 347,264.51 48.63 366,885.49 I Folice-Support-Services 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 58.335 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2150-4101 Regular Pay 101-4-2150-4102 Overtime Pay 101-4-2150-4104 PERA 101-4-2150-4105 FICA 101-4-2150-4107 Medicare 101-4-2150-4108 Insurance TOTAL Personal Services Supplies 101-4-2150-4201 Office Supplies 101-4-2150-4217 Uniform Allowance 101-4-2150-4219 Operating Supplies TOTAL Supplies 346,900.00 26,368.83 185,609.50 53.51 161,290.50 6,500.00 0.00 61.09 0.94 6,438.91 23,850.00 1,779.89 13,191.77 55.31 10,658.23 21,900.00 1,592.69 11,851.33 54.12 10,048.67 5,100.00 372.47 2,771.60 54.35 2,328.40 42,050.00 3,504.02 24,528.14 58.33 17,521.86 446,300.00 33,617.90 238,013.43 53.33 208,286.57 1,000.00 140.55 424.64 42.48 575.16 3,250.00 ( 18.97) 832.70 25.62 2,417.30 8,050.00 ( 803.31) 1,276.63 15.88 6,771.37 12,300.00 ( 681.73) 2,536.17 20.62 9,763.83 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,550.00 0.00 10. 00 0 .28 3,540. 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 860.47 4,183. 55 26 .15 11,816. 45 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 396.80 2,777. 60 35 .16 5,122 .40 TOTAL Other Services & Charges 33,450.00 1,257.27 10,868. 65 32 .49 22,581 .35 TOTAL Police Support Services Police Reserves 492,050.00 34,193.44 251,418.25 51.10 240,631.75 Personal Services 101-4-2160-4103 Part-time Pay 5,500. 00 554.03 554.03 10.07 4,945.97 101-4-2160-4105 FICA 350. 00 34.35 34.35 9.81 315.65 101-4-2160-4107 Medicare 100. 00 8.03 6.03 8.03 91.97 101-4-2160-4110 Re-employment Compensation 0. 00 0.00 29.07 0.00 ( 29.07) TOTAL Personal Services 5,950. 00 596.41 625.48 10.51 5,324.52 Supplies 101-4-2160-4217 Uniform Allowance 101-4-2160-4219 Operating Supplies TOTAL Supplies 5,000.00 112.10 844.62 16.89 4,155.38 6,000.00 0.00 1,131.88 18.86 4,868.12 11,000.00 112.10 1,976.50 17.97 9,023.50 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,500.00 91.90 933. 80 62.25 566. 20 101-4-2160-4321 Telephone 1,600.00 138.88 915 .54 57.22 684. 46 101-4-2160-4331 Travel, Conferences & Schools 1,700.00 0.00 0 .00 0.00 1,700. 00 101-4-2160-4359 Publishing 0.00 0.00 112 .20 0.00 ( 112. 20) 101-4-2160-4433 Dues & Subscriptions 1,000.00 0.00 481 .00 48.10 519 .00 TOTAL Other Services & Charges 5,800.00 230.78 2,442 .54 42.11 3,357 .46 TOTAL Police Reserves 22,750.00 939.29 5,044.52 22.17 17,705.48 CITY OF ELK RIVER PAGE: 14 8-12-2009 03:24 PM REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 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-4-2190-4108 IrisurariCe 101-4-2190-4109 Workers Comp TOTAL Personal Services 58.33"s OF YEAR COMP. CURRENT BUDGET CURRENT PERIOD YEAR TO DATE & OF BUDGET ACTUAL BUDGET BALANCE 98,200.00 450.00 6,650.00 6,100.00 1,450.00 14,250.00 2,200.00 129,300.00 7,029.45 49,438. 03 50.34 48,761.97 0.00 0. 00 0.00 450. 00 474.48 3,492. 01 52.51 3,157. 99 420.89 3,136. 66 51.42 2,963. 34 98.45 733 .66 50.60 716. 34 937.60 6,932 .89 48.65 7,317. 11 0.00 2,843 .25 129.24 ( 643 .25) 8,960.87 66,576 .50 51.49 62,723 .50 Sup~l?es 101-4-2190-4219 Operating Supplies 17,000.00 941.98 11,921.55 70.13 5,078.45 TOTAL Supplies 17,000.00 941.98 11,921.55 70.13 5,078.45 Other Services & Charges 00 0 006.50 3 43.57 3,893.50 6,900.00 . , 101-4-2190-4361 Insurance 12 592 7,122.02 39.13 11,077.98 101-4-2190-4389 Utilities 18,200.00 . 26 26 081.87 23 101-4-2190-4401 Bldg Repair/Maint Services 31,300.00 1,370.36 8,218.13 . , 400.00 56 1,962.48 18,346.65 32.53 38,053.35 TOTAL Other Services & Charges , TOTAL Public safety building 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-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 101-4-2310-4110 Re-employment Compensation 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 202,700.00 11,865.33 96,844.70 47.78 105,855.30 90,850.00 1,408.28 58,762.17 64.68 32,087.83 150,350.00 12,404.71 81,900.47 54.47 68,449.53 13,250.00 208.35 5,410.91 40.84 7,839.09 10,050.00 747.04 5,452.91 54.26 4,597.09 30,000.00 30,000.00 30,000.00 100.00 0.00 3,500.00 174.70 1,967.46 56.21 1,532.54 9,150.00 337.57 4,538.67 49.60 4,611.33 15,350.00 0.00 11,787.00 76.79 3,563.00 0.00 0.00 632.04 0.00 ( 632.04) 322,500.00 45,280.65 200,451.63 62.16 122,048.37 1,200.00 250.56 629.47 52.46 570.53 7,950.00 377.92 2,516.15 31.65 5,433.85 1,100.00 1,075.36 1,946.84 176.99 ( 846.84) 32,400.00 2,492.87 15,446.65 47.68 16,953.15 42,650.00 4,196.73 20,539.31 48.16 22,110.69 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NLY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 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-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 101-4-2310-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Fire Administration Fire Inspections Personal Services 101-4-2320-4101 Regular Pay 101-4-2320-4102 Overtime Pay 101-4-2320-4103 Part-time Pay 101-4-2320-4104 PERA 101-4-2320-4105 FICA 101-4-2320-4107 Medicare 101-4-2320-4108 Insurance TOTAL Personal Services Supplies 101-4-2320-4201 Office Supplies 101-4-2320-4212 Fuels & Lubs 101-4-2320-4217 Uniform Allowance 101-4-2320-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-2320-4321 Telephone 101-4-2320-4322 Postage 101-4-2320-4331 Travel, Conferences & Schools 101-4-2320-4359 Publishing 101-4-2320-4404 Equip Repair/Maint Services 101-4-2320-4433 Dues & Subscriptions TOTAL Other Services & Charges TOTAL Fire Inspections 58.338 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 4,950.00 0.00 2,400.00 48.48 2,550. 00 2,700.00 229.45 1,549.59 57.39 1,150. 41 500.00 103.02 217.59 43.52 282. 41 19,850.00 2,010.42 2,307.87 11.63 17,542. 13 500.00 0.00 301.00 60.20 199. 00 21,300.00 0.00 8,728.00 40.98 12,572. 00 15,150.00 201.88 8,943.34 59.03 6,206. 66 4,000.00 1,070.06 2,426.52 60.66 1,573. 48 20,850.00 9,515.28 14,386.07 69.00 6,463. 93 2,000.00 0.00 1,446.50 72.33 553. 50 15,250.00 764.20 5,349.40 35.08 9,900 .60 107,050.00 13,894.31 48,055.88 44.89 58,994.12 472,200.00 63,371.69 269,046.82 56.98 203,153 .18 132,250.00 9,862.80 73,619.09 55.67 58,630.91 2,000.00 0.00 0.00 0.00 2,000.00 0.00 1,348.80 2,725.70 0.00 ( 2,725.70) 14,700.00 1,092.78 8,255.80 56.16 6,444.20 7,600.00 366.54 2,160.71 28.69 5,419.29 1,900.00 162.95 1,140.70 60.04 759.30 13,700.00 1,078.00 7,802.00 56.95 5,898.00 172,150.00 13,911.87 95,724.00 55.60 76,426.00 1,950.00 0.00 0.00 0.00 1,950.00 3,000.00 201.01 1,350.99 45.03 1,649.01 800.00 128.00 239.78 29.97 560.22 4,150.00 2,416.46 3,176.14 76.53 973.86 9,900.00 2,745.47 4,766.91 48.15 5,133.09 1,350.00 79.62 660.52 48.93 689.48 150.00 0.00 0.00 0.00 150.00 2,750.00 350.00 350.00 12.73 2,400.00 200.00 0.00 0.00 0.00 200.00 1,850.00 100.00 243.35 13.15 1,606.65 500.00 0.00 70.00 14.00 430.00 6,800.00 529.62 1,323.87 19.47 5,476.13 188,850.00 17,186.96 101,814.78 53.91 87,035.22 CITY OF ELK RIVER PAGE: 16 8-12-2009 03:24 PM REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.335 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Emergency Management Personal Services 00 0 985.81 5 60. 16 3,964.19 101-4-2330-4101 Regular Pay 9,950.00 . , 55 927 1,400.00 0.00 472.45 33. 75 . 101-4-2330-4104 PERA 58 86 57 72 63.42 101-4-2330-4107 Medicare 150.00 0.00 . 4 . 32 01 543.96 800.00 0.00 256.0 . 101-4-2330-4108 Insurance 00 0 800.88 6 55. 29 5,499.12 TOTAL Personal Services 12,300.00 . , Supplies 00 0 0. 00 2,500.00 101-4-2330-4201 Office Supplies 2,500.00 0.00 . 7 43 100 8 101-4-2330-4219 Operating Supplies 8,500.00 0.00 399.57 4. 0 . , 11,000.00 0.00 399.57 3. 63 10,600.43 TOTAL Supplies Other Services & Charges 08 1 789.58 52 .64 710.42 101-4-2330-4321 Telephone 1,500.00 . 11 00 100 100.00 0.00 0.00 0 .00 . 101-4-2330-4322 Postage 60 255 13 .82 1,594.40 101-4-2330-4331 Travel, Conferences & Schools 1,850.00 0.00 . 00 500 500.00 0.00 0.00 0 .00 . 101-4-2330-4359 Publishing 44 27 836.00 101-4-2330-4389 Utilities 1,500.00 98.23 664.00 . 1 25 136 2 101-4-2330-4404 Equip Repair/Maint Services 5,100.00 72,78 2,963.75 58 .1 . , 400.00 0.00 200.00 50 .00 200.00 101-4-2330-4433 Dues & Subscriptions 44 50 077.07 6 TOTAL Other Services & Charges 10,950.00 282.09 4,872.93 . , Capital Outlay 14,900.00 0.00 0.00 0.00 14,900.00 101-4-2330-4560 Equipment 14,900.00 0.00 0.00 0.00 14,900.00 TOTAL Capital Outlay TOTAL Emergency Management 49,150.00 282.09 12,073.38 24.56 37,076.62 Building safety Personal Services 300.00 375 24,342.15 233,376. 92 62.18 141,923.08 101-4-2410-4101 Regular Pay , 00 0 500.00 101-4-2410-4102 Overtime Pay 500.00 0.00 0. 00 . 28 57 018.70 10 450.00 23 1,913.10 13,431. 30 . , 101-4-2410-4103 Part-time Pay , 2 541 14 76 53.96 12,408.24 26,950.00 1,772.2 . , 101-4-2410-4104 PERA 00 31 483 1 15,054. 53 60.83 9,695.47 101-4-2410-4105 FICA 24,750. . , 1 520 3 76 60.70 2,279.24 101-4-2410-4107 Medicare 5,800.00 346.9 . , 2 96 635 14 41,600.00 3,034.01 26,964. 04 64.8 . , 101-4-2410-4108 Insurance 987 75 70.55 412.25 101-4-2410-4109 Workers Comp 1,400.00 0.00 . 00 0 350.00 29 101-4-2410-4110 Re-employment Compensation 29,350.00 0.00 0 .00 . , 529,100.00 32,891.70 307,877 .06 58.19 221,222.94 TOTAL Personal Services 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 I 101-GENERAL FUND Public Safety 1 DEPARTMENTAL EXPENDITURES 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-4-2410-4331 Travel, Conferences & Schools 101-4-2410-4361 Insurance 101-4-2410-4404 Equip Repair/Maint Services 101-4-2410-4433 Dues & Subscriptions 101-4-2410-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Building Safety I Environmental Personal Services 101-4-2440-4101 Regular Pay 101-4-2440-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-2440-4201 Office Supplies 101-4-2440-4212 Fuels & Lubs 101-4-2440-4217 Uniform Allowance TOTAL Supplies Other Services & Charges 101-4-2440-4321 Telephorie 101-4-2440-4322 POStage 101-4-2440-4331 Travel, Conferences & Schools 101-4-2440-4359 Publishing 101-4-2440-4361 Insurance 101-4-2440-4404 Equip Repair/Maint Services 101-4-2440-4409 Contractual Services 101-4-2440-4433 Dues & Subscriptions 101-4-2440-4460 Equip Replacement Charge TOTAL Other Services & Charges 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 3,000.00 177.74 695.86 23.20 2,304.14 5,950.00 200.64 1,599.54 26.88 4,350.46 700.00 0.00 0.00 0.00 700.00 2,650.00 288.29 1,348.44 50.88 1,301.56 12,300.00 666.67 3,643.84 29.62 8,656.16 6,900.00 200.94 1,565.40 22.69 5,334.60 1,500.00 128.25 195.99 13.07 1,304.01 9,400.00 20.40 2,317.12 24.65 7,082.88 16,500.00 0.00 14,513.50 87.96 1,986.50 9,400.00 237.32 4,110.09 43.72 5,289.91 1,200.00 100.00 475.00 39.58 725.00 2,300.00 126.48 885.36 38.49 1,414.64 47,200.00 813.39 24,062.46 50.98 23,137.54 588,600.00 34,371.76 335,583.36 57.01 253,016.64 52,200.00 3,999.08 28,378.40 54.36 23,821.60 3,500.00 269.94 2,032.84 58.08 1,467.16 3,200.00 180.97 1,400.36 43.76 1,799.64 750.00 42.34 327.56 43.67 422.44 8,450.00 669.60 4,738.40 56.08 3,711.60 350.00 0.00 294.00 84.00 56.00 68,450.00 5,161.93 37,171.56 54.30 31,278.44 650.00 113.53 215.20 33.11 434.80 200.00 0.00 21.15 10.58 178.85 200.00 0.00 0.00 0.00 200.00 1,050.00 113.53 236.35 22.51 613.65 700.00 48.82 307.82 43.97 392.18 500.00 265.44 350.66 70.13 149.34 500.00 0.00 94.07 18.81 405.93 500.00 0.00 0.00 0.00 500.00 300.00 0.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 750.00 36.74 257.18 34.29 492.82 5,850.00 351.00 1,121.73 19.17 4,728.27 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Environmental 75,350.00 5,626.46 38,529.64 51.13 36,820.36 TOTAL Public Safety Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 101-4-3120-4102 Overtime Pay 101-4-3120-4103 Part-time Pay 101-4-3120-4104 PERA 101-4-3120-4105 FICA 101-4-3120-4107 Medicare 101-4-3120-4108 Insurance 101-4-3120-4109 Workers Comp TOTAL Personal Services Supplies 101-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-4359 Publishing 101-4-3120-4361 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-4460 Equip Replacement Charge TOTAL Other Services & Charges 5,586,300.00 426,767.69 2,886,030.44 51.66 2,700,269.56 391,850.00 40,328.40 245,065.31 62.54 146,784.69 10,400.00 0.00 0.00 0.00 10,400.00 78,950.00 8,116.32 35,788.53 45.33 43,161.47 31,050.00 2,966.04 18,743.05 60.36 12,306.95 28,750.00 2,800.30 16,748.13 58.25 12,001.87 6,700.00 654.90 3,916.73 58.46 2,783.27 50,400.00 5,724.79 34,717.98 68.88 15,682.02 20,000.00 0.00 14,768.25 73.84 5,231.75 618,100.00 60,590.75 369,747.98 59.82 248,352.02 4,800.00 47.99 557.40 11.61 4,242.60 82,950.00 ( 4,973.22) 21,084.00 25.42 61,866.00 160,000.00 12,590.13 60,391.98 37.74 99,608.02 17,500.00 720.54 20,331.39 116.18 ( 2,831.39) 265,250.00 8,385.44 102,364.77 38.59 162,885.23 950.00 0.00 152.00 16.00 798.00 9,450.00 424.86 2,634.66 27.88 6,815.34 200.00 43.54 61.83 30.92 138.17 3,000.00 95.00 1,873.87 62.46 1,126.13 500.00 82.50 82.50 16.50 417.50 18,250.00 0.00 7,963.50 43.64 10,286.50 33,000.00 2,507.95 20,453.88 61.98 12,546.12 6,500.00 0.00 673.69 10.36 5,826.31 0.00 291.16 1,949.43 0.00 ( 1,949.43) 199,000.00 2,737.58 11,737.96 5.90 187,262.04 3,500.00 95.85 575.10 16.43 2,924.90 4,850.00 417.17 1,857.30 38.29 2,992.70 700.00 0.00 241.25 34.46 458.75 500.00 0.00 0.00 0.00 500.00 130,200.00 6,517.73 45,624.11 35.04 84,575.89 410,600.00 13,213.34 95,881.08 23.35 314,718.92 ~ 8-12-2009 03:24 PM I 101-GENERAL FUND Public Works I DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 PAGE: 19 58.33 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 TOTAL Street Maintenance Snow Removal Personal Services 101-4-3130-4101 Regular Pay 101-4-3130-4102 Overtime Pay 101-4-3130-4104 PERA 101-4-3130-4105 FICA 101-4-3130-4107 Medicare 101-4-3130-4106 Insurance 101-4-3130-4109 Workers Comp TOTAL Personal Services Supplies 101-4-3130-4219 Operating Supplies TOTAL Supplies Capital Outlay 101-4-3130-4560 Equipment TOTAL Capital Outlay 6,700.00 0.00 2,662.50 39.74 4,037.50 6,700.00 0.00 2,662.50 39.74 4,037.50 1,300,650.00 82,189.53 570,656.33 43.87 729,993.67 159,150.00 0.00 51,121.00 32.12 108,029.00 12,450.00 0.00 401.74 3.23 12,048.26 11,800.00 0.00 4,843.68 41.05 6,956.32 10,950.00 0.00 4,203.11 38.38 6,746.89 2,550.00 0.00 982.97 38.55 1,567.03 21,300.00 0.00 8,908.07 41.82 12,391.93 6,550.00 0.00 5,170.50 78.94 1,379.50 224,750.00 0.00 75,631.07 33.65 149,118.93 79,000.00 0.00 72,994.83 92.40 6,005.17 79,000.00 0.00 72,994.83 92.40 6,005.17 5,000.00 0.00 0.00 0.00 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Snow Removal Equipment Services Personal Services 101-4-3150-4101 Regular Pay 101-4-3150-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 308,750.00 0.00 148,625.90 48.14 160,124.10 165,200.00 12,520.00 86,082.69 52.11 79,117.31 2,500.00 0.00 0.00 0.00 2,500.00 11,3.00.00 845.10 6,039.04 53.44 5,260.96 10,400.00 679.90 4,925.14 47.36 5,474.86 2,450.00 159.02 1,151.89 47.02 1,298.11 23,000.00 1,920.03 ~ 12,441.79 54.09 10,556.21 5,250.00 0.00 4,266.00 81.26 984.00 220,100.00 16,124.05 114,906.55 52.21 105,193.45 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Public Works DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET 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 1,086.13 6,179.57 37.80 10,170.43 9,200.00 0.00 431.42 4.69 8,768.58 25,550.00 1,086.13 6,610.99 25.87 18,939.01 2,000.00 788.03 788.03 39.40 1,211.97 2,800.00 227.16 1,471.90 52.57 1,328.10 4,800.00 1,015.19 2,259.93 47.08 2,540.07 TOTAL Equipment Services Engineering 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-4404 Equip Repair/Maint Services 101-4-3300-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Engineering 250,450.00 18,225.37 123,777.47 49.42 126,672.53 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 126.75 126.75 ( 26.75) 64,400.00 0.00 126.75 0.20 64,273.25 850.00 34.83 159.29 18.74 690.71 350.00 0.00 76.08 21.74 273.92 9,850.00 0.00 1,750.00 17.77 8,100.00 11,050.00 34.83 1,985.37 17.97 9,064.63 88,000.00 7,706.79 39,038.96 44.36 48,961.04 20,000.00 1,645.00 7,875.00 39.38 12,125.00 750.00 0.38 8.26 1.10 741.74 200.00 16.36 24.60 12.30 175.40 5,200.00 0.00 60.00 1.15 5,140.00 300.00 0.00 112.00 37.33 188.00 500.00 0.00 405.20 81.04 94.80 750.00 36.74 257.18 34.29 492.82 115,700.00 9,405.27 47,781.20 41.30 67,918.80 191,150.00 9,440.10 49,893.32 26.10 141,256.68 TOTAL Public Works 2,051,000.00 109,855.00 892,953.02 43.54 1,158,046.98 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 101-GENERAL FUND Culture & Recreation ~ DEPARTMENTAL EXPENDITURES Parks-Department Personal Services 101-4-5110-4101 Regular Pay 101-4-5110-4102 Overtime Pay 101-4-5110-4103 Part-time Pay 101-4-5110-4104 PERA 101-4-5110-4105 FICA 101-4-5110-4107 Medicare 101-4-5110-4108 Insurance 101-4-5110-4109 Workers Comp 101-4-5110-4110 Re-employment Compensation TOTAL Personal Services Supplies 101-4-5110-4212 Fuels & Lubs 101-4-5110-4217 Uniform Allowance 101-4-5110-4219 Operating Supplies TOTAL Supplies Other Services & Charges 101-4-5110-4321 Telephone 101-4-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-4409 Contractual Services 101-4-5110-4415 Equipment Rental 101-4-5110-4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Parks Department Parks & Rec Admire 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 338,150.00 27,615.35 184,232.80 54.48 153,917.20 1,000.00 0.00 0.00 0.00 1,000.00 43,350.00 6,643.09 20,981.03 48.40 22,368.97 23,850.00 1,864.03 13,317.80 55.84 10,532.20 24,150.00 1,954.93 12,156.81 50.34 11,993.19 5,650.00 457.19 2,843.09 50.32 2,806.91 51,200.00 3,848.22 24,833.71 48.50 26,366.29 6,500.00 0.00 5,778.00 88.89 722.00 0.00 0.00 599.56 0.00 ( 599.56) 493,850.00 42,382.81 264,742.80 53.61 229,107.20 31,350.00 894.81 8,140.17 25.97 23,209.83 3,200.00 125.69 1,632.05 51.00 1,567.95 68,550.00 7,128.15 41,373.50 60.36 27,176.50 103,100.00 8,148.65 51,145.72 49.61 51,954.28 3,900.00 425.22 2,327.45 59.68 1,572.55 2,550.00 14.86 1,962.86 76.97 587.14 27,000.00 0.00 11,810.00 43.74 15,190.00 15,050.00 5,085.79 10,616.09 70.54 4,433.91 5,500.00 0.00 108.75 1.98 5,391.25 13,500.00 2,180.38 3,917.82 29.02 9,582.18 6,100.00 6,124.90 6,620.45 108.53 ( 520.45) 24,500.00 2,024.89 7,040.49 28.74 17,459.51 38,100.00 1,837.86 12,865.02 33.77 25,234.98 136,200.00 17,693.90 57,268.93 42.05 78,931.07 733,150.00 68,225.36 373,157.45 50.90 359,992.55 Personal Services 101-4-5210-4101 Regular Pay 335,550.00 23,427.66 174,580.89 52. 03 160,969.11 101-4-5210-4102 Overtime Pay 700.00 0.00 0.00 0. 00 700.00 101-4-5210-4103 Part-time Pay 21,150.00 1,880.41 15,185.09 71. 80 5,964.91 101-4-5210-4104 PERA 24,150.00 1,727.88 13,459.95 55. 73 10,690.05 101-4-5210-4105 FICA 22,200.00 1,545.78 11,796.14 53. 14 10,403.86 101-4-5210-4107 Medicare 5,200.00 361.48 2,758.65 53. 05 2,441.35 101-4-5210-4108 Insurance 39,850.00 2,799.97 21,300.32 53 .45 18,549.68 101-4-5210-4109 Workers Comp 4,950.00 0.00 2,378.25 48 .05 2,571.75 TOTAL Personal Services 453,750.00 31,743.18 241,459.29 53 .21 212,290.71 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 I 101-GENERAL FUND Culture & Recreation ~ DEPARTMENTAL EXPENDITURES 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-4401 Bldg Repair/Maint Services 101-4-5210-4404 Equip Repair/Maint Services 101-4-5210-4433 Dues & Subscriptions TOTAL Other Services & Charges CURRENT CURRENT BUDGET PERIOD 58.33% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 12,900.00 717.63 8,068.02 62.70 4,811.98 12,900.00 717.63 8,088.02 62.70 4,811.98 4,100.00 279.23 1,990.36 48 .55 2,109.64 6,000.00 148.18 2,135.79 35 .60 3,864.21 5,650.00 631.63 2,281.87 40 .39 3,368.13 26,400.00 0.00 11,500.40 43 .56 14,899.60 1,500.00 0.00 714.00 47 .60 786.00 7,800.00 318.84 7,113.15 91 .19 686.85 14,950.00 1,048.07 7,115.70 47 .60 7,834.30 6,750.00 727.63 3,988.65 59 .09 2,761.35 1,650.00 0.00 1,310.00 79 .39 340.00 74,800.00 3,153.58 38,149.92 51 .00 36,650.08 TOTAL PdrkS & Rec Admire ROCredtlOri 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 101-4-5220-4404 Equip Repair/Maint Services 101-4-5220-4409 Contractual Services 101-4-5220-4412 Building Rerit 101-4-5220-4438 Credit Cdrd Fees TOTAL Other Services & Charges 541,450.00 35,614.39 287,697.23 53.13 253,752.77 0.00 0.00 1,195.07 0.00 ( 1,195.07) 80,000.00 14,409.32 53,564.73 66.96 26,435.27 1,600.00 269.05 1,414.67 88.42 185.33 4,500.00 832.50 3,468.75 77.08 1,031.25 1,300.00 194.72 811.33 62.41 488.67 0.00 0.00 290.00 0.00 ( 290.00) 87,400.00 15,705.59 60,744.55 69.50 26,655.45 24,000.00 4,154.08 14,099.93 58.75 9,900.07 24,000.00 4,154.08 14,099.93 58.75 9,900.07 400.00 0.00 239.63 59. 91 160.37 47,000.00 20,856.11 38,743.74 82. 43 8,256.26 2,500.00 1,492.00 2,919.00 116. 76 ( 419.00) 3,000.00 251.70 2,817.48 93. 92 182.52 52,900.00 22,599.81 44,719.85 84. 54 8,180.15 TOTAL Recreation Programs 164,300.00 42,459.48 119,564.33 72.77 44,735.67 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 I 101-GENERAL FUND Culture & Recreation I DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Concessions Pe rsOrial S8rV1Ce9 101-4-5230-4103 Part-time Pay 4,750.00 620.26 2,435.43 51.27 2,314.57 101-4-5230-4104 PERA 250.00 0.00 31.82 12.73 218.18 101-4-5230-4105 FICA 300.00 38.45 150.96 50.33 149.02 101-4-5230-4107 Medicare 100.00 9.00 35.32 35.32 64.68 TOTAL Personal Services 5,400.00 667.71 2,653.55 49.14 2,746.45 Supplies 101-4-5230-4219 Operating Supplies 600.00 0.00 35.04 5.84 564.96 101-4-5230-4259 Other Merchandise For Resale 13,400.00 451.79 4,540.97 33.89 8,859.03 TOTAL Supplies 14,000.00 451.79 4,576.01 32.69 9,423.99 Other Services & Charges 101-4-5230-4401 Bldg Repair/Maint Services 100.00 79.88 79.88 79.88 20.12 TOTAL Other Services & Charges 100.00 79.88 79.88 79.88 20.12 TOTAL Concessions Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 101-4-5510-4102 Overtime Pay 101-4-5510-4103 Part-time Pay 101-4-5510-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 & SChOO19 101-4-5510-4361 Insurance 101-4-5510-4389 Utilities 101-4-5510-4401 Bldg Repair/Maint Services 101-4-5510-4409 Contractual Services 101-4-5510-4433 Dues & Subscriptions TOTAL Other Services & Charges 19,500.00 1,199.38 7,309.44 37.48 12,190.56 54,950.00 4,191.36 29,098.89 52.96 25,851.11 500.00 0.00 0.00 0.00 500.00 58,700.00 4,540.14 31,545.44 53.74 27,154.56 7,700.00 589.37 4,308.18 55.95 3,391.82 7,100.00 502.84 3,697.04 52.07 3,402.96 1,650.00 117.61 864.70 52.41 785.30 12,400.00 1,034.22 7,239.54 58.38 5,160.46 700.00 0.00 279.00 39.86 421.00 143,700.00 10,975.54 77,032.79 53.61 66,667.21 10,950.00 1,423.23 6,638.49 60.63 4,311.51 10,950.00 1,423.23 6,638.49 60.63 4,311.51 2,400.00 207.55 1,442.15 60.09 957.85 4,000.00 208.63 1,350.96 33.77 2,649.04 2,400.00 0.00 597.29 24.89 1,802.71 900.00 0.00 775.50 86.17 124.50 8,150.00 567.98 5,139.45 63.06 3,010.55 11,800.00 603.89 6,070.17 51.44 5,729.83 8,100.00 4,516.00 4,209.29 51.97 3,890.71 950.00 279.84 519.31 54.66 430.69 36,700.00 6,383.89 20,104.12 51.95 18,595.68 8-12-2009 03:24 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 ` 101-GENERAL FUND I Culture & Recreation I DEPARTMENTAL EXPENDITURES 58.338 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE =s OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Sr Citizen Programs TOTAL Culture & Recreation ECOriOmic Development 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-4322 Postage 101-4-6210-4361 Insurance 101-4-6210-4440 Miscellaneous TOTAL Other Services & Charges 193,350.00 18,782.66 103,775.40 53.67 89,574.60 1,651,750.00 166,281.27 891,503.85 53.97 760,246.15 0.00 ( 22,899.05) 12,406.57 0.00 ( 12,406.57) 0.00 ( 1,050.32) 2,100.64 0.00 ( 2,100.64) 0.00 ( 1,568.23) 882.48 0.00 ( 882.48) 0.00 ( 1,389.28) 830.39 0.00 ( 630.39) 0.00 ( 324.92) 194.23 0.00 ( 194.23) 0.00 ( 2,158.73) 891.27 0.00 ( 891.27) 0.00 ( 203.70)( 59.20) 0.00 59.20 0.00 ( 29,594.23) 17,246.38 0.00 ( 17,246.38) 0.00 ( 64.67) 46.08 0.00 ( 46. 08) 0.00 ( 689.25)( 689.25) 0.00 689. 25 0.00 0.26 724.77 0.00 ( 724. 77) 0.00 ( 753.66) 81.60 0.00 ( 81 .60) TOTAL Economic Development Energy City Personal Services 101-4-6220-4101 Regular Pay 101-4-6220-4104 PERA 101-4-6220-4105 FICA 101-4-6220-4107 Medicare 101-4-6220-4108 Insurance TOTAL Personal Services other Services & Charges 101-4-6220-4319 Other Professional Services 101-4-6220-4331 Travel, Conferences & Schools 101-4-6220-4359 Publishing TOTAL Other Services & Charges 0.00 ( 30,347.89) 17,327.98 0.00 ( 17,327.98) 27,250.00 2,075 .11 14,876.37 54. 59 12,373 .63 1,550.00 140 .06 1,052.47 67. 90 497 .53 1,500.00 97 .20 750.03 50. 00 749 .97 400.00 22 .74 175.41 43. 85 224 .59 3,600.00 300 .01 2,074.46 57. 62 1,525 .54 34,300.00 2,635 .12 18,928.74 55. 19 15,371 .26 2,000.00 200.00 200. 00 10.00 1,800.00 17,000.00 2,336.00 ( 900. 63) 5.30- 17,900.63 2,500.00 65.20 2,469. 74 98.79 30.26 21,500.00 2,601.20 1,769. 11 8.23 19,730.69 TOTAL Energy City 55,800.00 5,236.32 20,697.85 37.09 35,102.15 TOTAL Economic Development 55,800.00 ( 25,111.57) 38,025.83 68.15 17,774.17 8-12-2009 03:24 PM 101-GENERAL FUND General DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 PAGE: 25 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET 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 0.00 66,600.00 100. 00 0 .00 TOTAL Transfers Out 229,300.00 0.00 66,600.00 29. 04 162,700.00 TOTAL Transfers Out 229,300.00 0.00 66,600.00 29. 04 162,700 .00 TOTAL General 229,300.00 0.00 66,600.00 29. 04 162,700 .00 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 12,207,550.00 861,658.12 6,074,891.58 49.76 6,132,658.42 428,550.00 1,228,987.69 118,678.86 309,871.14 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 I 221-ICE ARENA FINANCIAL SUMMARY CURRENT CURRENT BUDGET PERIOD 58.33°s OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arend 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 10,819. 01 230,238,63 31.32 504,761.37 70,000.00 9,206. 00 39,422.00 56.32 30,578.00 84,700.00 6,333. 00 45,520.90 53.74 39,179.10 73,000.00 0.00 31,545.98 43.21 41,454.02 962,700.00 26,358. 01 346,727.51 36.02 615,972.49 847,900.00 31,298.96 292,340.18 34. 48 555,559.82 30,150.00 351.81 13,255.29 43. 96 16,894.71 34,450.00 300.58 16,586.68 48. 15 17,863.32 50,200.00 ( 58.25) 20,301.33 40. 44 29,898.67 962,700.00 31,893.10 342,483.48 35. 58 620,216.52 962,700.00 31,893.10 342,483.48 35 .58 620,216.52 0.00 ( 5,535.09) 4,244.03 ( 4,244.03) 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 ~ 221-ICE ARENA REVENUES 58.33 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 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 221-3-5420-3465 Admissions TOTAL Charges for Services 432,000.00 9,207.00 194,170.37 44.95 237,829. 63 33,000.00 520.00 12,695.14 38.47 20,304. 86 15,000.00 584.00 9,336.09 62.24 5,663. 91 4,500.00 60.00 2,628.00 58.40 1,872. 00 2,600.00 0.00 0.00 0.00 2,600. 00 18,500.00 0.00 ( 85.00) 0.46- 18,585.00 505,600.00 10,371.00 218,744.60 43.26 286,855. 40 22,000.00 441.01 7,138.80 32.45 14,861. 20 0.00 0.00 3,443.00 0.00 ( 3,443. 00) 2,000.00 7.00 912.23 45.61 1,087. 77 24,000.00 448.01 11,494.03 47.89 12,505. 97 100,000.00 0.00 0.00 0.00 100,000. 00 105,400.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 10,819.01 230,238.63 31.32 504,761 .37 70,000.00 9,206.00 39,422.00 56.32 30,578.00 70,000.00 9,206.00 39,422.00 56.32 30,578.00 70,000.00 9,206.00 39,422.00 56.32 30,578.00 84,700.00 6,333.00 40,174.50 47.43 44,525.50 0.00 0.00 3,586.00 0.00 ( 3,586.00) 84,700.00 6,333.00 43,760.50 51.67 40,939.50 8-12-2009 03:25 PM 221-ICE ARENA REVENUES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 PAGE: 3 58.335 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 0.00 1,760. 40 0.00 ( 1,760.40) TOTAL Other Revenue 0.00 0.00 1,760. 40 0.00 ( 1,760.40) TOTAL Skating 84,700.00 6,333.00 45,520. 90 53.74 39,179.10 Concessions Charges for Services 221-3-5430-3467 Concessions 73,000.00 0.00 31,545 .98 43.21 41,454.02 TOTAL Charges for Services 73,000.00 0.00 31,545 .98 43.21 41,454.02 TOTAL Concessions 73,000.00 0.00 31,545 .98 43.21 41,454.02 1 TOTAL REVENUE 962,700.00 26,356.01 346,727.51 36.02 615,972.49 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 221-ICE ARENA I DEPARTMENTAL EXPENDITURES ICe Areria Personal Services 221-4-5400-4101 Regular Pay 221-4-5400-4102 Overtime Pay 221-4-5400-4103 Part-time Pay 221-4-5400-4104 PERA 221-4-5400-4105 FICA 221-4-5400-4107 Medicare 221-4-5400-4108 Insurance 221-4-5400-4109 Workers Comp TOTAL Personal Services 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE g OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 150,300.00 10,518.65 83,594.60 55.62 66,705.40 0.00 0.00 6.38 0.00 ( 6.38) 72,850.00 2,146.97 31,868.48 43.75 40,981.52 11,350.00 854.94 7,817.64 68.88 3,532.36 14,150.00 770.68 7,523.96 53.17 6,626.04 3,300.00 180.24 1,759.63 53.32 1,540.37 16,600.00 1,121.82 9,721.90 56.57 6,878.10 4,350.00 0.00 3,349.50 77.00 1,000.50 272,900.00 15,593.30 145,642.09 53.37 127,257.91 Supplies 221-4-5400-4212 Fuels & Lubs 300.00 221-4-5400-4217 Uniform Allowance 1,500.00 221-4-5400-4219 Operating Supplies 41,100.00 221-4-5400-4255 Soft Drinks/Misc 13,500.00 221-4-5400-4259 Other Merchandise For Resale 1,200.00 TOTAL Supplies 57,600.00 Other Services & Charges 221-4-5400-4321 Telephone 221-4-5400-4322 Postage 221-4-5400-4331 Travel, Conferences & Schools 221-4-5400-4359 Publishing 221-4-5400-4361 Insurance 221-4-5400-4389 Utilities 221-4-5400-4401 Bldg Repair/Maint Services 221-4-5400-4409 Contractual Services 221-4-5400-4415 Equipment Rental 221-4-5400-4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221-4-5400-4520 Buildings & Structures TOTAL Capital Outlay Transfers Out 221-4-5400-4730 Transfer-Debt Service TOTAL Transfers Out 0.00 ( 202.93) 129.50 427.85 3,413.64 15,593.40 0.00 4,411.93 0.00 221.85 3,543.14 20,452.10 2,900.00 217. 19 500.00 47. 76 1,050.00 109. 52 2,000.00 0. 00 9,000.00 0. 00 175,850.00 8,609 .83 19,750.00 3,178 .22 2,000.00 0 .00 5,400.00 0 .00 450.00 0 .00 218,900.00 12,162 .52 100,000.00 0.00 100,000.00 0.00 67. 64- 502. 93 28. 52 1,072. 15 37. 94 25,506. 60 32. 68 9,088. 07 18. 49 978. 15 35. 51 37,147. 90 1,383.60 47.71 1,516.40 108.54 21.71 391.46 258.52 24.62 791.48 2,046.06 102.30 ( 46.06) 4,047.50 44.97 4,952.50 82,320.95 46.81 93,529.05 10,093.97 51.11 9,656.03 280.41 14.02 1,719.59 1,293.94 23.96 4,106.06 187.50 41.67 262.50 102,020.99 46.61 116,879.01 0.00 0.00 100,000.00 0.00 0.00 100,000.00 198,500.00 0.00 24,225.00 12.20 174,275.00 198,500.00 0.00 24,225.00 12.20 174,275.00 TOTAL Ice Arena 847,900.00 31,298.96 292,340.18 34.48 555,559.82 ~ 8-12-2009 03:25 PM I 221-ICE ARENA Culture & Recreation ~ DEPARTMENTAL EXPENDITURES 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-4-5410-4438 Credit Card Fees TOTAL Other Services & Charges CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 3,600.00 0.00 154.00 4.28 3,446.00 200.00 0.00 9.55 4.78 190.45 50.00 0.00 2.23 4.46 47.77 3,850.00 0.00 165.78 4.31 3,684.22 14,850.00 0.00 7,200.60 48.49 7,649.40 14,850.00 0.00 7,200.60 48.49 7,649.40 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 315.20 4,450.80 63.13 2,599.20 2,200.00 36.61 1,438.11 65.37 761.89 11,450.00 351.81 5,888.91 51.43 5,561.09 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-5420-4322 Postage 221-4-5420-4359 Publishing 221-4-5420-4409 Contractual Services 221-4-5420-4438 Credit Card Fees TOTAL Other Services & Charges 30,150.00 351.81 13,255.29 43.96 16,894.71 20,000.00 0.00 9,013.36 45.07 10,986.64 500.00 0.00 428.60 85.72 71.40 1,250.00 0.00 575.90 46.07 674.10 300.00 0.00 134.67 44.89 165.33 22,050.00 0.00 10,152.53 46.04 11,897.47 6,000.00 0.00 3,407.71 56.80 2,592.29 6,000.00 0.00 3,407.71 56.80 2,592.29 200.00 0.00 0.00 0.00 200.00 1,300.00 0.00 358.91 27.61 941.09 2,450.00 120.80 1,704.58 69.57 745.42 2,450.00 179.78 962.95 39.30 1,487.05 6,400.00 300.58 3,026.44 47.29 3,373.56 ' TOTAL Skating 34,450.00 300.58 16,586.68 48.15 17,863.32 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 221-ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arend COriC2SSlOris Personal Services 221-4-5430-4103 Part-time Pay 20,900.00 0.00 6,780.08 32.44 14,119.92 221-4-5430-4104 PERA 0.00 0.00 177.00 0.00 ( 177.00) 221-4-5430-4105 FICA 1,300.00 0.00 440.72 33.90 859.28 221-4-5430-4107 Medicare 300.00 0.00 103.07 34.36 196.93 TOTAL Personal Services 22,500.00 0.00 7,500.87 33.34 14,999.13 Supplies 221-4-5430-4219 Operating Supplies 6,700.00 0.00 711.28 10.62 5,988.72 221-4-5430-4259 Other Merchandise For Resale 21,000.00 ( 58.25) 12,089.18 57.57 8,910.82 TOTAL Supplies 27,700.00 ( 58.25) 12,800.46 46.21 14,899.54 I TOTAL Arena Concessions 50,200.00 ( 58.25) 20,301.33 40.44 29,898.67 I TOTAL Culture & Recreation 962,700.00 31,893.10 342,483.48 35.58 620,216.52 ~ TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 962,700.00 31,893.10 342,483. 48 35.58 620,216.52 0.00 ( 5,535.09) 4,244. 03 ( 4,244.03) 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 I 222-PINEWOOD GOLF COURSE FINANCIAL SUMMARY 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Pinewood Golf Course TOTAL REVENUES ' EXPENDITURE SUMMARY Culture & Recreation Golf Course TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 254,800.00 34,394.40 143,445.66 56.30 111,354. 34 254,800.00 34,394.40 143,445.66 56.30 111,354 .34 254,800.00 26,621.55 153,449.83 60.22 101,350. 17 254,800.00 26,621.55 153,449.83 60.22 101,350. 17 254,800.00 26,621.55 153,449.83 60.22 101,350. 17 0.00 7,772.85 ( 10,004.17) 10,004 .17 8-12-2009 03:25 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 ~ 222-PINEWOOD GOLF COURSE I REVENUES 58.33 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Pinewood Golf Course Charges for Services 222-3-0000-3461 Recreation Fees 222-3-0000-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-3479 Tournaments 222-3-0000-3482 Advertising fee TOTAL Charges for Services Other Revenue 222-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 222-3-0000-3792 Cash Over TOTAL Sales Transfers In 222-3-0000-3922 Transfer-General Fund TOTAL Transfers In TOTAL Pinewood Golf Course 20,000.00 371.00 20,423.05 102. 12 ( 423.05) 19,000.00 4,385.29 12,168.73 64. 05 6,831.27 4,000.00 825.67 3,773.82 94. 35 226.18 112,000.00 24,043.57 77,365.24 69. 08 34,634.76 18,000.00 0.00 14,230.00 79. 06 3,770.00 19,000.00 4,395.78 12,310.78 64. 79 6,689.22 0.00 525.00 2,713.51 0. 00 ( 2,713.51) 500.00 0.00 400.00 80. 00 100.00 192,500.00 34,546.31 143,385.13 74. 49 49,114.87 0.00 ( 131.00) 74.50 0 .00 ( 74.50) 0.00 ( 131.00) 74.50 0 .00 ( 74.50) 0.00 ( 20.91)( 13.97) 0 .00 13.97 0.00 ( 20.91)( 13.97) 0 .00 13.97 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 34,394.40 143,445.66 56.30 111,354.34 ~ TOTAL REVENUE 254,800.00 34,394.40 143,445.66 56.30 111,354.34 8-12-2009 03:25 PM CITY OF ELK RIVER - PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2009 222-PINEWOOD GOLF COURSE DEPARTMENTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.33 OF YEAR COMP. YEAR TO DATE ~ OF BUDGET ACTUAL BUDGET BALANCE Golf Course Personal Services 222-4-5300-4101 Regular Pay 89,300.00 7,498.11 50,927.33 57.03 38,372. 67 222-4-5300-4102 Overtime Pay 100.00 0.00 169.38 169.38 ( 69. 38) 222-4-5300-4103 Part-time Pay 28,650.00 7,680.61 18,309.76 63.91 10,340. 24 222-4-5300-4104 PERA 8,100.00 653.19 4,049.89 50.00 4,050. 11 222-4-5300-4105 FICA 7,450.00 925.46 4,414.16 59.25 3,035. 84 222-4-5300-4107 Medicare 1,750.00 216.44 1,032.37 58.99 717. 63 222-4-5300-4108 Insurance 9,200.00 876.00 5,842.00 63.50 3,358. 00 222-4-5300-4109 Workers Comp 1,050.00 0.00 882.00 84.00 168. 00 TOTAL Personal Services 145,600.00 17,849.81 85,626.89 58.81 59,973. 11 Supplies 222-4-5300-4212 Fuels & Lubs 5,000.00 731.30 1,983.54 39.67 3,016. 46 222-4-5300-4217 Uniform Allowance 500.00 0.00 353.63 70.73 146. 37 222-4-5300-4219 Operating Supplies 25,100.00 3,697.76 10,973.70 43.72 14,126 .30 222-4-5300-4259 Other Merchandise For Resale 10,800.00 2,494.25 9,932.49 91.97 867 .51 TOTAL Supplies 41,400.00 6,923.31 23,243.36 56.14 18,156 .64 Other Services & Charges 222-4-5300-4321 Telephone 2,500.00 223.86 1,107.81 44.31 1,392 .19 222-4-5300-4331 Travel, Conferences & Schools 400.00 0.00 381.60 95.40 18 .40 222-4-5300-4349 Advertising/Marketing 1,500.00 0.00 159.75 10.65 1,340 .25 222-4-5300-4361 Insurance 11,550.00 0.00 5,146.50 44.56 6,403 .50 222-4-5300-4389 Utilities 6,800.00 875.84 2,630.76 38.69 4,169 .24 222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 244.42 344.27 17.21 1,655 .73 222-4-5300-4404 Equip Repair/Maint Services 2,500.00 136.00 1,090.45 43.62 1,409 .55 222-4-5300-4415 Equipment Rental 36,050.00 332.26 1,014.88 2.82 35,035 .12 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 2,262.32)( 3,211.29) 321.13- 4,211 .29 222-4-5300-4438 Credit Card Fees 3,500.00 882.37 2,697.37 77.07 802 .63 TOTAL Other Services & Charges 67,800.00 432.43 11,362.10 16.76 56,437 .90 Debt Service 222-4-5300-4601 Principal 0.00 1,416.00 33,217.48 0.00 ( 33,217 .48) TOTAL Debt S ervice 0.00 1,416.00 33,217.48 0.00 ( 33,217 .48) TOTAL Golf Course 254,800.00 26,621.55 153,449.83 60.22 101,350.17 TOTAL Culture & Recreation 254,800.00 26,621.55 153,449.83 60.22 101,350.17 TOTAL EXPENDITURES 254,800.00 26,621.55 153,449.83 60.22 101,350.17 REVENUES OVER/(UNDER) EXPENDITURES 0.00 7,772.85 ( 10,004.17) 10,004.17 8-12-2009 03:27 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JULY 31ST, 2009 FUND ACCOUNT# ACCOUNT NAME BEGINNING CURRENT CURRENT BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 101-1010 Cash - General Fund 211-1010 cash - Library 221-1010 Cash - Ice Arena 222-1010 Cash - Pinewood Golf Course 223-1010 Cash - Sr Citizen Account 225-1010 Cash - Park Dedication 228-1010 Cash - Landfill 231-1010 Cash - Landfill Const Debris 240-1010 CdSh - MiCYO Loan Fund 241-1010 Cash - DTED Loan 245-1010 Cash - Development Fund 290-1010 Cash - Capital Outlay Reserve 291-1010 Cash - Insurance Reserve 292-1010 Cash - Govt Bldgs Reserve 294-1010 Cash - Drug Forfeiture 295-1010 Cash - Severance Pay Reserve 296-1010 Cash - NSP/RDF Reserve 308-1010 Cash - 1999A GO Bonds 311-1010 Cash - 2003A GO Bonds 312-1010 Cash - 2005A GO Bonds 313-1010 Cash - 2007C GO Bonds 331-1010 Cash - 1994C Storm Sewer Bonds 333-1010 Cash - 2002A Pub Safety Bonds 340-1010 Cash - Equipment Certificates 350-1010 Cash - State-Aid Road Bonds 375-1010 Cash - TIF #19 East Elk River 401-1010 Cash - Capital Projects 403-1010 Cash - Street Improvement Resr 404-1010 Cash - Surface Water Managemnt 405-1010 Cash - NE Area Trunk Utilities 406-1010 Cash - City Wide Trunk Util 410-1010 Cash - Equipment Replacement 426-1010 Cash - YMCA 427-1010 Cash - 193rd Avenue 440-1010 Cash - Park Improvement 459-1010 Cash - TIF #19 Highway 169 462-1010 Cash - TIF #22 Downtown Redev 602-1010 Cash - Wastewater Treatment 603-1010 Cash - Liquor 605-1010 Cash - Garbage 801-1010 Cash - Interest 821-1010 Cash - Developer Escrow TOTAL CLAIM ON CASH 31,873.16 347.86 32,221.02 4,063,907.00 1,217,986.93 5,281,893.93 394,146.97 4,991.13 399,138.10 41,160.12 ( 2,480.09) 38,680.03 ( 15,973.39) 7,511.86 ( 8,461.53) 11,494.80 ( 1,237.76) 10,257.04 ( 79,699.55) ( 1,349.20) ( 81,048.75) 1,308,302.04 ( 39,476.79) 1,268,825.25 668,754.69 0.00 668,754.69 814,280.63 13,922.92 828,203.55 151,531.91 0.00 151,531.91 159,363.38 ( 56,935.46) 102,427.92 1,385,578.44 ( 8,693.27) 1,376,885.17 534,314.96 ( 737.16) 533,577.80 1,998,400.53 5,241.14 2,003,641.67 6,856.19 3,077.55 9,933.74 139,174.67 0.00 139,174.67 674,316.74 ( 39,500.00) 634,816.74 20,000.00 15,000.00 35,000.00 134,608.92 29,349.19 163,958.11 141,583.02 34,961.73 176,544.75 226,778.18 155,186.85 381,965.03 112,737.97 17,364.08 130,102.05 384,115.19 ( 44,033.02) 340,082.17 126,958.58 43,806.03 170,764.61 0.00 476,253.05 476,253.05 ( 77,731.25) 88,902.50 11,171.25 2,018,434.17 222,202.77 2,240,636.94 2,833,227.17 34,578.61 2,867,805.78 197,652.15 7,868.29 205,520.44 268,337.56 0.00 268,337.56 3,425,171.89 ( 87,282.08) 3,337,889.81 956,671.00 51,473.08 1,008,144.08 1,805,221.85 ( 250,000.00) 1,555,221.85 ( 364,338.70) 247,293.27 ( 117,045.43) 103,250.70 ( 16,528.51) 86,722.19 745,145.97 ( 205,322.85) 539,823.12 ( 997.50) 997.50 0.00 3,785,502.79 ( 15,703.63) 3,769,799.16 3,493,743.86 ( 191,454.75) 3,302,289.11 330,796.24 9,170.79 339,967.03 0.00 83,092.56 83,092.56 117,898.63 ( 2,872.64) 115,025.99 33,072,551.68 1,806,972.48 34,879,524.16