|
5-11-2011 09:15 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: APRIL 30TH, 2011
<br />~ 222-PINEWOOD GOLF COURSE
<br />I DEPARTMENTAL EXPENDITURES
<br />33.330 OF YEAR COMP.
<br />CURRENT CURRENT YEAR TO DATE o OF BUDGET
<br />BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />~ Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650.00 13,335.20 25,332.91 27.05 68,317.09
<br />222-4-5300-4103 Part-time Pay 29,900.00 716.01 716.01 2.39 29,183.99
<br />222-4-5300-4104 PERA 8,950.00 728.37 1,762.42 19.69 7,187.58
<br />222-4-5300-4105 FICA 7,650.00 865.37 1,732.22 22.64 5,917.78
<br />222-4-5300-4107 Medicare 1,800.00 202.38 405.08 22.50 1,394.92
<br />222-4-5300-4108 Insurance 10,150.00 458.01 1,832.04 18.05 8,317.96
<br />222-9-5300-4109 Workers Comp 1,400.00 0.00 836.00 59.71 564.00
<br />222-9-5300-4110 Re-employment Compensation 0.00 9,842.25 4,842.25 0.00 ( 4,842.25)
<br />TOTAL Persona l Services 153,500.00 21,147.59 37,458.93 24.40 116,041.07
<br />Supplies
<br />222-4-5300-9212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00
<br />222-4-5300-4217 Uniform Allowance 500.00 360.00 360.00 72.00 140.00
<br />222-4-5300-4219 Operating Supplies 30,400.00 4,429.60 4,896.64 16.11 25,503.36
<br />222-4-5300-4259 Other Merchandise For Resale 14,500.00 251.28 516.07 3.56 13,983.93
<br />TOTAL Supplies 50,400.00 5,090.88 5,772.71 11.45 94,627.29
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 122.16 429.06 17.16 2,070.94
<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 195.00 195.00 15.00 1,105.00
<br />222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 99.51 6,603.50
<br />222-4-5300-4389 Utilities 7,150.00 244.53 392.23 5.49 6,757.77
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 190.54 230.62 10.03 2,069.38
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000.00 61.60 1,277.40 42.58 1,722.60
<br />222-4-5300-4415 Equipment Rental 2,000.00 21.16 21.16 1.06 1,978.84
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,238.66)( 834.48) 83.45- 1,834.48
<br />222-4-5300-9438 Credit Card Fees 5,500.00 132.26 212.97 3.87 5,287.03
<br />TOTAL Other Services & Charges 37,150.00 ( 271.91) 7,220.46 19.94 29,929.54
<br />Capital Outlay
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,416.00 1,416.00 16.66 7,084.00
<br />TOTAL Debt Service 8,500.00 1,916.00 1,416.00 16.66 7,084.00
<br />TOTAL Golf Course 249,550.00 27,333.06 51,868.10 20.78 197,681.90
<br />TOTAL Culture & Recreation
<br />249,550.00 27,333.06 51,868.10 20.78 197,681.90
<br />~ TOTAL EXPENDITURES
<br />~ REVENUES OVER/(UNDER) EXPENDITURES
<br />249,550.00 27,333.06 51,868.10 20.78 197,681.90
<br />0.00 ( 5,185.72)( 25,777.76) 25,777.76
<br />
|