5-14-2009 08:29 AM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: APRIL 30TH, 2009
<br />^ 222-PINEWOOD GOLF COURSE
<br />^ DEPARTMENTAL EXPENDITURES
<br />Golf Course
<br />Personal Services
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />33.33% OF YEAR COMP.
<br />YEAR TO DATE $ OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />222-4-5300-4101 Regular Pay 89,300.00 7,358.24 25,250.95 28.28 64,049.05
<br />222-4-5300-4102 Overtime Pay 100.00 0.00 169.38 169.38 ( 69.38)
<br />222-4-5300-9103 Part-time Pay 28,650.00 202.50 202.50 0.71 28,947.50
<br />222-4-5300-9104 PERA 8,100.00 496.68 1,900.12 23.46 6,199.88
<br />222-4-5300-9105 FICA 7,450.00 453.14 1,746.46 23.44 5,703.54
<br />222-4-5300-9107 Medicare 1,750.00 105.98 408.47 23.34 1,341.53
<br />222-4-5300-4108 Insurance 9,200.00 876.00 3,214.00 34.93 5,986.00
<br />222-4-5300-4109 Workers Comp 1,050.00 0.00 588.00 56.00 962.00
<br />TOTAL Person al Services 145,600.00 9,492.54 33,479.88 22.99 112,120.12
<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 328.93 328.93 65.79 171.07
<br />222-9-5300-4219 Operating Supplies 25,100.00 1,407.53 2,563.12 10.21 22,536.88
<br />222-4-5300-4259 Other Merchandise For Resale 10,800.00 1,267.13 1,341.32 12.42 9,458.68
<br />TOTAL Suppli es 41,400.00 3,003.59 4,233.37 10.23 37,166.63
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 259.86 438.10 17.52 2,061.90
<br />222-4-5300-4331 Travel, Conferences & Schools 400.00 71.12 326.33 81.58 73.67
<br />222-4-5300-4349 Advertising/Marketing 1,500.00 150.00 150.00 10.00 1,350.00
<br />222-4-5300-4361 Insurance 11,550.00 0.00 5,146.50 44.56 6,403.50
<br />222-4-5300-9389 Utilities 6,800.00 275.55 914.86 13.45 5,885.14
<br />222-4-5300-9401 Bldg Repair/Maint Services 2,000.00 19.97 59.91 3.00 1,940.09
<br />222-4-5300-4409 Equip Repair/Maint Services 2,500.00 0.00 828.05 33.12 1,671.95
<br />222-4-5300-9415 Equipment Rental 36,050.00 0.00 0.00 0.00 36,050.00
<br />222-4-5300-4937 Taxes & Licenses 1,000.00 ( 1,509.13)( 1,198.83) 119.88- 2,198.83
<br />222-4-5300-4438 Credit Card Fees 3,500.00 167.24 176.18 5.03 3,323.82
<br />TOTAL Other Services & Charges 67,800.00 ( 565.39) 6,841.10 10.09 60,958.90
<br />Debt Service
<br />222-4-5300-9601 Principal 0.00 1,416.00 1,416.00 0.00 ( 1,416.00)
<br />TOTAL Debt S ervice 0.00 1,416.00 1,416.00 0.00 ( 1,416.00)
<br />TOTAL Golf Course 254,800.00 13,346.79 45,970.35 18.04 208,829.65
<br />TOTAL Culture & Recreation
<br />254,800.00 13,346.74 45,970.35 18.04 208,829.65
<br />^ TOTAL EXPENDITURES
<br />REVENUES OVER/(UNDER) EXPENDITURES
<br />254,800.00
<br />------------ - 13,346.74
<br />------------ - 45,970.35 18.04
<br />------------ ------- - 208,829.65
<br />------------
<br />0.00 20,783.29 ( 7,959.37) 7,959.37
<br />
|