|
5-12-2010 09:42 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: APRIL 30TH, 2010
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />33.33 OF YEAR COMP.
<br />YEAR TO DATE $ OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 91,550.00 11,360.07 23,290.89 25.94 68,259.11
<br />222-4-5300-4102 Overtime Pay 0.00 19.13 19.13 0.00 ( 19.13)
<br />222-4-5300-9103 Part-time Pay 28,900.00 2,722.19 2,741.82 9.49 26,158.18
<br />222-4-5300-4109 PERA 8,450.00 930.40 1,909.32 22.60 6,540.68
<br />222-4-5300-4105 FICA 7,450.00 858.78 1,712.36 22.98 5,737.64
<br />222-4-5300-4107 Medicare 1,750.00 200.85 400.49 22.89 1,349.51
<br />222-4-5300-4108 Insurance 11,050.00 898.02 2,295.05 20.32 8,809.95
<br />222-4-5300-4109 Workers Comp 1,250.00 0.00 622.50 49.80 627.50
<br />TOTAL Persona l Services 150,400.00 16,989.39 32,941.56 21.90 117,458.44
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 848.49 848.49 16.97 4,151.51
<br />222-4-5300-4217 Uniform Allowance 500.00 163.00 199.00 39.80 301.00
<br />222-4-5300-4219 Operating Supplies 25,600.00 2,211.65 3,002.38 11.73 22,597.62
<br />222-4-5300-4259 Other Merchandise For Resale 14,000.00 2,712.60 3,394.72 24.25 10,605.28
<br />TOTAL Supplies 45,100.00 5,935.79 7,449.59 16.51 37,655.41
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 3,100.00 291.79 541.76 17.48 2,558.24
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 127.96 25.59 372.04
<br />222-4-5300-9349 Advertising/Marketing 1,000.00 150.00 150.00 15.00 850.00
<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 180.57 330.50 4.62 6,819.50
<br />222-4-5300-4401 Bldg Repair/Maint Services 1,000.00 20.04 60.12 6.01 939.88
<br />222-4-5300-4404 Equip Repair/Maint Services 2,500.00 136.52 1,091.52 41.66 1,458.48
<br />222-4-5300-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00
<br />222-4-5300-4437 Taxes & Licenses 850.00 ( 982.70)( 1,127.46) 132.64- 1,977.46
<br />222-4-5300-4438 Credit Card Fees 4,500.00 167.24 176.18 3.92 4,323.82
<br />TOTAL Other Services & Charges 34,450.00 ( 36.54) 6,462.58 18.76 27,987.42
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,916.00 1,416.00 16.66 7,084.00
<br />TOTAL Debt Service 8,500.00 1,416.00 1,416.00 16.66 7,084.00
<br />TOTAL Golf Course 238,450.00 24,304.59 48,264.73 20.29 190,185.27
<br />TOTAL Culture & Recreation 238,450.00 24,304.59 48,264.73 20.24 190,185.27
<br />TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES 238,450.00
<br />0.00 24,304.59
<br />7,828.65 ( 98,264.73 20.24
<br />6,028.71) 190,185.27
<br />6,028.71
<br />
|