|
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: OCTOBER 31ST, 2011
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />83.33 OF YEAR COMP.
<br />YEAR TO DATE °s OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650.00 7,113.84 71,123.03 75.95 22,526.97
<br />222-4-5300-4103 Part-time Pay 29,900.00 2,098.40 27,437.33 91.76 2,462.67
<br />222-4-5300-4104 PERA 8,950.00 626.02 6,369.63 71.17 2,580.37
<br />222-4-5300-4105 FICA 7,650.00 565.36 6,222.77 81.34 1,927.23
<br />222-4-5300-4107 Medicare 1,800.00 132.23 1,455.27 80.85 344.73
<br />222-4-5300-4108 Insurance 10,150.00 458.01 9,580.10 45.12 5,569.90
<br />222-4-5300-4109 Workers Comp 1,400.00 398.50 1,648.50 117.75 ( 248.50)
<br />222-4-5300-9110 Re-employment Compensation 0.00 0.00 5,044.66 0.00 ( 5,044.66)
<br />TOTAL Person al Services 153,500.00 11,392.36 123,881.29 80.70 29,618.71
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 1,211.82 4,767.58 95.35 232.42
<br />222-4-5300-4217 Uniform Allowance 500.00 0.00 413.40 82.68 86.60
<br />222-4-5300-4219 Operating Supplies 30,400.00 1,681.88 28,357.93 93.28 2,042.07
<br />222-4-5300-4259 Other Merchandise For Resale 19,500.00 296.77 7,901.46 54.49 6,598.54
<br />TOTAL Suppli es 50,400.00 3,190.47 41,940.37 82.22 8,959.63
<br />Other Services & Charges
<br />222-4-5300-9321 Telephone 2,500.00 212.37 1,707.28 68.29 792.72
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 208.27 41.65 291.73
<br />222-4-5300-4349 Advertising/Marketing 1,300.00 0.00 1,914.97 147.31 ( 619.97)
<br />222-4-5300-9361 Insurance 11,900.00 0.00 5,296.50 44.51 6,603.50
<br />222-4-5300-4389 Utilities 7,150.00 927.32 4,536.26 63.44 2,613.74
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.04 1,540.07 66.96 759.93
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000.00 4.00 2,241.08 74.70 758.92
<br />222-4-5300-4415 Equipment Rental 2,000.00 48.29 1,501.15 75.06 498.85
<br />222-4-5300-4937 Taxes & Licenses 1,000.00 417.40 124.00 12.40 876.00
<br />222-4-5300-4438 Credit Card Fees 5,500.00 423.30 4,406.97 80.12 1,093.53
<br />TOTAL Other Services & Charges 37,150.00 2,052.72 23,476.05 63.19 13,673.95
<br />Capital Outlay
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 0.00 8,497.00 99.96 3.00
<br />TOTAL Debt S ervice 8,500.00 0.00 8,497.00 99.96 3.00
<br />~ TOTAL Golf Course
<br />~ TOTAL Culture & Recreation
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 16,635.55 197,294.71 79.06 52,255.29
<br />249,550.00 16,635.55 197,294.71 79.06 52,255.29
<br />249,550.00 16,635.55 197,299.71 79.06 52,255.29
<br />0.00 ( 7,179.55)( 28,826.77) 28,826.77
<br />
|