|
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: JULY 31ST, 2011
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />58.33$ OF YEAR COMP.
<br />YEAR TO DATE $ OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-9101 Regular Pay 93,650.00 7,031.20 46,229.59 49.36 47,425.91
<br />222-9-5300-9103 Part-time Pay 29,900.00 6,244.40 13,420.85 44.89 16,979.15
<br />222-4-5300-4104 PERA 8,950.00 756.61 3,894.86 43.52 5,055.14
<br />222-4-5300-4105 FICA 7,650.00 817.27 3,797.75 49.64 3,852.25
<br />222-4-5300-4107 Medicare 1,800.00 191.13 888.14 49.34 911.86
<br />222-4-5300-4108 Insurance 10,150.00 958.01 3,206.07 31.59 6,943.93
<br />222-9-5300-4109 Workers Comp 1,400.00 0.00 1,250.00 89.29 150.00
<br />222-4-5300-4110 Re-employment Compensation 0.00 202.41 5,044.66 0.00 ( 5,049.66)
<br />TOTAL Personal Services 153,500.00 15,701.03 77,726.92 50.64 75,773.08
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 1,689.39 33.79 3,310.61
<br />222-4-5300-4217 Uniform Allowance 500.00 0.00 413.40 82.68 86.60
<br />222-4-5300-4219 Operating Supplies 30,900.00 2,878.59 19,109.08 62.86 11,290.92
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 1,236.49 5,113.59 35.27 9,386.91
<br />TOTAL Supplies 50,400.00 9,115.03 26,325.46 52.23 24,074.54
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 199.63 1,031.05 91.24 1,468.95
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 208.27 41.65 291.73
<br />222-4-5300-4349 Advertising/Marketing 1,300.00 639.40 1,289.00 99.15 11.00
<br />222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 44.51 6,603.50
<br />222-4-5300-4389 Utilities 7,150.00 533.89 1,731.27 24.21 5,418.73
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.04 1,402.30 60.97 897.70
<br />222-4-5300-4909 Equip Repair/Maint Services 3,000.00 122.40 2,051.83 68.39 998.17
<br />222-4-5300-4415 Equipment Rental 2,000.00 385.58 1,029.09 51.45 970.91
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,744.16)( 2,686.75) 268.68- 3,686.75
<br />222-4-5300-4438 Credit Card Fees 5,500.00 807.52 2,422.49 44.05 3,077.51
<br />TOTAL Other Services & Charges 37,150.00 964.30 13,775.05 37.08 23,374.95
<br />Capital Outlay
<br />
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,416.00 5,664.00 66.64 2,836.00
<br />TOTAL Debt S ervice 8,500.00 1,416.00 5,664.00 66.64 2,836.00
<br />TOTAL Golf Course 249,550.00 22,196.36 123,491.43 49.49 126,058.57
<br />TOTAL Culture & Recreation
<br />249,550.00 22,196.36 123,491.43 49.49 126,058.57
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 22,196.36 123,491.43 49.49 126,058.57
<br />0.00 3,805.42 ( 10,681.48) 10,681.48
<br />
|