|
12-12-2012 01:08 PM CITY OF ELK RIVER PAGE: 3
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: NOVEMBER 30TH, 2012
<br /> 222-PINEWOOD GOLF COURSE
<br /> 91.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 6,000.46 76,544.09 87.88 10,555.91
<br /> 222-4-5300-4103 Part-time Pay 29,900.00 169.83 28,137.72 94.11 1,762.28
<br /> 222-4-5300-4104 PERA 8,500.00 435.04 6,831.75 80.37 1,668.25
<br /> 222-4-5300-4105 FICA 7,250.00 377.82 6,607.41 91.14 642.59
<br /> 222-4-5300-4107 Medicare 1,700.00 88.35 1,545.19 90.89 154.81
<br /> 222-4-5300-4108 Insurance 6,100.00 465.00 5,115.00 83.85 985.00
<br /> 222-4-5300-4109 Workers Comp 1,850.00 0.00 1,641.75 88.74 208.25
<br /> 222-4-5300-4110 Re-employment Compensation 0.00 587.85 4,417.55 0.00 ( 4,417.55)
<br /> TOTAL Personal Services 142,400.00 8,124.35 130,840.46 91.88 11,559.54
<br /> Supplies
<br /> 222-4-5300-4212 Fuels & Lubs 4,500.00 48.23 4,896.83 108.82 ( 396.83)
<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 783.05 29,310.97 98.69 389.03
<br /> 222-4-5300-4259 Other Merchandise For Resale 12,000.00 0.00 11,440.87 95.34 559.13
<br /> TOTAL Supplies 46,700.00 831.28 46,037.54 98.58 662.46
<br /> Other Services & Charges
<br /> 222-4-5300-4321 Telephone 2,400.00 185.38 1,718.12 71.59 681.88
<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 6,112.50 11,257.00 93.03 843.00
<br /> 222-4-5300-4389 Utilities 6,550.00 699.85 5,577.10 85.15 972.90
<br /> 222-4-5300-4401 Bldg Repair/Maint Services 8,950.00 20.04 521.44 5.83 8,428.56
<br /> 222-4-5300-4404 Equip Repair/Maint Services 4,600.00 375.68 4,392.58 95.49 207.42
<br /> 222-4-5300-4415 Equipment Rental 1,350.00 248.29 914.26 67.72 435.74
<br /> 222-4-5300-4437 Taxes & Licenses 1,000.00 204.17 776.16 77.62 223.84
<br /> 222-4-5300-4438 Credit Card Fees 5,000.00 205.21 5,307.23 106.14 ( 307.23)
<br /> TOTAL Other Services & Charges 47,400.00 8,051.12 35,494.23 74.88 11,905.77
<br /> Capital Outlay
<br /> Debt Service
<br /> TOTAL Golf Course 236,500.00 17,006.75 212,372.23 89.80 24,127.77
<br /> TOTAL Culture & Recreation 236,500.00 17,006.75 212,372.23 89.80 24,127.77
<br /> TOTAL EXPENDITURES 236,500.00 17,006.75 212,372.23 89.80 24,127.77
<br /> REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 15,320.27) ) 25,979.03) 25,979.03
<br />
|