|
10-09-2012 02:00 PM CITY OF ELK RIVER PAGE: 3
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: SEPTEMBER 30TH, 2012
<br /> 222-PINEWOOD GOLF COURSE
<br /> 75.00% OF YEAR COMP.
<br /> CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> Golf Course
<br /> Personal Services
<br /> 222-4-5300-4101 Regular Pay 87,100.00 7,395.46 63,223.17 72.59 23,876.83
<br /> 222-4-5300-4103 Part-time Pay 29,900.00 3,445.55 26,781.17 89.57 3,118.83
<br /> 222-4-5300-4104 PERA 8,500.00 714.55 5,807.19 68.32 2,692.81
<br /> 222-4-5300-4105 FICA 7,250.00 667.41 5,706.89 78.72 1,543.11
<br /> 222-4-5300-4107 Medicare 1,700.00 156.08 1,334.59 78.51 365.41
<br /> 222-4-5300-4108 Insurance 6,100.00 465.00 4,185.00 68.61 1,915.00
<br /> 222-4-5300-4109 Workers Comp 1,850.00 0.00 1,195.50 64.62 654.50
<br /> 222-4-5300-4110 Re-employment Compensation 0.00 0.00 3,829.70 0.00 ( 3,829.70)
<br /> TOTAL Personal Services 142,400.00 12,844.05 112,063.21 78.70 30,336.79
<br /> Supplies
<br /> 222-4-5300-4212 Fuels & Lubs 4,500.00 1,120.31 4,848.60 107.75 ( 348.60)
<br /> 222-4-5300-4217 Uniform Allowance 500.00 0.00 388.87 77.77 111.13
<br /> 222-4-5300-4219 Operating Supplies 29,700.00 4,483.20 27,497.40 92.58 2,202.60
<br /> 222-4-5300-4259 Other Merchandise For Resale 12,000.00 908.92 11,087.76 92.40 912.24
<br /> TOTAL Supplies 46,700.00 6,512.43 43,822.63 93.84 2,877.37
<br /> Other Services & Charges
<br /> 222-4-5300-4321 Telephone 2,400.00 166.86 1,368.89 57.04 1,031.11
<br /> 222-4-5300-4331 Travel, Conferences & Schools 450.00 0.00 17.69 3.93 432.31
<br /> 222-4-5300-4349 Advertising/Marketing 5,000.00 0.00 5,012.65 100.25 ( 12.65)
<br /> 222-4-5300-4361 Insurance 12,100.00 0.00 5,144.50 42.52 6,955.50
<br /> 222-4-5300-4389 Utilities 6,550.00 982.40 3,846.29 58.72 2,703.71
<br /> 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 481.36 5.38 8,468.64
<br /> 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 281.25 3,559.65 77.38 1,040.35
<br /> 222-4-5300-4415 Equipment Rental 1,350.00 378.29 617.68 45.75 732.32
<br /> 222-4-5300-4437 Taxes & Licenses 1,000.00 1,086.05 ( 272.11) 27.21- 1,272.11
<br /> 222-4-5300-4438 Credit Card Fees 5,000.00 767.23 4,675.04 93.50 324.96
<br /> TOTAL Other Services & Charges 47,400.00 3,682.12 24,451.64 51.59 22,948.36
<br /> Capital Outlay
<br /> Debt Service
<br /> TOTAL Golf Course 236,500.00 23,038.60 180,337.48 76.25 56,162.52
<br /> TOTAL Culture & Recreation 236,500.00 23,038.60 180,337.48 76.25 56,162.52
<br /> TOTAL EXPENDITURES 236,500.00 23,038.60 180,337.48 76.25 56,162.52
<br /> REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 5,285.39) ( 276.82) 276.82
<br />
|