|
11-15-2012 08:04 AM CITY OF ELK RIVER PAGE: 3
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: OCTOBER 31ST, 2012
<br /> 222-PINEWOOD GOLF COURSE
<br /> 83.33% 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,320.46 70,543.63 80.99 16,556.37
<br /> 222-4-5300-4103 Part-time Pay 29,900.00 1,186.72 27,967.89 93.54 1,932.11
<br /> 222-4-5300-4104 PERA 8,500.00 589.52 6,396.71 75.26 2,103.29
<br /> 222-4-5300-4105 FICA 7,250.00 522.70 6,229.59 85.93 1,020.41
<br /> 222-4-5300-4107 Medicare 1,700.00 122.25 1,456.84 85.70 243.16
<br /> 222-4-5300-4108 Insurance 6,100.00 465.00 4,650.00 76.23 1,450.00
<br /> 222-4-5300-4109 Workers Comp 1,850.00 446.25 1,641.75 88.74 208.25
<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 10,652.90 122,716.11 86.18 19,683.89
<br /> Supplies
<br /> 222-4-5300-4212 Fuels & Lubs 4,500.00 0.00 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 1,030.52 28,527.92 96.05 1,172.08
<br /> 222-4-5300-4259 Other Merchandise For Resale 12,000.00 353.11 11,440.87 95.34 559.13
<br /> TOTAL Supplies 46,700.00 1,383.63 45,206.26 96.80 1,493.74
<br /> Other Services & Charges
<br /> 222-4-5300-4321 Telephone 2,400.00 163.85 1,532.74 63.86 867.26
<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 1,030.96 4,877.25 74.46 1,672.75
<br /> 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 501.40 5.60 8,448.60
<br /> 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 457.25 4,016.90 87.32 583.10
<br /> 222-4-5300-4415 Equipment Rental 1,350.00 48.29 665.97 49.33 684.03
<br /> 222-4-5300-4437 Taxes & Licenses 1,000.00 844.10 571.99 57.20 428.01
<br /> 222-4-5300-4438 Credit Card Fees 5,000.00 426.98 5,102.02 102.04 ( 102.02)
<br /> TOTAL Other Services & Charges 47,400.00 2,991.47 27,443.11 57.90 19,956.89
<br /> Capital Outlay
<br /> Debt Service
<br /> TOTAL Golf Course 236,500.00 15,028.00 195,365.48 82.61 41,134.52
<br /> TOTAL Culture & Recreation 236,500.00 15,028.00 195,365.48 82.61 41,134.52
<br /> TOTAL EXPENDITURES 236,500.00 15,028.00 195,365.48 82.61 41,134.52
<br /> REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 10,381.94) ) 10,658.76) 10,658.76
<br />
|