|
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: MARCH 31ST, 2011
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />25.00% OF YEAR COMP.
<br />CURRENT CURRENT YEAR TO DATE % OF BUDGET
<br />BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-9101 Regular Pay 93,650.00 5,149.35 11,997.71 12.81 81,652.29
<br />222-4-5300-4103 Part-time Pay 29,900.00 0.00 0.00 0.00 29,900.00
<br />222-4-5300-4104 PERA 8,950.00 372.96 1,034.05 11.55 7,915.95
<br />222-4-5300-4105 FICA 7,650.00 313.13 866.85 11.33 6,783.15
<br />222-4-5300-4107 Medicare 1,800.00 73.22 202.70 11.26 1,597.30
<br />222-4-5300-4108 Insurance 10,150.00 458.01 1,374.03 13.54 8,775.97
<br />222-4-5300-4109 Workers Comp 1,400.00 422.00 836.00 59.71 564.00
<br />TOTAL Personal Services 153,500.00 6,783.67 16,311.34 10.63 137,188.66
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00
<br />222-4-5300-4217 Uniform Allowance 500.00 0.00 0.00 0.00 500.00
<br />222-4-5300-4219 Operating Supplies 30,900.00 184.52 467.04 1.54 29,932.96
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 264.79 264.79 1.83 14,235.21
<br />TOTAL Supplies 50,400.00 449.31 731.83 1.45 49,668.17
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 154.52 306.90 12.28 2,193.10
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00
<br />222-4-5300-4349 Advertising/Marketing 1,300.00 0.00 0.00 0.00 1,300.00
<br />222-4-5300-4361 Insurance 11,900.00 2,648.25 5,296.50 94.51 6,603.50
<br />222-4-5300-4389 Utilities 7,150.00 68.79 147.70 2.07 7,002.30
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.09 40.08 1.74 2,259.92
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000.00 20.80 1,215.80 40.53 1,784.20
<br />222-4-5300-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 6.18 404.18 40.42 595.82
<br />222-4-5300-4438 Credit Card Fees 5,500.00 19.09 80.71 1.47 5,419.29
<br />TOTAL Other Services & Charges 37,150.00 2,937.67 7,491.87 20.17 29,658.13
<br />Capital Outlay
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 0.00 0.00 0.00 8,500.00
<br />TOTAL Debt Service 8,500.00 0.00 0.00 0.00 8,500.00
<br />TOTAL Golf Course 249,550.00 10,170.65 24,535.04 9.83 225,014.96
<br />TOTAL Culture & Recreation 249,550.00 10,170.65 29,535.04 9.83 225,014.96
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 10,170.65 24,535.04 9.83 225,014.96
<br />0.00 ( 7,346.65)( 20,592.04) 20,592.04
<br />
|