|
10-11-2011 04:07 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: SEPTEMBER 30TH, 2011
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />75.OOo OF YEAR COMP.
<br />YEAR TO DATE a OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />I Golf-Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650.00 10,670.76 64,009.19 68.35 29,640.81
<br />222-4-5300-4103 Part-time Pay 29,900.00 5,861.40 25,338.93 84.75 4,561.07
<br />222-4-5300-4104 PERA 8,950.00 739.09 5,395.75 60.29 3,554.25
<br />222-4-5300-4105 FICA 7,650.00 694.97 5,317.53 69.51 2,332.47
<br />222-4-5300-4107 Medicare 1,800.00 162.52 1,243.56 69.09 556.44
<br />222-4-5300-4108 Insurance 10,150.00 458.01 4,122.09 40.61 6,027.91
<br />222-4-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 0.00 5,044.66 0.00 ( 5,044.66)
<br />TOTAL Personal Services 153,500.00 18,581.75 111,721.71 72.78 91,778.29
<br />Supplies
<br />222-4-5300-9212 Fuels & Lubs 5,000.00 0.00 3,555.76 71.12 1,944.24
<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 3,185.05 26,676.05 87.75 3,723.95
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 1,273.98 7,604.69 52.45 6,895.31
<br />TOTAL Supplies 50,400.00 9,459.03 38,249.90 75.89 12,150.10
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 228.53 1,494.91 59.80 1,005.09
<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 259.67 1,914.97 147..31 ( 614.97)
<br />222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 44.51 6,603.50
<br />222-4-5300-9389 Utilities 7,150.00 1,094.33 3,608.94 50.47 3,541.06
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.04 1,520.03 66.09 779.97
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000.00 57.00 2,237.08 79.57 762.92
<br />222-4-5300-4415 Equipment Rental 2,000.00 354.79 1,452.86 72.64 547.14
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 861.22 ( 293.40) 29.39- 1,293.40
<br />222-4-5300-4438 Credit Card Fees 5,500.00 870.93 3,983.17 72.42 1,516.83
<br />TOTAL Other Services & Charges 37,150.00 3,746.51 21,423.33 57.67 15,726.67
<br />Capital Outlay
<br />
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,417.00 8,497.00 99.96 3.00
<br />TOTAL Debt S ervice 8,500.00 1,417.00 8,497.00 99.96 3.00
<br />TOTAL Golf Course 249,550.00 28,204.29 179,891.94 72.09 69,658.06.
<br />TOTAL Culture & Recreation
<br />249,550.00 28,209.29 179,891.94 72.09 69,658.06
<br />^ TOTAL EXPENDITURES
<br />^ REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 28,204.29 179,891.94 72.09 69,658.06
<br />0.00 ( 11,658.34)( 20,880.00) 20,880.00
<br />
|