|
I 8-10-2010 02:08 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: JULY 31ST, 2010
<br />~ 222-PINEWOOD GOLF COURSE
<br />~ DEPARTMENTAL EXPENDITURES
<br />Golf Course
<br />Personal Services
<br />58.330 OF YEAR COMP
<br />CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
<br />BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />222-4-5300-9101 Regular Pay 91,550.00 7,812.66 46,250.31 50.52 45,299.69
<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 7,725.33 19,139.07 66.23 9,760.93
<br />222-4-5300-4104 PERA 8,450.00 858.59 4,272.32 50.56 4,177.68
<br />222-9-5300-4105 FICA 7,450.00 947.87 4,105.96 55.11 3,344.04
<br />222-4-5300-4107 Medicare 1,750.00 221.66 960.28 54.87 789.72
<br />222-4-5300-4108 Insurance 11,050.00 898.02 4,939.11 44.70 6,110.89
<br />222-4-5300-4109 Workers Comp 1,250.00 0.00 933.75 74.70 316.25
<br />222-4-5300-4110 Re-employment Compensation 0.00 0.00 9,154.00 0.00 ( 4,154.00)
<br />TOTAL Personal Services 150,400.00 18,464.13 84,773.93 56.37 65,626.07
<br />Supplies
<br />222-4-5300-4212 Euels & Lubs 5,000.00 0.00 1,615.71 32.31 3,384.29
<br />222-4-5300-4217 Uniform Allowance 500.00 0.00 214.10 42.82 285.90
<br />222-4-5300-4219 Operating Supplies 25,600.00 1,682.10 12,962.49 50.63 12,637.51
<br />222-4-5300-9259 Other Merchandise For Resale 14,000.00 1,032.20 8,413.82 60.10 5,586.18
<br />TOTAL Supplies 45,100.00 2,714.30 23,206.12 51.45 21,893.88
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 3,100.00 212.70 1,127.53 36.37 1,972.47
<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 333.30 648.30 64.83 351.70
<br />222-4-5300-9361 Insurance 11,850.00 0.00 5,162.00 93.56 6,688.00
<br />222-9-5300-4389 Utilities 7,150.00 683.86 1,844.18 25.79 5,305.82
<br />222-4-5300-4401 Bldq Repair/Maint Services 1,000.00 20.04 440.29 44.02 559.76
<br />222-4-5300-4909 Equip Repair/Maint Services 2,500.00 115.20 1,312.92 52.52 1,187.08
<br />222-4-5300-4915 Equipment Rental 2,000.00 42.29 712.87 35.64 1,267.13
<br />222-4-5300-4437 Taxes & Licenses 850.00 ( 1,992.30)( 2,879.70) 338.79- 3,729.70
<br />222-4-5300-4438 Credit Card Fees 4,500.00 814.68 2,692.04 59.82 1,807.96
<br />TOTAL Other Services & Charges 34,450.00 279.77 11,188.34 32.48 23,261.66
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500.00 1,416.00 5,664.00 66.64 2,836.00
<br />TOTAL Debt S ervice 8,500.00 1,416.00 5,664.00 66.64 2,836.00
<br />I TOTAL Golf Course 238,450.00 22,874.20 124,832.39 52.35 113,617.61
<br />I TOTAL Culture & Recreation
<br />TOTAL EXPENDITURES
<br />238,450.00 22,879.20 124,832.39 52.35 113,617.61
<br />238,450.00 22,874.20 124,832.39 52.35 113,617.61
<br />REVENUES OVER/(UNDER) EXPENDITURES 0.00 5,774.18 5,841.12 ( 5,841.12)
<br />
|