11-10-2010 07:46 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: OCTOBER 31ST, 2010
<br />1 222-PINEWOOD GOLF COURSE
<br />I DEPARTMENTAL EXPENDITURES
<br />83.33$ OF YEAR COMP.
<br />CURRENT CURRENT YEAR TO DATE $ OF BUDGET
<br />BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />1 Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 91,550.00 11,958.24 74,152.87 81.00 17,397.13
<br />222-4-5300-4102 Overtime Pay 0.00 0.00 19.13 0.00 ( 19.13)
<br />222-4-5300-4103 Part-time Pay 28,900.00 3,111.50 33,558.94 116.12 ( 4,658.94)
<br />222-9-5300-4104 PERA 8,450.00 991.94 6,857.50 81.15 1,592.50
<br />222-4-5300-4105 FICA 7,450.00 934.40 6,699.07 89.92 750.93
<br />222-4-5300-9107 Medicare 1,750.00 218.55 1,566.79 89.53 183.21
<br />222-4-5300-4108 Insurance 11,050.00 898.02 7,633.17 69.08 3,416.83
<br />222-4-5300-4109 Workers Comp 1,250.00 414.00 1,347.75 107.82 ( 97.75)
<br />222-4-5300-4110 Re-employment Compensation 0.00 0.00 4,154.00 0.00 ( 4,154.00)
<br />TOTAL Personal Services 150,400.00 18,526.65 135,989.22 90.42 14,410.78
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 3,685.20 73.70 1,314.80
<br />222-4-5300-4217 Uniform Allowance 500.00 119.98 334.08 66.82 165.92
<br />222-4-5300-4219 Operating Supplies 25,600.00 2,305.64 22,186.26 86.67 3,413.74
<br />222-4-5300-4259 Other Merchandise For Resale 14,000.00 11.30 11,782.30 84.16 2,217.70
<br />TOTAL Supplies 45,100.00 2,436.92 37,987.84 84.23 7,112.16
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 3,100.00 216.67 1,772.63 57.18 1,327.37
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 135.69 27.14 364.31
<br />222-4-5300-4349 Advertising/Marketing 1,000.00 103.80 859.40 85.94 140.60
<br />222-4-5300-4361 Insurance 11,850.00 0.00 5,162.00 43.56 6,688.00
<br />222-4-5300-4389 Utilities 7,150.00 961.15 4,774.47 66.78 2,375.53
<br />222-4-5300-4401 Bldg Repair/Maint Services 1,000.00 20.04 900.36 90.04 99.64
<br />222-4-5300-4404 Equip Repair/Maint Services 2,500.00 0.00 2,054.94 82.18 445.56
<br />222-4-5300-4415 Equipment Rental 2,000.00 74.19 1,335.64 66.78 664.36
<br />222-4-5300-4437 Taxes & Licenses 850.00 326.71 648.68 76.32 201.32
<br />222-4-5300-4438 Credit Card Fees 4,500.00 240.47 4,200.54 93.35 299.46
<br />TOTAL Other Services & Charges 34,450.00 1,943.03 21,843.85 63.41 12,606.15
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 0.00 8,496.00 99.95 4.00
<br />TOTAL Debt Service 8,500.00 0.00 8,996.00 99.95 4.00
<br />TOTAL Golf Course
<br />TOTAL Culture & Recreation
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />238,450.00 22,906.60 204,316.91 85.69 34,133.09
<br />238,450.00 22,906.60 204,316.91 85.69 34,133.09
<br />238,450.00 22,906.60 204,316.91 85.69 34,133.09
<br />0.00 ( 13,999.27)( 23,233.79) 23,233.79
<br />
|