|
6-15-2010 03:50 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: MAY 31ST, 2010
<br />~ 222-PINEWOOD GOLF COURSE
<br />' DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT YEAR TO DATE
<br />BUDGET PERIOD ACTUAL
<br />41.67% OF YEAR COMP.
<br />% OF BUDGET
<br />BUDGET BALANCE
<br />I Golf-Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 91,550.00 7,573.38 30,869.27 33.71 60,685.73
<br />222-4-5300-4102 Overtime Pay 0.00 0.00 19.13 0.00 ( 19.13)
<br />222-4-5300-4103 Part-time Pay 28,900.00 3,430.76 6,172.58 21.36 22,727.42
<br />222-4-5300-4104 PERA 8,950.00 726.19 2,635.51 31.19 5,814.49
<br />222-4-5300-4105 FICA 7,950.00 666.75 2,379.11 31.93 5,070.89
<br />222-4-5300-4107 Medicare 1,750.00 155.95 556.44 31.80 1,193.56
<br />222-4-5300-9108 Insurance 11,050.00 898.02 3,143.07 28.44 7,906.93
<br />222-4-5300-4109 Workers Comp 1,250.00 0.00 622.50 49.80 627.50
<br />222-4-5300-4110 Re-employment Compensation 0.00 4,154.00 9,154.00 0.00 ( 4,154.00)
<br />TOTAL Personal Services 150,400.00 17,605.05 50,546.61 33.61 99,853.39
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 848.49 16.97 4,151.51
<br />222-4-5300-4217 Uniform Allowance 500.00 15.10 214.10 42.82 285.90
<br />222-4-5300-4219 Operating Supplies 25,600.00 5,637.26 8,639.69 33.75 16,960.36
<br />222-4-5300-4259 Other Merchandise For Resale 14,000.00 1,966.60 5,361.32 38.30 8,638.68
<br />TOTAL Supplies 45,100.00 7,618.96 15,063.55 33.40 30,036.45
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 3,100.00 157.49 699.25 22.56 2,400.75
<br />222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 127.96 25.59 372.04
<br />222-4-5300-4349 Advertising/Marketing 1,000.00 165.00 315.00 31.50 685.00
<br />222-4-5300-4361 Insurance 11,850.00 0.00 5,162.00 43.56 6,688.00
<br />222-4-5300-9389 Utilities 7,150.00 209.25 539.75 7.55 6,610.25
<br />222-4-5300-4401 Bldg Repair/Maint Services 1,000.00 245.04 305.16 30.52 694.84
<br />222-4-5300-4404 Equip Repair/Maint Services 2,500.00 45.00 1,086.52 43.46 1,413.48
<br />222-4-5300-4415 Equipment Rental 2,000.00 587.51 587.51 29.38 1,412.49
<br />222-4-5300-4437 Taxes & Licenses 850.00 116.52 ( 1,010.94) 118.93- 1,860.94
<br />222-4-5300-4938 Credit Card Fees 4,500.00 928.54 1,104.72 24.55 3,395.28
<br />TOTAL Other Services & Charges 34,450.00 2,454.35 8,916.93 25.88 25,533.07
<br />Debt Service
<br />222-9-5300-4601 Principal 8,500.00 1,916.00 2,832.00 33.32 5,668.00
<br />TOTAL Debt Service 8,500.00 1,416.00 2,832.00 33.32 5,668.00
<br />TOTAL Golf Course 238,450.00 29,094.36 77,359.09 32.44 161,090.91
<br />TOTAL Culture & Recreation
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />238,450.00 29,094.36 77,359.09 32.44 161,090.91
<br />238,450.00 29,094.36 77,359.09 32.44 161,090.91
<br />0.00 ( 353.55)( 6,382.26) 6,382.26
<br />
|