|
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: JUNE 30TH, 2011
<br />~ 222-PINEWOOD GOLF COURSE
<br />I DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />50.00 OF YEAR COMP.
<br />YEAR TO DATE o OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />I Golf-Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650.00 6,930.24 39,193.39 41.85 54,456.61
<br />222-4-5300-4103 Part-time Pay 29,900.00 4,294.41 7,176.95 29.00 22,723.55
<br />222-4-5300-4104 PERA 8,950.00 718.52 3,138.25 35.06 5,811.75
<br />222-4-5300-4105 FICA 7,650.00 687.00 2,980.48 38.96 4,669.52
<br />222-4-5300-4107 Medicare 1,800.00 160.67 697.01 38.72 1,102.99
<br />222-4-5300-9108 Insurance 10,150.00 458.01 2,748.06 27.07 7,401.94
<br />222-4-5300-4109 Workers Comp 1,400.00 414.00 1,250.00 89.29 150.00
<br />222-4-5300-4110 Re-employment Compensation 0.00 0.00 9,842.25 0.00 ( 4,842.25)
<br />TOTAL Person al Services 153,500.00 13,612.85 62,025.89 40.41 91,974.11
<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-9219 Operating Supplies 30,400.00 3,429.24 16,530.54 54.38 13,869.46
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 1,529.51 3,877.10 26.74 10,622.90
<br />TOTAL Suppli es 50,400.00 4,958.75 22,510.43 44.66 27,889.57
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 209.13 831.42 33.26 1,668.58
<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 454.60 649.60 49.97 650.90
<br />222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 94.51 6,603.50
<br />222-9-5300-9389 Utilities 7,150.00 395.61 1,197.38 16.75 5,952.62
<br />222-4-5300-9401 Bldg Repair/Maint Services 2,300.00 1,131.60 1,382.26 60.10 917.74
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000.00 98.94 1,929.43 64.31 1,070.57
<br />222-4-5300-4415 Equipment Rental 2,000.00 34.84 643.51 32.18 1,356.49
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 67.71 ( 911.37) 91.14- 1,911.37
<br />222-4-5300-4438 Credit Card Fees 5,500.00 901.98 1,614.97 29.36 3,885.03
<br />TOTAL Other Services & Charges 37,150.00 3,294.41 12,841.97 34.57 24,308.03
<br />Capital Outlay
<br />
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,416.00 9,248.00 49.98 4,252.00
<br />TOTAL Debt S ervice 8,500.00 1,416.00 4,248.00 49.98 4,252.00
<br />TOTAL Golf Course 249,550.00 23,282.01 101,626.29 40.72 197,923.71
<br />TOTAL Culture & Recreation
<br />^ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 23,282.01 101,626.29 40.72 147,923.71
<br />299,550.00 23,282.01 101,626.29 40.72 147,923.71
<br />0.00 6,611.76 ( 14,796.78) 14,796.78
<br />
|