|
9-11-2012 02:11 PM CITY OF ELK RIVER PAGE: 3 j
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: AUGUST 31ST, 2012
<br /> 1
<br /> 222-PINEWOOD GOLF COURSE
<br /> 66.67% 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 11,284.44 55,827.71 64.10 31,272.29
<br /> 222-4-5300-4102 Overtime Pay 0.00 ( 191.25) 0.00 0.00 0.00
<br /> 222-4-5300-4103 Part-time Pay 29,900.00 7,655.16 23,335.62 78.05 6,564.38
<br /> 222-4-5300-4104 PERA 8,500.00 1,078.79 5,092.64 59.91 3,407.36
<br /> 222-4-5300-4105 FICA 7,250.00 1,177.07 5,039.48 69.51 2,210.52
<br /> 222-4-5300-4107 Medicare 1,700.00 275.26 1,178.51 69.32 521.49
<br /> 222-4-5300-4108 Insurance 6,100.00 465.00 3,720.00 60.98 2,380.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 1,135.89 3,829.70 0.00 ( 3,829.70)
<br /> TOTAL Personal Services 142,400.00 22,880.36 99,219.16 69.68 43,180.84
<br /> Supplies
<br /> 222-4-5300-4212 Fuels & Lubs 4,500.00 1,712.24 3,728.29 82.85 771.71
<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 5,399.44 23,014.20 77.49 6,685.80
<br /> 222-4-5300-4259 Other Merchandise For Resale 12,000.00 2,604.48 10,178.84 84.82 1,821.16
<br /> TOTAL Supplies 46,700.00 9,716.16 37,310.20 79.89 9,389.80
<br /> Other Services & Charges
<br /> 222-4-5300-4321 Telephone 2,400.00 171.32 1,202.03 50.08 1,197.97
<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 620.10 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,006.23 2,863.89 43.72 3,686.11
<br /> 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 461.32 5.15 8,488.68
<br /> 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 550.00 3,278.40 71.27 1,321.60
<br /> 222-4-5300-4415 Equipment Rental 1,350.00 48.29 239.39 17.73 1,110.61
<br /> 222-4-5300-4437 Taxes & Licenses 1,000.00 1,838.50 ( 897.30) 89.73- 1,897.30
<br /> 222-4-5300-4438 Credit Card Fees 5,000.00 763.21 3,907.81 78.16 1,092.19
<br /> TOTAL Other Services & Charges 47,400.00 5,017.69 21,230.38 44.79 26,169.62
<br /> Capital Outlay
<br /> Debt Service
<br /> TOTAL Golf Course 236,500.00 37,614.21 157,759.74 66.71 78,740.26
<br /> TOTAL Culture & Recreation 236,500.00 37,614.21 157,759.74 66.71 78,740.26
<br /> TOTAL EXPENDITURES 236,500.00 37,614.21 157,759.74 66.71 78,740.26
<br /> ------------- =-===------ ------------- ------- -------------
<br /> REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 11,573.64) ( 397.88) 397.88
<br />
|