|
7 -12 -2012 06:54 AM
<br />CITY OF ELK RIVER
<br />22,593.92
<br />PAGE: 3
<br />138,592.17
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />222 -4 -5300 -4101
<br />Regular Pay
<br />87,100.00
<br />AS OF: JUNE 30TH, 2012
<br />37,368.96
<br />42.90
<br />?- PINEWOOD GOLF COURSE
<br />222 -4 -5300 -4103
<br />Part -time Pay
<br />29,900.00
<br />4,388.61
<br />8,962.06
<br />50.00% OF
<br />YEAR COMP.
<br />222 -4- 5300 -4104
<br />CURRENT CURRENT YEAR TO DATE
<br />% OF
<br />BUDGET
<br />DEPARTMENTAL EXPENDITURES
<br />BUDGET PERIOD ACTUAL
<br />BUDGET
<br />BALANCE
<br />Golf Course
<br />Personal Services
<br />236,500.00
<br />22,593.92
<br />97,907.83 41.40
<br />138,592.17
<br />TOTAL Culture & Recreation
<br />222 -4 -5300 -4101
<br />Regular Pay
<br />87,100.00
<br />7,208.16
<br />37,368.96
<br />42.90
<br />49,731.04
<br />222 -4 -5300 -4103
<br />Part -time Pay
<br />29,900.00
<br />4,388.61
<br />8,962.06
<br />29.97
<br />20,937.94
<br />222 -4- 5300 -4104
<br />PERA
<br />8,500.00
<br />682.97
<br />3,260.21
<br />38.36
<br />5,239.79
<br />222 -4 -5300 -4105
<br />FICA
<br />7,250.00
<br />714.25
<br />2,993.94
<br />41.30
<br />4,256.06
<br />222 -4 -5300 -4107
<br />Medicare
<br />1,700.00
<br />167.04
<br />700.14
<br />41.18
<br />999.86
<br />222 -4 -5300 -4108
<br />Insurance
<br />6,100.00
<br />465.00
<br />2,790.00
<br />45.74
<br />3,310.00
<br />222 -4 -5300 -4109
<br />Workers Comp
<br />1,850.00
<br />398.50
<br />1,195.50
<br />64.62
<br />654.50
<br />222 -4 -5300 -4110
<br />Re- employment Compensation
<br />0.00
<br />0.00
<br />2,693.81
<br />0.00 (
<br />2,693.81)
<br />TOTAL Personal Services
<br />142,400.00
<br />14,024.53
<br />59,964.62
<br />42.11
<br />82,435.38
<br />Supplies
<br />222-4 -5300 -4212
<br />Fuels & Lubs
<br />4,500.00
<br />408.58
<br />2,016.05
<br />44.80
<br />2,483.95
<br />222 -4 -5300 -4217
<br />Uniform Allowance
<br />500.00
<br />0.00
<br />383.53
<br />76.71
<br />116.47
<br />222 -4 -5300 -4219
<br />Operating Supplies
<br />29,700.00
<br />3,603.2.1
<br />15,618.37
<br />52.59
<br />14,081.63
<br />222 - -4- 5300 -4259
<br />Other Merchandise For Resale
<br />12,000.00
<br />1,887.82
<br />6,065.64
<br />50.55
<br />5,934.36
<br />TOTAL Supplies
<br />46,700.00
<br />5,899.61
<br />24,083.59
<br />51.57
<br />22,616.41
<br />Other Services & Charges
<br />222 -4 -5300 -4321
<br />Telephone
<br />2,400.00
<br />174.78
<br />854.73
<br />35.61
<br />1,545.27
<br />222 -4- 5300 -4331
<br />Travel, Conferences & Schools
<br />450.00
<br />0.00
<br />17.69
<br />3.93
<br />432.31
<br />222 -4 -5300 -4349
<br />Advertising /Marketing
<br />5,000.00
<br />1,215.73
<br />3,423.93
<br />68.48
<br />1,576.07
<br />222 -4 -5300 -4361
<br />Insurance
<br />12,100.00
<br />0.00
<br />5,144.50
<br />42.52
<br />6,955.50
<br />222 -4 -5300 -4389
<br />Utilities
<br />6,550.00
<br />465.30
<br />1,211.64
<br />18.50
<br />5,338.36
<br />222 -4- 5300 -4401
<br />Bldg Repair /Maint Services
<br />8,950.00
<br />20.04
<br />234.70
<br />2.62
<br />8,715.30
<br />222 -4 -5300 -4404
<br />Equip Repair /Maint Services
<br />4,600.00
<br />0.00
<br />1,597.20
<br />34.72
<br />3,002.80
<br />222 -4- 5300 -4415
<br />Equipment Rental
<br />1,350.00
<br />48.29
<br />142.81
<br />10.58
<br />1,207.19
<br />222 -4 -5300 -4437
<br />Taxes & Licenses
<br />11000.00 (
<br />144.01)(
<br />1,004.23)
<br />100.42-
<br />2,004.23
<br />222 -4 -5300 -4438
<br />Credit Card Fees
<br />5,000.00
<br />889.65
<br />2,236.65
<br />44.73
<br />2,763.35
<br />TOTAL Other Services & Charges
<br />47,400.00
<br />2,669.78
<br />13,859.62
<br />29.24
<br />33,540.38
<br />Capital Outlay
<br />Debt Service
<br />TOTAL Golf Course
<br />236,500.00
<br />22,593.92
<br />97,907.83 41.40
<br />138,592.17
<br />TOTAL Culture & Recreation
<br />236,500.00
<br />22,593.92
<br />97,907.83 41.40
<br />138,592.17
<br />TOTAL EXPENDITURES
<br />REVENUES OVER /(UNDER) EXPENDITURES
<br />236,500.00
<br />0.00
<br />22,593.92
<br />8,79.9.92
<br />97,907.83 41.40
<br />8,194.62 (
<br />138,592.17
<br />8,194.62)
<br />
|