|
8-13-2012 12:14 PM CITY OF ELK RIVER PAGE: 3
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JULY 31ST, 2012
<br /> 222-PINEWOOD GOLF COURSE
<br /> 58.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,174.31 44,543.27 51.14 42,556.73
<br /> 222-4-5300-4102 Overtime Pay 0.00 191.25 191.25 0.00 ( 191.25)
<br /> 222-4-5300-4103 Part-time Pay 29,900.00 6,718.40 15,680.46 52.44 14,219.54
<br /> 222-4-5300-4104 PERA 8,500.00 753.64 4,013.85 47.22 4,486.15
<br /> 222-4-5300-4105 FICA 7,250.00 868.47 3,862.41 53.27 3,387.59
<br /> 222-4-5300-4107 Medicare 1,700.00 203.11 903.25 53.13 796.75
<br /> 222-4-5300-4108 Insurance 6,100.00 465.00 3,255.00 53.36 2,845.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 2,693.81 0.00 ( 2,693.81)
<br /> TOTAL Personal Services 142,400.00 16,374.18 76,338.80 53.61 66,061.20
<br /> Supplies
<br /> 222-4-5300-4212 Fuels & Lubs 4,500.00 0.00 2,016.05 44.80 2,483.95
<br /> 222-4-5300-4217 Uniform Allowance 500.00 5.34 388.87 77.77 111.13
<br /> 222-4-5300-4219 Operating Supplies 29,700.00 1,996.39 17,614.76 59.31 12,085.24
<br /> 222-4-5300-4259 Other Merchandise For Resale 12,000.00 1,508.72 7,574.36 63.12 4,425.64
<br /> TOTAL Supplies 46,700.00 3,510.45 27,594.04 59.09 19,105.96
<br /> Other Services & Charges
<br /> 222-4-5300-4321 Telephone 2,400.00 175.98 1,030.71 42.95 1,369.29
<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 968.62 4,392.55 87.85 607.45
<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 646.02 1,857.66 28.36 4,692.34
<br /> 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 206.58 441.28 4.93 8,508.72
<br /> 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 1,131.20 2,728.40 59.31 1,871.60
<br /> 222-4-5300-4415 Equipment Rental 1,350.00 48.29 191.10 14.16 1,158.90
<br /> 222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,731.57) ( 2,735.80) 273.58- 3,735.80
<br /> 222-4-5300-4438 Credit Card Fees 5,000.00 907.95 3,144.60 62.89 1,855.40
<br /> TOTAL Other Services & Charges 47,400.00 2,353.07 16,212.69 34.20 31,187.31
<br /> Capital Outlay
<br /> Debt Service
<br /> TOTAL Golf Course 236,500.00 22,237.70 120,145.53 50.80 116,354.47
<br /> TOTAL Culture & Recreation 236,500.00 22,237.70 120,145.53 50.80 116,354.47
<br /> TOTAL EXPENDITURES 236,500.00 22,237.70 120,145.53 50.80 116,354.47
<br /> REVENUES OVER/(UNDER) EXPENDITURES 0.00 2,981.14 11,175.76 ( 11,175.76)
<br />
|