12-13-2011 04:13 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: NOVEMBER 30TH, 2011
<br />1 222-PINEWOOD GOLF COURSE
<br />I DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />91.67$ OF YEAR COMP.
<br />YEAR TO DATES OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />1 Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650.00 6,753.84 77,876.87 83.16 15,773.13
<br />222-4-5300-4103 Part-time Pay 29,900.00 246.50 27,683.83 92.59 2,216.17
<br />222-4-5300-4104 PERA 8,950.00 507.53 6,877.16 76.84 2,072.84
<br />222-4-5300-4105 FICA 7,650.00 428.20 6,650.97 86.94 999.03
<br />222-4-5300-4107 Medicare 1,800.OD 100.13 1,555.40 86.41 249.60
<br />222-4-5300-4108 Insurance 10,150.00 458.01 5,038.11 99.64 5,111.89
<br />222-4-5300-9109 workers Comp 1,400.00 0.00 1,648.50 117.75 ( 248.50)
<br />222-4-5300-9110 Re-employment Compensation 0.00 0.00 5,044.66 0.00 ( 5,044.66)
<br />TOTAL Person al Services 153,500.00 8,494.21 132,375.50 86.24 21,124.50
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 4,767.58 95.35 232.42
<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,400.00 624.42 28,982.35 95.34 1,417.65
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 34.70 7,936.16 54.73 6,563.84
<br />TOTAL Suppli es 50,400.00 659.12 92,099.49 83.53 8,300.51
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 164.28 1,871.56 74.86 628.49
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 208.27 41.65 291.73
<br />222-4-5300-9349 Advertising/Marketing 1,300.00 0.00 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-4389 Utilities 7,150.00 781.47 5,317.73 74.37 1,832.27
<br />222-4-5300-4901 Bldg Repair/Maint Services 2,300.00 20.04 1,560.11 67.83 739.89
<br />222-4-5300-4409 Equip Repair/Maint Services 3,000.00 0.00 2,241.08 74.70 758.92
<br />222-4-5300-4415 Equipment Rental 2,000.00 48.29 1,549.44 77.47 450.56
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 659.84 783.84 78.38 216.16
<br />222-4-5300-4438 Credit Card Fees 5,500.00 309.81 4,711.28 85.66 788.72
<br />TOTAL Other Services & Charges 37,150.00 1,978.73 25,454.78 68.52 11,695.22
<br />Capital Outlay
<br />
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 0.00 8,497.00 99.96 3.00
<br />TOTAL Debt S ervice 8,500.00 0.00 8,497.00 99.96 3.00
<br />TOTAL Golf Course 249,550.00 11,132.06 208,426.77 83.52 41,123.23
<br />TOTAL Culture & Recreation 249,550.00 11,132.06 208,426.77 83.52 41,123.23
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 11,132.06 208,926.77 83.52 41,123.23
<br />0.00 ( 10,019.54)( 38,846.31) 38,846.31
<br />
|