|
8-12-2009 03:25 PM CITY OF ELK RIVER - PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: JULY 31ST, 2009
<br />222-PINEWOOD GOLF COURSE
<br />DEPARTMENTAL EXPENDITURES
<br />CURRENT CURRENT
<br />BUDGET PERIOD
<br />58.33 OF YEAR COMP.
<br />YEAR TO DATE ~ OF BUDGET
<br />ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 89,300.00 7,498.11 50,927.33 57.03 38,372. 67
<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 7,680.61 18,309.76 63.91 10,340. 24
<br />222-4-5300-4104 PERA 8,100.00 653.19 4,049.89 50.00 4,050. 11
<br />222-4-5300-4105 FICA 7,450.00 925.46 4,414.16 59.25 3,035. 84
<br />222-4-5300-4107 Medicare 1,750.00 216.44 1,032.37 58.99 717. 63
<br />222-4-5300-4108 Insurance 9,200.00 876.00 5,842.00 63.50 3,358. 00
<br />222-4-5300-4109 Workers Comp 1,050.00 0.00 882.00 84.00 168. 00
<br />TOTAL Personal Services 145,600.00 17,849.81 85,626.89 58.81 59,973. 11
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000.00 731.30 1,983.54 39.67 3,016. 46
<br />222-4-5300-4217 Uniform Allowance 500.00 0.00 353.63 70.73 146. 37
<br />222-4-5300-4219 Operating Supplies 25,100.00 3,697.76 10,973.70 43.72 14,126 .30
<br />222-4-5300-4259 Other Merchandise For Resale 10,800.00 2,494.25 9,932.49 91.97 867 .51
<br />TOTAL Supplies 41,400.00 6,923.31 23,243.36 56.14 18,156 .64
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500.00 223.86 1,107.81 44.31 1,392 .19
<br />222-4-5300-4331 Travel, Conferences & Schools 400.00 0.00 381.60 95.40 18 .40
<br />222-4-5300-4349 Advertising/Marketing 1,500.00 0.00 159.75 10.65 1,340 .25
<br />222-4-5300-4361 Insurance 11,550.00 0.00 5,146.50 44.56 6,403 .50
<br />222-4-5300-4389 Utilities 6,800.00 875.84 2,630.76 38.69 4,169 .24
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,000.00 244.42 344.27 17.21 1,655 .73
<br />222-4-5300-4404 Equip Repair/Maint Services 2,500.00 136.00 1,090.45 43.62 1,409 .55
<br />222-4-5300-4415 Equipment Rental 36,050.00 332.26 1,014.88 2.82 35,035 .12
<br />222-4-5300-4437 Taxes & Licenses 1,000.00 ( 2,262.32)( 3,211.29) 321.13- 4,211 .29
<br />222-4-5300-4438 Credit Card Fees 3,500.00 882.37 2,697.37 77.07 802 .63
<br />TOTAL Other Services & Charges 67,800.00 432.43 11,362.10 16.76 56,437 .90
<br />Debt Service
<br />222-4-5300-4601 Principal 0.00 1,416.00 33,217.48 0.00 ( 33,217 .48)
<br />TOTAL Debt S ervice 0.00 1,416.00 33,217.48 0.00 ( 33,217 .48)
<br />TOTAL Golf Course 254,800.00 26,621.55 153,449.83 60.22 101,350.17
<br />TOTAL Culture & Recreation
<br />254,800.00 26,621.55 153,449.83 60.22 101,350.17
<br />TOTAL EXPENDITURES 254,800.00 26,621.55 153,449.83 60.22 101,350.17
<br />REVENUES OVER/(UNDER) EXPENDITURES 0.00 7,772.85 ( 10,004.17) 10,004.17
<br />
|