|
12-16-2009 10:25 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: NOVEMBER 30TH, 2009
<br />~ 222-PINEWOOD GOLF COURSE
<br />' DEPARTMENTAL EXPENDITURES
<br />91.67°s OF YEAR COMP.
<br />CURRENT CURRENT YEAR TO DATE $ OF BUDGET
<br />BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />1 Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 89,300.00 6,953.33 84,387.49 94.50 4,912.51
<br />222-4-5300-4102 Overtime Pay 100.00 0.00 169.38 169.38 ( 69.38)
<br />222-4-5300-4103 Part-time Pay 28,650.00 0.00 34,927.20 121.91 ( 6,277.20)
<br />222-4-5300-4104 PERA 8,100.00 469.36 7,003.99 86.47 1,096.01
<br />222-4-5300-4105 FICA 7,450.00 416.27 7,480.67 100.41 ( 30.67)
<br />222-4-5300-4107 Medicare 1,750.00 97.35 1,749.53 99.97 0.47
<br />222-4-5300-4108 Insurance 9,200.00 876.00 9,346.00 101.59 ( 146.00)
<br />222-4-5300-4109 Workers Comp 1,050.00 0.00 1,193.25 113.64 ( 143.25)
<br />222-4-5300-4110 Re-employment Compensation 0.00 ( 640.81)( 640.81) 0.00 640.81
<br />TOTAL Personal Services 145,600.00 8,171.50 145,616.70 100.01 ( 16.70)
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 2,462.24 49.24 2,537.76
<br />222-4-5300-4217 Uniform Allowance 500.00 42.50 463.89 92.78 36.11
<br />222-4-5300-4219 Operating Supplies 25,100.00 760.42 22,057.31 87.88 3,042.69
<br />222-4-5300-4259 Other Merchandise For Resale 10,800.00 ( 112.45) 13,566.62 125.62 ( 2,766.62)
<br />TOTAL Supplies 41,400.00 690.47 38,550.06 93.12 2,849.94
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 221.71 1,952.03 78.08 597.97
<br />222-4-5300-4331 Travel, Conferences & Schools 400.00 0.00 426.56 106.64 ( 26.56)
<br />222-4-5300-4349 Advertising/Marketing 1,500.00 737.00 1,339.75 89.32 160.25
<br />222-4-5300-4361 Insurance 11,550.00 0.00 11,054.50 95.71 495.50
<br />222-4-5300-4389 Utilities 6,800.00 717.75 6,319.02 92.93 480.98
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 20.04 804.43 40.22 1,195.57
<br />222-4-5300-4404 Equip Repair/Maint Services 2,500.00 2.40 2,026.25 81.05 473.75
<br />222-4-5300-4415 Equipment Rental 0.00 42.28 1,764.00 0.00 ( 1,764.00;
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 37.78 619.83 61.98 380.17
<br />222-4-5300-4438 Credit Card Fees 3,500.00 127.31 4,847.54 138.50 ( 1,347.54;
<br />TOTAL Other Services & Charges 31,750.00 1,906.27 31,153.91 98.12 596.09
<br />Debt Service
<br />222-4-5300-4601 Principal 36,050.00 0.00 36,049.48 100.00 0.52
<br />TOTAL Debt Service 36,050.00 0.00 36,049.48 100.00 0.52
<br />TOTAL Golf Course 254,800.00 10,768.24 251,370.15 98.65 3,429.85
<br />TOTAL Culture & Recreation 254,800.00 10,768.24 251,370.15 98.65 3,429.85
<br />~ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />254,800.00 10,768.24 251,370.15 98.65 3,429.85
<br />0.00 ( 8,951.95)( 49,483.31) 49,483.31
<br />
|